Documentation
¶
Index ¶
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
This section is empty.
Types ¶
type Companies ¶
type Companies struct {
ot.Fact[any]
Company_id uuid.UUID `fact:"key"`
Company_name string
Industry string
City string
State string
Plan string
Created_at time.Time
}
func NewCompanies ¶
type Companiesdb ¶
type Companiesdb struct {
Queries map[string]*query
SubQueries map[string]*subquery
Db *mayfairdb.DataSortDb
// contains filtered or unexported fields
}
func NewCompaniesdb ¶
func NewCompaniesdb(db *mayfairdb.DataSortDb) *Companiesdb
func (*Companiesdb) Generate ¶
func (b *Companiesdb) Generate()
func (*Companiesdb) GenerateQueries ¶
func (b *Companiesdb) GenerateQueries()
func (*Companiesdb) GenerateSubQueries ¶
func (b *Companiesdb) GenerateSubQueries()
GenerateSubQueries will produce the necessary basic queries like 'SELECT id FROM tracks WHERE track.country = "USA"' There are subqueries that are part of a query, possibly combined through a set operation like UNION, INTERSECT, etc. These queries will have an id like 'sql2.sq.434'
Other types of subqueries are used in other subqueries like in 'SELECT id FROM (SELECT * FROM tracks WHERE track.country = "USA")' these will have an id different from the query's subqueries, e.g. 'sql36.ta.456'
type Contacts ¶
type Contacts struct {
ot.Fact[any]
Contact_id uuid.UUID `fact:"key"`
Company_id uuid.UUID
First_name string
Last_name string
Email string
Phone string
Job_title string
Department string
}
func NewContacts ¶
Click to show internal directories.
Click to hide internal directories.