-- test SQL queries for pilot-qof 0.1.x series

SELECT * from pilot_address where entryState = 'Anyshire' and category = 'Business';
SELECT * from pilot_address where entryCity = 'Sometown';
SELECT * from pilot_address where category = 'Friends' or category = 'Linux';
SELECT * from pilot_expenses where expense_city = 'ANYTOWN';
SELECT * from pilot_expenses where expense_vendor = 'Megga Park';
SELECT * from pilot_datebook where category = 'Personal' and repeat_type = 'repeatNone';
SELECT * from pilot_datebook where description = 'Sometown' and use_alarm = 'FALSE' and repeat_frequency = 0 and transient_repeat = 'FALSE';
SELECT * from pilot_todo where todo_description = 'qof' or todo_priority > 2;
