Version History

1.0.80.0 - April XX, 2012

1.0.81.0 - June XX, 2012

Support compiling the interop assembly without support for the custom extension functions and the CryptoAPI based codec.
Add DefineConstants property to the SQLiteConnection class to return the list of define constants used when compiling the core managed assembly.
Add release archive verification tool to the release automation.
Fix subtle race condition between threads fetching connection handles from the connection pool any garbage collection (GC) threads that may be running. Fix for [996d13cd87].
Add missing call to SetTimeout in the SQLite3_UTF16.Open method.
Add checks to prevent the SQLiteConnectionPool.Remove method from returning any connection handles that are closed or invalid.
Modify static SQLiteBase helper methods to prevent them from passing IntPtr.Zero to the SQLite native library.
Remove static locks from the static helper methods in the SQLiteBase class, replacing them with a lock on the connection handle instance being operated upon.
Revise CriticalHandle derived classes to make them more thread-safe.
Add connection pool related diagnostic messages when compiled with the DEBUG define constant.
Add PoolCount property to the SQLiteConnection class to return the number of pool entries for the file name associated with the connection.
Rename internal SQLiteLastError methods to GetLastError.
Add assembly file test constraints to all tests that execute the "test.exe" or "testlinq.exe" files.

1.0.80.0 - April 1, 2012

Updated to SQLite 3.7.11.
In the SQLiteFunction class, when calling user-provided methods from a delegate called by native code, avoid throwing exceptions, optionally tracing the caught exceptions. Fix for [8a426d12eb].
Add Visual Studio 2005 support to all the applicable solution/project files, their associated supporting files, and the test suite.
Add Visual Studio 2005 support to the redesigned designer support installer.
Add experimental support for "pre-loading" the native SQLite library based on the processor architecture of the current process. This feature is now enabled by default at compile-time.
Add support for the native SQLite Online Backup API. Fix for [c71846ed57].
Acquire and hold a static data lock while checking if the native SQLite library has been initialized to prevent a subtle race condition that can result in superfluous error messages. Fix for [72905c9a77].
Support tracing of all parameter binding activity and use the connection flags to control what is traced.
When converting a DateTime instance of an "Unspecified" kind to a string, use the same kind as the connection, if available.
Add overload of the SQLiteDataReader.GetValues method that returns a NameValueCollection.
Add static ToUnixEpoch method to the SQLiteConvert class to convert a DateTime value to the number of whole seconds since the Unix epoch.
In the implicit conversion operators (to IntPtr) for both the SQLiteConnectionHandle and SQLiteStatementHandle classes, return IntPtr.Zero if the instance being converted is null.
Write warning message to the active trace listners (for the Debug build configuration only) if a column type or type name cannot be mapped properly. See [4bbf851fa5].
Write warning message to the active trace listeners (for the Debug build configuration only) if a column type or type name cannot be mapped properly. See [4bbf851fa5].
When tracing SQL statements to be prepared, bypass the internal length limit of the sqlite3_log function by using the SQLiteLog class directly instead. Also, detect null and/or empty strings and emit a special message in that case.
For the setup, the Visual Studio task should only be initially checked if the GAC task is available and vice-versa.
Improve compatibility with custom command processors by using __ECHO instead of _ECHO in batch tools.
Add OpenAndReturn method to the SQLiteConnection class to open a connection and return it.
Add missing CheckDisposed calls to the SQLiteConnection class.

About SQLite.NET

This class library is an ADO.NET wrapper around the popular (and free!) - SQLite database engine. For information on SQL syntax, features of SQLite and a - good understanding of how it works and what it does, I highly recommend heading - over to sqlite.org and +

This class library is an ADO.NET wrapper around the popular (and free!) + SQLite database engine. For information on SQL syntax, features of SQLite and a + good understanding of how it works and what it does, I highly recommend heading + over to sqlite.org and reading the documentation there.

The C# provider, the very minor C code modifications to SQLite, documentation and - etc were written by Robert +

The C# provider, the very minor C code modifications to SQLite, documentation and + etc were written by Robert Simpson, and the SourceForge project page can be found here.

The System.Data.SQLite project is currently maintained by the + SQLite Development Team and + the latest source code and project information can be found + here.

What's New?

Click here to see the version history of this SQLite.NET +

Click here to see the version history of this SQLite.NET provider

Using this library

The following are links to information on various aspects of the library and +

The following are links to information on various aspects of the library and how to use it in your application(s)

How to install Visual Studio Design-Time Support

How to configure and enumerate SQLite.NET +

How to configure and enumerate SQLite.NET through the DbProviderFactories object

Getting the best performance out of SQLite

Limitations of the SQLite.NET provider and the SQLite +

Limitations of the SQLite.NET provider and the SQLite engine (compared to other providers and engines)

SQLite.NET Provider Features

This SQLite provider implements every feature of the underlying SQLite +

This SQLite provider implements every feature of the underlying SQLite database engine without omission. Here's a brief summary:

Written from scratch on Visual Studio 2008 specifically for ADO.NET, implenting all the base classes and features recently introduced in the framework, including automatic transaction enlistment.
Supports the Full and Compact .NET Framework, as well as native C/C++ development. 100% binary compatible with the original sqlite3.dll.
Full support for Mono via a "managed only" provider that runs against the +
Full support for Mono via a "managed only" provider that runs against the official SQLite 3.6.1 or higher library.
Full Entity Framework support (ADO.NET 3.5 SP1)
On the Compact Framework, it is faster than Sql Server Mobile. SQLite's installed size is a fraction of Sql Mobile's. It uses less memory at runtime, runs queries faster, and has a smaller database file size as well.
Encrypted database support. Encrypted databases are fully encrypted and support both binary and cleartext password types.
Visual Studio 2005/2008/2010 Design-Time Support. You can add a SQLite - database to the Servers list, design queries with the Query Designer, +
Visual Studio 2005/2008/2010 Design-Time Support. You can add a SQLite + database to the Servers list, design queries with the Query Designer, drag-and-drop tables onto a Typed DataSet, etc.
Full SQLite schema editing inside Visual Studio. You can create/edit +
Full SQLite schema editing inside Visual Studio. You can create/edit tables, views, triggers, indexes, check constraints and foreign keys.
- Available as a single file redistributable (except Compact Framework). The core sqlite3 codebase and the ADO.NET wrapper + Available as a single file redistributable (except Compact Framework). The core sqlite3 codebase and the ADO.NET wrapper are combined into one multi-module assembly.
Also available as separate native and managed assemblies and optionally with the Visual C++ Runtime statically linked.
Binaries included for Itanium, x64, x86 and ARM processors.
@@ -108,37 +112,37 @@
DbProviderFactory support.
Full support for ATTACH'ed databases. Exposed as Catalogs - in the schema. When cloning a connection, all attached databases are + in the schema. When cloning a connection, all attached databases are automatically re-attached to the new connection.
DbConnection.GetSchema(...) support includes the MetaDataCollections, DataSourceInformation, Columns, Tables, Views, ViewColumns, - Catalogs, Indexes, + Catalogs, Indexes, IndexColumns, ForeignKeys and Triggers.

- Enhanced DbDataReader.GetSchemaTable() functionality returns catalog, namespace + Enhanced DbDataReader.GetSchemaTable() functionality returns catalog, namespace and detailed schema information even for complex queries.

Named and unnamed parameters.

- Full UTF-8 and UTF-16 support, each with optimized pipelines into the native + Full UTF-8 and UTF-16 support, each with optimized pipelines into the native database core.

Multiple simultaneous DataReaders (one DataReader per Command however).

- Full support for user-defined scalar and aggregate functions, encapsulated into - an easy-to-use base class in which only a couple of overrides are necessary to + Full support for user-defined scalar and aggregate functions, encapsulated into + an easy-to-use base class in which only a couple of overrides are necessary to implement new SQL functions.

- Full support for user-defined collating sequences, every bit as simple to + Full support for user-defined collating sequences, every bit as simple to implement as user-defined functions and uses the same base class.

- Full source for the entire engine and wrapper. No copyrights. + Full source for the entire engine and wrapper. No copyrights. Public Domain. 100% free for commercial and non-commercial use.

Distributing the Binaries (Desktop)

When using the mixed-mode assembly, the System.Data.SQLite.DLL file @@ -154,11 +158,11 @@

Distributing the Binaries (Compact Framework)

Both the System.Data.SQLite.DLL and SQLite.Interop.XXX.DLL files must be deployed on the Compact Framework. The XXX is the build number of - the System.Data.SQLite library (e.g. "080"). The + the System.Data.SQLite library (e.g. "081"). The SQLite.Interop.XXX.DLL file is a fully native assembly compiled for the ARM processor, and System.Data.SQLite is the fully-managed Compact Framework assembly.

