System.Data.SQLite
Check-in [bc67919bfc]
Not logged in

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: bc67919bfc4c2bd2c9b9fd1552fb27b45103f4ca
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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

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