Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- > def LoadFromOracle(tablename):
- > GeometryColumn = Get_GeometryColumn(tablename)
- > print("GeoMetry Column is")
- > print(GeometryColumn)
- > oracleSetting = settingdb.GetSettingOracle()
- > uri = QgsDataSourceUri()
- > uri.setConnection(oracleSetting[3], oracleSetting[4], oracleSetting[0], oracleSetting[1], oracleSetting[2])
- > uri.setWkbType(QgsWkbTypes.Polygon)
- > uri.setDataSource('', tablename, GeometryColumn)
- > uri.setKeyColumn('ID1')
- > vlayer = QgsVectorLayer(uri.uri(), tablename, 'oracle')
- > print(uri.uri())
- > print ("uri wkbtype == %s layer geometry type == %s wkbType == %s"%(uri.wkbType(),vlayer.geometryType(),vlayer.wkbType()))
- > crs = QgsCoordinateReferenceSystem("EPSG:24048")
- > vlayer.setCrs(crs)
- >
- > return vlayer
- layer = self.LoadFromOracle('PROVINCE')
- print ('Layer is valid = %s'%self.layer.isValid())
- > dbname='XE' host=127.0.0.1 port=1521 user='SYSTEM' password='SYSTEM' key='ID1' estimatedmetadata=true type=Polygon table="PROVINCE" (GEOMETRY) sql=
- > uri wkbtype == 3 layer geometry type == 3 wkbType == 0
- > Layer is valid = False
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement