sqlbuilder

README

sqlbuilder

Documentation

Index

• type Builder
  • func NewBuilder() *Builder
  • func (b *Builder) And(cond Condition) *Builder
  • func (b *Builder) Asc() *Builder
  • func (b *Builder) Columns(fields ...Field) *Builder
  • func (b *Builder) DeleteFrom(table Table) *Builder
  • func (b *Builder) Desc() *Builder
  • func (b *Builder) ForUpdate() *Builder
  • func (b *Builder) From(tables ...Table) *Builder
  • func (b *Builder) InsertInto(table Table) *Builder
  • func (b *Builder) Limit() *Builder
  • func (b *Builder) Or(cond Condition) *Builder
  • func (b *Builder) OrderBy(fields ...Field) *Builder
  • func (b *Builder) Select(fields ...Field) *Builder
  • func (b *Builder) Set(fields ...Field) *Builder
  • func (b *Builder) String() string
  • func (b *Builder) Update(table Table) *Builder
  • func (b *Builder) Where(cond Condition) *Builder
• type Condition
• type Equal
  • func (e Equal) String() string
• type Field
  • func (f Field) As(alias Field) Field
  • func (f Field) Assign() Field
  • func (f Field) Count() Field
  • func (f Field) Named() Field
  • func (f Field) Of(alias Table) Field
  • func (f Field) String() string
• type FieldModifier
• type Keyword
• type Table
  • func (t Table) As(alias Table) Table
  • func (t Table) Field(name string) Field
  • func (t Table) String() string
• type TableModifier

Types

type Builder

type Builder struct {
	// contains filtered or unexported fields
}

func NewBuilder

func NewBuilder() *Builder

func (*Builder) And

func (b *Builder) And(cond Condition) *Builder

And implements Keyword.

func (*Builder) Asc

func (b *Builder) Asc() *Builder

Asc implements Keyword.

func (*Builder) Columns

func (b *Builder) Columns(fields ...Field) *Builder

Columns implements Keyword.

func (*Builder) DeleteFrom

func (b *Builder) DeleteFrom(table Table) *Builder

DeleteFrom implements Keyword.

func (*Builder) Desc

func (b *Builder) Desc() *Builder

Desc implements Keyword.

func (*Builder) ForUpdate

func (b *Builder) ForUpdate() *Builder

ForUpdate implements Keyword.

func (*Builder) From

func (b *Builder) From(tables ...Table) *Builder

func (*Builder) InsertInto

func (b *Builder) InsertInto(table Table) *Builder

InsertInto implements Keyword.

func (*Builder) Limit

func (b *Builder) Limit() *Builder

Limit implements Keyword.

func (*Builder) Or

func (b *Builder) Or(cond Condition) *Builder

Or implements Keyword.

func (*Builder) OrderBy

func (b *Builder) OrderBy(fields ...Field) *Builder

OrderBy implements Keyword.

func (*Builder) Select

func (b *Builder) Select(fields ...Field) *Builder

func (*Builder) Set

func (b *Builder) Set(fields ...Field) *Builder

Set implements Keyword.

func (*Builder) String

func (b *Builder) String() string

String implements Keyword.

func (*Builder) Update

func (b *Builder) Update(table Table) *Builder

Update implements Keyword.

func (*Builder) Where

func (b *Builder) Where(cond Condition) *Builder

type Condition

type Condition interface {
	fmt.Stringer
}

type Equal

type Equal struct {
	Left  Field
	Right Field
}

func (Equal) String

func (e Equal) String() string

String implements Condition.

type Field

type Field string

func (Field) As

func (f Field) As(alias Field) Field

As implements FieldModifier.

func (Field) Assign

func (f Field) Assign() Field

Assign implements FieldModifier.

func (Field) Count

func (f Field) Count() Field

Count implements FieldModifier.

func (Field) Named

func (f Field) Named() Field

Named implements FieldModifier.

func (Field) Of

func (f Field) Of(alias Table) Field

Of implements FieldModifier.

func (Field) String

func (f Field) String() string

String implements FieldModifier.

type FieldModifier

type FieldModifier interface {
	fmt.Stringer
	Count() Field
	As(Field) Field
	Of(Table) Field
	Named() Field
	Assign() Field
}

type Keyword

type Keyword interface {
	fmt.Stringer
	Select(...Field) *Builder
	From(...Table) *Builder
	Where(Condition) *Builder
	And(Condition) *Builder
	Or(Condition) *Builder
	ForUpdate() *Builder
	OrderBy(...Field) *Builder
	Asc() *Builder
	Desc() *Builder
	Limit() *Builder
	InsertInto(Table) *Builder
	Columns(...Field) *Builder
	Update(Table) *Builder
	Set(...Field) *Builder
	DeleteFrom(Table) *Builder
}

type Table

type Table string

func (Table) As

func (t Table) As(alias Table) Table

As implements Modifier.

func (Table) Field

func (t Table) Field(name string) Field

Field implements TableModifier.

func (Table) String

func (t Table) String() string

String implements Modifier.

type TableModifier

type TableModifier interface {
	fmt.Stringer
	As(Table) Table
	Field(string) Field
}