sqb

README

Simple Query Builder

Simple query builder for build SQL queries

Example

Simple example below

package main

import (
  "github.com/DizoftTeam/sqb"

  "fmt"
)

func main() {
  query := sqb.NewQuery("users as u").
    Select("u.name, u.email").
    Where("and", "u.name = 'Ruslan'").
    Generate()

  // TODO: Here you can use generated query as you want

  fmt.Printf("SQL: %v\n", query)
}

Documentation

Index

• type Query
  • func NewQuery(tableName string) *Query
  • func (q *Query) Generate() string
  • func (q *Query) Limit(limit int) *Query
  • func (q *Query) Offset(offset int) *Query
  • func (q *Query) Select(expr string) *Query
  • func (q *Query) Where(whereType string, condition string) *Query

Types

type Query

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

Query struct for QB

func NewQuery

func NewQuery(tableName string) *Query

NewQuery creates a new query object

func (*Query) Generate

func (q *Query) Generate() string

Generate sql statement

func (*Query) Limit

func (q *Query) Limit(limit int) *Query

Limit sets a limit

func (*Query) Offset

func (q *Query) Offset(offset int) *Query

Offset sets a offset

func (*Query) Select

func (q *Query) Select(expr string) *Query

Select adds a select expression

func (*Query) Where

func (q *Query) Where(whereType string, condition string) *Query

Where adds a where