Generating Source Code for Creating Database Triggers

A computing device comprising:

• a communications interface circuit configured to communicate data via a computer network with one or more devices;
• and
• a processing circuit operatively connected to the communications interface circuit and configured to:
• extract a plurality of tokens, based on a lexical analysis, from an input command associated with creating a plurality of database triggers that verify the integrity of data stored across a plurality of database tables in a database;
• verify the order of the plurality of tokens based on a syntactic analysis of the plurality of tokens;
• and
• if the order of the plurality of tokens is verified:
• verify the ordered plurality of tokens against a set of predetermined policies based on a semantic analysis of the plurality of tokens;
• and
• if the ordered plurality of tokens is verified:
• generate an indirect table path linking first and second database tables through an intermediary database table based on the ordered plurality of tokens, wherein the indirect table path comprises ordered foreign keys that link the first and second database tables to the intermediary database table;
• and
• generate source code for creating the plurality of database triggers based on the ordered plurality of tokens and on the indirect table path.

A non-transitory computer-readable storage medium comprising computer code stored thereon, wherein, when executed by a processing circuit of a computer, causes the computer to:

• obtain information associated with creating a plurality of database triggers, wherein the plurality of database triggers verify the integrity of data stored across a plurality of database tables in a database, the information comprising:
• a Boolean expression identifying one or more verification checks to be applied to the data stored in the plurality of database tables;
• and
• metadata associated with a structure of the database;
• verify one or both of the Boolean expression and the metadata against a set of predetermined policies;
• and
• if the one or both of the Boolean expression and the metadata are verified:
• generate an indirect table path linking first and second database tables through an intermediary database table based on the metadata, wherein the indirect table path comprises ordered foreign keys that link the first and second database tables to the intermediary database table;
• and
• generate source code for creating the plurality of database triggers based on the Boolean expression, the metadata, and the indirect table path.