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))