model

package
v0.9.3 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Feb 13, 2020 License: MIT Imports: 13 Imported by: 0

Documentation

Index

Constants

View Source 
const (
	AddressIDDefault       = ""
	AddressPersonIDDefault = ""
	AddressStreetDefault   = ""
	AddressCityDefault     = ""
)
View Source 
const (
	Address_ID       = `ID`
	Address_PersonID = `PersonID`
	Address_Person   = `Person`
	Address_Street   = `Street`
	Address_City     = `City`
)
View Source 
const (
	EmployeeInfoIDDefault             = ""
	EmployeeInfoPersonIDDefault       = ""
	EmployeeInfoEmployeeNumberDefault = 0
)
View Source 
const (
	EmployeeInfo_ID             = `ID`
	EmployeeInfo_PersonID       = `PersonID`
	EmployeeInfo_Person         = `Person`
	EmployeeInfo_EmployeeNumber = `EmployeeNumber`
)
View Source 
const (
	LoginIDDefault        = ""
	LoginPersonIDDefault  = ""
	LoginUsernameDefault  = ""
	LoginPasswordDefault  = ""
	LoginIsEnabledDefault = true
)
View Source 
const (
	Login_ID        = `ID`
	Login_PersonID  = `PersonID`
	Login_Person    = `Person`
	Login_Username  = `Username`
	Login_Password  = `Password`
	Login_IsEnabled = `IsEnabled`
)
View Source 
const (
	MilestoneIDDefault        = ""
	MilestoneProjectIDDefault = ""
	MilestoneNameDefault      = ""
)
View Source 
const (
	Milestone_ID        = `ID`
	Milestone_ProjectID = `ProjectID`
	Milestone_Project   = `Project`
	Milestone_Name      = `Name`
)
View Source 
const (
	PersonIDDefault        = ""
	PersonFirstNameDefault = ""
	PersonLastNameDefault  = ""
)
View Source 
const (
	Person_ID        = `ID`
	Person_FirstName = `FirstName`
	Person_LastName  = `LastName`
	PersonAddresses  = `Addresses`

	PersonEmployeeInfo = `EmployeeInfo`

	PersonLogin                = `Login`
	PersonProjectsAsManager    = `ProjectsAsManager`
	PersonPersonType           = `PersonType`
	PersonPersonTypes          = `PersonTypes`
	PersonProjectAsTeamMember  = `ProjectAsTeamMember`
	PersonProjectsAsTeamMember = `ProjectsAsTeamMember`
)
View Source 
const (
	PersonWithLockIDDefault           = ""
	PersonWithLockFirstNameDefault    = ""
	PersonWithLockLastNameDefault     = ""
	PersonWithLockSysTimestampDefault = datetime.Zero
)
View Source 
const (
	PersonWithLock_ID           = `ID`
	PersonWithLock_FirstName    = `FirstName`
	PersonWithLock_LastName     = `LastName`
	PersonWithLock_SysTimestamp = `SysTimestamp`
)
View Source 
const (
	ProjectIDDefault                  = ""
	ProjectNumDefault                 = 0
	ProjectProjectStatusTypeIDDefault = 0
	ProjectManagerIDDefault           = ""
	ProjectNameDefault                = ""
	ProjectDescriptionDefault         = ""
	ProjectStartDateDefault           = datetime.Zero
	ProjectEndDateDefault             = datetime.Zero
	ProjectBudgetDefault              = ""
	ProjectSpentDefault               = ""
)
View Source 
const (
	Project_ID                  = `ID`
	Project_Num                 = `Num`
	Project_ProjectStatusTypeID = `ProjectStatusTypeID`
	Project_ManagerID           = `ManagerID`
	Project_Manager             = `Manager`
	Project_Name                = `Name`
	Project_Description         = `Description`
	Project_StartDate           = `StartDate`
	Project_EndDate             = `EndDate`
	Project_Budget              = `Budget`
	Project_Spent               = `Spent`
	ProjectMilestones           = `Milestones`
	ProjectChildAsParent        = `ChildAsParent`
	ProjectChildrenAsParent     = `ChildrenAsParent`
	ProjectParentAsChild        = `ParentAsChild`
	ProjectParentsAsChild       = `ParentsAsChild`
	ProjectTeamMember           = `TeamMember`
	ProjectTeamMembers          = `TeamMembers`
)
View Source 
const PersonTypeMaxValue = 5
View Source 
const ProjectStatusTypeMaxValue = 4

Variables

This section is empty.

Functions

func AllPersonTypesI added in v0.9.0 

func AllPersonTypesI() (values []interface{})

AllPersonTypesI returns a slice of interfaces that contains all the PersonType items

func AllProjectStatusTypesI added in v0.9.0 

func AllProjectStatusTypesI() (values []interface{})

AllProjectStatusTypesI returns a slice of interfaces that contains all the ProjectStatusType items

func CountAddressByCity 

func CountAddressByCity(ctx context.Context, city string) uint

func CountAddressByID 

func CountAddressByID(ctx context.Context, id string) uint

func CountAddressByPersonID 

func CountAddressByPersonID(ctx context.Context, personID string) uint

func CountAddressByStreet 

func CountAddressByStreet(ctx context.Context, street string) uint

func CountEmployeeInfoByEmployeeNumber added in v0.7.0 

func CountEmployeeInfoByEmployeeNumber(ctx context.Context, employeeNumber int) uint

func CountEmployeeInfoByID added in v0.7.0 

func CountEmployeeInfoByID(ctx context.Context, id string) uint

func CountEmployeeInfoByPersonID added in v0.7.0 

func CountEmployeeInfoByPersonID(ctx context.Context, personID string) uint

func CountLoginByID 

func CountLoginByID(ctx context.Context, id string) uint

func CountLoginByIsEnabled 

func CountLoginByIsEnabled(ctx context.Context, isEnabled bool) uint

func CountLoginByPassword 

func CountLoginByPassword(ctx context.Context, password string) uint

func CountLoginByPersonID 

func CountLoginByPersonID(ctx context.Context, personID string) uint

func CountLoginByUsername 

func CountLoginByUsername(ctx context.Context, username string) uint

func CountMilestoneByID 

func CountMilestoneByID(ctx context.Context, id string) uint

func CountMilestoneByName 

func CountMilestoneByName(ctx context.Context, name string) uint

func CountMilestoneByProjectID 

func CountMilestoneByProjectID(ctx context.Context, projectID string) uint

func CountPersonByFirstName 

func CountPersonByFirstName(ctx context.Context, firstName string) uint

func CountPersonByID 

func CountPersonByID(ctx context.Context, id string) uint

func CountPersonByLastName 

func CountPersonByLastName(ctx context.Context, lastName string) uint

func CountPersonWithLockByFirstName 

func CountPersonWithLockByFirstName(ctx context.Context, firstName string) uint

func CountPersonWithLockByID 

func CountPersonWithLockByID(ctx context.Context, id string) uint

func CountPersonWithLockByLastName 

func CountPersonWithLockByLastName(ctx context.Context, lastName string) uint

func CountPersonWithLockBySysTimestamp 

func CountPersonWithLockBySysTimestamp(ctx context.Context, sysTimestamp datetime.DateTime) uint

func CountProjectByBudget 

func CountProjectByBudget(ctx context.Context, budget string) uint

func CountProjectByDescription 

func CountProjectByDescription(ctx context.Context, description string) uint

func CountProjectByEndDate 

func CountProjectByEndDate(ctx context.Context, endDate datetime.DateTime) uint

func CountProjectByID 

func CountProjectByID(ctx context.Context, id string) uint

func CountProjectByManagerID 

func CountProjectByManagerID(ctx context.Context, managerID string) uint

func CountProjectByName 

func CountProjectByName(ctx context.Context, name string) uint

func CountProjectByNum 

func CountProjectByNum(ctx context.Context, num int) uint

func CountProjectByProjectStatusTypeID 

func CountProjectByProjectStatusTypeID(ctx context.Context, projectStatusTypeID uint) uint

func CountProjectBySpent 

func CountProjectBySpent(ctx context.Context, spent string) uint

func CountProjectByStartDate 

func CountProjectByStartDate(ctx context.Context, startDate datetime.DateTime) uint

func Database added in v0.9.0 

func Database() db.DatabaseI

func DeleteAddress 

func DeleteAddress(ctx context.Context, pk string)

DeleteAddress deletes the given record from the database. Note that you can also delete loaded Address objects by calling Delete on them.

func DeleteEmployeeInfo added in v0.7.0 

func DeleteEmployeeInfo(ctx context.Context, pk string)

DeleteEmployeeInfo deletes the given record from the database. Note that you can also delete loaded EmployeeInfo objects by calling Delete on them.

func DeleteLogin 

func DeleteLogin(ctx context.Context, pk string)

DeleteLogin deletes the given record from the database. Note that you can also delete loaded Login objects by calling Delete on them.

func DeleteMilestone 

func DeleteMilestone(ctx context.Context, pk string)

DeleteMilestone deletes the given record from the database. Note that you can also delete loaded Milestone objects by calling Delete on them.

func DeletePerson 

func DeletePerson(ctx context.Context, pk string)

DeletePerson deletes the given record from the database. Note that you can also delete loaded Person objects by calling Delete on them.

func DeletePersonWithLock 

func DeletePersonWithLock(ctx context.Context, pk string)

DeletePersonWithLock deletes the given record from the database. Note that you can also delete loaded PersonWithLock objects by calling Delete on them.

func DeleteProject 

func DeleteProject(ctx context.Context, pk string)

DeleteProject deletes the given record from the database. Note that you can also delete loaded Project objects by calling Delete on them.

func HasEmployeeInfoByPersonID added in v0.9.3 

func HasEmployeeInfoByPersonID(ctx context.Context, person_id string) bool

HasEmployeeInfoByPersonID returns true if the given unique index values exist in the database.

func HasLoginByPersonID added in v0.9.3 

func HasLoginByPersonID(ctx context.Context, person_id string) bool

HasLoginByPersonID returns true if the given unique index values exist in the database.

func HasLoginByUsername added in v0.9.3 

func HasLoginByUsername(ctx context.Context, username string) bool

HasLoginByUsername returns true if the given unique index values exist in the database.

func HasProjectByNum added in v0.9.3 

func HasProjectByNum(ctx context.Context, num int) bool

HasProjectByNum returns true if the given unique index values exist in the database.

func PersonTypeNames 

func PersonTypeNames() []string

func ProjectStatusTypeDescriptions 

func ProjectStatusTypeDescriptions() []string

func ProjectStatusTypeGuidelines 

func ProjectStatusTypeGuidelines() []string

func ProjectStatusTypeIsActives 

func ProjectStatusTypeIsActives() []bool

func ProjectStatusTypeNames 

func ProjectStatusTypeNames() []string

Types

type Address 

type Address struct {
	// contains filtered or unexported fields
}

func LoadAddress 

