Skip to content

Instantly share code, notes, and snippets.

@bkuhns
Created February 18, 2013 02:53
Show Gist options
  • Save bkuhns/4974866 to your computer and use it in GitHub Desktop.
Save bkuhns/4974866 to your computer and use it in GitHub Desktop.
class Course : public Model {
[...]
public:
Field<std::string> name;
Field<long> weeks;
public:
Relation<Course, HasOne, Professor> professor;
};
int main() {
Course course;
course.where(course.professor->name == "Carvalho" && (course.weeks == 2 || course.weeks == 3));
return 0;
}
/*
SELECT * FROM `Course` WHERE (`Professor.name` = 'Carvalho') AND ((`Course.weeks` = 2) OR (`Course.weeks` = 3)) LEFT JOIN Professor ON `Course.Professor_id` = `Professor.id`
*/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment