postgreSQL

package

v0.0.0-...-71861b7 Latest Latest Go to latest Published: Jul 12, 2023 License: MIT Imports: 17 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

Repository

github.com/benedictdelfierro/payment

Links

Open Source Insights

Documentation ¶

Index ¶

Constants
func NewConnection(ctx context.Context) (*sql.DB, error)
type CartsPSQL
- func NewCartsPSQL(dbConn *sql.DB) *CartsPSQL
type Connection

Constants ¶

View Source

const (
	CheckActiveCart = `select cart_id from carts where status = 'ACTIVE' and user_id = $1`

	CreateCart = `INSERT INTO carts (user_id, createtimestamp) VALUES ($1,CURRENT_TIMESTAMP)`

	Upsert = `` /* 206-byte string literal not displayed */

	DeleteEmptyItems = `delete from cart_items where cart_id = $1 and quantity <= 0`

	DeleteProductFromCart = `delete from cart_items where cart_id = $1 and product_id = $2`

	UpdateCartStatus = `UPDATE carts SET status = $1 WHERE cart_id = $2`

	GetCartDetails = `` /* 304-byte string literal not displayed */

)

Variables ¶

This section is empty.

Functions ¶

func NewConnection ¶

func NewConnection(ctx context.Context) (*sql.DB, error)

Types ¶

type CartsPSQL ¶

type CartsPSQL struct {
	DBConn *sql.DB
}

func NewCartsPSQL ¶

func NewCartsPSQL(dbConn *sql.DB) *CartsPSQL

func (*CartsPSQL) AddItem ¶

func (c *CartsPSQL) AddItem(ctx context.Context, userID string, item schema.CartItem) (schema.GetCartDetailsResponse, error)

func (*CartsPSQL) GetActiveCartDetails ¶

func (c *CartsPSQL) GetActiveCartDetails(ctx context.Context, userID string) (schema.GetCartDetailsResponse, error)

func (*CartsPSQL) GetCartDetails ¶

func (c *CartsPSQL) GetCartDetails(ctx context.Context, cartID string) (schema.GetCartDetailsResponse, error)

func (*CartsPSQL) RemoveItem ¶

func (c *CartsPSQL) RemoveItem(ctx context.Context, userID string, cartID string, item schema.CartItem) (schema.GetCartDetailsResponse, error)

func (*CartsPSQL) RemoveProductFromCart ¶

func (c *CartsPSQL) RemoveProductFromCart(ctx context.Context, cartID string, item schema.CartItem) (schema.GetCartDetailsResponse, error)

func (*CartsPSQL) UpdateCartStatus ¶

func (c *CartsPSQL) UpdateCartStatus(ctx context.Context, cartID string, status string) error

type Connection ¶

type Connection struct {
	Database       string `json:"database"`
	UseID          string `json:"userID"`
	Password       string `json:"password"`
	ConnectionName string `json:"connectionName"`
	DBIAMUser      string `json:"dbIAMUser"`
}

Source Files ¶

View all Source files

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