module SQLite3::Pragmas

# File lib/sqlite3/pragmas.rb, line 101
def application_id
  get_int_pragma "application_id"
end

# File lib/sqlite3/pragmas.rb, line 105
def application_id=(integer)
  set_int_pragma "application_id", integer
end

# File lib/sqlite3/pragmas.rb, line 109
def auto_vacuum
  get_enum_pragma "auto_vacuum"
end

# File lib/sqlite3/pragmas.rb, line 113
def auto_vacuum=(mode)
  set_enum_pragma "auto_vacuum", mode, AUTO_VACUUM_MODES
end

# File lib/sqlite3/pragmas.rb, line 117
def automatic_index
  get_boolean_pragma "automatic_index"
end

# File lib/sqlite3/pragmas.rb, line 121
def automatic_index=(mode)
  set_boolean_pragma "automatic_index", mode
end

# File lib/sqlite3/pragmas.rb, line 125
def busy_timeout
  get_int_pragma "busy_timeout"
end

# File lib/sqlite3/pragmas.rb, line 129
def busy_timeout=(milliseconds)
  set_int_pragma "busy_timeout", milliseconds
end

# File lib/sqlite3/pragmas.rb, line 133
def cache_size
  get_int_pragma "cache_size"
end

# File lib/sqlite3/pragmas.rb, line 137
def cache_size=(size)
  set_int_pragma "cache_size", size
end

# File lib/sqlite3/pragmas.rb, line 141
def cache_spill
  get_boolean_pragma "cache_spill"
end

# File lib/sqlite3/pragmas.rb, line 145
def cache_spill=(mode)
  set_boolean_pragma "cache_spill", mode
end

# File lib/sqlite3/pragmas.rb, line 149
def case_sensitive_like=(mode)
  set_boolean_pragma "case_sensitive_like", mode
end

# File lib/sqlite3/pragmas.rb, line 153
def cell_size_check
  get_boolean_pragma "cell_size_check"
end

# File lib/sqlite3/pragmas.rb, line 157
def cell_size_check=(mode)
  set_boolean_pragma "cell_size_check", mode
end

# File lib/sqlite3/pragmas.rb, line 161
def checkpoint_fullfsync
  get_boolean_pragma "checkpoint_fullfsync"
end

# File lib/sqlite3/pragmas.rb, line 165
def checkpoint_fullfsync=(mode)
  set_boolean_pragma "checkpoint_fullfsync", mode
end

# File lib/sqlite3/pragmas.rb, line 169
def collation_list(&block) # :yields: row
  get_query_pragma "collation_list", &block
end

# File lib/sqlite3/pragmas.rb, line 173
def compile_options(&block) # :yields: row
  get_query_pragma "compile_options", &block
end

# File lib/sqlite3/pragmas.rb, line 177
def count_changes
  get_boolean_pragma "count_changes"
end

# File lib/sqlite3/pragmas.rb, line 181
def count_changes=(mode)
  set_boolean_pragma "count_changes", mode
end

# File lib/sqlite3/pragmas.rb, line 185
def data_version
  get_int_pragma "data_version"
end

# File lib/sqlite3/pragmas.rb, line 189
def database_list(&block) # :yields: row
  get_query_pragma "database_list", &block
end

# File lib/sqlite3/pragmas.rb, line 193
def default_cache_size
  get_int_pragma "default_cache_size"
end

# File lib/sqlite3/pragmas.rb, line 197
def default_cache_size=(size)
  set_int_pragma "default_cache_size", size
end

# File lib/sqlite3/pragmas.rb, line 201
def default_synchronous
  get_enum_pragma "default_synchronous"
end

# File lib/sqlite3/pragmas.rb, line 205
def default_synchronous=(mode)
  set_enum_pragma "default_synchronous", mode, SYNCHRONOUS_MODES
end

# File lib/sqlite3/pragmas.rb, line 209
def default_temp_store
  get_enum_pragma "default_temp_store"
end

# File lib/sqlite3/pragmas.rb, line 213
def default_temp_store=(mode)
  set_enum_pragma "default_temp_store", mode, TEMP_STORE_MODES
end

# File lib/sqlite3/pragmas.rb, line 217
def defer_foreign_keys
  get_boolean_pragma "defer_foreign_keys"
end

# File lib/sqlite3/pragmas.rb, line 221
def defer_foreign_keys=(mode)
  set_boolean_pragma "defer_foreign_keys", mode
end

