gormcnm

Dec 9, 2024

Changes in this version

+ type TableJoin struct

+ func (op *TableJoin) On(stmts ...string) string

Dec 8, 2024

Changes in this version

type ColumnName

+ func Cnm[T any](v T, name string) ColumnName[T]

+ func New[T any](name string) ColumnName[T]

Dec 6, 2024

Changes in this version

+ type ClauseColumn clause.Column

+ func (clauseColumn *ClauseColumn[TYPE]) Assignment(value TYPE) clause.Assignment

+ func (clauseColumn *ClauseColumn[TYPE]) Column() clause.Column

+ func (clauseColumn *ClauseColumn[TYPE]) WithAlias(alias string) *ClauseColumn[TYPE]

+ func (clauseColumn *ClauseColumn[TYPE]) WithRaw(raw bool) *ClauseColumn[TYPE]

+ func (clauseColumn *ClauseColumn[TYPE]) WithTable(tableName string) *ClauseColumn[TYPE]

+ type CoalesceNonNullGuardian struct

+ func NewCoalesceNonNullGuardian(methodName string, columnName string) *CoalesceNonNullGuardian

+ func (qs *CoalesceNonNullGuardian) AvgStmt(alias string) string

+ func (qs *CoalesceNonNullGuardian) MaxStmt(alias string) string

+ func (qs *CoalesceNonNullGuardian) MinStmt(alias string) string

+ func (qs *CoalesceNonNullGuardian) Stmt(sfn string, dfv string, alias string) string

+ func (qs *CoalesceNonNullGuardian) SumStmt(alias string) string

+ type ColumnName string

+ func (columnName ColumnName[TYPE]) AsAlias(alias string) string

+ func (columnName ColumnName[TYPE]) BetweenAND(arg1, arg2 TYPE) (string, TYPE, TYPE)

+ func (columnName ColumnName[TYPE]) BetweenAnd(arg1, arg2 TYPE) (string, TYPE, TYPE)

+ func (columnName ColumnName[TYPE]) COALESCE() *CoalesceNonNullGuardian

+ func (columnName ColumnName[TYPE]) Clause() *ClauseColumn[TYPE]

+ func (columnName ColumnName[TYPE]) ClauseWithTable(tableName string) *ClauseColumn[TYPE]

+ func (columnName ColumnName[TYPE]) ColumnCondition(op string) QsConjunction

+ func (columnName ColumnName[TYPE]) ColumnConditionWithValue(op string, x TYPE) *QxConjunction

+ func (columnName ColumnName[TYPE]) ColumnKeyAndValue(x TYPE) (string, TYPE)

+ func (columnName ColumnName[TYPE]) Count(alias string) string

+ func (columnName ColumnName[TYPE]) CountDistinct(alias string) string

+ func (columnName ColumnName[TYPE]) CreateColumnValueMap(x TYPE) ColumnValueMap

+ func (columnName ColumnName[TYPE]) Eq(x TYPE) (string, TYPE)

+ func (columnName ColumnName[TYPE]) ExprAdd(v TYPE) clause.Expr

+ func (columnName ColumnName[TYPE]) ExprSub(v TYPE) clause.Expr

+ func (columnName ColumnName[TYPE]) Gt(x TYPE) (string, TYPE)

+ func (columnName ColumnName[TYPE]) Gte(x TYPE) (string, TYPE)

+ func (columnName ColumnName[TYPE]) IFNULLFN() *CoalesceNonNullGuardian

+ func (columnName ColumnName[TYPE]) In(x []TYPE) (string, []TYPE)

+ func (columnName ColumnName[TYPE]) IsFALSE() string

+ func (columnName ColumnName[TYPE]) IsFalse() string

+ func (columnName ColumnName[TYPE]) IsNULL() string

+ func (columnName ColumnName[TYPE]) IsNotNULL() string

+ func (columnName ColumnName[TYPE]) IsNotNull() string

+ func (columnName ColumnName[TYPE]) IsNull() string

