Documentation ¶
Index ¶
Constants ¶
View Source
const ( //SELECT_SETTING = `SELECT * from settings WHERE key=$1` SELECT_SETTING = `SELECT settings.*, providers.name from settings, providers where settings.provider = providers.id AND key=$1` SELECT_ALL_SETTINGS = `SELECT settings.*, providers.name from settings, providers where settings.provider = providers.id` )
View Source
const (
DELETE_SETTING = `DELETE from settings WHERE key='%s' AND provider != (SELECT id from providers WHERE name='SYSTEM')`
)
View Source
const (
INSERT_SETTING = `INSERT INTO settings
(key, value, provider)
VALUES
(:key, :value, (SELECT id from providers WHERE name=:name))`
)
View Source
const (
UPDATE_SETTING = `UPDATE settings
SET
value=:value
WHERE
key=:key
AND
provider=(SELECT id from providers WHERE name=:name)`
)
Variables ¶
This section is empty.
Functions ¶
Types ¶
type Setting ¶
type Setting struct { Id int `json:"id" db:"id"` Key string `json:"key" db:"key"` Value string `json:"value" db:"value"` Provider int `json:"provider, omitempty" db:"provider"` ProviderName string `json:"provider_name" db:"name"` }
func (*Setting) ValidInsert ¶
func (*Setting) ValidUpdate ¶
Click to show internal directories.
Click to hide internal directories.