module Prostore::Adapter::SQLite::Introspect

Overview

SQLite introspection. Reads sqlite_master (for table names and the original CREATE TABLE SQL — useful for partial-index WHERE clauses that PRAGMA doesn't surface) and the pragma_* table-valued functions for column / index / FK details.

Extended Modules

Defined in:

prostore/adapter/sqlite/introspect.cr

Instance Method Summary

Instance Method Detail

def columns(executor : Prostore::Adapter::Base::Executor, table : String) : Array(LiveColumn) #

[View source]
def foreign_keys(executor : Prostore::Adapter::Base::Executor, table : String) : Array(LiveForeignKey) #

[View source]
def indexes(executor : Prostore::Adapter::Base::Executor, table : String) : Array(LiveIndex) #

[View source]
def table(executor : Prostore::Adapter::Base::Executor, name : String) : LiveTable #

[View source]
def table_names(executor : Prostore::Adapter::Base::Executor) : Array(String) #

User tables (excludes sqlite_* internals; the planner caller filters out our prostore_* bookkeeping).


[View source]