querybuilder

Documentation

Index

• func Delete(s string) string
• func QueryBuilder(fns ...FString) string
• func StringMap(fn FString, ss ...string) []string
• type ColumnMutator
• type FString
  • func AddForeignKey(name, refer, ontable string) FString
  • func AlterTable(t string) FString
  • func And(c, op string) FString
  • func AndEq(c string) FString
  • func Boolean(name string) FString
  • func CreateConstraint(c string, fn FString) FString
  • func CreateTable(name string) FString
  • func DropConstraint(table, field, ctype string) FString
  • func DropTable(t string) FString
  • func Field(name, field string) FString
  • func ForeignKey(refer, ontable string, fn FString) FString
  • func From(t string) FString
  • func InnerJoin(t string) FString
  • func Insert(into string, columns ...string) FString
  • func Int(name string) FString
  • func NotNull(fn FString) FString
  • func On(c1, c2 string) FString
  • func Or(c, op string) FString
  • func OrEq(c string) FString
  • func Prepare(fn FString) FString
  • func PrimaryKey(fn FString) FString
  • func Real(name string) FString
  • func Select(columns ...string) FString
  • func Serial(name string) FString
  • func Set(columns ...string) FString
  • func SubQuery(fns ...FString) FString
  • func TimeStamp(name string) FString
  • func TimeStamps() FString
  • func UUID() FString
  • func Unique(fn FString) FString
  • func Update(table string) FString
  • func VarChar(name string, size int) FString
  • func Where(c, op string) FString
  • func WhereEq(c string) FString
  • func WhereInSub(c string, subquery FString) FString
  • func WithColumns(fns ...FString) FString
  • func WithDefault(fn FString, v string) FString

Functions

func Delete

func Delete(s string) string

Delete is functional delete

func QueryBuilder

func QueryBuilder(fns ...FString) string

QueryBuilder composes Or a functional query builder Example: QueryBuilder(Select("column1", "column2"), FTable("users"))

func StringMap

func StringMap(fn FString, ss ...string) []string

StringMap iterates over a slice of strings with a valid FString function type

Types

type ColumnMutator

type ColumnMutator func(fn FString) FString

ColumnMutator is a function type that defines a Mutator. In this case, Mutator is more akin to PRIMARY KEY and NOT NULL.

type FString

type FString func(s string) string

FString is a special function type for function composition

func AddForeignKey

func AddForeignKey(name, refer, ontable string) FString

AddForeignKey creates an AddForeignKey statement when altering a table

func AlterTable

func AlterTable(t string) FString

AlterTable starts the Alter Table statement

func And

func And(c, op string) FString

And inserts a where clause prefixed with "AND" It takes 2 arguments, the column and the operation, both as strings It returns a function suitable for composing

func AndEq

func AndEq(c string) FString

AndEq builds an OR clause with equals Helper function for And, which sets the operation to '='

func Boolean

func Boolean(name string) FString

Boolean creates a boolean type column

func CreateConstraint

func CreateConstraint(c string, fn FString) FString

CreateConstraint adds a constraint to the end of a line

func CreateTable

func CreateTable(name string) FString

CreateTable begins a new create table query

func DropConstraint

func DropConstraint(table, field, ctype string) FString

DropConstraint assists in drop constraints based on the format { table }_{ field }_{ constrainttype } Example: DropConstraint("roles", "user_id", "fkey")

func DropTable

func DropTable(t string) FString

DropTable builds a drop table query

func Field

func Field(name, field string) FString

Field creates a field with a given type

func ForeignKey

func ForeignKey(refer, ontable string, fn FString) FString

ForeignKey helps in defining foreignkey constraints

func From

func From(t string) FString

From adds a table value

func InnerJoin

func InnerJoin(t string) FString

InnerJoin assists in creating an inner join query

func Insert

func Insert(into string, columns ...string) FString

Insert is functional insert

func Int

func Int(name string) FString

Int creates a new serial type column

func NotNull

func NotNull(fn FString) FString

NotNull sets a field to Not Null

func On

func On(c1, c2 string) FString

On sets the constraints for Joins

func Or

func Or(c, op string) FString

Or inserts a where clause prefixed with "OR" It takes 2 arguments, the column and the operation, both as strings It returns a function suitable for composing

func OrEq

func OrEq(c string) FString

OrEq builds an OR clause with equals Helper function for Or, which sets the operation to '='

func Prepare

func Prepare(fn FString) FString

Prepare caches a generated string for reuse

func PrimaryKey

func PrimaryKey(fn FString) FString

PrimaryKey is a mutator that creates a primary key from a given string

func Real

func Real(name string) FString

Real creates a new serial type column

func Select

func Select(columns ...string) FString

Select is functional select

func Serial

func Serial(name string) FString

Serial creates a new serial type column

func Set

func Set(columns ...string) FString

Set builds a "set" clause

func SubQuery

func SubQuery(fns ...FString) FString

SubQuery inserts a subquery

func TimeStamp

func TimeStamp(name string) FString

TimeStamp inserts a timestamp column of the given name

func TimeStamps

func TimeStamps() FString

TimeStamps inserts a created_at and updated_at timestamp

func UUID

func UUID() FString

UUID create's a field called id with the UUID type

func Unique

func Unique(fn FString) FString

Unique sets a field to be Unique

func Update

func Update(table string) FString

Update is functional Update

func VarChar

func VarChar(name string, size int) FString

VarChar creates a varchar column of a given size

func Where

func Where(c, op string) FString

Where inserts a where clause It takes 2 arguments, the column and the operation, both as strings It returns a function suitable for composing

func WhereEq

func WhereEq(c string) FString

WhereEq set's a where clause Or equals Helper function for Where, which sets the operation to '='

func WhereInSub

func WhereInSub(c string, subquery FString) FString

WhereInSub builds an IN clause

func WithColumns

func WithColumns(fns ...FString) FString

WithColumns builds columns through function composition

func WithDefault

func WithDefault(fn FString, v string) FString

WithDefault adds a default value. Value must always be as a string.