Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security Policy
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

db

package

Go to main page

Versions in this module

v2

v2.1.4

Oct 15, 2023

v2.1.3

Aug 12, 2023

v2.1.1

Apr 25, 2023

v2.1.0

Apr 21, 2023

Changes in this version

+ func ClearAuthorizedBrowsers(ctx context.Context, date string) (rowsDeleted int64, err error)

+ func ClearUserLogins(ctx context.Context, date string) (rowsDeleted int64, err error)

type ActivityLog

+ Referrer string

v2.1.0-beta3

Apr 21, 2023

v2.1.0-beta2

Apr 21, 2023

v2.1.0-beta1

Apr 20, 2023

v2.0.4

Aug 20, 2022

v2.0.3

Jul 8, 2022

v2.0.2

Jul 8, 2022

Changes in this version

+ const CustomFieldTypeBoolean

+ const CustomFieldTypeDate

+ const CustomFieldTypeDecimal

+ const CustomFieldTypeInteger

+ const CustomFieldTypeMultiChoice

+ const CustomFieldTypeText

+ const Enable2FAForAll

+ const InitialUserUsername

+ const TableAPIKeys

+ const TableActivityLog

+ const TableAppSettings

+ const TableApps

+ const TableAuthorizedBrowsers

+ const TableCustomFieldDefined

+ const TableCustomFieldResults

+ const TableDownloadHistory

+ const TableKeyPairs

+ const TableKeyValue

+ const TableLicenseNotes

+ const TableLicenses

+ const TableRenewalRelationships

+ const TableUserLogins

+ const TableUsers

+ var DeployFuncs = []sqldb.DeployFunc

+ var DeployQueries = []string

+ var ErrAppSettingDisabled = errors.New("app setting is turned off")

+ var ErrCouldNotFindMatchingField = errors.New("could not find matching result for defined field")

+ var ErrInputInvalid = errors.New("db: input invalid")

+ var ErrNoUser2FAEnabled = errors.New("no user has 2 factor auth enabled")

+ var UpdateQueries = []string

+ func ClearActivityLog(ctx context.Context, date string) (rowsDeleted int64, err error)

+ func DisableAllAuthorizedBrowsers(ctx context.Context, userID int64) (err error)

+ func DisableLicense(ctx context.Context, licenseID int64, tx *sqlx.Tx) (err error)

+ func DisableLoginsForUser(ctx context.Context, userID int64) (err error)

+ func Enable2FA(ctx context.Context, userID int64, turnOn bool) (err error)

+ func GetDateInConfigTimezone(input string) (output string)

+ func GetDatetimeInConfigTimezone(input string) (output string)

+ func GetPublicKeyByID(ctx context.Context, id int64) (publicKey string, err error)

+ func RevokeAPIKey(ctx context.Context, id int64) error

+ func Save2FASecret(ctx context.Context, userID int64, secret string) (err error)

+ func Set2FABadAttempts(ctx context.Context, userID int64, badValue uint8) error

+ func SetNewPassword(ctx context.Context, userID int64, passwordHash string) (err error)

+ func SetPasswordBadAttempts(ctx context.Context, userID int64, badValue uint8) error

+ type APIKey struct

+ Active bool

+ CreatedByUserID int64

+ CreatedByUsername string

+ DatetimeCreated string

+ DatetimeCreatedTZ string

+ DatetimeModified string

+ Description string

+ ID int64

+ K string

+ Timezone string

+ func GetAPIKeyByDescription(ctx context.Context, desc string) (a APIKey, err error)

+ func GetAPIKeyByKey(ctx context.Context, key string, columns sqldb.Columns) (a APIKey, err error)

+ func GetAPIKeys(ctx context.Context, activeOnly bool, columns sqldb.Columns) (aa []APIKey, err error)

+ func (a *APIKey) Insert(ctx context.Context) (err error)

+ type ActivityLog struct

+ APIKeyDescription string

+ APIKeyK string

+ CreatedByAPIKeyID null.Int

+ CreatedByUserID null.Int

+ DatetimeCreated string

+ DatetimeCreatedTZ string

+ ID int64

+ Method string

+ PostFormValues string

+ RemoteIP string

+ TimeDuration int64

+ TimestampCreated int64

+ Timezone string

+ URL string

+ UserAgent string

+ Username string

+ func GetActivityLog(ctx context.Context, userID int64, endpoint, searchFor string, numRows uint16) (aa []ActivityLog, err error)

+ func (a *ActivityLog) Insert(ctx context.Context) (err error)

+ type App struct

+ Active bool

+ CreatedByUserID int64

+ DatetimeCreated string

+ DatetimeModified string

+ DaysToExpiration int

+ DownloadFilename string

+ FileFormat licensefile.FileFormat

+ ID int64

+ Name string

+ ShowAppName bool

+ ShowLicenseID bool

+ func GetAppByID(ctx context.Context, id int64) (a App, err error)

+ func GetAppByName(ctx context.Context, name string) (a App, err error)

+ func GetApps(ctx context.Context, activeOnly bool) (aa []App, err error)

