The basic-sproc-crud-scaffolder is a command line code generator and the perfect accompaniment to Zalando's Java Sproc Wrapper. Its goal is to make interacting with your Postgres database as quick and easy as possible.
Installation is very straightforward. Simply clone the repository directly from GitHub to a directory of your choice:
$ git clone git://github.com/zalando/basic-sproc-crud-scaffolder.gitTo get a quick, "Hello World" type view of what the script can do for you, simply run:
$ ./run.pyShow the command line options available:
$ ./run.py -hAnd run against a table:
$ ./run.py --host= --port=5432 --database= --user= --table= --schema=The script will create a directory called /output that contains a database and src subdirecty. The former contains a database type and all sprocs that match the table you ran the script against while the latter contains the Java domain type and persistence layer that is setup to run with Zalando's Java Sproc Wrapper.