|
Project Information
Members
Featured
Downloads
Wiki pages
Links
|
Version 1.2 RELEASED!
Version 1.3 ALMOST HERE!Delayed until the release of NINJA-IDE Version 1.0 Working with Databases has never been Easier! QuickDB aims to develop a persistence library that allow the user to write only the Data Model, and the library will manage all the operations between the Entities and the Database, without writing any line of code for Connection, Sql, etc. Where each operation involves only what you wanna do (save, modify, ...) and to what are you going to apply it (the object)
(Working in a Python, .NET, PHP and Mobile{J2ME, .NET CF} Version)
Why QuickDB? Functionality is not synonymous with Complexity.
Capabilities
This capabilities can be combined with Inheritance, Compound Objects, Collections (Many to Many Relation, One to Many Relation) and Automatic Table Creation.
Keep It Simple...Example Classes:
//Create instance of AdminBase
//Parameters: DBMS, HOST, PORT, DB, USER, PASSWORD
AdminBase admin = new AdminBase(AdminBase.DATABASE.MYSQL, "localhost",
"3306", "exampleQuickDB", "root", "");
//Create Address Object
Address a = new Address();
a.setNumber(123);
a.setStreet("unnamed street");
//Create Collection of Phones
Phone p1 = new Phone();
p1.setAreaCode("351");
p1.setNumber("123456");
Phone p2 = new Phone();
p2.setAreaCode("351");
p2.setNumber("4567890");
ArrayList<Phone> phones = new ArrayList<Phone>();
phones.add(p1);
phones.add(p2);
//Create Employe Object
Employee e = new Employee();
e.setCode(555);
e.setRolDescription("play ping pong");
e.setName("Diego Sarmentero");
e.setBirth(new java.sql.Date(100, 4, 20));
e.setAddress(a);
e.setPhone(phones);Operation: Saveadmin.save(e); //Save Employe Result: Save (Tables)Create the Tables automatically Address
Phone
Person
PersonPhonePhone
Employee
Operation: ObtainGet the Employee object where the inherited attribute "address" has as street value = 'unnamed street' admin.obtain(e, "address.street = 'unnamed street'"); Or admin.obtain(e).If("street", Address.class).equal("unnamed street").find();Operation: ModifyChange Employee name and add a new Phone (after obtain the object). e.setName("Leonardo");
Phone p = new Phone();
p.setAreaCode("123");
p.setNumber("98765");
e.getPhone().add(p);
admin.modify(e);Operation: DeleteDelete this Employee object (after obtain). admin.delete(e);
Is it really so Simple??:
To participate or request features please contact: quickdb@googlegroups.com
|