sqlbuilder

Documentation

Index

• func AddLatestJoinWithOneLevelFilter(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 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 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 {
	// TableName   string
	FieldName   string   // Field name to match
	FieldValues []string // Criteria to match
}

FilterCriteria is the criteria to query for first-level field

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