def standalone():
c = connection.cursor()
create_statements = get_create_statements()
print "Create statements: ", create_statements
for cs in create_statements:
try:
print "executing %s" % cs
c.execute(cs)
except Exception:
_log.exception("Failed to create table")
pass
print "Done."
c.close()
def standalone():
c = connection.cursor()
create_statements = get_create_statements()
print "Create statements: ", create_statements
for cs in create_statements:
try:
print "executing %s" % cs
c.execute(cs)
except Exception:
_log.exception("Failed to create table")
pass
print "Done."
c.close()
def standalone():
c = connection.cursor()
try:
c.execute("select * from public_ids;")
except cql.ProgrammingError:
print ("Newer Homestead tables don't exist, create and populate them")
create_statements = get_create_statements()
print "Create statements: ", create_statements
for cs in create_statements:
try:
print "executing %s" % cs
c.execute(cs)
except Exception:
_log.exception("Failed to create table")
pass
print "Done."
# For each entry in the SIP_DIGESTS table, create entries in the
# public_ids and private_ids tables that contain the mapping
# private_id:<xxx> - public_id:<sip:xxx> - this is what earlier versions
# of Clearwater simulated but did not store in the database.
c.execute("SELECT private_id from %s;" % config.SIP_DIGESTS_TABLE)
private_ids = []
while True:
row = c.fetchone()
if row == None:
break
private_ids.append(row[0])
print ("List of private IDs: %s" % private_ids)
for priv in private_ids:
pub = "sip:" + priv
print ("Inserting private/public ID pair: %s/%s" % (priv, pub))
try:
c.execute("INSERT INTO %s (public_id, '%s') values ('%s', '%s');" % (config.PRIVATE_IDS_TABLE, priv, pub, priv))
c.execute("INSERT INTO %s (private_id, '%s') values ('%s', '%s');" % (config.PUBLIC_IDS_TABLE, pub, priv, pub))
except Exception:
_log.exception("Failed to insert private/public ID pair: %s/%s" % (priv, pub))
pass
print "Done."
c.close()
def create_tables(logger):
create_statements = get_create_statements()
# Print out the statements we will execute.
for keyspace, statements in create_statements.items():
print keyspace+":"
for s in statements:
print " "+s
# Now execute the statements in the correct keyspace.
for keyspace, statements in create_statements.items():
c = connection.cursor(keyspace)
for s in statements:
try:
print "Executing %s" % s
c.execute(s)
except Exception, ex:
print ex
logger.exception("Failed to create table")
print "Done."
c.close()