Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

models_sqlite

package

Go to main page

Versions in this module

v1

v1.7.0

May 12, 2025

Changes in this version

type Queries

+ func (q *Queries) UpdateDescendantPaths(ctx context.Context, oldUrlPath, newUrlPath, pageNodePath string, id int64) error

v1.6.9

Dec 20, 2024

v1.6.8

Nov 12, 2024

v1.6.7

Nov 6, 2024

v1.6.6

Oct 17, 2024

Changes in this version

type Queries

+ func (q *Queries) CountNodesByTypeHash(ctx context.Context, contentType string) (int64, error)

v1.6.5

Oct 7, 2024

Changes in this version

+ type DBTX interface

+ ExecContext func(context.Context, string, ...interface{}) (sql.Result, error)

+ PrepareContext func(context.Context, string) (*sql.Stmt, error)

+ QueryContext func(context.Context, string, ...interface{}) (*sql.Rows, error)

+ QueryRowContext func(context.Context, string, ...interface{}) *sql.Row

+ type Queries struct

+ func New(db DBTX) *Queries

+ func Prepare(ctx context.Context, db DBTX) (*Queries, error)

+ func (q *Queries) AllNodes(ctx context.Context, limit int32, offset int32) ([]models.PageNode, error)

+ func (q *Queries) Close() error

+ func (q *Queries) CountNodes(ctx context.Context) (int64, error)

+ func (q *Queries) CountRootNodes(ctx context.Context) (int64, error)

+ func (q *Queries) DecrementNumChild(ctx context.Context, id int64) (models.PageNode, error)

+ func (q *Queries) DeleteDescendants(ctx context.Context, path interface{}, depth int64) error

+ func (q *Queries) DeleteNode(ctx context.Context, id int64) error

+ func (q *Queries) DeleteNodes(ctx context.Context, id []int64) error

+ func (q *Queries) GetChildNodes(ctx context.Context, path interface{}, depth interface{}, limit int32, ...) ([]models.PageNode, error)

+ func (q *Queries) GetDescendants(ctx context.Context, path interface{}, depth int64, limit int32, offset int32) ([]models.PageNode, error)

+ func (q *Queries) GetNodeByID(ctx context.Context, id int64) (models.PageNode, error)

+ func (q *Queries) GetNodeByPath(ctx context.Context, path string) (models.PageNode, error)

+ func (q *Queries) GetNodeBySlug(ctx context.Context, slug string, depth int64, path interface{}) (models.PageNode, error)

+ func (q *Queries) GetNodesByDepth(ctx context.Context, depth int64, limit int32, offset int32) ([]models.PageNode, error)

+ func (q *Queries) GetNodesByIDs(ctx context.Context, id []int64) ([]models.PageNode, error)

+ func (q *Queries) GetNodesByPageIDs(ctx context.Context, pageID []int64) ([]models.PageNode, error)

+ func (q *Queries) GetNodesByTypeHash(ctx context.Context, contentType string, limit int32, offset int32) ([]models.PageNode, error)

+ func (q *Queries) GetNodesByTypeHashes(ctx context.Context, contentType []string, limit int32, offset int32) ([]models.PageNode, error)

+ func (q *Queries) GetNodesForPaths(ctx context.Context, path []string) ([]models.PageNode, error)

+ func (q *Queries) IncrementNumChild(ctx context.Context, id int64) (models.PageNode, error)

+ func (q *Queries) InsertNode(ctx context.Context, title string, path string, depth int64, numchild int64, ...) (int64, error)

+ func (q *Queries) UpdateNode(ctx context.Context, title string, path string, depth int64, numchild int64, ...) error

+ func (q *Queries) UpdateNodePathAndDepth(ctx context.Context, path string, depth int64, iD int64) error

+ func (q *Queries) UpdateNodeStatusFlags(ctx context.Context, statusFlags int64, iD int64) error

+ func (q *Queries) UpdateNodes(ctx context.Context, nodes []*models.PageNode) error

+ func (q *Queries) WithTx(tx *sql.Tx) models.Querier