sqlite

func (*SqliteApi) DeleteAllBy ¶

func (sapi *SqliteApi) DeleteAllBy(cond string) error

it will delete all rows in db with specified condition

example: name="muka" AND id=1

func (*SqliteApi) DropTable ¶

func (sapi *SqliteApi) DropTable() error

if you need to drop table just use it

func (*SqliteApi) Insert ¶

func (sapi *SqliteApi) Insert(cols string, values string) error

argument 'cols' is a string where you put all columns in which values will be inserted example: name, email argument 'values' is a string with values that will be inserted example: "muka", "cringer@asd.dq"

func (*SqliteApi) SelectAll ¶

func (sapi *SqliteApi) SelectAll() *sql.Rows

if you need to get all rows just use it WARNING: it's returns *sql.Rows that means that other work you need to do on your own

func (*SqliteApi) Sync ¶

func (sapi *SqliteApi) Sync(cols string) error

sync means "create table if not exists" argument 'cols' is just columns with all attributes example: "id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT"