Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Updates for 67 release |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | sourceforge |
| Files: | files | file ages | folders |
| SHA1: |
09564699fe430b960172783aac2e8643 |
| User & Date: | rmsimpson 2010-08-11 16:14:33 |
Context
|
2010-08-11
| ||
| 16:15 | Code merge SQLite 3.7.0.1 check-in: 70c0651802 user: rmsimpson tags: sourceforge | |
| 16:14 | Updates for 67 release check-in: 09564699fe user: rmsimpson tags: sourceforge | |
| 16:13 | Prep for 67 check-in: e842408df1 user: rmsimpson tags: sourceforge | |
Changes
Changes to System.Data.SQLite/AssemblyInfo.cs.
45 46 47 48 49 50 51 52 53 54 55 |
// Major Version
// Minor Version
// Build Number
// Revision
//
// You can specify all the values or you can default the Revision and Build Numbers
// by using the '*' as shown below:
[assembly: AssemblyVersion("1.0.66.0")]
#if !PLATFORM_COMPACTFRAMEWORK
[assembly: AssemblyFileVersion("1.0.66.0")]
#endif
|
| | |
45 46 47 48 49 50 51 52 53 54 55 |
// Major Version
// Minor Version
// Build Number
// Revision
//
// You can specify all the values or you can default the Revision and Build Numbers
// by using the '*' as shown below:
[assembly: AssemblyVersion("1.0.67.0")]
#if !PLATFORM_COMPACTFRAMEWORK
[assembly: AssemblyFileVersion("1.0.67.0")]
#endif
|
Changes to System.Data.SQLite/SQLiteConnection.cs.
139 140 141 142 143 144 145 146 147 148 149 150 151 152 ... 590 591 592 593 594 595 596 597 598 599 600 601 602 603 ... 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 .... 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 |
/// </item>
/// <item>
/// <description>Default IsolationLevel</description>
/// <description>The default transaciton isolation level</description>
/// <description>N</description>
/// <description>Serializable</description>
/// </item>
/// </list>
/// </remarks>
public sealed partial class SQLiteConnection : DbConnection, ICloneable
{
private const string _dataDirectory = "|DataDirectory|";
private const string _masterdb = "sqlite_master";
private const string _tempmasterdb = "sqlite_temp_master";
................................................................................
/// </item>
/// <item>
/// <description>Default IsolationLevel</description>
/// <description>The default transaciton isolation level</description>
/// <description>N</description>
/// <description>Serializable</description>
/// </item>
/// </list>
/// </remarks>
#if !PLATFORM_COMPACTFRAMEWORK
[RefreshProperties(RefreshProperties.All), DefaultValue("")]
[Editor("SQLite.Designer.SQLiteConnectionStringEditor, SQLite.Designer, Version=1.0.37.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139", "System.Drawing.Design.UITypeEditor, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
#endif
public override string ConnectionString
................................................................................
if (Convert.ToInt32(defValue, CultureInfo.InvariantCulture) != 2000)
{
cmd.CommandText = String.Format(CultureInfo.InvariantCulture, "PRAGMA cache_size={0}", defValue);
cmd.ExecuteNonQuery();
}
defValue = FindKey(opts, "Journal Mode", "Delete");
if (String.Compare(defValue, "Default", StringComparison.OrdinalIgnoreCase) != 0)
{
cmd.CommandText = String.Format(CultureInfo.InvariantCulture, "PRAGMA journal_mode={0}", defValue);
cmd.ExecuteNonQuery();
}
}
if (_commitHandler != null)
_sql.SetCommitHook(_commitCallback);
if (_updateHandler != null)
_sql.SetUpdateHook(_updateCallback);
................................................................................
return Schema_ReservedWords();
}
throw new NotSupportedException();
}
private static DataTable Schema_ReservedWords()
{
DataTable tbl = new DataTable("MetaDataCollections");
tbl.Locale = CultureInfo.InvariantCulture;
tbl.Columns.Add("ReservedWord", typeof(string));
tbl.Columns.Add("MaximumVersion", typeof(string));
tbl.Columns.Add("MinimumVersion", typeof(string));
tbl.BeginLoadData();
|
> > > > > > > > > > > > | > > > > | |
139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 ... 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 ... 878 879 880 881 882 883 884 885 886 887 888 889 890 891 892 893 894 895 896 897 898 899 900 .... 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 |
/// </item> /// <item> /// <description>Default IsolationLevel</description> /// <description>The default transaciton isolation level</description> /// <description>N</description> /// <description>Serializable</description> /// </item> /// <item> /// <description>Foreign Keys</description> /// <description><b>True</b> - Enables foreign key enforcement<br/><b>False</b> - Disables foreign key enforcement</description> /// <description>N</description> /// <description>False</description> /// </item> /// </list> /// </remarks> public sealed partial class SQLiteConnection : DbConnection, ICloneable { private const string _dataDirectory = "|DataDirectory|"; private const string _masterdb = "sqlite_master"; private const string _tempmasterdb = "sqlite_temp_master"; ................................................................................ /// </item> /// <item> /// <description>Default IsolationLevel</description> /// <description>The default transaciton isolation level</description> /// <description>N</description> /// <description>Serializable</description> /// </item> /// <item> /// <description>Foreign Keys</description> /// <description><b>True</b> - Enables foreign key enforcement<br/><b>False</b> - Disables foreign key enforcement</description> /// <description>N</description> /// <description>False</description> /// </item> /// </list> /// </remarks> #if !PLATFORM_COMPACTFRAMEWORK [RefreshProperties(RefreshProperties.All), DefaultValue("")] [Editor("SQLite.Designer.SQLiteConnectionStringEditor, SQLite.Designer, Version=1.0.37.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139", "System.Drawing.Design.UITypeEditor, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")] #endif public override string ConnectionString ................................................................................ if (Convert.ToInt32(defValue, CultureInfo.InvariantCulture) != 2000) { cmd.CommandText = String.Format(CultureInfo.InvariantCulture, "PRAGMA cache_size={0}", defValue); cmd.ExecuteNonQuery(); } defValue = FindKey(opts, "Journal Mode", "Delete"); if (String.Compare(defValue, "Delete", StringComparison.OrdinalIgnoreCase) != 0) { cmd.CommandText = String.Format(CultureInfo.InvariantCulture, "PRAGMA journal_mode={0}", defValue); cmd.ExecuteNonQuery(); } defValue = FindKey(opts, "Foreign Keys", Boolean.FalseString); cmd.CommandText = String.Format(CultureInfo.InvariantCulture, "PRAGMA foreign_keys={0}", SQLiteConvert.ToBoolean(defValue) == true ? "ON" : "OFF"); cmd.ExecuteNonQuery(); } if (_commitHandler != null) _sql.SetCommitHook(_commitCallback); if (_updateHandler != null) _sql.SetUpdateHook(_updateCallback); ................................................................................ return Schema_ReservedWords(); } throw new NotSupportedException(); } private static DataTable Schema_ReservedWords() { DataTable tbl = new DataTable("ReservedWords"); tbl.Locale = CultureInfo.InvariantCulture; tbl.Columns.Add("ReservedWord", typeof(string)); tbl.Columns.Add("MaximumVersion", typeof(string)); tbl.Columns.Add("MinimumVersion", typeof(string)); tbl.BeginLoadData(); |
Changes to System.Data.SQLite/SQLiteConnectionStringBuilder.cs.
453 454 455 456 457 458 459 460 461 462 463 464 465 466 |
return (IsolationLevel)value;
}
set
{
this["default isolationlevel"] = value;
}
}
/// <summary>
/// Helper function for retrieving values from the connectionstring
/// </summary>
/// <param name="keyword">The keyword to retrieve settings for</param>
/// <param name="value">The resulting parameter value</param>
/// <returns>Returns true if the value was found and returned</returns>
|
> > > > > > > > > > > > > > > > > > > > |
453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 |
return (IsolationLevel)value;
}
set
{
this["default isolationlevel"] = value;
}
}
/// <summary>
/// If enabled, use foreign key constraints
/// </summary>
[DisplayName("Foreign Keys")]
[Browsable(true)]
[DefaultValue(false)]
public bool ForeignKeys
{
get
{
object value;
TryGetValue("foreign keys", out value);
return SQLiteConvert.ToBoolean(value);
}
set
{
this["foreign keys"] = value;
}
}
/// <summary>
/// Helper function for retrieving values from the connectionstring
/// </summary>
/// <param name="keyword">The keyword to retrieve settings for</param>
/// <param name="value">The resulting parameter value</param>
/// <returns>Returns true if the value was found and returned</returns>
|
Changes to System.Data.SQLite/SQLiteConvert.cs.
778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 |
/// and the journal re-used as often as needed. If it is deleted, it will be recreated the next time it is needed.
/// </summary>
Persist = 1,
/// <summary>
/// This option disables the rollback journal entirely. Interrupted transactions or a program crash can cause database
/// corruption in this mode!
/// </summary>
Off = 2
}
/// <summary>
/// Struct used internally to determine the datatype of a column in a resultset
/// </summary>
internal class SQLiteType
{
|
| > > > > > |
778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 |
/// and the journal re-used as often as needed. If it is deleted, it will be recreated the next time it is needed.
/// </summary>
Persist = 1,
/// <summary>
/// This option disables the rollback journal entirely. Interrupted transactions or a program crash can cause database
/// corruption in this mode!
/// </summary>
Off = 2,
/// <summary>
/// This option commits transactions by truncating the rollback journal to zero-length instead of deleting it. On many systems,
/// truncating a file is much faster than deleting the file since the containing directory does not need to be changed.
/// </summary>
Truncate = 3,
}
/// <summary>
/// Struct used internally to determine the datatype of a column in a resultset
/// </summary>
internal class SQLiteType
{
|
Changes to System.Data.SQLite/UnsafeNativeMethods.cs.
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
#if !SQLITE_STANDARD
#if !USE_INTEROP_DLL
#if !PLATFORM_COMPACTFRAMEWORK
private const string SQLITE_DLL = "System.Data.SQLite.DLL";
#else
internal const string SQLITE_DLL = "SQLite.Interop.066.DLL";
#endif // PLATFORM_COMPACTFRAMEWORK
#else
private const string SQLITE_DLL = "SQLite.Interop.DLL";
#endif // USE_INTEROP_DLL
#else
|
| |
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
#if !SQLITE_STANDARD
#if !USE_INTEROP_DLL
#if !PLATFORM_COMPACTFRAMEWORK
private const string SQLITE_DLL = "System.Data.SQLite.DLL";
#else
internal const string SQLITE_DLL = "SQLite.Interop.067.DLL";
#endif // PLATFORM_COMPACTFRAMEWORK
#else
private const string SQLITE_DLL = "SQLite.Interop.DLL";
#endif // USE_INTEROP_DLL
#else
|