db

package
v0.0.0-...-18b278e Latest Latest
Warning

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

Go to latest
Published: Nov 8, 2017 License: MIT Imports: 24 Imported by: 0

Documentation

Index

Constants

View Source
const BlogEntryStdSelectColumns = "" /* 195-byte string literal not displayed */
View Source
const BlogEntryTable = "blog_entries"
View Source
const ClientStdSelectColumns = "clients.oid, clients.eid, clients.secret, clients.name, clients.created_on, clients.modified_on"
View Source
const ClientTable = "clients"
View Source
const ConferenceAdministratorStdSelectColumns = "" /* 220-byte string literal not displayed */
View Source
const ConferenceAdministratorTable = "conference_administrators"
View Source
const ConferenceComponentStdSelectColumns = "" /* 215-byte string literal not displayed */
View Source
const ConferenceComponentTable = "conference_components"
View Source
const ConferenceDateStdSelectColumns = "conference_dates.oid, conference_dates.eid, conference_dates.conference_id, conference_dates.open, conference_dates.close"
View Source
const ConferenceDateTable = "conference_dates"
View Source
const ConferenceSeriesAdministratorStdSelectColumns = "" /* 213-byte string literal not displayed */
View Source
const ConferenceSeriesAdministratorTable = "conference_series_administrators"
View Source
const ConferenceSeriesStdSelectColumns = "" /* 154-byte string literal not displayed */
View Source
const ConferenceSeriesTable = "conference_series"
View Source
const ConferenceStaffStdSelectColumns = "" /* 166-byte string literal not displayed */
View Source
const ConferenceStaffTable = "conference_staff"
View Source
const ConferenceStdSelectColumns = "" /* 349-byte string literal not displayed */
View Source
const ConferenceTable = "conferences"
View Source
const ConferenceVenueStdSelectColumns = "" /* 143-byte string literal not displayed */
View Source
const ConferenceVenueTable = "conference_venues"
View Source
const ExternalResourceStdSelectColumns = "" /* 223-byte string literal not displayed */
View Source
const ExternalResourceTable = "external_resources"
View Source
const FeaturedSpeakerStdSelectColumns = "" /* 261-byte string literal not displayed */
View Source
const FeaturedSpeakerTable = "featured_speakers"
View Source
const LocalizedStringStdSelectColumns = "" /* 162-byte string literal not displayed */
View Source
const LocalizedStringTable = "localized_strings"
View Source
const QuestionStdSelectColumns = "" /* 130-byte string literal not displayed */
View Source
const QuestionTable = "questions"
View Source
const RoomStdSelectColumns = "rooms.oid, rooms.eid, rooms.venue_id, rooms.name, rooms.capacity, rooms.created_on, rooms.modified_on"
View Source
const RoomTable = "rooms"
View Source
const SessionStdSelectColumns = "" /* 647-byte string literal not displayed */
View Source
const SessionTable = "sessions"
View Source
const SessionTypeStdSelectColumns = "" /* 274-byte string literal not displayed */
View Source
const SessionTypeTable = "session_types"
View Source
const SponsorStdSelectColumns = "" /* 183-byte string literal not displayed */
View Source
const SponsorTable = "sponsors"
View Source
const TemporaryEmailStdSelectColumns = "" /* 134-byte string literal not displayed */
View Source
const TemporaryEmailTable = "temporary_emails"
View Source
const TrackStdSelectColumns = "" /* 131-byte string literal not displayed */
View Source
const TrackTable = "tracks"
View Source
const UserStdSelectColumns = "" /* 238-byte string literal not displayed */
View Source
const UserTable = "users"
View Source
const VenueStdSelectColumns = "" /* 154-byte string literal not displayed */
View Source
const VenueTable = "venues"

Variables

View Source
var ErrNoTLSRequested = errors.New("TLS environment variables not set")
View Source
var Trace bool

Functions

func BeginTx

func BeginTx(ctx context.Context, opt *sql.TxOptions) (*sql.Tx, error)

func ConfigureDSN

func ConfigureDSN() (tlsname string, err error)

func DeleteConferenceAdministrator

func DeleteConferenceAdministrator(tx *sql.Tx, cid, uid string) error

func DeleteConferenceComponentsByIDAndName

func DeleteConferenceComponentsByIDAndName(tx *sql.Tx, conferenceID string, names ...string) error

func DeleteConferenceStaff

func DeleteConferenceStaff(tx *sql.Tx, cid, uid string) error

func DeleteConferenceVenue

func DeleteConferenceVenue(tx *sql.Tx, cid, vid string) error

func DeleteLocalizedStringsForParent

