setting

package

v0.0.0-...-70c8363 Latest Latest Go to latest Published: Jul 27, 2015 License: MIT Imports: 3 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

Repository

github.com/omie/shruti

Links

Open Source Insights

Documentation ¶

Index ¶

Constants
func Delete(conn *sqlx.DB, key string) (err error)
type Setting
- func Get(conn *sqlx.DB, key string) (s *Setting, err error)
- func GetAll(conn *sqlx.DB) (s []*Setting, err error)

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 ¶

func Delete ¶

func Delete(conn *sqlx.DB, key string) (err error)

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 Get ¶

func Get(conn *sqlx.DB, key string) (s *Setting, err error)

func GetAll ¶

func GetAll(conn *sqlx.DB) (s []*Setting, err error)

func (*Setting) Insert ¶

func (self *Setting) Insert(conn *sqlx.DB) (err error)

func (*Setting) Update ¶

func (self *Setting) Update(conn *sqlx.DB) (err error)

func (*Setting) ValidInsert ¶

func (self *Setting) ValidInsert() error

func (*Setting) ValidUpdate ¶

func (self *Setting) ValidUpdate() error

Source Files ¶

View all Source files

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