func LoadAddress(ctx context.Context, primaryKey string, joinOrSelectNodes ...query.NodeI) *Address

Load returns a Address from the database. joinOrSelectNodes lets you provide nodes for joining to other tables or selecting specific fields. Table nodes will be considered Join nodes, and column nodes will be Select nodes. See Join() and Select() for more info.

func NewAddress 

func NewAddress() *Address

Create a new Address object and initialize to default values.

func (*Address) City 

func (o *Address) City() string

func (*Address) CityIsNull 

func (o *Address) CityIsNull() bool

CityIsNull returns true if the related database value is null.

func (*Address) CityIsValid 

func (o *Address) CityIsValid() bool

CityIsValid returns true if the value was loaded from the database or has been set.

func (*Address) Delete 

func (o *Address) Delete(ctx context.Context)

Delete deletes the associated record from the database.

func (*Address) Get 

func (o *Address) Get(key string) interface{}

Get returns the value of a field in the object based on the field's name. It will also get related objects if they are loaded. Invalid fields and objects are returned as nil

func (*Address) GetAlias 

func (o *Address) GetAlias(key string) query.AliasValue

GetAlias returns the alias for the given key.

func (*Address) ID 

func (o *Address) ID() string

ID returns the loaded value of ID.

func (*Address) IDIsValid 

func (o *Address) IDIsValid() bool

IDIsValid returns true if the value was loaded from the database or has been set.

func (*Address) Initialize 

func (o *Address) Initialize()

Initialize or re-initialize a Address database object to default values.

func (*Address) IsDirty 

func (o *Address) IsDirty() bool

func (*Address) LoadPerson 

func (o *Address) LoadPerson(ctx context.Context) *Person

LoadPerson returns the related Person. If it is not already loaded, it will attempt to load it first.

func (*Address) MarshalBinary 

func (o *Address) MarshalBinary() ([]byte, error)

MarshalBinary serializes the object into a buffer that is deserializable using UnmarshalBinary. It should be used for transmitting database objects over the wire, or for temporary storage. It does not send a version number, so if the data format changes, its up to you to invalidate the old stored objects. The framework uses this to serialize the object when it is stored in a control.

func (*Address) MarshalJSON 

func (o *Address) MarshalJSON() (data []byte, err error)

MarshalJSON serializes the object into a JSON object. Only valid data will be serialized, meaning, you can control what gets serialized by using Select to select only the fields you want when you query for the object.

func (*Address) Person 

func (o *Address) Person() *Person

Person returns the current value of the loaded Person, and nil if its not loaded.

func (*Address) PersonID 

func (o *Address) PersonID() string

func (*Address) PersonIDIsValid 

func (o *Address) PersonIDIsValid() bool

PersonIDIsValid returns true if the value was loaded from the database or has been set.

func (*Address) PrimaryKey 

func (o *Address) PrimaryKey() string

func (*Address) Save 

func (o *Address) Save(ctx context.Context)

Save will update or insert the object, depending on the state of the object. If it has any auto-generated ids, those will be updated.

func (*Address) SetCity 

func (o *Address) SetCity(i interface{})

func (*Address) SetPerson 

func (o *Address) SetPerson(v *Person)

SetPerson sets the value of Person in the object, to be saved later using the Save() function.

func (*Address) SetPersonID 

func (o *Address) SetPersonID(v string)

SetPersonID sets the value of PersonID in the object, to be saved later using the Save() function.

func (*Address) SetStreet 

func (o *Address) SetStreet(v string)

SetStreet sets the value of Street in the object, to be saved later using the Save() function.

func (*Address) Street 

func (o *Address) Street() string

func (*Address) StreetIsValid 

func (o *Address) StreetIsValid() bool

StreetIsValid returns true if the value was loaded from the database or has been set.

func (*Address) String 

func (o *Address) String() string

String implements the Stringer interface and returns the default label for the object as it appears in html lists. Typically you would change this to whatever was pertinent to your application.

func (*Address) UnmarshalBinary 

func (o *Address) UnmarshalBinary(data []byte) (err error)

type AddressesBuilder 

type AddressesBuilder struct {
	// contains filtered or unexported fields
}

The AddressesBuilder uses the QueryBuilderI interface from the database to build a query. All query operations go through this query builder. End a query by calling either Load, Count, or Delete

func QueryAddresses 

func QueryAddresses(ctx context.Context) *AddressesBuilder

QueryAddresses returns a new builder that gives you general purpose access to the Address records in the database. Its here to give public access to the query builder, but you can remove it if you do not need it.

func (*AddressesBuilder) Alias 

func (b *AddressesBuilder) Alias(name string, n query.NodeI) *AddressesBuilder

Alias lets you add a node with a custom name. After the query, you can read out the data using GetAlias() on a returned object. Alias is useful for adding calculations or subqueries to the query.

func (*AddressesBuilder) Count 

func (b *AddressesBuilder) Count(ctx context.Context, distinct bool, nodes ...query.NodeI) uint

Count terminates a query and returns just the number of items selected.

func (*AddressesBuilder) Delete 

func (b *AddressesBuilder) Delete(ctx context.Context)

Delete uses the query builder to delete a group of records that match the criteria

func (*AddressesBuilder) Distinct 

func (b *AddressesBuilder) Distinct() *AddressesBuilder

Distinct removes duplicates from the results of the query. Adding a Select() may help you get to the data you want, although using Distinct with joined tables is often not effective, since we force joined tables to include primary keys in the query, and this often ruins the effect of Distinct.

func (*AddressesBuilder) Expand 

func (b *AddressesBuilder) Expand(n query.NodeI) *AddressesBuilder

Expand expands an array type node so that it will produce individual rows instead of an array of items

func (*AddressesBuilder) Get 

func (b *AddressesBuilder) Get(ctx context.Context) *Address

Get is a convenience method to return only the first item found in a query. The entire query is performed, so you should generally use this only if you know you are selecting on one or very few items.

func (*AddressesBuilder) GroupBy 

func (b *AddressesBuilder) GroupBy(nodes ...query.NodeI) *AddressesBuilder

GroupBy controls how results are grouped when using aggregate functions in an Alias() call.

func (*AddressesBuilder) Having 

func (b *AddressesBuilder) Having(node query.NodeI) *AddressesBuilder

Having does additional filtering on the results of the query.

func (*AddressesBuilder) Join 

func (b *AddressesBuilder) Join(n query.NodeI, conditions ...query.NodeI) *AddressesBuilder

Join adds a node to the node tree so that its fields will appear in the query. Optionally add conditions to filter what gets included. The conditions will be AND'd with the basic condition matching the primary keys of the join.

func (*AddressesBuilder) Limit 

func (b *AddressesBuilder) Limit(maxRowCount int, offset int) *AddressesBuilder

Limit will return a subset of the data, limited to the offset and number of rows specified

func (*AddressesBuilder) Load 

func (b *AddressesBuilder) Load(ctx context.Context) (addressSlice []*Address)

Load terminates the query builder, performs the query, and returns a slice of Address objects. If there are any errors, they are returned in the context object. If no results come back from the query, it will return an empty slice

func (*AddressesBuilder) LoadI 

func (b *AddressesBuilder) LoadI(ctx context.Context) (addressSlice []interface{})

LoadI terminates the query builder, performs the query, and returns a slice of interfaces. If there are any errors, they are returned in the context object. If no results come back from the query, it will return an empty slice.

func (*AddressesBuilder) OrderBy 

func (b *AddressesBuilder) OrderBy(nodes ...query.NodeI) *AddressesBuilder

OrderBy specifies how the resulting data should be sorted.

func (*AddressesBuilder) Select 

func (b *AddressesBuilder) Select(nodes ...query.NodeI) *AddressesBuilder

Select optimizes the query to only return the specified fields. Once you put a Select in your query, you must specify all the fields that you will eventually read out. Be careful when selecting fields in joined tables, as joined tables will also contain pointers back to the parent table, and so the parent node should have the same field selected as the child node if you are querying those fields.

func (*AddressesBuilder) Subquery 

func (b *AddressesBuilder) Subquery() *query.SubqueryNode

Subquery uses the query builder to define a subquery within a larger query. You MUST include what you are selecting by adding Alias or Select functions on the subquery builder. Generally you would use this as a node to an Alias function on the surrounding query builder.

func (*AddressesBuilder) Where 

func (b *AddressesBuilder) Where(c query.NodeI) *AddressesBuilder

Where adds a condition to filter what gets selected.

type EmployeeInfo added in v0.7.0 

type EmployeeInfo struct {
	// contains filtered or unexported fields
}

func LoadEmployeeInfo added in v0.7.0 

func LoadEmployeeInfo(ctx context.Context, primaryKey string, joinOrSelectNodes ...query.NodeI) *EmployeeInfo

Load returns a EmployeeInfo from the database. joinOrSelectNodes lets you provide nodes for joining to other tables or selecting specific fields. Table nodes will be considered Join nodes, and column nodes will be Select nodes. See Join() and Select() for more info.

func LoadEmployeeInfoByPersonID added in v0.7.0 

func LoadEmployeeInfoByPersonID(ctx context.Context, person_id string, joinOrSelectNodes ...query.NodeI) *EmployeeInfo

LoadEmployeeInfoByPersonID queries for a single EmployeeInfo object by the given unique index values. joinOrSelectNodes lets you provide nodes for joining to other tables or selecting specific fields. Table nodes will be considered Join nodes, and column nodes will be Select nodes. See Join() and Select() for more info. If you need a more elaborate query, use QueryEmployeeInfos() to start a query builder.

func NewEmployeeInfo added in v0.7.0 

func NewEmployeeInfo() *EmployeeInfo

Create a new EmployeeInfo object and initialize to default values.

func (*EmployeeInfo) Delete added in v0.7.0 

func (o *EmployeeInfo) Delete(ctx context.Context)

Delete deletes the associated record from the database.

func (*EmployeeInfo) EmployeeNumber added in v0.7.0 

func (o *EmployeeInfo) EmployeeNumber() int

func (*EmployeeInfo) EmployeeNumberIsValid added in v0.7.0 

func (o *EmployeeInfo) EmployeeNumberIsValid() bool

EmployeeNumberIsValid returns true if the value was loaded from the database or has been set.

func (*EmployeeInfo) Get added in v0.7.0 

func (o *EmployeeInfo) Get(key string) interface{}

Get returns the value of a field in the object based on the field's name. It will also get related objects if they are loaded. Invalid fields and objects are returned as nil

func (*EmployeeInfo) GetAlias added in v0.7.0 

func (o *EmployeeInfo) GetAlias(key string) query.AliasValue

GetAlias returns the alias for the given key.

func (*EmployeeInfo) ID added in v0.7.0 

func (o *EmployeeInfo) ID() string

ID returns the loaded value of ID.

func (*EmployeeInfo) IDIsValid added in v0.7.0 

func (o *EmployeeInfo) IDIsValid() bool

IDIsValid returns true if the value was loaded from the database or has been set.