Index: Doc/SQLite.NET.chm ================================================================== --- Doc/SQLite.NET.chm +++ Doc/SQLite.NET.chm cannot compute difference between binary files Index: Externals/Eagle/bin/Eagle.dll ================================================================== --- Externals/Eagle/bin/Eagle.dll +++ Externals/Eagle/bin/Eagle.dll cannot compute difference between binary files Index: Externals/Eagle/bin/EagleShell.exe ================================================================== --- Externals/Eagle/bin/EagleShell.exe +++ Externals/Eagle/bin/EagleShell.exe cannot compute difference between binary files Index: Externals/Eagle/bin/EagleShell.exe.config ================================================================== --- Externals/Eagle/bin/EagleShell.exe.config +++ Externals/Eagle/bin/EagleShell.exe.config @@ -16,10 +16,11 @@ 2010 - 080 - 1.0.80.0 - 1,0,80,0 + 081 + 1.0.81.0 + 1,0,81,0 + INTEROP_EXTENSION_FUNCTIONS=1;INTEROP_CODEC=1 /ASSEMBLYRESOURCE:..\System.Data.SQLite\SQLiteCommand.bmp,System.Data.SQLite.SQLiteCommand.bmp /ASSEMBLYRESOURCE:..\System.Data.SQLite\SQLiteConnection.bmp,System.Data.SQLite.SQLiteConnection.bmp /ASSEMBLYRESOURCE:..\System.Data.SQLite\SQLiteDataAdapter.bmp,System.Data.SQLite.SQLiteDataAdapter.bmp $(ProjectDir)..\System.Data.SQLite\System.Data.SQLite.snk SQLite.Interop System.Data.SQLite @@ -36,10 +37,14 @@ $(INTEROP_RC_VERSION) true + + $(INTEROP_EXTRA_DEFINES) + true + $(INTEROP_ASSEMBLY_RESOURCES) true Index: SQLite.Interop/src/win/interop.c ================================================================== --- SQLite.Interop/src/win/interop.c +++ SQLite.Interop/src/win/interop.c @@ -1,11 +1,16 @@ #define SQLITE_API __declspec(dllexport) #include "../core/sqlite3.c" + +#if defined(INTEROP_EXTENSION_FUNCTIONS) #include "../contrib/extension-functions.c" -#include "crypt.c" - extern int RegisterExtensionFunctions(sqlite3 *db); +#endif + +#if defined(INTEROP_CODEC) +#include "crypt.c" +#endif #ifdef SQLITE_OS_WIN // Additional open flags, we use this one privately //#define SQLITE_OPEN_SHAREDCACHE 0x01000000 @@ -111,12 +116,14 @@ //sqlite3_enable_shared_cache(sharedcache); ret = sqlite3_open_v2(filename, ppdb, flags, NULL); //sqlite3_enable_shared_cache(0); +#if defined(INTEROP_EXTENSION_FUNCTIONS) if (ret == 0) RegisterExtensionFunctions(*ppdb); +#endif return ret; } SQLITE_API int WINAPI sqlite3_open16_interop(const char *filename, int flags, sqlite3 **ppdb) Index: SQLite.Interop/src/win/interop.h ================================================================== --- SQLite.Interop/src/win/interop.h +++ SQLite.Interop/src/win/interop.h @@ -6,7 +6,7 @@ * Released to the public domain, use at your own risk! * */ #ifndef INTEROP_VERSION -#define INTEROP_VERSION "1.0.80.0" +#define INTEROP_VERSION "1.0.81.0" #endif Index: SQLite.MSIL.nuspec ================================================================== --- SQLite.MSIL.nuspec +++ SQLite.MSIL.nuspec @@ -1,10 +1,10 @@ System.Data.SQLite.MSIL - 1.0.80.0 + 1.0.81.0 SQLite Development Team An ADO.NET provider for SQLite (managed-only). en-US http://system.data.sqlite.org/ http://system.data.sqlite.org/images/sqlite32.png Index: SQLite.NET.Settings.targets ================================================================== --- SQLite.NET.Settings.targets +++ SQLite.NET.Settings.targets @@ -122,10 +122,44 @@ processor architecture of the currently running process upon using the component. This feature is experimental and may be modified or removed in a future release. --> true + + + true + + + true $(DefineConstants);PRELOAD_NATIVE_LIBRARY + + + + $(DefineConstants);INTEROP_EXTENSION_FUNCTIONS + + + + + $(DefineConstants);INTEROP_CODEC + Index: System.Data.SQLite/UnsafeNativeMethods.cs ================================================================== --- System.Data.SQLite/UnsafeNativeMethods.cs +++ System.Data.SQLite/UnsafeNativeMethods.cs @@ -21,10 +21,14 @@ #if !PLATFORM_COMPACTFRAMEWORK && !DEBUG using System.Security; #endif using System.Runtime.InteropServices; + +#if !PLATFORM_COMPACTFRAMEWORK + using System.Threading; +#endif #if !PLATFORM_COMPACTFRAMEWORK && !DEBUG [SuppressUnmanagedCodeSecurity] #endif internal static class UnsafeNativeMethods @@ -130,14 +134,24 @@ // processor architecture names and/or platform names // changes. // if (processorArchitecturePlatforms == null) { + // + // NOTE: Create the map of processor architecture names + // to platform names using a case-insensitive string + // comparer. + // processorArchitecturePlatforms = - new Dictionary(); + new Dictionary( + StringComparer.OrdinalIgnoreCase); - processorArchitecturePlatforms.Add("X86", "Win32"); + // + // NOTE: Setup the list of platform names associated with + // the supported processor architectures. + // + processorArchitecturePlatforms.Add("x86", "Win32"); processorArchitecturePlatforms.Add("AMD64", "x64"); processorArchitecturePlatforms.Add("IA64", "Itanium"); } // @@ -246,10 +260,21 @@ /// the .NET Compact Framework. /// private static string GetProcessorArchitecture() { #if !PLATFORM_COMPACTFRAMEWORK + // + // NOTE: If the "PreLoadSQLite_ProcessorArchitecture" environment + // variable is set, use it verbatim for the current processor + // architecture. + // + string processorArchitecture = Environment.GetEnvironmentVariable( + "PreLoadSQLite_ProcessorArchitecture"); + + if (processorArchitecture != null) + return processorArchitecture; + // // BUGBUG: Will this always be reliable? // return Environment.GetEnvironmentVariable(PROCESSOR_ARCHITECTURE); #else @@ -287,21 +312,10 @@ string platformName; if (processorArchitecturePlatforms.TryGetValue( processorArchitecture, out platformName)) { - return platformName; - } - - if (processorArchitecturePlatforms.TryGetValue( -#if !PLATFORM_COMPACTFRAMEWORK - processorArchitecture.ToUpperInvariant(), -#else - processorArchitecture.ToUpper(), -#endif - out platformName)) - { return platformName; } } return null; @@ -460,11 +474,11 @@ #if !USE_INTEROP_DLL #if !PLATFORM_COMPACTFRAMEWORK private const string SQLITE_DLL = "System.Data.SQLite.dll"; #else - internal const string SQLITE_DLL = "SQLite.Interop.080.dll"; + internal const string SQLITE_DLL = "SQLite.Interop.081.dll"; #endif // PLATFORM_COMPACTFRAMEWORK #else private const string SQLITE_DLL = "SQLite.Interop.dll"; #endif // USE_INTEROP_DLL @@ -1116,10 +1130,11 @@ #else [DllImport(SQLITE_DLL, CharSet = CharSet.Unicode)] #endif internal static extern void sqlite3_result_text16(IntPtr context, string strName, int nLen, IntPtr pvReserved); +#if INTEROP_CODEC #if !PLATFORM_COMPACTFRAMEWORK [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)] #else [DllImport(SQLITE_DLL)] #endif @@ -1129,10 +1144,11 @@ [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)] #else [DllImport(SQLITE_DLL)] #endif internal static extern int sqlite3_rekey(IntPtr db, byte[] key, int keylen); +#endif #if !PLATFORM_COMPACTFRAMEWORK [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)] #else [DllImport(SQLITE_DLL)] @@ -1233,10 +1249,44 @@ #else [DllImport(SQLITE_DLL)] #endif internal static extern int sqlite3_file_control(IntPtr db, byte[] zDbName, int op, IntPtr pArg); +#if !PLATFORM_COMPACTFRAMEWORK + [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)] +#else + [DllImport(SQLITE_DLL)] +#endif + internal static extern IntPtr sqlite3_backup_init(IntPtr destDb, byte[] zDestName, IntPtr sourceDb, byte[] zSourceName); + +#if !PLATFORM_COMPACTFRAMEWORK + [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)] +#else + [DllImport(SQLITE_DLL)] +#endif + internal static extern int sqlite3_backup_step(IntPtr backup, int nPage); + +#if !PLATFORM_COMPACTFRAMEWORK + [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)] +#else + [DllImport(SQLITE_DLL)] +#endif + internal static extern int sqlite3_backup_finish(IntPtr backup); + +#if !PLATFORM_COMPACTFRAMEWORK + [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)] +#else + [DllImport(SQLITE_DLL)] +#endif + internal static extern int sqlite3_backup_remaining(IntPtr backup); + +#if !PLATFORM_COMPACTFRAMEWORK + [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)] +#else + [DllImport(SQLITE_DLL)] +#endif + internal static extern int sqlite3_backup_pagecount(IntPtr backup); #endregion } #if PLATFORM_COMPACTFRAMEWORK internal abstract class CriticalHandle : IDisposable @@ -1316,42 +1366,49 @@ public static implicit operator IntPtr(SQLiteConnectionHandle db) { return (db != null) ? db.handle : IntPtr.Zero; } - public static implicit operator SQLiteConnectionHandle(IntPtr db) - { - return new SQLiteConnectionHandle(db); - } - - private SQLiteConnectionHandle(IntPtr db) + internal SQLiteConnectionHandle(IntPtr db) : this() { SetHandle(db); } - internal SQLiteConnectionHandle() + private SQLiteConnectionHandle() : base(IntPtr.Zero) { } protected override bool ReleaseHandle() { try { - SQLiteBase.CloseConnection(this); +#if !PLATFORM_COMPACTFRAMEWORK + IntPtr localHandle = Interlocked.Exchange( + ref handle, IntPtr.Zero); + + if (localHandle != IntPtr.Zero) + SQLiteBase.CloseConnection(this, localHandle); #if DEBUG && !NET_COMPACT_20 try { Trace.WriteLine(String.Format( - "CloseConnection: {0}", handle)); + "CloseConnection: {0}", localHandle)); } catch { } #endif +#else + if (handle != IntPtr.Zero) + { + SQLiteBase.CloseConnection(this, handle); + SetHandle(IntPtr.Zero); + } +#endif #if DEBUG return true; #endif } @@ -1371,10 +1428,14 @@ catch { } #endif } + finally + { + SetHandleAsInvalid(); + } #if DEBUG return false; #else return true; #endif @@ -1382,10 +1443,17 @@ public override bool IsInvalid { get { return (handle == IntPtr.Zero); } } + +#if DEBUG + public override string ToString() + { + return handle.ToString(); + } +#endif } // Provides finalization support for unmanaged SQLite statements. internal class SQLiteStatementHandle : CriticalHandle { @@ -1392,42 +1460,49 @@ public static implicit operator IntPtr(SQLiteStatementHandle stmt) { return (stmt != null) ? stmt.handle : IntPtr.Zero; } - public static implicit operator SQLiteStatementHandle(IntPtr stmt) - { - return new SQLiteStatementHandle(stmt); - } - - private SQLiteStatementHandle(IntPtr stmt) + internal SQLiteStatementHandle(IntPtr stmt) : this() { SetHandle(stmt); } - internal SQLiteStatementHandle() + private SQLiteStatementHandle() : base(IntPtr.Zero) { } protected override bool ReleaseHandle() { try { - SQLiteBase.FinalizeStatement(this); +#if !PLATFORM_COMPACTFRAMEWORK + IntPtr localHandle = Interlocked.Exchange( + ref handle, IntPtr.Zero); + + if (localHandle != IntPtr.Zero) + SQLiteBase.FinalizeStatement(localHandle); #if DEBUG && !NET_COMPACT_20 try { Trace.WriteLine(String.Format( - "FinalizeStatement: {0}", handle)); + "FinalizeStatement: {0}", localHandle)); } catch { } #endif +#else + if (handle != IntPtr.Zero) + { + SQLiteBase.FinalizeStatement(handle); + SetHandle(IntPtr.Zero); + } +#endif #if DEBUG return true; #endif } @@ -1447,10 +1522,14 @@ catch { } #endif } + finally + { + SetHandleAsInvalid(); + } #if DEBUG return false; #else return true; #endif @@ -1458,7 +1537,108 @@ public override bool IsInvalid { get { return (handle == IntPtr.Zero); } } + +#if DEBUG + public override string ToString() + { + return handle.ToString(); + } +#endif + } + + // Provides finalization support for unmanaged SQLite backup objects. + internal class SQLiteBackupHandle : CriticalHandle + { + public static implicit operator IntPtr(SQLiteBackupHandle backup) + { + return (backup != null) ? backup.handle : IntPtr.Zero; + } + + internal SQLiteBackupHandle(IntPtr backup) + : this() + { + SetHandle(backup); + } + + private SQLiteBackupHandle() + : base(IntPtr.Zero) + { + } + + protected override bool ReleaseHandle() + { + try + { +#if !PLATFORM_COMPACTFRAMEWORK + IntPtr localHandle = Interlocked.Exchange( + ref handle, IntPtr.Zero); + + if (localHandle != IntPtr.Zero) + SQLiteBase.FinishBackup(localHandle); + +#if DEBUG && !NET_COMPACT_20 + try + { + Trace.WriteLine(String.Format( + "FinishBackup: {0}", localHandle)); + } + catch + { + } +#endif +#else + if (handle != IntPtr.Zero) + { + SQLiteBase.FinishBackup(handle); + SetHandle(IntPtr.Zero); + } +#endif + +#if DEBUG + return true; +#endif + } +#if DEBUG && !NET_COMPACT_20 + catch (SQLiteException e) +#else + catch (SQLiteException) +#endif + { +#if DEBUG && !NET_COMPACT_20 + try + { + Trace.WriteLine(String.Format( + "FinishBackup: {0}, exception: {1}", + handle, e)); + } + catch + { + } +#endif + } + finally + { + SetHandleAsInvalid(); + } +#if DEBUG + return false; +#else + return true; +#endif + } + + public override bool IsInvalid + { + get { return (handle == IntPtr.Zero); } + } + +#if DEBUG + public override string ToString() + { + return handle.ToString(); + } +#endif } } ADDED Tests/backup.eagle Index: Tests/backup.eagle ================================================================== --- /dev/null +++ Tests/backup.eagle @@ -0,0 +1,231 @@ +############################################################################### +# +# backup.eagle -- +# +# Written by Joe Mistachkin. +# Released to the public domain, use at your own risk! +# +############################################################################### + +package require Eagle +package require Eagle.Library +package require Eagle.Test + +runTestPrologue + +############################################################################### + +package require System.Data.SQLite.Test +runSQLiteTestPrologue + +############################################################################### + +set params(pages) [list -1 -1 0 0 1 1 2 2 1000 1000] + +set params(callbacks) [list null "new SQLiteBackupCallback(BackupCallback)" \ + null "new SQLiteBackupCallback(BackupCallback)" \ + null "new SQLiteBackupCallback(BackupCallback)" \ + null "new SQLiteBackupCallback(BackupCallback)" \ + null "new SQLiteBackupCallback(BackupCallback)"] + +set params(results) [list \ + "0 \\{1 1048576 1048576 1048576 1048576 1048576 1048576 1048576 1048576\ + 1048576 1048576 10\\} 0\$" \ + "0 \\{1 1048576 1048576 1048576 1048576 1048576 1048576 1048576 1048576\ + 1048576 1048576 10\\} 0\$" \ + "1 \\{System\\.Reflection\\.TargetInvocationException: Exception has been\ + thrown by the target of an invocation\\. --->\ + System\\.Data\\.SQLite\\.SQLiteException: SQLite error\\r\\nno such table:\ + t1\\r\\n.*?" \ + "1 \\{System\\.Reflection\\.TargetInvocationException: Exception has been\ + thrown by the target of an invocation\\. --->\ + System\\.Data\\.SQLite\\.SQLiteException: SQLite error\\r\\nno such table:\ + t1\\r\\n.*?" \ + "0 \\{1 1048576 1048576 1048576 1048576 1048576 1048576 1048576 1048576\ + 1048576 1048576 10\\} 0\$" \ + "0 \\{1 1048576 1048576 1048576 1048576 1048576 1048576 1048576 1048576\ + 1048576 1048576 10\\} 10283\$" \ + "0 \\{1 1048576 1048576 1048576 1048576 1048576 1048576 1048576 1048576\ + 1048576 1048576 10\\} 0\$" \ + "1 \\{System\\.Reflection\\.TargetInvocationException: Exception has been\ + thrown by the target of an invocation\\. --->\ + System\\.Data\\.SQLite\\.SQLiteException: SQLite error\\r\\nno such table:\ + t1\\r\\n.*?" \ + "0 \\{1 1048576 1048576 1048576 1048576 1048576 1048576 1048576 1048576\ + 1048576 1048576 10\\} \\{\\}\$" \ + "0 \\{1 1048576 1048576 1048576 1048576 1048576 1048576 1048576 1048576\ + 1048576 1048576 10\\} \\{System\\.Data\\.SQLite\\.SQLiteConnection main\ + System\\.Data\\.SQLite\\.SQLiteConnection main 1000 9284 10284 False\ + System\\.Data\\.SQLite\\.SQLiteConnection main\ + System\\.Data\\.SQLite\\.SQLiteConnection main 1000 8284 10284 False\ + System\\.Data\\.SQLite\\.SQLiteConnection main\ + System\\.Data\\.SQLite\\.SQLiteConnection main 1000 7284 10284 False\ + System\\.Data\\.SQLite\\.SQLiteConnection main\ + System\\.Data\\.SQLite\\.SQLiteConnection main 1000 6284 10284 False\ + System\\.Data\\.SQLite\\.SQLiteConnection main\ + System\\.Data\\.SQLite\\.SQLiteConnection main 1000 5284 10284 False\ + System\\.Data\\.SQLite\\.SQLiteConnection main\ + System\\.Data\\.SQLite\\.SQLiteConnection main 1000 4284 10284 False\ + System\\.Data\\.SQLite\\.SQLiteConnection main\ + System\\.Data\\.SQLite\\.SQLiteConnection main 1000 3284 10284 False\ + System\\.Data\\.SQLite\\.SQLiteConnection main\ + System\\.Data\\.SQLite\\.SQLiteConnection main 1000 2284 10284 False\ + System\\.Data\\.SQLite\\.SQLiteConnection main\ + System\\.Data\\.SQLite\\.SQLiteConnection main 1000 1284 10284 False\ + System\\.Data\\.SQLite\\.SQLiteConnection main\ + System\\.Data\\.SQLite\\.SQLiteConnection main 1000 284 10284 False\\}\$"] + +############################################################################### + +for {set i 0} {$i < [llength $params(pages)]} {incr i} { + set pages [lindex $params(pages) $i] + set callback [lindex $params(callbacks) $i] + + runTest {test [appendArgs backup-1. $i] {BackupDatabase method} -setup { + setupDb [set fileName(1) :memory:] "" "" "" "" "" false memDb + setupDb [set fileName(2) [appendArgs backup-1. $i .db]] + } -body { + set id [object invoke Interpreter.GetActive NextId] + set dataSource [file join [getDatabaseDirectory] $fileName(2)] + + sql execute $memDb { + CREATE TABLE t1(x TEXT); + } + + for {set index 0} {$index < 10} {incr index} { + sql execute $memDb [subst { + INSERT INTO t1 (x) VALUES('[string repeat ! 1048576]'); + }] + } + + set memSource [object invoke -flags +NonPublic -objectflags +NoDispose \ + Interpreter.GetActive.connections get_Item $memDb] + + unset -nocomplain results errors + + set code [compileCSharpWith [subst { + using System; + using System.Data.SQLite; + using System.Text; + using Eagle._Components.Public; + + namespace _Dynamic${id} + { + public static class Test${id} + { + public static int count = 0; + public static readonly StringBuilder results = new StringBuilder(); + + ///////////////////////////////////////////////////////////////////// + + public static bool BackupCallback( + SQLiteConnection source, + string sourceName, + SQLiteConnection destination, + string destinationName, + int pages, + int remainingPages, + int totalPages, + bool retry + ) + { + results.AppendFormat("{0} {1} {2} {3} {4} {5} {6} {7} ", source, + sourceName, destination, destinationName, pages, remainingPages, + totalPages, retry); + + count++; + + return (pages != 2); + } + + ///////////////////////////////////////////////////////////////////// + + public static string BackupAndGetData( + Interpreter interpreter, + SQLiteConnection source + ) + { + using (SQLiteConnection destination = new SQLiteConnection( + "Data Source=${dataSource};")) + { + destination.Open(); + + int pages = ${pages}; + + source.BackupDatabase(destination, "main", "main", pages, + ${callback}, 0); + + ReturnCode code; + Result error = null; + + code = interpreter.SetVariableValue( + VariableFlags.GlobalOnly, "callbackResults", (pages > 2) ? + results.ToString().Trim() : count.ToString(), null, + ref error); + + if (code != ReturnCode.Ok) + Utility.Complain(interpreter, code, error); + + using (SQLiteCommand command = new SQLiteCommand( + "SELECT length(x) FROM t1;", destination)) + { + using (SQLiteDataReader dataReader = command.ExecuteReader()) + { + StringBuilder builder = new StringBuilder(); + int rowCount = 0; + + builder.Append(dataReader.FieldCount); + builder.Append(' '); + + while (dataReader.Read()) + { + builder.Append(dataReader.GetInt64(0)); + builder.Append(' '); + rowCount++; + } + + builder.Append(rowCount); + return builder.ToString(); + } + } + } + } + + ///////////////////////////////////////////////////////////////////// + + public static void Main() + { + // do nothing. + } + } + } + }] true true true results errors [list System.Data.SQLite.dll Eagle.dll]] + + set callbackResults [list] + + list $code $results \ + [expr {[info exists errors] ? $errors : ""}] \ + [expr {$code eq "Ok" ? [catch { + object invoke _Dynamic${id}.Test${id} BackupAndGetData "" $memSource + } result] : [set result ""]}] $result $callbackResults + } -cleanup { + cleanupDb $fileName(2) + cleanupDb $fileName(1) memDb + + unset -nocomplain result results errors code index memSource dataSource \ + id memDb db fileName callbackResults + } -constraints \ +{eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} \ +-match regexp -result [appendArgs \ +"^Ok System#CodeDom#Compiler#CompilerResults#\\d+ \\{\\} " \ +[lindex $params(results) $i]]} +} + +############################################################################### + +unset -nocomplain i params pages callback + +############################################################################### + +runSQLiteTestEpilogue +runTestEpilogue Index: Tests/basic.eagle ================================================================== --- Tests/basic.eagle +++ Tests/basic.eagle @@ -22,19 +22,31 @@ # # NOTE: Setup the variables that refer to the various files required by the # tests in this file. # +set systemDataSQLiteDllFile [getBuildFileName System.Data.SQLite.dll] +set systemDataSQLiteLinqDllFile [getBuildFileName System.Data.SQLite.Linq.dll] set testExeFile [getBuildFileName test.exe] set testLinqExeFile [getBuildFileName testlinq.exe] set testLinqOutFile [file nativename [file join $path testlinq.out]] set northwindEfDbFile [file nativename [file join [file dirname $path] \ testlinq northwindEF.db]] # # NOTE: Setup the test constraints specific to the tests in this file. # +if {![haveConstraint [appendArgs file_ \ + [file tail $systemDataSQLiteDllFile]]]} then { + checkForFile $test_channel $systemDataSQLiteDllFile +} + +if {![haveConstraint [appendArgs file_ \ + [file tail $systemDataSQLiteLinqDllFile]]]} then { + checkForFile $test_channel $systemDataSQLiteLinqDllFile +} + if {![haveConstraint [appendArgs file_ [file tail $testExeFile]]]} then { checkForFile $test_channel $testExeFile } if {![haveConstraint [appendArgs file_ [file tail $testLinqExeFile]]]} then { @@ -76,11 +88,11 @@ list $code [expr {$code == 0 ? "" : $error}] } -cleanup { cleanupDb $fileName unset -nocomplain code output error fileName -} -constraints {eagle file_test.exe} -result {0 {}}} +} -constraints {eagle file_System.Data.SQLite.dll file_test.exe} -result {0 {}}} ############################################################################### runTest {test data-1.2 {unit tests from the 'testlinq' project} -setup { # @@ -115,12 +127,12 @@ } -cleanup { catch {object invoke Console OutputEncoding $savedEncoding} unset -nocomplain code output error savedEncoding encoding } -constraints \ -{eagle monoToDo file_testlinq.exe file_northwindEF.db file_testlinq.out} \ --result {0 True {}}} +{eagle monoToDo file_System.Data.SQLite.dll file_System.Data.SQLite.Linq.dll\ +file_testlinq.exe file_northwindEF.db file_testlinq.out} -result {0 True {}}} ############################################################################### runTest {test data-1.3 {SELECT scalar/reader, CREATE, INSERT} -setup { setupDb [set fileName data-1.3.db] @@ -163,11 +175,11 @@ using System.Data; using System.Data.SQLite; namespace _Dynamic${id} { - public class Test${id} + public static class Test${id} { public static DataTable GetReservedWords() { using (SQLiteConnection connection = new SQLiteConnection( "Data Source=${dataSource};")) @@ -193,10 +205,11 @@ [expr {$code eq "Ok" ? [catch { object invoke _Dynamic${id}.Test${id} GetReservedWords } result] : [set result ""]}] $result } -cleanup { cleanupDb $fileName + unset -nocomplain result results errors code dataSource id db fileName } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} \ -match regexp -result {^Ok System#CodeDom#Compiler#CompilerResults#\d+ \{\} 0\ System#Data#DataTable#\d+$}} @@ -225,11 +238,11 @@ using System.Data; using System.Data.SQLite; namespace _Dynamic${id} { - public class Test${id} + public static class Test${id} { public static DataRowCollection GetForeignKeys() { using (SQLiteConnection connection = new SQLiteConnection( "Data Source=${dataSource};")) @@ -304,11 +317,11 @@ using System.Data; using System.Data.SQLite; namespace _Dynamic${id} { - public class Test${id} + public static class Test${id} { public static bool TestSetAvRetry( ref int count, ref int interval ) @@ -413,11 +426,11 @@ using System.Data; using System.Data.SQLite; namespace _Dynamic${id} { - public class Test${id} + public static class Test${id} { public static void Main() { using (SQLiteConnection connection = new SQLiteConnection( "Data Source=${dataSource};")) @@ -471,11 +484,11 @@ using System.Data; using System.Data.SQLite; namespace _Dynamic${id} { - public class Test${id} + public static class Test${id} { public static void Main() { using (SQLiteConnection connection = new SQLiteConnection( "Data Source=${dataSource};")) @@ -532,11 +545,11 @@ using System.Data; using System.Data.SQLite; namespace _Dynamic${id} { - public class Test${id} + public static class Test${id} { public static void Main() { using (SQLiteConnection connection = new SQLiteConnection( "Data Source=${dataSource};")) @@ -855,11 +868,11 @@ set code [compileCSharpWith [subst { using System.Data.SQLite; namespace _Dynamic${id} { - public class Test${id} + public static class Test${id} { public static string GetConnectionString( string format, string kind ) @@ -905,13 +918,13 @@ } -cleanup { unset -nocomplain result results errors code id } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -match \ regexp -result {^Ok System#CodeDom#Compiler#CompilerResults#\d+ \{\} 0 \{Date\ -Source=test\.db\} 0 \{Date Source=test\.db;DateTimeFormat=ISO8601\} 0 \{Date\ -Source=test\.db;DateTimeKind=Unspecified\} 0 \{Date\ -Source=test\.db;DateTimeFormat=ISO8601;DateTimeKind=Utc\}$}} +Source=test\.db\} 0 \{Date Source=test\.db;DateTimeFormat=(?:Default|ISO8601)\}\ +0 \{Date Source=test\.db;DateTimeKind=Unspecified\} 0 \{Date\ +Source=test\.db;DateTimeFormat=(?:Default|ISO8601);DateTimeKind=Utc\}$}} ############################################################################### runTest {test data-1.16 {SQLiteConnectionStringBuilder properties} -body { set id [object invoke Interpreter.GetActive NextId] @@ -923,11 +936,11 @@ using System.Data.SQLite; using System.Reflection; namespace _Dynamic${id} { - public class Test${id} + public static class Test${id} { public static string GetConnectionString( string key, string value, string propertyName @@ -1013,11 +1026,11 @@ \{4096, Page Size=4096\} 0 \{1024, Max Page Count=1024\} 0 \{8192, Cache\ Size=8192\} 0 \{UnixEpoch, DateTimeFormat=UnixEpoch\} 0 \{Utc,\ DateTimeKind=Utc\} 0 \{sqlite_schema, BaseSchemaName=sqlite_schema\} 0\ \{Memory, Journal Mode=Memory\} 0 \{Serializable, Default\ IsolationLevel=Serializable\} 0 \{False, Foreign Keys=False\} 0\ -\{LogCallbackException, Flags=LogCallbackException\}$}} +\{LogCallbackException, Flags=(?:Default|LogCallbackException)\}$}} ############################################################################### runTest {test data-1.17 {SQLiteConvert ToDateTime (Julian Day)} -body { set dateTime [object invoke System.Data.SQLite.SQLiteConvert ToDateTime \ @@ -1379,11 +1392,32 @@ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ {{26 26} {zebra zebra}}} ############################################################################### -unset -nocomplain testExeFile testLinqExeFile northwindEfDbFile testLinqOutFile +runTest {test data-1.26 {LINQ ISQLiteSchemaExtensions.BuildTempSchema} -setup { + setupDb [set fileName data-1.26.db] +} -body { + set connection [object invoke -flags +NonPublic -objectflags +NoDispose \ + Interpreter.GetActive.connections Item $db] + + set providerServices [object invoke -flags +NonPublic \ + System.Data.SQLite.SQLiteProviderServices Instance] + + object invoke -flags +NonPublic -type \ + System.Data.SQLite.ISQLiteSchemaExtensions $providerServices \ + BuildTempSchema $connection +} -cleanup { + cleanupDb $fileName + + unset -nocomplain providerServices connection db fileName +} -constraints {eagle System.Data.SQLite System.Data.SQLite.Linq} -result {}} + +############################################################################### + +unset -nocomplain systemDataSQLiteDllFile systemDataSQLiteLinqDllFile \ + testExeFile testLinqExeFile northwindEfDbFile testLinqOutFile ############################################################################### runSQLiteTestEpilogue runTestEpilogue Index: Tests/common.eagle ================================================================== --- Tests/common.eagle +++ Tests/common.eagle @@ -363,10 +363,33 @@ tputs $channel [appendArgs "yes (" $version " " $sourceId ")\n"] } else { tputs $channel no\n } } + + proc checkForSQLiteDefineConstant { channel name } { + tputs $channel [appendArgs \ + "---- checking for System.Data.SQLite define constant \"" $name \ + "\"... "] + + if {[catch {object invoke -flags +NonPublic System.Data.SQLite.SQLite3 \ + DefineConstants} defineConstants] == 0} then { + if {[lsearch -exact -nocase $defineConstants $name] != -1} then { + # + # NOTE: Yes, this define constant was enabled when the managed + # assembly was compiled. + # + addConstraint [appendArgs defineConstant.System.Data.SQLite. $name] + + tputs $channel yes\n + } else { + tputs $channel no\n + } + } else { + tputs $channel error\n + } + } proc getDateTimeFormat {} { # # NOTE: This procedure simply returns the "default" DateTime format used # by the test suite. @@ -444,26 +467,40 @@ # NOTE: Evaluate the constructed [compileCSharp] command and return the # result. # eval $command } + + proc isMemoryDb { fileName } { + # + # NOTE: Is the specified database file name really an in-memory database? + # + return [expr {$fileName eq ":memory:"}] + } proc setupDb { fileName {mode ""} {dateTimeFormat ""} {dateTimeKind ""} {flags ""} {extra ""} {delete true} {varName db} } { + # + # NOTE: First, see if the caller has requested an in-memory database. + # + set isMemory [isMemoryDb $fileName] + # # NOTE: For now, all test databases used by the test suite are placed into # the temporary directory. Each database used by a test should be # cleaned up by that test using the "cleanupDb" procedure, below. # - set fileName [file join [getDatabaseDirectory] [file tail $fileName]] + if {!$isMemory} then { + set fileName [file join [getDatabaseDirectory] [file tail $fileName]] + } # # NOTE: By default, delete any pre-existing database with the same file # name if it currently exists. # - if {$delete && [file exists $fileName]} then { + if {!$isMemory && $delete && [file exists $fileName]} then { # # NOTE: Attempt to delete any pre-existing database with the same file # name. # if {[catch {file delete $fileName} error]} then { @@ -576,20 +613,27 @@ tputs $::test_channel [appendArgs \ "==== WARNING: failed to close database \"" $db "\", error: " \ \n\t $error \n] } + # + # NOTE: First, see if the caller has requested an in-memory database. + # + set isMemory [isMemoryDb $fileName] + # # NOTE: Build the full path to the database file name. For now, all test # database files are stored in the temporary directory. # - set fileName [file join [getDatabaseDirectory] [file tail $fileName]] + if {!$isMemory} then { + set fileName [file join [getDatabaseDirectory] [file tail $fileName]] + } # # NOTE: Check if the file still exists. # - if {[file exists $fileName]} then { + if {!$isMemory && [file exists $fileName]} then { # # NOTE: Skip deleting database files if somebody sets the global # variable to prevent it. # if {![info exists ::no(cleanupDb)]} then { @@ -761,13 +805,20 @@ # # NOTE: Skip trying to delete any files if we are so instructed. # if {![info exists ::no(deleteSqliteFiles)]} then { tryDeleteAssembly sqlite3.dll + removeConstraint file_sqlite3.dll + tryDeleteAssembly SQLite.Interop.dll + removeConstraint file_SQLite.Interop.dll + tryDeleteAssembly System.Data.SQLite.dll + removeConstraint file_System.Data.SQLite.dll + tryDeleteAssembly System.Data.SQLite.Linq.dll + removeConstraint file_System.Data.SQLite.Linq.dll } # # NOTE: Skip trying to copy any files if we are so instructed. # @@ -812,19 +863,40 @@ tputs $::test_channel [appendArgs \ "---- found assembly: " $assembly \n] } } + catch { + tputs $::test_channel \ + "---- define constants for \"System.Data.SQLite\"... " + + if {[catch {object invoke -flags +NonPublic \ + System.Data.SQLite.SQLite3 DefineConstants} \ + defineConstants] == 0} then { + tputs $::test_channel [appendArgs [formatList [lsort \ + $defineConstants]] \n] + } else { + tputs $::test_channel unknown\n + } + } + # # NOTE: Now, we need to know if the SQLite core library is available # (i.e. because the managed-only System.Data.SQLite assembly can # load without it; however, it cannot do anything useful without # it). If we are using the mixed-mode assembly and we already # found it (above), this should always succeed. # checkForSQLite $::test_channel + # + # NOTE: Attempt to determine if the custom extension functions were + # compiled into the SQLite interop assembly. + # + checkForSQLiteDefineConstant $::test_channel \ + INTEROP_EXTENSION_FUNCTIONS + # # NOTE: Report the resource usage prior to running any tests. # reportSQLiteResources $::test_channel @@ -831,18 +903,32 @@ # # NOTE: Show the active test constraints. # tputs $::test_channel [appendArgs "---- constraints: " \ [formatList [lsort [getConstraints]]] \n] + + # + # NOTE: Show when our tests actually began (now). + # + tputs $::test_channel [appendArgs \ + "---- System.Data.SQLite tests began at " \ + [clock format [clock seconds]] \n] } } proc runSQLiteTestEpilogue {} { # # NOTE: Skip running our custom epilogue if the main one has been skipped. # if {![info exists ::no(epilogue.eagle)]} then { + # + # NOTE: Show when our tests actually ended (now). + # + tputs $::test_channel [appendArgs \ + "---- System.Data.SQLite tests ended at " \ + [clock format [clock seconds]] \n] + # # NOTE: Also report the resource usage after running the tests. # reportSQLiteResources $::test_channel } Index: Tests/tkt-00f86f9739.eagle ================================================================== --- Tests/tkt-00f86f9739.eagle +++ Tests/tkt-00f86f9739.eagle @@ -22,17 +22,29 @@ # # NOTE: Setup the variables that refer to the various files required by the # tests in this file. # +set systemDataSQLiteDllFile [getBuildFileName System.Data.SQLite.dll] +set systemDataSQLiteLinqDllFile [getBuildFileName System.Data.SQLite.Linq.dll] set testLinqExeFile [getBuildFileName testlinq.exe] set northwindEfDbFile [file nativename [file join [file dirname $path] \ testlinq northwindEF.db]] # # NOTE: Setup the test constraints specific to the tests in this file. # +if {![haveConstraint [appendArgs file_ \ + [file tail $systemDataSQLiteDllFile]]]} then { + checkForFile $test_channel $systemDataSQLiteDllFile +} + +if {![haveConstraint [appendArgs file_ \ + [file tail $systemDataSQLiteLinqDllFile]]]} then { + checkForFile $test_channel $systemDataSQLiteLinqDllFile +} + if {![haveConstraint [appendArgs file_ [file tail $testLinqExeFile]]]} then { checkForFile $test_channel $testLinqExeFile } if {![haveConstraint [appendArgs file_ [file tail $northwindEfDbFile]]]} then { @@ -67,17 +79,21 @@ } set result } -cleanup { unset -nocomplain code output error result value -} -constraints {eagle monoToDo file_testlinq.exe file_northwindEF.db} -result \ -{0 {} 0 {DRACD OLDWO RATTC} 0 {ALFKI CACTU CHOPS FOLKO GALED KOENE LILAS MAGAA\ -MAISD OCEAN RANCH SAVEA THECR} 0 {} 0 {} 0 {} 0 {}}} +} -constraints \ +{eagle monoToDo defineConstant.System.Data.SQLite.INTEROP_EXTENSION_FUNCTIONS\ +file_System.Data.SQLite.dll file_System.Data.SQLite.Linq.dll file_testlinq.exe\ +file_northwindEF.db} -result {0 {} 0 {DRACD OLDWO RATTC} 0 {ALFKI CACTU CHOPS\ +FOLKO GALED KOENE LILAS MAGAA MAISD OCEAN RANCH SAVEA THECR} 0 {} 0 {} 0 {} 0\ +{}}} ############################################################################### -unset -nocomplain testLinqExeFile northwindEfDbFile +unset -nocomplain systemDataSQLiteDllFile systemDataSQLiteLinqDllFile \ + testLinqExeFile northwindEfDbFile ############################################################################### runSQLiteTestEpilogue runTestEpilogue Index: Tests/tkt-343d392b51.eagle ================================================================== --- Tests/tkt-343d392b51.eagle +++ Tests/tkt-343d392b51.eagle @@ -118,11 +118,11 @@ using System.Data; using System.Data.SQLite; namespace _Dynamic${id} { - public class Test${id} + public static class Test${id} { public static void Main() { using (SQLiteConnection connection = new SQLiteConnection( "Data Source=${dataSource};")) @@ -224,11 +224,11 @@ using System.Data; using System.Data.SQLite; namespace _Dynamic${id} { - public class Test${id} + public static class Test${id} { public static void Main() { using (SQLiteConnection connection = new SQLiteConnection( "Data Source=${dataSource};DateTimeFormat=JulianDay;")) @@ -371,11 +371,11 @@ using System.Data; using System.Data.SQLite; namespace _Dynamic${id} { - public class Test${id} + public static class Test${id} { public static void Main() { using (SQLiteConnection connection = new SQLiteConnection( "Data Source=${dataSource};")) Index: Tests/tkt-448d663d11.eagle ================================================================== --- Tests/tkt-448d663d11.eagle +++ Tests/tkt-448d663d11.eagle @@ -23,10 +23,11 @@ runTest {test tkt-448d663d11-1.1 {missing journal mode, new db} -body { setupDb [set fileName tkt-448d663d11-1.1.db] sql execute -execute scalar $db "PRAGMA journal_mode;" } -cleanup { cleanupDb $fileName + unset -nocomplain db fileName } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ {delete}} @@ -38,10 +39,11 @@ [file join [getDatabaseDirectory] $fileName] setupDb $fileName "" "" "" "" "" false sql execute -execute scalar $db "PRAGMA journal_mode;" } -cleanup { cleanupDb $fileName + unset -nocomplain db fileName } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ {wal}} @@ -53,10 +55,11 @@ [file join [getDatabaseDirectory] $fileName] setupDb $fileName "" "" "" "" "" false sql execute -execute scalar $db "PRAGMA journal_mode;" } -cleanup { cleanupDb $fileName + unset -nocomplain db fileName } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ {delete}} @@ -65,10 +68,11 @@ runTest {test tkt-448d663d11-1.4 {'Default' journal mode, new db} -body { setupDb [set fileName tkt-448d663d11-1.4.db] Default sql execute -execute scalar $db "PRAGMA journal_mode;" } -cleanup { cleanupDb $fileName + unset -nocomplain db fileName } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ {delete}} @@ -80,10 +84,11 @@ [file join [getDatabaseDirectory] $fileName] setupDb $fileName Default "" "" "" "" false sql execute -execute scalar $db "PRAGMA journal_mode;" } -cleanup { cleanupDb $fileName + unset -nocomplain db fileName } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ {wal}} @@ -95,10 +100,11 @@ [file join [getDatabaseDirectory] $fileName] setupDb $fileName Default "" "" "" "" false sql execute -execute scalar $db "PRAGMA journal_mode;" } -cleanup { cleanupDb $fileName + unset -nocomplain db fileName } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ {delete}} @@ -107,10 +113,11 @@ runTest {test tkt-448d663d11-1.7 {'Delete' journal mode, new db} -body { setupDb [set fileName tkt-448d663d11-1.7.db] Delete sql execute -execute scalar $db "PRAGMA journal_mode;" } -cleanup { cleanupDb $fileName + unset -nocomplain db fileName } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ {delete}} @@ -122,10 +129,11 @@ [file join [getDatabaseDirectory] $fileName] setupDb $fileName Delete "" "" "" "" false sql execute -execute scalar $db "PRAGMA journal_mode;" } -cleanup { cleanupDb $fileName + unset -nocomplain db fileName } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ {delete}} @@ -137,10 +145,11 @@ [file join [getDatabaseDirectory] $fileName] setupDb $fileName Delete "" "" "" "" false sql execute -execute scalar $db "PRAGMA journal_mode;" } -cleanup { cleanupDb $fileName + unset -nocomplain db fileName } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ {delete}} @@ -149,10 +158,11 @@ runTest {test tkt-448d663d11-1.10 {'Persist' journal mode, new db} -body { setupDb [set fileName tkt-448d663d11-1.10.db] Persist sql execute -execute scalar $db "PRAGMA journal_mode;" } -cleanup { cleanupDb $fileName + unset -nocomplain db fileName } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ {persist}} @@ -161,10 +171,11 @@ runTest {test tkt-448d663d11-1.11 {'Off' journal mode, new db} -body { setupDb [set fileName tkt-448d663d11-1.11.db] Off sql execute -execute scalar $db "PRAGMA journal_mode;" } -cleanup { cleanupDb $fileName + unset -nocomplain db fileName } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ {off}} @@ -173,10 +184,11 @@ runTest {test tkt-448d663d11-1.12 {'Truncate' journal mode, new db} -body { setupDb [set fileName tkt-448d663d11-1.12.db] Truncate sql execute -execute scalar $db "PRAGMA journal_mode;" } -cleanup { cleanupDb $fileName + unset -nocomplain db fileName } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ {truncate}} @@ -185,10 +197,11 @@ runTest {test tkt-448d663d11-1.13 {'Memory' journal mode, new db} -body { setupDb [set fileName tkt-448d663d11-1.13.db] Memory sql execute -execute scalar $db "PRAGMA journal_mode;" } -cleanup { cleanupDb $fileName + unset -nocomplain db fileName } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ {memory}} @@ -197,10 +210,11 @@ runTest {test tkt-448d663d11-1.14 {'Wal' journal mode, new db} -body { setupDb [set fileName tkt-448d663d11-1.14.db] Wal sql execute -execute scalar $db "PRAGMA journal_mode;" } -cleanup { cleanupDb $fileName + unset -nocomplain db fileName } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ {wal}} @@ -212,10 +226,11 @@ [file join [getDatabaseDirectory] $fileName] setupDb $fileName Wal "" "" "" "" false sql execute -execute scalar $db "PRAGMA journal_mode;" } -cleanup { cleanupDb $fileName + unset -nocomplain db fileName } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ {wal}} @@ -227,10 +242,11 @@ [file join [getDatabaseDirectory] $fileName] setupDb $fileName Wal "" "" "" "" false sql execute -execute scalar $db "PRAGMA journal_mode;" } -cleanup { cleanupDb $fileName + unset -nocomplain db fileName } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ {wal}} @@ -239,10 +255,11 @@ runTest {test tkt-448d663d11-1.17 {'Bad' journal mode, new db} -body { setupDb [set fileName tkt-448d663d11-1.17.db] Bad sql execute -execute scalar $db "PRAGMA journal_mode;" } -cleanup { cleanupDb $fileName + unset -nocomplain db fileName } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ {delete}} @@ -254,10 +271,11 @@ [file join [getDatabaseDirectory] $fileName] setupDb $fileName Bad "" "" "" "" false sql execute -execute scalar $db "PRAGMA journal_mode;" } -cleanup { cleanupDb $fileName + unset -nocomplain db fileName } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ {delete}} @@ -269,14 +287,15 @@ [file join [getDatabaseDirectory] $fileName] setupDb $fileName Bad "" "" "" "" false sql execute -execute scalar $db "PRAGMA journal_mode;" } -cleanup { cleanupDb $fileName + unset -nocomplain db fileName } -constraints \ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \ {wal}} ############################################################################### runSQLiteTestEpilogue runTestEpilogue Index: Tests/tkt-59edc1018b.eagle ================================================================== --- Tests/tkt-59edc1018b.eagle +++ Tests/tkt-59edc1018b.eagle @@ -22,17 +22,29 @@ # # NOTE: Setup the variables that refer to the various files required by the # tests in this file. # +set systemDataSQLiteDllFile [getBuildFileName System.Data.SQLite.dll] +set systemDataSQLiteLinqDllFile [getBuildFileName System.Data.SQLite.Linq.dll] set testLinqExeFile [getBuildFileName testlinq.exe] set northwindEfDbFile [file nativename [file join [file dirname $path] \ testlinq northwindEF.db]] # # NOTE: Setup the test constraints specific to the tests in this file. # +if {![haveConstraint [appendArgs file_ \ + [file tail $systemDataSQLiteDllFile]]]} then { + checkForFile $test_channel $systemDataSQLiteDllFile +} + +if {![haveConstraint [appendArgs file_ \ + [file tail $systemDataSQLiteLinqDllFile]]]} then { + checkForFile $test_channel $systemDataSQLiteLinqDllFile +} + if {![haveConstraint [appendArgs file_ [file tail $testLinqExeFile]]]} then { checkForFile $test_channel $testLinqExeFile } if {![haveConstraint [appendArgs file_ [file tail $northwindEfDbFile]]]} then { @@ -67,17 +79,20 @@ } set result } -cleanup { unset -nocomplain code output error result value -} -constraints {eagle monoToDo file_testlinq.exe file_northwindEF.db} -result \ -{0 {} 0 {FURIB GALED GODOS LAZYK LINOD PRINI REGGC WOLZA} 0 {} 0 ERNSH 0 {} 0\ -{AROUT BSBEV CONSH EASTC NORTS SEVES} 0 {}}} +} -constraints \ +{eagle monoToDo defineConstant.System.Data.SQLite.INTEROP_EXTENSION_FUNCTIONS\ +file_System.Data.SQLite.dll file_System.Data.SQLite.Linq.dll file_testlinq.exe\ +file_northwindEF.db} -result {0 {} 0 {FURIB GALED GODOS LAZYK LINOD PRINI REGGC\ +WOLZA} 0 {} 0 ERNSH 0 {} 0 {AROUT BSBEV CONSH EASTC NORTS SEVES} 0 {}}} ############################################################################### -unset -nocomplain testLinqExeFile northwindEfDbFile +unset -nocomplain systemDataSQLiteDllFile systemDataSQLiteLinqDllFile \ + testLinqExeFile northwindEfDbFile ############################################################################### runSQLiteTestEpilogue runTestEpilogue Index: Tests/tkt-72905c9a77.eagle ================================================================== --- Tests/tkt-72905c9a77.eagle +++ Tests/tkt-72905c9a77.eagle @@ -53,11 +53,11 @@ using System.Text; using System.Threading; namespace _Dynamic${id} { - public class Test${id} + public static class Test${id} { public static string GetTraceOutput() { // // NOTE: Create a memory stream to capture all the trace output for Index: Tests/tkt-7e3fa93744.eagle ================================================================== --- Tests/tkt-7e3fa93744.eagle +++ Tests/tkt-7e3fa93744.eagle @@ -90,11 +90,11 @@ using System.Data; using System.Data.SQLite; namespace _Dynamic${id} { - public class Test${id} + public static class Test${id} { public static int Main() { using (SQLiteConnection connection = new SQLiteConnection( "Data Source=${dataSource};")) Index: Tests/tkt-8b7d179c3c.eagle ================================================================== --- Tests/tkt-8b7d179c3c.eagle +++ Tests/tkt-8b7d179c3c.eagle @@ -22,17 +22,29 @@ # # NOTE: Setup the variables that refer to the various files required by the # tests in this file. # +set systemDataSQLiteDllFile [getBuildFileName System.Data.SQLite.dll] +set systemDataSQLiteLinqDllFile [getBuildFileName System.Data.SQLite.Linq.dll] set testLinqExeFile [getBuildFileName testlinq.exe] set northwindEfDbFile [file nativename [file join [file dirname $path] \ testlinq northwindEF.db]] # # NOTE: Setup the test constraints specific to the tests in this file. # +if {![haveConstraint [appendArgs file_ \ + [file tail $systemDataSQLiteDllFile]]]} then { + checkForFile $test_channel $systemDataSQLiteDllFile +} + +if {![haveConstraint [appendArgs file_ \ + [file tail $systemDataSQLiteLinqDllFile]]]} then { + checkForFile $test_channel $systemDataSQLiteLinqDllFile +} + if {![haveConstraint [appendArgs file_ [file tail $testLinqExeFile]]]} then { checkForFile $test_channel $testLinqExeFile } if {![haveConstraint [appendArgs file_ [file tail $northwindEfDbFile]]]} then { @@ -67,30 +79,32 @@ } set result } -cleanup { unset -nocomplain code output error result pageSize -} -constraints {eagle monoToDo file_testlinq.exe file_northwindEF.db} -result \ -{0 {} 0 {DRACD RATTC OLDWO GALED LILAS MAGAA ALFKI CHOPS SAVEA KOENE MAISD\ -FOLKO CACTU OCEAN RANCH THECR GOURL GROSR SUPRD HUNGO ISLAT QUICK HUNGC GREAL\ -LEHMS RICSU ERNSH WILMK LINOD TRAIH SIMOB OTTIK SPLIR MORGK FOLIG FURIB PRINI\ -AROUT BSBEV CONSH EASTC NORTS SEVES BERGS VICTE BOLID FISSA ROMEY BLAUS BONAP\ -MEREP ANATR ANTON CENTC PERIC TORTU FRANK TOMSP DUMON FRANR WARTH PARIS SPECD\ -LONEP THEBI REGGC VINET WELLI HANAR QUEDE RICAR PICCO HILAA LETSS COMMI FAMIA\ -QUEEN TRADH WHITC GODOS SANTG BLONP WANDK FRANS LAMAI BOTTM LAUGB LACOR LAZYK\ -WOLZA VAFFE} 0 {DRACD RATTC OLDWO GALED LILAS MAGAA ALFKI CHOPS SAVEA KOENE\ +} -constraints {eagle monoToDo file_System.Data.SQLite.dll\ +file_System.Data.SQLite.Linq.dll file_testlinq.exe file_northwindEF.db} \ +-result {0 {} 0 {DRACD RATTC OLDWO GALED LILAS MAGAA ALFKI CHOPS SAVEA KOENE\ MAISD FOLKO CACTU OCEAN RANCH THECR GOURL GROSR SUPRD HUNGO ISLAT QUICK HUNGC\ GREAL LEHMS RICSU ERNSH WILMK LINOD TRAIH SIMOB OTTIK SPLIR MORGK FOLIG FURIB\ PRINI AROUT BSBEV CONSH EASTC NORTS SEVES BERGS VICTE BOLID FISSA ROMEY BLAUS\ BONAP MEREP ANATR ANTON CENTC PERIC TORTU FRANK TOMSP DUMON FRANR WARTH PARIS\ SPECD LONEP THEBI REGGC VINET WELLI HANAR QUEDE RICAR PICCO HILAA LETSS COMMI\ FAMIA QUEEN TRADH WHITC GODOS SANTG BLONP WANDK FRANS LAMAI BOTTM LAUGB LACOR\ -LAZYK WOLZA VAFFE}}} +LAZYK WOLZA VAFFE} 0 {DRACD RATTC OLDWO GALED LILAS MAGAA ALFKI CHOPS SAVEA\ +KOENE MAISD FOLKO CACTU OCEAN RANCH THECR GOURL GROSR SUPRD HUNGO ISLAT QUICK\ +HUNGC GREAL LEHMS RICSU ERNSH WILMK LINOD TRAIH SIMOB OTTIK SPLIR MORGK FOLIG\ +FURIB PRINI AROUT BSBEV CONSH EASTC NORTS SEVES BERGS VICTE BOLID FISSA ROMEY\ +BLAUS BONAP MEREP ANATR ANTON CENTC PERIC TORTU FRANK TOMSP DUMON FRANR WARTH\ +PARIS SPECD LONEP THEBI REGGC VINET WELLI HANAR QUEDE RICAR PICCO HILAA LETSS\ +COMMI FAMIA QUEEN TRADH WHITC GODOS SANTG BLONP WANDK FRANS LAMAI BOTTM LAUGB\ +LACOR LAZYK WOLZA VAFFE}}} ############################################################################### -unset -nocomplain testLinqExeFile northwindEfDbFile +unset -nocomplain systemDataSQLiteDllFile systemDataSQLiteLinqDllFile \ + testLinqExeFile northwindEfDbFile ############################################################################### runSQLiteTestEpilogue runTestEpilogue ADDED Tests/tkt-996d13cd87.eagle Index: Tests/tkt-996d13cd87.eagle ================================================================== --- /dev/null +++ Tests/tkt-996d13cd87.eagle @@ -0,0 +1,244 @@ +############################################################################### +# +# tkt-996d13cd87.eagle -- +# +# Written by Joe Mistachkin. +# Released to the public domain, use at your own risk! +# +############################################################################### + +package require Eagle +package require Eagle.Library +package require Eagle.Test + +runTestPrologue + +############################################################################### + +package require System.Data.SQLite.Test +runSQLiteTestPrologue + +############################################################################### + +runTest {test tkt-996d13cd87-1.1 {SQLiteConnectionPool stress} -setup { + set fileName tkt-996d13cd87-1.1.db +} -body { + set id [object invoke Interpreter.GetActive NextId] + set dataSource [file join [getDatabaseDirectory] $fileName] + + set sql { \ + CREATE TABLE t1(x TEXT); \ + INSERT INTO t1 (x) VALUES(RANDOMBLOB(1000)); \ + } + + unset -nocomplain results errors + + set code [compileCSharpWith [subst { + using System; + using System.Data.SQLite; + using System.Diagnostics; + using System.Threading; + + namespace _Dynamic${id} + { + public static class Test${id} + { + public static int Main() + { + // + // NOTE: This is the total number of exceptions caught by all the + // test threads. + // + int errors = 0; + + // + // NOTE: This is the total number of test threads to create. + // + int count = 100; + + // + // NOTE: This is the total number of times we should force a full + // garbage collection. + // + int gcCount = 2; + + // + // NOTE: Create a random number generator suitable for waiting a + // random number of milliseconds between each attempt to + // cause the race condition on a given thread. + // + Random random = new Random(); + + // + // NOTE: Create the event that will be used to synchronize all the + // created threads so that they start doing their actual test + // "work" at approximately the same time. + // + using (ManualResetEvent goEvent = new ManualResetEvent(false)) + { + // + // NOTE: Create a (reusable) delegate that will contain the code + // that half the created threads are to execute. This code + // will repeatedly create, open, and close a single database + // connection with pool enabled. + // + ThreadStart threadStart1 = delegate() + { + try + { + // + // NOTE: Wait forever for the "GO" signal so that all threads + // can start working at approximately the same time. + // + goEvent.WaitOne(); + + // + // NOTE: Repeatedly try to create, open, and close a pooled + // database connection and then wait a random number of + // milliseconds before doing it again. + // + Thread.Sleep(random.Next(0, 500)); + + SQLiteConnection connection = new SQLiteConnection( + "Data Source=${dataSource};Pooling=True;"); + + connection.Open(); + + using (SQLiteCommand command = new SQLiteCommand("${sql}", + connection)) + { + command.ExecuteNonQuery(); + } + + connection.Close(); + connection = null; + } + catch (Exception e) + { + Interlocked.Increment(ref errors); + Trace.WriteLine(e); + } + }; + + // + // NOTE: Create a (reusable) delegate that will contain the code + // that half the created threads are to execute. This code + // will repeatedly force a full garbage collection. + // + ThreadStart threadStart2 = delegate() + { + try + { + // + // NOTE: Wait forever for the "GO" signal so that all threads + // can start working at approximately the same time. + // + goEvent.WaitOne(); + + // + // NOTE: Wait a random number of milliseconds before forcing a + // full garbage collection. + // + for (int index = 0; index < gcCount; index++) + { + Thread.Sleep(random.Next(0, 1000)); + GC.GetTotalMemory(true); + } + } + catch (Exception e) + { + Interlocked.Increment(ref errors); + Trace.WriteLine(e); + } + }; + + // + // NOTE: Create the array of thread objects. + // + Thread\[\] thread = new Thread\[count\]; + + // + // NOTE: Create each of the test threads with a suitable stack + // size. We must specify a stack size here because the + // default one for the process would be the same as the + // parent executable (the Eagle shell), which is 16MB, + // too large to be useful. + // + for (int index = 0; index < count; index++) + { + // + // NOTE: Figure out what kind of thread to create (i.e. one + // that uses a connection or one that calls the GC). + // + ThreadStart threadStart; + + if (index == 0) + threadStart = threadStart2; + else + threadStart = threadStart1; + + thread\[index\] = new Thread(threadStart, 1048576); + + // + // NOTE: Name each thread for a better debugging experience. + // + thread\[index\].Name = String.Format( + "[file rootname ${fileName}] #{0}", index); + } + + // + // NOTE: Start all the threads now. They should not actually do + // any of the test "work" until we signal the event. + // + for (int index = 0; index < count; index++) + thread\[index\].Start(); + + // + // NOTE: Send the signal that all threads should start doing + // their test "work" now. + // + goEvent.Set(); /* GO */ + + // + // NOTE: Wait forever for each thread to finish its test "work" + // and then die. + // + for (int index = 0; index < count; index++) + thread\[index\].Join(); + } + + // + // NOTE: Return the total number of exceptions caught by the test + // threads. + // + return errors; + } + } + } + }] true true true results errors System.Data.SQLite.dll] + + list $code $results \ + [expr {[info exists errors] ? $errors : ""}] \ + [expr {$code eq "Ok" ? [catch { + object invoke _Dynamic${id}.Test${id} Main + } result] : [set result ""]}] $result \ + [expr {[object invoke -flags +NonPublic \ + System.Data.SQLite.SQLiteConnectionPool _poolOpened] > 0}] \ + [expr {[object invoke -flags +NonPublic \ + System.Data.SQLite.SQLiteConnectionPool _poolClosed] > 0}] +} -cleanup { + object invoke System.Data.SQLite.SQLiteConnection ClearAllPools + object invoke GC GetTotalMemory true + + cleanupDb $fileName + + unset -nocomplain result results errors code sql dataSource id db fileName +} -constraints \ +{eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -match \ +regexp -result {^Ok System#CodeDom#Compiler#CompilerResults#\d+ \{\} 0 \d+ True\ +True$}} + +############################################################################### + +runSQLiteTestEpilogue +runTestEpilogue Index: Tests/tkt-b4a7ddc83f.eagle ================================================================== --- Tests/tkt-b4a7ddc83f.eagle +++ Tests/tkt-b4a7ddc83f.eagle @@ -50,10 +50,11 @@ list $appDomainId(1) $appDomainId(2) \ [expr {$appDomainId(1) != $appDomainId(2)}] [setupDb $fileName] } -cleanup { cleanupDb $fileName + unset -nocomplain appDomainId db fileName } -constraints {eagle monoBug28 command.sql compile.DATA\ compile.ISOLATED_INTERPRETERS SQLite System.Data.SQLite} -isolationLevel \ AppDomain -match regexp -result {^\d+ \d+ True\ System#Data#SQLite#SQLiteConnection#\d+$}} Index: Tests/tkt-ccfa69fc32.eagle ================================================================== --- Tests/tkt-ccfa69fc32.eagle +++ Tests/tkt-ccfa69fc32.eagle @@ -22,17 +22,29 @@ # # NOTE: Setup the variables that refer to the various files required by the # tests in this file. # +set systemDataSQLiteDllFile [getBuildFileName System.Data.SQLite.dll] +set systemDataSQLiteLinqDllFile [getBuildFileName System.Data.SQLite.Linq.dll] set testLinqExeFile [getBuildFileName testlinq.exe] set northwindEfDbFile [file nativename [file join [file dirname $path] \ testlinq northwindEF.db]] # # NOTE: Setup the test constraints specific to the tests in this file. # +if {![haveConstraint [appendArgs file_ \ + [file tail $systemDataSQLiteDllFile]]]} then { + checkForFile $test_channel $systemDataSQLiteDllFile +} + +if {![haveConstraint [appendArgs file_ \ + [file tail $systemDataSQLiteLinqDllFile]]]} then { + checkForFile $test_channel $systemDataSQLiteLinqDllFile +} + if {![haveConstraint [appendArgs file_ [file tail $testLinqExeFile]]]} then { checkForFile $test_channel $testLinqExeFile } if {![haveConstraint [appendArgs file_ [file tail $northwindEfDbFile]]]} then { @@ -67,19 +79,21 @@ } set result } -cleanup { unset -nocomplain code output error result add -} -constraints {eagle monoToDo file_testlinq.exe file_northwindEF.db} -match \ +} -constraints {eagle monoToDo file_System.Data.SQLite.dll\ +file_System.Data.SQLite.Linq.dll file_testlinq.exe file_northwindEF.db} -match \ glob -result {0 {1581 1730 1833 2116 2139} 0 {System.Data.UpdateException: *\ ---> System.Data.SQLite.SQLiteException: Abort due to constraint violation PRIMARY KEY must be unique *} 0 {1 2 3 4 5 6 7 8 9 10 1576 1577 1578 1579 1580 1581 1730 1833 2116 2139}}} ############################################################################### -unset -nocomplain testLinqExeFile northwindEfDbFile +unset -nocomplain systemDataSQLiteDllFile systemDataSQLiteLinqDllFile \ + testLinqExeFile northwindEfDbFile ############################################################################### runSQLiteTestEpilogue runTestEpilogue Index: Tests/tkt-e1b2e0f769.eagle ================================================================== --- Tests/tkt-e1b2e0f769.eagle +++ Tests/tkt-e1b2e0f769.eagle @@ -43,13 +43,15 @@ using System.Collections.Generic; using System.Data.SQLite; namespace _Dynamic${id} { - public class Test${id} + public static class Test${id} { - public static List Tkt_e1b2e0f769(SQLiteConnection connection) + public static List Tkt_e1b2e0f769( + SQLiteConnection connection + ) { List result = new List(); using (SQLiteTransaction transaction = connection.BeginTransaction()) @@ -89,10 +91,12 @@ } connection.Close(); return result; } + + ///////////////////////////////////////////////////////////////////// public static int Main() { using (SQLiteConnection connection = new SQLiteConnection( "Data Source=${dataSource};")) Index: Tests/tkt-e30b820248.eagle ================================================================== --- Tests/tkt-e30b820248.eagle +++ Tests/tkt-e30b820248.eagle @@ -48,11 +48,11 @@ using System.Diagnostics; using System.IO; namespace _Dynamic${id} { - public class Test${id} + public static class Test${id} { public static void Main() { using (TraceListener listener = new TextWriterTraceListener( new FileStream("${test_log}", FileMode.Append, @@ -145,11 +145,11 @@ using System.Diagnostics; using System.IO; namespace _Dynamic${id} { - public class Test${id} + public static class Test${id} { #region Private Static Data private static SQLiteConnection connection; #endregion @@ -163,30 +163,36 @@ connection.LogMessage(0, "Connection opened."); } ///////////////////////////////////////////////////////////////////// - public static SQLiteCommand CreateCommand(string sql) + public static SQLiteCommand CreateCommand( + string sql + ) { SQLiteCommand command = connection.CreateCommand(); command.CommandText = sql; connection.LogMessage(0, "Command created."); return command; } ///////////////////////////////////////////////////////////////////// - public static SQLiteDataReader ExecuteReader(SQLiteCommand command) + public static SQLiteDataReader ExecuteReader( + SQLiteCommand command + ) { SQLiteDataReader dataReader = command.ExecuteReader(); connection.LogMessage(0, "Command executed."); return dataReader; } ///////////////////////////////////////////////////////////////////// - public static SQLiteDataReader ExecuteReader(string sql) + public static SQLiteDataReader ExecuteReader( + string sql + ) { SQLiteCommand command = CreateCommand(sql); SQLiteDataReader dataReader = command.ExecuteReader(); connection.LogMessage(0, "Command executed."); return dataReader; Index: Tests/version.eagle ================================================================== --- Tests/version.eagle +++ Tests/version.eagle @@ -27,11 +27,11 @@ # numbers must be manually kept synchronized with the version numbers for # the source code files, the built binaries, and the release packages. # set version(major) 1 set version(minor) 0 -set version(build) 80; # NOTE: Incremented with each release. +set version(build) 81; # NOTE: Incremented with each release. set version(revision) 0 ############################################################################### # ********************* END VOLATILE VERSION INFORMATION ********************** ############################################################################### Index: readme.htm ================================================================== --- readme.htm +++ readme.htm @@ -3,12 +3,12 @@ ADO.NET SQLite Data Provider
-Version 1.0.80.0 April XX, 2012 (release scheduled)
-Using SQLite 3.7.10
+Version 1.0.81.0 June XX, 2012 (release scheduled)
+Using SQLite 3.7.11
Originally written by Robert Simpson
Released to the public domain, use at your own risk!
Official provider website: http://system.data.sqlite.org/
Legacy versions: http://sqlite.phxsoftware.com/

