System.Data.SQLite: Check-in [717bc31b47]

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

Overview

Comment:	Add experimental support for incremental blob I/O.
Downloads:	Tarball \| ZIP archive
Timelines:	family \| ancestors \| descendants \| both \| trunk
Files:	files \| file ages \| folders
SHA1:	717bc31b477b503e94ffb836ab12a9cf66ace477
User & Date:	mistachkin 2016-07-01 21:05:29.253

Context

2016-07-01
21:23		Add support for the 'No_SQLiteGetSettingValue' and 'No_SQLiteXmlConfigFile' environment variables. check-in: dc631206c0 user: mistachkin tags: trunk
21:05		Add experimental support for incremental blob I/O. check-in: 717bc31b47 user: mistachkin tags: trunk
20:43		Improve doc comments. Closed-Leaf check-in: 283d973957 user: mistachkin tags: blobIo
03:20		Correct an attribution comment. check-in: 8c08bda9a1 user: mistachkin tags: trunk

Changes

Changes to Doc/Extra/Provider/dbfactorysupport.html.

Changes to Doc/Extra/Provider/version.html.

Changes to Doc/Extra/Provider/welcome.html.

Changes to NuGet/SQLite.Beta.nuspec.

Changes to NuGet/SQLite.Core.Beta.nuspec.

Changes to NuGet/SQLite.Core.MSIL.Beta.nuspec.

Changes to NuGet/SQLite.Core.MSIL.Test.nuspec.

Changes to NuGet/SQLite.Core.MSIL.nuspec.

Changes to NuGet/SQLite.Core.Test.nuspec.

Changes to NuGet/SQLite.Core.nuspec.

Changes to NuGet/SQLite.EF6.Beta.nuspec.

Changes to NuGet/SQLite.EF6.Test.nuspec.

Changes to NuGet/SQLite.EF6.nuspec.

Changes to NuGet/SQLite.Linq.Beta.nuspec.

Changes to NuGet/SQLite.Linq.Test.nuspec.

Changes to NuGet/SQLite.Linq.nuspec.

Changes to NuGet/SQLite.MSIL.Beta.nuspec.

Changes to NuGet/SQLite.MSIL.Test.nuspec.

Changes to NuGet/SQLite.MSIL.nuspec.

Changes to NuGet/SQLite.Test.nuspec.

Changes to NuGet/SQLite.nuspec.

Changes to NuGet/SQLite.x64.nuspec.

Changes to NuGet/SQLite.x86.nuspec.

Changes to SQLite.Designer/AssemblyInfo.cs.

Changes to SQLite.Designer/source.extension.vsixmanifest.

Changes to SQLite.Interop/props/SQLite.Interop.2005.vsprops.

Changes to SQLite.Interop/props/SQLite.Interop.2008.vsprops.

Changes to SQLite.Interop/props/SQLite.Interop.2010.props.

Changes to SQLite.Interop/props/SQLite.Interop.2012.props.

Changes to SQLite.Interop/props/SQLite.Interop.2013.props.

Changes to SQLite.Interop/props/SQLite.Interop.2015.props.

Changes to SQLite.Interop/src/generic/interop.c.

Changes to SQLite.Interop/src/generic/interop.h.

Changes to Setup/data/verify.lst.

Changes to System.Data.SQLite.Linq/AssemblyInfo.cs.

Changes to System.Data.SQLite/AssemblyInfo.cs.

Changes to System.Data.SQLite/SQLite3.cs.

Changes to System.Data.SQLite/SQLiteBase.cs.

Added System.Data.SQLite/SQLiteBlob.cs.

Changes to System.Data.SQLite/SQLiteConnection.cs.

Changes to System.Data.SQLite/SQLiteDataReader.cs.

Changes to System.Data.SQLite/SQLiteKeyReader.cs.

Changes to System.Data.SQLite/Targets/System.Data.SQLite.Files.targets.

Changes to System.Data.SQLite/UnsafeNativeMethods.cs.

Changes to Tests/basic.eagle.

Changes to Tests/types.eagle.

Changes to Tests/version.eagle.

Changes to lib/System.Data.SQLite/common.eagle.

Changes to readme.htm.

Changes to test/AssemblyInfo.cs.

Changes to test/app.config.

Changes to testce/AssemblyInfo.cs.

Changes to testlinq/2008/LINQ/App.config.

Changes to testlinq/2010/EF6/App.config.

Changes to testlinq/2010/LINQ/App.config.

Changes to testlinq/2012/EF6/App.config.

Changes to testlinq/2012/LINQ/App.config.

Changes to testlinq/2013/EF6/App.config.

Changes to testlinq/2013/LINQ/App.config.

Changes to testlinq/2015/EF6/App.config.

Changes to testlinq/2015/LINQ/App.config.

Changes to testlinq/Properties/AssemblyInfo.cs.

Changes to tools/install/Properties/AssemblyInfo.cs.

Changes to www/news.wiki.

︙
60 61 62 63 64 65 66 67 68 69 70 71 72 73	60 61 62 63 64 65 66 67 68 69 70 71 72 73 74	+	#define INTEROP_DEBUG_OPEN (0x0008) #define INTEROP_DEBUG_OPEN16 (0x0010) #define INTEROP_DEBUG_PREPARE (0x0020) #define INTEROP_DEBUG_PREPARE16 (0x0040) #define INTEROP_DEBUG_RESET (0x0080) #define INTEROP_DEBUG_CHANGES (0x0100) #define INTEROP_DEBUG_BREAK (0x0200) #define INTEROP_DEBUG_BLOB_CLOSE (0x0400) #if defined(_MSC_VER) && defined(INTEROP_DEBUG) && \ (INTEROP_DEBUG & INTEROP_DEBUG_BREAK) #define sqlite3InteropBreak(a) { sqlite3InteropDebug("%s\n", (a)); __debugbreak(); } #else #define sqlite3InteropBreak(a) #endif
︙
717 718 719 720 721 722 723 724 725 726 727 728 729 730	718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748	+ + + + + + + + + + + + + + + + +	#endif ret = sqlite3_backup_finish(p); #if defined(INTEROP_DEBUG) && (INTEROP_DEBUG & INTEROP_DEBUG_BACKUP_FINISH) sqlite3InteropDebug("sqlite3_backup_finish_interop(): sqlite3_backup_finish(%p, %p, %p) returned %d.\n", pDestDb, pSrcDb, p, ret); #endif return ret; } SQLITE_API int WINAPI sqlite3_blob_close_interop(sqlite3_blob p) { int ret; #if defined(INTEROP_DEBUG) && (INTEROP_DEBUG & INTEROP_DEBUG_BLOB_CLOSE) sqlite3InteropDebug("sqlite3_blob_close_interop(): calling sqlite3_blob_close(%p)...\n", p); #endif ret = sqlite3_blob_close(p); #if defined(INTEROP_DEBUG) && (INTEROP_DEBUG & INTEROP_DEBUG_BLOB_CLOSE) sqlite3InteropDebug("sqlite3_blob_close_interop(): sqlite3_blob_close(%p) returned %d.\n", p, ret); #endif return ret; } SQLITE_API int WINAPI sqlite3_reset_interop(sqlite3_stmt stmt) { int ret;
︙