func (*EmployeeInfo) Initialize added in v0.7.0 

func (o *EmployeeInfo) Initialize()

Initialize or re-initialize a EmployeeInfo database object to default values.

func (*EmployeeInfo) IsDirty added in v0.7.0 

func (o *EmployeeInfo) IsDirty() bool

func (*EmployeeInfo) LoadPerson added in v0.7.0 

func (o *EmployeeInfo) LoadPerson(ctx context.Context) *Person

LoadPerson returns the related Person. If it is not already loaded, it will attempt to load it first.

func (*EmployeeInfo) MarshalBinary added in v0.7.0 

func (o *EmployeeInfo) MarshalBinary() ([]byte, error)

MarshalBinary serializes the object into a buffer that is deserializable using UnmarshalBinary. It should be used for transmitting database objects over the wire, or for temporary storage. It does not send a version number, so if the data format changes, its up to you to invalidate the old stored objects. The framework uses this to serialize the object when it is stored in a control.

func (*EmployeeInfo) MarshalJSON added in v0.7.0 

func (o *EmployeeInfo) MarshalJSON() (data []byte, err error)

MarshalJSON serializes the object into a JSON object. Only valid data will be serialized, meaning, you can control what gets serialized by using Select to select only the fields you want when you query for the object.

func (*EmployeeInfo) Person added in v0.7.0 

func (o *EmployeeInfo) Person() *Person

Person returns the current value of the loaded Person, and nil if its not loaded.

func (*EmployeeInfo) PersonID added in v0.7.0 

func (o *EmployeeInfo) PersonID() string

func (*EmployeeInfo) PersonIDIsValid added in v0.7.0 

func (o *EmployeeInfo) PersonIDIsValid() bool

PersonIDIsValid returns true if the value was loaded from the database or has been set.

func (*EmployeeInfo) PrimaryKey added in v0.7.0 

func (o *EmployeeInfo) PrimaryKey() string

func (*EmployeeInfo) Save added in v0.7.0 

func (o *EmployeeInfo) Save(ctx context.Context)

Save will update or insert the object, depending on the state of the object. If it has any auto-generated ids, those will be updated.

func (*EmployeeInfo) SetEmployeeNumber added in v0.7.0 

func (o *EmployeeInfo) SetEmployeeNumber(v int)

SetEmployeeNumber sets the value of EmployeeNumber in the object, to be saved later using the Save() function.

func (*EmployeeInfo) SetPerson added in v0.7.0 

func (o *EmployeeInfo) SetPerson(v *Person)

SetPerson sets the value of Person in the object, to be saved later using the Save() function.

func (*EmployeeInfo) SetPersonID added in v0.7.0 

func (o *EmployeeInfo) SetPersonID(v string)

SetPersonID sets the value of PersonID in the object, to be saved later using the Save() function.

func (*EmployeeInfo) String added in v0.7.0 

func (o *EmployeeInfo) String() string

String implements the Stringer interface and returns the default label for the object as it appears in html lists. Typically you would change this to whatever was pertinent to your application.

func (*EmployeeInfo) UnmarshalBinary added in v0.7.0 

func (o *EmployeeInfo) UnmarshalBinary(data []byte) (err error)

type EmployeeInfosBuilder added in v0.7.0 

type EmployeeInfosBuilder struct {
	// contains filtered or unexported fields
}

The EmployeeInfosBuilder uses the QueryBuilderI interface from the database to build a query. All query operations go through this query builder. End a query by calling either Load, Count, or Delete

func QueryEmployeeInfos added in v0.7.0 

func QueryEmployeeInfos(ctx context.Context) *EmployeeInfosBuilder

QueryEmployeeInfos returns a new builder that gives you general purpose access to the EmployeeInfo records in the database. Its here to give public access to the query builder, but you can remove it if you do not need it.

func (*EmployeeInfosBuilder) Alias added in v0.7.0 

func (b *EmployeeInfosBuilder) Alias(name string, n query.NodeI) *EmployeeInfosBuilder

Alias lets you add a node with a custom name. After the query, you can read out the data using GetAlias() on a returned object. Alias is useful for adding calculations or subqueries to the query.

func (*EmployeeInfosBuilder) Count added in v0.7.0 

func (b *EmployeeInfosBuilder) Count(ctx context.Context, distinct bool, nodes ...query.NodeI) uint

Count terminates a query and returns just the number of items selected.

func (*EmployeeInfosBuilder) Delete added in v0.7.0 

func (b *EmployeeInfosBuilder) Delete(ctx context.Context)

Delete uses the query builder to delete a group of records that match the criteria

func (*EmployeeInfosBuilder) Distinct added in v0.7.0 

func (b *EmployeeInfosBuilder) Distinct() *EmployeeInfosBuilder

Distinct removes duplicates from the results of the query. Adding a Select() may help you get to the data you want, although using Distinct with joined tables is often not effective, since we force joined tables to include primary keys in the query, and this often ruins the effect of Distinct.

func (*EmployeeInfosBuilder) Expand added in v0.7.0 

func (b *EmployeeInfosBuilder) Expand(n query.NodeI) *EmployeeInfosBuilder

Expand expands an array type node so that it will produce individual rows instead of an array of items

func (*EmployeeInfosBuilder) Get added in v0.7.0 

func (b *EmployeeInfosBuilder) Get(ctx context.Context) *EmployeeInfo

Get is a convenience method to return only the first item found in a query. The entire query is performed, so you should generally use this only if you know you are selecting on one or very few items.

func (*EmployeeInfosBuilder) GroupBy added in v0.7.0 

func (b *EmployeeInfosBuilder) GroupBy(nodes ...query.NodeI) *EmployeeInfosBuilder

GroupBy controls how results are grouped when using aggregate functions in an Alias() call.

func (*EmployeeInfosBuilder) Having added in v0.7.0 

func (b *EmployeeInfosBuilder) Having(node query.NodeI) *EmployeeInfosBuilder

Having does additional filtering on the results of the query.

func (*EmployeeInfosBuilder) Join added in v0.7.0 

func (b *EmployeeInfosBuilder) Join(n query.NodeI, conditions ...query.NodeI) *EmployeeInfosBuilder

Join adds a node to the node tree so that its fields will appear in the query. Optionally add conditions to filter what gets included. The conditions will be AND'd with the basic condition matching the primary keys of the join.

func (*EmployeeInfosBuilder) Limit added in v0.7.0 

func (b *EmployeeInfosBuilder) Limit(maxRowCount int, offset int) *EmployeeInfosBuilder

Limit will return a subset of the data, limited to the offset and number of rows specified

func (*EmployeeInfosBuilder) Load added in v0.7.0 

func (b *EmployeeInfosBuilder) Load(ctx context.Context) (employeeInfoSlice []*EmployeeInfo)

Load terminates the query builder, performs the query, and returns a slice of EmployeeInfo objects. If there are any errors, they are returned in the context object. If no results come back from the query, it will return an empty slice

func (*EmployeeInfosBuilder) LoadI added in v0.7.0 

func (b *EmployeeInfosBuilder) LoadI(ctx context.Context) (employeeInfoSlice []interface{})

LoadI terminates the query builder, performs the query, and returns a slice of interfaces. If there are any errors, they are returned in the context object. If no results come back from the query, it will return an empty slice.

func (*EmployeeInfosBuilder) OrderBy added in v0.7.0 

func (b *EmployeeInfosBuilder) OrderBy(nodes ...query.NodeI) *EmployeeInfosBuilder

OrderBy specifies how the resulting data should be sorted.

func (*EmployeeInfosBuilder) Select added in v0.7.0 

func (b *EmployeeInfosBuilder) Select(nodes ...query.NodeI) *EmployeeInfosBuilder

Select optimizes the query to only return the specified fields. Once you put a Select in your query, you must specify all the fields that you will eventually read out. Be careful when selecting fields in joined tables, as joined tables will also contain pointers back to the parent table, and so the parent node should have the same field selected as the child node if you are querying those fields.

func (*EmployeeInfosBuilder) Subquery added in v0.7.0 

func (b *EmployeeInfosBuilder) Subquery() *query.SubqueryNode

Subquery uses the query builder to define a subquery within a larger query. You MUST include what you are selecting by adding Alias or Select functions on the subquery builder. Generally you would use this as a node to an Alias function on the surrounding query builder.

func (*EmployeeInfosBuilder) Where added in v0.7.0 

func (b *EmployeeInfosBuilder) Where(c query.NodeI) *EmployeeInfosBuilder

Where adds a condition to filter what gets selected.

type Login 

type Login struct {
	// contains filtered or unexported fields
}

func LoadLogin 

func LoadLogin(ctx context.Context, primaryKey string, joinOrSelectNodes ...query.NodeI) *Login

Load returns a Login from the database. joinOrSelectNodes lets you provide nodes for joining to other tables or selecting specific fields. Table nodes will be considered Join nodes, and column nodes will be Select nodes. See Join() and Select() for more info.

func LoadLoginByPersonID 

func LoadLoginByPersonID(ctx context.Context, person_id string, joinOrSelectNodes ...query.NodeI) *Login

LoadLoginByPersonID queries for a single Login object by the given unique index values. joinOrSelectNodes lets you provide nodes for joining to other tables or selecting specific fields. Table nodes will be considered Join nodes, and column nodes will be Select nodes. See Join() and Select() for more info. If you need a more elaborate query, use QueryLogins() to start a query builder.

func LoadLoginByUsername 

func LoadLoginByUsername(ctx context.Context, username string, joinOrSelectNodes ...query.NodeI) *Login

LoadLoginByUsername queries for a single Login object by the given unique index values. joinOrSelectNodes lets you provide nodes for joining to other tables or selecting specific fields. Table nodes will be considered Join nodes, and column nodes will be Select nodes. See Join() and Select() for more info. If you need a more elaborate query, use QueryLogins() to start a query builder.

func NewLogin 

func NewLogin() *Login

Create a new Login object and initialize to default values.

func (*Login) Delete 

func (o *Login) Delete(ctx context.Context)

Delete deletes the associated record from the database.

func (*Login) Get 

func (o *Login) Get(key string) interface{}

Get returns the value of a field in the object based on the field's name. It will also get related objects if they are loaded. Invalid fields and objects are returned as nil

func (*Login) GetAlias 

func (o *Login) GetAlias(key string) query.AliasValue

GetAlias returns the alias for the given key.

func (*Login) ID 

func (o *Login) ID() string

ID returns the loaded value of ID.

func (*Login) IDIsValid 

func (o *Login) IDIsValid() bool

IDIsValid returns true if the value was loaded from the database or has been set.

func (*Login) Initialize 

func (o *Login) Initialize()

Initialize or re-initialize a Login database object to default values.

func (*Login) IsDirty 

func (o *Login) IsDirty() bool

func (*Login) IsEnabled 

func (o *Login) IsEnabled() bool

func (*Login) IsEnabledIsValid 

func (o *Login) IsEnabledIsValid() bool

