I use sqlite database in my iphone app. I need ORM to perform complicated sql-queries such as:
String sql1 = "SELECT jobPlan.* " +
" FROM JobPlan AS jobPlan " +
" INNER JOIN JobTechOpPlan AS jobTechOpPlan ON " +
" jobTechOpPlan.id_JobPlan = jobPlan.id AND " +
" jobTechOpPlan.IsVisible AND " +
" jobTechOpPlan.StartingMoment <= ? " +
" LEFT JOIN JobPlanWorker AS jobWorker ON jobPlan.id = jobWorker.id_JobPlan AND jobWorker.id_Worker = " + workerId + " " +
" LEFT JOIN JobPlanBrigade AS jobBrigade ON jobPlan.id = jobBrigade.id_JobPlan AND jobBrigade.id_Brigade IN (" + brigadeIds + ") " +
" LEFT JOIN JobTechOpPlanWorker AS opWorker ON jobTechOpPlan.id = opWorker.id_JobTechOpPlan AND opWorker.id_Worker = " + workerId + " " +
" LEFT JOIN JobTechOpPlanBrigade AS opBrigade ON jobTechOpPlan.id = opBrigade.id_JobTechOpPlan AND opBrigade.id_Brigade IN (" + brigadeIds + ") " +
" WHERE jobPlan.IsVisible AND jobPlan.StartingMoment <= ? AND " +
" (jobWorker.id IS NOT NULL OR jobBrigade.id IS NOT NULL OR opWorker.id IS NOT NULL OR opBrigade.id IS NOT NULL)" +
" GROUP BY jobPlan.id";
My question is what ORM would you suggest for this purpose?
Aucun commentaire:
Enregistrer un commentaire