+ func (a *App) Insert(ctx context.Context) (err error)

+ func (a *App) Update(ctx context.Context) (err error)

+ func (a *App) Validate(ctx context.Context) (errMsg string, err error)

+ type AppSettings struct

+ Allow2FactorAuth bool

+ AllowAPIAccess bool

+ DatetimeModified string

+ EnableActivityLogging bool

+ Force2FactorAuth bool

+ ForceSingleSession bool

+ ID int64

+ func GetAppSettings(ctx context.Context) (a AppSettings, err error)

+ func (a *AppSettings) Update(ctx context.Context) (err error)

+ type AuthorizedBrowser struct

+ Active bool

+ Cookie string

+ DatetimeCreated string

+ ID int64

+ RemoteIP string

+ Timestamp int64

+ UserAgent string

+ UserID int64

+ func LookUpAuthorizedBrowser(ctx context.Context, userID int64, ip, ua, cookie string, activeOnly bool) (a AuthorizedBrowser, err error)

+ func (a *AuthorizedBrowser) Insert(ctx context.Context) (err error)

+ type CustomFieldDefined struct

+ Active bool

+ AppID int64

+ BoolDefaultValue null.Bool

+ BoolValue bool

+ CreatedByUserID int64

+ DateDefaultIncrement null.Int

+ DateValue string

+ DatetimeCreated string

+ DatetimeModified string

+ DecimalDefaultValue null.Float

+ Decimalvalue float64

+ ID int64

+ Instructions string

+ IntegerDefaultValue null.Int

+ IntegerValue int64

+ MultiChoiceDefaultValue null.String

+ MultiChoiceOptions null.String

+ MultiChoiceValue string

+ Name string

+ NumberMaxValue null.Float

+ NumberMinValue null.Float

+ TextDefaultValue null.String

+ TextValue string

+ Type customFieldType

+ func GetCustomFieldsDefined(ctx context.Context, appID int64, activeOnly bool) (cc []CustomFieldDefined, err error)

+ func GetFieldByName(ctx context.Context, appID int64, name string) (cfd CustomFieldDefined, err error)

+ func (cfd *CustomFieldDefined) Delete(ctx context.Context) (err error)

+ func (cfd *CustomFieldDefined) Insert(ctx context.Context) (err error)

+ func (cfd *CustomFieldDefined) Update(ctx context.Context) (err error)

+ func (cfd *CustomFieldDefined) Validate(ctx context.Context) (errMsg string, err error)

+ type CustomFieldResult struct

+ BoolValue null.Bool

+ CreatedByAPIKeyID null.Int

+ CreatedByUserID null.Int

+ CustomFieldDefinedID int64

+ CustomFieldName string

+ CustomFieldType customFieldType

+ DateValue null.String

+ DatetimeCreated string

+ DecimalValue null.Float

+ ID int64

+ IntegerValue null.Int

+ LicenseID int64

+ MultiChoiceValue null.String

+ TextValue null.String

+ func GetCustomFieldResults(ctx context.Context, licenseID int64) (ff []CustomFieldResult, err error)

+ func (f *CustomFieldResult) Insert(ctx context.Context, tx *sqlx.Tx) (err error)

+ type DownloadHistory struct

+ CreatedByAPIKeyDescription null.String

+ CreatedByAPIKeyID null.Int

+ CreatedByUserID null.Int

+ CreatedByUsername null.String

+ DatetimeCreated string

+ DatetimeCreatedTZ string

+ ID int64

+ LicenseID int64

+ TimestampCreated int64

+ Timezone string

+ func GetHistory(ctx context.Context, licenseID int64, orderBy string) (hh []DownloadHistory, err error)

+ func (h *DownloadHistory) Insert(ctx context.Context) (err error)

+ type KeyPair struct

+ Active bool

+ AlgorithmType licensefile.KeyPairAlgoType

+ AppID int64

+ CreatedByUserID int64

+ DatetimeCreated string

+ DatetimeModified string

+ ID int64

+ IsDefault bool

+ Name string

+ PrivateKey string

+ PrivateKeyEncrypted bool

+ PublicKey string

+ func GetDefaultKeyPair(ctx context.Context, appID int64) (k KeyPair, err error)

+ func GetKeyPairByID(ctx context.Context, id int64) (k KeyPair, err error)

+ func GetKeyPairByName(ctx context.Context, name string) (k KeyPair, err error)

+ func GetKeyPairs(ctx context.Context, appID int64, activeOnly bool) (kk []KeyPair, err error)

+ func (k *KeyPair) Delete(ctx context.Context) (err error)

+ func (k *KeyPair) Insert(ctx context.Context) (err error)

+ func (k *KeyPair) Validate(ctx context.Context) (errMsg string, err error)

+ func (kp *KeyPair) SetIsDefault(ctx context.Context) (err error)

+ type KeyValue struct

+ Active bool

+ CreatedByUserID int64

+ DatetimeCreated string

+ DatetimeModified string

+ Expiration int64

+ ID int64

