System.Data.SQLite

            {
                SQLiteMemory.Free(pName);
                pName = IntPtr.Zero;
            }
        }
    }
#endif

    /// <summary>
    /// Builds an error message string fragment containing the
    /// defined values of the <see cref="SQLiteStatusOpsEnum" />
    /// enumeration.
    /// </summary>
    /// <returns>
    /// The built string fragment.
    /// </returns>
    private static string GetStatusDbOpsNames()
    {
        StringBuilder builder = new StringBuilder();

#if !PLATFORM_COMPACTFRAMEWORK
        foreach (string name in Enum.GetNames(
                typeof(SQLiteStatusOpsEnum)))
        {
            if (String.IsNullOrEmpty(name))
                continue;

            if (builder.Length > 0)
                builder.Append(", ");

            builder.Append(name);
        }
#else
        //
        // TODO: Update this list if the available values in the
        //       "SQLiteConfigDbOpsEnum" enumeration change.
        //
        builder.AppendFormat(CultureInfo.InvariantCulture,
            "{0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9}, {10}, {11}",
            SQLiteStatusOpsEnum.SQLITE_DBSTATUS_LOOKASIDE_USED,
            SQLiteStatusOpsEnum.SQLITE_DBSTATUS_CACHE_USED,
            SQLiteStatusOpsEnum.SQLITE_DBSTATUS_SCHEMA_USED,
            SQLiteStatusOpsEnum.SQLITE_DBSTATUS_STMT_USED,
            SQLiteStatusOpsEnum.SQLITE_DBSTATUS_LOOKASIDE_HIT,
            SQLiteStatusOpsEnum.SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE,
            SQLiteStatusOpsEnum.SQLITE_DBSTATUS_LOOKASIDE_MISS_FULL,
            SQLiteStatusOpsEnum.SQLITE_DBSTATUS_CACHE_HIT,
            SQLiteStatusOpsEnum.SQLITE_DBSTATUS_CACHE_MISS,
            SQLiteStatusOpsEnum.SQLITE_DBSTATUS_CACHE_WRITE,
            SQLiteStatusOpsEnum.SQLITE_DBSTATUS_DEFERRED_FKS,
            SQLiteStatusOpsEnum.SQLITE_DBSTATUS_CACHE_USED_SHARED);
#endif

        return builder.ToString();
    }

    /// <summary>
    /// Builds an error message string fragment containing the
    /// defined values of the <see cref="SQLiteConfigDbOpsEnum" />
    /// enumeration.
    /// </summary>
    /// <returns>

            SQLiteConfigDbOpsEnum.SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE,
            SQLiteConfigDbOpsEnum.SQLITE_DBCONFIG_ENABLE_QPSG,
            SQLiteConfigDbOpsEnum.SQLITE_DBCONFIG_TRIGGER_EQP);
#endif

        return builder.ToString();
    }

    /// <summary>
    /// Returns the current and/or highwater values for the specified
    /// database status parameter.
    /// </summary>
    /// <param name="option">
    /// The database status parameter to query.
    /// </param>
    /// <param name="reset">
    /// Non-zero to reset the highwater value to the current value.
    /// </param>
    /// <param name="current">
    /// If applicable, receives the current value.
    /// </param>
    /// <param name="highwater">
    /// If applicable, receives the highwater value.
    /// </param>
    /// <returns>
    /// A standard SQLite return code.
    /// </returns>
    internal override SQLiteErrorCode GetStatusParameter(
        SQLiteStatusOpsEnum option,
        bool reset,
        ref int current,
        ref int highwater
        )
    {
        if (!Enum.IsDefined(typeof(SQLiteStatusOpsEnum), option))
        {
            throw new SQLiteException(HelperMethods.StringFormat(
                CultureInfo.CurrentCulture,
                "unrecognized status option, must be: {0}",
                GetStatusDbOpsNames()));
        }

        return UnsafeNativeMethods.sqlite3_db_status(
            _sql, option, ref current, ref highwater, reset ? 1 : 0);
    }

    /// <summary>
    /// Change a configuration option value for the database.
    /// connection.
    /// </summary>
    /// <param name="option">
    /// The database configuration option to change.

    /// <returns>
    /// A standard SQLite return code.
    /// </returns>
    internal abstract SQLiteErrorCode DeclareVirtualFunction(SQLiteModule module, int argumentCount, string name, ref string error);