+ func (columnName ColumnName[TYPE]) IsTRUE() string

+ func (columnName ColumnName[TYPE]) IsTrue() string

+ func (columnName ColumnName[TYPE]) KeAdd(x TYPE) (string, clause.Expr)

+ func (columnName ColumnName[TYPE]) KeExp(x clause.Expr) (string, clause.Expr)

+ func (columnName ColumnName[TYPE]) KeSub(x TYPE) (string, clause.Expr)

+ func (columnName ColumnName[TYPE]) Kv(x TYPE) (string, TYPE)

+ func (columnName ColumnName[TYPE]) Kw(x TYPE) ColumnValueMap

+ func (columnName ColumnName[TYPE]) Like(x TYPE) (string, TYPE)

+ func (columnName ColumnName[TYPE]) Lt(x TYPE) (string, TYPE)

+ func (columnName ColumnName[TYPE]) Lte(x TYPE) (string, TYPE)

+ func (columnName ColumnName[TYPE]) Name() string

+ func (columnName ColumnName[TYPE]) Ne(x TYPE) (string, TYPE)

+ func (columnName ColumnName[TYPE]) NotEq(x TYPE) (string, TYPE)

+ func (columnName ColumnName[TYPE]) NotIn(x []TYPE) (string, []TYPE)

+ func (columnName ColumnName[TYPE]) NotLike(x TYPE) (string, TYPE)

+ func (columnName ColumnName[TYPE]) Ob(direction string) OrderByBottle

+ func (columnName ColumnName[TYPE]) Op(op string, x TYPE) (string, TYPE)

+ func (columnName ColumnName[TYPE]) OrderByDirection(direction string) OrderByBottle

+ func (columnName ColumnName[TYPE]) Qc(op string) QsConjunction

+ func (columnName ColumnName[TYPE]) Qs(op string) string

+ func (columnName ColumnName[TYPE]) Qx(op string, x TYPE) *QxConjunction

+ func (columnName ColumnName[TYPE]) RawName() string

+ func (columnName ColumnName[TYPE]) SafeCnm(quote string) ColumnName[TYPE]

+ func (columnName ColumnName[TYPE]) TB(tab utils.GormTableNameFace) *TableColumn[TYPE]

+ func (columnName ColumnName[TYPE]) TC(tab utils.GormTableNameFace) *TableColumn[TYPE]

+ func (columnName ColumnName[TYPE]) TN(tableName string) *TableColumn[TYPE]

+ func (columnName ColumnName[TYPE]) WithTable(tab utils.GormTableNameFace) *TableColumn[TYPE]

+ func (columnName ColumnName[TYPE]) WithTableName(tableName string) *TableColumn[TYPE]

+ type ColumnOperationClass struct

+ func (common *ColumnOperationClass) CROSSJOIN(tableName string) *tableJoin

+ func (common *ColumnOperationClass) CombineColumnNames(a ...utils.ColumnNameInterface) string

+ func (common *ColumnOperationClass) CombineSelectStatements(cs ...SelectStatement) *SelectStatement

+ func (common *ColumnOperationClass) CombineStatements(a ...string) string

+ func (common *ColumnOperationClass) CombineSxs(cs ...SelectStatement) *SelectStatement

+ func (common *ColumnOperationClass) CountCaseWhenQxSx(qx *QxConjunction, alias string) *SelectStatement

+ func (common *ColumnOperationClass) CountCaseWhenStmt(condition string, alias string) string

+ func (common *ColumnOperationClass) CountStmt(alias string) string

+ func (common *ColumnOperationClass) CreateColumnValueMap(columnName string, value interface{}) ColumnValueMap

+ func (common *ColumnOperationClass) CreateCondition(stmt string, args ...interface{}) *QxConjunction

+ func (common *ColumnOperationClass) CreateSelect(stmt string, args ...interface{}) *SelectStatement

+ func (common *ColumnOperationClass) INNERJOIN(tableName string) *tableJoin