IsEnabledIsValid returns true if the value was loaded from the database or has been set.

func (*Login) LoadPerson 

func (o *Login) LoadPerson(ctx context.Context) *Person

LoadPerson returns the related Person. If it is not already loaded, it will attempt to load it first.

func (*Login) MarshalBinary 

func (o *Login) MarshalBinary() ([]byte, error)

MarshalBinary serializes the object into a buffer that is deserializable using UnmarshalBinary. It should be used for transmitting database objects over the wire, or for temporary storage. It does not send a version number, so if the data format changes, its up to you to invalidate the old stored objects. The framework uses this to serialize the object when it is stored in a control.

func (*Login) MarshalJSON 

func (o *Login) MarshalJSON() (data []byte, err error)

MarshalJSON serializes the object into a JSON object. Only valid data will be serialized, meaning, you can control what gets serialized by using Select to select only the fields you want when you query for the object.

func (*Login) Password 

func (o *Login) Password() string

func (*Login) PasswordIsNull 

func (o *Login) PasswordIsNull() bool

PasswordIsNull returns true if the related database value is null.

func (*Login) PasswordIsValid 

func (o *Login) PasswordIsValid() bool

PasswordIsValid returns true if the value was loaded from the database or has been set.

func (*Login) Person 

func (o *Login) Person() *Person

Person returns the current value of the loaded Person, and nil if its not loaded.

func (*Login) PersonID 

func (o *Login) PersonID() string

func (*Login) PersonIDIsNull 

func (o *Login) PersonIDIsNull() bool

PersonIDIsNull returns true if the related database value is null.

func (*Login) PersonIDIsValid 

func (o *Login) PersonIDIsValid() bool

PersonIDIsValid returns true if the value was loaded from the database or has been set.

func (*Login) PrimaryKey 

func (o *Login) PrimaryKey() string

func (*Login) Save 

func (o *Login) Save(ctx context.Context)

Save will update or insert the object, depending on the state of the object. If it has any auto-generated ids, those will be updated.

func (*Login) SetIsEnabled 

func (o *Login) SetIsEnabled(v bool)

SetIsEnabled sets the value of IsEnabled in the object, to be saved later using the Save() function.

func (*Login) SetPassword 

func (o *Login) SetPassword(i interface{})

func (*Login) SetPerson 

func (o *Login) SetPerson(v *Person)

func (*Login) SetPersonID 

func (o *Login) SetPersonID(i interface{})

func (*Login) SetUsername 

func (o *Login) SetUsername(v string)

SetUsername sets the value of Username in the object, to be saved later using the Save() function.

func (*Login) String 

func (o *Login) String() string

String implements the Stringer interface and returns the default label for the object as it appears in html lists. Typically you would change this to whatever was pertinent to your application.

func (*Login) UnmarshalBinary 

func (o *Login) UnmarshalBinary(data []byte) (err error)

func (*Login) Username 

func (o *Login) Username() string

func (*Login) UsernameIsValid 

func (o *Login) UsernameIsValid() bool

UsernameIsValid returns true if the value was loaded from the database or has been set.

type LoginsBuilder 

type LoginsBuilder struct {
	// contains filtered or unexported fields
}

The LoginsBuilder uses the QueryBuilderI interface from the database to build a query. All query operations go through this query builder. End a query by calling either Load, Count, or Delete

func QueryLogins 

func QueryLogins(ctx context.Context) *LoginsBuilder

QueryLogins returns a new builder that gives you general purpose access to the Login records in the database. Its here to give public access to the query builder, but you can remove it if you do not need it.

func (*LoginsBuilder) Alias 

func (b *LoginsBuilder) Alias(name string, n query.NodeI) *LoginsBuilder

Alias lets you add a node with a custom name. After the query, you can read out the data using GetAlias() on a returned object. Alias is useful for adding calculations or subqueries to the query.

func (*LoginsBuilder) Count 

func (b *LoginsBuilder) Count(ctx context.Context, distinct bool, nodes ...query.NodeI) uint

Count terminates a query and returns just the number of items selected.

func (*LoginsBuilder) Delete 

func (b *LoginsBuilder) Delete(ctx context.Context)

Delete uses the query builder to delete a group of records that match the criteria

func (*LoginsBuilder) Distinct 

func (b *LoginsBuilder) Distinct() *LoginsBuilder

Distinct removes duplicates from the results of the query. Adding a Select() may help you get to the data you want, although using Distinct with joined tables is often not effective, since we force joined tables to include primary keys in the query, and this often ruins the effect of Distinct.

func (*LoginsBuilder) Expand 

func (b *LoginsBuilder) Expand(n query.NodeI) *LoginsBuilder

Expand expands an array type node so that it will produce individual rows instead of an array of items

func (*LoginsBuilder) Get 

func (b *LoginsBuilder) Get(ctx context.Context) *Login

Get is a convenience method to return only the first item found in a query. The entire query is performed, so you should generally use this only if you know you are selecting on one or very few items.

func (*LoginsBuilder) GroupBy 

func (b *LoginsBuilder) GroupBy(nodes ...query.NodeI) *LoginsBuilder

GroupBy controls how results are grouped when using aggregate functions in an Alias() call.

func (*LoginsBuilder) Having 

func (b *LoginsBuilder) Having(node query.NodeI) *LoginsBuilder

Having does additional filtering on the results of the query.

func (*LoginsBuilder) Join 

func (b *LoginsBuilder) Join(n query.NodeI, conditions ...query.NodeI) *LoginsBuilder

Join adds a node to the node tree so that its fields will appear in the query. Optionally add conditions to filter what gets included. The conditions will be AND'd with the basic condition matching the primary keys of the join.

func (*LoginsBuilder) Limit 

func (b *LoginsBuilder) Limit(maxRowCount int, offset int) *LoginsBuilder

Limit will return a subset of the data, limited to the offset and number of rows specified

func (*LoginsBuilder) Load 

func (b *LoginsBuilder) Load(ctx context.Context) (loginSlice []*Login)

Load terminates the query builder, performs the query, and returns a slice of Login objects. If there are any errors, they are returned in the context object. If no results come back from the query, it will return an empty slice

func (*LoginsBuilder) LoadI 

func (b *LoginsBuilder) LoadI(ctx context.Context) (loginSlice []interface{})

LoadI terminates the query builder, performs the query, and returns a slice of interfaces. If there are any errors, they are returned in the context object. If no results come back from the query, it will return an empty slice.

func (*LoginsBuilder) OrderBy 

func (b *LoginsBuilder) OrderBy(nodes ...query.NodeI) *LoginsBuilder

OrderBy specifies how the resulting data should be sorted.

func (*LoginsBuilder) Select 

func (b *LoginsBuilder) Select(nodes ...query.NodeI) *LoginsBuilder

Select optimizes the query to only return the specified fields. Once you put a Select in your query, you must specify all the fields that you will eventually read out. Be careful when selecting fields in joined tables, as joined tables will also contain pointers back to the parent table, and so the parent node should have the same field selected as the child node if you are querying those fields.

func (*LoginsBuilder) Subquery 

func (b *LoginsBuilder) Subquery() *query.SubqueryNode

Subquery uses the query builder to define a subquery within a larger query. You MUST include what you are selecting by adding Alias or Select functions on the subquery builder. Generally you would use this as a node to an Alias function on the surrounding query builder.

func (*LoginsBuilder) Where 

func (b *LoginsBuilder) Where(c query.NodeI) *LoginsBuilder

Where adds a condition to filter what gets selected.

type Milestone 

type Milestone struct {
	// contains filtered or unexported fields
}

func LoadMilestone 

func LoadMilestone(ctx context.Context, primaryKey string, joinOrSelectNodes ...query.NodeI) *Milestone

Load returns a Milestone from the database. joinOrSelectNodes lets you provide nodes for joining to other tables or selecting specific fields. Table nodes will be considered Join nodes, and column nodes will be Select nodes. See Join() and Select() for more info.

func NewMilestone 

func NewMilestone() *Milestone

Create a new Milestone object and initialize to default values.

func (*Milestone) Delete 

func (o *Milestone) Delete(ctx context.Context)

Delete deletes the associated record from the database.

func (*Milestone) Get 

func (o *Milestone) Get(key string) interface{}

Get returns the value of a field in the object based on the field's name. It will also get related objects if they are loaded. Invalid fields and objects are returned as nil

func (*Milestone) GetAlias 

func (o *Milestone) GetAlias(key string) query.AliasValue

GetAlias returns the alias for the given key.

func (*Milestone) ID 

func (o *Milestone) ID() string

ID returns the loaded value of ID.

func (*Milestone) IDIsValid 

func (o *Milestone) IDIsValid() bool

IDIsValid returns true if the value was loaded from the database or has been set.

func (*Milestone) Initialize 

func (o *Milestone) Initialize()

Initialize or re-initialize a Milestone database object to default values.

func (*Milestone) IsDirty 

func (o *Milestone) IsDirty() bool

func (*Milestone) LoadProject 

func (o *Milestone) LoadProject(ctx context.Context) *Project

LoadProject returns the related Project. If it is not already loaded, it will attempt to load it first.

func (*Milestone) MarshalBinary 

func (o *Milestone) MarshalBinary() ([]byte, error)

MarshalBinary serializes the object into a buffer that is deserializable using UnmarshalBinary. It should be used for transmitting database objects over the wire, or for temporary storage. It does not send a version number, so if the data format changes, its up to you to invalidate the old stored objects. The framework uses this to serialize the object when it is stored in a control.

func (*Milestone) MarshalJSON 

func (o *Milestone) MarshalJSON() (data []byte, err error)

MarshalJSON serializes the object into a JSON object. Only valid data will be serialized, meaning, you can control what gets serialized by using Select to select only the fields you want when you query for the object.

func (*Milestone) Name 

func (o *Milestone) Name() string

func (*Milestone) NameIsValid 

func (o *Milestone) NameIsValid() bool

NameIsValid returns true if the value was loaded from the database or has been set.

func (*Milestone) PrimaryKey 

func (o *Milestone) PrimaryKey() string

func (*Milestone) Project 

func (o *Milestone) Project() *Project

Project returns the current value of the loaded Project, and nil if its not loaded.

func (*Milestone) ProjectID 

func (o *Milestone) ProjectID() string

func (*Milestone) ProjectIDIsValid 

func (o *Milestone) ProjectIDIsValid() bool

ProjectIDIsValid returns true if the value was loaded from the database or has been set.

func (*Milestone) Save 

func (o *Milestone) Save(ctx context.Context)

Save will update or insert the object, depending on the state of the object. If it has any auto-generated ids, those will be updated.

func (*Milestone) SetName 

func (o *Milestone) SetName(v string)

SetName sets the value of Name in the object, to be saved later using the Save() function.

func (*Milestone) SetProject 

func (o *Milestone) SetProject(v *Project)

SetProject sets the value of Project in the object, to be saved later using the Save() function.

func (*Milestone) SetProjectID 

