Versions in this module Expand all Collapse all v1 v1.0.0 May 11, 2026 Changes in this version + const Comment_Column_CommentID + const Comment_Column_Content + const Comment_Column_DateCreated + const Comment_Column_IsDeleted + const Comment_Column_Name + const Comment_Column_ObjectID + const Comment_Column_ObjectType + const Comment_TableName + const FiscalYear_Column_DateCreated + const FiscalYear_Column_DateFrom + const FiscalYear_Column_DateTo + const FiscalYear_Column_FiscalYearID + const FiscalYear_Column_FiscalYearKey + const FiscalYear_Column_IsDeleted + const FiscalYear_Column_IsLocked + const FiscalYear_Column_TotalFiscalDays + const FiscalYear_Column_Year + const FiscalYear_SchemaName + const FiscalYear_TableName + const JobSales_Column_CommissionDollars + const JobSales_Column_CommissionPercent + const JobSales_Column_DateCreated + const JobSales_Column_IsDeleted + const JobSales_Column_IsHouse + const JobSales_Column_JobID + const JobSales_Column_JobSalesID + const JobSales_Column_UserID + const JobSales_TableName + const Job_Column_AwardDate + const Job_Column_AwardDateString + const Job_Column_BidTypeID + const Job_Column_BillingAddress + const Job_Column_BillingAddressCity + const Job_Column_BillingAddressState + const Job_Column_BillingAddressZip + const Job_Column_CommissionTypeID + const Job_Column_CustomerContactID + const Job_Column_CustomerID + const Job_Column_CustomerPO1Number + const Job_Column_CustomerPO1SentTo + const Job_Column_CustomerPO2Number + const Job_Column_CustomerPO2SentTo + const Job_Column_DateCreated + const Job_Column_Description + const Job_Column_GrossMarginPercent + const Job_Column_GrossProfit + const Job_Column_IsAddFreight + const Job_Column_IsDeleted + const Job_Column_IsThirdPartySplit + const Job_Column_JEFDate + const Job_Column_JEFDateString + const Job_Column_JobID + const Job_Column_JobNumberString + const Job_Column_LastUpdated + const Job_Column_MarketID + const Job_Column_Notes + const Job_Column_ProjectCost + const Job_Column_QuoteID + const Job_Column_QuoteNumberID + const Job_Column_RemainingGrossProfit + const Job_Column_Sales1 + const Job_Column_Sales2 + const Job_Column_ShippingAddress + const Job_Column_ShippingAddressCity + const Job_Column_ShippingAddressState + const Job_Column_ShippingAddressZip + const Job_Column_ThirdPartyCommission + const Job_Column_ThirdPartyName + const Job_Column_ThirdPartySplitPercent + const Job_Column_TotalPrice + const Job_Column_Vendor1ID + const Job_Column_Vendor2ID + const Job_TableName + const ListItem_SchemaName + const TaskBatchSchedule_Column_CurrentStatus + const TaskBatchSchedule_Column_DOM + const TaskBatchSchedule_Column_DOW + const TaskBatchSchedule_Column_DateCreated + const TaskBatchSchedule_Column_HOD + const TaskBatchSchedule_Column_IsActive + const TaskBatchSchedule_Column_IsDeleted + const TaskBatchSchedule_Column_LastErrorDate + const TaskBatchSchedule_Column_LastRunDate + const TaskBatchSchedule_Column_LastSuccessDate + const TaskBatchSchedule_Column_MOH + const TaskBatchSchedule_Column_NumAttempted + const TaskBatchSchedule_Column_NumFailed + const TaskBatchSchedule_Column_NumFinished + const TaskBatchSchedule_Column_TaskBatchID + const TaskBatchSchedule_Column_TaskBatchScheduleID + const TaskBatchSchedule_SchemaName + const TaskBatchSchedule_TableName + var FiscalYear_Column_Types = map[goquery.Column]string + var FiscalYear_Columns = []goquery.Column + var FiscalYear_InsertColumns = []goquery.Column + var FiscalYear_PrimaryKey goquery.Column = "FiscalYearID" + var FiscalYear_UpdateColumns = []goquery.Column + var TaskBatchSchedule_Column_Types = map[goquery.Column]string + var TaskBatchSchedule_Columns = []goquery.Column + var TaskBatchSchedule_InsertColumns = []goquery.Column + var TaskBatchSchedule_PrimaryKey goquery.Column = "TaskBatchScheduleID" + var TaskBatchSchedule_UpdateColumns = []goquery.Column + func Cols() []goquery.Column + type Comment struct + CommentID int64 + Content null.String + DateCreated int64 + IsDeleted int + Name string + ObjectID int64 + ObjectType int64 + func (c *Comment) Create(db query.DBInterface) error + func (c *Comment) Delete(db query.DBInterface) error + func (c *Comment) FromID(db query.DBInterface, id int64) (query.ModelInterface, error) + func (c *Comment) String() string + func (c *Comment) Table_Column_Types() map[query.Column]string + func (c *Comment) Table_Column_Values() map[query.Column]interface{} + func (c *Comment) Table_Columns() []query.Column + func (c *Comment) Table_InsertColumns() []query.Column + func (c *Comment) Table_Name() query.TableName + func (c *Comment) Table_PrimaryKey() query.Column + func (c *Comment) Table_PrimaryKey_Value() int64 + func (c *Comment) Table_UpdateColumns() []query.Column + func (c *Comment) Update(db query.DBInterface) error + type FiscalYear struct + DateCreated int64 + DateFrom int64 + DateTo int64 + FiscalYearID int64 + FiscalYearKey int64 + IsDeleted int + IsLocked int64 + TotalFiscalDays int64 + Year int64 + func (c *FiscalYear) Create(db goquery.DBInterface) error + func (c *FiscalYear) Delete(db goquery.DBInterface) error + func (c *FiscalYear) FromID(db goquery.DBInterface, id int64) (goquery.ModelInterface, error) + func (c *FiscalYear) String() string + func (c *FiscalYear) Table_Column_Types() map[goquery.Column]string + func (c *FiscalYear) Table_Columns() []goquery.Column + func (c *FiscalYear) Table_InsertColumns() []goquery.Column + func (c *FiscalYear) Table_Name() goquery.TableName + func (c *FiscalYear) Table_PrimaryKey() goquery.Column + func (c *FiscalYear) Table_PrimaryKey_Value() int64 + func (c *FiscalYear) Table_SchemaName() string + func (c *FiscalYear) Table_UpdateColumns() []goquery.Column + func (c *FiscalYear) Update(db goquery.DBInterface) error + func (r *FiscalYear) Count(db goquery.DBInterface) *FiscalYearDALCounter + func (r *FiscalYear) Get(db goquery.DBInterface) *FiscalYearDALGetter + func (r *FiscalYear) Raw(db goquery.DBInterface, queryRaw string) ([]*FiscalYear, error) + func (r *FiscalYear) Select(db goquery.DBInterface) *FiscalYearDALSelector + func (r *FiscalYear) Sum(db goquery.DBInterface, col goquery.Column) *FiscalYearDALSummer + type FiscalYearDALCounter struct + func (ds *FiscalYearDALCounter) Run() (int64, error) + func (ds *FiscalYearDALCounter) Where(whereParts ...*goquery.WherePart) *FiscalYearDALCounter + func (r *FiscalYearDALCounter) Alias(alias string) *FiscalYearDALCounter + type FiscalYearDALGetter struct + func (ds *FiscalYearDALGetter) OrderBy(col goquery.Column, dir goquery.OrderDir) *FiscalYearDALGetter + func (ds *FiscalYearDALGetter) Run() (*FiscalYear, error) + func (ds *FiscalYearDALGetter) Where(whereParts ...*goquery.WherePart) *FiscalYearDALGetter + func (r *FiscalYearDALGetter) Alias(alias string) *FiscalYearDALGetter + type FiscalYearDALSelector struct + func (r *FiscalYearDALSelector) Alias(alias string) *FiscalYearDALSelector + func (r *FiscalYearDALSelector) Count(fieldName goquery.Column, fieldAlias string) *FiscalYearDALSelector + func (r *FiscalYearDALSelector) Limit(limit, offset int64) *FiscalYearDALSelector + func (r *FiscalYearDALSelector) OrderBy(col goquery.Column, dir goquery.OrderDir) *FiscalYearDALSelector + func (r *FiscalYearDALSelector) Run() ([]*FiscalYear, error) + func (r *FiscalYearDALSelector) Sum(fieldName goquery.Column, fieldAlias string) *FiscalYearDALSelector + func (r *FiscalYearDALSelector) Where(whereParts ...*goquery.WherePart) *FiscalYearDALSelector + type FiscalYearDALSummer struct + func (ds *FiscalYearDALSummer) Run() (float64, error) + func (ds *FiscalYearDALSummer) Where(whereParts ...*goquery.WherePart) *FiscalYearDALSummer + type Job struct + AwardDate int64 + AwardDateString string + BidTypeID int64 + BillingAddress string + BillingAddressCity string + BillingAddressState string + BillingAddressZip string + CommissionTypeID int64 + CustomerContactID int64 + CustomerID int64 + CustomerPO1Number string + CustomerPO1SentTo int64 + CustomerPO2Number string + CustomerPO2SentTo int64 + DateCreated int64 + Description string + GrossMarginPercent float64 + GrossProfit float64 + IsAddFreight int + IsDeleted int + IsThirdPartySplit int + JEFDate int64 + JEFDateString string + JobID int64 + JobNumberString string + LastUpdated int64 + MarketID int64 + Notes null.String + ProjectCost float64 + QuoteID int64 + QuoteNumberID int64 + RemainingGrossProfit float64 + Sales1 string + Sales2 string + ShippingAddress string + ShippingAddressCity string + ShippingAddressState string + ShippingAddressZip string + ThirdPartyCommission float64 + ThirdPartyName string + ThirdPartySplitPercent float64 + TotalPrice float64 + Vendor1ID int64 + Vendor2ID int64 + func (c *Job) Create(db goquery.DBInterface) error + func (c *Job) Delete(db goquery.DBInterface) error + func (c *Job) FromID(db goquery.DBInterface, id int64) (goquery.ModelInterface, error) + func (c *Job) String() string + func (c *Job) Table_Column_Types() map[goquery.Column]string + func (c *Job) Table_Column_Values() map[goquery.Column]interface{} + func (c *Job) Table_Columns() []goquery.Column + func (c *Job) Table_InsertColumns() []goquery.Column + func (c *Job) Table_Name() goquery.TableName + func (c *Job) Table_PrimaryKey() goquery.Column + func (c *Job) Table_PrimaryKey_Value() int64 + func (c *Job) Table_UpdateColumns() []goquery.Column + func (c *Job) Update(db goquery.DBInterface) error + type JobSales struct + CommissionDollars float64 + CommissionPercent float64 + DateCreated int64 + IsDeleted int + IsHouse int + JobID int64 + JobSalesID int64 + UserID int64 + func (c *JobSales) Create(db goquery.DBInterface) error + func (c *JobSales) Delete(db goquery.DBInterface) error + func (c *JobSales) FromID(db goquery.DBInterface, id int64) (goquery.ModelInterface, error) + func (c *JobSales) String() string + func (c *JobSales) Table_Column_Types() map[goquery.Column]string + func (c *JobSales) Table_Column_Values() map[goquery.Column]interface{} + func (c *JobSales) Table_Columns() []goquery.Column + func (c *JobSales) Table_InsertColumns() []goquery.Column + func (c *JobSales) Table_Name() goquery.TableName + func (c *JobSales) Table_PrimaryKey() goquery.Column + func (c *JobSales) Table_PrimaryKey_Value() int64 + func (c *JobSales) Table_UpdateColumns() []goquery.Column + func (c *JobSales) Update(db goquery.DBInterface) error + type MockDB struct + func (db *MockDB) BeginTx(ctx context.Context, opts *sql.TxOptions) (*sql.Tx, error) + func (db *MockDB) Close() + func (db *MockDB) Exec(query string, args ...interface{}) (sql.Result, error) + func (db *MockDB) ExecMany(stmts []string, chunkSize int) error + func (db *MockDB) Host() string + func (db *MockDB) Name() string + func (db *MockDB) Query(query string, args ...interface{}) (*sql.Rows, error) + func (db *MockDB) QueryRow(query string, args ...interface{}) *sql.Row + type TaskBatchSchedule struct + CurrentStatus int + DOM int64 + DOW int64 + DateCreated int64 + HOD int64 + IsActive int + IsDeleted int + LastErrorDate int64 + LastRunDate int64 + LastSuccessDate int64 + MOH int64 + NumAttempted int64 + NumFailed int64 + NumFinished int64 + TaskBatchID int64 + TaskBatchScheduleID int64 + func (c *TaskBatchSchedule) Create(db goquery.DBInterface) error + func (c *TaskBatchSchedule) Delete(db goquery.DBInterface) error + func (c *TaskBatchSchedule) FromID(db goquery.DBInterface, id int64) (goquery.ModelInterface, error) + func (c *TaskBatchSchedule) String() string + func (c *TaskBatchSchedule) Table_Column_Types() map[goquery.Column]string + func (c *TaskBatchSchedule) Table_Columns() []goquery.Column + func (c *TaskBatchSchedule) Table_InsertColumns() []goquery.Column + func (c *TaskBatchSchedule) Table_Name() goquery.TableName + func (c *TaskBatchSchedule) Table_PrimaryKey() goquery.Column + func (c *TaskBatchSchedule) Table_PrimaryKey_Value() int64 + func (c *TaskBatchSchedule) Table_SchemaName() string + func (c *TaskBatchSchedule) Table_UpdateColumns() []goquery.Column + func (c *TaskBatchSchedule) Update(db goquery.DBInterface) error