Function On

join.go:71–91

On creates a "join on" expression ie, as SQL, SELECT * FROM A INNER JOIN B ON B.id = A.user_id Syntax: "[table].[field]", "field"

(fields ...string)

// ie, as SQL, SELECT * FROM A INNER JOIN B ON B.id = A.user_id
// Syntax: "[table].[field]", "field"
func On(fields ...string) []JoinOn {
	var jon []JoinOn
	for _, f := range fields {
		matches := rgOn.FindStringSubmatch(f)

		switch len(matches) {
		case 0:
			jon = append(jon, JoinOn{Table: "*", Field: f})
		case 3:
			t := matches[1]
			if len(t) == 0 {
				t = "*"
			}
			jon = append(jon, JoinOn{Table: t, Field: matches[2]})
		default:
			return nil
		}
	}

	return jon
}

// Using creates a "join using" expression
// ie, as SQL, SELECT * FROM A INNER JOIN B USING 'field'