# File lib/sqlite3/pragmas.rb, line 225
def encoding
  get_enum_pragma "encoding"
end

# File lib/sqlite3/pragmas.rb, line 229
def encoding=(mode)
  set_enum_pragma "encoding", mode, ENCODINGS
end

# File lib/sqlite3/pragmas.rb, line 233
def foreign_key_check(*table, &block) # :yields: row
  get_query_pragma "foreign_key_check", *table, &block
end

# File lib/sqlite3/pragmas.rb, line 237
def foreign_key_list(table, &block) # :yields: row
  get_query_pragma "foreign_key_list", table, &block
end

# File lib/sqlite3/pragmas.rb, line 241
def foreign_keys
  get_boolean_pragma "foreign_keys"
end

# File lib/sqlite3/pragmas.rb, line 245
def foreign_keys=(mode)
  set_boolean_pragma "foreign_keys", mode
end

# File lib/sqlite3/pragmas.rb, line 249
def freelist_count
  get_int_pragma "freelist_count"
end

# File lib/sqlite3/pragmas.rb, line 253
def full_column_names
  get_boolean_pragma "full_column_names"
end

# File lib/sqlite3/pragmas.rb, line 257
def full_column_names=(mode)
  set_boolean_pragma "full_column_names", mode
end

# File lib/sqlite3/pragmas.rb, line 261
def fullfsync
  get_boolean_pragma "fullfsync"
end

# File lib/sqlite3/pragmas.rb, line 265
def fullfsync=(mode)
  set_boolean_pragma "fullfsync", mode
end

# File lib/sqlite3/pragmas.rb, line 11
def get_boolean_pragma(name)
  get_first_value("PRAGMA #{name}") != 0
end

# File lib/sqlite3/pragmas.rb, line 51
def get_enum_pragma(name)
  get_first_value("PRAGMA #{name}")
end

# File lib/sqlite3/pragmas.rb, line 69
def get_int_pragma(name)
  get_first_value("PRAGMA #{name}").to_i
end

# File lib/sqlite3/pragmas.rb, line 41
def get_query_pragma(name, *params, &block) # :yields: row
  if params.empty?
    execute("PRAGMA #{name}", &block)
  else
    args = "'" + params.join("','") + "'"
    execute("PRAGMA #{name}( #{args} )", &block)
  end
end

# File lib/sqlite3/pragmas.rb, line 269
def ignore_check_constraints=(mode)
  set_boolean_pragma "ignore_check_constraints", mode
end

# File lib/sqlite3/pragmas.rb, line 273
def incremental_vacuum(pages, &block) # :yields: row
  get_query_pragma "incremental_vacuum", pages, &block
end

# File lib/sqlite3/pragmas.rb, line 277
def index_info(index, &block) # :yields: row
  get_query_pragma "index_info", index, &block
end

# File lib/sqlite3/pragmas.rb, line 281
def index_list(table, &block) # :yields: row
  get_query_pragma "index_list", table, &block
end

# File lib/sqlite3/pragmas.rb, line 285
def index_xinfo(index, &block) # :yields: row
  get_query_pragma "index_xinfo", index, &block
end

# File lib/sqlite3/pragmas.rb, line 289
def integrity_check(*num_errors, &block) # :yields: row
  get_query_pragma "integrity_check", *num_errors, &block
end

# File lib/sqlite3/pragmas.rb, line 293
def journal_mode
  get_enum_pragma "journal_mode"
end

# File lib/sqlite3/pragmas.rb, line 297
def journal_mode=(mode)
  set_enum_pragma "journal_mode", mode, JOURNAL_MODES
end

# File lib/sqlite3/pragmas.rb, line 301
def journal_size_limit
  get_int_pragma "journal_size_limit"
end

# File lib/sqlite3/pragmas.rb, line 305
def journal_size_limit=(size)
  set_int_pragma "journal_size_limit", size
end

# File lib/sqlite3/pragmas.rb, line 309
def legacy_file_format
  get_boolean_pragma "legacy_file_format"
end

# File lib/sqlite3/pragmas.rb, line 313
def legacy_file_format=(mode)
  set_boolean_pragma "legacy_file_format", mode
end

# File lib/sqlite3/pragmas.rb, line 317
def locking_mode
  get_enum_pragma "locking_mode"
end

# File lib/sqlite3/pragmas.rb, line 321
def locking_mode=(mode)
  set_enum_pragma "locking_mode", mode, LOCKING_MODES
end

