postgresql

package

Go to main page

Versions in this module

v1

v1.5.1

Jun 20, 2023

v1.5.0

Jun 14, 2023

Changes in this version

type PostgreSQL

+ func (pg *PostgreSQL) AddTask(dbName string, task model.Task) (id string, err error)

+ func (pg *PostgreSQL) DeleteDocuments(auth model.Auth, dbName, col string, filters map[string]any) (n int64, err error)

+ func (pg *PostgreSQL) GetUserByID(dbName, accountID, userID string) (user model.User, err error)

+ func (pg *PostgreSQL) ListAccounts(dbName string) ([]model.Account, error)

+ func (pg *PostgreSQL) ListUsers(dbName, accountID string) ([]model.User, error)

+ func (pg *PostgreSQL) RemoveUser(auth model.Auth, dbName, userID string) error

+ func (sl *PostgreSQL) DeleteTask(dbName, id string) error

v1.5.0-beta.2

Jun 8, 2023

v1.5.0-beta.1

Jun 4, 2023

v1.5.0-alpha.3

Jun 2, 2023

v1.5.0-alpha.2

Jun 2, 2023

v1.5.0-alpha.1

Jun 1, 2023

v1.5.0-alpha.0

Jun 1, 2023

v1.5.0-alpha

May 26, 2023

v1.4.3

Dec 16, 2022

Changes in this version

type PostgreSQL

+ func (pg *PostgreSQL) Count(auth model.Auth, dbName, col string, filters map[string]interface{}) (count int64, err error)

v1.4.2

Sep 26, 2022

Changes in this version

type PostgreSQL

+ func (pg *PostgreSQL) GetDocumentsByIDs(auth model.Auth, dbName, col string, ids []string) (docs []map[string]interface{}, err error)

v1.4.1

Sep 24, 2022

Changes in this version

type PostgreSQL

+ func (pg *PostgreSQL) ActivateTenant(tenantID string, active bool) error

+ func (pg *PostgreSQL) ChangeTenantPlan(tenantID string, plan int) error

+ func (pg *PostgreSQL) CreateAccount(dbName, email string) (id string, err error)

+ func (pg *PostgreSQL) CreateDatabase(base model.DatabaseConfig) (b model.DatabaseConfig, err error)

+ func (pg *PostgreSQL) CreateTenant(customer model.Tenant) (c model.Tenant, err error)

+ func (pg *PostgreSQL) CreateUser(dbName string, tok model.User) (id string, err error)

+ func (pg *PostgreSQL) DeleteTenant(dbName, email string) error

+ func (pg *PostgreSQL) FindRootUser(dbName, userID, accountID, token string) (tok model.User, err error)

+ func (pg *PostgreSQL) FindTenant(tenantID string) (customer model.Tenant, err error)

+ func (pg *PostgreSQL) FindUser(dbName, userID, token string) (tok model.User, err error)

+ func (pg *PostgreSQL) FindUserByEmail(dbName, email string) (tok model.User, err error)

+ func (pg *PostgreSQL) GetFirstUserFromAccountID(dbName, accountID string) (tok model.User, err error)

+ func (pg *PostgreSQL) GetTenantByStripeID(stripeID string) (cus model.Tenant, err error)

v1.4.0

Sep 4, 2022

Changes in this version

type PostgreSQL

+ func (pg *PostgreSQL) ChangeCustomerPlan(customerID string, plan int) error

+ func (pg *PostgreSQL) EnableExternalLogin(customerID string, config map[string]internal.OAuthConfig) error

+ func (pg *PostgreSQL) GetAllDatabaseSizes() error

+ func (pg *PostgreSQL) ListAllFiles(dbName, accountID string) (results []internal.File, err error)

+ func (pg *PostgreSQL) UpdateDocuments(auth internal.Auth, dbName, col string, filters map[string]interface{}, ...) (n int64, err error)

v1.4.0-rc2

Aug 16, 2022

v1.4.0-rc1

Jul 28, 2022

v1.4.0-beta1

Aug 26, 2022

v1.3.0

Mar 16, 2022

Changes in this version

type PostgreSQL

+ func (pg *PostgreSQL) CreateIndex(dbName, col, field string) error

v1.2.1

Feb 22, 2022

v1.2.0

Feb 19, 2022

Changes in this version

+ const FieldAccountID

+ const FieldFormName

+ const FieldID

+ func New(db *sql.DB, pubdoc internal.PublishDocumentEvent) internal.Persister

+ type Document struct

+ AccountID string

+ Created time.Time

+ Data JSONB

+ ID string

+ OwnerID string

+ type FormData struct

+ Created time.Time

+ Data JSONB

+ ID string

+ Name string

+ type JSONB map[string]interface

+ func (j *JSONB) Scan(value interface{}) error

+ func (j JSONB) Value() (driver.Value, error)

+ type PostgreSQL struct

+ DB *sql.DB

+ PublishDocument internal.PublishDocumentEvent

+ func (mg *PostgreSQL) ParseQuery(clauses [][]interface{}) (map[string]interface{}, error)

+ func (pg *PostgreSQL) ActivateCustomer(customerID string) error

+ func (pg *PostgreSQL) AddFile(dbName string, f internal.File) (id string, err error)

+ func (pg *PostgreSQL) AddFormSubmission(dbName, form string, doc map[string]interface{}) error

