### QQȺ724424739

##########################################################
### ǰ:
##########################################################

1ṩһԶSQL ֶμ ѪԵ
2ʹܣҪ  ڽsqlűʱ򣬻Ὣűݷ
3ֶ֮᷵μѪԵݣûԸЩݹԼֶѪԵϵͳ




##########################################################
### űʹ˵
##########################################################

1SQLReader.py Ϊ SQLReaderԶ߰棬ʹʱҪ

2SQLReader.py ԰汾Ϊ Python3+Զģ飬ʱʾģȱʧвPythonģ鼴

3SQLReader.py ִзʽpython SQLReader.py + sqlļ·
    ǰĿ¼µsqlļ
    python SQLReader.py 1-create_table.sql     # Ƚ
    python SQLReader.py 2-codefile.sql           # ٽETLű


##########################################################
### ִн˵
##########################################################

1ɹӡɹ

2SQLͼΣɴ򿪵ַ(https://www.kexuejisuan.com/DataBloodRelationship/)鿴ע⣺Ҫ¼(ûsqlreader_test룺sqlreader_test)ܿڸûͼ

3ѪԵݣᱣڱ .log ־

4־ѪԵݶӦıṹ£ݿдЩ־еѪԵݣ

create table sql_table2table_info
(
  file_name_hash           bigint       COMMENT 'SQLļɵĹϣֵ'
, file_name                varchar(200) COMMENT 'SQLļ'
, sql_seq                  int          COMMENT 'SQL˳'
, sql_type                 varchar(50)  COMMENT 'SQL'
, target_table             varchar(200) COMMENT 'SQLĿ'
, source_table             varchar(200) COMMENT 'SQLӹԴ' 
, source_table_seq         int          COMMENT 'SQLԴ˳' 
, source_table_join_type   varchar(50)  COMMENT 'SQLӹԴʽ' 
, source_table_other_name  varchar(50)  COMMENT 'SQLӹԴ' 
, source_table_condition   varchar(10000) COMMENT 'SQLԴ' 
, src_tab_seqs_of_cdt_join varchar(100) COMMENT 'Դ˳'
)
DEFAULT CHARSET=utf8
partition by hash(file_name_hash) 
partitions 197
;

create table sql_table2column_info
(
  file_name_hash           bigint       COMMENT 'SQLļɵĹϣֵ'
, file_name                varchar(200) COMMENT 'SQLļ'
, sql_seq                  int          COMMENT 'SQL˳'
, target_table             varchar(200) COMMENT 'SQLĿ'
, column_name              varchar(200) COMMENT 'Ŀֶ'
, column_logic             varchar(10000) COMMENT 'ֶ߼'
, source_tables            varchar(4000) COMMENT 'ֶ߼漰Դֶ' 
)
DEFAULT CHARSET=utf8
partition by hash(file_name_hash)
partitions 197
;

create table sql_table_struct_info
(
  table_name_hash          bigint       COMMENT 'ɵĹϣֵ'
, table_name               varchar(200) COMMENT ''
, column_seq               int          COMMENT 'ֶ˳'
, column_name              varchar(200) COMMENT 'ֶ'
, column_data_type         varchar(200) COMMENT 'ֶ'
, column_comment           varchar(200) COMMENT 'ֶע'
)
DEFAULT CHARSET=utf8
partition by hash(table_name_hash)
partitions 197
;
