def main(argv):
print "************************* cassandra test START"
print py_cassandra.version()
users_columns = ["email","pw","date_creation","date_change","date_last_login","applications","appdrop_rem_token", "appdrop_rem_token_exp","visit_cnt", "cookie", "cookie_ip","cookie_exp", "cksum"]
users_values = ["*****@*****.**", "11", "2009", "2009", "2009", "bbs", "xxx", "xxx","1", "yyy", "0.0.0.0", "2009", "zzz"]
apps_columns = ["name", "version","owner","admins_list","host","port","creation_date", "last_time_updated_date", "yaml_file", "cksum", "num_entries"]
apps_values = ["name", "version","owner","admins_list","host","port","creation_date", "last_time_updated_date", "yaml_file", "cksum", "num_entries"]
TABLE_NAME = "AppScale"
COLUMN_FAMILY="appscale"
TABLE= "AppScale"
FAMILY="appscale"
KEY = "test"
COLUMN = "column1"
VALUE = "value1"
# key, family, column, value
# print py_cassandra.test_insert(KEY, COLUMN, VALUE)
# family(table_name), row_key
# print py_cassandra.get_row(FAMILY, KEY)
#create table .. : tablename(family), schema list
#print py_cassandra.create_table("apps", apps_columns)
#print py_cassandra.get_schema("apps")
#print py_cassandra.create_table("users", users_columns)
#print py_cassandra.get_schema("users")
#print py_cassandra.get_row_count("apps") [1:]
#print py_cassandra.get_row_count("users") [1:]
#print py_cassandra.put_entity("users", "users_suwanny", users_columns, users_values)
#print py_cassandra.get_row("users", "users_suwanny")[1:]
print "before keys", py_cassandra.get_keys()
column_names = ["name", "email", "date_creation", "column3"]
values = ["value1", "value2","value3", "value4"]
values2 = ["value2-1", "value2-2","value2-3", "value2-4"]
table = "temp"
key = "test_1"
key2 = "test_2"
#print "create table", py_cassandra.create_table(table, column_names)
#print "get_schema", py_cassandra.get_schema(table)[1:]
#print "row_count", py_cassandra.get_row_count(table)[1:]
#print "put_entity", py_cassandra.put_entity(table, key, column_names, values)
#print "put_entity", py_cassandra.put_entity(table, key2, column_names, values2)
#print "get_row", py_cassandra.get_row(table, key)[1:]
#print "delete_row", py_cassandra.delete_row(table, key)
#print "get_entity", (py_cassandra.get_entity(table, key2, column_names))[1:]
#print "get_table", py_cassandra.get_table(table, column_names)[1:]
print "put_entity", py_cassandra.put_entity("temp2", "test3", column_names, values)
print "get_schema", py_cassandra.get_schema("temp2")[1:]
print "get_table", py_cassandra.get_table("temp2", column_names)[1:]
# everything is sorted by alphabet order ..
print "after keys", py_cassandra.get_keys()
print "************************* cassandra test END"
def main(argv):
print "************************* cassandra test START"
print py_cassandra.version()
users_columns = [
"email", "pw", "date_creation", "date_change", "date_last_login",
"applications", "appdrop_rem_token", "appdrop_rem_token_exp",
"visit_cnt", "cookie", "cookie_ip", "cookie_exp", "cksum"
]
users_values = [
"*****@*****.**", "11", "2009", "2009", "2009", "bbs", "xxx", "xxx",
"1", "yyy", "0.0.0.0", "2009", "zzz"
]
apps_columns = [
"name", "version", "owner", "admins_list", "host", "port",
"creation_date", "last_time_updated_date", "yaml_file", "cksum",
"num_entries"
]
apps_values = [
"name", "version", "owner", "admins_list", "host", "port",
"creation_date", "last_time_updated_date", "yaml_file", "cksum",
"num_entries"
]
TABLE_NAME = "AppScale"
COLUMN_FAMILY = "appscale"
TABLE = "AppScale"
FAMILY = "appscale"
KEY = "test"
COLUMN = "column1"
VALUE = "value1"
# key, family, column, value
# print py_cassandra.test_insert(KEY, COLUMN, VALUE)
# family(table_name), row_key
# print py_cassandra.get_row(FAMILY, KEY)
#create table .. : tablename(family), schema list
#print py_cassandra.create_table("apps", apps_columns)
#print py_cassandra.get_schema("apps")
#print py_cassandra.create_table("users", users_columns)
#print py_cassandra.get_schema("users")
#print py_cassandra.get_row_count("apps") [1:]
#print py_cassandra.get_row_count("users") [1:]
#print py_cassandra.put_entity("users", "users_suwanny", users_columns, users_values)
#print py_cassandra.get_row("users", "users_suwanny")[1:]
print "before keys", py_cassandra.get_keys()
column_names = ["name", "email", "date_creation", "column3"]
values = ["value1", "value2", "value3", "value4"]
values2 = ["value2-1", "value2-2", "value2-3", "value2-4"]
table = "temp"
key = "test_1"
key2 = "test_2"
#print "create table", py_cassandra.create_table(table, column_names)
#print "get_schema", py_cassandra.get_schema(table)[1:]
#print "row_count", py_cassandra.get_row_count(table)[1:]
#print "put_entity", py_cassandra.put_entity(table, key, column_names, values)
#print "put_entity", py_cassandra.put_entity(table, key2, column_names, values2)
#print "get_row", py_cassandra.get_row(table, key)[1:]
#print "delete_row", py_cassandra.delete_row(table, key)
#print "get_entity", (py_cassandra.get_entity(table, key2, column_names))[1:]
#print "get_table", py_cassandra.get_table(table, column_names)[1:]
print "put_entity", py_cassandra.put_entity("temp2", "test3", column_names,
values)
print "get_schema", py_cassandra.get_schema("temp2")[1:]
print "get_table", py_cassandra.get_table("temp2", column_names)[1:]
# everything is sorted by alphabet order ..
print "after keys", py_cassandra.get_keys()
print "************************* cassandra test END"
if ret[1:] != columns:
print "ERROR in recieved schema"
print "returned: " + str(ret)
print "expected: " + str(columns)
ret = py_cassandra.delete_row(table_name, key)
print "Deleting the key %s"%key
print ret
ret = py_cassandra.get_entity(table_name, key, columns)
print "Trying to get deleted key:"
print ret
print "doing a put with key %s"%key
print py_cassandra.put_entity("hello", "1", ["a","b","c"], ["1","2","3"])
print "doing a get table"
print py_cassandra.get_table("hello", ["a","b","c"])
py_cassandra.put_entity("hello", "2", ["a","b","c"], ["4","5","6"])
print "doing get table:"
print py_cassandra.get_table("hello", ["a","b","c"])
py_cassandra.put_entity("hello", "3", ["a","b","c"], ["1","2","3"])
py_cassandra.get_table("hello", ["a","b","c"])
print "TRYING TO REPLACE KEY 3"
py_cassandra.put_entity("hello", "3", ["a","b","c"], ["1","2","3"])
print "TRYING TO REPLACE KEY 3"
py_cassandra.get_table("hello", ["a","b","c"])
print "TRYING TO REPLACE KEY 3"
ret = py_cassandra.delete_row("hello", "1")
print "TRYING TO REPLACE KEY 3"
ret = py_cassandra.delete_row("hello", "2")
print "TRYING TO REPLACE KEY 3"
