Search Results for "sqlite query builder"

...To finish using the SQLBuilder class you can have your query written to be used directly with the SQLite JDBC Driver to have the best performance without unnecessary frills.

SQLite is an awesome embedded relational database. Still, writing SQL and parsing query results are quite tedious and time-consuming tasks. greenDAO frees you from these by mapping Java objects to database tables (called ORM, “object/relational mapping”). This way you can store, update, delete, and query for Java objects using a simple object oriented API.

Now stored at https://github.com/gregorydgraham/DBvolution Available from Maven Central: nz.co.gregs.dbvolution Makes relational data easy and fast to use with semantic annotations and encapsulated datatypes. Simple declaration of a DB table: @DBTableName("mytable") public class MyTable extends DBRow { @DBColumn("numeric_code") @DBForeignKey(Code.class) private DBNumber numericCode = new DBNumber(); @DBColumn("uid_mytable") @DBPrimaryKey @DBAutoIncrement private...

MockSqlBuilder uses mock objects and method interception to build SQL queries in an OOP fashion. Instead of strings (like HQL or plain text), MockSqlBuilder uses the data object's and their methods to record and construct a query.