Download the PHP package vonbraunlabs/sql-ddl-generator without Composer
On this page you can find all versions of the php package vonbraunlabs/sql-ddl-generator. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package sql-ddl-generator
SQL To DDL Generator
A tool to aid on generating DDL SQL. It was conceived to abstract away the boring part of writing the SQL tables and let developers/DBAs focus on the business logic. This tool assumes that every table have:
- an integer ID column that uniquely identifies the row and is named ID
- audit columns to specify created time and last updated time
- audit columns to specify the db user who created the row and the one who last updated the row
activecolumn that indicates wether that row is active or should be regarded as deleted/inactive
The file user.json contains the following JSON:
The name of the schema/database is mydatabase. It is creating a table named
user, with four columns: username, email, password and confirmed_at.
Moreover, it declares a foreign key column inviter_id to itself. On its last
part, the snippet declares UNIQUE constraints. The rows must have unique
username and unique email. Executing ./sql-ddl-generator user.json the
following is printed to standard output:
Auditing Special Feature
For some application, it is necessary to keep track of all changes on table,
usually for auditing porposes. The audit flag creates a clone of the table
with the prefix audit_ in its name and store all changes on the clonned table.
If a row is updated N times, there will be N records of that specific row on the
equivalent audit table.
Consider the JSON above. From this model, the sql-ddl-generator will produce SQL below. Mind how tedious it would be to write that that SQL by hand. Now imagine you have many tables that require that auditing feature.
