2020-02-28 15:22:34,174 INFO sqlalchemy.engine.base.Engine SELECT version()
2020-02-28 15:22:34,174 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:34,177 INFO sqlalchemy.engine.base.Engine SELECT current_schema()
2020-02-28 15:22:34,177 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:34,179 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1
2020-02-28 15:22:34,179 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:34,180 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1
2020-02-28 15:22:34,180 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:34,181 INFO sqlalchemy.engine.base.Engine SHOW standard_conforming_strings
2020-02-28 15:22:34,181 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:34,183 INFO sqlalchemy.engine.base.Engine
        SELECT pg_terminate_backend(pg_stat_activity.pid)
        FROM pg_stat_activity
        WHERE pg_stat_activity.datname = 'cars'
          AND pid <> pg_backend_pid();

2020-02-28 15:22:34,183 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:34,188 INFO sqlalchemy.engine.base.Engine DROP DATABASE cars
2020-02-28 15:22:34,188 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:34,473 INFO sqlalchemy.engine.base.Engine COMMIT
2020-02-28 15:22:34,484 INFO sqlalchemy.engine.base.Engine SELECT version()
2020-02-28 15:22:34,485 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:34,486 INFO sqlalchemy.engine.base.Engine SELECT current_schema()
2020-02-28 15:22:34,486 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:34,488 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1
2020-02-28 15:22:34,488 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:34,489 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1
2020-02-28 15:22:34,489 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:34,490 INFO sqlalchemy.engine.base.Engine SHOW standard_conforming_strings
2020-02-28 15:22:34,490 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:34,491 INFO sqlalchemy.engine.base.Engine SELECT 1 FROM pg_database WHERE datname='cars'
2020-02-28 15:22:34,491 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:34,509 INFO sqlalchemy.engine.base.Engine SELECT version()
2020-02-28 15:22:34,509 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:34,510 INFO sqlalchemy.engine.base.Engine SELECT current_schema()
2020-02-28 15:22:34,510 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:34,512 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1
2020-02-28 15:22:34,512 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:34,513 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1
2020-02-28 15:22:34,513 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:34,514 INFO sqlalchemy.engine.base.Engine SHOW standard_conforming_strings
2020-02-28 15:22:34,514 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:34,516 INFO sqlalchemy.engine.base.Engine CREATE DATABASE cars ENCODING 'utf8' TEMPLATE template1
2020-02-28 15:22:34,516 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:35,161 INFO sqlalchemy.engine.base.Engine COMMIT
2020-02-28 15:22:35,180 INFO sqlalchemy.engine.base.Engine SELECT version()
2020-02-28 15:22:35,181 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:35,181 INFO sqlalchemy.engine.base.Engine SELECT current_schema()
2020-02-28 15:22:35,182 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:35,183 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1
2020-02-28 15:22:35,183 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:35,184 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1
2020-02-28 15:22:35,184 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:35,184 INFO sqlalchemy.engine.base.Engine SHOW standard_conforming_strings
2020-02-28 15:22:35,185 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:35,186 INFO sqlalchemy.engine.base.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
2020-02-28 15:22:35,186 INFO sqlalchemy.engine.base.Engine {'name': 'images'}
2020-02-28 15:22:35,188 INFO sqlalchemy.engine.base.Engine
CREATE TABLE images (
    id_image SERIAL NOT NULL,
    id_pair INTEGER,
    path VARCHAR,
    superres BOOLEAN,
    TIMESTAMP TIMESTAMP WITHOUT TIME ZONE,
    PRIMARY KEY (id_image)
)


2020-02-28 15:22:35,189 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:35,291 INFO sqlalchemy.engine.base.Engine COMMIT
2020-02-28 15:22:35,307 INFO sqlalchemy.engine.base.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
2020-02-28 15:22:35,308 INFO sqlalchemy.engine.base.Engine {'name': 'crops'}
2020-02-28 15:22:35,311 INFO sqlalchemy.engine.base.Engine
CREATE TABLE crops (
    id_crop SERIAL NOT NULL,
    id_image INTEGER,
    name VARCHAR,
    path VARCHAR,
    labels JSON,
    PRIMARY KEY (id_crop),
    FOREIGN KEY(id_image) REFERENCES images (id_image)
)


2020-02-28 15:22:35,311 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:35,415 INFO sqlalchemy.engine.base.Engine COMMIT
2020-02-28 15:22:35,444 INFO sqlalchemy.engine.base.Engine SELECT version()
2020-02-28 15:22:35,444 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:35,446 INFO sqlalchemy.engine.base.Engine SELECT current_schema()
2020-02-28 15:22:35,446 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:35,448 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1
2020-02-28 15:22:35,449 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:35,450 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1
2020-02-28 15:22:35,450 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:35,450 INFO sqlalchemy.engine.base.Engine SHOW standard_conforming_strings
2020-02-28 15:22:35,450 INFO sqlalchemy.engine.base.Engine {}
2020-02-28 15:22:35,451 INFO sqlalchemy.engine.base.Engine SELECT 1 FROM pg_database WHERE datname='cars'
2020-02-28 15:22:35,451 INFO sqlalchemy.engine.base.Engine {}
DATABASE EXISTS:  TRUE
[Main] — Connected TO DATABASE!