Method insertIntoTable

engine/engine.go:218–242

insertIntoTable - Insert row of values into the table

(command *ast.InsertCommand)

// insertIntoTable - Insert row of values into the table
func (engine *DbEngine) insertIntoTable(command *ast.InsertCommand) error {
	table, exist := engine.Tables[command.Name.Token.Literal]
	if !exist {
		return &TableDoesNotExistError{command.Name.Token.Literal}
	}

	columns := table.Columns

	if len(command.Values) != len(columns) {
		return &InvalidNumberOfParametersError{expectedNumber: len(columns), actualNumber: len(command.Values), commandName: command.Token.Literal}
	}

	for i := range columns {
		expectedToken := tokenMapper(columns[i].Type.Type)
		if (expectedToken != command.Values[i].Type) && (command.Values[i].Type != token.NULL) {
			return &InvalidValueTypeError{expectedType: string(expectedToken), actualType: string(command.Values[i].Type), commandName: command.Token.Literal}
		}
		interfaceValue, err := getInterfaceValue(command.Values[i])
		if err != nil {
			return err
		}
		columns[i].Values = append(columns[i].Values, interfaceValue)
	}
	return nil
}

func (engine *DbEngine) selectFromProvidedTable(command *ast.SelectCommand, table *Table) (*Table, error) {
	columns := table.Columns