+ func (pg *PostgreSQL) AddFunction(dbName string, data internal.ExecData) (id string, err error)

+ func (pg *PostgreSQL) BulkCreateDocument(auth internal.Auth, dbName, col string, docs []interface{}) error

+ func (pg *PostgreSQL) CreateBase(base internal.BaseConfig) (b internal.BaseConfig, err error)

+ func (pg *PostgreSQL) CreateCustomer(customer internal.Customer) (c internal.Customer, err error)

+ func (pg *PostgreSQL) CreateDocument(auth internal.Auth, dbName, col string, doc map[string]interface{}) (inserted map[string]interface{}, err error)

+ func (pg *PostgreSQL) CreateUserAccount(dbName, email string) (id string, err error)

+ func (pg *PostgreSQL) CreateUserToken(dbName string, tok internal.Token) (id string, err error)

+ func (pg *PostgreSQL) DatabaseExists(name string) (exists bool, err error)

+ func (pg *PostgreSQL) DeleteCustomer(dbName, email string) error

+ func (pg *PostgreSQL) DeleteDocument(auth internal.Auth, dbName, col, id string) (int64, error)

+ func (pg *PostgreSQL) DeleteFile(dbName, fileID string) error

+ func (pg *PostgreSQL) DeleteFunction(dbName, name string) error

+ func (pg *PostgreSQL) EmailExists(email string) (bool, error)

+ func (pg *PostgreSQL) FindAccount(customerID string) (customer internal.Customer, err error)

+ func (pg *PostgreSQL) FindDatabase(baseID string) (base internal.BaseConfig, err error)

+ func (pg *PostgreSQL) FindRootToken(dbName, tokenID, accountID, token string) (tok internal.Token, err error)

+ func (pg *PostgreSQL) FindToken(dbName, tokenID, token string) (tok internal.Token, err error)

+ func (pg *PostgreSQL) FindTokenByEmail(dbName, email string) (tok internal.Token, err error)

+ func (pg *PostgreSQL) GetCustomerByStripeID(stripeID string) (cus internal.Customer, err error)

+ func (pg *PostgreSQL) GetDocumentByID(auth internal.Auth, dbName, col, id string) (map[string]interface{}, error)

+ func (pg *PostgreSQL) GetFileByID(dbName, fileID string) (f internal.File, err error)

+ func (pg *PostgreSQL) GetFirstTokenFromAccountID(dbName, accountID string) (tok internal.Token, err error)

+ func (pg *PostgreSQL) GetForms(dbName string) (results []string, err error)

+ func (pg *PostgreSQL) GetFunctionByID(dbName, id string) (result internal.ExecData, err error)

+ func (pg *PostgreSQL) GetFunctionByName(dbName, name string) (result internal.ExecData, err error)

+ func (pg *PostgreSQL) GetFunctionForExecution(dbName, name string) (result internal.ExecData, err error)

+ func (pg *PostgreSQL) GetRootForBase(dbName string) (tok internal.Token, err error)

+ func (pg *PostgreSQL) IncrementMonthlyEmailSent(baseID string) error

+ func (pg *PostgreSQL) IncrementValue(auth internal.Auth, dbName, col, id, field string, n int) error

+ func (pg *PostgreSQL) ListCollections(dbName string) (results []string, err error)

+ func (pg *PostgreSQL) ListDatabases() (results []internal.BaseConfig, err error)

+ func (pg *PostgreSQL) ListDocuments(auth internal.Auth, dbName, col string, params internal.ListParams) (result internal.PagedResult, err error)

+ func (pg *PostgreSQL) ListFormSubmissions(dbName, name string) (results []map[string]interface{}, err error)

+ func (pg *PostgreSQL) ListFunctions(dbName string) (results []internal.ExecData, err error)

+ func (pg *PostgreSQL) ListFunctionsByTrigger(dbName, trigger string) (results []internal.ExecData, err error)

+ func (pg *PostgreSQL) ListTasks() (results []internal.Task, err error)

+ func (pg *PostgreSQL) ListTasksByBase(dbName string) (results []internal.Task, err error)

+ func (pg *PostgreSQL) NewID() string

+ func (pg *PostgreSQL) Ping() error

+ func (pg *PostgreSQL) QueryDocuments(auth internal.Auth, dbName, col string, filters map[string]interface{}, ...) (result internal.PagedResult, err error)

+ func (pg *PostgreSQL) RanFunction(dbName, id string, rh internal.ExecHistory) error

+ func (pg *PostgreSQL) ResetPassword(dbName, email, code, password string) error

+ func (pg *PostgreSQL) SetPasswordResetCode(dbName, tokenID, code string) error

+ func (pg *PostgreSQL) SetUserRole(dbName, email string, role int) error

+ func (pg *PostgreSQL) UpdateDocument(auth internal.Auth, dbName, col, id string, doc map[string]interface{}) (map[string]interface{}, error)

+ func (pg *PostgreSQL) UpdateFunction(dbName, id, code, trigger string) error

+ func (pg *PostgreSQL) UserEmailExists(dbName, email string) (exists bool, err error)

+ func (pg *PostgreSQL) UserSetPassword(dbName, tokenID, password string) error

+ type Scanner interface

+ Scan func(dest ...interface{}) error

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