Method parseCreateCols

rel/parse_sql.go:1656–1731

()

}

func (m *Sqlbridge) parseCreateCols() ([]*DdlColumn, error) {

	cols := make([]*DdlColumn, 0)
	var col *DdlColumn
	/*
		CREATE TABLE articles (
		  ID int(11) NOT NULL AUTO_INCREMENT,
		  Email char(150) NOT NULL DEFAULT '',
		  PRIMARY KEY (ID),
		  CONSTRAINT emails_fk FOREIGN KEY (Email) REFERENCES Emails (Email)
		)
	*/
	for {

		discardComments(m)
		switch m.Cur().T {
		case lex.TokenIdentity:
			col = &DdlColumn{Name: strings.ToLower(m.Next().V), Kw: lex.TokenIdentity}
			if err := m.parseDdlColumn(col); err != nil {
				return nil, err
			}
		case lex.TokenConstraint:
			col = &DdlColumn{Kw: m.Next().T}
			if err := m.parseDdlConstraint(col); err != nil {
				return nil, err
			}
		case lex.TokenPrimary:
			col = &DdlColumn{Kw: m.Next().T}
			if strings.ToLower(m.Next().V) != "key" {
				return nil, m.ErrMsg("expected 'PRIMARY KEY'")
			}
			if m.Next().T != lex.TokenLeftParenthesis {
				return nil, m.ErrMsg("expected 'PRIMARY KEY (field)'")
			}

		PrimaryKeyLoop:
			for {

				switch m.Cur().T {
				case lex.TokenRightParenthesis:
					m.Next() // consume )
					break PrimaryKeyLoop
				case lex.TokenIdentity:
					col = &DdlColumn{Name: strings.ToLower(m.Next().V), Kw: lex.TokenIdentity}
				case lex.TokenConstraint:
					col = &DdlColumn{Kw: m.Next().T}
				case lex.TokenPrimary:
					col = &DdlColumn{Kw: m.Next().T}
					if strings.ToLower(m.Cur().V) != "key" {
						return nil, m.ErrMsg("expected 'PRIMARY KEY'")
					}
					m.Next()

				default:
					return nil, m.ErrMsg("expected identity")
				}
			}