def setUp(self):
load_test_db("analyzer", "test_datastore_postgres")
dataset = Dataset.objects.get(pk=1)
postgres_connection = PostgresConnection.objects.get(pk=1)
postgres_connection.db_name = TEST_POSTGRES_DB_NAME
postgres_connection.username = TEST_POSTGRES_USERNAME
postgres_connection.password = encrypt(TEST_POSTGRES_PASSWORD)
postgres_connection.host = TEST_POSTGRES_HOST
postgres_connection.port = TEST_POSTGRES_PORT
postgres_connection.save()
self.datastore = datastore_factory(dataset.connection.pk)
def setUp(self):
load_test_db("analyzer", "test_datastore_azure")
dataset = Dataset.objects.get(pk=1)
azure_connection = AzureConnection.objects.get(pk=1)
azure_connection.db_name = TEST_AZURE_DB_NAME
azure_connection.username = TEST_AZURE_USERNAME
azure_connection.password = encrypt(TEST_AZURE_PASSWORD)
azure_connection.host = TEST_AZURE_HOST
azure_connection.port = TEST_AZURE_PORT
azure_connection.save()
self.datastore = datastore_factory(dataset.connection.pk)
self.setup_test_database()
def setUp(self):
self.test_schema = 'dbo'
self.test_table = 'saef_job'
self.test_column = 'id'
load_test_db("analyzer", "test_recordset_azure")
dataset = Dataset.objects.get(pk=1)
azure_connection = AzureConnection.objects.get(pk=1)
azure_connection.db_name = TEST_AZURE_DB_NAME
azure_connection.username = TEST_AZURE_USERNAME
azure_connection.password = encrypt(TEST_AZURE_PASSWORD)
azure_connection.host = TEST_AZURE_HOST
azure_connection.port = TEST_AZURE_PORT
azure_connection.save()
self.recordset = recordset_factory(dataset)
def setUp(self):
self.test_schema = 'public'
self.test_table = 'saef_job'
self.test_column = 'id'
load_test_db("analyzer", "test_recordset_postgres")
dataset = Dataset.objects.get(pk=1)
postgres_connection = PostgresConnection.objects.get(pk=1)
postgres_connection.db_name = TEST_POSTGRES_DB_NAME
postgres_connection.username = TEST_POSTGRES_USERNAME
postgres_connection.password = encrypt(TEST_POSTGRES_PASSWORD)
postgres_connection.host = TEST_POSTGRES_HOST
postgres_connection.port = TEST_POSTGRES_PORT
postgres_connection.save()
self.recordset = recordset_factory(dataset)
def postgres_connection(postgres_form, form):
connection = create_connection(postgres_form, form)
db_name = postgres_form["db_name"]
username = postgres_form["username"]
password = encrypt(postgres_form["password"])
host = postgres_form["host"]
port = postgres_form["port"]
postgres_connection = PostgresConnection(db_name=db_name,
username=username,
password=password,
host=host,
port=port,
connection=connection)
return connection, postgres_connection
def azure_connection(azure_form, form):
connection = create_connection(azure_form, form)
db_name = azure_form["db_name"]
username = azure_form["username"]
password = encrypt(azure_form["password"])
host = azure_form["host"]
port = azure_form["port"]
azure_connection = AzureConnection(
db_name=db_name,
username=username,
password=password,
host=host,
port=port,
connection=connection
)
return connection, azure_connection