------
Here i first auto generated the classes for Simplified Parking hero Project..
For doing this we cal follow different steps :
1) Create Java Project ,within that create lib folder in that download and copy jar files of :
http://www.mediafire.com/?f4dlaeuib3cf1e4
http://www.mediafire.com/?t5lxdeg0l3cgtim
add those into Project properties,then errors will disappear..
2)after doing that write code for generating cls classes for creating Database ..
package de.greenrobot.daogenerator.gentest;
import de.greenrobot.daogenerator.DaoGenerator;
import de.greenrobot.daogenerator.Entity;
import de.greenrobot.daogenerator.Property;
import de.greenrobot.daogenerator.Schema;
import de.greenrobot.daogenerator.ToMany;
/**
* Generates entities and DAOs for the example project DaoExample.
*
* Run it as a Java application (not Android).
*
* @author Markus
*/
public class ExampleDaoGenerator {
public static void main(String[] args) throws Exception {
Schema schema = new Schema(3, "de.greenrobot.daoexample");
/**
* Here in this below code we Establish a ForignKey realtionShip between
* -> Ticket and Evidence Table...
* -> Vehicle and VehicleImage Table(For Vehicle Images will be added to particular vehicle..)
* -> Vehicle and Tickets Table(for display all Vehicles related to the given Ticket..) *
*/
//simplified parkinghero tables...
//Ticket table..
Entity ticket = schema.addEntity("clsTicket");
ticket.setTableName("tblTickets");
ticket.addIdProperty().index(); ////like TicketId (or) Ticket SLNO
ticket.addIntProperty("TicketID");
ticket.addIntProperty("ViolationCode");
ticket.addIntProperty("StatusID");
ticket.addFloatProperty("NycFineAmount");
ticket.addStringProperty("ViolationDescription");
ticket.addStringProperty("TicketNumber");
ticket.addStringProperty("DateOfOffence");
ticket.addStringProperty("TimeOfOffence");
ticket.addStringProperty("PlaceOfOffence");
ticket.addStringProperty("Status");
ticket.addDateProperty("TicketAddedTimeStamp");
ticket.addDateProperty("TicketUpdatedTimeStamp");
ticket.addBooleanProperty("IsAutoScanned");
//Evidence table..
Entity evidence = schema.addEntity("clsEvidence");
evidence.setTableName("tblEvidences");
evidence.addIdProperty().index();
evidence.addIntProperty("EvidenceID").index();
evidence.addIntProperty("EvidenceTicketID");
//forign key for TicketSLNO...
Property TicketSLNO = evidence.addLongProperty("TicketSLNO").notNull().getProperty();
ToMany ticketsToEvidence = ticket.addToMany(evidence, TicketSLNO);
ticketsToEvidence.setName("Ticketevidences");
evidence.addIntProperty("UserID");
evidence.addIntProperty("EvidenceSLNo"); // only for mobiles
evidence.addBooleanProperty("IsReviewerNotes");
evidence.addStringProperty("EvidenceImageName");
evidence.addStringProperty("EvidenceImagePath");
evidence.addStringProperty("EvidenceNote");
evidence.addDateProperty("EvidenceAddedTimeStamp");
evidence.addBooleanProperty("IsEvidenceImageUploadPending");
evidence.addBooleanProperty("IsEvidenceImageDownloadPending");
///Vehicle table
Entity vehicle = schema.addEntity("clsVehicle");
vehicle.setTableName("tblVehicles");
vehicle.addIdProperty().index(); ////like VehicleId ,its aforiegn key relation..
vehicle.addIntProperty("UserID");
vehicle.addStringProperty("RegisteredOwner");
vehicle.addStringProperty("Make");
vehicle.addStringProperty("VehicleRegistrationImageName");
vehicle.addBooleanProperty("IsVehicleRegistrationDownloadPending");// ONLY FOR MOBILE
vehicle.addBooleanProperty("IsVehicleRegistrationUploadPending");//ONLY FOR MOBILE
vehicle.addStringProperty("VehicleTempRegistrationImageName");
vehicle.addBooleanProperty("IsVehicleTempRegistrationDownloadPending");
vehicle.addBooleanProperty("IsVehicleTempRegistrationUploadPending");
vehicle.addStringProperty("Model");
vehicle.addStringProperty("Color");
vehicle.addStringProperty("BodyType");
vehicle.addStringProperty("PlateType");
vehicle.addStringProperty("PlateNumber");
vehicle.addStringProperty("State");
vehicle.addStringProperty("VinNumber").index();
vehicle.addIntProperty("YearOfRegistration").index();
vehicle.addIntProperty("ManufacturingYear").index();
vehicle.addDateProperty("ExpirationDate");
vehicle.addBooleanProperty("IsEntryRequired");
vehicle.addBooleanProperty("IsRegistrationInfoAvailable");
vehicle.addDateProperty("VehicleDateAddedTimeStamp").index();
vehicle.addDateProperty("VehicleLastUpdatedTimeStamp").index();
vehicle.addBooleanProperty("IsVehicleDeleted");
//Vehicle Image table........
Entity vehicleImage = schema.addEntity("clsVehicleImage");
vehicleImage.setTableName("tblVehicleImages");
vehicleImage.addIdProperty().index();
//forign key ...
Property VehicleID = vehicleImage.addLongProperty("VehicleID").notNull().getProperty();
ToMany vehicleToVehiclImage= vehicle.addToMany(vehicleImage, VehicleID);
vehicleToVehiclImage.setName("vehicleImages");
vehicleImage.addIntProperty("UserID");
vehicleImage.addBooleanProperty("IsDeleted").index();
vehicleImage.addBooleanProperty("IsImageUploadPending");
vehicleImage.addBooleanProperty("IsImageDownloadPending").index();
vehicleImage.addStringProperty("Note");
vehicleImage.addStringProperty("VehicleImageName");
vehicleImage.addStringProperty("VehicleImagePath");
vehicleImage.addDateProperty("DataAddedTimeStamp").index();
///User table....
Entity user = schema.addEntity("clsUser");
user.setTableName("tblUser");
user.addIntProperty("UserID").index();
user.addStringProperty("CompanyName");
user.addStringProperty("UserName"); // chandrakanth
user.addStringProperty("EmailAddress");
user.addStringProperty("Password");
user.addStringProperty("PhoneNumber");
user.addDateProperty("UserAddedTimeStamp");
user.addDateProperty("UserUpdatedTimeStamp").index();
///The End
new DaoGenerator().generateAll(schema, "../DaoExampleGenerator/src-gen");
}
}
After running this code u will get generated cls classes , in src-gen folder and those classes will showed after ur refreshing the project..
3) after completion of that ,create Android project and copy all the data exists in src-gen folder into ur Android Project..
After that use Jar file in assets folder for clearing the errors:
http://www.mediafire.com/?zc8p868bx824w1z
4) After doing all Use this statement to create GreenDao Database in Android:
//It will create DataBase
public void createDataBase(){
SharedVariables.parking_hero_database_helper_obj = new DaoMaster.DevOpenHelper(SharedVariables.globalContext, SharedVariables.globalContext.getString(R.string.DataBase_Name), null);
SharedVariables.parking_hero_db= SharedVariables.parking_hero_database_helper_obj.getWritableDatabase();
DaoMaster daoMaster = new DaoMaster(SharedVariables.parking_hero_db);
DaoSession daoSession = daoMaster.newSession();
daoSession.clear();
//parking_hero_db.close();
//parking_hero_database_helper_obj.close();
}
For deleting the database use :
public void deleteDatabase()
{
Log.d("DLLOginscreenOperations","dl remove table called");
// DevOpenHelper ParkingHero_database_helper_obj = new DaoMaster.DevOpenHelper(SharedVariables.globalContext,SharedVariables.globalContext.getString(R.string.DataBase_Name), null);
//SQLiteDatabase ParkingHero_DB=ParkingHero_database_helper_obj.getWritableDatabase();
try{
DaoMaster.dropAllTables(SharedVariables.parking_hero_db, true);
}catch (Exception e) {
e.printStackTrace();
// TODO: handle exception
}
DaoMaster.createAllTables(SharedVariables.parking_hero_db, true);
// ParkingHero_DB.close();
// ParkingHero_database_helper_obj.close();
}
Comments
Post a Comment