ANDY - SQLite to JAVA ORM Mapping library for Android developers

Special thanks goes to my group members, Achithra, Muditha and Deshapriya for their great contribution to success this project.
-----------------------------------------------------------------------------------------------------------

Android  is  a  complete  operating  environment  based  upon  the  Linux  kernel.  Initially,  the  deployment  target  for Android was the mobile-phone arena, including smart phones and  tablet  devices.  For developers, Android SDK provides a rich set of tools, including debugger, libraries, handset emulator, documentation, sample code, and tutorials. Android applications can be easily developed using Eclipse (Android's official development platform) with the help of a plug-in called Android Development Tools (ADT).

Android uses the open source database engine, SQLite. It is a small, server-less library and has features that are pretty attractive in the mobile environment. Data stored in SQLite databases is persistent across processes, powercycling, and, usually, across upgrades and re-installs of the system software.

Android developers should model their SQLite databases using manually written java codes that containing SQL statements and have to write ORM classes manually to integrate their database tables with entity classes. Also they should have to write their own methods and classes to database transactions. In some cases developers require to modify their database structures with their new versions of applications. In those cases they have to write their  own codes to migrate existing data in to new database.

At last ANDY ended up as a solution for Android Database Developers who is using Eclipse IDE for their developments.

Minimum system Requirements

• Eclipse Helios or higher.
• ADT plugin
• Writable workspace

Note: There are no any minimal hardware or software platform restrictions for ANDY. But the actual system requirements may depend on system requirements of Eclipse IDE and ADT Plugin.

Andy Update site: http://cyberdyne.comeze.com/downloads/

Download ANDY sample project and try..

Also you can download and integrate ANDY manually Click Here to download

How to use ANDY

After creating the Android project, user can develop DB model for the project. To create DB model

with ANDY, user can go through the following path.

1. File --> New --> Other
2. From “Select a Wizard” window select, Andy --> Andy Modelling Wizard --> Next
3. Then it will appears “Andy Modeling Wizard” window. You can browse the project by clicking “Browse…” button and it will show the available Android projects in the work place.

You can select the Android project that need to create database and click OK. Thereafter you can gives a package name and file name for xml file. But wizard will not allow you to change the extension or package name with unusual marks.
After finish the Andy modelling wizard it will be generated the xml file and the andy.properties file. Xml file use for save the table and table column and andy.properties file use for save the basic settings of relevant android project. User can also change the xml file to create tables and table columns, but we highly recommend you to use “Andy modelling view” to create tables and the table columns.

To go “Andy modelling view”, follow the following path.

1. Window --> Show view --> other

2. From “Show view window” select, Andy --> Andy modelling view --> OK

Then you will enter to the ANDY modelling view. Select ANDY integrated project form list by clicking

“Browse”, the xml file will be loaded to the modelling view.

From tree view in the modeling view you can add or remove table and table columns can be added, deleted or discarded according to situation corresponding to the table form the table view.

After creating all the tables and table columns, you can generate the POJO classes, DB helper class, DB handler class by clicking the “Generate classes from database model” in Icon bar or you can access by, Andy --> Generate classes

Classes will be generated into package that you entered at “Andy modelling wizard”

You can clear all generated classes by clicking “clear classes from database model” in icon bar or can

be accessed by, Andy --> Clear classes from database model. Moreover you can remove ANDY integration from the project by clicking “remove ANDY integration from project” icon in icon bar or Andy --> remove ANDY integration from project. You will see all thegenerated classes has been cleared in package.

Here is the complete video guide to install and use ANDY