import datetime import osimport mssqlhelperms = mssqlhelper.MSSQL(host="192.168.0.108", user="sa", pwd="sa", db="ComPrject")def getAreas(cityid):  arealist=ms.ExecQuery("select *From dbo.areas where cityid='%s' " % cityid)  return arealistdef getCity(provinces):  citylist=ms.ExecQuery("select *From dbo.cities where provinceid='%s'" % provinces)  return citylistdef getProvinces():  provlist=ms.ExecQuery("select *From dbo.provinces")  return provlistdef createFileJson():  date=datetime.datetime.now().strftime('%Y-%m-%d')  path=date+'-provinces.json'  return pathdef writeJson(path):  provlist=getProvinces()  with open(path,"w+",encoding="utf-8") as f:    f.write("[")    lp = 0    for p in provlist:      if lp>0:        f.write(",/n")      else:        f.write("/n")      f.write("{/n")      f.write('"Code":"%s"/n'% p[1])      f.write(',"Name":"%s"/n'% p[2])      f.write(',Nodes:[/n')      citylist=getCity(p[1])      lc = 0      for c in citylist:        if lc>0:          f.write("/t,/n")        else:          f.write("/n")        f.write("/t{/n")        f.write('/t"Code":"%s"/n'% c[1])        f.write('/t,"Name":"%s"/n'% c[2])        f.write('/t,Nodes:[/n')        arealist = getAreas(c[1])        la = 0        for a in arealist:          if la>0:            f.write("/t/t,/n")          else:            f.write("/n")          f.write("/t/t{/n")          f.write('/t/t"Code":"%s"/n'% a[1])          f.write('/t/t,"Name":"%s"/n'% a[2])          f.write("/t/t}/n")          la += 1        f.write("/t]/n")        f.write("/t}/n")        lc += 1      f.write("]/n")      f.write("}/n")      lp += 1    f.write("]/n")if __name__ == '__main__':  path=createFileJson()  writeJson(path)