db

Documentation

Index

• func DatabaseConnect() *sqlx.DB
• type Database
  • func (db Database) CreateSchema(k string, props map[string]*openapi3.SchemaRef)
  • func (db Database) DeleteModel(id string, modelName string, r *http.Request) utils.JSONResponse
  • func (db Database) GetModels(model string) utils.JSONResponse
  • func (db Database) PostModel(modelName string, model *openapi3.SchemaRef, r *http.Request) utils.JSONResponse
  • func (db Database) PutModel(id string, modelName string, model *openapi3.SchemaRef, r *http.Request) utils.JSONResponse

Functions

func DatabaseConnect

func DatabaseConnect() *sqlx.DB

DatabaseConnect loads connection strings from the config file and connects to the specified DB

Types

type Database

type Database struct {
	Conn *sqlx.DB
}

Database holds the db connection and sould implement support for creation, retrieval, adding, updating and deleting

func (Database) CreateSchema

func (db Database) CreateSchema(k string, props map[string]*openapi3.SchemaRef)

CreateSchema generates a creation string from a model and executes

func (Database) DeleteModel

func (db Database) DeleteModel(id string, modelName string, r *http.Request) utils.JSONResponse

DeleteModel removes an existing entry

func (Database) GetModels

func (db Database) GetModels(model string) utils.JSONResponse

GetModels queries a table of a model and returns all those that match

func (Database) PostModel

func (db Database) PostModel(modelName string, model *openapi3.SchemaRef, r *http.Request) utils.JSONResponse

PostModel finds the model to be created and inserts the record

func (Database) PutModel

func (db Database) PutModel(id string, modelName string, model *openapi3.SchemaRef, r *http.Request) utils.JSONResponse

PutModel updates an existing entry