jookr.py

import os

SQL = "INSERT INTO table (`value1`,`value2`,) VALUES ('%s','%s');\n"


def main():
    for fname in os.listdir("."):
        # step1
        name, ext = os.path.splitext(fname)
        if ext != ".txt":
            continue
        os.rename(fname, name + ".sql")
        # step2
        i = name.index("-")
        left = name[:i]
        # step3
        with open(name + ".sql", "r") as f:
            contents = f.read().split("\n")
        with open(name + ".sql", "w") as f:
            for value in contents:
                f.write(SQL % (left, value))

if __name__ == '__main__':
    main()