func (o *Milestone) SetProjectID(v string)

SetProjectID sets the value of ProjectID in the object, to be saved later using the Save() function.

func (*Milestone) String 

func (o *Milestone) String() string

String implements the Stringer interface and returns the default label for the object as it appears in html lists. Typically you would change this to whatever was pertinent to your application.

func (*Milestone) UnmarshalBinary 

func (o *Milestone) UnmarshalBinary(data []byte) (err error)

type MilestonesBuilder 

type MilestonesBuilder struct {
	// contains filtered or unexported fields
}

The MilestonesBuilder uses the QueryBuilderI interface from the database to build a query. All query operations go through this query builder. End a query by calling either Load, Count, or Delete

func QueryMilestones 

func QueryMilestones(ctx context.Context) *MilestonesBuilder

QueryMilestones returns a new builder that gives you general purpose access to the Milestone records in the database. Its here to give public access to the query builder, but you can remove it if you do not need it.

func (*MilestonesBuilder) Alias 

func (b *MilestonesBuilder) Alias(name string, n query.NodeI) *MilestonesBuilder

Alias lets you add a node with a custom name. After the query, you can read out the data using GetAlias() on a returned object. Alias is useful for adding calculations or subqueries to the query.

func (*MilestonesBuilder) Count 

func (b *MilestonesBuilder) Count(ctx context.Context, distinct bool, nodes ...query.NodeI) uint

Count terminates a query and returns just the number of items selected.

func (*MilestonesBuilder) Delete 

func (b *MilestonesBuilder) Delete(ctx context.Context)

Delete uses the query builder to delete a group of records that match the criteria

func (*MilestonesBuilder) Distinct 

func (b *MilestonesBuilder) Distinct() *MilestonesBuilder

Distinct removes duplicates from the results of the query. Adding a Select() may help you get to the data you want, although using Distinct with joined tables is often not effective, since we force joined tables to include primary keys in the query, and this often ruins the effect of Distinct.

func (*MilestonesBuilder) Expand 

func (b *MilestonesBuilder) Expand(n query.NodeI) *MilestonesBuilder

Expand expands an array type node so that it will produce individual rows instead of an array of items

func (*MilestonesBuilder) Get 

func (b *MilestonesBuilder) Get(ctx context.Context) *Milestone

Get is a convenience method to return only the first item found in a query. The entire query is performed, so you should generally use this only if you know you are selecting on one or very few items.

func (*MilestonesBuilder) GroupBy 

func (b *MilestonesBuilder) GroupBy(nodes ...query.NodeI) *MilestonesBuilder

GroupBy controls how results are grouped when using aggregate functions in an Alias() call.

func (*MilestonesBuilder) Having 

func (b *MilestonesBuilder) Having(node query.NodeI) *MilestonesBuilder

Having does additional filtering on the results of the query.

func (*MilestonesBuilder) Join 

func (b *MilestonesBuilder) Join(n query.NodeI, conditions ...query.NodeI) *MilestonesBuilder

Join adds a node to the node tree so that its fields will appear in the query. Optionally add conditions to filter what gets included. The conditions will be AND'd with the basic condition matching the primary keys of the join.

func (*MilestonesBuilder) Limit 

func (b *MilestonesBuilder) Limit(maxRowCount int, offset int) *MilestonesBuilder

Limit will return a subset of the data, limited to the offset and number of rows specified

func (*MilestonesBuilder) Load 

func (b *MilestonesBuilder) Load(ctx context.Context) (milestoneSlice []*Milestone)

Load terminates the query builder, performs the query, and returns a slice of Milestone objects. If there are any errors, they are returned in the context object. If no results come back from the query, it will return an empty slice

func (*MilestonesBuilder) LoadI 

func (b *MilestonesBuilder) LoadI(ctx context.Context) (milestoneSlice []interface{})

LoadI terminates the query builder, performs the query, and returns a slice of interfaces. If there are any errors, they are returned in the context object. If no results come back from the query, it will return an empty slice.

func (*MilestonesBuilder) OrderBy 

func (b *MilestonesBuilder) OrderBy(nodes ...query.NodeI) *MilestonesBuilder

OrderBy specifies how the resulting data should be sorted.

func (*MilestonesBuilder) Select 

func (b *MilestonesBuilder) Select(nodes ...query.NodeI) *MilestonesBuilder

Select optimizes the query to only return the specified fields. Once you put a Select in your query, you must specify all the fields that you will eventually read out. Be careful when selecting fields in joined tables, as joined tables will also contain pointers back to the parent table, and so the parent node should have the same field selected as the child node if you are querying those fields.

func (*MilestonesBuilder) Subquery 

func (b *MilestonesBuilder) Subquery() *query.SubqueryNode

Subquery uses the query builder to define a subquery within a larger query. You MUST include what you are selecting by adding Alias or Select functions on the subquery builder. Generally you would use this as a node to an Alias function on the surrounding query builder.

func (*MilestonesBuilder) Where 

func (b *MilestonesBuilder) Where(c query.NodeI) *MilestonesBuilder

Where adds a condition to filter what gets selected.

type PeopleBuilder 

type PeopleBuilder struct {
	// contains filtered or unexported fields
}

The PeopleBuilder uses the QueryBuilderI interface from the database to build a query. All query operations go through this query builder. End a query by calling either Load, Count, or Delete

func QueryPeople 

func QueryPeople(ctx context.Context) *PeopleBuilder

QueryPeople returns a new builder that gives you general purpose access to the Person records in the database. Its here to give public access to the query builder, but you can remove it if you do not need it.

func (*PeopleBuilder) Alias 

func (b *PeopleBuilder) Alias(name string, n query.NodeI) *PeopleBuilder

Alias lets you add a node with a custom name. After the query, you can read out the data using GetAlias() on a returned object. Alias is useful for adding calculations or subqueries to the query.

func (*PeopleBuilder) Count 

func (b *PeopleBuilder) Count(ctx context.Context, distinct bool, nodes ...query.NodeI) uint

Count terminates a query and returns just the number of items selected.

func (*PeopleBuilder) Delete 

func (b *PeopleBuilder) Delete(ctx context.Context)

Delete uses the query builder to delete a group of records that match the criteria

func (*PeopleBuilder) Distinct 

func (b *PeopleBuilder) Distinct() *PeopleBuilder

Distinct removes duplicates from the results of the query. Adding a Select() may help you get to the data you want, although using Distinct with joined tables is often not effective, since we force joined tables to include primary keys in the query, and this often ruins the effect of Distinct.

func (*PeopleBuilder) Expand 

func (b *PeopleBuilder) Expand(n query.NodeI) *PeopleBuilder

Expand expands an array type node so that it will produce individual rows instead of an array of items

func (*PeopleBuilder) Get 

func (b *PeopleBuilder) Get(ctx context.Context) *Person

Get is a convenience method to return only the first item found in a query. The entire query is performed, so you should generally use this only if you know you are selecting on one or very few items.

func (*PeopleBuilder) GroupBy 

func (b *PeopleBuilder) GroupBy(nodes ...query.NodeI) *PeopleBuilder

GroupBy controls how results are grouped when using aggregate functions in an Alias() call.

func (*PeopleBuilder) Having 

func (b *PeopleBuilder) Having(node query.NodeI) *PeopleBuilder

Having does additional filtering on the results of the query.

func (*PeopleBuilder) Join 

func (b *PeopleBuilder) Join(n query.NodeI, conditions ...query.NodeI) *PeopleBuilder

Join adds a node to the node tree so that its fields will appear in the query. Optionally add conditions to filter what gets included. The conditions will be AND'd with the basic condition matching the primary keys of the join.

func (*PeopleBuilder) Limit 

func (b *PeopleBuilder) Limit(maxRowCount int, offset int) *PeopleBuilder

Limit will return a subset of the data, limited to the offset and number of rows specified

func (*PeopleBuilder) Load 

func (b *PeopleBuilder) Load(ctx context.Context) (personSlice []*Person)

Load terminates the query builder, performs the query, and returns a slice of Person objects. If there are any errors, they are returned in the context object. If no results come back from the query, it will return an empty slice

func (*PeopleBuilder) LoadI 

func (b *PeopleBuilder) LoadI(ctx context.Context) (personSlice []interface{})

LoadI terminates the query builder, performs the query, and returns a slice of interfaces. If there are any errors, they are returned in the context object. If no results come back from the query, it will return an empty slice.

func (*PeopleBuilder) OrderBy 

func (b *PeopleBuilder) OrderBy(nodes ...query.NodeI) *PeopleBuilder

OrderBy specifies how the resulting data should be sorted.

func (*PeopleBuilder) Select 

func (b *PeopleBuilder) Select(nodes ...query.NodeI) *PeopleBuilder

Select optimizes the query to only return the specified fields. Once you put a Select in your query, you must specify all the fields that you will eventually read out. Be careful when selecting fields in joined tables, as joined tables will also contain pointers back to the parent table, and so the parent node should have the same field selected as the child node if you are querying those fields.

func (*PeopleBuilder) Subquery 

func (b *PeopleBuilder) Subquery() *query.SubqueryNode

Subquery uses the query builder to define a subquery within a larger query. You MUST include what you are selecting by adding Alias or Select functions on the subquery builder. Generally you would use this as a node to an Alias function on the surrounding query builder.

func (*PeopleBuilder) Where 

func (b *PeopleBuilder) Where(c query.NodeI) *PeopleBuilder

Where adds a condition to filter what gets selected.

type Person 

type Person struct {
	// contains filtered or unexported fields
}

func LoadPerson 

func LoadPerson(ctx context.Context, primaryKey string, joinOrSelectNodes ...query.NodeI) *Person

Load returns a Person from the database. joinOrSelectNodes lets you provide nodes for joining to other tables or selecting specific fields. Table nodes will be considered Join nodes, and column nodes will be Select nodes. See Join() and Select() for more info.

func NewPerson 

func NewPerson() *Person

Create a new Person object and initialize to default values.

func (*Person) Address 

func (o *Person) Address(pk string) *Address

Address returns a single Address object by primary key, if one was loaded. Otherwise, it will return nil. It will not return Address objects that are not saved.

func (*Person) Addresses 

func (o *Person) Addresses() []*Address

Addresses returns a slice of Address objects if loaded.

func (*Person) Delete 

func (o *Person) Delete(ctx context.Context)

Delete deletes the associated record from the database.

func (*Person) EmployeeInfo added in v0.7.0 

func (o *Person) EmployeeInfo() *EmployeeInfo

EmployeeInfo returns the connected EmployeeInfo object, if one was loaded otherwise, it will return nil.

func (*Person) FirstName 

func (o *Person) FirstName() string

func (*Person) FirstNameIsValid 

func (o *Person) FirstNameIsValid() bool

FirstNameIsValid returns true if the value was loaded from the database or has been set.

func (*Person) Get 

func (o *Person) Get(key string) interface{}

