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

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Merge testing and doc updates from trunk.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | deferred-close
Files: files | file ages | folders
SHA1: a2f8c25b8a4d37b6c4ccbbffcbc9ceeaa50cf737
User & Date: mistachkin 2012-06-18 11:10:50
Context
2012-06-22
20:12
Update core SQLite library to the latest trunk. Merge support for the sqlite3_close_v2 API. Add missing test contraints for the dynamic SQLite core library detection, the USE_INTEROP_DLL compile-time define, and the System.Data.SQLite.dll / System.Data.SQLite.Linq.dll file detection. Fix several #if statements to include USE_INTEROP_DLL in addition to INTEROP_EXTENSION_FUNCTIONS. check-in: 1462b42fc2 user: mistachkin tags: trunk
2012-06-18
11:10
Merge testing and doc updates from trunk. Closed-Leaf check-in: a2f8c25b8a user: mistachkin tags: deferred-close
11:08
Modify the test suite cleanup semantics to allow the deferred close functionality to work correctly. Also, fix the database cleanup ordering in the tests for ticket [343d392b51]. check-in: 9b92396ca2 user: mistachkin tags: trunk
2012-06-12
08:52
Experimental changes to support the prototype sqlite3_close_v2 interface. check-in: 8b0d3259cb user: mistachkin tags: deferred-close
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to Doc/Extra/version.html.

    41     41         </table>
    42     42       </div>
    43     43       <div id="mainSection">
    44     44       <div id="mainBody">
    45     45       <h1 class="heading">Version History</h1>
    46     46       <p><b>1.0.82.0 - July XX, 2012</b></p>
    47     47       <ul>
    48         -      <li>Updated to SQLite 3.7.13.</li>
           48  +      <li>Updated to <a href="http://www.sqlite.org/releaselog/3_7_13.html">SQLite 3.7.13</a>.</li>
    49     49         <li>Add SetMemoryStatus static method to the SQLiteConnection class.</li>
    50     50         <li>Improve threaded handling of the delegate used by the SQLiteLog class.</li>
    51     51       </ul>
    52     52       <p><b>1.0.81.0 - May 27, 2012</b></p>
    53     53       <ul>
    54     54         <li>Updated to <a href="http://www.sqlite.org/releaselog/3_7_12_1.html">SQLite 3.7.12.1</a>.</li>
    55     55         <li>Support compiling the interop assembly without support for the custom extension functions and the CryptoAPI based codec.</li>

