mercredi 19 août 2015

What ORM is better to use for complicated queries in IOS(sqlite)?

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