Get returns the value of a field in the object based on the field's name. It will also get related objects if they are loaded. Invalid fields and objects are returned as nil

func (*Person) GetAlias 

func (o *Person) GetAlias(key string) query.AliasValue

GetAlias returns the alias for the given key.

func (*Person) ID 

func (o *Person) ID() string

ID returns the loaded value of ID.

func (*Person) IDIsValid 

func (o *Person) IDIsValid() bool

IDIsValid returns true if the value was loaded from the database or has been set.

func (*Person) Initialize 

func (o *Person) Initialize()

Initialize or re-initialize a Person database object to default values.

func (*Person) IsDirty 

func (o *Person) IsDirty() bool

func (*Person) LastName 

func (o *Person) LastName() string

func (*Person) LastNameIsValid 

func (o *Person) LastNameIsValid() bool

LastNameIsValid returns true if the value was loaded from the database or has been set.

func (*Person) LoadAddresses 

func (o *Person) LoadAddresses(ctx context.Context, conditions ...interface{}) []*Address

LoadAddresses loads a new slice of Address objects and returns it.

func (*Person) LoadEmployeeInfo added in v0.7.0 

func (o *Person) LoadEmployeeInfo(ctx context.Context) *EmployeeInfo

LoadEmployeeInfo returns the connected EmployeeInfo object, if one was loaded otherwise, it will return nil.

func (*Person) LoadLogin 

func (o *Person) LoadLogin(ctx context.Context) *Login

LoadLogin returns the connected Login object, if one was loaded otherwise, it will return nil.

func (*Person) LoadProjectsAsManager 

func (o *Person) LoadProjectsAsManager(ctx context.Context, conditions ...interface{}) []*Project

LoadProjectsAsManager loads a new slice of Project objects and returns it.

func (*Person) Login 

func (o *Person) Login() *Login

Login returns the connected Login object, if one was loaded otherwise, it will return nil.

func (*Person) MarshalBinary 

func (o *Person) MarshalBinary() ([]byte, error)

MarshalBinary serializes the object into a buffer that is deserializable using UnmarshalBinary. It should be used for transmitting database objects over the wire, or for temporary storage. It does not send a version number, so if the data format changes, its up to you to invalidate the old stored objects. The framework uses this to serialize the object when it is stored in a control.

func (*Person) MarshalJSON 

func (o *Person) MarshalJSON() (data []byte, err error)

MarshalJSON serializes the object into a JSON object. Only valid data will be serialized, meaning, you can control what gets serialized by using Select to select only the fields you want when you query for the object.

func (*Person) PersonTypes 

func (o *Person) PersonTypes() []PersonType

PersonTypes returns a slice of PersonType values if loaded.

func (*Person) PrimaryKey 

func (o *Person) PrimaryKey() string

func (*Person) ProjectAsManager 

func (o *Person) ProjectAsManager(pk string) *Project

ProjectAsManager returns a single Project object by primary key, if one was loaded. Otherwise, it will return nil. It will not return Project objects that are not saved.

func (*Person) ProjectAsTeamMember 

func (o *Person) ProjectAsTeamMember(pk string) *Project

ProjectAsTeamMember returns a single Project object by primary key, if one was loaded otherwise, it will return nil.

func (*Person) ProjectsAsManager 

func (o *Person) ProjectsAsManager() []*Project

ProjectsAsManager returns a slice of Project objects if loaded.

func (*Person) ProjectsAsTeamMember 

func (o *Person) ProjectsAsTeamMember() []*Project

ProjectsAsTeamMember returns a slice of Project objects if loaded. If not loaded, will return nil.

func (*Person) Save 

func (o *Person) Save(ctx context.Context)

Save will update or insert the object, depending on the state of the object. If it has any auto-generated ids, those will be updated.

func (*Person) SetAddresses added in v0.7.0 

func (o *Person) SetAddresses(objs []*Address)

SetAddresses associates the given objects with the Person. WARNING! If it has items already associated with it that will not be associated after a save, those items will be DELETED since they cannot be null. If you did not use a join to query the items in the first place, used a conditional join, or joined with an expansion, be particularly careful, since you may be changing items that are not currently attached to this Person.

func (*Person) SetEmployeeInfo added in v0.7.0 

func (o *Person) SetEmployeeInfo(obj *EmployeeInfo)

SetEmployeeInfo associates the given object with the Person. WARNING! If it has an item already associated with it, that item will be DELETED since it cannot be null. If you did not use a join to query the items in the first place, used a conditional join, or joined with an expansion, be particularly careful, since you may be changing an item that is not currently attached to this Person.

func (*Person) SetFirstName 

func (o *Person) SetFirstName(v string)

SetFirstName sets the value of FirstName in the object, to be saved later using the Save() function.

func (*Person) SetLastName 

func (o *Person) SetLastName(v string)

SetLastName sets the value of LastName in the object, to be saved later using the Save() function.

func (*Person) SetLogin added in v0.7.0 

func (o *Person) SetLogin(obj *Login)

SetLogin associates the given object with the Person. If it has an item already associated with it, the foreign key for that item will be set to null. If you did not use a join to query the items in the first place, used a conditional join, or joined with an expansion, be particularly careful, since you may be changing an item that is not currently attached to this Person.

func (*Person) SetPersonTypes added in v0.9.0 

func (o *Person) SetPersonTypes(objs []PersonType)

SetPersonTypes sets the associated values to the given slice of PersonType values. It will also disassociate from all previously associated values.

func (*Person) SetProjectsAsManager added in v0.7.0 

func (o *Person) SetProjectsAsManager(objs []*Project)

SetProjectsAsManager associates the given objects with the Person. If it has items already associated with it that will not be associated after a save, the foreign keys for those will be set to null. If you did not use a join to query the items in the first place, used a conditional join, or joined with an expansion, be particularly careful, since you may be changing items that are not currently attached to this Person.

func (*Person) SetProjectsAsTeamMember added in v0.9.0 

func (o *Person) SetProjectsAsTeamMember(objs []*Project)

SetProjectsAsTeamMember sets the associated objects to the given slice of Project objects. It will unassociate from all previously associated objects after saving.

func (*Person) String 

func (o *Person) String() string

String implements the Stringer interface and returns the default label for the object as it appears in html lists. Typically you would change this to whatever was pertinent to your application.

func (*Person) UnmarshalBinary 

func (o *Person) UnmarshalBinary(data []byte) (err error)

type PersonType 

type PersonType uint
const (
	PersonTypeContractor PersonType = 1

	PersonTypeManager PersonType = 2

	PersonTypeInactive PersonType = 3

	PersonTypeCompanyCar PersonType = 4

	PersonTypeWorksFromHome PersonType = 5
)

func AllPersonTypes added in v0.9.0 

func AllPersonTypes() (values []PersonType)

AllPersonTypes returns a slice of all the PersonType items

func PersonTypeFromID added in v0.9.3 

func PersonTypeFromID(id string) PersonType

PersonTypeFromID converts a PersonType ID to a PersonType

func (PersonType) ID 

func (p PersonType) ID() string

ID returns a string representation of the id and satisfies the IDer interface

func (PersonType) Label 

func (p PersonType) Label() string

Label returns the string that will be displayed to a user for this item. Together with the Value function, it satisfies the ItemLister interface that makes it easy to create a dropdown list of items.

func (PersonType) String 

func (p PersonType) String() string

String returns the name value of the type and satisfies the fmt.Stringer interface

func (PersonType) Value 

func (p PersonType) Value() interface{}

Value returns the value that will be used in dropdown lists and satisfies the Valuer and ItemLister interfaces.

type PersonWithLock 

type PersonWithLock struct {
	// contains filtered or unexported fields
}

func LoadPersonWithLock 

func LoadPersonWithLock(ctx context.Context, primaryKey string, joinOrSelectNodes ...query.NodeI) *PersonWithLock

Load returns a PersonWithLock from the database. joinOrSelectNodes lets you provide nodes for joining to other tables or selecting specific fields. Table nodes will be considered Join nodes, and column nodes will be Select nodes. See Join() and Select() for more info.

func NewPersonWithLock 

func NewPersonWithLock() *PersonWithLock

Create a new PersonWithLock object and initialize to default values.

func (*PersonWithLock) Delete 

func (o *PersonWithLock) Delete(ctx context.Context)

Delete deletes the associated record from the database.

func (*PersonWithLock) FirstName 

func (o *PersonWithLock) FirstName() string

func (*PersonWithLock) FirstNameIsValid 

func (o *PersonWithLock) FirstNameIsValid() bool

FirstNameIsValid returns true if the value was loaded from the database or has been set.

func (*PersonWithLock) Get 

func (o *PersonWithLock) Get(key string) interface{}

Get returns the value of a field in the object based on the field's name. It will also get related objects if they are loaded. Invalid fields and objects are returned as nil

func (*PersonWithLock) GetAlias 

func (o *PersonWithLock) GetAlias(key string) query.AliasValue

GetAlias returns the alias for the given key.

func (*PersonWithLock) ID 

func (o *PersonWithLock) ID() string

ID returns the loaded value of ID.

func (*PersonWithLock) IDIsValid 

func (o *PersonWithLock) IDIsValid() bool

IDIsValid returns true if the value was loaded from the database or has been set.

func (*PersonWithLock) Initialize 

func (o *PersonWithLock) Initialize()

Initialize or re-initialize a PersonWithLock database object to default values.

func (*PersonWithLock) IsDirty 

func (o *PersonWithLock) IsDirty() bool

func (*PersonWithLock) LastName 

func (o *PersonWithLock) LastName() string

func (*PersonWithLock) LastNameIsValid 

func (o *PersonWithLock) LastNameIsValid() bool

LastNameIsValid returns true if the value was loaded from the database or has been set.

func (*PersonWithLock) MarshalBinary 

func (o *PersonWithLock) MarshalBinary() ([]byte, error)

MarshalBinary serializes the object into a buffer that is deserializable using UnmarshalBinary. It should be used for transmitting database objects over the wire, or for temporary storage. It does not send a version number, so if the data format changes, its up to you to invalidate the old stored objects. The framework uses this to serialize the object when it is stored in a control.

func (*PersonWithLock) MarshalJSON 

func (o *PersonWithLock) MarshalJSON() (data []byte, err error)

MarshalJSON serializes the object into a JSON object. Only valid data will be serialized, meaning, you can control what gets serialized by using Select to select only the fields you want when you query for the object.

func (*PersonWithLock) PrimaryKey 

func (o *PersonWithLock) PrimaryKey() string

func (*PersonWithLock) Save 

func (o *PersonWithLock) Save(ctx context.Context)

Save will update or insert the object, depending on the state of the object. If it has any auto-generated ids, those will be updated.

func (*PersonWithLock) SetFirstName 

func (o *PersonWithLock) SetFirstName(v string)

SetFirstName sets the value of FirstName in the object, to be saved later using the Save() function.

func (*PersonWithLock) SetLastName 

func (o *PersonWithLock) SetLastName(v string)