@@ -144,11 +144,11 @@ <configuration> <system.data> <DbProviderFactories> <remove invariant="System.Data.SQLite" /> <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite" - type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.80.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" /> + type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.81.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" /> </DbProviderFactories> </system.data> </configuration>
@@ -185,24 +185,44 @@

Version History

- 1.0.80.0 - April XX, 2012 + 1.0.81.0 - June XX, 2012 +
+
+
Support compiling the interop assembly without support for the custom extension functions and the CryptoAPI based codec.
+
Add DefineConstants property to the SQLiteConnection class to return the list of define constants used when compiling the core managed assembly.
+
Add release archive verification tool to the release automation.
+
Fix subtle race condition between threads fetching connection handles from the connection pool any garbage collection (GC) threads that may be running. Fix for [996d13cd87].
+
Add missing call to SetTimeout in the SQLite3_UTF16.Open method.
+
Add checks to prevent the SQLiteConnectionPool.Remove method from returning any connection handles that are closed or invalid.
+
Modify static SQLiteBase helper methods to prevent them from passing IntPtr.Zero to the SQLite native library.
+
Remove static locks from the static helper methods in the SQLiteBase class, replacing them with a lock on the connection handle instance being operated upon.
+
Revise CriticalHandle derived classes to make them more thread-safe.
+
Add connection pool related diagnostic messages when compiled with the DEBUG define constant.
+
Add PoolCount property to the SQLiteConnection class to return the number of pool entries for the file name associated with the connection.
+
Rename internal SQLiteLastError methods to GetLastError.
+
Add assembly file test constraints to all tests that execute the "test.exe" or "testlinq.exe" files.
+
+
+ 1.0.80.0 - April 1, 2012