func DeleteLocalizedStringsForParent(tx *sql.Tx, parentID, parentType string) error

func DeleteTracks

func DeleteTracks(tx *sql.Tx, conferenceID string) (err error)

func Init

func Init(dsn string) (err error)

func IsAcceptingSubmissions

func IsAcceptingSubmissions(tx *sql.Tx, id string) error

func IsAdministrator

func IsAdministrator(tx *sql.Tx, userID string) error

func IsConferenceAdministrator

func IsConferenceAdministrator(tx *sql.Tx, cid, uid string) error

func IsConferenceSeriesAdministrator

func IsConferenceSeriesAdministrator(tx *sql.Tx, sid, uid string) error

func IsSessionOwner

func IsSessionOwner(tx *sql.Tx, sessionID, userID string) (err error)

func ListConferencesByOrganizer

func ListConferencesByOrganizer(tx *sql.Tx, l *ConferenceList, orgID string, statuses []string, since string, limit int) error

func LoadConferenceAdministrators

func LoadConferenceAdministrators(tx *sql.Tx, admins *UserList, cid string) error

func LoadConferenceStaff

func LoadConferenceStaff(tx *sql.Tx, admins *UserList, cid string) error

func LoadConferenceVenues

func LoadConferenceVenues(tx *sql.Tx, venues *VenueList, cid string) (err error)

func LoadFeaturedSpeakers

func LoadFeaturedSpeakers(tx *sql.Tx, venues *FeaturedSpeakerList, cid string) error

func LoadSessionTypes

func LoadSessionTypes(tx *sql.Tx, list *SessionTypeList, cid string) error

func LoadSponsors

func LoadSponsors(tx *sql.Tx, venues *SponsorList, cid string) error

func LoadVenueRooms

func LoadVenueRooms(tx *sql.Tx, rooms *RoomList, vid string) error

func UpsertConferenceComponentsByIDAndName

func UpsertConferenceComponentsByIDAndName(tx *sql.Tx, conferenceID string, values map[string]string) error

Types

type BlogEntry

type BlogEntry struct {
	OID          int64
	EID          string
	ConferenceID string
	Title        string
	URL          string
	URLHash      string
	Status       string
	CreatedOn    time.Time
	ModifiedOn   NullTime
}

+DB tablename:"blog_entries"

func (*BlogEntry) Create

func (b *BlogEntry) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (BlogEntry) Delete

func (b BlogEntry) Delete(tx *sql.Tx) error

func (*BlogEntry) LoadByEID

func (b *BlogEntry) LoadByEID(tx *sql.Tx, eid string) (err error)

func (*BlogEntry) Scan

func (b *BlogEntry) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (BlogEntry) Update

func (b BlogEntry) Update(tx *sql.Tx) (err error)

type BlogEntryList

type BlogEntryList []BlogEntry

func (*BlogEntryList) FromRows

func (v *BlogEntryList) FromRows(rows *sql.Rows, capacity int) error

func (*BlogEntryList) LoadByConference

func (v *BlogEntryList) LoadByConference(tx *sql.Tx, confID string, status []string) (err error)

func (*BlogEntryList) LoadSince

func (v *BlogEntryList) LoadSince(tx *sql.Tx, since int64, limit int) error

func (*BlogEntryList) LoadSinceEID

func (v *BlogEntryList) LoadSinceEID(tx *sql.Tx, since string, limit int) error

type Client

type Client struct {
	OID        int64
	EID        string
	Secret     string
	Name       string
	CreatedOn  time.Time
	ModifiedOn NullTime
}

+DB tablename:"clients"

func (*Client) Create

func (c *Client) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (Client) Delete

func (c Client) Delete(tx *sql.Tx) error

func (*Client) LoadByEID

func (c *Client) LoadByEID(tx *sql.Tx, eid string) (err error)

func (*Client) Scan

func (c *Client) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (Client) Update

func (c Client) Update(tx *sql.Tx) (err error)

type ClientList

type ClientList []Client

func (*ClientList) FromRows

func (v *ClientList) FromRows(rows *sql.Rows, capacity int) error

func (*ClientList) LoadSince

func (v *ClientList) LoadSince(tx *sql.Tx, since int64, limit int) error

func (*ClientList) LoadSinceEID

func (v *ClientList) LoadSinceEID(tx *sql.Tx, since string, limit int) error

type Conference

type Conference struct {
	OID                   int64  // intenral id, used for sorting and what not
	EID                   string // ID that is visible to the outside
	CoverURL              sql.NullString
	RedirectURL           sql.NullString
	SeriesID              string // ConferenceSeries ID
	Slug                  string
	Status                string
	SubTitle              sql.NullString
	Title                 string
	BlogFeedbackAvailable bool // true if we are collecting/displaying blog feed back
	TimetableAvailable    bool
	Timezone              string
	CreatedBy             string // User ID that creates this conference
	CreatedOn             time.Time
	ModifiedOn            NullTime
}

