J69VjbJL

1String sqlDataStore = "create table if not exists " 
2+ TABLE_NAME_INFOTABLE + " ("+ BaseColumns._ID + " integer primary key autoincrement," 
3
4         + COLUMN_NAME_SITE + "text not null," 
5         + COLUMN_NAME_ADDRESS + "text not null,"
6         + COLUMN_NAME_USERNAME + "text not null,"
7         + COLUMN_NAME_PASSWORD + "text not null)";
8
9      db.execSQL(sqlDataStore);
10	
11Cursor cursor = database.query(databaseName.TABLE_NAME, null, null, null, null, null, databaseName.COLUMN_NAME, null);
12	
13sqlite> create table foo (n integer);
14sqlite> insert into foo values ('wibble');
15sqlite> select n from foo;
16wibble
17	
18create table test_limit (
19  n integer primary key
20    check (
21      (typeof(n)='integer') and
22      (n >=1 and n <= 10)
23  )
24);
25	
26sqlite> insert into test_limit values (1.13);
27Error: datatype mismatch
28sqlite> insert into test_limit values (-2);
29Error: constraint failed
30sqlite> insert into test_limit values ('wibble');
31Error: datatype mismatch
32sqlite> insert into test_limit values (1);
33sqlite> insert into test_limit values (2);
34sqlite> insert into test_limit values (17);
35Error: constraint failed
36	
37create table test_limit (
38  id integer primary key autoincrement,
39  site text not null,
40  address text not null,
41  username text not null,
42  password text not null,
43  check (
44    typeof(id) = 'integer' and
45    (id >= 1 and id <= 10)
46  )
47);
48
49-- 10 inserts.    
50insert into test_limit (site, address, username, password)
51values ('site', 'address', 'username', 'password');
52insert into test_limit (site, address, username, password)
53values ('site', 'address', 'username', 'password');
54insert into test_limit (site, address, username, password)
55values ('site', 'address', 'username', 'password');
56insert into test_limit (site, address, username, password)
57values ('site', 'address', 'username', 'password');
58insert into test_limit (site, address, username, password)
59values ('site', 'address', 'username', 'password');
60insert into test_limit (site, address, username, password)
61values ('site', 'address', 'username', 'password');
62insert into test_limit (site, address, username, password)
63values ('site', 'address', 'username', 'password');
64insert into test_limit (site, address, username, password)
65values ('site', 'address', 'username', 'password');
66insert into test_limit (site, address, username, password)
67values ('site', 'address', 'username', 'password');
68insert into test_limit (site, address, username, password)
69values ('site', 'address', 'username', 'password');