Python get_table_info示例

示例#1

文件： db_inspector.py 项目： micheles/sqlplain

 def print_table(self, fullname):
     with self.conn as conn:
         try:
             schema, tname = fullname.split('.')
         except ValueError:
             schema, tname = fullname, None
         pprint(util.get_table_info(conn, tname, schema))

示例#2

文件： test_util.py 项目： micheles/sqlplain

def test_introspection():
    from sqlplain import core, util, _util
    with core.ScratchDB(
            'config://scratch/psycopg2_uri', _util.createbook) as db:
        assert_equal(
            util.get_table_info(db.conn, 'book_author'),
            ['book_author', ['code', 'author_id'], [],
             {'author_id': 'public.author.id',
              'code': 'public.book.code'}])
        assert_equal(
            util.get_schema_info(db.conn),
            [['author', ['id'], ['firstname', 'lastname'], {}],
             ['book', ['code'], ['title', 'score'],
              {'score': 'public.score.value'}],
             ['book_author', ['code', 'author_id'], [],
              {'author_id': 'public.author.id', 'code': 'public.book.code'}],
             ['reading_history', ['code'], ['date'],
              {'code': 'public.book.code'}],
             ['score', ['value'], ['evaluation'], {}]])