+DB tablename:"conferences"

func (*Conference) Create

func (c *Conference) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (Conference) Delete

func (c Conference) Delete(tx *sql.Tx) error

func (*Conference) LoadByEID

func (c *Conference) LoadByEID(tx *sql.Tx, eid string) (err error)

func (*Conference) Scan

func (c *Conference) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (Conference) Update

func (c Conference) Update(tx *sql.Tx) (err error)

type ConferenceAdministrator

type ConferenceAdministrator struct {
	OID          int64 // OID is the internal id, used for sorting and what not
	ConferenceID string
	UserID       string
	SortOrder    int
	CreatedOn    time.Time
	ModifiedOn   NullTime
}

+DB tablename:"conference_administrators"

func (*ConferenceAdministrator) Create

func (c *ConferenceAdministrator) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (ConferenceAdministrator) Delete

func (c ConferenceAdministrator) Delete(tx *sql.Tx) error

func (*ConferenceAdministrator) Scan

func (c *ConferenceAdministrator) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (ConferenceAdministrator) Update

func (c ConferenceAdministrator) Update(tx *sql.Tx) (err error)

type ConferenceAdministratorList

type ConferenceAdministratorList []ConferenceAdministrator

func (*ConferenceAdministratorList) FromRows

func (v *ConferenceAdministratorList) FromRows(rows *sql.Rows, capacity int) error

type ConferenceComponent

type ConferenceComponent struct {
	OID          int64  // intenral id, used for sorting and what not
	EID          string // ID that is visible to the outside
	ConferenceID string
	Name         string
	Value        string
	CreatedOn    time.Time
	ModifiedOn   NullTime
}

+DB tablename:"conference_components"

func (*ConferenceComponent) Create

func (c *ConferenceComponent) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (ConferenceComponent) Delete

func (c ConferenceComponent) Delete(tx *sql.Tx) error

func (*ConferenceComponent) LoadByEID

func (c *ConferenceComponent) LoadByEID(tx *sql.Tx, eid string) (err error)

func (*ConferenceComponent) Scan

func (c *ConferenceComponent) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (ConferenceComponent) Update

func (c ConferenceComponent) Update(tx *sql.Tx) (err error)

type ConferenceComponentList

type ConferenceComponentList []ConferenceComponent

func (*ConferenceComponentList) FromRows

func (v *ConferenceComponentList) FromRows(rows *sql.Rows, capacity int) error

func (*ConferenceComponentList) LoadByConferenceID

func (ccl *ConferenceComponentList) LoadByConferenceID(tx *sql.Tx, cid string) error

func (*ConferenceComponentList) LoadSince

func (v *ConferenceComponentList) LoadSince(tx *sql.Tx, since int64, limit int) error

func (*ConferenceComponentList) LoadSinceEID

func (v *ConferenceComponentList) LoadSinceEID(tx *sql.Tx, since string, limit int) error

type ConferenceDate

type ConferenceDate struct {
	OID          int64
	EID          string
	ConferenceID string
	Open         NullTime
	Close        NullTime
}

+DB tablename:"conference_dates"

func (*ConferenceDate) Create

func (c *ConferenceDate) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (ConferenceDate) Delete

func (c ConferenceDate) Delete(tx *sql.Tx) error

func (*ConferenceDate) DeleteDate

func (cd *ConferenceDate) DeleteDate(tx *sql.Tx, cid, eid string) error

func (*ConferenceDate) LoadByEID

func (c *ConferenceDate) LoadByEID(tx *sql.Tx, eid string) (err error)

func (*ConferenceDate) Scan

func (c *ConferenceDate) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (ConferenceDate) Update

func (c ConferenceDate) Update(tx *sql.Tx) (err error)

type ConferenceDateList

type ConferenceDateList []ConferenceDate

func (*ConferenceDateList) FromRows

func (v *ConferenceDateList) FromRows(rows *sql.Rows, capacity int) error

func (*ConferenceDateList) LoadByConferenceID

func (cdl *ConferenceDateList) LoadByConferenceID(tx *sql.Tx, cid string) error

func (*ConferenceDateList) LoadSince

func (v *ConferenceDateList) LoadSince(tx *sql.Tx, since int64, limit int) error

func (*ConferenceDateList) LoadSinceEID

func (v *ConferenceDateList) LoadSinceEID(tx *sql.Tx, since string, limit int) error

type ConferenceList

type ConferenceList []Conference

