Man, developing a web app where different parts of it, only work when a specific application gate is open, is difficult. I pray for the QA team because I know it can be rough.

I did have an idea for an app that would serve as a database proxy, where it could make an in-memory clone of given tables. This benefit of this would be the avoidance of someone changing the gates on you. This is still in-progress, but is proving to be more challenging than I thought.

I don’t think this app is as much of an accomplishment, but it definitely has great utility. Trying to ensure one gate open ad closed before another is way too tedious. With gate-keeper, you just choose the year of the gates to set, choose your gate of interest, then chooose where you want be relative to it, then click ‘Set ates’.

gate-keeper

Description

This a very simple program I wrote to automate a common task at work–opening and closing application gates to mimic an application cycle flow. I tried writing this generically, so that some user with a different database schema can find this helpful. Specifying this schema is done in a config.json.

To help you visualize what this program does. see the below timeline:

       aaaaa       bbbbb       ccccc       ddddd       eeeee     
------------------------------------------------------------------------

This represents an application cycle, as you can see, the cycle has periods a through e.

This program will configure the gates for a given year such that you will be virtually teleported.

Lets say, given the database of the above system, and as program inputs I provided: year 2025, at gate c, place me before it

These inputs, will update the start datetime and end datetime of the application gates so that you are placed on the timeline as shown below. (indicated by me)

       aaaaa       bbbbb  me   ccccc       ddddd       eeeee     
------------------------------------------------------------------------

In other words, the open and close dates of the gates are configured so that the current moment is before the opening of gate c.

For the third input, other options are after and inside, which wouls appear as:

inside:

                                me
       aaaaa       bbbbb       ccccc       ddddd       eeeee     
------------------------------------------------------------------------

after

       aaaaa       bbbbb       ccccc   me  ddddd       eeeee     
------------------------------------------------------------------------