← Back to branch summary

~ubuntu-branches/ubuntu/saucy/indicator-appmenu/saucy-updates

« back to all changes in this revision

Viewing changes to tests/test-usage-db-simple.sql

  • Committer: Package Import Robot
  • Author(s): Automatic PS uploader, Mathieu Trudel-Lapierre, Automatic PS uploader
  • Date: 2013-02-20 09:41:54 UTC
  • mfrom: (1.1.40)
  • Revision ID: package-import@ubuntu.com-20130220094154-zrxsx0vgay436wyt
Tags: 13.01.0daily13.02.20-0ubuntu1
[ Mathieu Trudel-Lapierre ]
* Artificially bump upstream major version to please hud.

[ Automatic PS uploader ]
* Automatic snapshot from revision 234

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/test-usage-db-simple.sql
1
 
create table usage (application text, entry text, timestamp datetime);
2
 
insert into usage (application, entry, timestamp) values ("testapp.desktop", "One", datetime('now', 'utc'));
3
 
insert into usage (application, entry, timestamp) values ("testapp.desktop", "Two", datetime('now', 'utc'));
4
 
insert into usage (application, entry, timestamp) values ("testapp.desktop", "Two", datetime('now', 'utc', '-1 day'));
5
 
insert into usage (application, entry, timestamp) values ("testapp.desktop", "Three", datetime('now', 'utc'));
6
 
insert into usage (application, entry, timestamp) values ("testapp.desktop", "Three", datetime('now', 'utc', '-1 day'));
7
 
insert into usage (application, entry, timestamp) values ("testapp.desktop", "Three", datetime('now', 'utc', '-2 day'));
8
 
insert into usage (application, entry, timestamp) values ("testapp.desktop", "Four", datetime('now', 'utc'));
9
 
insert into usage (application, entry, timestamp) values ("testapp.desktop", "Four", datetime('now', 'utc', '-1 day'));
10
 
insert into usage (application, entry, timestamp) values ("testapp.desktop", "Four", datetime('now', 'utc', '-2 day'));
11
 
insert into usage (application, entry, timestamp) values ("testapp.desktop", "Four", datetime('now', 'utc', '-3 day'));