simpleSQLDatabase

Documentation

Index

• Constants
• func ColumnsFromTag(table interface{}, forInsert bool, requireFields []string) (columns []string, err error)
• func FieldsFromLocalTable(table interface{}, forInsert bool) (fields []string, err error)
• func NewRowsInstance(base interface{}) (rows interface{})
• func SQLRowsToStructureRows(sqlRows *sql.Rows, targetRowType interface{}) (rows []interface{}, err error)
• func StringDataFromRow(row interface{}, requiredField []string) (data []interface{})
• type BasicRows
  • func (b BasicRows) Count() int
  • func (b BasicRows) Data(requiredField []string) (data []interface{})
  • func (b BasicRows) DataForInsert() (data []interface{})
• type BasicTable
  • func (b BasicTable) Columns() (list []string)
  • func (b BasicTable) ColumnsForInsert() (list []string)
  • func (b BasicTable) FieldForInsert() (fields []string)
  • func (b BasicTable) FieldsToColumns(fields []string) []string
  • func (b BasicTable) Name() string
• type IDriver
• type IRows
• type ITable
• type SimplePagingQueryParam
  • func (s *SimplePagingQueryParam) PageFromString(page string)
• type SimplePagingQueryResult

Constants

const (
	ColumnNameTag      = "col"
	DefaultValueTag    = "def"
	IgnoreForInsertTag = "ignoreInsert"
)

Functions

func ColumnsFromTag

func ColumnsFromTag(table interface{}, forInsert bool, requireFields []string) (columns []string, err error)

func FieldsFromLocalTable

func FieldsFromLocalTable(table interface{}, forInsert bool) (fields []string, err error)

func NewRowsInstance

func NewRowsInstance(base interface{}) (rows interface{})

func SQLRowsToStructureRows

func SQLRowsToStructureRows(sqlRows *sql.Rows, targetRowType interface{}) (rows []interface{}, err error)

func StringDataFromRow

func StringDataFromRow(row interface{}, requiredField []string) (data []interface{})

Types

type BasicRows

type BasicRows struct {
	Rows []interface{}

	Instance IRows
}

func (BasicRows) Count

func (b BasicRows) Count() int

func (BasicRows) Data

func (b BasicRows) Data(requiredField []string) (data []interface{})

func (BasicRows) DataForInsert

func (b BasicRows) DataForInsert() (data []interface{})

type BasicTable

type BasicTable struct {
	Instance interface{}
	// contains filtered or unexported fields
}

func (BasicTable) Columns

func (b BasicTable) Columns() (list []string)

func (BasicTable) ColumnsForInsert

func (b BasicTable) ColumnsForInsert() (list []string)

func (BasicTable) FieldForInsert

func (b BasicTable) FieldForInsert() (fields []string)

func (BasicTable) FieldsToColumns

func (b BasicTable) FieldsToColumns(fields []string) []string

func (BasicTable) Name

func (b BasicTable) Name() string

type IDriver

type IDriver interface {
	Insert(rows IRows, ignoreKey bool) (result sql.Result, err error)
	Replace(rows IRows) (result sql.Result, err error)
	Update(rows IRows, fields []string, condition string, args []interface{}) (result sql.Result, err error)
	Query(rowType interface{}, sql string, args []interface{}) (rows []interface{}, err error)
	SimpleSelect(rowType interface{}, table string, col string, equalVal interface{}) (rows []interface{}, err error)
	RowCount(table string, condition string, args []interface{}) (cnt uint64, err error)
	SimplePagingQuery(param SimplePagingQueryParam) (ret *SimplePagingQueryResult, err error)
}

type IRows

type IRows interface {
	Table() ITable
	Count() int
	DataForInsert() []interface{}
	Data(requiredColumns []string) []interface{}
}

type ITable

type ITable interface {
	Name() string
	Columns() []string
	ColumnsForInsert() []string
	FieldForInsert() []string
	FieldsToColumns([]string) []string
	NewRows() interface{}
}

type SimplePagingQueryParam

type SimplePagingQueryParam struct {
	Page          int64
	Count         int64
	Table         string
	RowType       interface{}
	Condition     string
	ConditionArgs []interface{}
}

func (*SimplePagingQueryParam) PageFromString

func (s *SimplePagingQueryParam) PageFromString(page string)

type SimplePagingQueryResult

type SimplePagingQueryResult struct {
	Total uint64
	Rows  interface{}
}