SetLastName sets the value of LastName in the object, to be saved later using the Save() function.

func (*PersonWithLock) SetSysTimestamp 

func (o *PersonWithLock) SetSysTimestamp(i interface{})

func (*PersonWithLock) String 

func (o *PersonWithLock) String() string

String implements the Stringer interface and returns the default label for the object as it appears in html lists. Typically you would change this to whatever was pertinent to your application.

func (*PersonWithLock) SysTimestamp 

func (o *PersonWithLock) SysTimestamp() datetime.DateTime

func (*PersonWithLock) SysTimestampIsNull 

func (o *PersonWithLock) SysTimestampIsNull() bool

SysTimestampIsNull returns true if the related database value is null.

func (*PersonWithLock) SysTimestampIsValid 

func (o *PersonWithLock) SysTimestampIsValid() bool

SysTimestampIsValid returns true if the value was loaded from the database or has been set.

func (*PersonWithLock) UnmarshalBinary 

func (o *PersonWithLock) UnmarshalBinary(data []byte) (err error)

type PersonWithLocksBuilder 

type PersonWithLocksBuilder struct {
	// contains filtered or unexported fields
}

The PersonWithLocksBuilder uses the QueryBuilderI interface from the database to build a query. All query operations go through this query builder. End a query by calling either Load, Count, or Delete

func QueryPersonWithLocks 

func QueryPersonWithLocks(ctx context.Context) *PersonWithLocksBuilder

QueryPersonWithLocks returns a new builder that gives you general purpose access to the PersonWithLock records in the database. Its here to give public access to the query builder, but you can remove it if you do not need it.

func (*PersonWithLocksBuilder) Alias 

func (b *PersonWithLocksBuilder) Alias(name string, n query.NodeI) *PersonWithLocksBuilder

Alias lets you add a node with a custom name. After the query, you can read out the data using GetAlias() on a returned object. Alias is useful for adding calculations or subqueries to the query.

func (*PersonWithLocksBuilder) Count 

func (b *PersonWithLocksBuilder) Count(ctx context.Context, distinct bool, nodes ...query.NodeI) uint

Count terminates a query and returns just the number of items selected.

func (*PersonWithLocksBuilder) Delete 

func (b *PersonWithLocksBuilder) Delete(ctx context.Context)

Delete uses the query builder to delete a group of records that match the criteria

func (*PersonWithLocksBuilder) Distinct 

func (b *PersonWithLocksBuilder) Distinct() *PersonWithLocksBuilder

Distinct removes duplicates from the results of the query. Adding a Select() may help you get to the data you want, although using Distinct with joined tables is often not effective, since we force joined tables to include primary keys in the query, and this often ruins the effect of Distinct.

func (*PersonWithLocksBuilder) Expand 

func (b *PersonWithLocksBuilder) Expand(n query.NodeI) *PersonWithLocksBuilder

Expand expands an array type node so that it will produce individual rows instead of an array of items

func (*PersonWithLocksBuilder) Get 

func (b *PersonWithLocksBuilder) Get(ctx context.Context) *PersonWithLock

Get is a convenience method to return only the first item found in a query. The entire query is performed, so you should generally use this only if you know you are selecting on one or very few items.

func (*PersonWithLocksBuilder) GroupBy 

func (b *PersonWithLocksBuilder) GroupBy(nodes ...query.NodeI) *PersonWithLocksBuilder

GroupBy controls how results are grouped when using aggregate functions in an Alias() call.

func (*PersonWithLocksBuilder) Having 

func (b *PersonWithLocksBuilder) Having(node query.NodeI) *PersonWithLocksBuilder

Having does additional filtering on the results of the query.

func (*PersonWithLocksBuilder) Join 

func (b *PersonWithLocksBuilder) Join(n query.NodeI, conditions ...query.NodeI) *PersonWithLocksBuilder

Join adds a node to the node tree so that its fields will appear in the query. Optionally add conditions to filter what gets included. The conditions will be AND'd with the basic condition matching the primary keys of the join.

func (*PersonWithLocksBuilder) Limit 

func (b *PersonWithLocksBuilder) Limit(maxRowCount int, offset int) *PersonWithLocksBuilder

Limit will return a subset of the data, limited to the offset and number of rows specified

func (*PersonWithLocksBuilder) Load 

func (b *PersonWithLocksBuilder) Load(ctx context.Context) (personWithLockSlice []*PersonWithLock)

Load terminates the query builder, performs the query, and returns a slice of PersonWithLock objects. If there are any errors, they are returned in the context object. If no results come back from the query, it will return an empty slice

func (*PersonWithLocksBuilder) LoadI 

func (b *PersonWithLocksBuilder) LoadI(ctx context.Context) (personWithLockSlice []interface{})

LoadI terminates the query builder, performs the query, and returns a slice of interfaces. If there are any errors, they are returned in the context object. If no results come back from the query, it will return an empty slice.

func (*PersonWithLocksBuilder) OrderBy 

func (b *PersonWithLocksBuilder) OrderBy(nodes ...query.NodeI) *PersonWithLocksBuilder

OrderBy specifies how the resulting data should be sorted.

func (*PersonWithLocksBuilder) Select 

func (b *PersonWithLocksBuilder) Select(nodes ...query.NodeI) *PersonWithLocksBuilder

Select optimizes the query to only return the specified fields. Once you put a Select in your query, you must specify all the fields that you will eventually read out. Be careful when selecting fields in joined tables, as joined tables will also contain pointers back to the parent table, and so the parent node should have the same field selected as the child node if you are querying those fields.

func (*PersonWithLocksBuilder) Subquery 

func (b *PersonWithLocksBuilder) Subquery() *query.SubqueryNode

Subquery uses the query builder to define a subquery within a larger query. You MUST include what you are selecting by adding Alias or Select functions on the subquery builder. Generally you would use this as a node to an Alias function on the surrounding query builder.

func (*PersonWithLocksBuilder) Where 

func (b *PersonWithLocksBuilder) Where(c query.NodeI) *PersonWithLocksBuilder

Where adds a condition to filter what gets selected.

type Project 

type Project struct {
	// contains filtered or unexported fields
}

func LoadProject 

func LoadProject(ctx context.Context, primaryKey string, joinOrSelectNodes ...query.NodeI) *Project

Load returns a Project from the database. joinOrSelectNodes lets you provide nodes for joining to other tables or selecting specific fields. Table nodes will be considered Join nodes, and column nodes will be Select nodes. See Join() and Select() for more info.

func LoadProjectByNum 

func LoadProjectByNum(ctx context.Context, num int, joinOrSelectNodes ...query.NodeI) *Project

LoadProjectByNum queries for a single Project object by the given unique index values. joinOrSelectNodes lets you provide nodes for joining to other tables or selecting specific fields. Table nodes will be considered Join nodes, and column nodes will be Select nodes. See Join() and Select() for more info. If you need a more elaborate query, use QueryProjects() to start a query builder.

func NewProject 

func NewProject() *Project

Create a new Project object and initialize to default values.

func (*Project) Budget 

func (o *Project) Budget() string

func (*Project) BudgetIsNull 

func (o *Project) BudgetIsNull() bool

BudgetIsNull returns true if the related database value is null.

func (*Project) BudgetIsValid 

func (o *Project) BudgetIsValid() bool

BudgetIsValid returns true if the value was loaded from the database or has been set.

func (*Project) ChildAsParent 

func (o *Project) ChildAsParent(pk string) *Project

ChildAsParent returns a single Project object by primary key, if one was loaded otherwise, it will return nil.

func (*Project) ChildrenAsParent 

func (o *Project) ChildrenAsParent() []*Project

ChildrenAsParent returns a slice of Project objects if loaded. If not loaded, will return nil.

func (*Project) Delete 

func (o *Project) Delete(ctx context.Context)

Delete deletes the associated record from the database.

func (*Project) Description 

func (o *Project) Description() string

func (*Project) DescriptionIsNull 

func (o *Project) DescriptionIsNull() bool

DescriptionIsNull returns true if the related database value is null.

func (*Project) DescriptionIsValid 

func (o *Project) DescriptionIsValid() bool

DescriptionIsValid returns true if the value was loaded from the database or has been set.

func (*Project) EndDate 

func (o *Project) EndDate() datetime.DateTime

func (*Project) EndDateIsNull 

func (o *Project) EndDateIsNull() bool

EndDateIsNull returns true if the related database value is null.

func (*Project) EndDateIsValid 

func (o *Project) EndDateIsValid() bool

EndDateIsValid returns true if the value was loaded from the database or has been set.

func (*Project) Get 

func (o *Project) Get(key string) interface{}

Get returns the value of a field in the object based on the field's name. It will also get related objects if they are loaded. Invalid fields and objects are returned as nil

func (*Project) GetAlias 

func (o *Project) GetAlias(key string) query.AliasValue

GetAlias returns the alias for the given key.

func (*Project) ID 

func (o *Project) ID() string

ID returns the loaded value of ID.

func (*Project) IDIsValid 

func (o *Project) IDIsValid() bool

IDIsValid returns true if the value was loaded from the database or has been set.

func (*Project) Initialize 

func (o *Project) Initialize()

Initialize or re-initialize a Project database object to default values.

func (*Project) IsDirty 

func (o *Project) IsDirty() bool

func (*Project) LoadManager 

func (o *Project) LoadManager(ctx context.Context) *Person

LoadManager returns the related Manager. If it is not already loaded, it will attempt to load it first.

func (*Project) LoadMilestones 

func (o *Project) LoadMilestones(ctx context.Context, conditions ...interface{}) []*Milestone

LoadMilestones loads a new slice of Milestone objects and returns it.

func (*Project) Manager 

func (o *Project) Manager() *Person

Manager returns the current value of the loaded Manager, and nil if its not loaded.

func (*Project) ManagerID 

func (o *Project) ManagerID() string

func (*Project) ManagerIDIsNull 

func (o *Project) ManagerIDIsNull() bool

ManagerIDIsNull returns true if the related database value is null.

func (*Project) ManagerIDIsValid 

func (o *Project) ManagerIDIsValid() bool

ManagerIDIsValid returns true if the value was loaded from the database or has been set.

func (*Project) MarshalBinary 

func (o *Project) MarshalBinary() ([]byte, error)

MarshalBinary serializes the object into a buffer that is deserializable using UnmarshalBinary. It should be used for transmitting database objects over the wire, or for temporary storage. It does not send a version number, so if the data format changes, its up to you to invalidate the old stored objects. The framework uses this to serialize the object when it is stored in a control.

func (*Project) MarshalJSON 

func (o *Project) MarshalJSON() (data []byte, err error)

MarshalJSON serializes the object into a JSON object. Only valid data will be serialized, meaning, you can control what gets serialized by using Select to select only the fields you want when you query for the object.

func (*Project) Milestone 

func (o *Project) Milestone(pk string) *Milestone

Milestone returns a single Milestone object by primary key, if one was loaded. Otherwise, it will return nil. It will not return Milestone objects that are not saved.

