def load_stored_procedures(self, sp_files):
dbname = self.param_dict['dbname']
dbdir = os.path.join(os.getenv('HOME'),
self.param_dict['user'],
self.param_dict['mwd'],
self.param_dict['dbdir'])
print "Setting up database ", dbname
for f in sp_files:
mddb_utils.load_sql("{0}/{1}".format(dbdir,f), dbname)
def init_database(self, init_files):
dbname = self.param_dict['dbname']
dbdir = os.path.join(os.getenv('HOME'),
self.param_dict['user'],
self.param_dict['mwd'],
self.param_dict['dbdir'])
p = mddb_utils.run_cmd("dropdb {0}".format(dbname))
p = mddb_utils.run_cmd("createdb {0}".format(dbname))
madpack = '/usr/local/madlib/bin/madpack'
#mddb_utils.run_sql("alter role {0} with password '12345'".format(self.param_dict['dbuser']), dbname)
#mddb_utils.run_cmd("{0} -p greenplum -c {1}/12345@{2}/{3} install".format(
# madpack, self.param_dict['dbuser'], 'localhost4', dbname))
#mddb_utils.run_sql("alter role {0} with password null".format(self.param_dict['dbuser']), dbname)
for f in init_files:
mddb_utils.load_sql("{0}/{1}".format(dbdir,f), dbname)
