Friendpaste

--- Revision None
+++ Revision 363133363464
@@ -0,0 +1,21 @@
+Midgard.QueryStorage storage = new Midgard.QueryStorage ("midgard_page");
+Midgard.QuerySelect select = new Midgard.QuerySelect (cnc, storage);
+
+Midgard.QueryProperty prop1 = new Midgard.QueryProperty ("metadata.created", null);
+Midgard.QueryValue val1 = new Midgard.QueryValue ("2000-01-01 10:10:10");
+Midgard.QueryConstraint cnstr1 = new Midgard.QueryConstraint (prop1, ">", val1, null);
+
+Midgard.QueryProperty prop2 = new Midgard.QueryProperty ("name", null);
+Midgard.QueryValue val2 = new Midgard.QueryValue ("");
+Midgard.QueryConstraint cnstr2 = new Midgard.QueryConstraint (prop2, "<>", val2, null);
+
+Midgard.QueryGroupConstraint group_constraint = new Midgard.QueryGroupConstraint ("AND", cnstr1, cnstr2);
+
+elect.set_constraint (group_constraint);
+select.set_limit (1);
+select.execute();
+
+Executed query so far:
+
+SELECT page.guid AS guid, page.id AS id, page.name AS name, page.info AS info, page.style AS style, page.up AS up, page.component AS component, page.title AS title, page.content AS content, page.metadata_creator AS creator, page.metadata_created AS created, page.metadata_revisor AS revisor, page.metadata_revised AS revised, page.metadata_revision AS revision, page.metadata_locker AS locker, page.metadata_locked AS locked, page.metadata_approver AS approver, page.metadata_approved AS approved, page.metadata_authors AS authors, page.metadata_owner AS owner, page.metadata_schedule_start AS schedulestart, page.metadata_schedule_end AS scheduleend, page.metadata_hidden AS hidden, page.metadata_nav_noentry AS navnoentry, page.metadata_size AS size, page.metadata_published AS published, page.metadata_score AS score, page.metadata_imported AS imported, page.metadata_exported AS exported, page.metadata_deleted AS deleted, page.metadata_isapproved AS isapproved, page.metadata_islocked AS islocked FROM `page` WHERE metadata_deleted = 0
+
a	b
	0	+	Midgard.QueryStorage storage = new Midgard.QueryStorage ("midgard_page");
	0	+	Midgard.QuerySelect select = new Midgard.QuerySelect (cnc, storage);
	0	+
	0	+	Midgard.QueryProperty prop1 = new Midgard.QueryProperty ("metadata.created", null);
	0	+	Midgard.QueryValue val1 = new Midgard.QueryValue ("2000-01-01 10:10:10");
	0	+	Midgard.QueryConstraint cnstr1 = new Midgard.QueryConstraint (prop1, ">", val1, null);
	0	+
	0	+	Midgard.QueryProperty prop2 = new Midgard.QueryProperty ("name", null);
	0	+	Midgard.QueryValue val2 = new Midgard.QueryValue ("");
	0	+	Midgard.QueryConstraint cnstr2 = new Midgard.QueryConstraint (prop2, "<>", val2, null);
	0	+
	0	+	Midgard.QueryGroupConstraint group_constraint = new Midgard.QueryGroupConstraint ("AND", cnstr1, cnstr2);
	0	+
	0	+	elect.set_constraint (group_constraint);
	0	+	select.set_limit (1);
	0	+	select.execute();
	0	+
	0	+	Executed query so far:
	0	+
	0	+	SELECT page.guid AS guid, page.id AS id, page.name AS name, page.info AS info, page.style AS style, page.up AS up, page.component AS component, page.title AS title, page.content AS content, page.metadata_creator AS creator, page.metadata_created AS created, page.metadata_revisor AS revisor, page.metadata_revised AS revised, page.metadata_revision AS revision, page.metadata_locker AS locker, page.metadata_locked AS locked, page.metadata_approver AS approver, page.metadata_approved AS approved, page.metadata_authors AS authors, page.metadata_owner AS owner, page.metadata_schedule_start AS schedulestart, page.metadata_schedule_end AS scheduleend, page.metadata_hidden AS hidden, page.metadata_nav_noentry AS navnoentry, page.metadata_size AS size, page.metadata_published AS published, page.metadata_score AS score, page.metadata_imported AS imported, page.metadata_exported AS exported, page.metadata_deleted AS deleted, page.metadata_isapproved AS isapproved, page.metadata_islocked AS islocked FROM `page` WHERE metadata_deleted = 0
	0	+
...