+ K string

+ Type string

+ V string

+ func GetValueByKey(ctx context.Context, keyName string) (k KeyValue, err error)

+ func (k *KeyValue) Insert(ctx context.Context, tx *sqlx.Tx) (err error)

+ func (k *KeyValue) Update(ctx context.Context, tx *sqlx.Tx) (err error)

+ type License struct

+ Active bool

+ AppDownloadFilename string

+ AppFileFormat licensefile.FileFormat

+ AppID int64

+ AppName string

+ CompanyName string

+ ContactName string

+ CreatedByAPIKeyDescription null.String

+ CreatedByAPIKeyID null.Int

+ CreatedByUserID null.Int

+ CreatedByUsername null.String

+ DatetimeCreated string

+ DatetimeCreatedTZ string

+ DatetimeModified string

+ Email string

+ ExpireDate string

+ Expired bool

+ FileFormat licensefile.FileFormat

+ ID int64

+ IssueDate string

+ IssueDateTZ string

+ IssueTimestamp int64

+ KeyPairAlgoType licensefile.KeyPairAlgoType

+ KeyPairID int64

+ PhoneNumber string

+ RenewedFromLicenseID null.Int

+ RenewedToLicenseID null.Int

+ ShowAppName bool

+ ShowLicenseID bool

+ Signature string

+ Timezone string

+ Verified bool

+ func GetLicense(ctx context.Context, licenseID int64, columns sqldb.Columns) (l License, err error)

+ func GetLicenses(ctx context.Context, appID, limit int64, activeOnly bool, ...) (ll []License, err error)

+ func (l *License) Insert(ctx context.Context, tx *sqlx.Tx) (err error)

+ func (l *License) MarkVerified(ctx context.Context) (err error)

+ func (l *License) SaveSignature(ctx context.Context, tx *sqlx.Tx) (err error)

+ func (l *License) Validate(ctx context.Context) (errMsg string, err error)

+ type LicenseNote struct

+ Active bool

+ CreatedByAPIKeyDescription null.String

+ CreatedByAPIKeyID null.Int

+ CreatedByUserID null.Int

+ CreatedByUsername null.String

+ DatetimeCreated string

+ DatetimeCreatedTZ string

+ DatetimeModified string

+ ID int64

+ LicenseID int64

+ Note string

+ Timezone string

+ func GetNotes(ctx context.Context, licenseID int64, orderBy string) (nn []LicenseNote, err error)

+ func (n *LicenseNote) Insert(ctx context.Context, tx *sqlx.Tx) (err error)

+ func (n *LicenseNote) Validate() (errMsg string)

+ type MultiCustomFieldResult []CustomFieldResult

+ func (results MultiCustomFieldResult) Validate(ctx context.Context, appID int64, viaAPI bool) (errMsg string, err error)

+ type RenewalRelationship struct

+ Active bool

+ CreatedByAPIKeyID null.Int

+ CreatedByUserID null.Int

+ DatetimeCreated string

+ DatetimeModified string

+ FromLicenseID int64

+ ID int64

+ ToLicenseID int64

+ func GetRenewalRelationshipByFromID(ctx context.Context, fromLicenseID int64) (r RenewalRelationship, err error)

+ func (r *RenewalRelationship) Insert(ctx context.Context, tx *sqlx.Tx) (err error)

+ type User struct

+ Active bool

+ Administrator bool

+ BadPasswordAttempts uint8

+ CreateLicenses bool

+ CreatedByUserID int64

+ DatetimeCreated string

+ DatetimeModified string

+ ID int64

+ Password string

+ PasswordInput1 string

+ PasswordInput2 string

+ TwoFactorAuthBadAttempts uint8

+ TwoFactorAuthEnabled bool

+ TwoFactorAuthSecret string

+ Username string

+ ViewLicenses bool

+ func GetUserByID(ctx context.Context, id int64, columns sqldb.Columns) (u User, err error)

+ func GetUserByUsername(ctx context.Context, username string, columns sqldb.Columns) (u User, err error)

+ func GetUsers(ctx context.Context, activeOnly bool) (uu []User, err error)

+ func (u *User) Insert(ctx context.Context) (err error)

+ func (u *User) Update(ctx context.Context) (err error)

+ func (u *User) Validate(ctx context.Context) (errMsg string, err error)

+ type UserLogin struct

+ Active bool

+ CookieValue string

+ DatetimeCreated string

+ DatetimeCreatedTZ string

+ DatetimeModified string

+ Expiration int64

+ ID int64

+ RemoteIP string

+ Timezone string

+ TwoFATokenProvided bool

+ UserAgent string

+ UserID int64

+ Username string

+ func GetLoginByCookieValue(ctx context.Context, cv string) (l UserLogin, err error)

+ func GetUserLogins(ctx context.Context, userID int64, numRows uint16) (uu []UserLogin, err error)

+ func (l *UserLogin) ExtendLoginExpiration(ctx context.Context, newExpiration int64) (err error)

+ func (u *UserLogin) Insert(ctx context.Context) (err error)