2022-09-18 10:34:03,268 INFO sqlalchemy.engine.Engine select pg_catalog.version()
2022-09-18 10:34:03,268 INFO sqlalchemy.engine.Engine [raw sql] {}
2022-09-18 10:34:03,274 INFO sqlalchemy.engine.Engine select current_schema()
2022-09-18 10:34:03,274 INFO sqlalchemy.engine.Engine [raw sql] {}
2022-09-18 10:34:03,275 INFO sqlalchemy.engine.Engine show standard_conforming_strings
2022-09-18 10:34:03,276 INFO sqlalchemy.engine.Engine [raw sql] {}
2022-09-18 10:34:03,278 INFO sqlalchemy.engine.Engine SELECT c.relname FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname = %(schema)s AND c.relkind in ('r', 'p')
2022-09-18 10:34:03,279 INFO sqlalchemy.engine.Engine [generated in 0.00088s] {'schema': 'public'}
2022-09-18 10:34:03,283 INFO sqlalchemy.engine.Engine
            SELECT c.oid
            FROM pg_catalog.pg_class c
            LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
            WHERE (pg_catalog.pg_table_is_visible(c.oid))
            AND c.relname = %(table_name)s AND c.relkind in
            ('r', 'v', 'm', 'f', 'p')

2022-09-18 10:34:03,284 INFO sqlalchemy.engine.Engine [generated in 0.00127s] {'table_name': 'books'}
2022-09-18 10:34:03,285 INFO sqlalchemy.engine.Engine
            SELECT a.attname,
              pg_catalog.format_type(a.atttypid, a.atttypmod),
              (
                SELECT pg_catalog.pg_get_expr(d.adbin, d.adrelid)
                FROM pg_catalog.pg_attrdef d
                WHERE d.adrelid = a.attrelid AND d.adnum = a.attnum
                AND a.atthasdef
              ) AS DEFAULT,
              a.attnotnull,
              a.attrelid as table_oid,
              pgd.description as comment,
              a.attgenerated as generated,
                              (SELECT json_build_object(
                    'always', a.attidentity = 'a',
                    'start', s.seqstart,
                    'increment', s.seqincrement,
                    'minvalue', s.seqmin,
                    'maxvalue', s.seqmax,
                    'cache', s.seqcache,
                    'cycle', s.seqcycle)
                FROM pg_catalog.pg_sequence s
                JOIN pg_catalog.pg_class c on s.seqrelid = c."oid"
                WHERE c.relkind = 'S'
                AND a.attidentity != ''
                AND s.seqrelid = pg_catalog.pg_get_serial_sequence(
                    a.attrelid::regclass::text, a.attname
                )::regclass::oid
                ) as identity_options
            FROM pg_catalog.pg_attribute a
            LEFT JOIN pg_catalog.pg_description pgd ON (
                pgd.objoid = a.attrelid AND pgd.objsubid = a.attnum)
            WHERE a.attrelid = %(table_oid)s
            AND a.attnum > 0 AND NOT a.attisdropped
            ORDER BY a.attnum

2022-09-18 10:34:03,289 INFO sqlalchemy.engine.Engine [generated in 0.00334s] {'table_oid': 16928}
2022-09-18 10:34:03,296 INFO sqlalchemy.engine.Engine
            SELECT t.typname as "name",
               pg_catalog.format_type(t.typbasetype, t.typtypmod) as "attype",
               not t.typnotnull as "nullable",
               t.typdefault as "default",
               pg_catalog.pg_type_is_visible(t.oid) as "visible",
               n.nspname as "schema"
            FROM pg_catalog.pg_type t
               LEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace
            WHERE t.typtype = 'd'

2022-09-18 10:34:03,297 INFO sqlalchemy.engine.Engine [generated in 0.00147s] {}
2022-09-18 10:34:03,299 INFO sqlalchemy.engine.Engine
            SELECT t.typname as "name",
               -- no enum defaults in 8.4 at least
               -- t.typdefault as "default",
               pg_catalog.pg_type_is_visible(t.oid) as "visible",
               n.nspname as "schema",
               e.enumlabel as "label"
            FROM pg_catalog.pg_type t
                 LEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace
                 LEFT JOIN pg_catalog.pg_enum e ON t.oid = e.enumtypid
            WHERE t.typtype = 'e'
        ORDER BY "schema", "name", e.oid
2022-09-18 10:34:03,300 INFO sqlalchemy.engine.Engine [generated in 0.00128s] {}
2022-09-18 10:34:03,305 INFO sqlalchemy.engine.Engine
                SELECT a.attname
                FROM pg_attribute a JOIN (
                    SELECT unnest(ix.indkey) attnum,
                           generate_subscripts(ix.indkey, 1) ord
                    FROM pg_index ix
                    WHERE ix.indrelid = %(table_oid)s AND ix.indisprimary
                    ) k ON a.attnum=k.attnum
                WHERE a.attrelid = %(table_oid)s
                ORDER BY k.ord

2022-09-18 10:34:03,305 INFO sqlalchemy.engine.Engine [generated in 0.00138s] {'table_oid': 16928}
2022-09-18 10:34:03,309 INFO sqlalchemy.engine.Engine
        SELECT conname
           FROM  pg_catalog.pg_constraint r
           WHERE r.conrelid = %(table_oid)s AND r.contype = 'p'
           ORDER BY 1

