def testTableUri(self):
"""Create a connection from a layer uri and create a table URI"""
md = self.createProviderMetadata()
conn = md.createConnection(self.uri, {})
vl = QgsHanaProviderUtils.createVectorLayer(
conn.tableUri(self.schemaName, 'some_data'), 'test')
def setUpClass(cls):
"""Run before all tests"""
cls.uri = 'driver=\'/usr/sap/hdbclient/libodbcHDB.so\' host=localhost port=30015 user=SYSTEM ' \
'password=mypassword sslEnabled=true sslValidateCertificate=False'
if 'QGIS_HANA_TEST_DB' in os.environ:
cls.uri = os.environ['QGIS_HANA_TEST_DB']
cls.conn = QgsHanaProviderUtils.createConnection(cls.uri)
cls.schemaName = QgsHanaProviderUtils.generateSchemaName(cls.conn, 'qgis_test')
QgsHanaProviderUtils.createAndFillDefaultTables(cls.conn, cls.schemaName)
# Create test layers
cls.vl = QgsHanaProviderUtils.createVectorLayer(
cls.uri + f' key=\'pk\' srid=4326 type=POINT table="{cls.schemaName}"."some_data" (geom) sql=', 'test')
cls.source = cls.vl.dataProvider()
cls.poly_vl = QgsHanaProviderUtils.createVectorLayer(
cls.uri + f' key=\'pk\' srid=4326 type=POLYGON table="{cls.schemaName}"."some_poly_data" (geom) sql=', 'test')
cls.poly_provider = cls.poly_vl.dataProvider()
def createVectorLayer(self, conn_parameters, layer_name):
return QgsHanaProviderUtils.createVectorLayer(
self.uri + ' ' + conn_parameters, layer_name)
def createVectorLayer(self, conn_parameters, layer_name):
layer = QgsHanaProviderUtils.createVectorLayer(
self.uri + ' ' + conn_parameters, layer_name)
self.assertTrue(layer.isValid())
return layer