-----------------------------------------------------------------------------------------------------------
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
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.
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