statement

Documentation

Index

• Constants
• func WriteDelete(sw io.StringWriter, table string) error
• func WriteInsert(sw io.StringWriter, into string, columns []string) error
• func WriteSelect(sw io.StringWriter, selectColumns []clauses.Selectable) error
• func WriteUpdate(sw io.StringWriter, table string) error
• type ClauseWriter
  • func (s *ClauseWriter) SetClause(c clauses.Clause)
  • func (s *ClauseWriter) Write(sw io.StringWriter) error
• type Delete
  • func NewDelete(table string) *Delete
  • func (d *Delete) Write(sw io.StringWriter) error
• type Insert
  • func NewInsert(table string, columns []string) *Insert
  • func (i *Insert) Write(sw io.StringWriter) error
• type Select
  • func NewSelect(selectColumns []clauses.Selectable) *Select
  • func (s *Select) Write(sw io.StringWriter) error
• type Statement
• type Update
  • func NewUpdate(table string) *Update
  • func (u *Update) Write(sw io.StringWriter) error

Constants

const (
	SpaceSeparator = " "
	CommaSeparator = ", "
)

Functions

func WriteDelete

func WriteDelete(sw io.StringWriter, table string) error

func WriteInsert

func WriteInsert(sw io.StringWriter, into string, columns []string) error

WriteInsert writes a SQL WriteInsert statement to the given string writer.

Example:

INSERT INTO users (username, age)

func WriteSelect

func WriteSelect(sw io.StringWriter, selectColumns []clauses.Selectable) error

WriteSelect writes a SQL select query to the given string writer.

Example:

SELECT field1, field2, field3

func WriteUpdate

func WriteUpdate(sw io.StringWriter, table string) error

WriteUpdate writes a SQL update query to the given string writer.

Example:

UPDATE table

Types

type ClauseWriter

type ClauseWriter struct {
	ClauseSeparator string
	// contains filtered or unexported fields
}

ClauseWriter represents a ClauseWriter.

func (*ClauseWriter) SetClause

func (s *ClauseWriter) SetClause(c clauses.Clause)

SetClause implements Statement SetClause.

func (*ClauseWriter) Write

func (s *ClauseWriter) Write(sw io.StringWriter) error

Write writes clauses to the string writer.

type Delete

type Delete struct {
	ClauseWriter
	// contains filtered or unexported fields
}

Delete writes a SQL From string to the given string writer.

func NewDelete

func NewDelete(
	table string,
) *Delete

NewDelete creates a new Delete statement.

func (*Delete) Write

func (d *Delete) Write(sw io.StringWriter) error

ToSQL returns the query as a string and it's arguments and an error if any.

type Insert

type Insert struct {
	ClauseWriter
	// contains filtered or unexported fields
}

SelectWriter writes a SQL From string to the given string writer.

func NewInsert

func NewInsert(table string, columns []string) *Insert

NewSelectClause creates a new SelectClause.

func (*Insert) Write

func (i *Insert) Write(sw io.StringWriter) error

ToSQL returns the query as a string and it's arguments and an error if any.

type Select

type Select struct {
	ClauseWriter
	// contains filtered or unexported fields
}

SelectWriter writes a SQL From string to the given string writer.

func NewSelect

func NewSelect(
	selectColumns []clauses.Selectable,
) *Select

NewSelectClause creates a new SelectClause.

func (*Select) Write

func (s *Select) Write(sw io.StringWriter) error

ToSQL returns the query as a string and it's arguments and an error if any.

type Statement

type Statement interface {
	expressions.Expression
	SetClause(clauses.Clause)
}

type Update

type Update struct {
	ClauseWriter
	// contains filtered or unexported fields
}

Update writes an update statement to the given string writer.

func NewUpdate

func NewUpdate(
	table string,
) *Update

NewUpdate creates a new update statement.

func (*Update) Write

func (u *Update) Write(sw io.StringWriter) error

ToSQL returns the query as a string and it's arguments and an error if any.