Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Tweaks and optimizations |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | sourceforge |
| Files: | files | file ages | folders |
| SHA1: |
dcbda7101ee5d885a04d743a348b3b75 |
| User & Date: | rmsimpson 2005-08-26 05:04:57 |
Context
|
2005-08-27
| ||
| 23:17 | Added itanium and x64 platform build settings check-in: 065c6034ae user: rmsimpson tags: sourceforge | |
|
2005-08-26
| ||
| 05:04 | Tweaks and optimizations check-in: dcbda7101e user: rmsimpson tags: sourceforge | |
| 03:08 | no message check-in: c2d292b29a user: rmsimpson tags: sourceforge | |
Changes
Changes to System.Data.SQLite/SQLiteConnection.cs.
541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 |
throw new ArgumentException("Data Source cannot be empty. Use :MEMORY: to open an in-memory database");
try
{
bool bUTF16 = (Convert.ToBoolean(FindKey(opts, "UseUTF16Encoding", "False"), CultureInfo.InvariantCulture) == true);
SQLiteDateFormats dateFormat = String.Compare(FindKey(opts, "DateTimeFormat", "ISO8601"), "ticks", true, CultureInfo.CurrentCulture) == 0 ? SQLiteDateFormats.Ticks : SQLiteDateFormats.ISO8601;
if (bUTF16)
_sql = new SQLite3_UTF16(dateFormat);
else
_sql = new SQLite3(dateFormat);
_sql.Open(strFile);
_dataSource = System.IO.Path.GetFileNameWithoutExtension(strFile);
if (bUTF16 == true)
_sql.Execute("PRAGMA encoding = 'UTF-16'");
else
_sql.Execute("PRAGMA encoding = 'UTF-8'");
_sql.Execute(String.Format(CultureInfo.InvariantCulture, "PRAGMA Synchronous={0}", FindKey(opts, "Synchronous", "Normal")));
_sql.Execute(String.Format(CultureInfo.InvariantCulture, "PRAGMA Cache_Size={0}", FindKey(opts, "Cache Size", "2000")));
if (String.Compare(":MEMORY:", strFile, true, CultureInfo.CurrentCulture) == 0)
_sql.Execute(String.Format(CultureInfo.InvariantCulture, "PRAGMA Page_Size={0}", FindKey(opts, "Page Size", "1024")));
}
catch (SQLiteException)
{
|
| < < < < < |
541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 |
throw new ArgumentException("Data Source cannot be empty. Use :MEMORY: to open an in-memory database");
try
{
bool bUTF16 = (Convert.ToBoolean(FindKey(opts, "UseUTF16Encoding", "False"), CultureInfo.InvariantCulture) == true);
SQLiteDateFormats dateFormat = String.Compare(FindKey(opts, "DateTimeFormat", "ISO8601"), "ticks", true, CultureInfo.CurrentCulture) == 0 ? SQLiteDateFormats.Ticks : SQLiteDateFormats.ISO8601;
if (bUTF16) // SQLite automatically sets the encoding of the database to UTF16 if called from sqlite3_open16()
_sql = new SQLite3_UTF16(dateFormat);
else
_sql = new SQLite3(dateFormat);
_sql.Open(strFile);
_dataSource = System.IO.Path.GetFileNameWithoutExtension(strFile);
_sql.Execute(String.Format(CultureInfo.InvariantCulture, "PRAGMA Synchronous={0}", FindKey(opts, "Synchronous", "Normal")));
_sql.Execute(String.Format(CultureInfo.InvariantCulture, "PRAGMA Cache_Size={0}", FindKey(opts, "Cache Size", "2000")));
if (String.Compare(":MEMORY:", strFile, true, CultureInfo.CurrentCulture) == 0)
_sql.Execute(String.Format(CultureInfo.InvariantCulture, "PRAGMA Page_Size={0}", FindKey(opts, "Page Size", "1024")));
}
catch (SQLiteException)
{
|
Changes to System.Data.SQLite/UnsafeNativeMethods.cs.
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
...
231
232
233
234
235
236
237
238
239
240
|
private const string SQLITE_DLL = "SQLite.Interop.DLL";
#endif
private UnsafeNativeMethods()
{
}
[DllImport("kernel32.dll")]
internal static extern void Sleep(uint dwMilliseconds);
[DllImport(SQLITE_DLL)]
internal static extern IntPtr sqlite3_libversion_interop(out int len);
[DllImport(SQLITE_DLL)]
internal static extern void sqlite3_free_interop(IntPtr p);
................................................................................
internal static extern int sqlite3_encryptedstatus(string fileName, out long fileStatus);
[DllImport(SQLITE_DLL, CharSet = CharSet.Unicode, SetLastError = true)]
internal static extern int sqlite3_compressfile(string fileName);
[DllImport(SQLITE_DLL, CharSet = CharSet.Unicode, SetLastError = true)]
internal static extern int sqlite3_decompressfile(string fileName);
}
}
|
|
|
|
|
<
|
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
...
231
232
233
234
235
236
237
238
239
|
private const string SQLITE_DLL = "SQLite.Interop.DLL";
#endif
private UnsafeNativeMethods()
{
}
[DllImport(SQLITE_DLL)]
internal static extern void sqlite3_sleep_interop(uint dwMilliseconds);
[DllImport(SQLITE_DLL)]
internal static extern IntPtr sqlite3_libversion_interop(out int len);
[DllImport(SQLITE_DLL)]
internal static extern void sqlite3_free_interop(IntPtr p);
................................................................................
internal static extern int sqlite3_encryptedstatus(string fileName, out long fileStatus);
[DllImport(SQLITE_DLL, CharSet = CharSet.Unicode, SetLastError = true)]
internal static extern int sqlite3_compressfile(string fileName);
[DllImport(SQLITE_DLL, CharSet = CharSet.Unicode, SetLastError = true)]
internal static extern int sqlite3_decompressfile(string fileName);
}
}
|
Changes to test/Program.cs.
9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 |
class Program
{
static void Main(string[] args)
{
DbProviderFactory fact;
DbConnection cnn;
//fact = DbProviderFactories.GetFactory("System.Data.SqlClient");
//using (cnn = fact.CreateConnection())
//{
// cnn.ConnectionString = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=dlink;Data Source=(LOCAL)";
// cnn.Open();
// TestCases.Run(fact, cnn);
//}
// cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Temp\\db.mdb;Persist Security Info=False";
// cnn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DirectLink;Data Source=MASTER";
// cnn.Open();
// TestCases.Run(fact, cnn);
using (cnn = new SQLiteConnection())
{
fact = DbProviderFactories.GetFactory("System.Data.SQLite");
cnn.ConnectionString = "Data Source=test.db3;Synchronous=Off;UseUTF16Encoding=TRUE";
cnn.Open();
TestCases.Run(fact, cnn);
}
System.IO.File.Delete("test.db3");
Console.ReadKey();
}
}
}
|
< < < < < < < < < < < < < | |
9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 |
class Program
{
static void Main(string[] args)
{
DbProviderFactory fact;
DbConnection cnn;
using (cnn = new SQLiteConnection())
{
fact = DbProviderFactories.GetFactory("System.Data.SQLite");
cnn.ConnectionString = "Data Source=test.db3";
cnn.Open();
TestCases.Run(fact, cnn);
}
System.IO.File.Delete("test.db3");
Console.ReadKey();
}
}
}
|
Changes to testce/Program.cs.
9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 |
class Program
{
[MTAThread]
static void Main()
{
DbConnection cnn;
//fact = DbProviderFactories.GetFactory("System.Data.SqlClient");
//using (cnn = fact.CreateConnection())
//{
// cnn.ConnectionString = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=dlink;Data Source=(LOCAL)";
// cnn.Open();
// TestCases.Run(fact, cnn);
//}
// cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Temp\\db.mdb;Persist Security Info=False";
// cnn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DirectLink;Data Source=MASTER";
// cnn.Open();
// TestCases.Run(fact, cnn);
SQLiteFunction.RegisterFunction(typeof(TestFunc));
SQLiteFunction.RegisterFunction(typeof(MyCount));
SQLiteFunction.RegisterFunction(typeof(MySequence));
using (cnn = new SQLiteConnection())
{
TestCases tests = new TestCases();
cnn.ConnectionString = "Data Source=test.db3;Synchronous=Off;UseUTF16Encoding=TRUE";
cnn.Open();
tests.Run(cnn);
System.Windows.Forms.Application.Run(tests.frm);
}
System.IO.File.Delete("test.db3");
}
}
}
|
< < < < < < < < < < < < < | |
9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
class Program
{
[MTAThread]
static void Main()
{
DbConnection cnn;
SQLiteFunction.RegisterFunction(typeof(TestFunc));
SQLiteFunction.RegisterFunction(typeof(MyCount));
SQLiteFunction.RegisterFunction(typeof(MySequence));
using (cnn = new SQLiteConnection())
{
TestCases tests = new TestCases();
cnn.ConnectionString = "Data Source=test.db3";
cnn.Open();
tests.Run(cnn);
System.Windows.Forms.Application.Run(tests.frm);
}
System.IO.File.Delete("test.db3");
}
}
}
|