Advertisement
Guest User

Untitled

a guest
Aug 21st, 2019
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.11 KB | None | 0 0
  1. > def LoadFromOracle(tablename):
  2. > GeometryColumn = Get_GeometryColumn(tablename)
  3. > print("GeoMetry Column is")
  4. > print(GeometryColumn)
  5. > oracleSetting = settingdb.GetSettingOracle()
  6. > uri = QgsDataSourceUri()
  7. > uri.setConnection(oracleSetting[3], oracleSetting[4], oracleSetting[0], oracleSetting[1], oracleSetting[2])
  8. > uri.setWkbType(QgsWkbTypes.Polygon)
  9. > uri.setDataSource('', tablename, GeometryColumn)
  10. > uri.setKeyColumn('ID1')
  11. > vlayer = QgsVectorLayer(uri.uri(), tablename, 'oracle')
  12. > print(uri.uri())
  13. > print ("uri wkbtype == %s layer geometry type == %s wkbType == %s"%(uri.wkbType(),vlayer.geometryType(),vlayer.wkbType()))
  14. > crs = QgsCoordinateReferenceSystem("EPSG:24048")
  15. > vlayer.setCrs(crs)
  16. >
  17. > return vlayer
  18.  
  19. layer = self.LoadFromOracle('PROVINCE')
  20. print ('Layer is valid = %s'%self.layer.isValid())
  21.  
  22. > dbname='XE' host=127.0.0.1 port=1521 user='SYSTEM' password='SYSTEM' key='ID1' estimatedmetadata=true type=Polygon table="PROVINCE" (GEOMETRY) sql=
  23. > uri wkbtype == 3 layer geometry type == 3 wkbType == 0
  24. > Layer is valid = False
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement