def __init__(self,
connexion,
table,
column,
prepare_tree,
srsdialog,
parent=None):
QtGui.QDialog.__init__(self)
# Set up the user interface from Designer.
self.ui = Ui_RecoverGeometryColumn()
self.ui.setupUi(self)
self.srsdialog = srsdialog
self.connexion = connexion
self.table = table
self.column = column
self.prepare_tree = prepare_tree #callbackfunction
self.ui.table.setText(table)
self.ui.table.setEnabled(False)
self.ui.column.setText(column)
self.ui.column.setEnabled(False)
self.dims = ["2", "3"]
self.ui.dims.insertItems(0, self.dims)
self.geometry = [
"POINT", "MULTIPOINT", "LINESTRING", "MULTILINESTRING", "POLYGON",
"MULTIPOLYGON", "GEOMETRYCOLLECTION"
]
self.ui.geometry.insertItems(0, self.geometry)
QtCore.QObject.connect(self.ui.buttonBox, QtCore.SIGNAL("accepted()"),
self.validate)
QtCore.QObject.connect(self.ui.browseSRID,
QtCore.SIGNAL("clicked(bool)"), self.browseSRID)
class recovergeometry(QtGui.QDialog):
def __init__(self,connexion,table,column, prepare_tree, srsdialog,parent = None):
QtGui.QDialog.__init__(self)
# Set up the user interface from Designer.
self.ui = Ui_RecoverGeometryColumn()
self.ui.setupUi(self)
self.srsdialog=srsdialog
self.connexion=connexion
self.table=table
self.column=column
self.prepare_tree=prepare_tree #callbackfunction
self.ui.table.setText(table)
self.ui.table.setEnabled(False)
self.ui.column.setText(column)
self.ui.column.setEnabled(False)
self.dims=["2","3"]
self.ui.dims.insertItems(0,self.dims)
self.geometry=["POINT","MULTIPOINT","LINESTRING","MULTILINESTRING","POLYGON","MULTIPOLYGON","GEOMETRYCOLLECTION"]
self.ui.geometry.insertItems(0,self.geometry)
QtCore.QObject.connect(self.ui.buttonBox,
QtCore.SIGNAL("accepted()"),
self.validate)
QtCore.QObject.connect(self.ui.browseSRID,
QtCore.SIGNAL("clicked(bool)"),
self.browseSRID)
def validate(self):
try:
srid=int(self.ui.srid.text())
except:
QtGui.QMessageBox.information(self, "Error", "SRID must be Integer")
return #srid must be integer
dims=self.ui.dims.currentText()
geometry=self.ui.geometry.currentText()
if (self.table=='') or (self.column=='') or (srid=='') or (dims=='') or (geometry==''):
QtGui.QMessageBox.information(self, "Error", "All fields are required")
return # all fields are needed...
Query="SELECT recovergeometryColumn('%s','%s',%s,'%s',%s)"%( self.table, self.column, srid, geometry,dims)
cursor=self.connexion.cursor()
rep=cursor.execute(Query)
if rep.fetchall()[0][0]!=1:
QtGui.QMessageBox.information(self,"Geometry column validation failed","Geometry column doesn't satisfies required constraints\na ROLLBACK was automatically performed")
self.connexion.rollback()
cursor.close
return
QtGui.QMessageBox.information(self,"Information","Geometry column validation succeed")
self.connexion.commit()
cursor.close()
self.prepare_tree()
def browseSRID(self):
dialog = self.srsdialog( "Select desired SRS" )
if dialog.exec_():
self.ui.srid.setText(dialog.getProjection())
def __init__(self,connexion,table,column, prepare_tree, srsdialog,parent = None):
QtGui.QDialog.__init__(self)
# Set up the user interface from Designer.
self.ui = Ui_RecoverGeometryColumn()
self.ui.setupUi(self)
self.srsdialog=srsdialog
self.connexion=connexion
self.table=table
self.column=column
self.prepare_tree=prepare_tree #callbackfunction
self.ui.table.setText(table)
self.ui.table.setEnabled(False)
self.ui.column.setText(column)
self.ui.column.setEnabled(False)
self.dims=["2","3"]
self.ui.dims.insertItems(0,self.dims)
self.geometry=["POINT","MULTIPOINT","LINESTRING","MULTILINESTRING","POLYGON","MULTIPOLYGON","GEOMETRYCOLLECTION"]
self.ui.geometry.insertItems(0,self.geometry)
QtCore.QObject.connect(self.ui.buttonBox,
QtCore.SIGNAL("accepted()"),
self.validate)
QtCore.QObject.connect(self.ui.browseSRID,
QtCore.SIGNAL("clicked(bool)"),
self.browseSRID)
class recovergeometry(QtGui.QDialog):
def __init__(self,
connexion,
table,
column,
prepare_tree,
srsdialog,
parent=None):
QtGui.QDialog.__init__(self)
# Set up the user interface from Designer.
self.ui = Ui_RecoverGeometryColumn()
self.ui.setupUi(self)
self.srsdialog = srsdialog
self.connexion = connexion
self.table = table
self.column = column
self.prepare_tree = prepare_tree #callbackfunction
self.ui.table.setText(table)
self.ui.table.setEnabled(False)
self.ui.column.setText(column)
self.ui.column.setEnabled(False)
self.dims = ["2", "3"]
self.ui.dims.insertItems(0, self.dims)
self.geometry = [
"POINT", "MULTIPOINT", "LINESTRING", "MULTILINESTRING", "POLYGON",
"MULTIPOLYGON", "GEOMETRYCOLLECTION"
]
self.ui.geometry.insertItems(0, self.geometry)
QtCore.QObject.connect(self.ui.buttonBox, QtCore.SIGNAL("accepted()"),
self.validate)
QtCore.QObject.connect(self.ui.browseSRID,
QtCore.SIGNAL("clicked(bool)"), self.browseSRID)
def validate(self):
try:
srid = int(self.ui.srid.text())
except:
QtGui.QMessageBox.information(self, "Error",
"SRID must be Integer")
return #srid must be integer
dims = self.ui.dims.currentText()
geometry = self.ui.geometry.currentText()
if (self.table == '') or (self.column == '') or (srid == '') or (
dims == '') or (geometry == ''):
QtGui.QMessageBox.information(self, "Error",
"All fields are required")
return # all fields are needed...
Query = "SELECT recovergeometryColumn('%s','%s',%s,'%s',%s)" % (
self.table, self.column, srid, geometry, dims)
cursor = self.connexion.cursor()
rep = cursor.execute(Query)
if rep.fetchall()[0][0] != 1:
QtGui.QMessageBox.information(
self, "Geometry column validation failed",
"Geometry column doesn't satisfies required constraints\na ROLLBACK was automatically performed"
)
self.connexion.rollback()
cursor.close
return
QtGui.QMessageBox.information(self, "Information",
"Geometry column validation succeed")
self.connexion.commit()
cursor.close()
self.prepare_tree()
def browseSRID(self):
dialog = self.srsdialog("Select desired SRS")
if dialog.exec_():
self.ui.srid.setText(dialog.getProjection())