︙
687 688 689 690 691 692 693 694 695 696 697 698 699 700	687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726	+ + + + + + + + + + + + + + + + + + + + + + + + + +	#else SQLiteErrorCode n = UnsafeNativeMethods.sqlite3_backup_finish(backup); #endif if (n != SQLiteErrorCode.Ok) throw new SQLiteException(n, null); } } } internal static void CloseBlob(SQLiteConnectionHandle hdl, IntPtr blob) { if ((hdl == null) \|\| (blob == IntPtr.Zero)) return; try { // do nothing. } finally /* NOTE: Thread.Abort() protection. */ { #if PLATFORM_COMPACTFRAMEWORK lock (hdl.syncRoot) #else lock (hdl) #endif { #if !SQLITE_STANDARD SQLiteErrorCode n = UnsafeNativeMethods.sqlite3_blob_close_interop(blob); #else SQLiteErrorCode n = UnsafeNativeMethods.sqlite3_blob_close(blob); #endif if (n != SQLiteErrorCode.Ok) throw new SQLiteException(n, null); } } } internal static void FinalizeStatement(SQLiteConnectionHandle hdl, IntPtr stmt) { if ((hdl == null) \|\| (stmt == IntPtr.Zero)) return; try {
︙
1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200	1213 1214 1215 1216 1217 1218 1219 1220 1221 1222 1223 1224 1225 1226 1227 1228 1229 1230 1231	+ + + + +	/// <summary> /// If the database type name has not been explicitly set for the /// parameter specified, fallback to using the database type name /// associated with the <see cref="DbType" /> value. /// </summary> UseParameterDbTypeForTypeName = 0x2000000000, /// <summary> /// When returning column values, skip verifying their affinity. /// </summary> NoVerifyTypeAffinity = 0x4000000000, /// <summary> /// When binding parameter values or returning column values, always /// treat them as though they were plain text (i.e. no numeric, /// date/time, or other conversions should be attempted). /// </summary> BindAndGetAllAsText = BindAllAsText \| GetAllAsText,
︙

︙
20 21 22 23 24 25 26 27 28 29 30 31 32 33 34	20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35	- + +	using System.Text; ///////////////////////////////////////////////////////////////////////////////////////////////// /// <summary> /// This class represents a single value to be returned /// from the <see cref="SQLiteDataReader" /> class via ~~/// its <see cref="SQLiteDataReader.GetB~~oolean~~" />,~~ /// its <see cref="SQLiteDataReader.GetBlob" />, /// <see cref="SQLiteDataReader.GetBoolean" />, /// <see cref="SQLiteDataReader.GetByte" />, /// <see cref="SQLiteDataReader.GetBytes" />, /// <see cref="SQLiteDataReader.GetChar" />, /// <see cref="SQLiteDataReader.GetChars" />, /// <see cref="SQLiteDataReader.GetDateTime" />, /// <see cref="SQLiteDataReader.GetDecimal" />, /// <see cref="SQLiteDataReader.GetDouble" />,
︙
44 45 46 47 48 49 50 51 52 53 54 55 56 57	45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65	+ + + + + + +	/// <see cref="SQLiteDataReader" /> method called is not a value type. /// If the value to be returned from the <see cref="SQLiteDataReader" /> /// method is unsuitable (e.g. null with a value type), an exception will /// be thrown. /// </summary> public sealed class SQLiteDataReaderValue { /// <summary> /// The value to be returned from the /// <see cref="SQLiteDataReader.GetBlob" /> method -OR- null to /// indicate an error. /// </summary> public SQLiteBlob BlobValue; /// <summary> /// The value to be returned from the /// <see cref="SQLiteDataReader.GetBoolean" /> method -OR- null to /// indicate an error. /// </summary> public bool? BooleanValue;
︙
148 149 150 151 152 153 154 155 156 157 158 159 160 ~~161~~ 162 163 164 165 166 167 168	156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240	+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - +	/// <see cref="SQLiteDataReader.GetValue" /> method. /// </summary> public object Value; } ///////////////////////////////////////////////////////////////////////////////////////////////// /// <summary> /// This class represents the parameters that are provided /// to the <see cref="SQLiteDataReader" /> methods, with /// the exception of the column index (provided separately). /// </summary> public abstract class SQLiteReadEventArgs : EventArgs { // nothing. } ///////////////////////////////////////////////////////////////////////////////////////////////// /// <summary> /// This class represents the parameters that are provided to /// the <see cref="SQLiteDataReader.GetBlob" /> method, with /// the exception of the column index (provided separately). /// </summary> public class SQLiteReadBlobEventArgs : SQLiteReadEventArgs { #region Private Data /// <summary> /// Provides the underlying storage for the /// <see cref="ReadOnly" /> property. /// </summary> private bool readOnly; #endregion ///////////////////////////////////////////////////////////////////////// #region Private Constructors /// <summary> /// Constructs an instance of this class to pass into a user-defined /// callback associated with the <see cref="SQLiteDataReader.GetBlob" /> /// method. /// </summary> /// <param name="readOnly"> /// The value that was originally specified for the "readOnly" /// parameter to the <see cref="SQLiteDataReader.GetBlob" /> method. /// </param> internal SQLiteReadBlobEventArgs( bool readOnly ) { this.readOnly = readOnly; } #endregion ///////////////////////////////////////////////////////////////////////// #region Public Properties /// <summary> /// The value that was originally specified for the "readOnly" /// parameter to the <see cref="SQLiteDataReader.GetBlob" /> method. /// </summary> public bool ReadOnly { get { return readOnly; } set { readOnly = value; } } #endregion } ///////////////////////////////////////////////////////////////////////////////////////////////// /// <summary> /// This class represents the parameters that are provided /// to the <see cref="SQLiteDataReader.GetBytes" /> and /// <see cref="SQLiteDataReader.GetChars" /> methods, with /// the exception of the column index (provided separately). /// </summary> ~~public class SQLiteReadArrayEventArgs : EventArgs~~ public class SQLiteReadArrayEventArgs : SQLiteReadEventArgs { #region Private Data /// <summary> /// Provides the underlying storage for the /// <see cref="DataOffset" /> property. /// </summary> private long dataOffset;
︙
340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 ~~363~~ 364 365 366 367 368 369 370 371 372 373 ~~374~~ 375 ~~376~~ 377 378 379 380 381 382 383 384 385 386 387 388 389 ~~390~~ 391 392 393 394 395 396 ~~397~~ 398 399 400 ~~401~~ 402 403 404 405 406 407 408 ~~409~~ 410 411 412 413 ~~414~~ 415 416 417 418 419 420 421	412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 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 487 488 489 490 491 492 493 494 495 496	+ - + - + - + - + - + + + - + - + - +	#endregion } ///////////////////////////////////////////////////////////////////////////////////////////////// /// <summary> /// This class represents the parameters and return values for the /// <see cref="SQLiteDataReader.GetBlob" />, /// <see cref="SQLiteDataReader.GetBoolean" />, /// <see cref="SQLiteDataReader.GetByte" />, /// <see cref="SQLiteDataReader.GetBytes" />, /// <see cref="SQLiteDataReader.GetChar" />, /// <see cref="SQLiteDataReader.GetChars" />, /// <see cref="SQLiteDataReader.GetDateTime" />, /// <see cref="SQLiteDataReader.GetDecimal" />, /// <see cref="SQLiteDataReader.GetDouble" />, /// <see cref="SQLiteDataReader.GetFloat" />, /// <see cref="SQLiteDataReader.GetGuid" />, /// <see cref="SQLiteDataReader.GetInt16" />, /// <see cref="SQLiteDataReader.GetInt32" />, /// <see cref="SQLiteDataReader.GetInt64" />, /// <see cref="SQLiteDataReader.GetString" />, and /// <see cref="SQLiteDataReader.GetValue" /> methods. /// </summary> ~~public class SQLiteReadValueEventArgs : EventArgs~~ public class SQLiteReadValueEventArgs : SQLiteReadEventArgs { #region Private Data /// <summary> /// Provides the underlying storage for the /// <see cref="MethodName" /> property. /// </summary> private string methodName; /// <summary> /// Provides the underlying storage for the ~~/// <see cref="~~Array~~EventArgs" /> property.~~ /// <see cref="ExtraEventArgs" /> property. /// </summary> ~~private SQLiteRead~~Array~~EventArgs ~~array~~EventArgs;~~ private SQLiteReadEventArgs extraEventArgs; /// <summary> /// Provides the underlying storage for the /// <see cref="Value" /> property. /// </summary> private SQLiteDataReaderValue value; #endregion ///////////////////////////////////////////////////////////////////////// #region Private Constructors /// <summary> /// Constructs a new instance of this class. Depending on the method ~~/// being called, the <paramref name="~~array~~EventArgs" /> and/or~~ /// being called, the <paramref name="extraEventArgs" /> and/or /// <paramref name="value" /> parameters may be null. /// </summary> /// <param name="methodName"> /// The name of the <see cref="SQLiteDataReader" /> method that was /// responsible for invoking this callback. /// </param> ~~/// <param name="~~array~~EventArgs">~~ /// <param name="extraEventArgs"> /// If the <see cref="SQLiteDataReader.GetBytes" /> or /// <see cref="SQLiteDataReader.GetChars" /> method is being called, /// this object will contain the array related parameters for that /// method. If the <see cref="SQLiteDataReader.GetBlob" /> method is /// being called, this object will contain the blob related parameters ~~/// method.~~ /// for that method. /// </param> /// <param name="value"> /// This may be used by the callback to set the return value for the /// called <see cref="SQLiteDataReader" /> method. /// </param> internal SQLiteReadValueEventArgs( string methodName, ~~SQLiteRead~~Array~~EventArgs ~~array~~EventArgs,~~ SQLiteReadEventArgs extraEventArgs, SQLiteDataReaderValue value ) { this.methodName = methodName; ~~this.~~array~~EventArgs = ~~array~~EventArgs;~~ this.extraEventArgs = extraEventArgs; this.value = value; } #endregion ///////////////////////////////////////////////////////////////////////// #region Public Properties
︙
430 431 432 433 434 435 436 ~~437~~ 438 ~~439~~ 440 ~~441~~ 442 443 444 445 446 447 448	505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525	+ + - + - + - +	///////////////////////////////////////////////////////////////////////// /// <summary> /// If the <see cref="SQLiteDataReader.GetBytes" /> or /// <see cref="SQLiteDataReader.GetChars" /> method is being called, /// this object will contain the array related parameters for that /// method. If the <see cref="SQLiteDataReader.GetBlob" /> method is /// being called, this object will contain the blob related parameters ~~/// method.~~ /// for that method. /// </summary> ~~public SQLiteRead~~Array~~EventArgs ~~Array~~EventArgs~~ public SQLiteReadEventArgs ExtraEventArgs { ~~get { return ~~array~~EventArgs; }~~ get { return extraEventArgs; } } ///////////////////////////////////////////////////////////////////////// /// <summary> /// This may be used by the callback to set the return value for the /// called <see cref="SQLiteDataReader" /> method.
︙
536 537 538 539 540 541 542 ~~543~~ 544 545 546 547 548 549 550	613 614 615 616 617 618 619 620 621 622 623 624 625 626 627	- +	/// skipped. If this is set to non-zero and the necessary return value /// is unavailable or unsuitable, an exception will be thrown. /// </param> public delegate void SQLiteReadValueCallback( SQLiteConvert convert, SQLiteDataReader dataReader, SQLiteConnectionFlags flags, ~~SQLiteRead~~Value~~EventArgs eventArgs,~~ SQLiteReadEventArgs eventArgs, string typeName, int index, object userData, out bool complete ); /////////////////////////////////////////////////////////////////////////////////////////////////
︙