func (*ConferenceList) FromRows

func (v *ConferenceList) FromRows(rows *sql.Rows, capacity int) error

func (*ConferenceList) LoadByRange

func (v *ConferenceList) LoadByRange(tx *sql.Tx, since string, rangeStart, rangeEnd time.Time, limit int) error

func (*ConferenceList) LoadFromQuery

func (v *ConferenceList) LoadFromQuery(tx *sql.Tx, status, organizerID []string, rangeStart, rangeEnd time.Time, since string, limit int) error

func (*ConferenceList) LoadSince

func (v *ConferenceList) LoadSince(tx *sql.Tx, since int64, limit int) error

func (*ConferenceList) LoadSinceEID

func (v *ConferenceList) LoadSinceEID(tx *sql.Tx, since string, limit int) error

type ConferenceSeries

type ConferenceSeries struct {
	OID        int64  // intenral id, used for sorting and what not
	EID        string // ID that is visible to the outside
	Slug       string
	Title      string
	CreatedOn  time.Time
	ModifiedOn NullTime
}

+DB tablename:"conference_series"

func (*ConferenceSeries) Create

func (c *ConferenceSeries) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (ConferenceSeries) Delete

func (c ConferenceSeries) Delete(tx *sql.Tx) error

func (*ConferenceSeries) LoadByEID

func (c *ConferenceSeries) LoadByEID(tx *sql.Tx, eid string) (err error)

func (*ConferenceSeries) Scan

func (c *ConferenceSeries) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (ConferenceSeries) Update

func (c ConferenceSeries) Update(tx *sql.Tx) (err error)

type ConferenceSeriesAdministrator

type ConferenceSeriesAdministrator struct {
	OID        int64 // OID is the internal id, used for sorting and what not
	SeriesID   string
	UserID     string
	CreatedOn  time.Time
	ModifiedOn NullTime
}

+DB tablename:"conference_series_administrators"

func (*ConferenceSeriesAdministrator) Create

func (c *ConferenceSeriesAdministrator) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (ConferenceSeriesAdministrator) Delete

func (c ConferenceSeriesAdministrator) Delete(tx *sql.Tx) error

func (*ConferenceSeriesAdministrator) Scan

func (c *ConferenceSeriesAdministrator) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (ConferenceSeriesAdministrator) Update

func (c ConferenceSeriesAdministrator) Update(tx *sql.Tx) (err error)

type ConferenceSeriesAdministratorList

type ConferenceSeriesAdministratorList []ConferenceSeriesAdministrator

func (*ConferenceSeriesAdministratorList) FromRows

func (v *ConferenceSeriesAdministratorList) FromRows(rows *sql.Rows, capacity int) error

type ConferenceSeriesList

type ConferenceSeriesList []ConferenceSeries

func (*ConferenceSeriesList) FromRows

func (v *ConferenceSeriesList) FromRows(rows *sql.Rows, capacity int) error

func (*ConferenceSeriesList) LoadSince

func (v *ConferenceSeriesList) LoadSince(tx *sql.Tx, since int64, limit int) error

func (*ConferenceSeriesList) LoadSinceEID

func (v *ConferenceSeriesList) LoadSinceEID(tx *sql.Tx, since string, limit int) error

type ConferenceStaff

type ConferenceStaff struct {
	OID          int64 // OID is the internal id, used for sorting and what not
	ConferenceID string
	UserID       string
	SortOrder    int
	CreatedOn    time.Time
	ModifiedOn   NullTime
}

+DB tablename:"conference_staff"

func (*ConferenceStaff) Create

func (c *ConferenceStaff) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (ConferenceStaff) Delete

func (c ConferenceStaff) Delete(tx *sql.Tx) error

func (*ConferenceStaff) Scan

func (c *ConferenceStaff) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (ConferenceStaff) Update

func (c ConferenceStaff) Update(tx *sql.Tx) (err error)

type ConferenceStaffList

type ConferenceStaffList []ConferenceStaff

func (*ConferenceStaffList) FromRows

func (v *ConferenceStaffList) FromRows(rows *sql.Rows, capacity int) error

type ConferenceVenue

type ConferenceVenue struct {
	OID          int64 // OID is the internal id, used for sorting and what not
	ConferenceID string
	VenueID      string
	CreatedOn    time.Time
	ModifiedOn   NullTime
}

+DB tablename:"conference_venues"

func (*ConferenceVenue) Create

func (c *ConferenceVenue) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (ConferenceVenue) Delete

func (c ConferenceVenue) Delete(tx *sql.Tx) error

func (*ConferenceVenue) Scan

func (c *ConferenceVenue) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (ConferenceVenue) Update

