postgreSQL

Documentation

Index

• Constants
• func NewConnection(ctx context.Context) (*sql.DB, error)
• type CartsPSQL
  • func NewCartsPSQL(dbConn *sql.DB) *CartsPSQL
  • func (c *CartsPSQL) AddItem(ctx context.Context, userID string, item schema.CartItem) (schema.GetCartDetailsResponse, error)
  • func (c *CartsPSQL) GetActiveCartDetails(ctx context.Context, userID string) (schema.GetCartDetailsResponse, error)
  • func (c *CartsPSQL) GetCartDetails(ctx context.Context, cartID string) (schema.GetCartDetailsResponse, error)
  • func (c *CartsPSQL) RemoveItem(ctx context.Context, userID string, cartID string, item schema.CartItem) (schema.GetCartDetailsResponse, error)
  • func (c *CartsPSQL) RemoveProductFromCart(ctx context.Context, cartID string, item schema.CartItem) (schema.GetCartDetailsResponse, error)
  • func (c *CartsPSQL) UpdateCartStatus(ctx context.Context, cartID string, status string) error
• type Connection

Constants

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 */

)

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"`
}