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)