+ func (common *ColumnOperationClass) Kw(columnName string, value interface{}) ColumnValueMap

+ func (common *ColumnOperationClass) LEFTJOIN(tableName string) *tableJoin

+ func (common *ColumnOperationClass) MergeNames(a ...utils.ColumnNameInterface) string

+ func (common *ColumnOperationClass) MergeStmts(a ...string) string

+ func (common *ColumnOperationClass) NewColumnValueMap() ColumnValueMap

+ func (common *ColumnOperationClass) NewKw() ColumnValueMap

+ func (common *ColumnOperationClass) NewQx(stmt string, args ...interface{}) *QxConjunction

+ func (common *ColumnOperationClass) NewSx(stmt string, args ...interface{}) *SelectStatement

+ func (common *ColumnOperationClass) OK() bool

+ func (common *ColumnOperationClass) OrderByColumns(db *gorm.DB, obs ...OrderByBottle) *gorm.DB

+ func (common *ColumnOperationClass) Qx(stmt string, args ...interface{}) *QxConjunction

+ func (common *ColumnOperationClass) RIGHTJOIN(tableName string) *tableJoin

+ func (common *ColumnOperationClass) Select(db *gorm.DB, qxs ...*SelectStatement) *gorm.DB

+ func (common *ColumnOperationClass) Sx(stmt string, args ...interface{}) *SelectStatement

+ func (common *ColumnOperationClass) UpdateColumns(db *gorm.DB, kws ...ColumnValueMap) *gorm.DB

+ func (common *ColumnOperationClass) Where(db *gorm.DB, qxs ...*QxConjunction) *gorm.DB

+ type ColumnValueMap map[string]interface

+ func (mp ColumnValueMap) AsMap() map[string]interface{}

+ func (mp ColumnValueMap) Kw(columnName string, value interface{}) ColumnValueMap

+ func (mp ColumnValueMap) Kws() map[string]interface{}

+ func (mp ColumnValueMap) Map() map[string]interface{}

+ func (mp ColumnValueMap) ToMap() map[string]interface{}

+ func Kw(columnName string, value interface{}) ColumnValueMap

+ func NewKw() ColumnValueMap

+ type OrderByBottle string

+ func (ob OrderByBottle) Ob(next OrderByBottle) OrderByBottle

+ func (ob OrderByBottle) Ox() string

+ type QsConjunction string

+ func NewQsConjunction(stmt string) QsConjunction

+ func (qsConjunction QsConjunction) AND(qcs ...QsConjunction) QsConjunction

+ func (qsConjunction QsConjunction) NOT() QsConjunction

+ func (qsConjunction QsConjunction) OR(qcs ...QsConjunction) QsConjunction

+ func (qsConjunction QsConjunction) Qs() string

+ func (qsConjunction QsConjunction) Qx() *QxConjunction

+ func (qsConjunction QsConjunction) Value() (driver.Value, error)

+ type QsType = QsConjunction

+ func NewQs(stmt string) QsType

+ type QxConjunction struct

+ func NewQxConjunction(stmt string, args ...interface{}) *QxConjunction

+ func Qx(stmt string, args ...interface{}) *QxConjunction

+ func (qx *QxConjunction) AND(cs ...*QxConjunction) *QxConjunction

+ func (qx *QxConjunction) AND1(stmt string, args ...interface{}) *QxConjunction

+ func (qx *QxConjunction) NOT() *QxConjunction

+ func (qx *QxConjunction) OR(cs ...*QxConjunction) *QxConjunction

+ func (qx *QxConjunction) OR1(stmt string, args ...interface{}) *QxConjunction

+ func (qx QxConjunction) Args() []interface{}

+ func (qx QxConjunction) Qs() string

+ func (qx QxConjunction) Qx0() string

+ func (qx QxConjunction) Qx1() (string, interface{})

+ func (qx QxConjunction) Qx10() (string, interface{}, interface{}, interface{}, interface{}, interface{}, ...)

