def create_schemas():
conp = get_conp1('jilin')
arr = [
'baicheng', 'baishan', 'changchun', 'jilin', 'jilinshi', 'liaoyuan',
'siping', 'songyuan', 'tonghua'
]
for diqu in arr:
sql = "create schema if not exists %s" % diqu
db_command(sql, dbtype="postgresql", conp=conp)
def create_schemas():
conp = get_conp1('yunnan')
arr = [
'baoshan', 'chuxiong', 'dali', 'lijiang', 'lincang', 'puer',
'tengchong', 'wenshan', 'yunnan', 'yuxi', 'zhaotong', 'kunming'
]
for diqu in arr:
sql = "create schema if not exists %s" % diqu
db_command(sql, dbtype="postgresql", conp=conp)
def create_schemas():
conp = get_conp1('anhui')
arr = [
"anqing", "bengbu", "bozhou", "chaohu", "chizhou", "chuzhou", "fuyang",
"huaibei", "huainan", "huangshan", "luan", "maanshan", "suzhou",
"tongling", "wuhu", 'xuancheng', 'hefei'
]
for diqu in arr:
sql = "create schema if not exists %s" % diqu
db_command(sql, dbtype="postgresql", conp=conp)
def create_schemas():
conp = get_conp1('jiangxi')
arr = [
"dexing", "fengcheng", 'fuzhou', 'ganzhou', 'gaoan', 'jian', 'jiangxi',
'jingdezhen', 'jinggangshan', 'lushan', 'nanchang', 'ruichang',
'ruijin', 'shangrao', 'xinyu', 'yichun', 'yingtan', 'zhangshu'
]
for diqu in arr:
sql = "create schema if not exists %s" % diqu
db_command(sql, dbtype="postgresql", conp=conp)
def create_schemas():
conp = get_conp1('jiangsu')
arr = ["changshu", "changzhou", "danyang", "dongtai", "huaian"
, "jiangyin", "kunshan", "lianyungang", "nanjing", "nantong"
, "jiangsu", "suqian", "suzhou", "taizhou", "wuxi"
, "xinyi", "xuzhou", "yancheng", "yangzhou", "yizheng"
, "zhangjiagang", "zhenjiang"
]
for diqu in arr:
sql = "create schema if not exists %s" % diqu
db_command(sql, dbtype="postgresql", conp=conp)
def create_schemas():
conp = get_conp1('liaoning')
arr = [
"anshan", "beizhen", "benxi", "chaoyang", "dalian",
"dandong", "donggang", "fushun", "fuxin", "haicheng",
"huludao", "jinzhou", "liaoning", "liaoyang", "panjin",
"shenyang", "tieling", "yingkou",
]
for diqu in arr:
sql = "create schema if not exists %s" % diqu
db_command(sql, dbtype="postgresql", conp=conp)
def create_schemas():
conp = get_conp1('zhejiang')
arr = [
"cixi", "dongyang", "hangzhou", "huzhou", "jiaxing", "jinhua",
"linhai", "lishui", "longquan", "ningbo", "pinghu", "quzhou", "ruian",
"shaoxing", "shengzhou", "taizhou", "tongxiang", "wenling", "wenzhou",
"yiwu", "yueqing", "yuhuan", "zhejiang", "zhoushan", "zhuji"
]
for diqu in arr:
sql = "create schema if not exists %s" % diqu
db_command(sql, dbtype="postgresql", conp=conp)
def create_schemas():
conp = get_conp1('sichuan')
arr = [
"bazhong", "chengdu", "chongzhou", "dazhou", "deyang", "dujiangyan",
"guangan", "guanghan", "guangyuan", "jiangyou", "jianyang", "leshan",
"longchang", "luzhou", "meishan", "mianyang", "nanchong", "neijiang",
"panzhihua", "pengzhou", "qionglai", "shifang", "sichuan", "suining",
"wanyuan", "yaan", "yibin"
]
for diqu in arr:
sql = "create schema if not exists %s" % diqu
db_command(sql, dbtype="postgresql", conp=conp)
def create_schemas():
conp = get_conp1('henan')
arr = [
"anyang", "dengfeng", "gongyi", "hebi", "jiaozhuo", "jiyuan",
"jiyuan1", "kaifeng", "linzhou", "luohe", "luoyang", "mengzhou",
"nanyang", "pingdingshan", "puyang", "qinyang", "ruzhou", "sanmenxia",
"shangqiu", "weihui", "wugang", "xinmi", "xinyang", "xinxiang",
"xinzheng", "xuchang", "yanshi", "yongcheng", "zhengzhou", "zhoukou",
"zhumadian"
]
for diqu in arr:
sql = "create schema if not exists %s" % diqu
db_command(sql, dbtype="postgresql", conp=conp)
def create_schemas():
conp = get_conp1('neimenggu')
arr = [
"baotou",
"bayannaoer",
"chifeng",
"eeduosi",
"huhehaote",
"hulunbeier",
"manzhouli",
"xinganmeng",
"tongliao",
"wuhai",
"wulanchabu",
"xilinguolemeng",
"xinganmeng",
]
for diqu in arr:
sql = "create schema if not exists %s" % diqu
db_command(sql, dbtype="postgresql", conp=conp)
def create_schemas():
conp = get_conp1('guangxi')
arr = [
"baise",
"beihai",
"chongzuo",
"fangchenggang",
"guangxi",
"guigang",
"guilin",
"hechi",
"hezhou",
"laibin",
"liuzhou",
"nanning",
"qinzhou",
"wuzhou",
]
for diqu in arr:
sql = "create schema if not exists %s" % diqu
db_command(sql, dbtype="postgresql", conp=conp)
def create_schemas():
conp = get_conp1('qinghai')
arr = ['qinghai', 'xining']
for diqu in arr:
sql = "create schema if not exists %s" % diqu
db_command(sql, dbtype="postgresql", conp=conp)
def create_schemas():
conp = get_conp1('xizang')
arr = ['xizang','lasa','rikaze']
for diqu in arr:
sql = "create schema if not exists %s" % diqu
db_command(sql, dbtype="postgresql", conp=conp)
def create_schemas():
conp = get_conp1('ningxia')
arr = ['guyuan', 'ningxia', 'yinchuan']
for diqu in arr:
sql = "create schema if not exists %s" % diqu
db_command(sql, dbtype="postgresql", conp=conp)
def create_schemas():
conp = get_conp1('shanxi1')
arr = ['shanxi']
for diqu in arr:
sql = "create schema if not exists %s" % diqu
db_command(sql, dbtype="postgresql", conp=conp)
def create_schemas():
conp = get_conp1('heilongjiang')
arr = ["daqing", "hegang", "heilongjiang", 'qiqihaer', 'yichun']
for diqu in arr:
sql = "create schema if not exists %s" % diqu
db_command(sql, dbtype="postgresql", conp=conp)