Загрузка данных


[lds-uploader@VDC01-DISPLDS08 ~]$ docker exec -it testops-db-1 psql -U testops -d testops -c "
> SELECT table_name
> FROM information_schema.tables
> WHERE table_schema = 'public'
>   AND table_type = 'BASE TABLE'
> ORDER BY table_name;
> "
    table_name    
------------------
 attachments
 tags
 test_case_steps
 test_case_suites
 test_case_tags
 test_cases
 test_suites
 testrun_results
(8 rows)

[lds-uploader@VDC01-DISPLDS08 ~]$ docker exec -it testops-db-1 psql -U testops -d testops -c "
> SELECT column_name, data_type, is_nullable
> FROM information_schema.columns
> WHERE table_name = 'testrun_results'
> ORDER BY ordinal_position;
> "
  column_name  |          data_type          | is_nullable 
---------------+-----------------------------+-------------
 id            | integer                     | NO
 run_name      | character varying           | NO
 start_date    | timestamp without time zone | YES
 end_date      | timestamp without time zone | YES
 stand         | character varying           | YES
 status        | character varying           | NO
 passed_count  | integer                     | YES
 failed_count  | integer                     | YES
 broken_count  | integer                     | YES
 skipped_count | integer                     | YES
 created_at    | timestamp without time zone | NO
 is_deleted    | boolean                     | YES
(12 rows)

[lds-uploader@VDC01-DISPLDS08 ~]$ docker exec -it testops-flask-app flask db current
Error response from daemon: No such container: testops-flask-app
[lds-uploader@VDC01-DISPLDS08 ~]$ docker exec -itflask_app flask db current
unknown shorthand flag: 'f' in -flask_app
See 'docker exec --help'.
[lds-uploader@VDC01-DISPLDS08 ~]$ docker exec -it flask_app flask db current
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
[lds-uploader@VDC01-DISPLDS08 ~]$