KanbanCore_earlyValid/direct.py

import sqlite3


def Operate_sqlite3(dbPath, commands):

    con = sqlite3.connect(dbPath)
    cur = con.cursor()
    # 1. exist check
    try:
        res = cur.execute(commands)
        con.commit()
        print("res.fetchone() is None: ", res.fetchone() is None)

        # syntax right but not exist:
        if res.fetchone() is None == True:
            print("err <Code>: could not found, creat? y/n")


    except:
        print("err <Code>: Syntax error")

    con.close()


if __name__ == "__main__":
    while(1):
        # syi = input("sql: ").split()
        sy_i = input("sql: ")
        Operate_sqlite3("dev.db", sy_i)