source: tmcsimulator/branches/LCSv1/databases/search_test.sql @ 615

Revision 615, 1.0 KB checked in by liquan, 6 years ago (diff)

Modified results function to correct the search for provided enddate.

Line 
1SELECT * FROM closures WHERE closures.id = "T5AA";
2SELECT * FROM closures WHERE closures.id = "T55AB";
3
4/* closureid + lognum */
5SELECT * FROM closures WHERE closureid = "T55AA" and lognum = 1;
6SELECT * FROM closures WHERE closureid = "T55AA" and lognum = 5;
7
8/* Route */
9SELECT * FROM closures WHERE route = 5;
10SELECT * FROM closures WHERE route = 13;
11
12/* Route + direction */
13SELECT * FROM closures WHERE route = 5 and direction = "N";
14SELECT * FROM closures WHERE route = 5 and direction = "E";
15
16/* Route + start date */
17SELECT * FROM closures WHERE route = 5 and startdate >= "2020-04-01";
18
19SELECT * FROM closures WHERE route = 5 and startdate >= "2020-05-01";
20
21/* Route + end date */
22SELECT * FROM closures WHERE route = 5 and startdate <= "2020-01-23";
23/* entry 71 */
24SELECT * FROM closures WHERE route = 5 and startdate <= "2019-01-07";
25
26/* Route + end date */
27SELECT * FROM closures WHERE route = 5 and startdate >= "2020-03-17" and startdate <= "2020-03-20";
28/* entry 69 */
29SELECT * FROM closures WHERE route = 5 and startdate <= "2019-01-07";
30
31
Note: See TracBrowser for help on using the repository browser.