class DBSchema

• DBSchema
• Reference
• Object

Overview

This components holds

1. Table and content from a 'WITH' clause (derived)
2. Table and content from independent subqueries as derived table
3. Table and content from initial load anything
4. and of cource from running sql statemnets

Included Modules

• JSON::Serializable

Defined in:

pocketlib/dbschema.cr

Constructors

• .new(pull : JSON::PullParser)
• .new

Instance Method Summary

• #add_csv_table(loadfilename, colnames, filename) : ResultSet

  ---

• #add_cte_def(kind, tablename, comma_list)
• #add_result_set(rs)

  ---

• #add_value_table(kind, tablename, comma_list, rows)

  ---

• #all_tables_as_result

  ---

• #cte_and_derived_tables : Array(ResultSet)
• #cte_and_derived_tables=(cte_and_derived_tables : Array(ResultSet))
• #find_table(tbl_name : String) : ResultSet | Nil
• #find_table_by_name(name : TblName)
• #find_table_obj(tbl_name : String)
• #one_table_as_result(table_name : String)

  ---

• #save_to_dir(dirpath : String)
• #set_up_related_objs

  All 'Table' attributes are known to its name only Resolve 'Table' names to real Table instance at start time ---------------------------------------------------------------------------

• #tables : Array(Table)
• #tables=(tables : Array(Table))

Constructor Detail

Instance Method Detail