︙
387 388 389 390 391 392 393 394 395 396 397 398 399 400	387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403	+ + +	/// <returns> /// This function throws an InvalidTypeCast() exception if the requested type doesn't match the column's definition or affinity. /// </returns> /// <param name="i">The index of the column to type-check</param> /// <param name="typ">The type we want to get out of the column</param> private TypeAffinity VerifyType(int i, DbType typ) { if ((_flags & SQLiteConnectionFlags.NoVerifyTypeAffinity) == SQLiteConnectionFlags.NoVerifyTypeAffinity) return TypeAffinity.None; TypeAffinity affinity = GetSQLiteType(_flags, i).Affinity; switch (affinity) { case TypeAffinity.Int64: if (typ == DbType.Int64) return affinity; if (typ == DbType.Int32) return affinity;
︙
443 444 445 446 447 448 449 ~~450~~ 451 452 453 454 455 456 457	446 447 448 449 450 451 452 453 454 455 456 457 458 459 460	- +	/// <param name="complete"> /// Non-zero if the default handling for the data reader call should be /// skipped. If this is set to non-zero and the necessary return value /// is unavailable or unsuitable, an exception will be thrown. /// </param> private void InvokeReadValueCallback( int index, ~~SQLiteRead~~Value~~EventArgs eventArgs,~~ SQLiteReadEventArgs eventArgs, out bool complete ) { complete = false; SQLiteConnectionFlags oldFlags = _flags; _flags &= ~SQLiteConnectionFlags.UseConnectionReadValueCallbacks;
︙
487 488 489 490 491 492 493 494 495 496 497 498 499 500	490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 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	+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +	index, userData, out complete); /* throw */ } finally { _flags \|= SQLiteConnectionFlags.UseConnectionReadValueCallbacks; } } /// <summary> /// Attempts to query the integer identifier for the current row. This /// will not work for tables that were created WITHOUT ROWID -OR- if the /// query does not include the "rowid" column or one of its aliases -OR- /// if the <see cref="SQLiteDataReader" /> was not created with the /// <see cref="CommandBehavior.KeyInfo"/> flag. /// </summary> /// <returns> /// The integer identifier for the current row -OR- null if it could not /// be determined. /// </returns> internal long? GetRowId(int i) { // CheckDisposed(); VerifyForGet(); if (_keyInfo == null) return null; int iRowId = _keyInfo.GetRowIdIndex( GetDatabaseName(i), GetTableName(i)); if (iRowId == -1) return null; return GetInt64(iRowId); } /// <summary> /// Retrieves the column as a <see cref="SQLiteBlob" /> object. /// This will not work for tables that were created WITHOUT ROWID /// -OR- if the query does not include the "rowid" column or one /// of its aliases -OR- if the <see cref="SQLiteDataReader" /> was /// not created with the <see cref="CommandBehavior.KeyInfo"/> flag. /// </summary> /// <param name="i">The index of the column.</param> /// <param name="readOnly"> /// Non-zero to open the blob object for read-only access. /// </param> /// <returns>A new <see cref="SQLiteBlob" /> object.</returns> public SQLiteBlob GetBlob(int i, bool readOnly) { CheckDisposed(); VerifyForGet(); if ((_flags & SQLiteConnectionFlags.UseConnectionReadValueCallbacks) == SQLiteConnectionFlags.UseConnectionReadValueCallbacks) { SQLiteDataReaderValue value = new SQLiteDataReaderValue(); bool complete; InvokeReadValueCallback(i, new SQLiteReadValueEventArgs( "GetBlob", new SQLiteReadBlobEventArgs(readOnly), value), out complete); if (complete) return (SQLiteBlob)value.BlobValue; } if (i >= PrivateVisibleFieldCount && _keyInfo != null) return _keyInfo.GetBlob(i - PrivateVisibleFieldCount, readOnly); return SQLiteBlob.Create(this, i, readOnly); } /// <summary> /// Retrieves the column as a boolean value /// </summary> /// <param name="i">The index of the column.</param> /// <returns>bool</returns> public override bool GetBoolean(int i)
︙
1845 1846 1847 1848 1849 1850 1851 ~~1852~~ 1853 1854 1855 1856 1857 1858 1859	1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926	- +	/// This method attempts to query the database connection associated with /// the data reader in use. If the underlying command or connection is /// unavailable, a null value will be returned. /// </summary> /// <returns> /// The connection object -OR- null if it is unavailable. /// </returns> ~~~~priva~~te static SQLiteConnection GetConnection(~~ internal static SQLiteConnection GetConnection( SQLiteDataReader dataReader ) { try { if (dataReader != null) {
︙

