parser.py

import os


TXT_PATH = ""
QUERY_PATH = ""

text = ""
queries = []
with open(TXT_PATH, "r") as f:
    text = f.read().strip()
    queries = list(map(lambda x: x.strip(), text.split("CREATE QUERY")))
    queries = queries[1:]

os.chdir(QUERY_PATH)
for query in queries:
    j = query.index("(")
    name = query[:j].strip()
    query = f"DROP QUERY {name} \n CREATE " + query + f" \n INSTALL QUERY {name}"
    with open(f'{name}.gsql', "w") as f:
        f.write(query)
        print(name)