2022-09-18 10:34:03,310 INFO sqlalchemy.engine.Engine [generated in 0.00119s] {'table_oid': 16928}
2022-09-18 10:34:03,316 INFO sqlalchemy.engine.Engine
          SELECT r.conname,
                pg_catalog.pg_get_constraintdef(r.oid, true) as condef,
                n.nspname as conschema
          FROM  pg_catalog.pg_constraint r,
                pg_namespace n,
                pg_class c

          WHERE r.conrelid = %(table)s AND
                r.contype = 'f' AND
                c.oid = confrelid AND
                n.oid = c.relnamespace
          ORDER BY 1

2022-09-18 10:34:03,318 INFO sqlalchemy.engine.Engine [generated in 0.00172s] {'table': 16928}
2022-09-18 10:34:03,321 INFO sqlalchemy.engine.Engine
              SELECT
                  i.relname as relname,
                  ix.indisunique, ix.indexprs,
                  a.attname, a.attnum, c.conrelid, ix.indkey::varchar,
                  ix.indoption::varchar, i.reloptions, am.amname,
                  pg_get_expr(ix.indpred, ix.indrelid),
                  ix.indnkeyatts as indnkeyatts
              FROM
                  pg_class t
                        join pg_index ix on t.oid = ix.indrelid
                        join pg_class i on i.oid = ix.indexrelid
                        left outer join
                            pg_attribute a
                            on t.oid = a.attrelid and a.attnum = ANY(ix.indkey)
                        left outer join
                            pg_constraint c
                            on (ix.indrelid = c.conrelid and
                                ix.indexrelid = c.conindid and
                                c.contype in ('p', 'u', 'x'))
                        left outer join
                            pg_am am
                            on i.relam = am.oid
              WHERE
                  t.relkind IN ('r', 'v', 'f', 'm', 'p')
                  and t.oid = %(table_oid)s
                  and ix.indisprimary = 'f'
              ORDER BY
                  t.relname,
                  i.relname

2022-09-18 10:34:03,324 INFO sqlalchemy.engine.Engine [generated in 0.00351s] {'table_oid': 16928}
2022-09-18 10:34:03,330 INFO sqlalchemy.engine.Engine
            SELECT
                cons.conname as name,
                cons.conkey as key,
                a.attnum as col_num,
                a.attname as col_name
            FROM
                pg_catalog.pg_constraint cons
                join pg_attribute a
                  on cons.conrelid = a.attrelid AND
                    a.attnum = ANY(cons.conkey)
            WHERE
                cons.conrelid = %(table_oid)s AND
                cons.contype = 'u'

2022-09-18 10:34:03,332 INFO sqlalchemy.engine.Engine [generated in 0.00189s] {'table_oid': 16928}
2022-09-18 10:34:03,334 INFO sqlalchemy.engine.Engine
            SELECT
                cons.conname as name,
                pg_get_constraintdef(cons.oid) as src
            FROM
                pg_catalog.pg_constraint cons
            WHERE
                cons.conrelid = %(table_oid)s AND
                cons.contype = 'c'

2022-09-18 10:34:03,335 INFO sqlalchemy.engine.Engine [generated in 0.00168s] {'table_oid': 16928}
2022-09-18 10:34:03,337 INFO sqlalchemy.engine.Engine
            SELECT
                pgd.description as table_comment
            FROM
                pg_catalog.pg_description pgd
            WHERE
                pgd.objsubid = 0 AND
                pgd.objoid = %(table_oid)s

2022-09-18 10:34:03,338 INFO sqlalchemy.engine.Engine [generated in 0.00129s] {'table_oid': 16928}
2022-09-18 10:34:03,340 INFO sqlalchemy.engine.Engine BEGIN (implicit)
2022-09-18 10:34:03,378 INFO sqlalchemy.engine.Engine select relname from pg_class c join pg_namespace n on n.oid=c.relnamespace where pg_catalog.pg_table_is_visible(c.oid) and relname=%(name)s
2022-09-18 10:34:03,378 INFO sqlalchemy.engine.Engine [generated in 0.00074s] {'name': 'books'}
2022-09-18 10:34:03,380 INFO sqlalchemy.engine.Engine
DROP TABLE books
2022-09-18 10:34:03,381 INFO sqlalchemy.engine.Engine [no key 0.00059s] {}
2022-09-18 10:34:03,387 INFO sqlalchemy.engine.Engine COMMIT
2022-09-18 10:34:03,412 INFO sqlalchemy.engine.Engine BEGIN (implicit)
2022-09-18 10:34:03,413 INFO sqlalchemy.engine.Engine select relname from pg_class c join pg_namespace n on n.oid=c.relnamespace where pg_catalog.pg_table_is_visible(c.oid) and relname=%(name)s
2022-09-18 10:34:03,414 INFO sqlalchemy.engine.Engine [cached since 0.03573s ago] {'name': 'books'}
2022-09-18 10:34:03,415 INFO sqlalchemy.engine.Engine
CREATE TABLE books (
        id SERIAL NOT NULL,
        title VARCHAR,
        author VARCHAR,
        pages VARCHAR,
        published DATE,
        PRIMARY KEY (id)
)


2022-09-18 10:34:03,417 INFO sqlalchemy.engine.Engine [no key 0.00181s] {}
2022-09-18 10:34:03,552 INFO sqlalchemy.engine.Engine COMMIT
2022-09-18 10:34:03,588 INFO sqlalchemy.engine.Engine UPDATE books SET title=%(title)s WHERE books.author = %(author_1)s
2022-09-18 10:34:03,588 INFO sqlalchemy.engine.Engine [generated in 0.00054s] {'title': 'futurehead', 'author_1': 'jeoe'}
2022-09-18 10:34:03,590 INFO sqlalchemy.engine.Engine COMMIT