+
Updated to SQLite 3.7.11.

In the SQLiteFunction class, when calling user-provided methods from a delegate called by native code, avoid throwing exceptions, optionally tracing the caught exceptions. Fix for [8a426d12eb].

Add Visual Studio 2005 support to all the applicable solution/project files, their associated supporting files, and the test suite.

Add Visual Studio 2005 support to the redesigned designer support installer.

Add experimental support for "pre-loading" the native SQLite library based on the processor architecture of the current process. This feature is now enabled by default at compile-time.
+
Add support for the native SQLite Online Backup API. Fix for [c71846ed57].

Acquire and hold a static data lock while checking if the native SQLite library has been initialized to prevent a subtle race condition that can result in superfluous error messages. Fix for [72905c9a77].

Support tracing of all parameter binding activity and use the connection flags to control what is traced.

When converting a DateTime instance of an "Unspecified" kind to a string, use the same kind as the connection, if available.

Add overload of the SQLiteDataReader.GetValues method that returns a NameValueCollection.

Add static ToUnixEpoch method to the SQLiteConvert class to convert a DateTime value to the number of whole seconds since the Unix epoch.

In the implicit conversion operators (to IntPtr) for both the SQLiteConnectionHandle and SQLiteStatementHandle classes, return IntPtr.Zero if the instance being converted is null.
-
Write warning message to the active trace listners (for the Debug build configuration only) if a column type or type name cannot be mapped properly. See [4bbf851fa5].
+
Write warning message to the active trace listeners (for the Debug build configuration only) if a column type or type name cannot be mapped properly. See [4bbf851fa5].

