File: select.sql

package info (click to toggle)
pilot-qof 0.2.2-1
  • links: PTS, VCS
  • area: main
  • in suites: squeeze
  • size: 3,348 kB
  • ctags: 684
  • sloc: sh: 10,533; ansic: 4,891; xml: 1,814; perl: 1,768; makefile: 374; sql: 8
file content (10 lines) | stat: -rw-r--r-- 704 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
 
-- 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;