+ func (qx QxConjunction) Qx11() (string, interface{}, interface{}, interface{}, interface{}, interface{}, ...)

+ func (qx QxConjunction) Qx12() (string, interface{}, interface{}, interface{}, interface{}, interface{}, ...)

+ func (qx QxConjunction) Qx2() (string, interface{}, interface{})

+ func (qx QxConjunction) Qx3() (string, interface{}, interface{}, interface{})

+ func (qx QxConjunction) Qx4() (string, interface{}, interface{}, interface{}, interface{})

+ func (qx QxConjunction) Qx5() (string, interface{}, interface{}, interface{}, interface{}, interface{})

+ func (qx QxConjunction) Qx6() (string, interface{}, interface{}, interface{}, interface{}, interface{}, ...)

+ func (qx QxConjunction) Qx7() (string, interface{}, interface{}, interface{}, interface{}, interface{}, ...)

+ func (qx QxConjunction) Qx8() (string, interface{}, interface{}, interface{}, interface{}, interface{}, ...)

+ func (qx QxConjunction) Qx9() (string, interface{}, interface{}, interface{}, interface{}, interface{}, ...)

+ func (qx QxConjunction) Value() (driver.Value, error)

+ type QxType = QxConjunction

+ func NewQx(stmt string, args ...interface{}) *QxType

+ type SelectStatement struct

+ func NewSelectStatement(stmt string, args ...interface{}) *SelectStatement

+ func (qx SelectStatement) Args() []interface{}

+ func (qx SelectStatement) Qs() string

+ func (qx SelectStatement) Qx0() string

+ func (qx SelectStatement) Qx1() (string, interface{})

+ func (qx SelectStatement) Qx10() (string, interface{}, interface{}, interface{}, interface{}, interface{}, ...)

+ func (qx SelectStatement) Qx11() (string, interface{}, interface{}, interface{}, interface{}, interface{}, ...)

+ func (qx SelectStatement) Qx12() (string, interface{}, interface{}, interface{}, interface{}, interface{}, ...)

+ func (qx SelectStatement) Qx2() (string, interface{}, interface{})

+ func (qx SelectStatement) Qx3() (string, interface{}, interface{}, interface{})

+ func (qx SelectStatement) Qx4() (string, interface{}, interface{}, interface{}, interface{})

+ func (qx SelectStatement) Qx5() (string, interface{}, interface{}, interface{}, interface{}, interface{})

+ func (qx SelectStatement) Qx6() (string, interface{}, interface{}, interface{}, interface{}, interface{}, ...)

+ func (qx SelectStatement) Qx7() (string, interface{}, interface{}, interface{}, interface{}, interface{}, ...)

+ func (qx SelectStatement) Qx8() (string, interface{}, interface{}, interface{}, interface{}, interface{}, ...)

+ func (qx SelectStatement) Qx9() (string, interface{}, interface{}, interface{}, interface{}, interface{}, ...)

+ func (qx SelectStatement) Value() (driver.Value, error)

+ func (selectStatement *SelectStatement) Combine(cs ...*SelectStatement) *SelectStatement

+ type SxType = SelectStatement

+ func NewSx(stmt string, args ...interface{}) *SxType

+ type TableColumn struct

+ func (tc *TableColumn[TYPE]) AsAlias(alias string) string

+ func (tc *TableColumn[TYPE]) AsName(alias ColumnName[TYPE]) string

+ func (tc *TableColumn[TYPE]) Cnm() ColumnName[TYPE]

+ func (tc *TableColumn[TYPE]) ColumnName() ColumnName[TYPE]

+ func (tc *TableColumn[TYPE]) Eq(xc *TableColumn[TYPE]) string

+ func (tc *TableColumn[TYPE]) Name() string

+ func (tc *TableColumn[TYPE]) Ob(direction string) OrderByBottle

+ func (tc *TableColumn[TYPE]) Op(op string, xc *TableColumn[TYPE]) string