sqldb

package
v0.0.0-...-b99263a Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Aug 4, 2020 License: MIT Imports: 9 Imported by: 0

Documentation

Overview

Package sql represents SQL database implementation of the user data persistence layer

Index

Constants

View Source
const (
	DELETE_USER        string = "delete from userinfo where username=?"
	QUERY_USER_BY_ID   string = "SELECT * FROM userinfo where uid =?"
	QUERY_USER_BY_NAME        = "SELECT * FROM userinfo where username =?"
	QUERY_USER                = "SELECT * FROM userinfo "
	UPDATE_USER               = "update userinfo set username=?, department=?, created=? where uid=?"
	INSERT_USER               = "INSERT userinfo SET username=?,department=?,created=?"
)

Variables

This section is empty.

Functions

This section is empty.

Types

type UserDataSql

type UserDataSql struct {
	DB gdbc.SqlGdbc
}

UserDataSql is the SQL implementation of UserDataInterface

func (*UserDataSql) EnableTx

func (uds *UserDataSql) EnableTx(tx dataservice.TxDataInterface)

func (*UserDataSql) Find

func (uds *UserDataSql) Find(id int) (*model.User, error)

func (*UserDataSql) FindAll

func (uds *UserDataSql) FindAll() ([]model.User, error)

func (*UserDataSql) FindByName

func (uds *UserDataSql) FindByName(name string) (*model.User, error)

func (*UserDataSql) Insert

func (uds *UserDataSql) Insert(user *model.User) (*model.User, error)

func (*UserDataSql) Remove

func (uds *UserDataSql) Remove(username string) (int64, error)

func (*UserDataSql) Update

func (uds *UserDataSql) Update(user *model.User) (int64, error)

Jump to

Keyboard shortcuts

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