Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security Policy
  
  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

queries

package

Go to main page

Versions in this module

v0

v0.2.2

Jun 29, 2022

v0.2.1

Apr 11, 2022

v0.2.0

Apr 8, 2022

Changes in this version

+ const AddVerifyUser

+ const DeleteVerifyUser

+ const GetVerifyUser

+ var AddOAuthUser = ...

+ var AddSession = `insert into session (id,refresh_token,owner) values($1, $2, (select id from users where username=$3));`

+ var AddUser = ...

+ var DeleteAllSessions = `delete from session where owner=$1;`

+ var DeleteBlob = `delete from blob where digest=$1;`

+ var DeleteLayer = `delete from layer where digest=$1;`

+ var DeleteManifestByDig = `delete from config where digest=$1;`

+ var DeleteManifestByRef = `delete from config where reference=$1;`

+ var DeleteSession = `delete from session where id=$1 and owner=$2;`

+ var DeleteUser = `delete from users where username = $1;`

+ var GetAllEmails = `select email from users;`

+ var GetBlob = `select * from blob where digest=$1;`

+ var GetCatalog = `select namespace from image_manifest;`

+ var GetCatalogCount = `select count(namespace) from image_manifest;`

+ var GetCatalogDetailWithPagination = `select namespace,created_at::timestamptz,updated_at::timestamptz from image_manifest order by %s limit $1 offset $2;`

+ var GetCatalogWithPagination = `select namespace from image_manifest limit $1 offset $2;`

+ var GetConfig = `select * from config where namespace=$1;`

+ var GetContentHashById = `select sky_link from layer where uuid=$1;`

+ var GetDigest = `select digest from layers where digest=$1;`

+ var GetImageNamespace = ...

+ var GetImageTags = `select reference from config where namespace=$1;`

+ var GetLayer = `select * from layer where digest=$1;`

+ var GetManifest = `select * from image_manifest where namespace=$1;`

+ var GetManifestByDig = `select * from config where namespace=$1 and digest=$2;`

+ var GetManifestByRef = `select * from config where namespace=$1 and reference=$2;`

+ var GetRepoDetailWithPagination = ...

+ var GetSession = `select id,refresh_token,owner from session where id=$1;`

+ var GetUser = `select id, is_active, username, email, created_at, updated_at from users where email=$1 or username=$1;`

+ var GetUserById = `select id, is_active, username, email, created_at, updated_at from users where id=$1;`

+ var GetUserByIdWithPassword = `select id, is_active, username, email, password, created_at, updated_at from users where id=$1;`

+ var GetUserCatalogCount = `select count(namespace) from image_manifest where namespace like $1;`

+ var GetUserCatalogDetailWithPagination = ...

+ var GetUserCatalogWithPagination = `select namespace from image_manifest where namespace like $1 limit $2 offset $3;`

+ var GetUserWithPassword = `select id, is_active, username, email, password, created_at, updated_at from users where email=$1 or username=$1;`

+ var GetUserWithSession = `select id, is_active, name, username, email, hireable, html_url, created_at, updated_at from users where id=(select owner from session where id=$1);`

+ var ReadMetadata = `select * from metadata where namespace=$1;`

+ var SetBlob = ...

+ var SetConfig = ...

+ var SetImageManifest = ...

+ var SetLayer = ...

+ var SetUserActive = `update users set is_active=true where id=$1`

+ var UpdateUser = `update users set is_active = $1, updated_at = $2 where id = $3;`

+ var UpdateUserPwd = `update users set password=$1 where id=$2;`