func (c ConferenceVenue) Update(tx *sql.Tx) (err error)

type ConferenceVenueList

type ConferenceVenueList []ConferenceVenue

func (*ConferenceVenueList) FromRows

func (v *ConferenceVenueList) FromRows(rows *sql.Rows, capacity int) error

type Config

type Config struct {
	DSN string // DSN, can be a template string
}

type DB

type DB struct {
	*guard.DB
}

type ExternalResource

type ExternalResource struct {
	OID          int64
	EID          string
	ConferenceID string
	Description  string
	ImageURL     sql.NullString
	Title        string
	URL          string
	SortOrder    int
}

+DB tablename:"external_resources"

func (*ExternalResource) Create

func (e *ExternalResource) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (ExternalResource) Delete

func (e ExternalResource) Delete(tx *sql.Tx) error

func (*ExternalResource) LoadByEID

func (e *ExternalResource) LoadByEID(tx *sql.Tx, eid string) (err error)

func (*ExternalResource) Scan

func (e *ExternalResource) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (ExternalResource) Update

func (e ExternalResource) Update(tx *sql.Tx) (err error)

type ExternalResourceList

type ExternalResourceList []ExternalResource

func (*ExternalResourceList) FromRows

func (v *ExternalResourceList) FromRows(rows *sql.Rows, capacity int) error

func (*ExternalResourceList) LoadByConference

func (v *ExternalResourceList) LoadByConference(tx *sql.Tx, conferenceID string) (err error)

func (*ExternalResourceList) LoadSince

func (v *ExternalResourceList) LoadSince(tx *sql.Tx, since int64, limit int) error

func (*ExternalResourceList) LoadSinceEID

func (v *ExternalResourceList) LoadSinceEID(tx *sql.Tx, since string, limit int) error

type FeaturedSpeaker

type FeaturedSpeaker struct {
	OID          int64
	EID          string
	ConferenceID string
	SpeakerID    sql.NullString
	AvatarURL    sql.NullString
	DisplayName  string
	Description  string
	CreatedOn    time.Time
	ModifiedOn   NullTime
}

+DB tablename:"featured_speakers"

func (*FeaturedSpeaker) Create

func (f *FeaturedSpeaker) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (FeaturedSpeaker) Delete

func (f FeaturedSpeaker) Delete(tx *sql.Tx) error

func (*FeaturedSpeaker) LoadByEID

func (f *FeaturedSpeaker) LoadByEID(tx *sql.Tx, eid string) (err error)

func (*FeaturedSpeaker) Scan

func (f *FeaturedSpeaker) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (FeaturedSpeaker) Update

func (f FeaturedSpeaker) Update(tx *sql.Tx) (err error)

type FeaturedSpeakerList

type FeaturedSpeakerList []FeaturedSpeaker

func (*FeaturedSpeakerList) FromRows

func (v *FeaturedSpeakerList) FromRows(rows *sql.Rows, capacity int) error

func (*FeaturedSpeakerList) LoadByConferenceSince

func (v *FeaturedSpeakerList) LoadByConferenceSince(tx *sql.Tx, confID string, since int64, limit int) error

func (*FeaturedSpeakerList) LoadByConferenceSinceEID

func (v *FeaturedSpeakerList) LoadByConferenceSinceEID(tx *sql.Tx, confID, since string, limit int) error

func (*FeaturedSpeakerList) LoadSince

func (v *FeaturedSpeakerList) LoadSince(tx *sql.Tx, since int64, limit int) error

func (*FeaturedSpeakerList) LoadSinceEID

func (v *FeaturedSpeakerList) LoadSinceEID(tx *sql.Tx, since string, limit int) error

type InsertOption

type InsertOption interface{}

func WithInsertIgnore

func WithInsertIgnore(b bool) InsertOption

type LocalizedString

type LocalizedString struct {
	OID        int64
	ParentID   string // EID of the parent object
	ParentType string // Type of the parent object
	Name       string
	Language   string
	Localized  string
}

+DB tablename:"localized_strings"

func (*LocalizedString) Create

func (l *LocalizedString) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (LocalizedString) Delete

func (l LocalizedString) Delete(tx *sql.Tx) error

func (*LocalizedString) LoadByLangKey

func (l *LocalizedString) LoadByLangKey(tx *sql.Tx, language, name, parentType, parentID string) error

func (*LocalizedString) Scan

func (l *LocalizedString) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (LocalizedString) Update

func (l LocalizedString) Update(tx *sql.Tx) (err error)

func (*LocalizedString) Upsert

func (l *LocalizedString) Upsert(tx *sql.Tx) (err error)

type LocalizedStringList

type LocalizedStringList []LocalizedString

