node-persist | js ORM framework supporting MySQL and SQLite 3 relational | SQL Database library

The environment to read from the database.json file. If not set will use the value of default from the database.json. Connects to a database. Defines a model object for use in persist. The primary key column does not need to be specified and will default to the name 'id' with the attributes dbColumnName='id', type='integer'. You can override the database name using dbColumnName or setting the primaryKey attribute on any column. A model class. Events can also be registered with model instances - see Model Events. Defines a model object for use in persist. Columns are defined by the program in this method. Uses an existing database connection to retrieve column data. A model class. Events can also be registered with model instances - see Model Events. Sets the default connection options to be used on future connect calls. see database.json. Shutdown persist. This is currently only required if you are using connection pooling. see generic-pool. Chains multiple statements together in order and gets the results. Begins a transaction on the connection. Runs a sql statement that does not return results (INSERT, UPDATE, etc). Runs a sql statement that returns results (ie SELECT). Runs a sql statement that returns results (ie SELECT). This is different from runSqlAll in that it returns each row in a seperate callback. Same as runSql, runSqlAll, runSqlEach except the first parameter is a filename of where to load the SQL from. Adds a has many relationship to a model. This will automatically add a property to the associated model which links to this model. It will also define a property on instances of this model to get the releated objects - see Associated Object Properties. The model class object suitable for chaining. Adds a has one relationship to a model. This will automatically add a property to the associated model which links to this model. It will also define a property on instances of this model to get the releated objects - see Associated Object Properties. The model class object suitable for chaining. Gets a query object bound to a connection object. A new Query object. Saves the model object to the database. Updates the model object to the database. Updates the model object specified with id to the database. This will only update the values specified and will not retreive the item from the database first. Deletes the model object from the database. Gets an object from the database by id. Creates a custom method that is a composition of clauses. this is set to refer to the query. you're constructing. If preset this function will be called when an update or save occures. You would typically create this method in your model file. If preset this function will be called after an object is loaded from the database. You would typically create this method in your model file. Model validation is loosely implemented. Instead, it's left to the developers to integrate any valiation library that fits their needs. If present this function will be called during a save or update operation. If you have setup an associated property using hasMany instances of your model will have an additional property which allows you to get the associated data. This property returns a Query object which you can further chain to limit the results.