Changes to Tests/basic.eagle.

  1380   1380   
  1381   1381     object foreach -alias item $collection {
  1382   1382       lappend result [$collection GetValues $item]
  1383   1383     }
  1384   1384   
  1385   1385     set result
  1386   1386   } -cleanup {
  1387         -  cleanupDb $fileName
         1387  +  unset -nocomplain result item collection reader command connection
  1388   1388   
  1389         -  unset -nocomplain result item collection reader command connection db \
  1390         -      fileName
         1389  +  cleanupDb $fileName; # NOTE: After object disposal.
         1390  +
         1391  +  unset -nocomplain db fileName
  1391   1392   } -constraints \
  1392   1393   {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \
  1393   1394   {{26 26} {zebra zebra}}}
  1394   1395   
  1395   1396   ###############################################################################
  1396   1397   
  1397   1398   runTest {test data-1.26 {LINQ ISQLiteSchemaExtensions.BuildTempSchema} -setup {

Changes to Tests/common.eagle.

   592    592         # NOTE: Open the database connection now, placing the opaque handle value
   593    593         #       into the variable specified by the caller.
   594    594         #
   595    595         set db [sql open -type SQLite [subst $connection]]
   596    596       }
   597    597   
   598    598       proc cleanupDb { fileName {varName db} } {
          599  +      #
          600  +      # NOTE: Attempt to force all pending "garbage" objects to be collected,
          601  +      #       including SQLite statements and backup objects; this should allow
          602  +      #       the underlying database file to be deleted.
          603  +      #
          604  +      if {[catch {object invoke GC GetTotalMemory true} error]} then {
          605  +        tputs $channel [appendArgs \
          606  +            "==== WARNING: failed full garbage collection, error: " \
          607  +            \n\t $error \n]
          608  +      }
          609  +
   599    610         #
   600    611         # NOTE: Refer to the specified variable (e.g. "db") in the context of the
   601    612         #       caller.  The handle to the opened database is stored there.
   602    613         #
   603    614         upvar 1 $varName db
   604    615   
   605    616         #
................................................................................
   665    676           set code 0
   666    677         }
   667    678   
   668    679         return $code
   669    680       }
   670    681   
   671    682       proc cleanupFile { fileName {force false} } {
          683  +      #
          684  +      # NOTE: Attempt to force all pending "garbage" objects to be collected,
          685  +      #       including SQLite statements and backup objects; this should allow
          686  +      #       the underlying database file to be deleted.
          687  +      #
          688  +      if {[catch {object invoke GC GetTotalMemory true} error]} then {
          689  +        tputs $channel [appendArgs \
          690  +            "==== WARNING: failed full garbage collection, error: " \
          691  +            \n\t $error \n]
          692  +      }
          693  +
   672    694         #
   673    695         # NOTE: Check if the file still exists.
   674    696         #
   675    697         if {[file exists $fileName]} then {
   676    698           #
   677    699           # NOTE: Skip deleting test files if somebody sets the global variable
   678    700           #       to prevent it.

Changes to Tests/tkt-343d392b51.eagle.

   177    177   
   178    178     list $code $results \
   179    179         [expr {[info exists errors] ? $errors : ""}] \
   180    180         [expr {$code eq "Ok" ? [catch {
   181    181           object invoke _Dynamic${id}.Test${id} Main
   182    182         } result] : [set result ""]}] $result
   183    183   } -cleanup {
          184  +  cleanupDb $fileName; unset -nocomplain db fileName
   184    185     cleanupDb $otherFileName
   185         -  cleanupDb $fileName
   186    186   
   187    187     unset -nocomplain result code results errors i sql otherTable otherDbName \
   188         -      otherDataSource dataSource id db otherFileName fileName
          188  +      otherDataSource dataSource id otherFileName
   189    189   } -constraints \
   190    190   {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -match \
   191    191   glob -result {* System.Data.DBConcurrencyException: *}}
   192    192   
   193    193   ###############################################################################
   194    194   
   195    195   runTest {test tkt-343d392b51-2.2 {SQLiteDataAdapter update success} -setup {
................................................................................
   283    283   
   284    284     list $code $results \
   285    285         [expr {[info exists errors] ? $errors : ""}] \
   286    286         [expr {$code eq "Ok" ? [catch {
   287    287           object invoke _Dynamic${id}.Test${id} Main
   288    288         } result] : [set result ""]}] $result
   289    289   } -cleanup {
          290  +  cleanupDb $fileName; unset -nocomplain db fileName
   290    291     cleanupDb $otherFileName
   291         -  cleanupDb $fileName
   292    292   
   293    293     unset -nocomplain result code results errors i sql otherTable otherDbName \
   294         -      otherDataSource dataSource id db otherFileName fileName
          294  +      otherDataSource dataSource id otherFileName
   295    295   } -constraints \
   296    296   {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -match \
   297    297   regexp -result {^Ok System#CodeDom#Compiler#CompilerResults#\d+ \{\} 0 \{\}$}}
   298    298   
   299    299   ###############################################################################
   300    300   
   301    301   runTest {test tkt-343d392b51-3.1 {attached database, same table name} -setup {
................................................................................
   322    322   
   323    323     sql execute $db $sql(1)
   324    324   
   325    325     list [sql execute -execute reader -format list $db "SELECT x FROM t1;"] \
   326    326         [sql execute -execute reader -format list $db [appendArgs \
   327    327         "SELECT x FROM " ${otherTable} ";"]]
   328    328   } -cleanup {
          329  +  cleanupDb $fileName; unset -nocomplain db fileName
   329    330     cleanupDb $otherFileName
   330         -  cleanupDb $fileName
   331    331   
   332         -  unset -nocomplain i sql otherTable otherDbName otherDataSource db \
   333         -      otherFileName fileName
          332  +  unset -nocomplain i sql otherTable otherDbName otherDataSource otherFileName
   334    333   } -constraints \
   335    334   {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \
   336    335   {{1 2} {2 4}}}
   337    336   
   338    337   ###############################################################################
   339    338   
   340    339   runTest {test tkt-343d392b51-3.2 {adapter, attached db, table names} -setup {
................................................................................
   421    420   
   422    421     list $code $results \
   423    422         [expr {[info exists errors] ? $errors : ""}] \
   424    423         [expr {$code eq "Ok" ? [catch {
   425    424           object invoke _Dynamic${id}.Test${id} Main
   426    425         } result] : [set result ""]}] $result
   427    426   } -cleanup {
          427  +  cleanupDb $fileName; unset -nocomplain db fileName
   428    428     cleanupDb $otherFileName
   429         -  cleanupDb $fileName
   430    429   
   431    430     unset -nocomplain result code results errors i sql otherTable otherDbName \
   432         -      otherDataSource dataSource id db otherFileName fileName
          431  +      otherDataSource dataSource id otherFileName
   433    432   } -constraints \
   434    433   {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -match \
   435    434   regexp -result {^Ok System#CodeDom#Compiler#CompilerResults#\d+ \{\} 0 \{\}$}}
   436    435   
   437    436   ###############################################################################
   438    437   
   439    438   runSQLiteTestEpilogue
   440    439   runTestEpilogue

Changes to readme.htm.

     2      2   <html>
     3      3   <head>
     4      4   <title></title>
     5      5   </head>
     6      6   <body>
     7      7   ADO.NET SQLite Data Provider<br />
     8      8   Version 1.0.82.0 July XX, 2012 <font color="red">(release scheduled)</font><br />
     9         -Using SQLite 3.7.13 <a href="http://www.sqlite.org/src/info/506008f000">(unreleased trunk)</a><br />
            9  +Using <a href="http://www.sqlite.org/releaselog/3_7_13.html">SQLite 3.7.13</a><br />
    10     10   Originally written by Robert Simpson<br />
    11     11   Released to the public domain, use at your own risk!<br />
    12     12   Official provider website:&nbsp;<a href="http://system.data.sqlite.org/">http://system.data.sqlite.org/</a><br />
    13     13   Legacy versions:&nbsp;<a href="http://sqlite.phxsoftware.com/">http://sqlite.phxsoftware.com/</a><br />
    14     14   <br />
    15     15   The current development version can be downloaded from <a href="http://system.data.sqlite.org/index.html/timeline?y=ci">
    16     16   http://system.data.sqlite.org/index.html/timeline?y=ci</a>
................................................................................
   186    186   
   187    187   <h2><b>Version History</b></h2>
   188    188   
   189    189   <p>
   190    190       <b>1.0.82.0 - July XX, 2012</b>
   191    191   </p>
   192    192   <ul>
   193         -    <li>Updated to SQLite 3.7.13.</li>
          193  +    <li>Updated to <a href="http://www.sqlite.org/releaselog/3_7_13.html">SQLite 3.7.13</a>.</li>
   194    194       <li>Add SetMemoryStatus static method to the SQLiteConnection class.</li>
   195    195       <li>Improve threaded handling of the delegate used by the SQLiteLog class.</li>
   196    196   </ul>
   197    197   <p>
   198    198       <b>1.0.81.0 - May 27, 2012</b>
   199    199   </p>
   200    200   <ul>

Changes to www/news.wiki.

     2      2   
     3      3   <b>Version History</b>
     4      4   
     5      5   <p>
     6      6       <b>1.0.82.0 - July XX, 2012 <font color="red">(release scheduled)</font></b>
     7      7   </p>
     8      8   <ul>
     9         -    <li>Updated to SQLite 3.7.13.</li>
            9  +    <li>Updated to [http://www.sqlite.org/releaselog/3_7_13.html|SQLite 3.7.13].</li>
    10     10       <li>Add SetMemoryStatus static method to the SQLiteConnection class.</li>
    11     11       <li>Improve threaded handling of the delegate used by the SQLiteLog class.</li>
    12     12   </ul>
    13     13   <p>
    14     14       <b>1.0.81.0 - May 27, 2012</b>
    15     15   </p>
    16     16   <ul>