import sys import argparse outputxml = '<Script version="1">\n' def add_query(q): global outputxml template = "<Query>\n<![CDATA[\n{0}\n]]>\n</Query>\n" outputxml += template.format(q) def main(argv): global outputxml parser = argparse.ArgumentParser(description='Convert SQL to OH-DB Script.xml.') parser.add_argument('-i','--input', type=str, help='Input SQL-file') parser.add_argument('-o','--output', type=str, help='Output XML-file' , default='DB Script.xml' ) args = parser.parse_args() with open(args.input) as f: content = f.readlines() chunk = '' transaction = False for line in content: if line.startswith('--'): continue if line.startswith('DELIMITER'): continue if line.startswith('START TRANSACTION;'): transaction = True continue if line.startswith('COMMIT;'): transaction = False continue if transaction: chunk += line; if line == '\n' or transaction == True: if len(chunk.strip('\n \t')) == 0: continue add_query(chunk); chunk='' continue chunk += line; outputxml += '</Script>' with open(args.output, 'w') as f: f.write(outputxml) print outputxml if __name__ == "__main__": main(sys.argv)
Run
Reset
Share
Import
Link
Embed
Language▼
English
中文
Python Fiddle
Python Cloud IDE
Follow @python_fiddle
Browser Version Not Supported
Due to Python Fiddle's reliance on advanced JavaScript techniques, older browsers might have problems running it correctly. Please download the latest version of your favourite browser.
Chrome 10+
Firefox 4+
Safari 5+
IE 10+
Let me try anyway!
url:
Go
Python Snippet
Stackoverflow Question