DDL containing more than one CREATE statement about ddlparse HOT 3 OPEN

import re
import sqlparse
from ddlparse import DdlParse

def main():
    with open("/path/to/ddl.sql", "r") as ddl_file:
        sql = ddl_file.read()
        ddls = sqlparse.split(sql)
        tmp_tables_regex = re.compile("^CREATE TABLE.*.*\(")
        for ddl in ddls:
            if(tmp_tables_regex.match(ddl)):
                parser = DdlParse(ddl=ddl, source_database=DdlParse.DATABASE.postgresql)
                table = parser.parse()
                print("table_name: %s"%table.name)
                for column in table.columns.values():
                    print("     column_name: %s, data_type: %s"%(column.name,column.bigquery_standard_data_type))

if __name__ == "__main__":
    main()