func LoadLocalizedStringsForParent

func LoadLocalizedStringsForParent(tx *sql.Tx, parentID, parentType string) (LocalizedStringList, error)

func (*LocalizedStringList) FromRows

func (v *LocalizedStringList) FromRows(rows *sql.Rows, capacity int) error

type NullTime

type NullTime struct {
	mysql.NullTime
}

type Question

type Question struct {
	OID        int64
	EID        string
	SessionID  string
	UserID     string
	Body       string
	CreatedOn  time.Time
	ModifiedOn NullTime
}

+DB tablename:"questions"

func (*Question) Create

func (q *Question) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (Question) Delete

func (q Question) Delete(tx *sql.Tx) error

func (*Question) LoadByEID

func (q *Question) LoadByEID(tx *sql.Tx, eid string) (err error)

func (*Question) Scan

func (q *Question) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (Question) Update

func (q Question) Update(tx *sql.Tx) (err error)

type QuestionList

type QuestionList []Question

func (*QuestionList) FromRows

func (v *QuestionList) FromRows(rows *sql.Rows, capacity int) error

func (*QuestionList) LoadSince

func (v *QuestionList) LoadSince(tx *sql.Tx, since int64, limit int) error

func (*QuestionList) LoadSinceEID

func (v *QuestionList) LoadSinceEID(tx *sql.Tx, since string, limit int) error

type Room

type Room struct {
	OID        int64  // intenral id, used for sorting and what not
	EID        string // ID that is visible to the outside
	VenueID    string // ID of the venue that this room belongs to
	Name       string // Name of the room (English)
	Capacity   uint   // How many people fit in this room? Approximation.
	CreatedOn  time.Time
	ModifiedOn NullTime
}

+DB tablename:"rooms"

func (*Room) Create

func (r *Room) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (Room) Delete

func (r Room) Delete(tx *sql.Tx) error

func (*Room) LoadByEID

func (r *Room) LoadByEID(tx *sql.Tx, eid string) (err error)

func (*Room) Scan

func (r *Room) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (Room) Update

func (r Room) Update(tx *sql.Tx) (err error)

type RoomList

type RoomList []Room

func (*RoomList) FromRows

func (v *RoomList) FromRows(rows *sql.Rows, capacity int) error

func (*RoomList) LoadForVenueSince

func (v *RoomList) LoadForVenueSince(tx *sql.Tx, venueID string, since int64, limit int) error

func (*RoomList) LoadForVenueSinceEID

func (v *RoomList) LoadForVenueSinceEID(tx *sql.Tx, venueID string, since string, limit int) error

func (*RoomList) LoadSince

func (v *RoomList) LoadSince(tx *sql.Tx, since int64, limit int) error

func (*RoomList) LoadSinceEID

func (v *RoomList) LoadSinceEID(tx *sql.Tx, since string, limit int) error

type Session

type Session struct {
	OID                 int64          // OID is the internal id, used for sorting and what not
	EID                 string         // EID is the ID that is visible to the outside
	ConferenceID        string         // ConferenceID is the ID of the conference that this session belongs to
	RoomID              sql.NullString // ID of the room where this session will be held at.
	SpeakerID           string         // ID of the speaker that this session belongs to
	SessionTypeID       string         // ID of the session type
	Title               sql.NullString // Title of the session (English)
	Abstract            sql.NullString // Abstract of the session (English)
	Memo                sql.NullString // Correspondence between the speaker and the organizer. Should not be publicly available
	StartsOn            NullTime       // Time that this session is scheduled to start on
	Duration            int            // Length of this session in minutes.
	MaterialLevel       sql.NullString
	Tags                sql.NullString // Comma separated tags
	Category            sql.NullString
	SelectionResultSent bool
	SpokenLanguage      sql.NullString
	SlideLanguage       sql.NullString
	SlideSubtitles      sql.NullString
	SlideURL            sql.NullString
	VideoURL            sql.NullString
	PhotoRelease        sql.NullString
	RecordingRelease    sql.NullString
	MaterialsRelease    sql.NullString
	HasInterpretation   bool
	IsVoteTarget        bool
	Status              string
	SortOrder           int
	Confirmed           bool
	CreatedOn           time.Time
	ModifiedOn          NullTime
}

+DB tablename:"sessions"

func (*Session) Create

func (s *Session) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (Session) Delete

func (s Session) Delete(tx *sql.Tx) error

func (*Session) LoadByEID

func (s *Session) LoadByEID(tx *sql.Tx, eid string) (err error)

func (*Session) Scan

func (s *Session) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (Session) Update

func (s Session) Update(tx *sql.Tx) (err error)

type SessionList

