sqlgen

type FieldDefFunc func(fmt, col string, vals ...interface{})

type FieldSet interface {
	// It adds a row to the set.
	Row(func(RowDef))

	// Potent returns true if this FieldSet would produce a useful SQL query.
	// If Potent() returns false, there's no purpose in using this FieldSet with the database.
	Potent() bool

	// InsertSQL generates and returns an INSERT query to send to the database to insert this FieldSet.
	// The conflict string is used to resolve duplicate rows in an upserty kind of a way.
	// It allows Go template formatting.
	InsertSQL(table string, conflict string) string

	// InsertValues produces a slice of values for INSERTs, such that the positions of values will match up
	// with SQL replacements in an InsertSQL call.
	InsertValues() []interface{}

	// RowCount returns the number of rows in the FieldSet.
	RowCount() int
}

type Inserter interface {
	Exec(table string, conflict string, fn func(FieldSet)) error
}

type RowDef interface {
	// FD is short for Field Definition - used for defining fields in the row.
	FD(fmt string, col string, vals ...interface{})

	// CF is short for Candidate Field - used to define fields in the row that participate in distinguishing the row.
	// Two rows with the same values for their "CFs" will be considered the same.
	CF(fmt string, col string, vals ...interface{})

	KV(col string, val interface{})
}