#endif

    /// <summary>
    /// Returns the current and/or highwater values for the specified database status parameter.
    /// </summary>
    /// <param name="option">
    /// The database status parameter to query.
    /// </param>
    /// <param name="reset">
    /// Non-zero to reset the highwater value to the current value.
    /// </param>
    /// <param name="current">
    /// If applicable, receives the current value.
    /// </param>
    /// <param name="highwater">
    /// If applicable, receives the highwater value.
    /// </param>
    /// <returns>
    /// A standard SQLite return code.
    /// </returns>
    internal abstract SQLiteErrorCode GetStatusParameter(SQLiteStatusOpsEnum option, bool reset, ref int current, ref int highwater);
    /// <summary>
    /// Change a configuration option value for the database.
    /// </summary>
    /// <param name="option">
    /// The database configuration option to change.
    /// </param>
    /// <param name="value">
    /// The new value for the specified configuration option.

      Default = LogDefault | BindInvariantDecimal | GetInvariantDecimal,

      /// <summary>
      /// The default extra flags for new connections with all logging enabled.
      /// </summary>
      DefaultAndLogAll = Default | LogAll
  }

  /// <summary>
  /// These are the supported status parameters for use with the native
  /// SQLite library.
  /// </summary>
  internal enum SQLiteStatusOpsEnum
  {
      /// <summary>
      /// This parameter returns the number of lookaside memory slots
      /// currently checked out.
      /// </summary>
      SQLITE_DBSTATUS_LOOKASIDE_USED = 0,

      /// <summary>
      /// This parameter returns the approximate number of bytes of
      /// heap memory used by all pager caches associated with the
      /// database connection. The highwater mark associated with
      /// SQLITE_DBSTATUS_CACHE_USED is always 0.
      /// </summary>
      SQLITE_DBSTATUS_CACHE_USED = 1,

      /// <summary>
      /// This parameter returns the approximate number of bytes of
      /// heap memory used to store the schema for all databases
      /// associated with the connection - main, temp, and any ATTACH-ed
      /// databases. The full amount of memory used by the schemas is
      /// reported, even if the schema memory is shared with other
      /// database connections due to shared cache mode being enabled.
      /// The highwater mark associated with SQLITE_DBSTATUS_SCHEMA_USED
      /// is always 0.
      /// </summary>
      SQLITE_DBSTATUS_SCHEMA_USED = 2,

      /// <summary>
      /// This parameter returns the number malloc attempts that might
      /// have been satisfied using lookaside memory but failed due to
      /// all lookaside memory already being in use. Only the high-water
      /// value is meaningful; the current value is always zero.
      /// </summary>
      SQLITE_DBSTATUS_STMT_USED = 3,

      /// <summary>
      /// This parameter returns the number malloc attempts that were
      /// satisfied using lookaside memory. Only the high-water value
      /// is meaningful; the current value is always zero.
      /// </summary>
      SQLITE_DBSTATUS_LOOKASIDE_HIT = 4,

      /// <summary>
      /// This parameter returns the number malloc attempts that might
      /// have been satisfied using lookaside memory but failed due to
      /// the amount of memory requested being larger than the lookaside
      /// slot size. Only the high-water value is meaningful; the current
      /// value is always zero.
      /// </summary>
      SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE = 5,

      /// <summary>
      /// This parameter returns the number malloc attempts that might
      /// have been satisfied using lookaside memory but failed due to
      /// the amount of memory requested being larger than the lookaside
      /// slot size. Only the high-water value is meaningful; the current
      /// value is always zero.
      /// </summary>
      SQLITE_DBSTATUS_LOOKASIDE_MISS_FULL = 6,

      /// <summary>
      /// This parameter returns the number of pager cache hits that
      /// have occurred. The highwater mark associated with
      /// SQLITE_DBSTATUS_CACHE_HIT is always 0.
      /// </summary>
      SQLITE_DBSTATUS_CACHE_HIT = 7,

      /// <summary>
      /// This parameter returns the number of pager cache misses that
      /// have occurred. The highwater mark associated with
      /// SQLITE_DBSTATUS_CACHE_MISS is always 0.
      /// </summary>
      SQLITE_DBSTATUS_CACHE_MISS = 8,

      /// <summary>
      /// This parameter returns the number of dirty cache entries that
      /// have been written to disk. Specifically, the number of pages
      /// written to the wal file in wal mode databases, or the number
      /// of pages written to the database file in rollback mode
      /// databases. Any pages written as part of transaction rollback
      /// or database recovery operations are not included. If an IO or
      /// other error occurs while writing a page to disk, the effect
      /// on subsequent SQLITE_DBSTATUS_CACHE_WRITE requests is
      /// undefined. The highwater mark associated with
      /// SQLITE_DBSTATUS_CACHE_WRITE is always 0.
      /// </summary>
      SQLITE_DBSTATUS_CACHE_WRITE = 9,

      /// <summary>
      /// This parameter returns zero for the current value if and only
      /// if all foreign key constraints (deferred or immediate) have
      /// been resolved. The highwater mark is always 0.
      /// </summary>
      SQLITE_DBSTATUS_DEFERRED_FKS = 10,

      /// <summary>
      /// This parameter is similar to DBSTATUS_CACHE_USED, except that
      /// if a pager cache is shared between two or more connections the
      /// bytes of heap memory used by that pager cache is divided evenly
      /// between the attached connections. In other words, if none of
      /// the pager caches associated with the database connection are
      /// shared, this request returns the same value as DBSTATUS_CACHE_USED.
      /// Or, if one or more or the pager caches are shared, the value
      /// returned by this call will be smaller than that returned by
      /// DBSTATUS_CACHE_USED. The highwater mark associated with
      /// SQLITE_DBSTATUS_CACHE_USED_SHARED is always 0.
      /// </summary>
      SQLITE_DBSTATUS_CACHE_USED_SHARED = 11
  }

  /// <summary>
  /// These are the supported configuration verbs for use with the native
  /// SQLite library.  They are used with the
  /// <see cref="SQLiteConnection.SetConfigurationOption" /> method.
  /// </summary>
  public enum SQLiteConfigDbOpsEnum

