import pyodbc hil_sql = """ create table interface_report ( id bigint identity primary key, source nvarchar(64) not null, target nvarchar(64) not null, body nvarchar(max), response nvarchar(max), status bit default 1 not null, retry_times tinyint default 0 not null, duration smallint not null, create_time datetime not null ); create table hil_compare_report_new ( id bigint identity primary key, application_id nvarchar(64) not null, is_se bit default 1 not null, is_auto bit default 0 not null, is_pass bit default 0 not null, full_result nvarchar(max), field_result nvarchar(max), start_time datetime not null, end_time datetime not null, ); create index hil_compare_report_new_start_time_index on hil_compare_report_new (start_time); create index hil_compare_report_new_application_id_index on hil_compare_report_new (application_id); """ afc_sql = """ create table afc_compare_report_new ( id bigint identity primary key, application_id nvarchar(64) not null, is_se bit default 1 not null, is_auto bit default 0 not null, is_pass bit default 0 not null, full_result nvarchar(max), field_result nvarchar(max), start_time datetime not null, end_time datetime not null, ); create index afc_compare_report_new_start_time_index on afc_compare_report_new (start_time); create index afc_compare_report_new_application_id_index on afc_compare_report_new (application_id); """ hil_cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};', autocommit=True) hil_cursor = hil_cnxn.cursor() hil_cursor.execute(hil_sql) hil_cursor.close() hil_cnxn.close() afc_cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};', autocommit=True) afc_cursor = afc_cnxn.cursor() afc_cursor.execute(afc_sql) afc_cursor.close() afc_cnxn.close()