store

Documentation

Index

• Constants
• Variables
• func Create(db *sql.DB) error
• func Delete(db *sql.DB, where string, args ...interface{}) error
• func Domains(db *sql.DB, where string, args ...interface{}) ([]string, error)
• func NewAlias(db *sql.DB, name, domain, forwrd string) error
• func NewBox(db *sql.DB, name, domain, passwd string) error
• type Dest
  • func Dests(db *sql.DB, where string, args ...interface{}) ([]Dest, error)
  • func (d *Dest) String() string

Constants

const (
	TypeBox
	TypeAlias
)

Variables

var CreateSql = []string{`create table if not exists dest (
	id integer primary key autoincrement,
	type integer,
	name text,
	domain text,
	enable integer default 1,
	passwd text,
	forwrd text,
	unique (name, domain)
)`}

var DeleteSql = `delete from dest %s`

var DestsSql = `select
	id, type, name, domain, enable, passwd, forwrd
	from dest %s order by domain, name
`

var DomainsSql = `select
	distinct domain
	from dest %s order by domain
`

var InsertSql = `insert into dest
	(type, name, domain, passwd, forwrd)
	values (?, ?, ?, ?, ?)
`

Functions

func Create

func Create(db *sql.DB) error

func Delete

func Delete(db *sql.DB, where string, args ...interface{}) error

func Domains

func Domains(db *sql.DB, where string, args ...interface{}) ([]string, error)

func NewAlias

func NewAlias(db *sql.DB, name, domain, forwrd string) error

func NewBox

func NewBox(db *sql.DB, name, domain, passwd string) error

Types

type Dest

type Dest struct {
	Id     int64
	Type   int
	Name   string
	Domain string
	Enable bool
	Passwd string
	Forwrd string
}

func Dests

func Dests(db *sql.DB, where string, args ...interface{}) ([]Dest, error)

func (*Dest) String

func (d *Dest) String() string