def setUpClass(cls):
"""Run before all tests"""
TestPyQgsProviderConnectionBase.setUpClass()
gpkg_original_path = '{}/qgis_server/test_project_wms_grouped_layers.gpkg'.format(
TEST_DATA_DIR)
cls.gpkg_path = '{}/qgis_server/test_project_wms_grouped_layers_test.gpkg'.format(
TEST_DATA_DIR)
shutil.copy(gpkg_original_path, cls.gpkg_path)
vl = QgsVectorLayer('{}|layername=cdb_lines'.format(cls.gpkg_path),
'test', 'ogr')
assert vl.isValid()
cls.uri = cls.gpkg_path
def setUpClass(cls):
"""Run before all tests"""
TestPyQgsProviderConnectionBase.setUpClass()
spatialite_original_path = '{}/qgis_server/test_project_wms_grouped_layers.sqlite'.format(
TEST_DATA_DIR)
cls.spatialite_path = '{}/qgis_server/test_project_wms_grouped_layers_test.sqlite'.format(
TEST_DATA_DIR)
shutil.copy(spatialite_original_path, cls.spatialite_path)
cls.uri = "dbname=\'%s\'" % cls.spatialite_path
vl = QgsVectorLayer('{} table=\'cdb_lines\''.format(cls.uri), 'test',
'spatialite')
assert vl.isValid()
def setUpClass(cls):
"""Run before all tests"""
TestPyQgsProviderConnectionBase.setUpClass()
cls.postgres_conn = "service='qgis_test'"
if 'QGIS_PGTEST_DB' in os.environ:
cls.postgres_conn = os.environ['QGIS_PGTEST_DB']
# Create test layers
vl = QgsVectorLayer(
cls.postgres_conn +
' sslmode=disable key=\'"key1","key2"\' srid=4326 type=POINT table="qgis_test"."someData" (geom) sql=',
'test', 'postgres')
assert vl.isValid()
cls.uri = cls.postgres_conn + ' sslmode=disable'
def setUpClass(cls):
"""Run before all tests"""
TestPyQgsProviderConnectionBase.setUpClass()
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_provider_conn')
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')
def setUpClass(cls):
"""Run before all tests"""
TestPyQgsProviderConnectionBase.setUpClass()
# These are the connection details for the SQL Server instance running on Travis
cls.dbconn = "service='testsqlserver' user=sa password='******' "
if 'QGIS_MSSQLTEST_DB' in os.environ:
cls.dbconn = os.environ['QGIS_MSSQLTEST_DB']
cls.uri = cls.dbconn
try:
md = QgsProviderRegistry.instance().providerMetadata('mssql')
conn = md.createConnection(cls.uri, {})
conn.executeSql('drop schema [myNewSchema]')
except:
pass
def setUpClass(cls):
"""Run before all tests"""
TestPyQgsProviderConnectionBase.setUpClass()
# These are the connection details for the Docker Oracle instance running on Travis
cls.dbconn = "host=localhost/XEPDB1 port=1521 user='******' password='******'"
if 'QGIS_ORACLETEST_DB' in os.environ:
cls.dbconn = os.environ['QGIS_ORACLETEST_DB']
cls.uri = cls.dbconn
cls.conn = QSqlDatabase.addDatabase('QOCISPATIAL', "oracletest")
cls.conn.setDatabaseName('localhost/XEPDB1')
if 'QGIS_ORACLETEST_DBNAME' in os.environ:
cls.conn.setDatabaseName(os.environ['QGIS_ORACLETEST_DBNAME'])
cls.conn.setUserName('QGIS')
cls.conn.setPassword('qgis')
assert cls.conn.open()
def setUpClass(cls):
"""Run before all tests"""
TestPyQgsProviderConnectionBase.setUpClass()
# These are the connection details for the Docker Oracle instance running on Travis
cls.dbconn = "host=localhost/XEPDB1 port=1521 user='******' password='******'"
if 'QGIS_ORACLETEST_DB' in os.environ:
cls.dbconn = os.environ['QGIS_ORACLETEST_DB']
cls.uri = cls.dbconn
cls.conn = QSqlDatabase.addDatabase('QOCISPATIAL', "oracletest")
cls.conn.setDatabaseName('localhost/XEPDB1')
if 'QGIS_ORACLETEST_DBNAME' in os.environ:
cls.conn.setDatabaseName(os.environ['QGIS_ORACLETEST_DBNAME'])
cls.conn.setUserName('QGIS')
cls.conn.setPassword('qgis')
# Start clean
md = QgsProviderRegistry.instance().providerMetadata('oracle')
conn = md.createConnection(cls.dbconn, {})
for table_name in (cls.myNewTable, cls.myVeryNewTable):
try:
conn.dropVectorTable('QGIS', table_name)
except QgsProviderConnectionException:
pass
try:
conn.executeSql(
f"DELETE FROM user_sdo_geom_metadata WHERE TABLE_NAME = '{table_name}'"
)
except QgsProviderConnectionException:
pass
assert cls.conn.open()
