Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add test for the SQLiteConnection.Open method using all non-default PRAGMA property values in the connection string. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
bc67919bfc4c2bd2c9b9fd1552fb27b4 |
| User & Date: | mistachkin 2012-07-22 09:12:42 |
Context
|
2012-07-27
| ||
| 00:52 | Modify release archive verification tool to use environment variables that do not interfere with the operation of the called tools themselves. check-in: 4dedf50acc user: mistachkin tags: trunk | |
|
2012-07-22
| ||
| 09:12 | Add test for the SQLiteConnection.Open method using all non-default PRAGMA property values in the connection string. check-in: bc67919bfc user: mistachkin tags: trunk | |
| 08:38 | Enhance the stress test to keep track of the execution times for each workload and then report the averages. check-in: be04e652f4 user: mistachkin tags: trunk | |
Changes
Changes to Tests/basic.eagle.
1587 1587 } -cleanup { 1588 1588 cleanupDb $fileName 1589 1589 1590 1590 unset -nocomplain result db fileName 1591 1591 } -constraints \ 1592 1592 {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ 1593 1593 {1024 1073741823 0 2 2000 delete 0}} 1594 + 1595 +############################################################################### 1596 + 1597 +runTest {test data-1.32 {SQLiteConnection.Open with PRAGMA overrides} -setup { 1598 + # 1599 + # NOTE: Attempt to open a connection with all available PRAGMA settings 1600 + # set to non-default values in the connection string. 1601 + # 1602 + setupDb [set fileName data-1.32.db] "" "" "" "" [join [list \ 1603 + "Page Size=4096" "Max Page Count=2048" "Legacy Format=True" \ 1604 + Synchronous=Normal "Cache Size=4096" "Journal Mode=Wal" \ 1605 + "Foreign Keys=True"] \;] 1606 +} -body { 1607 + set result [list] 1608 + 1609 + lappend result [sql execute -execute scalar $db "PRAGMA page_size;"] 1610 + lappend result [sql execute -execute scalar $db "PRAGMA max_page_count;"] 1611 + lappend result [sql execute -execute scalar $db "PRAGMA legacy_file_format;"] 1612 + lappend result [sql execute -execute scalar $db "PRAGMA synchronous;"] 1613 + lappend result [sql execute -execute scalar $db "PRAGMA cache_size;"] 1614 + lappend result [sql execute -execute scalar $db "PRAGMA journal_mode;"] 1615 + lappend result [sql execute -execute scalar $db "PRAGMA foreign_keys;"] 1616 + 1617 + set result 1618 +} -cleanup { 1619 + cleanupDb $fileName 1620 + 1621 + unset -nocomplain result db fileName 1622 +} -constraints \ 1623 +{eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ 1624 +{4096 2048 1 1 4096 wal 1}} 1594 1625 1595 1626 ############################################################################### 1596 1627 1597 1628 unset -nocomplain systemDataSQLiteDllFile systemDataSQLiteLinqDllFile \ 1598 1629 testExeFile testLinqExeFile northwindEfDbFile testLinqOutFile 1599 1630 1600 1631 ############################################################################### 1601 1632 1602 1633 runSQLiteTestEpilogue 1603 1634 runTestEpilogue