All pastes #38077 Raw Edit

Mine

public text v1 · immutable
#38077 ·published 2006-01-22 21:30 UTC
rendered paste body
Testing Opening Databases
SQLiteDll: Open: test: :memory: :S_OK
SQLiteDll: Close: test: :S_OK
SQLiteDll: Open: test: C:\PROGRA~1\mIRC\d1.db :S_OK
SQLiteDll: Open: test: C:\PROGRA~1\mIRC\d1.db :E_LABEL_IN_USE test
Begining Transaction
SQLiteDll: Query: test: BEGIN TRANSACTION; :S_OK 0 0
SQLiteDll: Query: test: BEGIN TRANSACTION; :E_SQLITE_ERROR cannot start a transaction within a transaction
Create a couple of Test Tables
SQLiteDll: Query: test: CREATE TABLE t1 (f1,f2,f3,f4); :S_OK 0 0
SQLiteDll: Query: test: CREATE TABLE t2 (f1,f2,f3,f4); :S_OK 0 0
SQLiteDll: Query: test: CREATE TEMPORY TABLE t3 (f1,f2,f3,f4); :E_SQLITE_ERROR near "TEMPORY": syntax error
Testing Querys
SQLiteDll: Query: test: SELECT * FROM :E_SQLITE_ERROR near "FROM": syntax error
SQLiteDll: Query: fred: SELECT * FROM moo; :E_INVALID_LABEL fred
Commit Transaction
SQLiteDll: Query: test: COMMIT TRANSACTION; :S_OK 0 0
SQLiteDll: Query: test: COMMIT TRANSACTION; :E_SQLITE_ERROR cannot commit - no transaction is active
SQLiteDll: Query: test: SELECT * FROM sqlite_master WHERE (type IN ('table','trigger')) UNION ALL SELECT * FROM sqlite_temp_master WHERE (type IN('table','trigger')); :S_OK 2 5
Testing Fetch Data
SQLiteDll: Rows: test: :S_OK 2
SQLiteDll: RowsAffected: test: :S_OK 0
SQLiteDll: Fields: test: :S_OK type	name	tbl_name	rootpage	sql
SQLiteDll: Fields: test: 1 :S_OK typenametbl_namerootpagesql
SQLiteDll: FetchRow: test: 1 :S_OK table	t1	t1	4	CREATE TABLE t1 (f1,f2,f3,f4)
SQLiteDll: FetchRow: test: 2 @ :S_OK tableblet2bleblet2t2bleblet2bleblet2t23bleblet2bleblet2t2bleblet2bleblet2t23CREATE TABLE t2 (f1,f2,f3,f4)
SQLiteDll: FetchRow: test: 4098 :E_INVALID_ROW 4098
SQLiteDll: FetchRow: test: 1  :S_OK tableblet1bleblet1t1bleblet1bleblet1t14bleblet1bleblet1t1bleblet1bleblet1t14CREATE TABLE t1 (f1,f2,f3,f4)
Freeing up Query Results...
SQLiteDll: FreeQuery: test: :S_OK
Destroy Tempory Databases
SQLiteDll: Query: test: BEGIN TRANSACTION; :S_OK 0 0
SQLiteDll: Query: test: DROP TABLE t1; :S_OK 0 0
SQLiteDll: Query: test: DROP TABLE t2; :S_OK 0 0
SQLiteDll: Query: test: COMMIT TRANSACTION; :S_OK 0 0
SQLiteDll: Query: test: BEGIN TRANSACTION; :S_OK 0 0
Testing misc. Pragma's
SQLiteDll: Query: test: PRAGMA integrity_check; :S_OK 1 1
SQLiteDll: Fields: test: :S_OK integrity_check
SQLiteDll: FetchRow: test: 1 :S_OK ok
Testing Fetch
SQLiteDll: Query: test: PRAGMA database_list; :S_OK 2 3
SQLiteDll: Fetch: test: 0 1 :S_OK 3
SQLiteDll: Fetch: test: 1 0 :S_OK 3
SQLiteDll: Fetch: test: 1 1 :S_OK main
SQLiteDll: Fetch: test: 1 2 :S_OK C:\PROGRA~1\mIRC\d1.db
SQLiteDll: Fetch: test: 1 3 :S_OK 1
SQLiteDll: Fetch: test: 1 4 :E_INVALID_FIELD 4
SQLiteDll: Fetch: test: 2 seq :S_OK 3
SQLiteDll: Fetch: test: 2 name :S_OK temp
SQLiteDll: Fetch: test: 2 file :S_OK C:\DOKUME~1\Silvan\LOKALE~1\Temp\sqlite_qNHsR5rdZ9gHH1Y
SQLiteDll: Fetch: test: 2 bob :E_INVALID_FIELD bob
SQLiteDll: Fetch: test: -1 -1 :S_OK seq	name	file
SQLiteDll: Fetch: test: 0 -1 ! :S_OK 3
SQLiteDll: Fetch: test: 1 -1 9 :S_OK 0	main	C:\PROGRA~1\mIRC\d1.db
SQLiteDll: Fetch: test: 2 -1 255 :S_OK 1ÿtempÿC:\DOKUME~1\Silvan\LOKALE~1\Temp\sqlite_qNHsR5rdZ9gHH1Y
SQLiteDll: Fetch: test: 3 -1 128 :E_INVALID_ROW 3
SQLiteDll: Fetch: test: -1 0 :S_OK 3
SQLiteDll: Fetch: test: -1 1 :S_OK name
SQLiteDll: Fetch: test: -1 2 :S_OK file
SQLiteDll: Fetch: test: -1 3 :S_OK 0
SQLiteDll: Fetch: test: -1 4 :E_INVALID_FIELD 4
SQLiteDll: Fetch: test: 0 :S_OK 3
SQLiteDll: Fetch: test: 1 :S_OK 0	main	C:\PROGRA~1\mIRC\d1.db
SQLiteDll: Fetch: test: 2 :S_OK 1	temp	C:\DOKUME~1\Silvan\LOKALE~1\Temp\sqlite_qNHsR5rdZ9gHH1Y
SQLiteDll: Fetch: test: 3 :E_INVALID_ROW 3
SQLiteDll: Query: test: COMMIT TRANSACTION; :S_OK 0 0
Testing Closing Databases
SQLiteDll: Close: test: :S_OK
SQLiteDll: Close: test: :E_INVALID_LABEL test
Testing Label Listing (Using InMemory Database)...
SQLiteDll: Open: test_a: :memory: :S_OK
SQLiteDll: Open: test_b: :memory: :S_OK
SQLiteDll: Open: test_c: :memory: :S_OK
SQLiteDll: Labels: 0: :S_OK 3
SQLiteDll: Labels: 1: :S_OK test_c
SQLiteDll: Labels: 2: :S_OK test_b
SQLiteDll: Labels: 3: :S_OK test_a
SQLiteDll: Labels: 4: :E_INVALID_LABEL 4
SQLiteDll: Close: test_c: :S_OK
SQLiteDll: Close: test_b: :S_OK
SQLiteDll: Close: test_a: :S_OK
Tests Completed...