# File lib/sqlite3/pragmas.rb, line 325
def max_page_count
  get_int_pragma "max_page_count"
end

# File lib/sqlite3/pragmas.rb, line 329
def max_page_count=(size)
  set_int_pragma "max_page_count", size
end

# File lib/sqlite3/pragmas.rb, line 333
def mmap_size
  get_int_pragma "mmap_size"
end

# File lib/sqlite3/pragmas.rb, line 337
def mmap_size=(size)
  set_int_pragma "mmap_size", size
end

# File lib/sqlite3/pragmas.rb, line 347
def optimize(bitmask = nil)
  if bitmask
    set_int_pragma "optimize", bitmask
  else
    execute("PRAGMA optimize")
  end
end

# File lib/sqlite3/pragmas.rb, line 355
def page_count
  get_int_pragma "page_count"
end

# File lib/sqlite3/pragmas.rb, line 359
def page_size
  get_int_pragma "page_size"
end

# File lib/sqlite3/pragmas.rb, line 363
def page_size=(size)
  set_int_pragma "page_size", size
end

# File lib/sqlite3/pragmas.rb, line 367
def parser_trace=(mode)
  set_boolean_pragma "parser_trace", mode
end

# File lib/sqlite3/pragmas.rb, line 371
def query_only
  get_boolean_pragma "query_only"
end

# File lib/sqlite3/pragmas.rb, line 375
def query_only=(mode)
  set_boolean_pragma "query_only", mode
end

# File lib/sqlite3/pragmas.rb, line 379
def quick_check(*num_errors, &block) # :yields: row
  get_query_pragma "quick_check", *num_errors, &block
end

# File lib/sqlite3/pragmas.rb, line 383
def read_uncommitted
  get_boolean_pragma "read_uncommitted"
end

# File lib/sqlite3/pragmas.rb, line 387
def read_uncommitted=(mode)
  set_boolean_pragma "read_uncommitted", mode
end

# File lib/sqlite3/pragmas.rb, line 391
def recursive_triggers
  get_boolean_pragma "recursive_triggers"
end

# File lib/sqlite3/pragmas.rb, line 395
def recursive_triggers=(mode)
  set_boolean_pragma "recursive_triggers", mode
end

# File lib/sqlite3/pragmas.rb, line 399
def reverse_unordered_selects
  get_boolean_pragma "reverse_unordered_selects"
end

# File lib/sqlite3/pragmas.rb, line 403
def reverse_unordered_selects=(mode)
  set_boolean_pragma "reverse_unordered_selects", mode
end

# File lib/sqlite3/pragmas.rb, line 407
def schema_cookie
  get_int_pragma "schema_cookie"
end

# File lib/sqlite3/pragmas.rb, line 411
def schema_cookie=(cookie)
  set_int_pragma "schema_cookie", cookie
end

# File lib/sqlite3/pragmas.rb, line 415
def schema_version
  get_int_pragma "schema_version"
end

# File lib/sqlite3/pragmas.rb, line 419
def schema_version=(version)
  set_int_pragma "schema_version", version
end

# File lib/sqlite3/pragmas.rb, line 423
def secure_delete
  get_boolean_pragma "secure_delete"
end

# File lib/sqlite3/pragmas.rb, line 427
def secure_delete=(mode)
  set_boolean_pragma "secure_delete", mode
end

# File lib/sqlite3/pragmas.rb, line 18
def set_boolean_pragma(name, mode)
  case mode
  when String
    case mode.downcase
    when "on", "yes", "true", "y", "t" then mode = "'ON'"
    when "off", "no", "false", "n", "f" then mode = "'OFF'"
    else
      raise SQLite3::Exception, "unrecognized pragma parameter #{mode.inspect}"
    end
  when true, 1
    mode = "ON"
  when false, 0, nil
    mode = "OFF"
  else
    raise SQLite3::Exception, "unrecognized pragma parameter #{mode.inspect}"
  end

  execute("PRAGMA #{name}=#{mode}")
end

# File lib/sqlite3/pragmas.rb, line 60
def set_enum_pragma(name, mode, enums)
  match = enums.find { |p| p.find { |i| i.to_s.downcase == mode.to_s.downcase } }
  unless match
    raise SQLite3::Exception, "unrecognized #{name} #{mode.inspect}"
  end
  execute("PRAGMA #{name}='#{match.first.upcase}'")
end

# File lib/sqlite3/pragmas.rb, line 75
def set_int_pragma(name, value)
  execute("PRAGMA #{name}=#{value.to_i}")