1 2 3 4 5 6 7 8 9 10 11	1 2 3 4 5 6 7 8 9 10 11	- +	/******************************************************** * ADO.NET 2.0 Data Provider for SQLite Version 3.X * Written by Robert Simpson (robert@blackcastlesoft.com) * * * Released to the public domain, use at your own risk! ********************************************************/ namespace System.Data.SQLite { using System; using System.Data;
︙
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 48	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 48 49 50 51 52 53 54 55 56 57 58 59	+ + + + + + + + + + +	/// </remarks> /// </summary> internal sealed class SQLiteKeyReader : IDisposable { private KeyInfo[] _keyInfo; private SQLiteStatement _stmt; private bool _isValid; private RowIdInfo[] _rowIdInfo; /// <summary> /// Used to support CommandBehavior.KeyInfo /// </summary> private struct KeyInfo { internal string databaseName; internal string tableName; internal string columnName; internal int database; internal int rootPage; internal int cursor; internal KeyQuery query; internal int column; } /// <summary> /// Used to keep track of the per-table RowId column metadata. /// </summary> private struct RowIdInfo { internal string databaseName; internal string tableName; internal int column; } /// <summary> /// A single sub-query for a given table/database. /// </summary> private sealed class KeyQuery : IDisposable { private SQLiteCommand _command;
︙
151 152 153 154 155 156 157 158 159 160 161 162 163 164	162 163 164 165 166 167 168 169 170 171 172 173 174 175 176	+	/// <param name="stmt"></param> internal SQLiteKeyReader(SQLiteConnection cnn, SQLiteDataReader reader, SQLiteStatement stmt) { Dictionary<string, int> catalogs = new Dictionary<string, int>(); Dictionary<string, List<string>> tables = new Dictionary<string, List<string>>(); List<string> list; List<KeyInfo> keys = new List<KeyInfo>(); List<RowIdInfo> rowIds = new List<RowIdInfo>(); // Record the statement so we can use it later for sync'ing _stmt = stmt; // Fetch all the attached databases on this connection using (DataTable tbl = cnn.GetSchema("Catalogs")) {
︙
199 200 201 202 203 204 205 ~~206~~ 207 208 209 210 211 212 213	211 212 213 214 215 216 217 218 219 220 221 222 223 224 225	- +	{ for (int i = 0; i < pair.Value.Count; i++) { string table = pair.Value[i]; DataRow preferredRow = null; using (DataTable tbl = cnn.GetSchema("Indexes", new string[] { pair.Key, null, table })) { ~~// Loop twice. The first time looking for a primary key index,~~ // Loop twice. The first time looking for a primary key index, // the second time looking for a unique index for (int n = 0; n < 2 && preferredRow == null; n++) { foreach (DataRow row in tbl.Rows) { if (n == 0 && (bool)row["PRIMARY_KEY"] == true) {
︙
234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 ~~272~~ 273 274 275 276 277 278 279	246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306	+ + + + + + + + + + + + + + + - +	int database = catalogs[pair.Key]; int rootPage = Convert.ToInt32(tblTables.Rows[0]["TABLE_ROOTPAGE"], CultureInfo.InvariantCulture); int cursor = stmt._sql.GetCursorForTable(stmt, database, rootPage); // Now enumerate the members of the index we're going to use using (DataTable indexColumns = cnn.GetSchema("IndexColumns", new string[] { pair.Key, null, table, (string)preferredRow["INDEX_NAME"] })) { // // NOTE: If this is actually a RowId (or alias), record that now. There should // be exactly one index column in that case. // bool isRowId = (string)preferredRow["INDEX_NAME"] == "sqlite_master_PK_" + table; KeyQuery query = null; List<string> cols = new List<string>(); for (int x = 0; x < indexColumns.Rows.Count; x++) { string columnName = SQLiteConvert.GetStringOrNull( indexColumns.Rows[x]["COLUMN_NAME"]); bool addKey = true; // If the column in the index already appears in the query, skip it foreach (DataRow row in schema.Rows) { if (row.IsNull(SchemaTableColumn.BaseColumnName)) continue; if ((string)row[SchemaTableColumn.BaseColumnName] == columnName && (string)row[SchemaTableColumn.BaseTableName] == table && (string)row[SchemaTableOptionalColumn.BaseCatalogName] == pair.Key) { if (isRowId) { RowIdInfo rowId = new RowIdInfo(); rowId.databaseName = pair.Key; rowId.tableName = table; rowId.column = (int)row[SchemaTableColumn.ColumnOrdinal]; rowIds.Add(rowId); } indexColumns.Rows.RemoveAt(x); x--; addKey = false; break; } } if (addKey == true) cols.Add(columnName); } // If the index is not a rowid alias, record all the columns // needed to make up the unique index and construct a SQL query for it ~~if (~~(string)preferred~~Row~~["INDEX_NAME"] != "sqlite_master_PK_" + table~~)~~ if (!isRowId) { // Whatever remains of the columns we need that make up the index that are not // already in the query need to be queried separately, so construct a subquery if (cols.Count > 0) { string[] querycols = new string[cols.Count]; cols.CopyTo(querycols);
︙
306 307 308 309 310 311 312 313 314 315 316 317 318 319	333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373	+ + + + + + + + + + + + + + + + + + + + + + + + + + +	} } // Now we have all the additional columns we have to return in order to support // CommandBehavior.KeyInfo _keyInfo = new KeyInfo[keys.Count]; keys.CopyTo(_keyInfo); _rowIdInfo = new RowIdInfo[rowIds.Count]; rowIds.CopyTo(_rowIdInfo); } /////////////////////////////////////////////////////////////////////////////////////////////// internal int GetRowIdIndex( string databaseName, string tableName ) { if ((_rowIdInfo != null) && (databaseName != null) && (tableName != null)) { for (int i = 0; i < _rowIdInfo.Length; i++) { if (_rowIdInfo[i].databaseName == databaseName && _rowIdInfo[i].tableName == tableName) { return _rowIdInfo[i].column; } } } return -1; } /////////////////////////////////////////////////////////////////////////////////////////////// #region IDisposable Members public void Dispose() {
︙
458 459 460 461 462 463 464 465 466 467 468 469 470 471	512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532	+ + + + + + +	{ for (int n = 0; n < _keyInfo.Length; n++) { if (String.Compare(name, _keyInfo[n].columnName, StringComparison.OrdinalIgnoreCase) == 0) return n; } return -1; } internal SQLiteBlob GetBlob(int i, bool readOnly) { Sync(i); if (_keyInfo[i].query != null) return _keyInfo[i].query._reader.GetBlob(_keyInfo[i].column, readOnly); else throw new InvalidCastException(); } internal bool GetBoolean(int i) { Sync(i); if (_keyInfo[i].query != null) return _keyInfo[i].query._reader.GetBoolean(_keyInfo[i].column); else throw new InvalidCastException(); }
︙
561 562 563 564 565 566 567 ~~568~~ 569 570 571 572 573 574 575	622 623 624 625 626 627 628 629 630 631 632 633 634 635 636	- +	{ Sync(i); if (_keyInfo[i].query != null) return _keyInfo[i].query._reader.GetInt64(_keyInfo[i].column); else { long rowid = _stmt._sql.GetRowIdForCursor(_stmt, _keyInfo[i].cursor); if (rowid == 0) throw new InvalidCastException(); ~~return ~~Convert.ToInt64(rowid)~~;~~ return rowid; } } internal string GetString(int i) { Sync(i); if (_keyInfo[i].query != null) return _keyInfo[i].query._reader.GetString(_keyInfo[i].column);
︙
























































































































































































































































































































































1 2 3 4 5 6 7 8 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 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344	+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +	/******************************************************** * ADO.NET 2.0 Data Provider for SQLite Version 3.X * Written by Joe Mistachkin (joe@mistachkin.com) * * Released to the public domain, use at your own risk! *******************************************************/ namespace System.Data.SQLite { using System; /// <summary> /// Represents a single SQL blob in SQLite. /// </summary> public sealed class SQLiteBlob : IDisposable { #region Private Data /// <summary> /// The underlying SQLite object this blob is bound to. /// </summary> internal SQLiteBase _sql; /// <summary> /// The actual blob handle. /// </summary> internal SQLiteBlobHandle _sqlite_blob; #endregion /////////////////////////////////////////////////////////////////////////////////////////////// #region Private Constructors /// <summary> /// Initializes the blob. /// </summary> /// <param name="sqlbase">The base SQLite object.</param> /// <param name="blob">The blob handle.</param> private SQLiteBlob( SQLiteBase sqlbase, SQLiteBlobHandle blob ) { _sql = sqlbase; _sqlite_blob = blob; } #endregion /////////////////////////////////////////////////////////////////////////////////////////////// #region Static "Factory" Methods public static SQLiteBlob Create( SQLiteDataReader dataReader, int i, bool readOnly ) { SQLiteConnection connection = SQLiteDataReader.GetConnection( dataReader); if (connection == null) throw new InvalidOperationException("Connection not available"); SQLite3 sqlite3 = connection._sql as SQLite3; if (sqlite3 == null) throw new InvalidOperationException("Connection has no wrapper"); SQLiteConnectionHandle handle = sqlite3._sql; if (handle == null) throw new InvalidOperationException("Connection has an invalid handle."); long? rowId = dataReader.GetRowId(i); if (rowId == null) throw new InvalidOperationException("No RowId is available"); SQLiteBlobHandle blob = null; try { // do nothing. } finally / NOTE: Thread.Abort() protection. / { IntPtr ptrBlob = IntPtr.Zero; SQLiteErrorCode rc = UnsafeNativeMethods.sqlite3_blob_open( sqlite3._sql, SQLiteConvert.ToUTF8( dataReader.GetDatabaseName(i)), SQLiteConvert.ToUTF8( dataReader.GetTableName(i)), SQLiteConvert.ToUTF8( dataReader.GetName(i)), (long)rowId, readOnly ? 0 : 1, ref ptrBlob); if (rc != SQLiteErrorCode.Ok) throw new SQLiteException(rc, null); blob = new SQLiteBlobHandle(handle, ptrBlob); } SQLiteConnection.OnChanged(null, new ConnectionEventArgs( SQLiteConnectionEventType.NewCriticalHandle, null, null, null, dataReader, blob, null, new object[] { typeof(SQLiteBlob), dataReader, i, readOnly })); return new SQLiteBlob(sqlite3, blob); } #endregion /////////////////////////////////////////////////////////////////////////////////////////////// #region Private Methods /// <summary> /// Throws an exception if the blob object does not appear to be open. /// </summary> private void CheckOpen() { if (_sqlite_blob == IntPtr.Zero) throw new InvalidOperationException("Blob is not open"); } /////////////////////////////////////////////////////////////////////////////////////////////// /// <summary> /// Throws an exception if an invalid read/write parameter is detected. /// </summary> /// <param name="buffer"> /// When reading, this array will be populated with the bytes read from /// the underlying database blob. When writing, this array contains new /// values for the specified portion of the underlying database blob. /// </param> /// <param name="count"> /// The number of bytes to read or write. /// </param> /// <param name="offset"> /// The byte offset, relative to the start of the underlying database /// blob, where the read or write operation will begin. /// </param> private void VerifyParameters( byte[] buffer, int count, int offset ) { if (buffer == null) throw new ArgumentNullException("buffer"); if (offset < 0) throw new ArgumentException("Negative offset not allowed."); if (count < 0) throw new ArgumentException("Negative count not allowed."); if (count > buffer.Length) throw new ArgumentException("Buffer is too small."); } #endregion /////////////////////////////////////////////////////////////////////////////////////////////// #region Public Methods /// <summary> /// Retargets this object to an underlying database blob for a /// different row; the database, table, and column remain exactly /// the same. If this operation fails for any reason, this blob /// object is automatically disposed. /// </summary> /// <param name="rowId"> /// The integer identifier for the new row. /// </param> public void Reopen( long rowId ) { CheckDisposed(); CheckOpen(); SQLiteErrorCode rc = UnsafeNativeMethods.sqlite3_blob_reopen( _sqlite_blob, rowId); if (rc != SQLiteErrorCode.Ok) { Dispose(); throw new SQLiteException(rc, null); } } /////////////////////////////////////////////////////////////////////////////////////////////// /// <summary> /// Queries the total number of bytes for the underlying database blob. /// </summary> /// <returns> /// The total number of bytes for the underlying database blob. /// </returns> public int GetCount() { CheckDisposed(); CheckOpen(); return UnsafeNativeMethods.sqlite3_blob_bytes(_sqlite_blob); } /////////////////////////////////////////////////////////////////////////////////////////////// /// <summary> /// Reads data from the underlying database blob. /// </summary> /// <param name="buffer"> /// This array will be populated with the bytes read from the /// underlying database blob. /// </param> /// <param name="count"> /// The number of bytes to read. /// </param> /// <param name="offset"> /// The byte offset, relative to the start of the underlying /// database blob, where the read operation will begin. /// </param> public void Read( byte[] buffer, int count, int offset ) { CheckDisposed(); CheckOpen(); VerifyParameters(buffer, count, offset); SQLiteErrorCode rc = UnsafeNativeMethods.sqlite3_blob_read( _sqlite_blob, buffer, count, offset); if (rc != SQLiteErrorCode.Ok) throw new SQLiteException(rc, null); } /////////////////////////////////////////////////////////////////////////////////////////////// /// <summary> /// Writes data into the underlying database blob. /// </summary> /// <param name="buffer"> /// This array contains the new values for the specified portion of /// the underlying database blob. /// </param> /// <param name="count"> /// The number of bytes to write. /// </param> /// <param name="offset"> /// The byte offset, relative to the start of the underlying /// database blob, where the write operation will begin. /// </param> public void Write( byte[] buffer, int count, int offset ) { CheckDisposed(); CheckOpen(); VerifyParameters(buffer, count, offset); SQLiteErrorCode rc = UnsafeNativeMethods.sqlite3_blob_write( _sqlite_blob, buffer, count, offset); if (rc != SQLiteErrorCode.Ok) throw new SQLiteException(rc, null); } /////////////////////////////////////////////////////////////////////////////////////////////// /// <summary> /// Closes the blob, freeing the associated resources. /// </summary> public void Close() { Dispose(); } #endregion /////////////////////////////////////////////////////////////////////////////////////////////// #region IDisposable Members /// <summary> /// Disposes and finalizes the blob. /// </summary> public void Dispose() { Dispose(true); GC.SuppressFinalize(this); } #endregion /////////////////////////////////////////////////////////////////////////////////////////////// #region IDisposable "Pattern" Members private bool disposed; private void CheckDisposed() / throw */ { #if THROW_ON_DISPOSED if (disposed) throw new ObjectDisposedException(typeof(SQLiteBlob).Name); #endif } /////////////////////////////////////////////////////////////////////////////////////////////// private void Dispose(bool disposing) { if (!disposed) { if (disposing) { //////////////////////////////////// // dispose managed resources here... //////////////////////////////////// if (_sqlite_blob != null) { _sqlite_blob.Dispose(); _sqlite_blob = null; } _sql = null; } ////////////////////////////////////// // release unmanaged resources here... ////////////////////////////////////// disposed = true; } } #endregion /////////////////////////////////////////////////////////////////////////////////////////////// #region Destructor ~SQLiteBlob() { Dispose(false); } #endregion } }

︙
53 54 55 56 57 58 59 60 61 62 63 64 65 66	53 54 55 56 57 58 59 60 61 62 63 64 65 66 67	+	// associated constructors and are decremented upon the // successful completion of the associated ReleaseHandle // methods. // internal static int connectionCount; internal static int statementCount; internal static int backupCount; internal static int blobCount; #endif #endregion ///////////////////////////////////////////////////////////////////////// #region Settings Read Counts (Debug Build Only) #if DEBUG
︙
1677 1678 1679 1680 1681 1682 1683 ~~1684~~ 1685 1686 1687 1688 1689 1690 1691	1678 1679 1680 1681 1682 1683 1684 1685 1686 1687 1688 1689 1690 1691 1692	- +	// // NOTE: On the .NET Compact Framework, the native interop assembly must // be used because it provides several workarounds to .NET Compact // Framework limitations important for proper operation of the core // System.Data.SQLite functionality (e.g. being able to bind // parameters and handle column values of types Int64 and Double). // ~~internal const string SQLITE_DLL = "SQLite.Interop.102.dll";~~ internal const string SQLITE_DLL = "SQLite.Interop.103.dll"; #elif SQLITE_STANDARD // // NOTE: Otherwise, if the standard SQLite library is enabled, use it. // internal const string SQLITE_DLL = "sqlite3"; #elif USE_INTEROP_DLL //
︙
1799 1800 1801 1802 1803 1804 1805 1806 1807 1808 1809 1810 1811 1812	1800 1801 1802 1803 1804 1805 1806 1807 1808 1809 1810 1811 1812 1813 1814 1815 1816	+ + +	[DllImport(SQLITE_DLL)] internal static extern SQLiteErrorCode sqlite3_finalize_interop(IntPtr stmt); [DllImport(SQLITE_DLL)] internal static extern SQLiteErrorCode sqlite3_backup_finish_interop(IntPtr backup); [DllImport(SQLITE_DLL)] internal static extern SQLiteErrorCode sqlite3_blob_close_interop(IntPtr blob); [DllImport(SQLITE_DLL)] internal static extern SQLiteErrorCode sqlite3_open_interop(byte[] utf8Filename, byte[] vfsName, SQLiteOpenFlagsEnum flags, int extFuncs, ref IntPtr db); [DllImport(SQLITE_DLL)] internal static extern SQLiteErrorCode sqlite3_open16_interop(byte[] utf8Filename, byte[] vfsName, SQLiteOpenFlagsEnum flags, int extFuncs, ref IntPtr db); [DllImport(SQLITE_DLL)]
︙
2773 2774 2775 2776 2777 2778 2779 2780 2781 2782 2783 2784 2785 2786	2777 2778 2779 2780 2781 2782 2783 2784 2785 2786 2787 2788 2789 2790 2791 2792 2793 2794 2795 2796 2797 2798 2799 2800 2801 2802 2803 2804 2805 2806 2807 2808 2809 2810 2811 2812 2813 2814 2815 2816 2817 2818 2819 2820 2821 2822 2823 2824 2825 2826 2827 2828 2829 2830 2831 2832	+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +	#if !PLATFORM_COMPACTFRAMEWORK [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)] #else [DllImport(SQLITE_DLL)] #endif internal static extern int sqlite3_backup_pagecount(IntPtr backup); #if !PLATFORM_COMPACTFRAMEWORK [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)] #else [DllImport(SQLITE_DLL)] #endif internal static extern SQLiteErrorCode sqlite3_blob_close(IntPtr blob); #if !PLATFORM_COMPACTFRAMEWORK [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)] #else [DllImport(SQLITE_DLL)] #endif internal static extern int sqlite3_blob_bytes(IntPtr blob); #if !PLATFORM_COMPACTFRAMEWORK [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)] #else [DllImport(SQLITE_DLL)] #endif internal static extern SQLiteErrorCode sqlite3_blob_open(IntPtr db, byte[] dbName, byte[] tblName, byte[] colName, long rowId, int flags, ref IntPtr ptrBlob); #if !PLATFORM_COMPACTFRAMEWORK [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)] #else [DllImport(SQLITE_DLL)] #endif internal static extern SQLiteErrorCode sqlite3_blob_read(IntPtr blob, [MarshalAs(UnmanagedType.LPArray)] byte[] buffer, int count, int offset); #if !PLATFORM_COMPACTFRAMEWORK [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)] #else [DllImport(SQLITE_DLL)] #endif internal static extern SQLiteErrorCode sqlite3_blob_reopen(IntPtr blob, long rowId); #if !PLATFORM_COMPACTFRAMEWORK [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)] #else [DllImport(SQLITE_DLL)] #endif internal static extern SQLiteErrorCode sqlite3_blob_write(IntPtr blob, [MarshalAs(UnmanagedType.LPArray)] byte[] buffer, int count, int offset); #if !PLATFORM_COMPACTFRAMEWORK [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)] #else [DllImport(SQLITE_DLL)] #endif internal static extern SQLiteErrorCode sqlite3_declare_vtab(IntPtr db, IntPtr zSQL);
︙
3844 3845 3846 3847 3848 3849 3850 3851 3852 3853 3854 3855 3856 3857	3890 3891 3892 3893 3894 3895 3896 3897 3898 3899 3900 3901 3902 3903 3904 3905 3906 3907 3908 3909 3910 3911 3912 3913 3914 3915 3916 3917 3918 3919 3920 3921 3922 3923 3924 3925 3926 3927 3928 3929 3930 3931 3932 3933 3934 3935 3936 3937 3938 3939 3940 3941 3942 3943 3944 3945 3946 3947 3948 3949 3950 3951 3952 3953 3954 3955 3956 3957 3958 3959 3960 3961 3962 3963 3964 3965 3966 3967 3968 3969 3970 3971 3972 3973 3974 3975 3976 3977 3978 3979 3980 3981 3982 3983 3984 3985 3986 3987 3988 3989 3990 3991 3992 3993 3994 3995 3996 3997 3998 3999 4000 4001 4002 4003 4004 4005 4006 4007 4008 4009 4010 4011 4012 4013 4014 4015 4016 4017 4018 4019 4020 4021 4022 4023 4024 4025 4026 4027 4028 4029 4030 4031 4032 4033 4034 4035 4036 4037 4038 4039 4040 4041 4042 4043 4044 4045 4046 4047 4048 4049 4050 4051 4052 4053 4054 4055 4056 4057 4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073	+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +	#if COUNT_HANDLE public int WasReleasedOk() { return Interlocked.Decrement(ref DebugData.backupCount); } #endif /////////////////////////////////////////////////////////////////////// public override bool IsInvalid { get { #if PLATFORM_COMPACTFRAMEWORK lock (syncRoot) #endif { return (handle == IntPtr.Zero); } } } /////////////////////////////////////////////////////////////////////// #if DEBUG public override string ToString() { #if PLATFORM_COMPACTFRAMEWORK lock (syncRoot) #endif { return handle.ToString(); } } #endif } #endregion /////////////////////////////////////////////////////////////////////////// #region SQLiteBlobHandle Class // Provides finalization support for unmanaged SQLite blob objects. internal sealed class SQLiteBlobHandle : CriticalHandle { #if PLATFORM_COMPACTFRAMEWORK internal readonly object syncRoot = new object(); #endif /////////////////////////////////////////////////////////////////////// private SQLiteConnectionHandle cnn; /////////////////////////////////////////////////////////////////////// public static implicit operator IntPtr(SQLiteBlobHandle blob) { if (blob != null) { #if PLATFORM_COMPACTFRAMEWORK lock (blob.syncRoot) #endif { return blob.handle; } } return IntPtr.Zero; } /////////////////////////////////////////////////////////////////////// internal SQLiteBlobHandle(SQLiteConnectionHandle cnn, IntPtr blob) : this() { #if PLATFORM_COMPACTFRAMEWORK lock (syncRoot) #endif { this.cnn = cnn; SetHandle(blob); } } /////////////////////////////////////////////////////////////////////// private SQLiteBlobHandle() : base(IntPtr.Zero) { #if COUNT_HANDLE Interlocked.Increment(ref DebugData.blobCount); #endif } /////////////////////////////////////////////////////////////////////// protected override bool ReleaseHandle() { try { #if !PLATFORM_COMPACTFRAMEWORK IntPtr localHandle = Interlocked.Exchange( ref handle, IntPtr.Zero); if (localHandle != IntPtr.Zero) SQLiteBase.CloseBlob(cnn, localHandle); #if !NET_COMPACT_20 && TRACE_HANDLE try { Trace.WriteLine(HelperMethods.StringFormat( CultureInfo.CurrentCulture, "CloseBlob: {0}", localHandle)); /* throw / } catch { } #endif #else lock (syncRoot) { if (handle != IntPtr.Zero) { SQLiteBase.CloseBlob(cnn, handle); SetHandle(IntPtr.Zero); } } #endif #if COUNT_HANDLE Interlocked.Decrement(ref DebugData.blobCount); #endif #if DEBUG return true; #endif } #if !NET_COMPACT_20 && TRACE_HANDLE catch (SQLiteException e) #else catch (SQLiteException) #endif { #if !NET_COMPACT_20 && TRACE_HANDLE try { Trace.WriteLine(HelperMethods.StringFormat( CultureInfo.CurrentCulture, "CloseBlob: {0}, exception: {1}", handle, e)); / throw */ } catch { } #endif } finally { #if PLATFORM_COMPACTFRAMEWORK lock (syncRoot) #endif { SetHandleAsInvalid(); } } #if DEBUG return false; #else return true; #endif } /////////////////////////////////////////////////////////////////////// #if COUNT_HANDLE public int WasReleasedOk() { return Interlocked.Decrement(ref DebugData.blobCount); } #endif /////////////////////////////////////////////////////////////////////// public override bool IsInvalid { get {
︙

︙
108 109 110 111 112 113 114 ~~115 116 117 118 119 120 121 122 123 124~~ 125 ~~126 127 128 129 130~~ 131 132 133 134 135 136 137	108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138	- - - - - - - - - - + + + + + + + + + + - - - - - + + + + + +	############################################################################### set readArgs [list \ convert dataReader flags eventArgs typeName index userData \ completeVarName] set params [list \ [list Boolean GetBoolean false BooleanValue true 0] \ [list Byte GetByte false ByteValue true 0] \ [list Byte GetBytes true BytesValue false 0] \ [list Char GetChar false CharValue true 0] \ [list Char GetChars true CharsValue false 0] \ [list DateTime GetDateTime false DateTimeValue true 0] \ [list Decimal GetDecimal false DecimalValue true 0] \ [list Double GetDouble false DoubleValue true 0] \ [list Single GetFloat false FloatValue true 0] \ [list Guid GetGuid false GuidValue true \ [list Boolean GetBoolean false BooleanValue true 0] \ [list Byte GetByte false ByteValue true 0] \ [list Byte GetBytes true BytesValue false 0] \ [list Char GetChar false CharValue true 0] \ [list Char GetChars true CharsValue false 0] \ [list DateTime GetDateTime false DateTimeValue true 0] \ [list Decimal GetDecimal false DecimalValue true 0] \ [list Double GetDouble false DoubleValue true 0] \ [list Single GetFloat false FloatValue true 0] \ [list Guid GetGuid false GuidValue true \ 00000000-0000-0000-0000-000000000000] \ [list Int16 GetInt16 false Int16Value true 0] \ [list Int32 GetInt32 false Int32Value true 0] \ [list Int64 GetInt64 false Int64Value true 0] \ [list String GetString false StringValue false null] \ [list Object GetValue false Value false null]] [list Int16 GetInt16 false Int16Value true 0] \ [list Int32 GetInt32 false Int32Value true 0] \ [list Int64 GetInt64 false Int64Value true 0] \ [list String GetString false StringValue false null] \ [list Object GetValue false Value false null] \ [list SDS.SQLiteBlob GetBlob false BlobValue false 0]] ############################################################################### set expectedResults [list \ {False False True False False False False False} \ {0 0 1 0 0 0 0 0} \ {0 1 48 1 49 3 {49 46 50} 5 {116 104 114\
︙
163 164 165 166 167 168 169 ~~170~~ 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 ~~192~~ 193 ~~194~~ 195 196 ~~197 198~~ 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 ~~216~~ 217 ~~218~~ 219 220 221 222 223 224 ~~225~~ 226 ~~227 228~~ 229 230 231 232 233 234 235	164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246	- + + + + + + - + - + - - + + - + - + + + + + - + - - + + +	{0 0 1 0 0 0 0 0} \ {0 0 1 0 0 0 0 0} \ "<NUL> <NUL> <NUL> <NUL> three \x04\x05\x06\ {2016-06-19 19:50:04.1234567}\ 74f1f402-ddef-4027-a78f-3847fa97b830" \ {{} 0 1 1.2 three {4 5 6} {2016-06-19\ 19:50:04.1234567}\ ~~74f1f402-ddef-4027-a78f-3847fa97b830}]~~ 74f1f402-ddef-4027-a78f-3847fa97b830} \ {System.Data.SQLite.SQLiteBlob System.Data.SQLite.SQLiteBlob\ System.Data.SQLite.SQLiteBlob System.Data.SQLite.SQLiteBlob\ System.Data.SQLite.SQLiteBlob System.Data.SQLite.SQLiteBlob\ System.Data.SQLite.SQLiteBlob System.Data.SQLite.SQLiteBlob}] ############################################################################### set savedDateTimeFormat [object invoke Interpreter.GetActive DateTimeFormat] if {![isObjectHandle $savedDateTimeFormat]} then {set savedDateTimeFormat null} object invoke Interpreter.GetActive DateTimeFormat [getDateTimeFormat] ############################################################################### for {set i 0} {$i < [llength $params]} {incr i} { foreach { typeName methodName isArray propertyName isRequired value } [lindex $params $i] break set typeName [string map [list SDS. System.Data.SQLite.] $typeName] set expectedResult [lindex $expectedResults $i] ############################################################################# proc readValueCallback2 $readArgs [subst { if {$isArray} then { if {\[catch { ~~set dataOffset \[\$eventArgs ~~Array~~EventArgs.DataOffset\]~~ set dataOffset \[\$eventArgs ExtraEventArgs.DataOffset\] ~~set buffer \[\$eventArgs -create [appendArgs ~~Array~~EventArgs. \~~ set buffer \[\$eventArgs -create [appendArgs ExtraEventArgs. \ $typeName Buffer]\] ~~set bufferOffset \[\$eventArgs ~~Array~~EventArgs.BufferOffset\] set length \[\$eventArgs ~~Array~~EventArgs.Length\]~~ set bufferOffset \[\$eventArgs ExtraEventArgs.BufferOffset\] set length \[\$eventArgs ExtraEventArgs.Length\] set readValue \[\$dataReader \[\$eventArgs MethodName\] \ \$index \$dataOffset \$buffer \$bufferOffset \$length\] \$eventArgs \[appendArgs Value. $propertyName\] \$readValue } error\]} then { set readValue \[\$dataReader -tostring GetValue \$index\] if {"$typeName" eq "Char"} then { set string \[object create -alias String \$readValue\] set buffer \[\$string -create -alias ToCharArray] } else { set buffer \[object invoke -create -alias \ System.Text.Encoding.UTF8 GetBytes \$readValue\] } \$eventArgs \[appendArgs Value. $propertyName\] \$buffer ~~\$eventArgs ~~Array~~EventArgs.Length \[\$buffer Length\]~~ \$eventArgs ExtraEventArgs.Length \[\$buffer Length\] } else { ~~set buffer \[\$eventArgs -create [appendArgs ~~Array~~EventArgs. \~~ set buffer \[\$eventArgs -create [appendArgs ExtraEventArgs. \ $typeName Buffer]\] \$eventArgs \[appendArgs Value. $propertyName\] \$buffer } } else { if {\[catch { if {"$typeName" eq "System.Data.SQLite.SQLiteBlob"} then { set readValue \[object create -flags +NonPublic $typeName \ null null\] } else { ~~set readValue \[\$dataReader \[\$eventArgs MethodName\] \$index\]~~ set readValue \[\$dataReader \[\$eventArgs MethodName\] \$index\] ~~if {"$typeName" eq "Char"} then { set readValue \[object invoke -create Char Parse \$readValue\]~~ if {"$typeName" eq "Char"} then { set readValue \[object invoke -create Char Parse \$readValue\] } } \$eventArgs \[appendArgs Value. $propertyName\] \$readValue } error\]} then { \$eventArgs \[appendArgs Value. $propertyName\] {$value} } }
︙
292 293 294 295 296 297 298 ~~299~~ 300 301 302 303 304 305 306	303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321	+ + + - + +	$list 0 [expr {$value - 1}] false] } } else { lappend result [list error(array) $::errorCode] } } else { if {[catch { if {$typeName eq "System.Data.SQLite.SQLiteBlob"} then { $dataReader $methodName 0 true; # read-only } else { ~~$dataReader $methodName 0~~ $dataReader $methodName 0 } } value] == 0} then { if {$value eq "\x00"} then { lappend result <NUL> } else { lappend result [getStringFromObjectHandle $value] } } else {
︙

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15	1 2 3 4 5 6 7 8 9 10 11 12 13 14 15	- +	<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title></title> </head> <body> ADO.NET SQLite Data Provider<br /> ~~Version 1.0.102.0 - Ju~~ne 23~~, 2016<br />~~ Version 1.0.103.0 - August XX, 2016 <font color="red">(release scheduled)</font><br /> Using <a href="https://www.sqlite.org/releaselog/3_13_0.html">SQLite 3.13.0</a><br /> Originally written by Robert Simpson<br /> Released to the public domain, use at your own risk!<br /> Official provider website: <a href="https://system.data.sqlite.org/">https://system.data.sqlite.org/</a><br /> Legacy versions: <a href="http://sqlite.phxsoftware.com/">http://sqlite.phxsoftware.com/</a><br /> <br /> The current development version can be downloaded from <a href="https://system.data.sqlite.org/index.html/timeline?y=ci">
︙
142 143 144 145 146 147 148 ~~149~~ 150 151 152 153 154 155 156	142 143 144 145 146 147 148 149 150 151 152 153 154 155 156	- +	app.config file:<br /> <pre> <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.102.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />~~ type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.103.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" /> </DbProviderFactories> </system.data> </configuration> </pre> <p> See the help documentation for further details on implementing both version-specific (GAC enabled) and version independent DBProviderFactories support.
︙
204 205 206 207 208 209 210 211 212 213 214 215 216 217	204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227	+ + + + + + + + + +	supported <a href="https://www.sqlite.org/compile.html">compile-time options</a> designed for robustness and maximum backward compatibility with previously released versions of System.Data.SQLite. </p> <h2><b>Version History</b></h2> <p> <b>1.0.103.0 - August XX, 2016 <font color="red">(release scheduled)</font></b> </p> <ul> <li>Change the SQLiteReadValueCallback delegate "eventArgs" parameter to be of type SQLiteReadEventArgs. <b> Potentially Incompatible Change </b></li> <li>Make SQLiteReadValueEventArgs and SQLiteReadArrayEventArgs derive from SQLiteReadEventArgs. <b> Potentially Incompatible Change </b></li> <li>Rename SQLiteReadValueEventArgs.ArrayEventArgs property to ExtraEventArgs. <b> Potentially Incompatible Change </b></li> <li>Add NoVerifyTypeAffinity connection flag to disable all type affinity checking.</li> <li>Add support for <a href="https://www.sqlite.org/c3ref/blob_open.html">incremental blob I/O</a>.</li> </ul> <p> <b>1.0.102.0 - June 23, 2016</b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_13_0.html">SQLite 3.13.0</a>.</li> <li>Update the SQLiteConnection.EnableExtensions method to make use of the new SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION option, when available. <b> Potentially Incompatible Change </b></li> <li>Prevent the SQLiteCommand.ExecuteScalar method from throwing an exception when there are no result columns. <b> Potentially Incompatible Change </b></li>
︙