Documentation
¶
Index ¶
- Constants
- Variables
- func Cols() []goquery.Column
- type Comment
- 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
- func (r *FiscalYear) Count(db goquery.DBInterface) *FiscalYearDALCounter
- 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 (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 (c *FiscalYear) String() string
- func (r *FiscalYear) Sum(db goquery.DBInterface, col goquery.Column) *FiscalYearDALSummer
- 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
- type FiscalYearDALCounter
- type FiscalYearDALGetter
- func (r *FiscalYearDALGetter) Alias(alias string) *FiscalYearDALGetter
- 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
- type FiscalYearDALSelector
- 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
- type Job
- 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
- 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
- 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
- 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
Constants ¶
const ( // ListItem_SchemaName is the name of the schema group this model is in ListItem_SchemaName = "rfq" // Comment_TableName Comment_TableName query.TableName = "Comment" // Columns Comment_Column_CommentID query.Column = "CommentID" Comment_Column_DateCreated query.Column = "DateCreated" Comment_Column_IsDeleted query.Column = "IsDeleted" Comment_Column_Content query.Column = "Content" Comment_Column_ObjectType query.Column = "ObjectType" Comment_Column_ObjectID query.Column = "ObjectID" Comment_Column_Name query.Column = "Name" )
const ( // FiscalYear_SchemaName is the name of the schema group this model is in FiscalYear_SchemaName = "rfq" // FiscalYear_TableName is the name of the table FiscalYear_TableName goquery.TableName = "FiscalYear" // Columns FiscalYear_Column_FiscalYearID goquery.Column = "FiscalYearID" FiscalYear_Column_FiscalYearKey goquery.Column = "FiscalYearKey" FiscalYear_Column_Year goquery.Column = "Year" FiscalYear_Column_DateFrom goquery.Column = "DateFrom" FiscalYear_Column_DateTo goquery.Column = "DateTo" FiscalYear_Column_DateCreated goquery.Column = "DateCreated" FiscalYear_Column_IsDeleted goquery.Column = "IsDeleted" FiscalYear_Column_TotalFiscalDays goquery.Column = "TotalFiscalDays" FiscalYear_Column_IsLocked goquery.Column = "IsLocked" )
const ( Job_TableName goquery.TableName = "Job" // Columns Job_Column_JobID goquery.Column = "JobID" Job_Column_DateCreated goquery.Column = "DateCreated" Job_Column_LastUpdated goquery.Column = "LastUpdated" Job_Column_IsDeleted goquery.Column = "IsDeleted" Job_Column_QuoteNumberID goquery.Column = "QuoteNumberID" Job_Column_CustomerID goquery.Column = "CustomerID" Job_Column_AwardDate goquery.Column = "AwardDate" Job_Column_AwardDateString goquery.Column = "AwardDateString" Job_Column_QuoteID goquery.Column = "QuoteID" Job_Column_Description goquery.Column = "Description" Job_Column_CustomerContactID goquery.Column = "CustomerContactID" Job_Column_Notes goquery.Column = "Notes" Job_Column_CustomerPO2SentTo goquery.Column = "CustomerPO2SentTo" Job_Column_ThirdPartyName goquery.Column = "ThirdPartyName" Job_Column_CustomerPO2Number goquery.Column = "CustomerPO2Number" Job_Column_BillingAddressZip goquery.Column = "BillingAddressZip" Job_Column_BillingAddress goquery.Column = "BillingAddress" Job_Column_BillingAddressState goquery.Column = "BillingAddressState" Job_Column_CustomerPO1SentTo goquery.Column = "CustomerPO1SentTo" Job_Column_ProjectCost goquery.Column = "ProjectCost" Job_Column_CustomerPO1Number goquery.Column = "CustomerPO1Number" Job_Column_ThirdPartySplitPercent goquery.Column = "ThirdPartySplitPercent" Job_Column_CommissionTypeID goquery.Column = "CommissionTypeID" Job_Column_GrossMarginPercent goquery.Column = "GrossMarginPercent" Job_Column_TotalPrice goquery.Column = "TotalPrice" Job_Column_IsThirdPartySplit goquery.Column = "IsThirdPartySplit" Job_Column_GrossProfit goquery.Column = "GrossProfit" Job_Column_BillingAddressCity goquery.Column = "BillingAddressCity" Job_Column_RemainingGrossProfit goquery.Column = "RemainingGrossProfit" Job_Column_IsAddFreight goquery.Column = "IsAddFreight" Job_Column_JobNumberString goquery.Column = "JobNumberString" Job_Column_ThirdPartyCommission goquery.Column = "ThirdPartyCommission" Job_Column_ShippingAddressZip goquery.Column = "ShippingAddressZip" Job_Column_ShippingAddress goquery.Column = "ShippingAddress" Job_Column_ShippingAddressCity goquery.Column = "ShippingAddressCity" Job_Column_ShippingAddressState goquery.Column = "ShippingAddressState" Job_Column_Sales1 goquery.Column = "Sales1" Job_Column_BidTypeID goquery.Column = "BidTypeID" Job_Column_Vendor1ID goquery.Column = "Vendor1ID" Job_Column_MarketID goquery.Column = "MarketID" Job_Column_Vendor2ID goquery.Column = "Vendor2ID" Job_Column_Sales2 goquery.Column = "Sales2" Job_Column_JEFDate goquery.Column = "JEFDate" Job_Column_JEFDateString goquery.Column = "JEFDateString" )
const ( JobSales_TableName goquery.TableName = "JobSales" JobSales_Column_JobSalesID goquery.Column = "JobSalesID" JobSales_Column_JobID goquery.Column = "JobID" JobSales_Column_UserID goquery.Column = "UserID" JobSales_Column_CommissionPercent goquery.Column = "CommissionPercent" JobSales_Column_DateCreated goquery.Column = "DateCreated" JobSales_Column_IsDeleted goquery.Column = "IsDeleted" JobSales_Column_CommissionDollars goquery.Column = "CommissionDollars" JobSales_Column_IsHouse goquery.Column = "IsHouse" )
const ( // TaskBatchSchedule_SchemaName is the name of the schema group this model is in TaskBatchSchedule_SchemaName = "dvc" // TaskBatchSchedule_TableName is the name of the table TaskBatchSchedule_TableName goquery.TableName = "TaskBatchSchedule" // Columns TaskBatchSchedule_Column_TaskBatchScheduleID goquery.Column = "TaskBatchScheduleID" TaskBatchSchedule_Column_TaskBatchID goquery.Column = "TaskBatchID" TaskBatchSchedule_Column_DOM goquery.Column = "DOM" TaskBatchSchedule_Column_DOW goquery.Column = "DOW" TaskBatchSchedule_Column_HOD goquery.Column = "HOD" TaskBatchSchedule_Column_MOH goquery.Column = "MOH" TaskBatchSchedule_Column_DateCreated goquery.Column = "DateCreated" TaskBatchSchedule_Column_IsDeleted goquery.Column = "IsDeleted" TaskBatchSchedule_Column_IsActive goquery.Column = "IsActive" TaskBatchSchedule_Column_CurrentStatus goquery.Column = "CurrentStatus" TaskBatchSchedule_Column_LastRunDate goquery.Column = "LastRunDate" TaskBatchSchedule_Column_LastSuccessDate goquery.Column = "LastSuccessDate" TaskBatchSchedule_Column_LastErrorDate goquery.Column = "LastErrorDate" TaskBatchSchedule_Column_NumFailed goquery.Column = "NumFailed" TaskBatchSchedule_Column_NumFinished goquery.Column = "NumFinished" TaskBatchSchedule_Column_NumAttempted goquery.Column = "NumAttempted" )
Variables ¶
var ( // FiscalYear_Columns is a list of all the columns FiscalYear_Columns = []goquery.Column{ FiscalYear_Column_FiscalYearID, FiscalYear_Column_FiscalYearKey, FiscalYear_Column_Year, FiscalYear_Column_DateFrom, FiscalYear_Column_DateTo, FiscalYear_Column_DateCreated, FiscalYear_Column_IsDeleted, FiscalYear_Column_TotalFiscalDays, FiscalYear_Column_IsLocked} // FiscalYear_Column_Types maps columns to their string types FiscalYear_Column_Types = map[goquery.Column]string{ FiscalYear_Column_FiscalYearID: "%d", FiscalYear_Column_FiscalYearKey: "%d", FiscalYear_Column_Year: "%d", FiscalYear_Column_DateFrom: "%d", FiscalYear_Column_DateTo: "%d", FiscalYear_Column_DateCreated: "%d", FiscalYear_Column_IsDeleted: "%d", FiscalYear_Column_TotalFiscalDays: "%d", FiscalYear_Column_IsLocked: "%d"} // FiscalYear_UpdateColumns is a list of all update columns for this model FiscalYear_UpdateColumns = []goquery.Column{FiscalYear_Column_FiscalYearKey, FiscalYear_Column_Year, FiscalYear_Column_DateFrom, FiscalYear_Column_DateTo, FiscalYear_Column_IsDeleted, FiscalYear_Column_TotalFiscalDays, FiscalYear_Column_IsLocked} // FiscalYear_InsertColumns is a list of all insert columns for this model FiscalYear_InsertColumns = []goquery.Column{FiscalYear_Column_FiscalYearKey, FiscalYear_Column_Year, FiscalYear_Column_DateFrom, FiscalYear_Column_DateTo, FiscalYear_Column_DateCreated, FiscalYear_Column_TotalFiscalDays, FiscalYear_Column_IsLocked} // FiscalYear_PrimaryKey is the name of the table's primary key FiscalYear_PrimaryKey goquery.Column = "FiscalYearID" )
var ( // TaskBatchSchedule_Columns is a list of all the columns TaskBatchSchedule_Columns = []goquery.Column{ TaskBatchSchedule_Column_TaskBatchScheduleID, TaskBatchSchedule_Column_TaskBatchID, TaskBatchSchedule_Column_DOM, TaskBatchSchedule_Column_DOW, TaskBatchSchedule_Column_HOD, TaskBatchSchedule_Column_MOH, TaskBatchSchedule_Column_DateCreated, TaskBatchSchedule_Column_IsDeleted, TaskBatchSchedule_Column_IsActive, TaskBatchSchedule_Column_CurrentStatus, TaskBatchSchedule_Column_LastRunDate, TaskBatchSchedule_Column_LastSuccessDate, TaskBatchSchedule_Column_LastErrorDate, TaskBatchSchedule_Column_NumFailed, TaskBatchSchedule_Column_NumFinished, TaskBatchSchedule_Column_NumAttempted} // TaskBatchSchedule_Column_Types maps columns to their string types TaskBatchSchedule_Column_Types = map[goquery.Column]string{ TaskBatchSchedule_Column_TaskBatchScheduleID: "%d", TaskBatchSchedule_Column_TaskBatchID: "%d", TaskBatchSchedule_Column_DOM: "%d", TaskBatchSchedule_Column_DOW: "%d", TaskBatchSchedule_Column_HOD: "%d", TaskBatchSchedule_Column_MOH: "%d", TaskBatchSchedule_Column_DateCreated: "%d", TaskBatchSchedule_Column_IsDeleted: "%d", TaskBatchSchedule_Column_IsActive: "%d", TaskBatchSchedule_Column_CurrentStatus: "%d", TaskBatchSchedule_Column_LastRunDate: "%d", TaskBatchSchedule_Column_LastSuccessDate: "%d", TaskBatchSchedule_Column_LastErrorDate: "%d", TaskBatchSchedule_Column_NumFailed: "%d", TaskBatchSchedule_Column_NumFinished: "%d", TaskBatchSchedule_Column_NumAttempted: "%d"} // TaskBatchSchedule_UpdateColumns is a list of all update columns for this model TaskBatchSchedule_UpdateColumns = []goquery.Column{TaskBatchSchedule_Column_TaskBatchID, TaskBatchSchedule_Column_DOM, TaskBatchSchedule_Column_DOW, TaskBatchSchedule_Column_HOD, TaskBatchSchedule_Column_MOH, TaskBatchSchedule_Column_IsDeleted, TaskBatchSchedule_Column_IsActive, TaskBatchSchedule_Column_CurrentStatus, TaskBatchSchedule_Column_LastRunDate, TaskBatchSchedule_Column_LastSuccessDate, TaskBatchSchedule_Column_LastErrorDate, TaskBatchSchedule_Column_NumFailed, TaskBatchSchedule_Column_NumFinished, TaskBatchSchedule_Column_NumAttempted} // TaskBatchSchedule_InsertColumns is a list of all insert columns for this model TaskBatchSchedule_InsertColumns = []goquery.Column{TaskBatchSchedule_Column_TaskBatchID, TaskBatchSchedule_Column_DOM, TaskBatchSchedule_Column_DOW, TaskBatchSchedule_Column_HOD, TaskBatchSchedule_Column_MOH, TaskBatchSchedule_Column_DateCreated, TaskBatchSchedule_Column_IsActive, TaskBatchSchedule_Column_CurrentStatus, TaskBatchSchedule_Column_LastRunDate, TaskBatchSchedule_Column_LastSuccessDate, TaskBatchSchedule_Column_LastErrorDate, TaskBatchSchedule_Column_NumFailed, TaskBatchSchedule_Column_NumFinished, TaskBatchSchedule_Column_NumAttempted} // TaskBatchSchedule_PrimaryKey is the name of the table's primary key TaskBatchSchedule_PrimaryKey goquery.Column = "TaskBatchScheduleID" )
Functions ¶
Types ¶
type Comment ¶
type Comment struct {
CommentID int64 `db:"CommentID" json:"CommentID"`
DateCreated int64 `db:"DateCreated" json:"DateCreated"`
IsDeleted int `db:"IsDeleted" json:"IsDeleted"`
Content null.String `db:"Content" json:"Content"`
ObjectType int64 `db:"ObjectType" json:"ObjectType"`
ObjectID int64 `db:"ObjectID" json:"ObjectID"`
Name string `db:"Name" json:"Name"`
}
Comment is a `Comment` data model
func (*Comment) FromID ¶
func (c *Comment) FromID(db query.DBInterface, id int64) (query.ModelInterface, error)
func (*Comment) Table_Column_Values ¶
func (*Comment) Table_Columns ¶
func (*Comment) Table_InsertColumns ¶
Comment_InsertColumns is a list of all insert columns for this model
func (*Comment) Table_Name ¶
Comment_TableName is the name of the table
func (*Comment) Table_PrimaryKey ¶
Comment_PrimaryKey is the name of the table's primary key
func (*Comment) Table_PrimaryKey_Value ¶
func (*Comment) Table_UpdateColumns ¶
Comment_UpdateColumns is a list of all update columns for this model
type FiscalYear ¶
type FiscalYear struct {
FiscalYearID int64 `db:"FiscalYearID" json:"FiscalYearID"`
FiscalYearKey int64 `db:"FiscalYearKey" json:"FiscalYearKey"`
Year int64 `db:"Year" json:"Year"`
DateFrom int64 `db:"DateFrom" json:"DateFrom"`
DateTo int64 `db:"DateTo" json:"DateTo"`
DateCreated int64 `db:"DateCreated" json:"DateCreated"`
IsDeleted int `db:"IsDeleted" json:"IsDeleted"`
TotalFiscalDays int64 `db:"TotalFiscalDays" json:"TotalFiscalDays"`
IsLocked int64 `db:"IsLocked" json:"IsLocked"`
}
FiscalYear is a `FiscalYear` data model
func (*FiscalYear) Count ¶
func (r *FiscalYear) Count(db goquery.DBInterface) *FiscalYearDALCounter
func (*FiscalYear) Create ¶
func (c *FiscalYear) Create(db goquery.DBInterface) error
Create inserts a FiscalYear record
func (*FiscalYear) Delete ¶
func (c *FiscalYear) Delete(db goquery.DBInterface) error
Destroy deletes a FiscalYear record
func (*FiscalYear) FromID ¶
func (c *FiscalYear) FromID(db goquery.DBInterface, id int64) (goquery.ModelInterface, error)
FromID returns a FromID query statement
func (*FiscalYear) Get ¶
func (r *FiscalYear) Get(db goquery.DBInterface) *FiscalYearDALGetter
func (*FiscalYear) Raw ¶
func (r *FiscalYear) Raw(db goquery.DBInterface, queryRaw string) ([]*FiscalYear, error)
func (*FiscalYear) Select ¶
func (r *FiscalYear) Select(db goquery.DBInterface) *FiscalYearDALSelector
func (*FiscalYear) String ¶
func (c *FiscalYear) String() string
String returns a json marshalled string of the object
func (*FiscalYear) Sum ¶
func (r *FiscalYear) Sum(db goquery.DBInterface, col goquery.Column) *FiscalYearDALSummer
func (*FiscalYear) Table_Column_Types ¶
func (c *FiscalYear) Table_Column_Types() map[goquery.Column]string
Table_ColumnTypes returns a map of tableColumn names with their fmt string types
func (*FiscalYear) Table_Columns ¶
func (c *FiscalYear) Table_Columns() []goquery.Column
func (*FiscalYear) Table_InsertColumns ¶
func (c *FiscalYear) Table_InsertColumns() []goquery.Column
Table_InsertColumns is a list of all insert columns for this model
func (*FiscalYear) Table_Name ¶
func (c *FiscalYear) Table_Name() goquery.TableName
FiscalYear_TableName is the name of the table
func (*FiscalYear) Table_PrimaryKey ¶
func (c *FiscalYear) Table_PrimaryKey() goquery.Column
Table_PrimaryKey returns the name of this table's primary key
func (*FiscalYear) Table_PrimaryKey_Value ¶
func (c *FiscalYear) Table_PrimaryKey_Value() int64
Table_PrimaryKey_Value returns the value of this table's primary key
func (*FiscalYear) Table_SchemaName ¶
func (c *FiscalYear) Table_SchemaName() string
FiscalYear_SchemaName is the name of this table's schema
func (*FiscalYear) Table_UpdateColumns ¶
func (c *FiscalYear) Table_UpdateColumns() []goquery.Column
Table_UpdateColumns is a list of all update columns for this model
func (*FiscalYear) Update ¶
func (c *FiscalYear) Update(db goquery.DBInterface) error
Update updates a FiscalYear record
type FiscalYearDALCounter ¶
type FiscalYearDALCounter struct {
// contains filtered or unexported fields
}
Counter
func (*FiscalYearDALCounter) Alias ¶
func (r *FiscalYearDALCounter) Alias(alias string) *FiscalYearDALCounter
func (*FiscalYearDALCounter) Run ¶
func (ds *FiscalYearDALCounter) Run() (int64, error)
func (*FiscalYearDALCounter) Where ¶
func (ds *FiscalYearDALCounter) Where(whereParts ...*goquery.WherePart) *FiscalYearDALCounter
type FiscalYearDALGetter ¶
type FiscalYearDALGetter struct {
// contains filtered or unexported fields
}
func (*FiscalYearDALGetter) Alias ¶
func (r *FiscalYearDALGetter) Alias(alias string) *FiscalYearDALGetter
func (*FiscalYearDALGetter) OrderBy ¶
func (ds *FiscalYearDALGetter) OrderBy(col goquery.Column, dir goquery.OrderDir) *FiscalYearDALGetter
func (*FiscalYearDALGetter) Run ¶
func (ds *FiscalYearDALGetter) Run() (*FiscalYear, error)
func (*FiscalYearDALGetter) Where ¶
func (ds *FiscalYearDALGetter) Where(whereParts ...*goquery.WherePart) *FiscalYearDALGetter
type FiscalYearDALSelector ¶
type FiscalYearDALSelector struct {
// contains filtered or unexported fields
}
func (*FiscalYearDALSelector) Alias ¶
func (r *FiscalYearDALSelector) Alias(alias string) *FiscalYearDALSelector
func (*FiscalYearDALSelector) Count ¶
func (r *FiscalYearDALSelector) Count(fieldName goquery.Column, fieldAlias string) *FiscalYearDALSelector
func (*FiscalYearDALSelector) Limit ¶
func (r *FiscalYearDALSelector) Limit(limit, offset int64) *FiscalYearDALSelector
func (*FiscalYearDALSelector) OrderBy ¶
func (r *FiscalYearDALSelector) OrderBy(col goquery.Column, dir goquery.OrderDir) *FiscalYearDALSelector
func (*FiscalYearDALSelector) Run ¶
func (r *FiscalYearDALSelector) Run() ([]*FiscalYear, error)
func (*FiscalYearDALSelector) Sum ¶
func (r *FiscalYearDALSelector) Sum(fieldName goquery.Column, fieldAlias string) *FiscalYearDALSelector
func (*FiscalYearDALSelector) Where ¶
func (r *FiscalYearDALSelector) Where(whereParts ...*goquery.WherePart) *FiscalYearDALSelector
type FiscalYearDALSummer ¶
type FiscalYearDALSummer struct {
// contains filtered or unexported fields
}
Summer
func (*FiscalYearDALSummer) Run ¶
func (ds *FiscalYearDALSummer) Run() (float64, error)
func (*FiscalYearDALSummer) Where ¶
func (ds *FiscalYearDALSummer) Where(whereParts ...*goquery.WherePart) *FiscalYearDALSummer
type Job ¶
type Job struct {
JobID int64 `db:"JobID" json:"JobID"`
DateCreated int64 `db:"DateCreated" json:"DateCreated"`
LastUpdated int64 `db:"LastUpdated" json:"LastUpdated"`
IsDeleted int `db:"IsDeleted" json:"IsDeleted"`
QuoteNumberID int64 `db:"QuoteNumberID" json:"QuoteNumberID"`
CustomerID int64 `db:"CustomerID" json:"CustomerID"`
AwardDate int64 `db:"AwardDate" json:"AwardDate"`
AwardDateString string `db:"AwardDateString" json:"AwardDateString"`
QuoteID int64 `db:"QuoteID" json:"QuoteID"`
Description string `db:"Description" json:"Description"`
CustomerContactID int64 `db:"CustomerContactID" json:"CustomerContactID"`
Notes null.String `db:"Notes" json:"Notes"`
CustomerPO2SentTo int64 `db:"CustomerPO2SentTo" json:"CustomerPO2SentTo"`
ThirdPartyName string `db:"ThirdPartyName" json:"ThirdPartyName"`
CustomerPO2Number string `db:"CustomerPO2Number" json:"CustomerPO2Number"`
BillingAddressZip string `db:"BillingAddressZip" json:"BillingAddressZip"`
BillingAddress string `db:"BillingAddress" json:"BillingAddress"`
BillingAddressState string `db:"BillingAddressState" json:"BillingAddressState"`
CustomerPO1SentTo int64 `db:"CustomerPO1SentTo" json:"CustomerPO1SentTo"`
ProjectCost float64 `db:"ProjectCost" json:"ProjectCost"`
CustomerPO1Number string `db:"CustomerPO1Number" json:"CustomerPO1Number"`
ThirdPartySplitPercent float64 `db:"ThirdPartySplitPercent" json:"ThirdPartySplitPercent"`
CommissionTypeID int64 `db:"CommissionTypeID" json:"CommissionTypeID"`
GrossMarginPercent float64 `db:"GrossMarginPercent" json:"GrossMarginPercent"`
TotalPrice float64 `db:"TotalPrice" json:"TotalPrice"`
IsThirdPartySplit int `db:"IsThirdPartySplit" json:"IsThirdPartySplit"`
GrossProfit float64 `db:"GrossProfit" json:"GrossProfit"`
BillingAddressCity string `db:"BillingAddressCity" json:"BillingAddressCity"`
RemainingGrossProfit float64 `db:"RemainingGrossProfit" json:"RemainingGrossProfit"`
IsAddFreight int `db:"IsAddFreight" json:"IsAddFreight"`
JobNumberString string `db:"JobNumberString" json:"JobNumberString"`
ThirdPartyCommission float64 `db:"ThirdPartyCommission" json:"ThirdPartyCommission"`
ShippingAddressZip string `db:"ShippingAddressZip" json:"ShippingAddressZip"`
ShippingAddress string `db:"ShippingAddress" json:"ShippingAddress"`
ShippingAddressCity string `db:"ShippingAddressCity" json:"ShippingAddressCity"`
ShippingAddressState string `db:"ShippingAddressState" json:"ShippingAddressState"`
Sales1 string `db:"Sales1" json:"Sales1"`
BidTypeID int64 `db:"BidTypeID" json:"BidTypeID"`
Vendor1ID int64 `db:"Vendor1ID" json:"Vendor1ID"`
MarketID int64 `db:"MarketID" json:"MarketID"`
Vendor2ID int64 `db:"Vendor2ID" json:"Vendor2ID"`
Sales2 string `db:"Sales2" json:"Sales2"`
JEFDate int64 `db:"JEFDate" json:"JEFDate"`
JEFDateString string `db:"JEFDateString" json:"JEFDateString"`
}
Job is a `Job` data model
func (*Job) FromID ¶
func (c *Job) FromID(db goquery.DBInterface, id int64) (goquery.ModelInterface, error)
func (*Job) Table_Column_Values ¶
func (*Job) Table_Columns ¶
func (*Job) Table_InsertColumns ¶
Comment_InsertColumns is a list of all insert columns for this model TODO
func (*Job) Table_Name ¶
Comment_TableName is the name of the table
func (*Job) Table_PrimaryKey ¶
Comment_PrimaryKey is the name of the table's primary key
func (*Job) Table_PrimaryKey_Value ¶
func (*Job) Table_UpdateColumns ¶
Comment_UpdateColumns is a list of all update columns for this model TODO
type JobSales ¶
type JobSales struct {
JobSalesID int64 `db:"JobSalesID" json:"JobSalesID"`
JobID int64 `db:"JobID" json:"JobID"`
UserID int64 `db:"UserID" json:"UserID"`
CommissionPercent float64 `db:"CommissionPercent" json:"CommissionPercent"`
DateCreated int64 `db:"DateCreated" json:"DateCreated"`
IsDeleted int `db:"IsDeleted" json:"IsDeleted"`
CommissionDollars float64 `db:"CommissionDollars" json:"CommissionDollars"`
IsHouse int `db:"IsHouse" json:"IsHouse"`
}
JobSales is a `JobSales` data model
func (*JobSales) FromID ¶
func (c *JobSales) FromID(db goquery.DBInterface, id int64) (goquery.ModelInterface, error)
func (*JobSales) Table_Column_Types ¶
func (*JobSales) Table_Column_Values ¶
func (*JobSales) Table_Columns ¶
func (*JobSales) Table_InsertColumns ¶
Comment_InsertColumns is a list of all insert columns for this model
func (*JobSales) Table_Name ¶
Comment_TableName is the name of the table
func (*JobSales) Table_PrimaryKey ¶
Comment_PrimaryKey is the name of the table's primary key
func (*JobSales) Table_PrimaryKey_Value ¶
func (*JobSales) Table_UpdateColumns ¶
Comment_UpdateColumns is a list of all update columns for this model
type MockDB ¶
type MockDB struct {
}
MockDB is a mock implementation of the IDB interface for testing purposes
type TaskBatchSchedule ¶
type TaskBatchSchedule struct {
TaskBatchScheduleID int64 `db:"TaskBatchScheduleID" json:"TaskBatchScheduleID"`
TaskBatchID int64 `db:"TaskBatchID" json:"TaskBatchID"`
DOM int64 `db:"DOM" json:"DOM"`
DOW int64 `db:"DOW" json:"DOW"`
HOD int64 `db:"HOD" json:"HOD"`
MOH int64 `db:"MOH" json:"MOH"`
DateCreated int64 `db:"DateCreated" json:"DateCreated"`
IsDeleted int `db:"IsDeleted" json:"IsDeleted"`
IsActive int `db:"IsActive" json:"IsActive"`
CurrentStatus int `db:"CurrentStatus" json:"CurrentStatus"`
LastRunDate int64 `db:"LastRunDate" json:"LastRunDate"`
LastSuccessDate int64 `db:"LastSuccessDate" json:"LastSuccessDate"`
LastErrorDate int64 `db:"LastErrorDate" json:"LastErrorDate"`
NumFailed int64 `db:"NumFailed" json:"NumFailed"`
NumFinished int64 `db:"NumFinished" json:"NumFinished"`
NumAttempted int64 `db:"NumAttempted" json:"NumAttempted"`
}
TaskBatchSchedule is a `TaskBatchSchedule` data model
func (*TaskBatchSchedule) Create ¶
func (c *TaskBatchSchedule) Create(db goquery.DBInterface) error
func (*TaskBatchSchedule) Delete ¶
func (c *TaskBatchSchedule) Delete(db goquery.DBInterface) error
func (*TaskBatchSchedule) FromID ¶
func (c *TaskBatchSchedule) FromID(db goquery.DBInterface, id int64) (goquery.ModelInterface, error)
func (*TaskBatchSchedule) String ¶
func (c *TaskBatchSchedule) String() string
String returns a json marshalled string of the object
func (*TaskBatchSchedule) Table_Column_Types ¶
func (c *TaskBatchSchedule) Table_Column_Types() map[goquery.Column]string
Table_ColumnTypes returns a map of tableColumn names with their fmt string types
func (*TaskBatchSchedule) Table_Columns ¶
func (c *TaskBatchSchedule) Table_Columns() []goquery.Column
func (*TaskBatchSchedule) Table_InsertColumns ¶
func (c *TaskBatchSchedule) Table_InsertColumns() []goquery.Column
Table_InsertColumns is a list of all insert columns for this model
func (*TaskBatchSchedule) Table_Name ¶
func (c *TaskBatchSchedule) Table_Name() goquery.TableName
TaskBatchSchedule_TableName is the name of the table
func (*TaskBatchSchedule) Table_PrimaryKey ¶
func (c *TaskBatchSchedule) Table_PrimaryKey() goquery.Column
Table_PrimaryKey returns the name of this table's primary key
func (*TaskBatchSchedule) Table_PrimaryKey_Value ¶
func (c *TaskBatchSchedule) Table_PrimaryKey_Value() int64
Table_PrimaryKey_Value returns the value of this table's primary key
func (*TaskBatchSchedule) Table_SchemaName ¶
func (c *TaskBatchSchedule) Table_SchemaName() string
TaskBatchSchedule_SchemaName is the name of this table's schema
func (*TaskBatchSchedule) Table_UpdateColumns ¶
func (c *TaskBatchSchedule) Table_UpdateColumns() []goquery.Column
Table_UpdateColumns is a list of all update columns for this model
func (*TaskBatchSchedule) Update ¶
func (c *TaskBatchSchedule) Update(db goquery.DBInterface) error