end

# File lib/sqlite3/pragmas.rb, line 431
def short_column_names
  get_boolean_pragma "short_column_names"
end

# File lib/sqlite3/pragmas.rb, line 435
def short_column_names=(mode)
  set_boolean_pragma "short_column_names", mode
end

# File lib/sqlite3/pragmas.rb, line 439
def shrink_memory
  execute("PRAGMA shrink_memory")
end

# File lib/sqlite3/pragmas.rb, line 443
def soft_heap_limit
  get_int_pragma "soft_heap_limit"
end

# File lib/sqlite3/pragmas.rb, line 447
def soft_heap_limit=(mode)
  set_int_pragma "soft_heap_limit", mode
end

# File lib/sqlite3/pragmas.rb, line 451
def stats(&block) # :yields: row
  get_query_pragma "stats", &block
end

# File lib/sqlite3/pragmas.rb, line 455
def synchronous
  get_enum_pragma "synchronous"
end

# File lib/sqlite3/pragmas.rb, line 459
def synchronous=(mode)
  set_enum_pragma "synchronous", mode, SYNCHRONOUS_MODES
end

# File lib/sqlite3/pragmas.rb, line 538
def table_info table
  stmt = prepare "PRAGMA table_info(#{table})"
  columns = stmt.columns

  needs_tweak_default =
    version_compare(SQLite3.libversion.to_s, "3.3.7") > 0

  result = [] unless block_given?
  stmt.each do |row|
    new_row = columns.zip(row).to_h

    tweak_default(new_row) if needs_tweak_default

    # Ensure the type value is downcased.  On Mac and Windows
    # platforms this value is now being returned as all upper
    # case.
    if new_row["type"]
      new_row["type"] = new_row["type"].downcase
    end

    if block_given?
      yield new_row
    else
      result << new_row
    end
  end
  stmt.close

  result
end

# File lib/sqlite3/pragmas.rb, line 463
def temp_store
  get_enum_pragma "temp_store"
end

# File lib/sqlite3/pragmas.rb, line 467
def temp_store=(mode)
  set_enum_pragma "temp_store", mode, TEMP_STORE_MODES
end

# File lib/sqlite3/pragmas.rb, line 471
def threads
  get_int_pragma "threads"
end

# File lib/sqlite3/pragmas.rb, line 475
def threads=(count)
  set_int_pragma "threads", count
end

# File lib/sqlite3/pragmas.rb, line 479
def user_cookie
  get_int_pragma "user_cookie"
end

# File lib/sqlite3/pragmas.rb, line 483
def user_cookie=(cookie)
  set_int_pragma "user_cookie", cookie
end

# File lib/sqlite3/pragmas.rb, line 487
def user_version
  get_int_pragma "user_version"
end

# File lib/sqlite3/pragmas.rb, line 491
def user_version=(version)
  set_int_pragma "user_version", version
end

# File lib/sqlite3/pragmas.rb, line 495
def vdbe_addoptrace=(mode)
  set_boolean_pragma "vdbe_addoptrace", mode
end

# File lib/sqlite3/pragmas.rb, line 499
def vdbe_debug=(mode)
  set_boolean_pragma "vdbe_debug", mode
end

# File lib/sqlite3/pragmas.rb, line 503
def vdbe_listing=(mode)
  set_boolean_pragma "vdbe_listing", mode
end

# File lib/sqlite3/pragmas.rb, line 507
def vdbe_trace
  get_boolean_pragma "vdbe_trace"
end

# File lib/sqlite3/pragmas.rb, line 511
def vdbe_trace=(mode)
  set_boolean_pragma "vdbe_trace", mode
end

# File lib/sqlite3/pragmas.rb, line 515
def wal_autocheckpoint
  get_int_pragma "wal_autocheckpoint"
end

# File lib/sqlite3/pragmas.rb, line 519
def wal_autocheckpoint=(mode)
  set_int_pragma "wal_autocheckpoint", mode
end

# File lib/sqlite3/pragmas.rb, line 523
def wal_checkpoint
  get_enum_pragma "wal_checkpoint"
end

# File lib/sqlite3/pragmas.rb, line 527
def wal_checkpoint=(mode)
  set_enum_pragma "wal_checkpoint", mode, WAL_CHECKPOINTS
end

# File lib/sqlite3/pragmas.rb, line 531
def writable_schema=(mode)
  set_boolean_pragma "writable_schema", mode
end