def test_then_i_insert_values_into_columns_of_cassandra_table(self):
cassandra_.then_i_insert_values_into_columns_of_cassandra_table(
self.ctx, self.table, ', '.join(self.values), ', '.join(self.columns), self.current_session_name)
statement = "SELECT * FROM %s" % self.table
cassandra_.given_i_store_cql_query_result_under_name(self.ctx, statement, 'cql_result', self.current_session_name, 0)
self.assertEquals(self.ctx.zato.user_ctx['cql_result'], ';'.join(self.values))
def test_then_i_delete_from_cassandra_table(self):
criterion = "WHERE %s='%s'" % (self.columns[0], self.values[0])
cassandra_.then_i_delete_from_cassandra_table(self.ctx, self.table, self.current_session_name, criterion)
statement = "SELECT * FROM %s" % self.table
cassandra_.given_i_store_cql_query_result_under_name(self.ctx, statement, 'cql_result', self.current_session_name, 0)
self.assertEquals(self.ctx.zato.user_ctx['cql_result'], '')
def test_then_i_insert_values_into_columns_of_cassandra_table(self):
current_session = self.ctx.zato.user_ctx[self.current_session_name]
cassandra_.then_i_insert_values_into_columns_of_cassandra_table(
self.ctx, self.table, ', '.join(self.values), ', '.join(self.columns), current_session)
statement = "SELECT * FROM %s" % self.table
cassandra_.given_i_store_cql_query_result_under_name(self.ctx, statement, 'cql_result', current_session)
self.assertEquals(self.ctx.zato.user_ctx['cql_result'][0][0], self.values[0])
self.assertEquals(self.ctx.zato.user_ctx['cql_result'][0][0:], tuple((item) for item in self.values))
def test_then_i_update_columns_of_cassandra_table_setting_values(self):
new_values = 'John, Doe'
criterion = "WHERE %s='%s'" % (self.columns[0], self.values[0])
cassandra_.then_i_update_columns_of_cassandra_table_setting_values(
self.ctx, self.table, ', '.join(self.columns[1:]), new_values, self.current_session_name, criterion)
statement = "SELECT * FROM %s" % self.table
cassandra_.given_i_store_cql_query_result_under_name(self.ctx, statement, 'cql_result', self.current_session_name, 0)
self.assertEquals(self.ctx.zato.user_ctx['cql_result'], '{};John;Doe'.format(self.values[0]))
def test_i_insert_data_from_csv_file_to_cassandra_table(self, open_mock):
values = (util.rand_string(), util.rand_string(), util.rand_string())
fake_csv = 'userid, fname, sname\n%s, %s, %s' % values
filename = util.rand_string()
open_mock.return_value = StringIO(fake_csv)
cassandra_.i_insert_data_from_csv_file_to_cassandra_table(self.ctx, filename, self.table, self.current_session_name)
statement = "SELECT * FROM %s" % self.table
cassandra_.given_i_store_cql_query_result_under_name(self.ctx, statement, 'cql_result', self.current_session_name, 0)
self.assertEquals(self.ctx.zato.user_ctx['cql_result'], ';'.join(values))
def test_then_i_insert_values_into_columns_of_cassandra_table(self):
# TODO: Cassandra tests are failing due to """PysandraUnitServerError:
# Failed to execute command start: /127.0.0.1:7010 is in use by another process.
# Change listen_address:storage_port in cassandra.yaml to values that do not conflict with other services"""
return
cassandra_.then_i_insert_values_into_columns_of_cassandra_table(
self.ctx, self.table, ', '.join(self.values), ', '.join(self.columns), self.current_session_name)
statement = "SELECT * FROM %s" % self.table
cassandra_.given_i_store_cql_query_result_under_name(self.ctx, statement, 'cql_result', self.current_session_name, 0)
self.assertEquals(self.ctx.zato.user_ctx['cql_result'], ';'.join(self.values))
def test_then_i_delete_from_cassandra_table(self):
# TODO: Cassandra tests are failing due to """PysandraUnitServerError:
# Failed to execute command start: /127.0.0.1:7010 is in use by another process.
# Change listen_address:storage_port in cassandra.yaml to values that do not conflict with other services"""
return
criterion = "WHERE %s='%s'" % (self.columns[0], self.values[0])
cassandra_.then_i_delete_from_cassandra_table(self.ctx, self.table, self.current_session_name, criterion)
statement = "SELECT * FROM %s" % self.table
cassandra_.given_i_store_cql_query_result_under_name(self.ctx, statement, 'cql_result', self.current_session_name, 0)
self.assertEquals(self.ctx.zato.user_ctx['cql_result'], '')
def test_then_i_delete_from_cassandra_table(self):
# TODO: Cassandra tests are failing due to """PysandraUnitServerError:
# Failed to execute command start: /127.0.0.1:7010 is in use by another process.
# Change listen_address:storage_port in cassandra.yaml to values that do not conflict with other services"""
return
criterion = "WHERE %s='%s'" % (self.columns[0], self.values[0])
cassandra_.then_i_delete_from_cassandra_table(
self.ctx, self.table, self.current_session_name, criterion)
statement = "SELECT * FROM %s" % self.table
cassandra_.given_i_store_cql_query_result_under_name(
self.ctx, statement, 'cql_result', self.current_session_name, 0)
self.assertEquals(self.ctx.zato.user_ctx['cql_result'], '')
def test_then_i_insert_values_into_columns_of_cassandra_table(self):
# TODO: Cassandra tests are failing due to """PysandraUnitServerError:
# Failed to execute command start: /127.0.0.1:7010 is in use by another process.
# Change listen_address:storage_port in cassandra.yaml to values that do not conflict with other services"""
return
cassandra_.then_i_insert_values_into_columns_of_cassandra_table(
self.ctx, self.table, ', '.join(self.values),
', '.join(self.columns), self.current_session_name)
statement = "SELECT * FROM %s" % self.table
cassandra_.given_i_store_cql_query_result_under_name(
self.ctx, statement, 'cql_result', self.current_session_name, 0)
self.assertEquals(self.ctx.zato.user_ctx['cql_result'],
';'.join(self.values))
def test_i_insert_data_from_csv_file_to_cassandra_table(self, open_mock):
# TODO: Cassandra tests are failing due to """PysandraUnitServerError:
# Failed to execute command start: /127.0.0.1:7010 is in use by another process.
# Change listen_address:storage_port in cassandra.yaml to values that do not conflict with other services"""
return
values = (util.rand_string(), util.rand_string(), util.rand_string())
fake_csv = 'userid, fname, sname\n%s, %s, %s' % values
filename = util.rand_string()
open_mock.return_value = StringIO(fake_csv)
cassandra_.i_insert_data_from_csv_file_to_cassandra_table(self.ctx, filename, self.table, self.current_session_name)
statement = "SELECT * FROM %s" % self.table
cassandra_.given_i_store_cql_query_result_under_name(self.ctx, statement, 'cql_result', self.current_session_name, 0)
self.assertEquals(self.ctx.zato.user_ctx['cql_result'], ';'.join(values))
def test_i_insert_data_from_csv_file_to_cassandra_table(self, open_mock):
# TODO: Cassandra tests are failing due to """PysandraUnitServerError:
# Failed to execute command start: /127.0.0.1:7010 is in use by another process.
# Change listen_address:storage_port in cassandra.yaml to values that do not conflict with other services"""
return
values = (util.rand_string(), util.rand_string(), util.rand_string())
fake_csv = 'userid, fname, sname\n%s, %s, %s' % values
filename = util.rand_string()
open_mock.return_value = StringIO(fake_csv)
cassandra_.i_insert_data_from_csv_file_to_cassandra_table(
self.ctx, filename, self.table, self.current_session_name)
statement = "SELECT * FROM %s" % self.table
cassandra_.given_i_store_cql_query_result_under_name(
self.ctx, statement, 'cql_result', self.current_session_name, 0)
self.assertEquals(self.ctx.zato.user_ctx['cql_result'],
';'.join(values))