#if !PLATFORM_COMPACTFRAMEWORK
    [DllImport(SQLITE_DLL, EntryPoint = "sqlite3_db_config", CallingConvention = CallingConvention.Cdecl)]
#else
    [DllImport(SQLITE_DLL, EntryPoint = "sqlite3_db_config")]
#endif
    internal static extern SQLiteErrorCode sqlite3_db_config_intptr_two_ints(IntPtr db, SQLiteConfigDbOpsEnum op, IntPtr ptr, int int0, int int1);

#if !PLATFORM_COMPACTFRAMEWORK
    [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
#else
    [DllImport(SQLITE_DLL)]
#endif
    internal static extern SQLiteErrorCode sqlite3_db_status(IntPtr db, SQLiteStatusOpsEnum op, ref int current, ref int highwater, int resetFlag);

#if !PLATFORM_COMPACTFRAMEWORK
    [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
#else
    [DllImport(SQLITE_DLL)]
#endif
    internal static extern IntPtr sqlite3_rollback_hook(IntPtr db, SQLiteRollbackCallback func, IntPtr pvUser);

warning message} 231 {unknown error ==> unknown error} {0 {}}\
Ok_Load_Permanently {not an error ==> not an error} Error_Retry {SQL logic\
error ==> SQL logic error} IoErr_Short_Read {disk I/O error ==> disk I/O error}\
CantOpen_NoTempDir {unable to open database file ==> unable to open database\
file} Notice_Recover_Rollback {notification message ==> notification message}\
Warning_AutoIndex {warning message ==> warning message} 999 {unknown error ==>\
unknown error}}}

###############################################################################

runTest {test data-1.95 {SetConfigurationOption method} -setup {
  setupDb [set fileName data-1.95.db]
} -body {
  set dbConfigs [list]

  lappend dbConfigs SQLITE_DBCONFIG_NONE; # nil
  lappend dbConfigs SQLITE_DBCONFIG_MAINDBNAME; # char*
  lappend dbConfigs SQLITE_DBCONFIG_LOOKASIDE; # void* int int

  lappend dbConfigs SQLITE_DBCONFIG_ENABLE_FKEY; # int int*
  lappend dbConfigs SQLITE_DBCONFIG_ENABLE_TRIGGER; # int int*
  lappend dbConfigs SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER; # int int*
  lappend dbConfigs SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION; # int int*
  lappend dbConfigs SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE; # int int*
  lappend dbConfigs SQLITE_DBCONFIG_ENABLE_QPSG; # int int*
  lappend dbConfigs SQLITE_DBCONFIG_TRIGGER_EQP; # int int*

  set connection [getDbConnection]

  foreach dbConfig $dbConfigs {
    switch -exact -- $dbConfig {
      SQLITE_DBCONFIG_NONE {
        set value null
      }
      SQLITE_DBCONFIG_MAINDBNAME {
        set value [object create String test]
      }
      SQLITE_DBCONFIG_LOOKASIDE {
        if {[info exists ptr]} then {
          error "pointer value should not exist yet"
        }

        set ptr [object invoke -create -flags +NonPublic \
            System.Data.SQLite.SQLiteMemory Allocate 20000]

        set ints(0) [object invoke -create Int32 Parse 10000]
        set ints(1) [object invoke -create Int32 Parse 2]

        set value [object create -alias Object\[\] 3]

        $value SetValue $ptr 0
        $value SetValue $ints(0) 1
        $value SetValue $ints(1) 2
      }
      default {
        set value [object invoke -create System.Boolean Parse true]
      }
    }

    lappend result [$connection SetConfigurationOption $dbConfig $value]
  }

  sql execute $db {
    CREATE TABLE t1(x);
    INSERT INTO t1 (x) VALUES(RANDOMBLOB(1024));
  }

  set current 0; set highwater 0

  lappend result [$connection -flags +NonPublic \
      _sql.GetStatusParameter SQLITE_DBSTATUS_LOOKASIDE_USED \
      false current highwater]

  lappend result $current $highwater
} -cleanup {
  cleanupDb $fileName

  freeDbConnection

  if {[info exists ptr]} then {
    object invoke -flags +NonPublic \
        System.Data.SQLite.SQLiteMemory Free $ptr
  }

  unset -nocomplain current highwater ints ptr value
  unset -nocomplain result dbConfig dbConfigs
  unset -nocomplain connection db fileName
} -constraints {eagle monoBug28 command.sql compile.DATA SQLite\
System.Data.SQLite} -result {{} {} {} {} {} {} {} {} {} {} Ok 48 100}}

###############################################################################

reportSQLiteResources $test_channel

###############################################################################