When tracing SQL statements to be prepared, bypass the internal length limit of the sqlite3_log function by using the SQLiteLog class directly instead. Also, detect null and/or empty strings and emit a special message in that case.

For the setup, the Visual Studio task should only be initially checked if the GAC task is available and vice-versa.

Improve compatibility with custom command processors by using __ECHO instead of _ECHO in batch tools.

Add OpenAndReturn method to the SQLiteConnection class to open a connection and return it.

Add missing CheckDisposed calls to the SQLiteConnection class.
Index: test/AssemblyInfo.cs ================================================================== --- test/AssemblyInfo.cs +++ test/AssemblyInfo.cs @@ -36,7 +36,7 @@ // Major Version // Minor Version // Build Number // Revision // -[assembly: AssemblyVersion("1.0.80.0")] -[assembly: AssemblyFileVersion("1.0.80.0")] +[assembly: AssemblyVersion("1.0.81.0")] +[assembly: AssemblyFileVersion("1.0.81.0")] Index: test/TestCases.cs ================================================================== --- test/TestCases.cs +++ test/TestCases.cs @@ -77,10 +77,11 @@ { if (_fact.GetType().Name.IndexOf("SQLite", StringComparison.OrdinalIgnoreCase) == -1) throw new InconclusiveException("Not a SQLite database"); } +#if INTEROP_CODEC ///
/// Tests changing password on an encrypted database. ///
[Test] internal void ChangePasswordTest() @@ -145,10 +146,11 @@ cnn.Open(); cnn.Close(); } } +#endif [Test(Sequence=1)] internal string VersionTest() { CheckSQLite(); @@ -217,10 +219,11 @@ reader.Read(); } } } +#if INTEROP_EXTENSION_FUNCTIONS [Test(Sequence = 8)] internal void FunctionWithCollation() { CheckSQLite(); using (DbCommand cmd = _cnn.CreateCommand()) @@ -232,10 +235,11 @@ if (reader.GetInt64(0) != reader.GetInt64(2) || reader.GetInt64(1) != 0 || reader.GetInt64(0) != 4) throw new Exception("CharIndex returned wrong results!"); } } } +#endif [Test(Sequence = 9)] internal void FunctionWithCollation2() { CheckSQLite(); @@ -1198,10 +1202,14 @@ { adp.SelectCommand = cmd; builder.DataAdapter = adp; builder.ConflictOption = ConflictOption.OverwriteChanges; + // + // NOTE: *MONO* This test fails on all recent versions of Mono (e.g. + // 2.10, 2.11) for reasons that are presently unknown. + // using (DbCommand updatecmd = builder.GetUpdateCommand()) { if (updatecmd.Parameters.Count != 4) throw new Exception("Wrong number of parameters in update command!"); } Index: test/app.config ================================================================== --- test/app.config +++ test/app.config @@ -1,8 +1,8 @@ - + Index: testce/AssemblyInfo.cs ================================================================== --- testce/AssemblyInfo.cs +++ testce/AssemblyInfo.cs @@ -36,8 +36,8 @@ // Major Version // Minor Version // Build Number // Revision // -[assembly: AssemblyVersion("1.0.80.0")] -// [assembly: AssemblyFileVersion("1.0.80.0")] +[assembly: AssemblyVersion("1.0.81.0")] +// [assembly: AssemblyFileVersion("1.0.81.0")] Index: testlinq/2008/App.config ================================================================== --- testlinq/2008/App.config +++ testlinq/2008/App.config @@ -1,11 +1,11 @@ - + Index: testlinq/2010/App.config ================================================================== --- testlinq/2010/App.config +++ testlinq/2010/App.config @@ -1,11 +1,11 @@ - + Index: testlinq/Properties/AssemblyInfo.cs ================================================================== --- testlinq/Properties/AssemblyInfo.cs +++ testlinq/Properties/AssemblyInfo.cs @@ -39,7 +39,7 @@ // Revision // // You can specify all the values or you can default the Build and Revision Numbers // by using the '*' as shown below: // [assembly: AssemblyVersion("1.0.*")] -[assembly: AssemblyVersion("1.0.80.0")] -[assembly: AssemblyFileVersion("1.0.80.0")] +[assembly: AssemblyVersion("1.0.81.0")] +[assembly: AssemblyFileVersion("1.0.81.0")] Index: tools/install/Properties/AssemblyInfo.cs ================================================================== --- tools/install/Properties/AssemblyInfo.cs +++ tools/install/Properties/AssemblyInfo.cs @@ -26,7 +26,7 @@ // Major Version // Minor Version // Build Number // Revision // -[assembly: AssemblyVersion("1.0.80.0")] -[assembly: AssemblyFileVersion("1.0.80.0")] +[assembly: AssemblyVersion("1.0.81.0")] +[assembly: AssemblyFileVersion("1.0.81.0")] Index: www/downloads.wiki ================================================================== --- www/downloads.wiki +++ www/downloads.wiki @@ -10,20 +10,20 @@ - sqlite-netFx-source-1.0.79.0.zip + sqlite-netFx-source-1.0.80.0.zip
- (2.62 MiB) + (2.68 MiB) This ZIP archive contains all current source code for System.Data.SQLite - 1.0.79.0 (3.7.10) combined into a single archive file. + 1.0.80.0 (3.7.11) combined into a single archive file.
- (sha1: 634b93112cd3bd093933760944aa3bf8740a455a) + (sha1: 96e37d1d9146f9cd6721ef273eb3973d1612c0ad) @@ -32,40 +32,40 @@ - sqlite-netFx35-setup-bundle-x86-2008-1.0.79.0.exe + sqlite-netFx35-setup-bundle-x86-2008-1.0.80.0.exe
- (6.02 MiB) + (6.04 MiB) This setup package features the mixed-mode assembly and will install all the necessary runtime components and dependencies for the x86 version of - the System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2008 + the System.Data.SQLite 1.0.80.0 (3.7.11) package. The Visual C++ 2008 SP1 runtime for x86 is included. The .NET Framework 3.5 SP1 is required.
- (sha1: 5a6de51b4d2c06629b7070c2c147f6a6eb8ce043) + (sha1: a4b9b35779ae85ce02f0e0a622f3039163335858) - sqlite-netFx35-setup-x86-2008-1.0.79.0.exe + sqlite-netFx35-setup-x86-2008-1.0.80.0.exe
- (6.02 MiB) + (6.03 MiB) This setup package will install all the necessary runtime components and - dependencies for the x86 version of the System.Data.SQLite 1.0.79.0 - (3.7.10) package. The Visual C++ 2008 SP1 runtime for x86 is included. + dependencies for the x86 version of the System.Data.SQLite 1.0.80.0 + (3.7.11) package. The Visual C++ 2008 SP1 runtime for x86 is included. The .NET Framework 3.5 SP1 is required.
- (sha1: 2208f5903ed522aa6b5718fcce5f22b528c62640) + (sha1: d8ddde29f3fc0ded715d632501809158c174fd4a) @@ -74,40 +74,40 @@ - sqlite-netFx35-setup-bundle-x64-2008-1.0.79.0.exe + sqlite-netFx35-setup-bundle-x64-2008-1.0.80.0.exe
- (6.76 MiB) + (6.77 MiB) This setup package features the mixed-mode assembly and will install all the necessary runtime components and dependencies for the x64 version of - the System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2008 + the System.Data.SQLite 1.0.80.0 (3.7.11) package. The Visual C++ 2008 SP1 runtime for x64 is included. The .NET Framework 3.5 SP1 is required.
- (sha1: 3b5febbc8915fd353ce9cbf28228635edf78d8c4) + (sha1: 65d6b88e6180f0956ed189de2e8595fb70d90970) - sqlite-netFx35-setup-x64-2008-1.0.79.0.exe + sqlite-netFx35-setup-x64-2008-1.0.80.0.exe
- (6.75 MiB) + (6.77 MiB) This setup package will install all the necessary runtime components and - dependencies for the x64 version of the System.Data.SQLite 1.0.79.0 - (3.7.10) package. The Visual C++ 2008 SP1 runtime for x64 is included. + dependencies for the x64 version of the System.Data.SQLite 1.0.80.0 + (3.7.11) package. The Visual C++ 2008 SP1 runtime for x64 is included. The .NET Framework 3.5 SP1 is required.
- (sha1: e0845f081c19edb6c27878e33bc9e4c2f166220e) + (sha1: 93da8e2d4e556c232587251f826d8e87da4969c9) @@ -116,40 +116,40 @@ - sqlite-netFx40-setup-bundle-x86-2010-1.0.79.0.exe + sqlite-netFx40-setup-bundle-x86-2010-1.0.80.0.exe
- (10.35 MiB) + (10.36 MiB) This setup package features the mixed-mode assembly and will install all the necessary runtime components and dependencies for the x86 version of - the System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2010 + the System.Data.SQLite 1.0.80.0 (3.7.11) package. The Visual C++ 2010 SP1 runtime for x86 is included. The .NET Framework 4.0 is required.
- (sha1: 2f6f2b9d507a7c751b638f76a1e3b25bc2322b76) + (sha1: 0d7a51989eb3f23bbf3d695c9af264666031e7c3) - sqlite-netFx40-setup-x86-2010-1.0.79.0.exe + sqlite-netFx40-setup-x86-2010-1.0.80.0.exe
- (10.34 MiB) + (10.36 MiB) This setup package will install all the necessary runtime components and - dependencies for the x86 version of the System.Data.SQLite 1.0.79.0 - (3.7.10) package. The Visual C++ 2010 SP1 runtime for x86 is included. + dependencies for the x86 version of the System.Data.SQLite 1.0.80.0 + (3.7.11) package. The Visual C++ 2010 SP1 runtime for x86 is included. The .NET Framework 4.0 is required.
- (sha1: b60fb8a586118182a3bee8dcbf77433ca651feec) + (sha1: ee2a4dde8f470eee99d1a616c5c2eab0dd2e245e) @@ -158,40 +158,40 @@ - sqlite-netFx40-setup-bundle-x64-2010-1.0.79.0.exe + sqlite-netFx40-setup-bundle-x64-2010-1.0.80.0.exe
- (11.60 MiB) + (11.62 MiB) This setup package features the mixed-mode assembly and will install all the necessary runtime components and dependencies for the x64 version of - the System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2010 + the System.Data.SQLite 1.0.80.0 (3.7.11) package. The Visual C++ 2010 SP1 runtime for x64 is included. The .NET Framework 4.0 is required.
- (sha1: 48ad9c2d7413cbdd80ff53597601e65e572d3369) + (sha1: e2a1b48e4e743d0224f2a6607be6b067426ab34b) - sqlite-netFx40-setup-x64-2010-1.0.79.0.exe + sqlite-netFx40-setup-x64-2010-1.0.80.0.exe
- (11.59 MiB) + (11.61 MiB) This setup package will install all the necessary runtime components and - dependencies for the x64 version of the System.Data.SQLite 1.0.79.0 - (3.7.10) package. The Visual C++ 2010 SP1 runtime for x64 is included. + dependencies for the x64 version of the System.Data.SQLite 1.0.80.0 + (3.7.11) package. The Visual C++ 2010 SP1 runtime for x64 is included. The .NET Framework 4.0 is required.
- (sha1: 4a8abad785ff31495e8fb137ec7fa4d9dca14062) + (sha1: 6e9fcd43446d88238875b8a1d83ec28e831fb0be) @@ -200,39 +200,39 @@ - sqlite-netFx35-binary-bundle-Win32-2008-1.0.79.0.zip + sqlite-netFx35-binary-bundle-Win32-2008-1.0.80.0.zip
(1.61 MiB) This binary package features the mixed-mode assembly and contains all the - binaries for the x86 version of the System.Data.SQLite 1.0.79.0 (3.7.10) + binaries for the x86 version of the System.Data.SQLite 1.0.80.0 (3.7.11) package. The Visual C++ 2008 SP1 runtime for x86 and the .NET Framework 3.5 SP1 are required.
- (sha1: 28bb5a9d453571060c608ccc158819d6c51e52af) + (sha1: 63240eacb4af8c507a6957e177de1a375db32e18) - sqlite-netFx35-binary-Win32-2008-1.0.79.0.zip + sqlite-netFx35-binary-Win32-2008-1.0.80.0.zip
- (1.60 MiB) + (1.62 MiB) This binary package contains all the binaries for the x86 version of the - System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2008 SP1 + System.Data.SQLite 1.0.80.0 (3.7.11) package. The Visual C++ 2008 SP1 runtime for x86 and the .NET Framework 3.5 SP1 are required.
- (sha1: ba5309ecd3d68de8e1c6d64c0c5e1ee8521c5892) + (sha1: 3159f8d2df5473ea1c42c603ec7a43f9d3aaf939) @@ -241,39 +241,39 @@ - sqlite-netFx35-binary-bundle-x64-2008-1.0.79.0.zip + sqlite-netFx35-binary-bundle-x64-2008-1.0.80.0.zip
- (1.67 MiB) + (1.68 MiB) This binary package features the mixed-mode assembly and contains all the - binaries for the x64 version of the System.Data.SQLite 1.0.79.0 (3.7.10) + binaries for the x64 version of the System.Data.SQLite 1.0.80.0 (3.7.11) package. The Visual C++ 2008 SP1 runtime for x64 and the .NET Framework 3.5 SP1 are required.
- (sha1: e5d595ca4d0af4a8a79866cd0899d783d3c2955f) + (sha1: 188f4fd49c9199474e7dec951d1702869f6b7bed) - sqlite-netFx35-binary-x64-2008-1.0.79.0.zip + sqlite-netFx35-binary-x64-2008-1.0.80.0.zip
- (1.67 MiB) + (1.69 MiB) This binary package contains all the binaries for the x64 version of the - System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2008 SP1 + System.Data.SQLite 1.0.80.0 (3.7.11) package. The Visual C++ 2008 SP1 runtime for x64 and the .NET Framework 3.5 SP1 are required.
- (sha1: da7a355d19b7649cd8804fff1b83397f29cef15a) + (sha1: 2d841e8f28cbbb95942afffde159b9beb8ecb9d0) @@ -282,39 +282,39 @@ - sqlite-netFx40-binary-bundle-Win32-2010-1.0.79.0.zip + sqlite-netFx40-binary-bundle-Win32-2010-1.0.80.0.zip
- (1.65 MiB) + (1.69 MiB) This binary package features the mixed-mode assembly and contains all the - binaries for the x86 version of the System.Data.SQLite 1.0.79.0 (3.7.10) + binaries for the x86 version of the System.Data.SQLite 1.0.80.0 (3.7.11) package. The Visual C++ 2010 SP1 runtime for x86 and the .NET Framework 4.0 are required.
- (sha1: c6076691c1ab4f98f363afe980e3c19b3e143557) + (sha1: f29643dd4be2876487c054ee5f2dca87e46f80a4) - sqlite-netFx40-binary-Win32-2010-1.0.79.0.zip + sqlite-netFx40-binary-Win32-2010-1.0.80.0.zip
- (1.64 MiB) + (1.66 MiB) This binary package contains all the binaries for the x86 version of the - System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2010 SP1 + System.Data.SQLite 1.0.80.0 (3.7.11) package. The Visual C++ 2010 SP1 runtime for x86 and the .NET Framework 4.0 are required.
- (sha1: 779f3857ec43f6d67f0744363d090114236aa4aa) + (sha1: 0c88572b2794ca75d08c8a6ab66fe1edce9ae825) @@ -323,39 +323,39 @@ - sqlite-netFx40-binary-bundle-x64-2010-1.0.79.0.zip + sqlite-netFx40-binary-bundle-x64-2010-1.0.80.0.zip
(1.68 MiB) This binary package features the mixed-mode assembly and contains all the - binaries for the x64 version of the System.Data.SQLite 1.0.79.0 (3.7.10) + binaries for the x64 version of the System.Data.SQLite 1.0.80.0 (3.7.11) package. The Visual C++ 2010 SP1 runtime for x64 and the .NET Framework 4.0 are required.
- (sha1: da37bb787291e6b9d14f2f80bfe85539d9ff2864) + (sha1: 32b30e7430d92ce7192ce83451e8a9862f1e5d97) - sqlite-netFx40-binary-x64-2010-1.0.79.0.zip + sqlite-netFx40-binary-x64-2010-1.0.80.0.zip
(1.67 MiB) This binary package contains all the binaries for the x64 version of the - System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2010 SP1 + System.Data.SQLite 1.0.80.0 (3.7.11) package. The Visual C++ 2010 SP1 runtime for x64 and the .NET Framework 4.0 are required.
- (sha1: e24444efe5ff214bf9a82a1ce0056193cea2d1c0) + (sha1: 81d53e5b515b8906b875d994c0d8a60224b842fc) @@ -364,40 +364,40 @@ - sqlite-netFx35-static-binary-bundle-Win32-2008-1.0.79.0.zip + sqlite-netFx35-static-binary-bundle-Win32-2008-1.0.80.0.zip
- (1.82 MiB) + (1.88 MiB) This binary package features the mixed-mode assembly and contains all the - binaries for the x86 version of the System.Data.SQLite 1.0.79.0 (3.7.10) + binaries for the x86 version of the System.Data.SQLite 1.0.80.0 (3.7.11) package. The Visual C++ 2008 SP1 runtime for x86 is statically linked. The .NET Framework 3.5 SP1 is required.
- (sha1: 3b86995edf96216f496ee9800cb7c6a9ae435f8f) + (sha1: 62e17ad898954b884c78f331f03376dfa7cb15c2) - sqlite-netFx35-static-binary-Win32-2008-1.0.79.0.zip + sqlite-netFx35-static-binary-Win32-2008-1.0.80.0.zip
- (1.82 MiB) + (1.83 MiB) This binary package contains all the binaries for the x86 version of the - System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2008 SP1 + System.Data.SQLite 1.0.80.0 (3.7.11) package. The Visual C++ 2008 SP1 runtime for x86 is statically linked. The .NET Framework 3.5 SP1 is required.
- (sha1: b450fdfe98591c2ba590207cdb802a552c57f4a6) + (sha1: aa5d46057977a99e1eb275526bf0b5baea087026) @@ -406,40 +406,40 @@ - sqlite-netFx35-static-binary-bundle-x64-2008-1.0.79.0.zip + sqlite-netFx35-static-binary-bundle-x64-2008-1.0.80.0.zip
- (1.85 MiB) + (1.89 MiB) This binary package features the mixed-mode assembly and contains all the - binaries for the x64 version of the System.Data.SQLite 1.0.79.0 (3.7.10) + binaries for the x64 version of the System.Data.SQLite 1.0.80.0 (3.7.11) package. The Visual C++ 2008 SP1 runtime for x64 is statically linked. The .NET Framework 3.5 SP1 is required.
- (sha1: e0d696f9f18a1993b796d3572372c84fee543300) + (sha1: 4a3863c15848fae10c4521c6c30c630f1a5e07d4) - sqlite-netFx35-static-binary-x64-2008-1.0.79.0.zip + sqlite-netFx35-static-binary-x64-2008-1.0.80.0.zip
(1.84 MiB) This binary package contains all the binaries for the x64 version of the - System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2008 SP1 + System.Data.SQLite 1.0.80.0 (3.7.11) package. The Visual C++ 2008 SP1 runtime for x64 is statically linked. The .NET Framework 3.5 SP1 is required.
- (sha1: 032185157560dc169036f58d9f2975471548cfd9) + (sha1: 098caf7d4adab54d8c20cd0bfb5553b353b236c4) @@ -448,39 +448,39 @@ - sqlite-netFx40-static-binary-bundle-Win32-2010-1.0.79.0.zip + sqlite-netFx40-static-binary-bundle-Win32-2010-1.0.80.0.zip
- (1.87 MiB) + (1.89 MiB) This binary package features the mixed-mode assembly and contains all the - binaries for the x86 version of the System.Data.SQLite 1.0.79.0 (3.7.10) + binaries for the x86 version of the System.Data.SQLite 1.0.80.0 (3.7.11) package. The Visual C++ 2010 SP1 runtime for x86 is statically linked. The .NET Framework 4.0 is required.
- (sha1: 04e6b299f802de1520ccbfafc4a67ce1862e2fc3) + (sha1: ce97513d2fa7ba9b7dec0f3c45c58b0ba3e749c3) - sqlite-netFx40-static-binary-Win32-2010-1.0.79.0.zip + sqlite-netFx40-static-binary-Win32-2010-1.0.80.0.zip
- (1.86 MiB) + (1.88 MiB) This binary package contains all the binaries for the x86 version of the - System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2010 SP1 + System.Data.SQLite 1.0.80.0 (3.7.11) package. The Visual C++ 2010 SP1 runtime for x86 is statically linked. The .NET Framework 4.0 is required.
- (sha1: 2b76be35643b92128f67b2b02c8b4d0ef78aa7da) + (sha1: 50acae4e4f60ecc4e9a992191c2e8df47d6145e0) @@ -489,39 +489,39 @@ - sqlite-netFx40-static-binary-bundle-x64-2010-1.0.79.0.zip + sqlite-netFx40-static-binary-bundle-x64-2010-1.0.80.0.zip
(1.87 MiB) This binary package features the mixed-mode assembly and contains all the - binaries for the x64 version of the System.Data.SQLite 1.0.79.0 (3.7.10) + binaries for the x64 version of the System.Data.SQLite 1.0.80.0 (3.7.11) package. The Visual C++ 2010 SP1 runtime for x64 is statically linked. The .NET Framework 4.0 is required.
- (sha1: f4d904accd7412f0980b2bcac9576a3af4c63930) + (sha1: 9b412b19857bf123683e15dac3fa89bdabf59bc5) - sqlite-netFx40-static-binary-x64-2010-1.0.79.0.zip + sqlite-netFx40-static-binary-x64-2010-1.0.80.0.zip
(1.86 MiB) This binary package contains all the binaries for the x64 version of the - System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2010 SP1 + System.Data.SQLite 1.0.80.0 (3.7.11) package. The Visual C++ 2010 SP1 runtime for x64 is statically linked. The .NET Framework 4.0 is required.
- (sha1: a04f7718eb947d40f1201ac8bee3433a38dd6d08) + (sha1: 4e3bcc6a28813fa57bfd6b63a85406a3beb0de79) @@ -530,21 +530,21 @@ - sqlite-netFx35-binary-PocketPC-2008-1.0.79.0.zip + sqlite-netFx35-binary-PocketPC-2008-1.0.80.0.zip
- (0.81 MiB) + (0.82 MiB) This binary package contains all the binaries for the PocketPC version of - the System.Data.SQLite 1.0.79.0 (3.7.10) package. The .NET Compact + the System.Data.SQLite 1.0.80.0 (3.7.11) package. The .NET Compact Framework 3.5 is required.
- (sha1: 8b0517a3468099bcdeb8bdb6de1395c4b5dfae43) + (sha1: 14f204b9a842623be3a514372b810d3eb64edae0) @@ -560,12 +560,12 @@ (3.2 MiB) Legacy versions, as well as the original support forums, may still be - found at [http://sqlite.phxsoftware.com/], though there have been no updates - to this version since April of 2010. + found at [http://sqlite.phxsoftware.com/], though there have been no + updates to this version since April of 2010.
Build Product Names
@@ -600,31 +600,35 @@ statically linked to the Visual C++ runtime. Template (9) is used for unofficial pre-release "snapshots" of source code.

- The framework in templates (3), (4), (5), (6), (7), and (8) will be one of netFx35, netFx40. + The framework in templates (3), (4), (5), (6), (7), and (8) will be + one of netFx35, netFx40. +
+ +
+ The cpu in templates (3) and (4) will be one of x86, x64, arm, ia64. +
+ +
+ The platform in templates (5), (6), (7), and (8) will be one of Win32, + x64, PocketPC.

- The cpu in templates (3) and (4) will be one of x86, x64, arm, ia64. + The year in templates (3), (4), (5), (6), (7), and (8) will be one of + 2008, 2010.

- The platform in templates (5), (6), (7), and (8) will be one of Win32, x64, PocketPC. + The version in templates (1), (2), (3), (4), (5), (6), (7), and (8) is + the dot-delimited version number of the primary System.Data.SQLite assembly.

- The year in templates (3), (4), (5), (6), (7), and (8) will be one of 2008, 2010. -
- -
- The version in templates (1), (2), (3), (4), (5), (6), (7), and (8) is the dot-delimited version number of the primary System.Data.SQLite assembly. -
- -
- The date in template (9) is of the form: YYYYMMDDHHMM + The date in template (9) is of the form: YYYYMMDDHHMM

Canonical Source Code

@@ -634,8 +638,8 @@ or ZIP archives of historical check-ins.

The complete source tree for any [/timeline?n=20&y=ci | check-in] may always - be downloaded using the "ZIP archive" link available from the - check-in detail page. + be downloaded using the "Tarball" or "ZIP archive" links + available from the check-in detail page.
Index: www/faq.wiki ================================================================== --- www/faq.wiki +++ www/faq.wiki @@ -94,10 +94,18 @@
When the solution is loaded in Visual Studio, why do no files show up for several of the projects in the Solution Explorer window?
+
+
+ When the System.Data.SQLite project is compiled and run from + inside Visual Studio, why do I get a DllNotFoundException or a + BadImageFormatException (for "sqlite3.dll" or + "SQLite.Interop.dll") when trying to run or debug the application? + +

@@ -442,5 +450,35 @@ design-time, the C# source code files do not show up in the Solution Explorer window. This limitation is largely cosmetic and does not impact the correctness of the build process itself, whether in Visual Studio or when using MSBuild on the command line.
+ +
+ +
+ (20) When the System.Data.SQLite project is compiled and run from inside + Visual Studio, why do I get a DllNotFoundException or a BadImageFormatException + (for "sqlite3.dll" or "SQLite.Interop.dll") when trying to + run or debug the application? +
+ +
+ When compiling and running a solution from within Visual Studio that uses the + System.Data.SQLite project (including the test project), it is very important + to select the correct build configuration and platform. First, managed + applications to be debugged inside Visual Studio cannot use the mixed-mode + assembly (i.e. because it is always compiled to the platform-specific build + output directory). This is necessary to properly support building binaries + for multiple platforms using the same source project files. Therefore, only + the "DebugNativeOnly" or "ReleaseNativeOnly" build + configurations should be selected when running a managed application from + inside Visual Studio that relies upon the System.Data.SQLite assembly. These + build configurations contain a custom post-build step that copies the required + native assembly to the managed output directory (i.e. to enable running the + managed binaries in-place). However, this post-build step will only be + performed if the selected platform matches that of the operating system (e.g. + "Win32" for 32-bit Windows and "x64" for 64-bit Windows). + Therefore, it is good practice to double-check the selected build platform + against the operating system prior to attempting to run a managed project in + the solution. +
Index: www/news.wiki ================================================================== --- www/news.wiki +++ www/news.wiki @@ -1,24 +1,44 @@ News Version History
- 1.0.80.0 - April XX, 2012 (release scheduled) + 1.0.81.0 - June XX, 2012 (release scheduled) +
+
+
Support compiling the interop assembly without support for the custom extension functions and the CryptoAPI based codec.
+
Add DefineConstants property to the SQLiteConnection class to return the list of define constants used when compiling the core managed assembly.
+
Add release archive verification tool to the release automation.
+
Fix subtle race condition between threads fetching connection handles from the connection pool any garbage collection (GC) threads that may be running. Fix for [996d13cd87].
+
Add missing call to SetTimeout in the SQLite3_UTF16.Open method.
+
Add checks to prevent the SQLiteConnectionPool.Remove method from returning any connection handles that are closed or invalid.
+
Modify static SQLiteBase helper methods to prevent them from passing IntPtr.Zero to the SQLite native library.
+
Remove static locks from the static helper methods in the SQLiteBase class, replacing them with a lock on the connection handle instance being operated upon.
+
Revise CriticalHandle derived classes to make them more thread-safe.
+
Add connection pool related diagnostic messages when compiled with the DEBUG define constant.
+
Add PoolCount property to the SQLiteConnection class to return the number of pool entries for the file name associated with the connection.
+
Rename internal SQLiteLastError methods to GetLastError.
+
Add assembly file test constraints to all tests that execute the "test.exe" or "testlinq.exe" files.
+
+
+ 1.0.80.0 - April 1, 2012

+
Updated to [http://www.sqlite.org/releaselog/3_7_11.html|SQLite 3.7.11].

In the SQLiteFunction class, when calling user-provided methods from a delegate called by native code, avoid throwing exceptions, optionally tracing the caught exceptions. Fix for [8a426d12eb].

Add Visual Studio 2005 support to all the applicable solution/project files, their associated supporting files, and the test suite.

Add Visual Studio 2005 support to the redesigned designer support installer.

Add experimental support for "pre-loading" the native SQLite library based on the processor architecture of the current process. This feature is now enabled by default at compile-time.
+
Add support for the native [http://www.sqlite.org/backup.html|SQLite Online Backup API]. Fix for [c71846ed57].

Acquire and hold a static data lock while checking if the native SQLite library has been initialized to prevent a subtle race condition that can result in superfluous error messages. Fix for [72905c9a77].

Support tracing of all parameter binding activity and use the connection flags to control what is traced.

When converting a DateTime instance of an "Unspecified" kind to a string, use the same kind as the connection, if available.

Add overload of the SQLiteDataReader.GetValues method that returns a NameValueCollection.

Add static ToUnixEpoch method to the SQLiteConvert class to convert a DateTime value to the number of whole seconds since the Unix epoch.

In the implicit conversion operators (to IntPtr) for both the SQLiteConnectionHandle and SQLiteStatementHandle classes, return IntPtr.Zero if the instance being converted is null.
-
Write warning message to the active trace listners (for the Debug build configuration only) if a column type or type name cannot be mapped properly. See [4bbf851fa5].
+
Write warning message to the active trace listeners (for the Debug build configuration only) if a column type or type name cannot be mapped properly. See [4bbf851fa5].

When tracing SQL statements to be prepared, bypass the internal length limit of the sqlite3_log function by using the SQLiteLog class directly instead. Also, detect null and/or empty strings and emit a special message in that case.

For the setup, the Visual Studio task should only be initially checked if the GAC task is available and vice-versa.

Improve compatibility with custom command processors by using __ECHO instead of _ECHO in batch tools.

Add OpenAndReturn method to the SQLiteConnection class to open a connection and return it.

Add missing CheckDisposed calls to the SQLiteConnection class.
Index: www/release.wiki ================================================================== --- www/release.wiki +++ www/release.wiki @@ -220,10 +220,27 @@
Enter the following command to build all the source release packages: archive.bat

+ + +
Verify All Release Packages
+ +
+
Open a normal command prompt window with "cmd.exe".
+ +
Change the current directory to "<root>\Setup".
+ +
+ Enter the following command to build all the source release packages: + ..\Externals\Eagle\bin\EagleShell.exe -file verify.eagle Output
+ If errors are generated, the file "<root>\Setup\verify.lst" + may need to be updated to account for the files that have been added and/or + removed from the release archives since the previous release. +
+

Update Downloads Page