func (*Project) Milestones 

func (o *Project) Milestones() []*Milestone

Milestones returns a slice of Milestone objects if loaded.

func (*Project) Name 

func (o *Project) Name() string

func (*Project) NameIsValid 

func (o *Project) NameIsValid() bool

NameIsValid returns true if the value was loaded from the database or has been set.

func (*Project) Num 

func (o *Project) Num() int

func (*Project) NumIsValid 

func (o *Project) NumIsValid() bool

NumIsValid returns true if the value was loaded from the database or has been set.

func (*Project) ParentAsChild 

func (o *Project) ParentAsChild(pk string) *Project

ParentAsChild returns a single Project object by primary key, if one was loaded otherwise, it will return nil.

func (*Project) ParentsAsChild 

func (o *Project) ParentsAsChild() []*Project

ParentsAsChild returns a slice of Project objects if loaded. If not loaded, will return nil.

func (*Project) PrimaryKey 

func (o *Project) PrimaryKey() string

func (*Project) ProjectStatusType 

func (o *Project) ProjectStatusType() ProjectStatusType

func (*Project) Save 

func (o *Project) Save(ctx context.Context)

Save will update or insert the object, depending on the state of the object. If it has any auto-generated ids, those will be updated.

func (*Project) SetBudget 

func (o *Project) SetBudget(i interface{})

func (*Project) SetChildrenAsParent added in v0.9.0 

func (o *Project) SetChildrenAsParent(objs []*Project)

SetChildrenAsParent sets the associated objects to the given slice of Project objects. It will unassociate from all previously associated objects after saving.

func (*Project) SetDescription 

func (o *Project) SetDescription(i interface{})

func (*Project) SetEndDate 

func (o *Project) SetEndDate(i interface{})

func (*Project) SetManager 

func (o *Project) SetManager(v *Person)

func (*Project) SetManagerID 

func (o *Project) SetManagerID(i interface{})

func (*Project) SetMilestones added in v0.7.0 

func (o *Project) SetMilestones(objs []*Milestone)

SetMilestones associates the given objects with the Project. WARNING! If it has items already associated with it that will not be associated after a save, those items will be DELETED since they cannot be null. If you did not use a join to query the items in the first place, used a conditional join, or joined with an expansion, be particularly careful, since you may be changing items that are not currently attached to this Project.

func (*Project) SetName 

func (o *Project) SetName(v string)

SetName sets the value of Name in the object, to be saved later using the Save() function.

func (*Project) SetNum 

func (o *Project) SetNum(v int)

SetNum sets the value of Num in the object, to be saved later using the Save() function.

func (*Project) SetParentsAsChild added in v0.9.0 

func (o *Project) SetParentsAsChild(objs []*Project)

SetParentsAsChild sets the associated objects to the given slice of Project objects. It will unassociate from all previously associated objects after saving.

func (*Project) SetProjectStatusType 

func (o *Project) SetProjectStatusType(v ProjectStatusType)

func (*Project) SetSpent 

func (o *Project) SetSpent(i interface{})

func (*Project) SetStartDate 

func (o *Project) SetStartDate(i interface{})

func (*Project) SetTeamMembers added in v0.9.0 

func (o *Project) SetTeamMembers(objs []*Person)

SetTeamMembers sets the associated objects to the given slice of Person objects. It will unassociate from all previously associated objects after saving.

func (*Project) Spent 

func (o *Project) Spent() string

func (*Project) SpentIsNull 

func (o *Project) SpentIsNull() bool

SpentIsNull returns true if the related database value is null.

func (*Project) SpentIsValid 

func (o *Project) SpentIsValid() bool

SpentIsValid returns true if the value was loaded from the database or has been set.

func (*Project) StartDate 

func (o *Project) StartDate() datetime.DateTime

func (*Project) StartDateIsNull 

func (o *Project) StartDateIsNull() bool

StartDateIsNull returns true if the related database value is null.

func (*Project) StartDateIsValid 

func (o *Project) StartDateIsValid() bool

StartDateIsValid returns true if the value was loaded from the database or has been set.

func (*Project) String 

func (o *Project) String() string

String implements the Stringer interface and returns the default label for the object as it appears in html lists. Typically you would change this to whatever was pertinent to your application.

func (*Project) TeamMember 

func (o *Project) TeamMember(pk string) *Person

TeamMember returns a single Person object by primary key, if one was loaded otherwise, it will return nil.

func (*Project) TeamMembers 

func (o *Project) TeamMembers() []*Person

TeamMembers returns a slice of Person objects if loaded. If not loaded, will return nil.

func (*Project) UnmarshalBinary 

func (o *Project) UnmarshalBinary(data []byte) (err error)

type ProjectStatusType 

type ProjectStatusType uint
const (
	ProjectStatusTypeOpen ProjectStatusType = 1

	ProjectStatusTypeCancelled ProjectStatusType = 2

	ProjectStatusTypeCompleted ProjectStatusType = 3

	ProjectStatusTypePlanned ProjectStatusType = 4
)

func AllProjectStatusTypes added in v0.9.0 

func AllProjectStatusTypes() (values []ProjectStatusType)

AllProjectStatusTypes returns a slice of all the ProjectStatusType items

func ProjectStatusTypeFromID added in v0.9.3 

func ProjectStatusTypeFromID(id string) ProjectStatusType

ProjectStatusTypeFromID converts a ProjectStatusType ID to a ProjectStatusType

func (ProjectStatusType) Description 

func (p ProjectStatusType) Description() string

func (ProjectStatusType) Guidelines 

func (p ProjectStatusType) Guidelines() string

func (ProjectStatusType) ID 

func (p ProjectStatusType) ID() string

ID returns a string representation of the id and satisfies the IDer interface

func (ProjectStatusType) IsActive 

func (p ProjectStatusType) IsActive() bool

func (ProjectStatusType) Label 

func (p ProjectStatusType) Label() string

Label returns the string that will be displayed to a user for this item. Together with the Value function, it satisfies the ItemLister interface that makes it easy to create a dropdown list of items.

func (ProjectStatusType) String 

func (p ProjectStatusType) String() string

String returns the name value of the type and satisfies the fmt.Stringer interface

func (ProjectStatusType) Value 

func (p ProjectStatusType) Value() interface{}

Value returns the value that will be used in dropdown lists and satisfies the Valuer and ItemLister interfaces.

type ProjectsBuilder 

type ProjectsBuilder struct {
	// contains filtered or unexported fields
}

The ProjectsBuilder uses the QueryBuilderI interface from the database to build a query. All query operations go through this query builder. End a query by calling either Load, Count, or Delete

func QueryProjects 

func QueryProjects(ctx context.Context) *ProjectsBuilder

QueryProjects returns a new builder that gives you general purpose access to the Project records in the database. Its here to give public access to the query builder, but you can remove it if you do not need it.

func (*ProjectsBuilder) Alias 

func (b *ProjectsBuilder) Alias(name string, n query.NodeI) *ProjectsBuilder

Alias lets you add a node with a custom name. After the query, you can read out the data using GetAlias() on a returned object. Alias is useful for adding calculations or subqueries to the query.

func (*ProjectsBuilder) Count 

func (b *ProjectsBuilder) Count(ctx context.Context, distinct bool, nodes ...query.NodeI) uint

Count terminates a query and returns just the number of items selected.

func (*ProjectsBuilder) Delete 

func (b *ProjectsBuilder) Delete(ctx context.Context)

Delete uses the query builder to delete a group of records that match the criteria

func (*ProjectsBuilder) Distinct 

func (b *ProjectsBuilder) Distinct() *ProjectsBuilder

Distinct removes duplicates from the results of the query. Adding a Select() may help you get to the data you want, although using Distinct with joined tables is often not effective, since we force joined tables to include primary keys in the query, and this often ruins the effect of Distinct.

func (*ProjectsBuilder) Expand 

func (b *ProjectsBuilder) Expand(n query.NodeI) *ProjectsBuilder

Expand expands an array type node so that it will produce individual rows instead of an array of items

func (*ProjectsBuilder) Get 

func (b *ProjectsBuilder) Get(ctx context.Context) *Project

Get is a convenience method to return only the first item found in a query. The entire query is performed, so you should generally use this only if you know you are selecting on one or very few items.

func (*ProjectsBuilder) GroupBy 

func (b *ProjectsBuilder) GroupBy(nodes ...query.NodeI) *ProjectsBuilder

GroupBy controls how results are grouped when using aggregate functions in an Alias() call.

func (*ProjectsBuilder) Having 

func (b *ProjectsBuilder) Having(node query.NodeI) *ProjectsBuilder

Having does additional filtering on the results of the query.

func (*ProjectsBuilder) Join 

func (b *ProjectsBuilder) Join(n query.NodeI, conditions ...query.NodeI) *ProjectsBuilder

Join adds a node to the node tree so that its fields will appear in the query. Optionally add conditions to filter what gets included. The conditions will be AND'd with the basic condition matching the primary keys of the join.

func (*ProjectsBuilder) Limit 

func (b *ProjectsBuilder) Limit(maxRowCount int, offset int) *ProjectsBuilder

Limit will return a subset of the data, limited to the offset and number of rows specified

func (*ProjectsBuilder) Load 

func (b *ProjectsBuilder) Load(ctx context.Context) (projectSlice []*Project)

Load terminates the query builder, performs the query, and returns a slice of Project objects. If there are any errors, they are returned in the context object. If no results come back from the query, it will return an empty slice

func (*ProjectsBuilder) LoadI 

func (b *ProjectsBuilder) LoadI(ctx context.Context) (projectSlice []interface{})

LoadI terminates the query builder, performs the query, and returns a slice of interfaces. If there are any errors, they are returned in the context object. If no results come back from the query, it will return an empty slice.

func (*ProjectsBuilder) OrderBy 

func (b *ProjectsBuilder) OrderBy(nodes ...query.NodeI) *ProjectsBuilder

OrderBy specifies how the resulting data should be sorted.

func (*ProjectsBuilder) Select 

func (b *ProjectsBuilder) Select(nodes ...query.NodeI) *ProjectsBuilder

Select optimizes the query to only return the specified fields. Once you put a Select in your query, you must specify all the fields that you will eventually read out. Be careful when selecting fields in joined tables, as joined tables will also contain pointers back to the parent table, and so the parent node should have the same field selected as the child node if you are querying those fields.

func (*ProjectsBuilder) Subquery 

func (b *ProjectsBuilder) Subquery() *query.SubqueryNode

Subquery uses the query builder to define a subquery within a larger query. You MUST include what you are selecting by adding Alias or Select functions on the subquery builder. Generally you would use this as a node to an Alias function on the surrounding query builder.

func (*ProjectsBuilder) Where 

func (b *ProjectsBuilder) Where(c query.NodeI) *ProjectsBuilder

Where adds a condition to filter what gets selected.

Source Files

View all Source files

Directories

Path Synopsis

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.