statements

Documentation

Index

• Constants
• func CountFediAccounts() string
• func CountFediAccountsForInstance() string
• func CountFediInstances() string
• func InsertFediAccount() string
• func InsertFediInstance() string
• func SelectFediAccount() string
• func SelectFediAccountByUsername() string
• func SelectFediAccountsPage(asc bool, limit int) string
• func SelectFediInstance() string
• func SelectFediInstanceByDomain() string
• func SelectFediInstancesPage(asc bool, limit int) string
• func SelectPageHelper(tableName string, asc bool, limit int) string
• func UpsertFediAccount() string
• func UpsertFediInstance() string

Constants

const (
	ColumnNameID = "id"

	ParamLastReadID = "last_read_id"
)

const (
	FediAccountsTableName = "fedi_accounts"

	FediAccountColumnNameID          = ColumnNameID
	FediAccountColumnNameCreatedAt   = "created_at"
	FediAccountColumnNameUpdatedAt   = "updated_at"
	FediAccountColumnNameUsername    = "username"
	FediAccountColumnNameInstanceID  = "instance_id"
	FediAccountColumnNameActorURI    = "actor_uri"
	FediAccountColumnNameDisplayName = "display_name"
	FediAccountColumnNameLastFinger  = "last_finger"
	FediAccountColumnNameAccessToken = "access_token"
	FediAccountColumnNameIsAdmin     = "is_admin"
)

const (
	FediAccountColumnIndexID int64 = iota
	FediAccountColumnIndexCreatedAt
	FediAccountColumnIndexUpdatedAt
	FediAccountColumnIndexUsername
	FediAccountColumnIndexInstanceID
	FediAccountColumnIndexActorURI
	FediAccountColumnIndexDisplayName
	FediAccountColumnIndexLastFinger
	FediAccountColumnIndexAccessToken
	FediAccountColumnIndexIsAdmin
)

const (
	FediInstancesTableName = "fedi_instances"

	FediInstanceColumnNameID             = ColumnNameID
	FediInstanceColumnNameCreatedAt      = "created_at"
	FediInstanceColumnNameUpdatedAt      = "updated_at"
	FediInstanceColumnNameDomain         = "domain"
	FediInstanceColumnNameActorURI       = "actor_uri"
	FediInstanceColumnNameServerHostname = "server_hostname"
	FediInstanceColumnNameSoftware       = "software"
	FediInstanceColumnNameClientID       = "client_id"
	FediInstanceColumnNameClientSecret   = "client_secret"
)

const (
	FediInstanceColumnIndexID int64 = iota
	FediInstanceColumnIndexCreatedAt
	FediInstanceColumnIndexUpdatedAt
	FediInstanceColumnIndexDomain
	FediInstanceColumnIndexActorURI
	FediInstanceColumnIndexServerHostname
	FediInstanceColumnIndexSoftware
	FediInstanceColumnIndexClientID
	FediInstanceColumnIndexClientSecret
)

Functions

func CountFediAccounts

func CountFediAccounts() string

func CountFediAccountsForInstance

func CountFediAccountsForInstance() string

func CountFediInstances

func CountFediInstances() string

func InsertFediAccount

func InsertFediAccount() string

func InsertFediInstance

func InsertFediInstance() string

func SelectFediAccount

func SelectFediAccount() string

func SelectFediAccountByUsername

func SelectFediAccountByUsername() string

func SelectFediAccountsPage

func SelectFediAccountsPage(asc bool, limit int) string

func SelectFediInstance

func SelectFediInstance() string

func SelectFediInstanceByDomain

func SelectFediInstanceByDomain() string

func SelectFediInstancesPage

func SelectFediInstancesPage(asc bool, limit int) string

func SelectPageHelper

func SelectPageHelper(tableName string, asc bool, limit int) string

func UpsertFediAccount

func UpsertFediAccount() string

func UpsertFediInstance

func UpsertFediInstance() string