def test_given_i_connect_to_sqlalchemy_url_as_conn_name(self):
current_conn_name = util.rand_string()
sql.given_i_connect_to_sqlalchemy_url_as_conn_name(
self.ctx, self.sqlalchemy_url, current_conn_name)
current_conn = self.ctx.zato.user_ctx[current_conn_name]
self.assertIsInstance(current_conn, Connection)
sql.then_i_disconnect_from_sql(self.ctx, current_conn)
def setUp(self):
self.ctx = Bunch()
self.ctx.zato = util.new_context(None, util.rand_string(), {})
self.id = util.rand_int()
self.name = util.rand_string()
self.value = util.rand_string()
self.temp_db = NamedTemporaryFile().name
self.conn = sqlite3.connect(self.temp_db)
self.cursor = self.conn.cursor()
self.cursor.execute("CREATE TABLE TestDB (id integer, name text, value text)")
self.cursor.execute("INSERT INTO TestDB (id, name, value) VALUES (?,?,?)", (self.id, self.name, self.value))
self.conn.commit()
self.sqlalchemy_url = 'sqlite:///' + self.temp_db
general_conn_name = 'general_connn_name'
sql.given_i_connect_to_sqlalchemy_url_as_conn_name(self.ctx, self.sqlalchemy_url, general_conn_name)
self.general_conn = self.ctx.zato.user_ctx[general_conn_name]
def setUp(self):
self.ctx = Bunch()
self.ctx.zato = util.new_context(None, util.rand_string(), {})
self.id = util.rand_int()
self.name = util.rand_string()
self.value = util.rand_string()
self.temp_db = NamedTemporaryFile().name
self.conn = sqlite3.connect(self.temp_db)
self.cursor = self.conn.cursor()
self.cursor.execute(
"CREATE TABLE TestDB (id integer, name text, value text)")
self.cursor.execute(
"INSERT INTO TestDB (id, name, value) VALUES (?,?,?)",
(self.id, self.name, self.value))
self.conn.commit()
self.sqlalchemy_url = 'sqlite:///' + self.temp_db
general_conn_name = 'general_connn_name'
sql.given_i_connect_to_sqlalchemy_url_as_conn_name(
self.ctx, self.sqlalchemy_url, general_conn_name)
self.general_conn = self.ctx.zato.user_ctx[general_conn_name]
def test_given_i_connect_to_sqlalchemy_url_as_conn_name(self):
current_conn_name = util.rand_string()
sql.given_i_connect_to_sqlalchemy_url_as_conn_name(self.ctx, self.sqlalchemy_url, current_conn_name)
current_conn = self.ctx.zato.user_ctx[current_conn_name]
self.assertIsInstance(current_conn, Connection)
sql.then_i_disconnect_from_sql(self.ctx, current_conn)
