Install SQLite3
Download SQLite from http://www.sqlite.org/download.html
saya download source-sqlite3 -> http://www.sqlite.org/sqlite-3.6.1.tar.gz
extract -> tar xzvf sqlite-3.6.1.tar.gz
#cd sqlite-3.6.1
#sudo ./configure
#make
#make install
selesai
Install wxSqlite
Download wxSQLite http://transact.dl.sourceforge.net/sourceforge/wxcode/wxsqlite3-1.4.2.tar.gz
extract -> tar xzvf wxsqlite3-1.4.2.tar.gz
kemudian compile dengan prefix sama sperti saat compilasi wxWidgets
#cd wxsqlite3
#./configure –prefix=/opt/ –enable-debug –enable-unicode –disable-shared –enable-monolithic
#make
#make install
Concragulation
ok let’s we test
#cd samples
#./minimal
#./minimal: error while loading shared libraries: libwxsqlite3.so.0: cannot open shared object file: No such file or directory
o.. owww… ERROR dah
ok create link untuk library libwxsqlite3.so.0 di /lib/
#sudo ln -s /opt/lib/libwxsqlite3.so.0.0.0 /lib/libwxsqlite3.so.0
ok test again
#./minimal
SQLite3 Version: 3.6.1
emp table exists=FALSE
Creating emp table
emp table exists=TRUE
DML tests
1 rows inserted
Franz Beckenbauer
1 rows updated
1 rows deleted
Transaction test, creating 50000 rows please wait…
50000 rows in emp table in 1 seconds
Auto increment test
1 rows deleted
primary key: 1
primary key: 2
primary key: 3
primary key: 4
primary key: 5
Select statement test
empno(integer)|empname(char(20))|salary(int)|
1|Empname000001|1234567890123456|
2|Empname000002|1234567890123456|
3|Empname000003|1234567890123456|
4|Empname000004|1234567890123456|
5|Empname000005|1234567890123456|
SQLite sprintf test
insert into emp (empname, salary) values (‘He”s bad’, 1);
insert into emp (empname, salary) values (NULL, 2);
getTable() test
empno|empname|salary|
Empname000001|1|Empname000001|1234567890123456|
Empname000002|2|Empname000002|1234567890123456|
Empname000003|3|Empname000003|1234567890123456|
Empname000004|4|Empname000004|1234567890123456|
Empname000005|5|Empname000005|1234567890123456|
He’s bad|6|He’s bad|1|
|7|NULL|2|
Select statement test
Empname000001 Empname000002 Empname000003 Empname000004 Empname000005 He’s bad
Binary data test
Stored binary Length: 256
Retrieved binary Length: 256
Transaction test, creating 50000 rows please wait…
AUTH: 9,sqlite_master,,main,main
AUTH: 11,emp,,main,main
AUTH: 9,emp,,main,main
AUTH: 9,sqlite_master,,main,main
AUTH: 20,sqlite_master,tbl_name,main,main
AUTH: 20,sqlite_master,type,main,main
AUTH: 23,sqlite_master,rootpage,main,main
AUTH: 20,sqlite_master,rootpage,main,main
AUTH: 18,sqlite_master,,main,main
AUTH: 2,emp,,main,main
AUTH: 23,sqlite_master,type,main,main
AUTH: 23,sqlite_master,name,main,main
AUTH: 23,sqlite_master,tbl_name,main,main
AUTH: 23,sqlite_master,rootpage,main,main
AUTH: 23,sqlite_master,sql,main,main
AUTH: 20,sqlite_master,ROWID,main,main
AUTH: 20,sqlite_master,name,main,main
AUTH: 20,sqlite_master,rootpage,main,main
AUTH: 20,sqlite_master,sql,main,main
AUTH: 20,sqlite_master,tbl_name,main,main
AUTH: 22,BEGIN,,,
AUTH: 18,emp,,main,main
AUTH: 22,COMMIT,,,
AUTH: 21,,,,
AUTH: 31,,count,,
50000 rows in emp table in 1 seconds
End of tests
Press q then enter to quit:
yeaahh….
Recent Comments