sqlbuilder

Documentation

Index

• func AddLatestJoinWithOneLevelFilter(db *gorm.DB, typeString string, tableName string, latestn int, ...) (*gorm.DB, error)
• func AddLatestNCTEJoin(db *gorm.DB, typeString string, tableName string, latestn int, ...) (*gorm.DB, error)
• func AddNestedQueryJoinStmt(db *gorm.DB, typeString string, criteria TwoLevelFilterCriteria) (*gorm.DB, error)
• func AddWhereStmt(db *gorm.DB, typeString string, tableName string, filter FilterCriteria) (*gorm.DB, error)
• type FilterCriteria
• type Predicate
• type TwoLevelFilterCriteria

Functions

func AddLatestJoinWithOneLevelFilter

func AddLatestJoinWithOneLevelFilter(db *gorm.DB, typeString string, tableName string, latestn int, filters []FilterCriteria) (*gorm.DB, error)

AddLatestJoinWithOneLevelFilter generates latest join with one-level filter TODO? Can tablename be part of the "?"

func AddLatestNCTEJoin

func AddLatestNCTEJoin(db *gorm.DB, typeString string, tableName string, latestn int, latestnons []string, filterslatestnons []FilterCriteria) (*gorm.DB, error)

filters is for latestnons

func AddNestedQueryJoinStmt

func AddNestedQueryJoinStmt(db *gorm.DB, typeString string, criteria TwoLevelFilterCriteria) (*gorm.DB, error)

AddNestedQueryJoinStmt adds a join statement into db

func AddWhereStmt

func AddWhereStmt(db *gorm.DB, typeString string, tableName string, filter FilterCriteria) (*gorm.DB, error)

AddWhereStmt adds where statement into db

Types

type FilterCriteria

type FilterCriteria struct {
	FieldName     string        // Field name to match
	PredicatesArr [][]Predicate // greater than less than, etc., multiple for AND relationship

}

FilterCriteria is the criteria to query for first-level field

type Predicate

type Predicate struct {
	PredicateLogic qry.PredicateCond
	FieldValue     string
}

Predicate :-

type TwoLevelFilterCriteria

type TwoLevelFilterCriteria struct {
	OuterTableName string
	InnerTableName string
	OuterFieldName string
	Filters        []FilterCriteria // Key: inner table name,
}

TwoLevelFilterCriteria is the criteria to query for inner level field