Beispiel #1
0
def runCommand(cmd):
    cmd.lower()
    cmds = cmd.split()
    if cmds[0] == "exit" or cmds[0] == "quit":
        return True
    elif cmds[0] == "help":
        print usage
    elif cmds[0] == "factory":
        cmds = [
            "create table t1 (id int, name string, val int)",
            "create index i1 on t1 (id)",
            "insert into t1 values (3, s, 5)",
            "insert into t1 values (2, o, 6)",
            "insert into t1 values (1, e, 7)",
            "insert into t1 values (5, d, 3)",
            "insert into t1 values (4, i, 4)",
            "select * from t1",
        ]
        for c in cmds:
            print "> " + c
            queryproc.processQuery(c)
    elif cmds[0] == "save":
        queryproc.saveTables(cmds[1])
    elif cmds[0] == "load":
        queryproc.loadTables(cmds[1])
    else:
        raise DBCommandNotFound()
Beispiel #2
0
def runInterpreter():
    print "Loading interpreter ..."
    print "Type .help for usage"

    while True:
        try:
            input = raw_input("> ")
            if input[0] == ".":  # '.' -prefix means command
                if runCommand(input[1:]):
                    break
            elif input[0] == "#":
                pass  # '#' -prefix means comment
            else:  # process sql
                queryproc.processQuery(input)
        except DBError as e:
            print str(e)