sqldb

package
v0.0.0-...-244eeba Latest Latest
Warning

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

Go to latest
Published: Aug 10, 2020 License: MIT Imports: 8 Imported by: 0

Documentation

Overview

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

Index

Constants

View Source
const (
	DELETE_ORDER        string = "delete from porder where order_number=?"
	QUERY_ORDER_BY_ID   string = "SELECT id, order_number, user_id, payment_id, status, created_time, updated_time FROM porder where id =?"
	QUERY_ORDER_BY_NAME        = "SELECT * FROM porder where order_number =?"
	QUERY_ORDER                = "SELECT * FROM porder "
	CREATE_PAYMENT             = "update porder set payment_id=?, status=?, updated_time=? where order_number=?"
	INSERT_ORDER               = "INSERT porder SET order_number =?, user_id=?, " +
		"status=?, created_time=?, updated_time=?"
)

Variables

This section is empty.

Functions

This section is empty.

Types

type OrderDataSql

type OrderDataSql struct {
	DB gdbc.SqlGdbc
}

OrderDataSql is the SQL implementation of OrderDataInterface

func (*OrderDataSql) Find

func (ods *OrderDataSql) Find(id int) (*model.Order, error)

func (*OrderDataSql) FindAll

func (ods *OrderDataSql) FindAll() ([]model.Order, error)

func (*OrderDataSql) FindByNumber

func (ods *OrderDataSql) FindByNumber(orderNumber string) (*model.Order, error)

func (*OrderDataSql) Insert

func (ods *OrderDataSql) Insert(o *model.Order) (*model.Order, error)

func (*OrderDataSql) Remove

func (ods *OrderDataSql) Remove(orderNumber string) (int64, error)

func (*OrderDataSql) UpdatePayment

func (ods *OrderDataSql) UpdatePayment(orderNumber string, paymentId int, status string) (int64, error)

Jump to

Keyboard shortcuts

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