SpreadServe Cloud Schema

ss_schema1.py

# create SS cloud schema

import socket
import logging
import os
import rethinkdb as rdb

if __name__ == "__main__":
    conn = rdb.connect( 'localhost', 28015)

    # drop the old DB
    try:
        print( rdb.db_drop( 'sscloud'))
    except rdb.RqlRuntimeError as ex:
        print( "sscloud DB doesn't exist %s" % ex.message)

    # create the new DB with instance, sheet and user tables
    try:
        print( rdb.db_create( 'sscloud'))
        db = rdb.db( 'sscloud')
        print( db.table_create( 'ssinst').run( conn))
        print( db.table_create( 'sheet').run( conn))
        print( db.table_create( 'user').run( conn))
    except rdb.RqlRuntimeError as err:
        print( err.message)
    finally:
        print( conn.close( ))