mysql 词法代码

function lexicalAnalysis(sqlStatement):
    tokens = []
    currentState = START_STATE
    buffer = ""

    for each character in sqlStatement:
        switch (currentState):
            case START_STATE:
                if character is letter:
                    buffer += character
                    currentState = IDENTIFIER_STATE
                else if character is digit:
                    buffer += character
                    currentState = NUMBER_STATE
                else:
                    // Handle other cases like operators, keywords, etc.
            case IDENTIFIER_STATE:
                if character is letter or character is digit:
                    buffer += character
                else:
                    if isKeyword(buffer):
                        tokens.append(new Token(KEYWORD, buffer))
                    else:
                        tokens.append(new Token(IDENTIFIER, buffer))
                    buffer = ""
                    currentState = START_STATE
                    // Handle the current character
            // Handle other states like NUMBER_STATE, OPERATOR_STATE, etc.

    return tokens