Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add some tests for the 'sqlite_stmt' virtual table. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
e52c25447b09492a5f68c6ec5fe5c688 |
| User & Date: | mistachkin 2017-07-15 21:19:32 |
References
|
2017-07-31
| ||
| 18:08 | Fix broken expected result for test 'data-1.90', added by check-in [e52c25447b]. check-in: c6aa4ff71c user: mistachkin tags: trunk | |
Context
|
2017-07-26
| ||
| 20:04 | Update SQLite core library to the latest 3.20 release candidate. check-in: 73881c98e0 user: mistachkin tags: trunk | |
|
2017-07-15
| ||
| 21:19 | Add some tests for the 'sqlite_stmt' virtual table. check-in: e52c25447b user: mistachkin tags: trunk | |
| 19:12 | By default, enable the 'sqlite_stmt' virtual table in the interop assembly. check-in: 0d5ba4b280 user: mistachkin tags: trunk | |
Changes
Changes to Tests/basic.eagle.
4686 4687 4688 4689 4690 4691 4692 4693 4694 4695 4696 4697 4698 4699 4700 4701 4702 |
unset -nocomplain dataReader
cleanupDb $fileName
unset -nocomplain result sql db fileName
} -constraints {eagle command.object monoBug28 command.sql compile.DATA SQLite\
System.Data.SQLite} -result {9 18}}
###############################################################################
reportSQLiteResources $test_channel
###############################################################################
runSQLiteTestFilesEpilogue
runSQLiteTestEpilogue
runTestEpilogue
|
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > |
4686 4687 4688 4689 4690 4691 4692 4693 4694 4695 4696 4697 4698 4699 4700 4701 4702 4703 4704 4705 4706 4707 4708 4709 4710 4711 4712 4713 4714 4715 4716 4717 4718 4719 4720 4721 4722 4723 4724 4725 4726 4727 4728 4729 4730 4731 4732 4733 4734 4735 4736 4737 |
unset -nocomplain dataReader
cleanupDb $fileName
unset -nocomplain result sql db fileName
} -constraints {eagle command.object monoBug28 command.sql compile.DATA SQLite\
System.Data.SQLite} -result {9 18}}
###############################################################################
runTest {test data-1.90 {stmt extension / 'sqlite_stmt' virtual table} -setup {
setupDb [set fileName data-1.90.db]
} -body {
sql execute $db {
CREATE TABLE t1(x);
INSERT INTO t1 (x) VALUES(1);
}
set result [list]
set reader(1) [sql execute -execute reader -format datareader -alias \
$db "SELECT * FROM t1;"]
lappend result [sql execute -execute reader -format list -alias \
$db "SELECT * FROM sqlite_stmt;"]
$reader(1) Close; unset -nocomplain $reader(1)
lappend result [sql execute -execute reader -format list -alias \
$db "SELECT * FROM sqlite_stmt;"]
set result
} -cleanup {
unset -nocomplain reader
cleanupDb $fileName
unset -nocomplain result db fileName
} -constraints {eagle command.object monoBug28 command.sql compile.DATA SQLite\
System.Data.SQLite SQLiteInterop} -match regexp -result {^\{\{SELECT * FROM\
sqlite_stmt;\} 11 1 1 0 0 0 0 0 1 \d+ \{SELECT * FROM t1;\} 1 1 1 0 0 0 9 0 1\
\d+} \{\{SELECT * FROM sqlite_stmt;\} 11 1 1 0 0 0 0 0 1 \d+\}$}}
###############################################################################
reportSQLiteResources $test_channel
###############################################################################
runSQLiteTestFilesEpilogue
runSQLiteTestEpilogue
runTestEpilogue
|