Method parseInsertCommand

parser/parser.go:159–227

parseInsertCommand - Return ast.InsertCommand created from tokens and validate the syntax Example of input parsable to the ast.InsertCommand: insert into tbl values( 'hello', 10 );

()

// Example of input parsable to the ast.InsertCommand:
// insert into tbl values( 'hello',	 10 );
func (parser *Parser) parseInsertCommand() (ast.Command, error) {
	// token.INSERT already at current position in parser
	insertCommand := &ast.InsertCommand{Token: parser.currentToken}

	// Ignore token.INSERT
	parser.nextToken()

	err := validateTokenAndSkip(parser, []token.Type{token.INTO})
	if err != nil {
		return nil, err
	}

	err = validateToken(parser.currentToken.Type, []token.Type{token.IDENT})
	if err != nil {
		return nil, err
	}
	insertCommand.Name = ast.Identifier{Token: parser.currentToken}
	// Ignore token.INDENT
	parser.nextToken()

	err = validateTokenAndSkip(parser, []token.Type{token.VALUES})
	if err != nil {
		return nil, err
	}
	err = validateTokenAndSkip(parser, []token.Type{token.LPAREN})
	if err != nil {
		return nil, err
	}

	for parser.currentToken.Type == token.IDENT || parser.currentToken.Type == token.LITERAL || parser.currentToken.Type == token.NULL || parser.currentToken.Type == token.APOSTROPHE {
		startedWithApostrophe := parser.skipIfCurrentTokenIsApostrophe()

		err = validateToken(parser.currentToken.Type, []token.Type{token.IDENT, token.LITERAL, token.NULL})
		if err != nil {
			return nil, err
		}
		value := parser.currentToken
		insertCommand.Values = append(insertCommand.Values, value)
		// Ignore token.IDENT, token.LITERAL or token.NULL
		parser.nextToken()

		finishedWithApostrophe := parser.skipIfCurrentTokenIsApostrophe()

		err = validateApostropheWrapping(startedWithApostrophe, finishedWithApostrophe, value)

		if err != nil {
			return nil, err
		}

		if parser.currentToken.Type != token.COMMA {
			break
		}

		// Ignore token.COMMA
		parser.nextToken()
	}

	err = validateTokenAndSkip(parser, []token.Type{token.RPAREN})