type SessionList []Session

func (*SessionList) FromRows

func (v *SessionList) FromRows(rows *sql.Rows, capacity int) error

func (*SessionList) LoadByConference

func (v *SessionList) LoadByConference(tx *sql.Tx, conferenceID, speakerID string, rangeStart, rangeEnd time.Time, status []string, confirmed []bool) (err error)

func (*SessionList) LoadSince

func (v *SessionList) LoadSince(tx *sql.Tx, since int64, limit int) error

func (*SessionList) LoadSinceEID

func (v *SessionList) LoadSinceEID(tx *sql.Tx, since string, limit int) error

type SessionType

type SessionType struct {
	OID             int64  // OID is the internal id, used for sorting and what not
	EID             string // EID is the ID that is visible to the outside
	ConferenceID    string // ConferenceID is the ID of the conference that this session belongs to
	Name            string
	Abstract        string
	Duration        int
	IsDefault       bool
	SubmissionStart NullTime
	SubmissionEnd   NullTime
	CreatedOn       time.Time
	ModifiedOn      NullTime
}

+DB tablename:"session_types"

func (*SessionType) Create

func (s *SessionType) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (SessionType) Delete

func (s SessionType) Delete(tx *sql.Tx) error

func (*SessionType) LoadByEID

func (s *SessionType) LoadByEID(tx *sql.Tx, eid string) (err error)

func (*SessionType) Scan

func (s *SessionType) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (SessionType) Update

func (s SessionType) Update(tx *sql.Tx) (err error)

type SessionTypeList

type SessionTypeList []SessionType

func (*SessionTypeList) FromRows

func (v *SessionTypeList) FromRows(rows *sql.Rows, capacity int) error

func (*SessionTypeList) LoadByConferenceSince

func (v *SessionTypeList) LoadByConferenceSince(tx *sql.Tx, confID string, since int64, limit int) error

func (*SessionTypeList) LoadByConferenceSinceEID

func (v *SessionTypeList) LoadByConferenceSinceEID(tx *sql.Tx, confID, since string, limit int) error

func (*SessionTypeList) LoadSince

func (v *SessionTypeList) LoadSince(tx *sql.Tx, since int64, limit int) error

func (*SessionTypeList) LoadSinceEID

func (v *SessionTypeList) LoadSinceEID(tx *sql.Tx, since string, limit int) error
type Sponsor struct {
	OID          int64
	EID          string
	ConferenceID string
	Name         string
	LogoURL      sql.NullString
	URL          string
	GroupName    string
	SortOrder    int
	CreatedOn    time.Time
	ModifiedOn   NullTime
}

+DB tablename:"sponsors"

func (*Sponsor) Create

func (s *Sponsor) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (Sponsor) Delete

func (s Sponsor) Delete(tx *sql.Tx) error

func (*Sponsor) LoadByEID

func (s *Sponsor) LoadByEID(tx *sql.Tx, eid string) (err error)

func (*Sponsor) Scan

func (s *Sponsor) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (Sponsor) Update

func (s Sponsor) Update(tx *sql.Tx) (err error)

type SponsorList

type SponsorList []Sponsor

func (*SponsorList) FromRows

func (v *SponsorList) FromRows(rows *sql.Rows, capacity int) error

func (*SponsorList) LoadByConferenceSince

func (v *SponsorList) LoadByConferenceSince(tx *sql.Tx, confID string, since int64, limit int) error

func (*SponsorList) LoadByConferenceSinceEID

func (v *SponsorList) LoadByConferenceSinceEID(tx *sql.Tx, confID, since string, limit int) error

func (*SponsorList) LoadSince

func (v *SponsorList) LoadSince(tx *sql.Tx, since int64, limit int) error

func (*SponsorList) LoadSinceEID

func (v *SponsorList) LoadSinceEID(tx *sql.Tx, since string, limit int) error

type StmtItem

type StmtItem struct {
	Text string
	Stmt *sql.Stmt
	// contains filtered or unexported fields
}

type StmtKey

type StmtKey [sha512.Size]byte

type StmtPool

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

type TemporaryEmail

type TemporaryEmail struct {
	OID             int64
	UserID          string
	ConfirmationKey string
	Email           string
	ExpiresOn       time.Time
}

+DB tablename:"temporary_emails"

func (*TemporaryEmail) Create

func (t *TemporaryEmail) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (TemporaryEmail) Delete

func (t TemporaryEmail) Delete(tx *sql.Tx) error

func (*TemporaryEmail) LoadByUserIDAndConfirmationKey

func (vdb *TemporaryEmail) LoadByUserIDAndConfirmationKey(tx *sql.Tx, userID, confirmationKey string) error

