def import_bootstrap(): print "Importing bootstrap ..." vendor = "SQLServer" impl = DatabaseImpl.get(vendor) impl.create_database("sthpw") upgrade_dir = Environment.get_upgrade_dir() for category in ['bootstrap', 'sthpw', 'config']: f = open("%s/%s/%s_schema.sql" % (upgrade_dir, vendor.lower(), category) ) data = f.read() f.close() data = data.split(";") cmds = [] for cmd in data: cmd = cmd.strip() if cmd == '': continue cmds.append(cmd) from pyasm.search import DbContainer sql = DbContainer.get("sthpw") for cmd in cmds: sql.do_update(cmd)
def import_bootstrap(): print "Importing bootstrap ..." vendor = "MySQL" impl = DatabaseImpl.get(vendor) impl.create_database("sthpw") upgrade_dir = Environment.get_upgrade_dir() for category in ['bootstrap', 'sthpw', 'config']: f = open("%s/%s/%s_schema.sql" % (upgrade_dir, vendor.lower(), category)) data = f.read() f.close() data = data.split(";") cmds = [] for cmd in data: cmd = cmd.strip() if cmd == '': continue cmds.append(cmd) from pyasm.search import DbContainer sql = DbContainer.get("sthpw") for cmd in cmds: sql.do_update(cmd)
def convert_file(my, src_path, dst_path): upgrade_dir = Environment.get_upgrade_dir() tmp_dir = Environment.get_tmp_dir() dir = os.path.dirname(dst_path) if dir and not os.path.exists(dir): os.makedirs(dir) f = open(src_path, 'r') f2 = open(dst_path, 'w') # prepend lines lines = my.get_prepend_lines() for line in lines: f2.write(line) for line in f.xreadlines(): line = my.handle_line(line) if line == None: continue f2.write(line) f.close() f2.close() return dst_path
def convert_file(self, src_path, dst_path): upgrade_dir = Environment.get_upgrade_dir() tmp_dir = Environment.get_tmp_dir() dir = os.path.dirname(dst_path) if dir and not os.path.exists(dir): os.makedirs(dir) f = open(src_path, 'r') f2 = open(dst_path, 'w') # prepend lines lines = self.get_prepend_lines() for line in lines: f2.write(line) for line in f.xreadlines(): line = self.handle_line(line) if line == None: continue f2.write(line) f.close() f2.close() return dst_path
def convert_bootstrap(my): upgrade_dir = Environment.get_upgrade_dir() file_names = [ "bootstrap_schema.sql", "sthpw_schema.sql", "config_schema.sql" ] for file_name in file_names: src_file = "%s/postgresql/%s" % (upgrade_dir, file_name) dst_file = "%s/%s/%s" % (upgrade_dir, my.vendor.lower(), file_name) print "Converting .." print " from: ", src_file print " to: ", dst_file my.convert_file(src_file, dst_file)
def convert_upgrade(self, namespace): self.namespace = namespace upgrade_dir = Environment.get_upgrade_dir() tmp_dir = Environment.get_tmp_dir() src_path ="%s/project/%s_upgrade.py" % (upgrade_dir, namespace) dst_path = "%s/upgrade/%s/%s_upgrade.py" % (tmp_dir, self.vendor, namespace) self.convert_file(src_path, dst_path) return dst_path
def convert_bootstrap(self): upgrade_dir = Environment.get_upgrade_dir() file_names = [ "bootstrap_schema.sql", "sthpw_schema.sql", "config_schema.sql" ] for file_name in file_names: src_file = "%s/postgresql/%s" % (upgrade_dir, file_name) dst_file = "%s/%s/%s" % (upgrade_dir, self.vendor.lower(), file_name) print "Converting .." print " from: ", src_file print " to: ", dst_file self.convert_file(src_file, dst_file)
def convert_sqlite_upgrade(namespace): upgrade_dir = Environment.get_upgrade_dir() tmp_dir = Environment.get_tmp_dir() src_path = "%s/project/%s_upgrade.py" % (upgrade_dir, namespace) path = "%s/upgrade/sqlite/%s_upgrade.py" % (tmp_dir, namespace) dir = os.path.dirname(path) if not os.path.exists(dir): os.makedirs(dir) f = open(src_path, 'r') f2 = open(path, 'w') for line in f.xreadlines(): if line.find("serial PRIMARY KEY") != -1: line = line.replace("serial PRIMARY KEY", "integer PRIMARY KEY AUTOINCREMENT") elif line.find("PRIMARY KEY") != -1: if line.find("ALTER TABLE") != -1: pass else: pass elif line.find("now()") != -1: line = line.replace("now()", "CURRENT_TIMESTAMP") elif line.startswith("class "): line = "class Sqlite%sUpgrade(BaseUpgrade):\n" % namespace.capitalize( ) elif line.startswith("__all__ "): line = "__all__ = ['Sqlite%sUpgrade']\n" % namespace.capitalize() f2.write(line) #print line.rstrip() f.close() f2.close() return path
def import_bootstrap(): print "Importing bootstrap ..." vendor = "PostgreSQL" plugin_dir = Environment.get_plugin_dir() sys.path.insert(0, plugin_dir) impl = DatabaseImpl.get(vendor) impl.create_database("sthpw") upgrade_dir = Environment.get_upgrade_dir() for category in ['bootstrap', 'sthpw', 'config']: f = open("%s/%s/%s_schema.sql" % (upgrade_dir, vendor.lower(), category)) data = f.read() f.close() data = data.split(";") cmds = [] for cmd in data: lines = cmd.split("\n") lines2 = [] for line in lines: if line.startswith("--"): continue lines2.append(line) cmd = "\n".join(lines2) cmd = cmd.strip() if cmd == '': continue cmds.append(cmd) from pyasm.search import DbContainer sql = DbContainer.get("sthpw") for cmd in cmds: sql.do_update(cmd)
def import_bootstrap(): print "Importing bootstrap ..." vendor = "PostgreSQL" plugin_dir = Environment.get_plugin_dir() sys.path.insert(0, plugin_dir) impl = DatabaseImpl.get(vendor) impl.create_database("sthpw") upgrade_dir = Environment.get_upgrade_dir() for category in ['bootstrap', 'sthpw', 'config']: f = open("%s/%s/%s_schema.sql" % (upgrade_dir, vendor.lower(), category) ) data = f.read() f.close() data = data.split(";") cmds = [] for cmd in data: lines = cmd.split("\n") lines2 = [] for line in lines: if line.startswith("--"): continue lines2.append(line) cmd = "\n".join(lines2) cmd = cmd.strip() if cmd == '': continue cmds.append(cmd) from pyasm.search import DbContainer, DbResource sql = DbContainer.get("sthpw") for cmd in cmds: sql.do_update(cmd)