def test_ili_schema_to_postgis(): imd = ImdParser("./tests/data/np/NP_73_CH_de_ili2.imd") transferfn = imd.gen_empty_transfer_file() trans = OgrConfig(config="tests/data/np/NP_73_CH_de_ili2-pg.cfg", ds=transferfn + ",tests/data/np/NP_73_CH_de_ili2.imd") __, dstfile = tempfile.mkstemp(suffix='.sql') trans.transform(dstfile, "PGDump") print(dstfile) sql = codecs.open(dstfile, encoding='utf-8').read() assert """CREATE TABLE "public"."n0_grundnutzung_zonenflaeche" (""" in sql assert """SELECT AddGeometryColumn('public','n0_grundnutzung_zonenflaeche','geometrie',21781,'POLYGON',2);""" in sql os.remove(transferfn) os.remove(dstfile)
def test_ili_schema_to_postgis(): imd = ImdParser("./tests/data/np/NP_73_CH_de_ili2.imd") transferfn = imd.gen_empty_transfer_file() trans = OgrConfig( config="tests/data/np/NP_73_CH_de_ili2-pg.cfg", ds=transferfn+",tests/data/np/NP_73_CH_de_ili2.imd") __, dstfile = tempfile.mkstemp(suffix='.sql') trans.transform(dstfile, "PGDump") print dstfile sql = codecs.open(dstfile, encoding='utf-8').read() assert """CREATE TABLE "public"."n0_grundnutzung_zonenflaeche" (""" in sql assert """SELECT AddGeometryColumn('public','n0_grundnutzung_zonenflaeche','geometrie',21781,'POLYGON',2);""" in sql os.remove(transferfn) os.remove(dstfile)
def _empty_transfer_ds(self): imd = ImdParser(self.ui.mModelLineEdit.text()) transferfn = imd.gen_empty_transfer_file() ds = transferfn + "," + self.ui.mModelLineEdit.text() return ds