func (*TemporaryEmail) Scan

func (t *TemporaryEmail) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (TemporaryEmail) Update

func (t TemporaryEmail) Update(tx *sql.Tx) (err error)

func (*TemporaryEmail) Upsert

func (vdb *TemporaryEmail) Upsert(tx *sql.Tx) error

type TemporaryEmailList

type TemporaryEmailList []TemporaryEmail

func (*TemporaryEmailList) FromRows

func (v *TemporaryEmailList) FromRows(rows *sql.Rows, capacity int) error

type Track

type Track struct {
	OID          int64
	EID          string
	ConferenceID string
	RoomID       string
	Name         string
	SortOrder    int
	CreatedOn    time.Time
	ModifiedOn   NullTime
}

+DB tablename:"tracks"

func (*Track) Create

func (t *Track) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (Track) Delete

func (t Track) Delete(tx *sql.Tx) error

func (*Track) Load

func (vdb *Track) Load(tx *sql.Tx, conferenceID, roomID string) (err error)

func (*Track) LoadByEID

func (t *Track) LoadByEID(tx *sql.Tx, eid string) (err error)

func (*Track) Scan

func (t *Track) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (Track) Update

func (t Track) Update(tx *sql.Tx) (err error)

type TrackList

type TrackList []Track

func (*TrackList) FromRows

func (v *TrackList) FromRows(rows *sql.Rows, capacity int) error

func (*TrackList) LoadByConferenceID

func (v *TrackList) LoadByConferenceID(tx *sql.Tx, conferenceID string) (err error)

func (*TrackList) LoadSince

func (v *TrackList) LoadSince(tx *sql.Tx, since int64, limit int) error

func (*TrackList) LoadSinceEID

func (v *TrackList) LoadSinceEID(tx *sql.Tx, since string, limit int) error

type Tx

type Tx struct {
	*guard.Tx
}

type User

type User struct {
	OID        int64
	EID        string
	AuthVia    string
	AuthUserID string
	AvatarURL  sql.NullString
	FirstName  sql.NullString
	LastName   sql.NullString
	Lang       string
	Nickname   string
	Email      sql.NullString
	TshirtSize sql.NullString
	IsAdmin    bool
	Timezone   string
	CreatedOn  time.Time
	ModifiedOn NullTime
}

+DB tablename:"users"

func (*User) Create

func (u *User) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (User) Delete

func (u User) Delete(tx *sql.Tx) error

func (*User) LoadByAuthUserID

func (vdb *User) LoadByAuthUserID(tx *sql.Tx, via, id string) error

func (*User) LoadByEID

func (u *User) LoadByEID(tx *sql.Tx, eid string) (err error)

func (*User) Scan

func (u *User) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (User) Update

func (u User) Update(tx *sql.Tx) (err error)

type UserList

type UserList []User

func (*UserList) FromRows

func (v *UserList) FromRows(rows *sql.Rows, capacity int) error

func (*UserList) LoadFromQuery

func (vdbl *UserList) LoadFromQuery(tx *sql.Tx, pattern, since string, limit int) error

func (*UserList) LoadSince

func (v *UserList) LoadSince(tx *sql.Tx, since int64, limit int) error

func (*UserList) LoadSinceEID

func (v *UserList) LoadSinceEID(tx *sql.Tx, since string, limit int) error

type Venue

type Venue struct {
	OID        int64  // intenral id, used for sorting and what not
	EID        string // ID that is visible to the outside
	Name       string // Name of the venue (English)
	Address    string
	PlaceID    sql.NullString
	URL        sql.NullString
	Latitude   float64
	Longitude  float64
	CreatedOn  time.Time
	ModifiedOn NullTime
}

+DB tablename:"venues"

func (*Venue) Create

func (v *Venue) Create(tx *sql.Tx, opts ...InsertOption) (err error)

func (Venue) Delete

func (v Venue) Delete(tx *sql.Tx) error

func (*Venue) LoadByEID

func (v *Venue) LoadByEID(tx *sql.Tx, eid string) (err error)

func (*Venue) Scan

func (v *Venue) Scan(scanner interface {
	Scan(...interface{}) error
}) error

func (Venue) Update

func (v Venue) Update(tx *sql.Tx) (err error)

type VenueList

type VenueList []Venue

func (*VenueList) FromRows

func (v *VenueList) FromRows(rows *sql.Rows, capacity int) error

func (*VenueList) LoadSince

func (v *VenueList) LoadSince(tx *sql.Tx, since int64, limit int) error

func (*VenueList) LoadSinceEID

func (v *VenueList) LoadSinceEID(tx *sql.Tx, since string, limit int) error

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL