Documentation
¶
Index ¶
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
This section is empty.
Types ¶
type CTE ¶
type CTE struct {
Name string
Columns []string
Subquery clause.Expression
Materialized CTEMaterializeOption
}
CTE common table expressions
func NewCTE ¶ added in v0.4.0
NewCTE creates a new CTE with unspecified materialization (database default)
func NewMaterializedCTE ¶ added in v0.4.0
NewMaterializedCTE creates a new CTE that will be materialized
func NewNotMaterializedCTE ¶ added in v0.4.0
NewNotMaterializedCTE creates a new CTE that will not be materialized
type CTEMaterializeOption ¶ added in v0.4.0
type CTEMaterializeOption int
CTEMaterializeOption represents the materialization hint for a CTE
const ( // CTEMaterializeUnspecified means no materialization hint (database default) CTEMaterializeUnspecified CTEMaterializeOption = iota // CTEMaterialize forces the CTE to be materialized CTEMaterialize // CTENotMaterialize prevents the CTE from being materialized CTENotMaterialize )
type Except ¶ added in v0.2.0
type Except struct {
Statements []clause.Expression
}
Except is except clause
func NewExcept ¶ added in v0.2.0
func NewExcept(query interface{}, args ...interface{}) Except
NewExcept is easy to create new Except
// examples
// SELECT * FROM `general_users` EXCEPT SELECT * FROM `admin_users`
db.Table("general_users").Clauses(exclause.NewExcept("SELECT * FROM `admin_users`")).Scan(&users)
// SELECT * FROM `general_users` EXCEPT SELECT * FROM `admin_users`
db.Table("general_users").Clauses(exclause.NewExcept(db.Table("admin_users"))).Scan(&users)
// SELECT * FROM `general_users` EXCEPT ALL SELECT * FROM `admin_users`
db.Table("general_users").Clauses(exclause.NewExcept("ALL ?", db.Table("admin_users"))).Scan(&users)
func (Except) MergeClause ¶ added in v0.2.0
MergeClause merge Except clauses
type Intersect ¶ added in v0.2.0
type Intersect struct {
Statements []clause.Expression
}
Intersect is intersect clause
func NewIntersect ¶ added in v0.2.0
func NewIntersect(query interface{}, args ...interface{}) Intersect
NewIntersect is easy to create new Intersect
// examples
// SELECT * FROM `general_users` INTERSECT SELECT * FROM `admin_users`
db.Table("general_users").Clauses(exclause.NewIntersect("SELECT * FROM `admin_users`")).Scan(&users)
// SELECT * FROM `general_users` INTERSECT SELECT * FROM `admin_users`
db.Table("general_users").Clauses(exclause.NewIntersect(db.Table("admin_users"))).Scan(&users)
// SELECT * FROM `general_users` INTERSECT ALL SELECT * FROM `admin_users`
db.Table("general_users").Clauses(exclause.NewIntersect("ALL ?", db.Table("admin_users"))).Scan(&users)
func (Intersect) MergeClause ¶ added in v0.2.0
MergeClause merge Intersect clauses
type Union ¶
type Union struct {
Statements []clause.Expression
}
Union is union clause
func NewUnion ¶
func NewUnion(query interface{}, args ...interface{}) Union
NewUnion is easy to create new Union
// examples
// SELECT * FROM `general_users` UNION SELECT * FROM `admin_users`
db.Table("general_users").Clauses(exclause.NewUnion("SELECT * FROM `admin_users`")).Scan(&users)
// SELECT * FROM `general_users` UNION SELECT * FROM `admin_users`
db.Table("general_users").Clauses(exclause.NewUnion(db.Table("admin_users"))).Scan(&users)
// SELECT * FROM `general_users` UNION ALL SELECT * FROM `admin_users`
db.Table("general_users").Clauses(exclause.NewUnion("ALL ?", db.Table("admin_users"))).Scan(&users)
func (Union) MergeClause ¶
MergeClause merge Union clauses
type With ¶
With with clause
// examples
// WITH `cte` AS (SELECT * FROM `users`) SELECT * FROM `cte`
db.Clauses(exclause.With{CTEs: []exclause.CTE{{Name: "cte", Subquery: clause.Expr{SQL: "SELECT * FROM `users`"}}}}).Table("cte").Scan(&users)
// WITH `cte` AS (SELECT * FROM `users`) SELECT * FROM `cte`
db.Clauses(exclause.With{CTEs: []exclause.CTE{{Name: "cte", Subquery: exclause.Subquery{DB: db.Table("users")}}}}).Table("cte").Scan(&users)
// WITH `cte` (`id`,`name`) AS (SELECT * FROM `users`) SELECT * FROM `cte`
db.Clauses(exclause.With{CTEs: []exclause.CTE{{Name: "cte", Columns: []string{"id", "name"}, Subquery: exclause.Subquery{DB: db.Table("users")}}}}).Table("cte").Scan(&users)
// WITH RECURSIVE `cte` AS (SELECT * FROM `users`) SELECT * FROM `cte`
db.Clauses(exclause.With{Recursive: true, CTEs: []exclause.CTE{{Name: "cte", Subquery: exclause.Subquery{DB: db.Table("users")}}}}).Table("cte").Scan(&users)
// WITH `cte` AS MATERIALIZED (SELECT * FROM `users`) SELECT * FROM `cte`
db.Clauses(exclause.With{CTEs: []exclause.CTE{{Name: "cte", Subquery: exclause.Subquery{DB: db.Table("users")}, Materialized: exclause.CTEMaterialize}}}).Table("cte").Scan(&users)
// WITH `cte` AS NOT MATERIALIZED (SELECT * FROM `users`) SELECT * FROM `cte`
db.Clauses(exclause.With{CTEs: []exclause.CTE{{Name: "cte", Subquery: exclause.Subquery{DB: db.Table("users")}, Materialized: exclause.CTENotMaterialize}}}).Table("cte").Scan(&users)
// WITH `cte1` AS MATERIALIZED (...), `cte2` AS NOT MATERIALIZED (...) SELECT * FROM `cte1`
db.Clauses(exclause.With{CTEs: []exclause.CTE{
exclause.NewMaterializedCTE("cte1", exclause.Subquery{DB: db.Table("users")}),
exclause.NewNotMaterializedCTE("cte2", exclause.Subquery{DB: db.Table("products")}),
}}).Table("cte1").Scan(&users)
func NewWith ¶
NewWith is easy to create new With
// examples
// WITH `cte` AS (SELECT * FROM `users`) SELECT * FROM `cte`
db.Clauses(exclause.NewWith("cte", "SELECT * FROM `users`")).Table("cte").Scan(&users)
// WITH `cte` AS (SELECT * FROM `users` WHERE `name` = 'WinterYukky') SELECT * FROM `cte`
db.Clauses(exclause.NewWith("cte", "SELECT * FROM `users` WHERE `name` = ?", "WinterYukky")).Table("cte").Scan(&users)
// WITH `cte` AS (SELECT * FROM `users` WHERE `name` = 'WinterYukky') SELECT * FROM `cte`
db.Clauses(exclause.NewWith("cte", db.Table("users").Where("`name` = ?", "WinterYukky"))).Table("cte").Scan(&users)
If you need more advanced WITH clause, you can see With struct.
func (With) MergeClause ¶
MergeClause merge With clauses
Source Files
Click to show internal directories.
Click to hide internal directories.