tbl: for sql tables

python wrapper for sql tables.

t = tbl("<target in .dbc>")
print(t.tables())

documentation here.

install

download tbl whl from here. install whl with pip:

pip install tbl-<version>.whl

see dbcq for database connection setup.

functions:

fields
fieldtypes
deletefrom
fk
fkfromt
fkfromtf
fktot
fktotf
identities
insert
update
pk
tables

supports mssql at the moment. fk, fields and tables also support sqlite.

cli

use from the command line like:

tbl <db target> <subcommand>

with subcommands:

  fk           all foreign keys as json
  tables       all tables as json
  fields <tablename>   fields of a table as json
  table <tablename>    human readable table summary