dblogger

package module
v1.1.0 Latest Latest
Warning

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

 Go to latest Published: May 24, 2024 License: MIT Imports: 12 Imported by: 0

README

dblogger

Go Test golangci-lint Ask AI

A std-lib log and zerolog logger for Sqlite, Turso, RqLite, and other sqlite-like dialected databases.

Installation

go get github.com/conneroisu/dblogger

Usage

Development

SQL

Each sql file

-- file: {file_name}
-- url: github.com/conneroisu/dblogger/data/{file_path}.sql
-- description: {description}
Makefile
make dev.requirements
make database
make lint
make test
Testing
make test
Linting
make lint
Database

Combine all the sql files (shcemas, queries, seeds) into a single sql file each. (ex: data/combined/schema.sql)

make database

Documentation

Index

Constants

This section is empty.

Variables

View Source 
var SQLQueries string
View Source 
var SQLSchema string

Functions

This section is empty.

Types

type ApiLog 

type ApiLog struct {
	ID            int64  `db:"id"              json:"id"`
	LevelID       int64  `db:"level_id"        json:"level_id"`
	CreatedAt     string `db:"created_at"      json:"created_at"`
	GoVersionID   int64  `db:"go_version_id"   json:"go_version_id"`
	BuildSumID    int64  `db:"build_sum_id"    json:"build_sum_id"`
	GitRevisionID int64  `db:"git_revision_id" json:"git_revision_id"`
	UserAgent     string `db:"user_agent"      json:"user_agent"`
	Method        string `db:"method"          json:"method"`
	Url           string `db:"url"             json:"url"`
	ElapsedNs     int64  `db:"elapsed_ns"      json:"elapsed_ns"`
	DeploymentID  int64  `db:"deployment_id"   json:"deployment_id"`
}

type BuildSum 

type BuildSum struct {
	ID        int64     `db:"id"         json:"id"`
	BuildSum  string    `db:"build_sum"  json:"build_sum"`
	CreatedAt time.Time `db:"created_at" json:"created_at"`
}

type DBTX 

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

DBTX is the interface for the database/sql.Tx type and is used to simplify the queries interface by allowing the queries to be run within a transaction.

Example: 

tx, err := db.Begin()
if err != nil {
    return err
}
q := data.New(tx)

type DeleteBuildSumByIDParams 

type DeleteBuildSumByIDParams struct {
	ID int64 `db:"id" json:"id"`
}

type DeleteDeploymentByIDParams 

type DeleteDeploymentByIDParams struct {
	ID int64 `db:"id" json:"id"`
}

type DeleteGitRevisionByIDParams 

type DeleteGitRevisionByIDParams struct {
	ID int64 `db:"id" json:"id"`
}

type DeleteLogByIDParams 

type DeleteLogByIDParams struct {
	ID int64 `db:"id" json:"id"`
}

type DeleteLogLevelByIDParams 

type DeleteLogLevelByIDParams struct {
	ID int64 `db:"id" json:"id"`
}

type DeleteURLByIDParams 

type DeleteURLByIDParams struct {
	ID int64 `db:"id" json:"id"`
}

type Deployment 

type Deployment struct {
	ID        int64  `db:"id"         json:"id"`
	Name      string `db:"name"       json:"name"`
	CreatedAt string `db:"created_at" json:"created_at"`
	UpdatedAt string `db:"updated_at" json:"updated_at"`
}

type GetBuildSumByIDParams 

type GetBuildSumByIDParams struct {
	ID int64 `db:"id" json:"id"`
}

type GetBuildSumsByDateParams 

type GetBuildSumsByDateParams struct {
	CreatedAt time.Time `db:"created_at" json:"created_at"`
}

type GetBuildSumsBySubstringParams 

type GetBuildSumsBySubstringParams struct {
	BuildSum string `db:"build_sum" json:"build_sum"`
}

type GetDeploymentByIDParams 

type GetDeploymentByIDParams struct {
	ID int64 `db:"id" json:"id"`
}

type GetDeploymentsByDateParams 

type GetDeploymentsByDateParams struct {
	CreatedAt string `db:"created_at" json:"created_at"`
}

type GetDeploymentsByDateRangeParams 

type GetDeploymentsByDateRangeParams struct {
	FromCreatedAt string `db:"from_created_at" json:"from_created_at"`
	ToCreatedAt   string `db:"to_created_at"   json:"to_created_at"`
}

type GetDeploymentsBySubstringParams 

type GetDeploymentsBySubstringParams struct {
	Name string `db:"name" json:"name"`
}

type GetGitRevisionByIDParams 

type GetGitRevisionByIDParams struct {
	ID int64 `db:"id" json:"id"`
}

type GetGitRevisionsByDateParams 

type GetGitRevisionsByDateParams struct {
	CreatedAt string `db:"created_at" json:"created_at"`
}

type GetGitRevisionsByNameParams 

type GetGitRevisionsByNameParams struct {
	GitRevision string `db:"git_revision" json:"git_revision"`
}

type GetGoVersionByIDParams 

type GetGoVersionByIDParams struct {
	ID int64 `db:"id" json:"id"`
}

type GetGoVersionIdByNameParams 

type GetGoVersionIdByNameParams struct {
	Name string `db:"name" json:"name"`
}

type GetGoVersionsByDateParams 

type GetGoVersionsByDateParams struct {
	CreatedAt string `db:"created_at" json:"created_at"`
}

type GetGoVersionsBySubstringParams 

type GetGoVersionsBySubstringParams struct {
	Name    string `db:"name"    json:"name"`
	Version string `db:"version" json:"version"`
}

type GetLogByIDParams 

type GetLogByIDParams struct {
	ID int64 `db:"id" json:"id"`
}

type GetLogLevelsBySubstringParams 

type GetLogLevelsBySubstringParams struct {
	Name string `db:"name" json:"name"`
}

type GetLogsByBuildSumIDParams 

type GetLogsByBuildSumIDParams struct {
	BuildSumID int64 `db:"build_sum_id" json:"build_sum_id"`
}

type GetLogsByDateParams 

type GetLogsByDateParams struct {
	CreatedAt string `db:"created_at" json:"created_at"`
}

type GetLogsByDateRangeParams 

type GetLogsByDateRangeParams struct {
	FromCreatedAt string `db:"from_created_at" json:"from_created_at"`
	ToCreatedAt   string `db:"to_created_at"   json:"to_created_at"`
}

type GetLogsByElapsedRangeParams 

type GetLogsByElapsedRangeParams struct {
	FromElapsedNs int64 `db:"from_elapsed_ns" json:"from_elapsed_ns"`
	ToElapsedNs   int64 `db:"to_elapsed_ns"   json:"to_elapsed_ns"`
}

type GetLogsByGitRevisionIDParams 

type GetLogsByGitRevisionIDParams struct {
	GitRevisionID int64 `db:"git_revision_id" json:"git_revision_id"`
}

type GetLogsByGoVersionIDParams 

type GetLogsByGoVersionIDParams struct {
	GoVersionID int64 `db:"go_version_id" json:"go_version_id"`
}

type GetLogsByURLSubstringParams 

type GetLogsByURLSubstringParams struct {
	Url string `db:"url" json:"url"`
}

type GetURLByIDParams 

type GetURLByIDParams struct {
	ID int64 `db:"id" json:"id"`
}

type GetURLsByDateParams 

type GetURLsByDateParams struct {
	CreatedAt string `db:"created_at" json:"created_at"`
}

type GetURLsBySubstringParams 

type GetURLsBySubstringParams struct {
	Url string `db:"url" json:"url"`
}

type GitRevision 

type GitRevision struct {
	ID          int64  `db:"id"           json:"id"`
	GitRevision string `db:"git_revision" json:"git_revision"`
	CreatedAt   string `db:"created_at"   json:"created_at"`
}

type GoVersion 

type GoVersion struct {
	ID        int64  `db:"id"         json:"id"`
	Name      string `db:"name"       json:"name"`
	Version   string `db:"version"    json:"version"`
	CreatedAt string `db:"created_at" json:"created_at"`
}

type InsertBuildSumParams 

type InsertBuildSumParams struct {
	BuildSum string `db:"build_sum" json:"build_sum"`
}

type InsertBuildSumReturningIDParams 

type InsertBuildSumReturningIDParams struct {
	BuildSum string `db:"build_sum" json:"build_sum"`
}

type InsertBuildSumWithParamParams 

type InsertBuildSumWithParamParams struct {
	BuildSum string `db:"build_sum" json:"build_sum"`
}

type InsertDeploymentParams 

type InsertDeploymentParams struct {
	Name string `db:"name" json:"name"`
}

type InsertDeploymentReturningIDParams 

type InsertDeploymentReturningIDParams struct {
	Name string `db:"name" json:"name"`
}

type InsertGitRevisionParams 

type InsertGitRevisionParams struct {
	GitRevision string `db:"git_revision" json:"git_revision"`
}

type InsertGitRevisionReturningIDParams 

type InsertGitRevisionReturningIDParams struct {
	GitRevision string `db:"git_revision" json:"git_revision"`
}

type InsertGitRevisionWithParamParams 

type InsertGitRevisionWithParamParams struct {
	GitRevision string `db:"git_revision" json:"git_revision"`
}

type InsertGoVersionParams 

type InsertGoVersionParams struct {
	Name    string `db:"name"    json:"name"`
	Version string `db:"version" json:"version"`
}

type InsertGoVersionReturningIDParams 

type InsertGoVersionReturningIDParams struct {
	Name    string `db:"name"    json:"name"`
	Version string `db:"version" json:"version"`
}

type InsertLogEntryParams 

type InsertLogEntryParams struct {
	GoVersionID   int64  `db:"go_version_id"   json:"go_version_id"`
	BuildSumID    int64  `db:"build_sum_id"    json:"build_sum_id"`
	GitRevisionID int64  `db:"git_revision_id" json:"git_revision_id"`
	UserAgent     string `db:"user_agent"      json:"user_agent"`
	Method        string `db:"method"          json:"method"`
	Url           string `db:"url"             json:"url"`
	ElapsedNs     int64  `db:"elapsed_ns"      json:"elapsed_ns"`
	DeploymentID  int64  `db:"deployment_id"   json:"deployment_id"`
	LevelID       int64  `db:"level_id"        json:"level_id"`
}

type InsertLogLevelParams 

type InsertLogLevelParams struct {
	Name string `db:"name" json:"name"`
}

type InsertURLParams 

type InsertURLParams struct {
	Url string `db:"url" json:"url"`
}

type InsertURLWithParamParams 

type InsertURLWithParamParams struct {
	Url string `db:"url" json:"url"`
}

type ListBuildSumsPaginatedParams 

type ListBuildSumsPaginatedParams struct {
	Limit  int64 `db:"limit"  json:"limit"`
	Offset int64 `db:"offset" json:"offset"`
}

type ListDeploymentsPaginatedParams 

type ListDeploymentsPaginatedParams struct {
	Limit  int64 `db:"limit"  json:"limit"`
	Offset int64 `db:"offset" json:"offset"`
}

type ListGitRevisionsPaginatedParams 

type ListGitRevisionsPaginatedParams struct {
	Limit  int64 `db:"limit"  json:"limit"`
	Offset int64 `db:"offset" json:"offset"`
}

type ListGoVersionsPaginatedParams 

type ListGoVersionsPaginatedParams struct {
	Limit  int64 `db:"limit"  json:"limit"`
	Offset int64 `db:"offset" json:"offset"`
}

type ListLogLevelsPaginatedParams 

type ListLogLevelsPaginatedParams struct {
	Limit  int64 `db:"limit"  json:"limit"`
	Offset int64 `db:"offset" json:"offset"`
}

type ListLogsByDeploymentIDParams 

type ListLogsByDeploymentIDParams struct {
	DeploymentID int64 `db:"deployment_id" json:"deployment_id"`
}

type ListLogsByMethodParams 

type ListLogsByMethodParams struct {
	Method string `db:"method" json:"method"`
}

type ListLogsByUserAgentParams 

type ListLogsByUserAgentParams struct {
	UserAgent string `db:"user_agent" json:"user_agent"`
}

type ListLogsPaginatedParams 

type ListLogsPaginatedParams struct {
	Limit  int64 `db:"limit"  json:"limit"`
	Offset int64 `db:"offset" json:"offset"`
}

type ListLogsWithJoinByBuildSumIDPaginatedParams 

type ListLogsWithJoinByBuildSumIDPaginatedParams struct {
	ID int64 `db:"id" json:"id"`
}

type ListLogsWithJoinByBuildSumIDPaginatedRow 

type ListLogsWithJoinByBuildSumIDPaginatedRow struct {
	ID            int64  `db:"id"              json:"id"`
	CreatedAt     string `db:"created_at"      json:"created_at"`
	UserAgent     string `db:"user_agent"      json:"user_agent"`
	Method        string `db:"method"          json:"method"`
	Url           string `db:"url"             json:"url"`
	ElapsedNs     int64  `db:"elapsed_ns"      json:"elapsed_ns"`
	LevelID       int64  `db:"level_id"        json:"level_id"`
	LevelName     string `db:"level_name"      json:"level_name"`
	GoVersionName string `db:"go_version_name" json:"go_version_name"`
	GoVersion     string `db:"go_version"      json:"go_version"`
	BuildSum      string `db:"build_sum"       json:"build_sum"`
	GitRevision   string `db:"git_revision"    json:"git_revision"`
}

type ListLogsWithJoinByBuildSumIDParams 

type ListLogsWithJoinByBuildSumIDParams struct {
	ID int64 `db:"id" json:"id"`
}

type ListLogsWithJoinByBuildSumIDRow 

type ListLogsWithJoinByBuildSumIDRow struct {
	ID            int64  `db:"id"              json:"id"`
	CreatedAt     string `db:"created_at"      json:"created_at"`
	UserAgent     string `db:"user_agent"      json:"user_agent"`
	Method        string `db:"method"          json:"method"`
	Url           string `db:"url"             json:"url"`
	ElapsedNs     int64  `db:"elapsed_ns"      json:"elapsed_ns"`
	LevelID       int64  `db:"level_id"        json:"level_id"`
	LevelName     string `db:"level_name"      json:"level_name"`
	GoVersionName string `db:"go_version_name" json:"go_version_name"`
	GoVersion     string `db:"go_version"      json:"go_version"`
	BuildSum      string `db:"build_sum"       json:"build_sum"`
	GitRevision   string `db:"git_revision"    json:"git_revision"`
}

type ListLogsWithJoinByDatePaginatedParams 

type ListLogsWithJoinByDatePaginatedParams struct {
	FromCreatedAt   string    `db:"from_created_at"   json:"from_created_at"`
	FromCreatedAt_2 string    `db:"from_created_at_2" json:"from_created_at_2"`
	FromCreatedAt_3 string    `db:"from_created_at_3" json:"from_created_at_3"`
	FromCreatedAt_4 time.Time `db:"from_created_at_4" json:"from_created_at_4"`
	FromCreatedAt_5 string    `db:"from_created_at_5" json:"from_created_at_5"`
	ToCreatedAt     string    `db:"to_created_at"     json:"to_created_at"`
	ToCreatedAt_2   string    `db:"to_created_at_2"   json:"to_created_at_2"`
	ToCreatedAt_3   string    `db:"to_created_at_3"   json:"to_created_at_3"`
	ToCreatedAt_4   time.Time `db:"to_created_at_4"   json:"to_created_at_4"`
	ToCreatedAt_5   string    `db:"to_created_at_5"   json:"to_created_at_5"`
	Limit           int64     `db:"limit"             json:"limit"`
	Offset          int64     `db:"offset"            json:"offset"`
}

type ListLogsWithJoinByDatePaginatedRow 

type ListLogsWithJoinByDatePaginatedRow struct {
	ID            int64  `db:"id"              json:"id"`
	CreatedAt     string `db:"created_at"      json:"created_at"`
	UserAgent     string `db:"user_agent"      json:"user_agent"`
	Method        string `db:"method"          json:"method"`
	Url           string `db:"url"             json:"url"`
	ElapsedNs     int64  `db:"elapsed_ns"      json:"elapsed_ns"`
	LevelID       int64  `db:"level_id"        json:"level_id"`
	LevelName     string `db:"level_name"      json:"level_name"`
	GoVersionName string `db:"go_version_name" json:"go_version_name"`
	GoVersion     string `db:"go_version"      json:"go_version"`
	BuildSum      string `db:"build_sum"       json:"build_sum"`
	GitRevision   string `db:"git_revision"    json:"git_revision"`
}

type ListLogsWithJoinByDateParams 

type ListLogsWithJoinByDateParams struct {
	FromCreatedAt   string    `db:"from_created_at"   json:"from_created_at"`
	FromCreatedAt_2 string    `db:"from_created_at_2" json:"from_created_at_2"`
	FromCreatedAt_3 string    `db:"from_created_at_3" json:"from_created_at_3"`
	FromCreatedAt_4 time.Time `db:"from_created_at_4" json:"from_created_at_4"`
	FromCreatedAt_5 string    `db:"from_created_at_5" json:"from_created_at_5"`
	ToCreatedAt     string    `db:"to_created_at"     json:"to_created_at"`
	ToCreatedAt_2   string    `db:"to_created_at_2"   json:"to_created_at_2"`
	ToCreatedAt_3   string    `db:"to_created_at_3"   json:"to_created_at_3"`
	ToCreatedAt_4   time.Time `db:"to_created_at_4"   json:"to_created_at_4"`
	ToCreatedAt_5   string    `db:"to_created_at_5"   json:"to_created_at_5"`
}

type ListLogsWithJoinByDateRangePaginatedParams 

type ListLogsWithJoinByDateRangePaginatedParams struct {
	FromCreatedAt   string    `db:"from_created_at"   json:"from_created_at"`
	FromCreatedAt_2 string    `db:"from_created_at_2" json:"from_created_at_2"`
	FromCreatedAt_3 string    `db:"from_created_at_3" json:"from_created_at_3"`
	FromCreatedAt_4 time.Time `db:"from_created_at_4" json:"from_created_at_4"`
	FromCreatedAt_5 string    `db:"from_created_at_5" json:"from_created_at_5"`
	ToCreatedAt     string    `db:"to_created_at"     json:"to_created_at"`
	ToCreatedAt_2   string    `db:"to_created_at_2"   json:"to_created_at_2"`
	ToCreatedAt_3   string    `db:"to_created_at_3"   json:"to_created_at_3"`
	ToCreatedAt_4   time.Time `db:"to_created_at_4"   json:"to_created_at_4"`
	ToCreatedAt_5   string    `db:"to_created_at_5"   json:"to_created_at_5"`
	Limit           int64     `db:"limit"             json:"limit"`
	Offset          int64     `db:"offset"            json:"offset"`
}

type ListLogsWithJoinByDateRangePaginatedRow 

type ListLogsWithJoinByDateRangePaginatedRow struct {
	ID            int64  `db:"id"              json:"id"`
	CreatedAt     string `db:"created_at"      json:"created_at"`
	UserAgent     string `db:"user_agent"      json:"user_agent"`
	Method        string `db:"method"          json:"method"`
	Url           string `db:"url"             json:"url"`
	ElapsedNs     int64  `db:"elapsed_ns"      json:"elapsed_ns"`
	LevelID       int64  `db:"level_id"        json:"level_id"`
	LevelName     string `db:"level_name"      json:"level_name"`
	GoVersionName string `db:"go_version_name" json:"go_version_name"`
	GoVersion     string `db:"go_version"      json:"go_version"`
	BuildSum      string `db:"build_sum"       json:"build_sum"`
	GitRevision   string `db:"git_revision"    json:"git_revision"`
}

type ListLogsWithJoinByDateRangeParams 

type ListLogsWithJoinByDateRangeParams struct {
	FromCreatedAt   string    `db:"from_created_at"   json:"from_created_at"`
	FromCreatedAt_2 string    `db:"from_created_at_2" json:"from_created_at_2"`
	FromCreatedAt_3 string    `db:"from_created_at_3" json:"from_created_at_3"`
	FromCreatedAt_4 time.Time `db:"from_created_at_4" json:"from_created_at_4"`
	FromCreatedAt_5 string    `db:"from_created_at_5" json:"from_created_at_5"`
	ToCreatedAt     string    `db:"to_created_at"     json:"to_created_at"`
	ToCreatedAt_2   string    `db:"to_created_at_2"   json:"to_created_at_2"`
	ToCreatedAt_3   string    `db:"to_created_at_3"   json:"to_created_at_3"`
	ToCreatedAt_4   time.Time `db:"to_created_at_4"   json:"to_created_at_4"`
	ToCreatedAt_5   string    `db:"to_created_at_5"   json:"to_created_at_5"`
}

type ListLogsWithJoinByDateRangeRow 

type ListLogsWithJoinByDateRangeRow struct {
	ID            int64  `db:"id"              json:"id"`
	CreatedAt     string `db:"created_at"      json:"created_at"`
	UserAgent     string `db:"user_agent"      json:"user_agent"`
	Method        string `db:"method"          json:"method"`
	Url           string `db:"url"             json:"url"`
	ElapsedNs     int64  `db:"elapsed_ns"      json:"elapsed_ns"`
	LevelID       int64  `db:"level_id"        json:"level_id"`
	LevelName     string `db:"level_name"      json:"level_name"`
	GoVersionName string `db:"go_version_name" json:"go_version_name"`
	GoVersion     string `db:"go_version"      json:"go_version"`
	BuildSum      string `db:"build_sum"       json:"build_sum"`
	GitRevision   string `db:"git_revision"    json:"git_revision"`
}

type ListLogsWithJoinByDateRow 

type ListLogsWithJoinByDateRow struct {
	ID            int64  `db:"id"              json:"id"`
	CreatedAt     string `db:"created_at"      json:"created_at"`
	UserAgent     string `db:"user_agent"      json:"user_agent"`
	Method        string `db:"method"          json:"method"`
	Url           string `db:"url"             json:"url"`
	ElapsedNs     int64  `db:"elapsed_ns"      json:"elapsed_ns"`
	LevelID       int64  `db:"level_id"        json:"level_id"`
	LevelName     string `db:"level_name"      json:"level_name"`
	GoVersionName string `db:"go_version_name" json:"go_version_name"`
	GoVersion     string `db:"go_version"      json:"go_version"`
	BuildSum      string `db:"build_sum"       json:"build_sum"`
	GitRevision   string `db:"git_revision"    json:"git_revision"`
}

type ListLogsWithJoinByElapsedRangePaginatedParams 

type ListLogsWithJoinByElapsedRangePaginatedParams struct {
	FromElapsedNs int64 `db:"from_elapsed_ns" json:"from_elapsed_ns"`
	ToElapsedNs   int64 `db:"to_elapsed_ns"   json:"to_elapsed_ns"`
	Limit         int64 `db:"limit"           json:"limit"`
	Offset        int64 `db:"offset"          json:"offset"`
}

type ListLogsWithJoinByElapsedRangePaginatedRow 

type ListLogsWithJoinByElapsedRangePaginatedRow struct {
	ID            int64  `db:"id"              json:"id"`
	CreatedAt     string `db:"created_at"      json:"created_at"`
	UserAgent     string `db:"user_agent"      json:"user_agent"`
	Method        string `db:"method"          json:"method"`
	Url           string `db:"url"             json:"url"`
	ElapsedNs     int64  `db:"elapsed_ns"      json:"elapsed_ns"`
	LevelID       int64  `db:"level_id"        json:"level_id"`
	LevelName     string `db:"level_name"      json:"level_name"`
	GoVersionName string `db:"go_version_name" json:"go_version_name"`
	GoVersion     string `db:"go_version"      json:"go_version"`
	BuildSum      string `db:"build_sum"       json:"build_sum"`
	GitRevision   string `db:"git_revision"    json:"git_revision"`
}

type ListLogsWithJoinByElapsedRangeParams 

type ListLogsWithJoinByElapsedRangeParams struct {
	FromElapsedNs int64 `db:"from_elapsed_ns" json:"from_elapsed_ns"`
	ToElapsedNs   int64 `db:"to_elapsed_ns"   json:"to_elapsed_ns"`
}

type ListLogsWithJoinByElapsedRangeRow 

type ListLogsWithJoinByElapsedRangeRow struct {
	ID            int64  `db:"id"              json:"id"`
	CreatedAt     string `db:"created_at"      json:"created_at"`
	UserAgent     string `db:"user_agent"      json:"user_agent"`
	Method        string `db:"method"          json:"method"`
	Url           string `db:"url"             json:"url"`
	ElapsedNs     int64  `db:"elapsed_ns"      json:"elapsed_ns"`
	LevelID       int64  `db:"level_id"        json:"level_id"`
	LevelName     string `db:"level_name"      json:"level_name"`
	GoVersionName string `db:"go_version_name" json:"go_version_name"`
	GoVersion     string `db:"go_version"      json:"go_version"`
	BuildSum      string `db:"build_sum"       json:"build_sum"`
	GitRevision   string `db:"git_revision"    json:"git_revision"`
}

type ListLogsWithJoinByGitRevisionIDPaginatedParams 

type ListLogsWithJoinByGitRevisionIDPaginatedParams struct {
	ID int64 `db:"id" json:"id"`
}

type ListLogsWithJoinByGitRevisionIDPaginatedRow 

type ListLogsWithJoinByGitRevisionIDPaginatedRow struct {
	ID            int64  `db:"id"              json:"id"`
	CreatedAt     string `db:"created_at"      json:"created_at"`
	UserAgent     string `db:"user_agent"      json:"user_agent"`
	Method        string `db:"method"          json:"method"`
	Url           string `db:"url"             json:"url"`
	ElapsedNs     int64  `db:"elapsed_ns"      json:"elapsed_ns"`
	LevelID       int64  `db:"level_id"        json:"level_id"`
	LevelName     string `db:"level_name"      json:"level_name"`
	GoVersionName string `db:"go_version_name" json:"go_version_name"`
	GoVersion     string `db:"go_version"      json:"go_version"`
	BuildSum      string `db:"build_sum"       json:"build_sum"`
	GitRevision   string `db:"git_revision"    json:"git_revision"`
}

type ListLogsWithJoinByGitRevisionIDParams 

type ListLogsWithJoinByGitRevisionIDParams struct {
	ID int64 `db:"id" json:"id"`
}

type ListLogsWithJoinByGitRevisionIDRow 

type ListLogsWithJoinByGitRevisionIDRow struct {
	ID            int64  `db:"id"              json:"id"`
	CreatedAt     string `db:"created_at"      json:"created_at"`
	UserAgent     string `db:"user_agent"      json:"user_agent"`
	Method        string `db:"method"          json:"method"`
	Url           string `db:"url"             json:"url"`
	ElapsedNs     int64  `db:"elapsed_ns"      json:"elapsed_ns"`
	LevelID       int64  `db:"level_id"        json:"level_id"`
	LevelName     string `db:"level_name"      json:"level_name"`
	GoVersionName string `db:"go_version_name" json:"go_version_name"`
	GoVersion     string `db:"go_version"      json:"go_version"`
	BuildSum      string `db:"build_sum"       json:"build_sum"`
	GitRevision   string `db:"git_revision"    json:"git_revision"`
}

type ListLogsWithJoinByGoVersionIDPaginatedParams 

type ListLogsWithJoinByGoVersionIDPaginatedParams struct {
	ID int64 `db:"id" json:"id"`
}

type ListLogsWithJoinByGoVersionIDPaginatedRow 

type ListLogsWithJoinByGoVersionIDPaginatedRow struct {
	ID            int64  `db:"id"              json:"id"`
	CreatedAt     string `db:"created_at"      json:"created_at"`
	UserAgent     string `db:"user_agent"      json:"user_agent"`
	Method        string `db:"method"          json:"method"`
	Url           string `db:"url"             json:"url"`
	ElapsedNs     int64  `db:"elapsed_ns"      json:"elapsed_ns"`
	LevelID       int64  `db:"level_id"        json:"level_id"`
	LevelName     string `db:"level_name"      json:"level_name"`
	GoVersionName string `db:"go_version_name" json:"go_version_name"`
	GoVersion     string `db:"go_version"      json:"go_version"`
	BuildSum      string `db:"build_sum"       json:"build_sum"`
	GitRevision   string `db:"git_revision"    json:"git_revision"`
}

type ListLogsWithJoinByGoVersionIDParams 

type ListLogsWithJoinByGoVersionIDParams struct {
	ID int64 `db:"id" json:"id"`
}

type ListLogsWithJoinByGoVersionIDRow 

type ListLogsWithJoinByGoVersionIDRow struct {
	ID            int64  `db:"id"              json:"id"`
	CreatedAt     string `db:"created_at"      json:"created_at"`
	UserAgent     string `db:"user_agent"      json:"user_agent"`
	Method        string `db:"method"          json:"method"`
	Url           string `db:"url"             json:"url"`
	ElapsedNs     int64  `db:"elapsed_ns"      json:"elapsed_ns"`
	LevelID       int64  `db:"level_id"        json:"level_id"`
	LevelName     string `db:"level_name"      json:"level_name"`
	GoVersionName string `db:"go_version_name" json:"go_version_name"`
	GoVersion     string `db:"go_version"      json:"go_version"`
	BuildSum      string `db:"build_sum"       json:"build_sum"`
	GitRevision   string `db:"git_revision"    json:"git_revision"`
}

type ListLogsWithJoinPaginatedParams 

type ListLogsWithJoinPaginatedParams struct {
	Limit  int64 `db:"limit"  json:"limit"`
	Offset int64 `db:"offset" json:"offset"`
}

type ListLogsWithJoinPaginatedRow 

type ListLogsWithJoinPaginatedRow struct {
	ID            int64  `db:"id"              json:"id"`
	CreatedAt     string `db:"created_at"      json:"created_at"`
	UserAgent     string `db:"user_agent"      json:"user_agent"`
	Method        string `db:"method"          json:"method"`
	Url           string `db:"url"             json:"url"`
	ElapsedNs     int64  `db:"elapsed_ns"      json:"elapsed_ns"`
	LevelID       int64  `db:"level_id"        json:"level_id"`
	LevelName     string `db:"level_name"      json:"level_name"`
	GoVersionName string `db:"go_version_name" json:"go_version_name"`
	GoVersion     string `db:"go_version"      json:"go_version"`
	BuildSum      string `db:"build_sum"       json:"build_sum"`
	GitRevision   string `db:"git_revision"    json:"git_revision"`
}

type ListLogsWithJoinRow 

type ListLogsWithJoinRow struct {
	ID            int64  `db:"id"              json:"id"`
	CreatedAt     string `db:"created_at"      json:"created_at"`
	UserAgent     string `db:"user_agent"      json:"user_agent"`
	Method        string `db:"method"          json:"method"`
	Url           string `db:"url"             json:"url"`
	ElapsedNs     int64  `db:"elapsed_ns"      json:"elapsed_ns"`
	LevelID       int64  `db:"level_id"        json:"level_id"`
	LevelName     string `db:"level_name"      json:"level_name"`
	GoVersionName string `db:"go_version_name" json:"go_version_name"`
	GoVersion     string `db:"go_version"      json:"go_version"`
	BuildSum      string `db:"build_sum"       json:"build_sum"`
	GitRevision   string `db:"git_revision"    json:"git_revision"`
}

type ListURLsPaginatedParams 

type ListURLsPaginatedParams struct {
	Limit  int64 `db:"limit"  json:"limit"`
	Offset int64 `db:"offset" json:"offset"`
}

type LogLevel 

type LogLevel struct {
	ID   int64  `db:"id"   json:"id"`
	Name string `db:"name" json:"name"`
}

type Querier 

type Querier interface {
	// file: build_sums.sql
	// url: github.com/conneroisu/dblogger/data/queries/build_sums.sql
	// description: build_sums.sql is
	//
	//  SELECT
	//      COUNT(*)
	//  FROM
	//      build_sums
	CountBuildSums(ctx context.Context) (int64, error)
	// file: deployments.sql
	// url: github.com/conneroisu/dblogger/data/queries/deployments.sql
	// description: deployments.sql is
	//
	//  SELECT
	//      COUNT(*)
	//  FROM
	//      deployments
	CountDeployments(ctx context.Context) (int64, error)
	// file: git_revisions.sql
	// url: github.com/conneroisu/dblogger/data/queries/git_revisions.sql
	// description: git_revisions.sql is
	//
	//  SELECT
	//      COUNT(*)
	//  FROM
	//      git_revisions
	CountGitRevisions(ctx context.Context) (int64, error)
	// file: go_versions.sql
	// url: github.com/conneroisu/dblogger/data/queries/go_versions.sql
	// description: go_versions.sql is
	//
	//  SELECT
	//      COUNT(*)
	//  FROM
	//      go_versions
	CountGoVersions(ctx context.Context) (int64, error)
	// file: log_levels.sql
	// url: github.com/conneroisu/dblogger/data/queries/log_levels.sql
	// description: log_levels.sql is
	//
	//  SELECT
	//      COUNT(*)
	//  FROM
	//      log_levels
	CountLogLevels(ctx context.Context) (int64, error)
	// file: api_logs.sql
	// url: github.com/conneroisu/dblogger/data/queries/api_logs.sql
	// description: api_logs.sql is
	//
	//  SELECT
	//      COUNT(*)
	//  FROM
	//      api_logs
	CountLogs(ctx context.Context) (int64, error)
	// file: urls.sql
	// url: github.com/conneroisu/dblogger/data/queries/urls.sql
	// description: urls.sql is
	//
	//  SELECT
	//      COUNT(*)
	//  FROM
	//      urls
	CountURLs(ctx context.Context) (int64, error)
	//DeleteBuildSumByID
	//
	//  DELETE FROM
	//      build_sums
	//  WHERE
	//      id = ?
	DeleteBuildSumByID(
		ctx context.Context,
		arg *DeleteBuildSumByIDParams,
	) error
	//DeleteDeploymentByID
	//
	//  DELETE FROM
	//      deployments
	//  WHERE
	//      id = ?
	DeleteDeploymentByID(
		ctx context.Context,
		arg *DeleteDeploymentByIDParams,
	) error
	//DeleteGitRevisionByID
	//
	//  DELETE FROM
	//      git_revisions
	//  WHERE
	//      id = ?
	DeleteGitRevisionByID(
		ctx context.Context,
		arg *DeleteGitRevisionByIDParams,
	) error
	//DeleteGoVersionByID
	//
	//  DELETE FROM
	//      go_versions
	//  WHERE
	//      id = 1
	DeleteGoVersionByID(ctx context.Context) error
	//DeleteLogByID
	//
	//  DELETE FROM
	//      api_logs
	//  WHERE
	//      id = ?
	DeleteLogByID(ctx context.Context, arg *DeleteLogByIDParams) error
	//DeleteLogLevelByID
	//
	//  DELETE FROM
	//      log_levels
	//  WHERE
	//      id = ?
	DeleteLogLevelByID(
		ctx context.Context,
		arg *DeleteLogLevelByIDParams,
	) error
	//DeleteURLByID
	//
	//  DELETE FROM
	//      urls
	//  WHERE
	//      id = ?
	DeleteURLByID(ctx context.Context, arg *DeleteURLByIDParams) error
	//GetBuildSumByID
	//
	//  SELECT
	//      id, build_sum, created_at
	//  FROM
	//      build_sums
	//  WHERE
	//      id = ?
	GetBuildSumByID(
		ctx context.Context,
		arg *GetBuildSumByIDParams,
	) (BuildSum, error)
	//GetBuildSumsByDate
	//
	//  SELECT
	//      id, build_sum, created_at
	//  FROM
	//      build_sums
	//  WHERE
	//      created_at >= ?
	GetBuildSumsByDate(
		ctx context.Context,
		arg *GetBuildSumsByDateParams,
	) ([]BuildSum, error)
	//GetBuildSumsBySubstring
	//
	//  SELECT
	//      id, build_sum, created_at
	//  FROM
	//      build_sums
	//  WHERE
	//      build_sum LIKE ?
	GetBuildSumsBySubstring(
		ctx context.Context,
		arg *GetBuildSumsBySubstringParams,
	) ([]BuildSum, error)
	//GetDeploymentByID
	//
	//  SELECT
	//      id, name, created_at, updated_at
	//  FROM
	//      deployments
	//  WHERE
	//      id = ?
	GetDeploymentByID(
		ctx context.Context,
		arg *GetDeploymentByIDParams,
	) (Deployment, error)
	//GetDeploymentsByDate
	//
	//  SELECT
	//      id, name, created_at, updated_at
	//  FROM
	//      deployments
	//  WHERE
	//      created_at >= ?
	GetDeploymentsByDate(
		ctx context.Context,
		arg *GetDeploymentsByDateParams,
	) ([]Deployment, error)
	//GetDeploymentsByDateRange
	//
	//  SELECT
	//      id, name, created_at, updated_at
	//  FROM
	//      deployments
	//  WHERE
	//      created_at BETWEEN ? AND ?
	GetDeploymentsByDateRange(
		ctx context.Context,
		arg *GetDeploymentsByDateRangeParams,
	) ([]Deployment, error)
	//GetDeploymentsBySubstring
	//
	//  SELECT
	//      id, name, created_at, updated_at
	//  FROM
	//      deployments
	//  WHERE
	//      name LIKE ?
	GetDeploymentsBySubstring(
		ctx context.Context,
		arg *GetDeploymentsBySubstringParams,
	) ([]Deployment, error)
	//GetGitRevisionByID
	//
	//  SELECT
	//      id, git_revision, created_at
	//  FROM
	//      git_revisions
	//  WHERE
	//      id = ?
	GetGitRevisionByID(
		ctx context.Context,
		arg *GetGitRevisionByIDParams,
	) (GitRevision, error)
	//GetGitRevisionsByDate
	//
	//  SELECT
	//      id, git_revision, created_at
	//  FROM
	//      git_revisions
	//  WHERE
	//      created_at >= ?
	GetGitRevisionsByDate(
		ctx context.Context,
		arg *GetGitRevisionsByDateParams,
	) ([]GitRevision, error)
	//GetGitRevisionsByName
	//
	//  SELECT
	//      id, git_revision, created_at
	//  FROM
	//      git_revisions
	//  WHERE
	//      git_revision = ?
	GetGitRevisionsByName(
		ctx context.Context,
		arg *GetGitRevisionsByNameParams,
	) (GitRevision, error)
	//GetGoVersionByID
	//
	//  SELECT
	//      id, name, version, created_at
	//  FROM
	//      go_versions
	//  WHERE
	//      id = ?
	GetGoVersionByID(
		ctx context.Context,
		arg *GetGoVersionByIDParams,
	) (GoVersion, error)
	//GetGoVersionIdByName
	//
	//  SELECT
	//      id
	//  FROM
	//      go_versions
	//  WHERE
	//      name = ?
	GetGoVersionIdByName(
		ctx context.Context,
		arg *GetGoVersionIdByNameParams,
	) (int64, error)
	//GetGoVersionsByDate
	//
	//  SELECT
	//      id, name, version, created_at
	//  FROM
	//      go_versions
	//  WHERE
	//      created_at >= ?
	GetGoVersionsByDate(
		ctx context.Context,
		arg *GetGoVersionsByDateParams,
	) ([]GoVersion, error)
	//GetGoVersionsBySubstring
	//
	//  SELECT
	//      id, name, version, created_at
	//  FROM
	//      go_versions
	//  WHERE
	//      name LIKE ?
	//      OR version LIKE ?
	GetGoVersionsBySubstring(
		ctx context.Context,
		arg *GetGoVersionsBySubstringParams,
	) ([]GoVersion, error)
	//GetLogByID
	//
	//  SELECT
	//      id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
	//  FROM
	//      api_logs
	//  WHERE
	//      id = ?
	GetLogByID(ctx context.Context, arg *GetLogByIDParams) (ApiLog, error)
	//GetLogLevelsBySubstring
	//
	//  SELECT
	//      id, name
	//  FROM
	//      log_levels
	//  WHERE
	//      name LIKE ?
	GetLogLevelsBySubstring(
		ctx context.Context,
		arg *GetLogLevelsBySubstringParams,
	) ([]LogLevel, error)
	//GetLogsByBuildSumID
	//
	//  SELECT
	//      id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
	//  FROM
	//      api_logs
	//  WHERE
	//      build_sum_id = ?
	GetLogsByBuildSumID(
		ctx context.Context,
		arg *GetLogsByBuildSumIDParams,
	) ([]ApiLog, error)
	//GetLogsByDate
	//
	//  SELECT
	//      id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
	//  FROM
	//      api_logs
	//  WHERE
	//      created_at >= ?
	GetLogsByDate(
		ctx context.Context,
		arg *GetLogsByDateParams,
	) ([]ApiLog, error)
	//GetLogsByDateRange
	//
	//  SELECT
	//      id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
	//  FROM
	//      api_logs
	//  WHERE
	//      created_at BETWEEN ? AND ?
	GetLogsByDateRange(
		ctx context.Context,
		arg *GetLogsByDateRangeParams,
	) ([]ApiLog, error)
	//GetLogsByElapsedRange
	//
	//  SELECT
	//      id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
	//  FROM
	//      api_logs
	//  WHERE
	//      elapsed_ns BETWEEN ? AND ?
	GetLogsByElapsedRange(
		ctx context.Context,
		arg *GetLogsByElapsedRangeParams,
	) ([]ApiLog, error)
	//GetLogsByGitRevisionID
	//
	//  SELECT
	//      id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
	//  FROM
	//      api_logs
	//  WHERE
	//      git_revision_id = ?
	GetLogsByGitRevisionID(
		ctx context.Context,
		arg *GetLogsByGitRevisionIDParams,
	) ([]ApiLog, error)
	//GetLogsByGoVersionID
	//
	//  SELECT
	//      id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
	//  FROM
	//      api_logs
	//  WHERE
	//      go_version_id = ?
	GetLogsByGoVersionID(
		ctx context.Context,
		arg *GetLogsByGoVersionIDParams,
	) ([]ApiLog, error)
	//GetLogsByURLSubstring
	//
	//  SELECT
	//      id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
	//  FROM
	//      api_logs
	//  WHERE
	//      url LIKE ?
	GetLogsByURLSubstring(
		ctx context.Context,
		arg *GetLogsByURLSubstringParams,
	) ([]ApiLog, error)
	//GetURLByID
	//
	//  SELECT
	//      id, url, created_at
	//  FROM
	//      urls
	//  WHERE
	//      id = ?
	GetURLByID(ctx context.Context, arg *GetURLByIDParams) (Url, error)
	//GetURLsByDate
	//
	//  SELECT
	//      id, url, created_at
	//  FROM
	//      urls
	//  WHERE
	//      created_at >= ?
	GetURLsByDate(ctx context.Context, arg *GetURLsByDateParams) ([]Url, error)
	//GetURLsBySubstring
	//
	//  SELECT
	//      id, url, created_at
	//  FROM
	//      urls
	//  WHERE
	//      url LIKE ?
	GetURLsBySubstring(
		ctx context.Context,
		arg *GetURLsBySubstringParams,
	) ([]Url, error)
	//InsertBuildSum
	//
	//  INSERT INTO
	//      build_sums (build_sum)
	//  VALUES
	//      (?) RETURNING id, build_sum, created_at
	InsertBuildSum(
		ctx context.Context,
		arg *InsertBuildSumParams,
	) (BuildSum, error)
	//InsertBuildSumReturningID
	//
	//  INSERT INTO
	//      build_sums (build_sum)
	//  VALUES
	//      (?) RETURNING id
	InsertBuildSumReturningID(
		ctx context.Context,
		arg *InsertBuildSumReturningIDParams,
	) (int64, error)
	//InsertBuildSumWithParam
	//
	//  INSERT INTO
	//      build_sums (build_sum)
	//  VALUES
	//      (?)
	InsertBuildSumWithParam(
		ctx context.Context,
		arg *InsertBuildSumWithParamParams,
	) error
	//InsertDeployment
	//
	//  INSERT INTO
	//      deployments (name)
	//  VALUES
	//      (?) RETURNING id, name, created_at, updated_at
	InsertDeployment(
		ctx context.Context,
		arg *InsertDeploymentParams,
	) (Deployment, error)
	//InsertDeploymentReturningID
	//
	//  INSERT INTO
	//      deployments (name)
	//  VALUES
	//      (?) RETURNING id
	InsertDeploymentReturningID(
		ctx context.Context,
		arg *InsertDeploymentReturningIDParams,
	) (int64, error)
	//InsertGitRevision
	//
	//  INSERT INTO
	//      git_revisions (git_revision)
	//  VALUES
	//      (?) RETURNING id, git_revision, created_at
	InsertGitRevision(
		ctx context.Context,
		arg *InsertGitRevisionParams,
	) (GitRevision, error)
	//InsertGitRevisionReturningID
	//
	//  INSERT INTO
	//      git_revisions (git_revision)
	//  VALUES
	//      (?) RETURNING id
	InsertGitRevisionReturningID(
		ctx context.Context,
		arg *InsertGitRevisionReturningIDParams,
	) (int64, error)
	//InsertGitRevisionWithParam
	//
	//  INSERT INTO
	//      git_revisions (git_revision)
	//  VALUES
	//      (?)
	InsertGitRevisionWithParam(
		ctx context.Context,
		arg *InsertGitRevisionWithParamParams,
	) error
	//InsertGoVersion
	//
	//  INSERT INTO
	//      go_versions (name, version)
	//  VALUES
	//      (?, ?) RETURNING id, name, version, created_at
	InsertGoVersion(
		ctx context.Context,
		arg *InsertGoVersionParams,
	) (GoVersion, error)
	//InsertGoVersionReturningID
	//
	//  INSERT INTO
	//      go_versions (name, version)
	//  VALUES
	//      (?, ?) RETURNING id
	InsertGoVersionReturningID(
		ctx context.Context,
		arg *InsertGoVersionReturningIDParams,
	) (int64, error)
	//InsertLogEntry
	//
	//  INSERT INTO
	//      api_logs (
	//          go_version_id,
	//          build_sum_id,
	//          git_revision_id,
	//          user_agent,
	//          method,
	//          url,
	//          elapsed_ns,
	//          deployment_id,
	//          level_id
	//      )
	//  VALUES
	//      (?, ?, ?, ?, ?, ?, ?, ?, ?)
	InsertLogEntry(ctx context.Context, arg *InsertLogEntryParams) error
	//InsertLogLevel
	//
	//  INSERT INTO
	//      log_levels (name)
	//  VALUES
	//      (?)
	InsertLogLevel(ctx context.Context, arg *InsertLogLevelParams) error
	//InsertURL
	//
	//  INSERT INTO
	//      urls (url)
	//  VALUES
	//      (?)
	InsertURL(ctx context.Context, arg *InsertURLParams) error
	//InsertURLWithParam
	//
	//  INSERT INTO
	//      urls (url)
	//  VALUES
	//      (?)
	InsertURLWithParam(
		ctx context.Context,
		arg *InsertURLWithParamParams,
	) error
	//ListBuildSums
	//
	//  SELECT
	//      id, build_sum, created_at
	//  FROM
	//      build_sums
	ListBuildSums(ctx context.Context) ([]BuildSum, error)
	//ListBuildSumsPaginated
	//
	//  SELECT
	//      id, build_sum, created_at
	//  FROM
	//      build_sums
	//  LIMIT
	//      ? OFFSET ?
	ListBuildSumsPaginated(
		ctx context.Context,
		arg *ListBuildSumsPaginatedParams,
	) ([]BuildSum, error)
	//ListDeployments
	//
	//  SELECT
	//      id, name, created_at, updated_at
	//  FROM
	//      deployments
	ListDeployments(ctx context.Context) ([]Deployment, error)
	//ListDeploymentsPaginated
	//
	//  SELECT
	//      id, name, created_at, updated_at
	//  FROM
	//      deployments
	//  LIMIT
	//      ? OFFSET ?
	ListDeploymentsPaginated(
		ctx context.Context,
		arg *ListDeploymentsPaginatedParams,
	) ([]Deployment, error)
	//ListGitRevisions
	//
	//  SELECT
	//      id, git_revision, created_at
	//  FROM
	//      git_revisions
	ListGitRevisions(ctx context.Context) ([]GitRevision, error)
	//ListGitRevisionsPaginated
	//
	//  SELECT
	//      id, git_revision, created_at
	//  FROM
	//      git_revisions
	//  LIMIT
	//      ? OFFSET ?
	ListGitRevisionsPaginated(
		ctx context.Context,
		arg *ListGitRevisionsPaginatedParams,
	) ([]GitRevision, error)
	//ListGoVersions
	//
	//  SELECT
	//      id, name, version, created_at
	//  FROM
	//      go_versions
	ListGoVersions(ctx context.Context) ([]GoVersion, error)
	//ListGoVersionsPaginated
	//
	//  SELECT
	//      id, name, version, created_at
	//  FROM
	//      go_versions
	//  LIMIT
	//      ? OFFSET ?
	ListGoVersionsPaginated(
		ctx context.Context,
		arg *ListGoVersionsPaginatedParams,
	) ([]GoVersion, error)
	//ListLogLevels
	//
	//  SELECT
	//      id, name
	//  FROM
	//      log_levels
	ListLogLevels(ctx context.Context) ([]LogLevel, error)
	//ListLogLevelsPaginated
	//
	//  SELECT
	//      id, name
	//  FROM
	//      log_levels
	//  LIMIT
	//      ? OFFSET ?
	ListLogLevelsPaginated(
		ctx context.Context,
		arg *ListLogLevelsPaginatedParams,
	) ([]LogLevel, error)
	//ListLogs
	//
	//  SELECT
	//      id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
	//  FROM
	//      api_logs
	ListLogs(ctx context.Context) ([]ApiLog, error)
	//ListLogsByDeploymentID
	//
	//  SELECT
	//      id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
	//  FROM
	//      api_logs
	//  WHERE
	//      deployment_id = ?
	ListLogsByDeploymentID(
		ctx context.Context,
		arg *ListLogsByDeploymentIDParams,
	) ([]ApiLog, error)
	//ListLogsByMethod
	//
	//  SELECT
	//      id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
	//  FROM
	//      api_logs
	//  WHERE
	//      method = ?
	ListLogsByMethod(
		ctx context.Context,
		arg *ListLogsByMethodParams,
	) ([]ApiLog, error)
	//ListLogsByUserAgent
	//
	//  SELECT
	//      id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
	//  FROM
	//      api_logs
	//  WHERE
	//      user_agent = ?
	ListLogsByUserAgent(
		ctx context.Context,
		arg *ListLogsByUserAgentParams,
	) ([]ApiLog, error)
	//ListLogsPaginated
	//
	//  SELECT
	//      id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
	//  FROM
	//      api_logs
	//  LIMIT
	//      ? OFFSET ?
	ListLogsPaginated(
		ctx context.Context,
		arg *ListLogsPaginatedParams,
	) ([]ApiLog, error)
	//ListLogsWithJoin
	//
	//  SELECT
	//      l.id,
	//      l.created_at,
	//      l.user_agent,
	//      l.method,
	//      l.url,
	//      l.elapsed_ns,
	//      l.level_id,
	//      le.name AS level_name,
	//      gv.name AS go_version_name,
	//      gv.version AS go_version,
	//      bs.build_sum,
	//      gr.git_revision
	//  FROM
	//      api_logs l
	//      JOIN log_levels le ON l.level_id = le.id
	//      JOIN deployments d ON l.deployment_id = d.id
	//      JOIN go_versions gv ON l.go_version_id = gv.id
	//      JOIN build_sums bs ON l.build_sum_id = bs.id
	//      JOIN git_revisions gr ON l.git_revision_id = gr.id
	ListLogsWithJoin(ctx context.Context) ([]ListLogsWithJoinRow, error)
	//ListLogsWithJoinByBuildSumID
	//
	//  SELECT
	//      l.id,
	//      l.created_at,
	//      l.user_agent,
	//      l.method,
	//      l.url,
	//      l.elapsed_ns,
	//      l.level_id,
	//      le.name AS level_name,
	//      gv.name AS go_version_name,
	//      gv.version AS go_version,
	//      bs.build_sum,
	//      gr.git_revision
	//  FROM
	//      api_logs l
	//      JOIN log_levels le ON l.level_id = le.id
	//      JOIN deployments d ON l.deployment_id = d.id
	//      JOIN go_versions gv ON l.go_version_id = gv.id
	//      JOIN build_sums bs ON l.build_sum_id = bs.id
	//      JOIN git_revisions gr ON l.git_revision_id = gr.id
	//  WHERE
	//      bs.id = ?
	ListLogsWithJoinByBuildSumID(
		ctx context.Context,
		arg *ListLogsWithJoinByBuildSumIDParams,
	) ([]ListLogsWithJoinByBuildSumIDRow, error)
	//ListLogsWithJoinByBuildSumIDPaginated
	//
	//  SELECT
	//      l.id,
	//      l.created_at,
	//      l.user_agent,
	//      l.method,
	//      l.url,
	//      l.elapsed_ns,
	//      l.level_id,
	//      le.name AS level_name,
	//      gv.name AS go_version_name,
	//      gv.version AS go_version,
	//      bs.build_sum,
	//      gr.git_revision
	//  FROM
	//      api_logs l
	//      JOIN log_levels le ON l.level_id = le.id
	//      JOIN deployments d ON l.deployment_id = d.id
	//      JOIN go_versions gv ON l.go_version_id = gv.id
	//      JOIN build_sums bs ON l.build_sum_id = bs.id
	//      JOIN git_revisions gr ON l.git_revision_id = gr.id
	//  WHERE
	//      bs.id = ?
	ListLogsWithJoinByBuildSumIDPaginated(
		ctx context.Context,
		arg *ListLogsWithJoinByBuildSumIDPaginatedParams,
	) ([]ListLogsWithJoinByBuildSumIDPaginatedRow, error)
	//ListLogsWithJoinByDate
	//
	//  SELECT
	//      l.id,
	//      l.created_at,
	//      l.user_agent,
	//      l.method,
	//      l.url,
	//      l.elapsed_ns,
	//      l.level_id,
	//      le.name AS level_name,
	//      gv.name AS go_version_name,
	//      gv.version AS go_version,
	//      bs.build_sum,
	//      gr.git_revision
	//  FROM
	//      api_logs l
	//      JOIN log_levels le ON l.level_id = le.id
	//      JOIN deployments d ON l.deployment_id = d.id
	//      JOIN go_versions gv ON l.go_version_id = gv.id
	//      JOIN build_sums bs ON l.build_sum_id = bs.id
	//      JOIN git_revisions gr ON l.git_revision_id = gr.id
	//  WHERE
	//      created_at BETWEEN ? AND ?
	ListLogsWithJoinByDate(
		ctx context.Context,
		arg *ListLogsWithJoinByDateParams,
	) ([]ListLogsWithJoinByDateRow, error)
	//ListLogsWithJoinByDatePaginated
	//
	//  SELECT
	//      l.id,
	//      l.created_at,
	//      l.user_agent,
	//      l.method,
	//      l.url,
	//      l.elapsed_ns,
	//      l.level_id,
	//      le.name AS level_name,
	//      gv.name AS go_version_name,
	//      gv.version AS go_version,
	//      bs.build_sum,
	//      gr.git_revision
	//  FROM
	//      api_logs l
	//      JOIN log_levels le ON l.level_id = le.id
	//      JOIN deployments d ON l.deployment_id = d.id
	//      JOIN go_versions gv ON l.go_version_id = gv.id
	//      JOIN build_sums bs ON l.build_sum_id = bs.id
	//      JOIN git_revisions gr ON l.git_revision_id = gr.id
	//  WHERE
	//      created_at BETWEEN ? AND ?
	//  LIMIT
	//      ? OFFSET ?
	ListLogsWithJoinByDatePaginated(
		ctx context.Context,
		arg *ListLogsWithJoinByDatePaginatedParams,
	) ([]ListLogsWithJoinByDatePaginatedRow, error)
	//ListLogsWithJoinByDateRange
	//
	//  SELECT
	//      l.id,
	//      l.created_at,
	//      l.user_agent,
	//      l.method,
	//      l.url,
	//      l.elapsed_ns,
	//      l.level_id,
	//      le.name AS level_name,
	//      gv.name AS go_version_name,
	//      gv.version AS go_version,
	//      bs.build_sum,
	//      gr.git_revision
	//  FROM
	//      api_logs l
	//      JOIN log_levels le ON l.level_id = le.id
	//      JOIN deployments d ON l.deployment_id = d.id
	//      JOIN go_versions gv ON l.go_version_id = gv.id
	//      JOIN build_sums bs ON l.build_sum_id = bs.id
	//      JOIN git_revisions gr ON l.git_revision_id = gr.id
	//  WHERE
	//      created_at BETWEEN ? AND ?
	ListLogsWithJoinByDateRange(
		ctx context.Context,
		arg *ListLogsWithJoinByDateRangeParams,
	) ([]ListLogsWithJoinByDateRangeRow, error)
	//ListLogsWithJoinByDateRangePaginated
	//
	//  SELECT
	//      l.id,
	//      l.created_at,
	//      l.user_agent,
	//      l.method,
	//      l.url,
	//      l.elapsed_ns,
	//      l.level_id,
	//      le.name AS level_name,
	//      gv.name AS go_version_name,
	//      gv.version AS go_version,
	//      bs.build_sum,
	//      gr.git_revision
	//  FROM
	//      api_logs l
	//      JOIN log_levels le ON l.level_id = le.id
	//      JOIN deployments d ON l.deployment_id = d.id
	//      JOIN go_versions gv ON l.go_version_id = gv.id
	//      JOIN build_sums bs ON l.build_sum_id = bs.id
	//      JOIN git_revisions gr ON l.git_revision_id = gr.id
	//  WHERE
	//      created_at BETWEEN ? AND ?
	//  LIMIT
	//      ? OFFSET ?
	ListLogsWithJoinByDateRangePaginated(
		ctx context.Context,
		arg *ListLogsWithJoinByDateRangePaginatedParams,
	) ([]ListLogsWithJoinByDateRangePaginatedRow, error)
	//ListLogsWithJoinByElapsedRange
	//
	//  SELECT
	//      l.id,
	//      l.created_at,
	//      l.user_agent,
	//      l.method,
	//      l.url,
	//      l.elapsed_ns,
	//      l.level_id,
	//      le.name AS level_name,
	//      gv.name AS go_version_name,
	//      gv.version AS go_version,
	//      bs.build_sum,
	//      gr.git_revision
	//  FROM
	//      api_logs l
	//      JOIN log_levels le ON l.level_id = le.id
	//      JOIN deployments d ON l.deployment_id = d.id
	//      JOIN go_versions gv ON l.go_version_id = gv.id
	//      JOIN build_sums bs ON l.build_sum_id = bs.id
	//      JOIN git_revisions gr ON l.git_revision_id = gr.id
	//  WHERE
	//      elapsed_ns BETWEEN ? AND ?
	ListLogsWithJoinByElapsedRange(
		ctx context.Context,
		arg *ListLogsWithJoinByElapsedRangeParams,
	) ([]ListLogsWithJoinByElapsedRangeRow, error)
	//ListLogsWithJoinByElapsedRangePaginated
	//
	//  SELECT
	//      l.id,
	//      l.created_at,
	//      l.user_agent,
	//      l.method,
	//      l.url,
	//      l.elapsed_ns,
	//      l.level_id,
	//      le.name AS level_name,
	//      gv.name AS go_version_name,
	//      gv.version AS go_version,
	//      bs.build_sum,
	//      gr.git_revision
	//  FROM
	//      api_logs l
	//      JOIN log_levels le ON l.level_id = le.id
	//      JOIN deployments d ON l.deployment_id = d.id
	//      JOIN go_versions gv ON l.go_version_id = gv.id
	//      JOIN build_sums bs ON l.build_sum_id = bs.id
	//      JOIN git_revisions gr ON l.git_revision_id = gr.id
	//  WHERE
	//      elapsed_ns BETWEEN ? AND ?
	//  LIMIT
	//      ? OFFSET ?
	ListLogsWithJoinByElapsedRangePaginated(
		ctx context.Context,
		arg *ListLogsWithJoinByElapsedRangePaginatedParams,
	) ([]ListLogsWithJoinByElapsedRangePaginatedRow, error)
	//ListLogsWithJoinByGitRevisionID
	//
	//  SELECT
	//      l.id,
	//      l.created_at,
	//      l.user_agent,
	//      l.method,
	//      l.url,
	//      l.elapsed_ns,
	//      l.level_id,
	//      le.name AS level_name,
	//      gv.name AS go_version_name,
	//      gv.version AS go_version,
	//      bs.build_sum,
	//      gr.git_revision
	//  FROM
	//      api_logs l
	//      JOIN log_levels le ON l.level_id = le.id
	//      JOIN deployments d ON l.deployment_id = d.id
	//      JOIN go_versions gv ON l.go_version_id = gv.id
	//      JOIN build_sums bs ON l.build_sum_id = bs.id
	//      JOIN git_revisions gr ON l.git_revision_id = gr.id
	//  WHERE
	//      gr.id = ?
	ListLogsWithJoinByGitRevisionID(
		ctx context.Context,
		arg *ListLogsWithJoinByGitRevisionIDParams,
	) ([]ListLogsWithJoinByGitRevisionIDRow, error)
	//ListLogsWithJoinByGitRevisionIDPaginated
	//
	//  SELECT
	//      l.id,
	//      l.created_at,
	//      l.user_agent,
	//      l.method,
	//      l.url,
	//      l.elapsed_ns,
	//      l.level_id,
	//      le.name AS level_name,
	//      gv.name AS go_version_name,
	//      gv.version AS go_version,
	//      bs.build_sum,
	//      gr.git_revision
	//  FROM
	//      api_logs l
	//      JOIN log_levels le ON l.level_id = le.id
	//      JOIN deployments d ON l.deployment_id = d.id
	//      JOIN go_versions gv ON l.go_version_id = gv.id
	//      JOIN build_sums bs ON l.build_sum_id = bs.id
	//      JOIN git_revisions gr ON l.git_revision_id = gr.id
	//  WHERE
	//      gr.id = ?
	ListLogsWithJoinByGitRevisionIDPaginated(
		ctx context.Context,
		arg *ListLogsWithJoinByGitRevisionIDPaginatedParams,
	) ([]ListLogsWithJoinByGitRevisionIDPaginatedRow, error)
	//ListLogsWithJoinByGoVersionID
	//
	//  SELECT
	//      l.id,
	//      l.created_at,
	//      l.user_agent,
	//      l.method,
	//      l.url,
	//      l.elapsed_ns,
	//      l.level_id,
	//      le.name AS level_name,
	//      gv.name AS go_version_name,
	//      gv.version AS go_version,
	//      bs.build_sum,
	//      gr.git_revision
	//  FROM
	//      api_logs l
	//      JOIN log_levels le ON l.level_id = le.id
	//      JOIN deployments d ON l.deployment_id = d.id
	//      JOIN go_versions gv ON l.go_version_id = gv.id
	//      JOIN build_sums bs ON l.build_sum_id = bs.id
	//      JOIN git_revisions gr ON l.git_revision_id = gr.id
	//  WHERE
	//      gv.id = ?
	ListLogsWithJoinByGoVersionID(
		ctx context.Context,
		arg *ListLogsWithJoinByGoVersionIDParams,
	) ([]ListLogsWithJoinByGoVersionIDRow, error)
	//ListLogsWithJoinByGoVersionIDPaginated
	//
	//  SELECT
	//      l.id,
	//      l.created_at,
	//      l.user_agent,
	//      l.method,
	//      l.url,
	//      l.elapsed_ns,
	//      l.level_id,
	//      le.name AS level_name,
	//      gv.name AS go_version_name,
	//      gv.version AS go_version,
	//      bs.build_sum,
	//      gr.git_revision
	//  FROM
	//      api_logs l
	//      JOIN log_levels le ON l.level_id = le.id
	//      JOIN deployments d ON l.deployment_id = d.id
	//      JOIN go_versions gv ON l.go_version_id = gv.id
	//      JOIN build_sums bs ON l.build_sum_id = bs.id
	//      JOIN git_revisions gr ON l.git_revision_id = gr.id
	//  WHERE
	//      gv.id = ?
	ListLogsWithJoinByGoVersionIDPaginated(
		ctx context.Context,
		arg *ListLogsWithJoinByGoVersionIDPaginatedParams,
	) ([]ListLogsWithJoinByGoVersionIDPaginatedRow, error)
	//ListLogsWithJoinPaginated
	//
	//  SELECT
	//      l.id,
	//      l.created_at,
	//      l.user_agent,
	//      l.method,
	//      l.url,
	//      l.elapsed_ns,
	//      l.level_id,
	//      le.name AS level_name,
	//      gv.name AS go_version_name,
	//      gv.version AS go_version,
	//      bs.build_sum,
	//      gr.git_revision
	//  FROM
	//      api_logs l
	//      JOIN log_levels le ON l.level_id = le.id
	//      JOIN deployments d ON l.deployment_id = d.id
	//      JOIN go_versions gv ON l.go_version_id = gv.id
	//      JOIN build_sums bs ON l.build_sum_id = bs.id
	//      JOIN git_revisions gr ON l.git_revision_id = gr.id
	//  LIMIT
	//      ? OFFSET ?
	ListLogsWithJoinPaginated(
		ctx context.Context,
		arg *ListLogsWithJoinPaginatedParams,
	) ([]ListLogsWithJoinPaginatedRow, error)
	//ListURLs
	//
	//  SELECT
	//      id, url, created_at
	//  FROM
	//      urls
	ListURLs(ctx context.Context) ([]Url, error)
	//ListURLsPaginated
	//
	//  SELECT
	//      id, url, created_at
	//  FROM
	//      urls
	//  LIMIT
	//      ? OFFSET ?
	ListURLsPaginated(
		ctx context.Context,
		arg *ListURLsPaginatedParams,
	) ([]Url, error)
	//UpdateGoVersionByID
	//
	//  UPDATE
	//      go_versions
	//  SET
	//      name = ?,
	//      version = ?
	//  WHERE
	//      id = 1
	UpdateGoVersionByID(
		ctx context.Context,
		arg *UpdateGoVersionByIDParams,
	) error
}

Querier is the interface for the Queries type and is used to simplify the queries interface by defining a common interface for a type that can be used to run the defined queries.

// vim regex to fix the commenting // :%s#//\([a-z]\)#// \1#g

Example: 

db, err := sql.Open("sqlite", "my.db")
if err != nil {
	log.Fatal(err)
}
q := data.New(db)
var count int64
err := q.SelectCount(ctx, &count)
if err != nil {
    return err
}
fmt.Printf("count: %v\n", count)

type Queries 

type Queries struct {
	// contains filtered or unexported fields
}

Queries defines the queries that are run against the database. These queries can be executed by the query method on the Queries type, or can be used by the *sql.Rows methods.

Example: 

     out, err := queries.CountGitRevisions(ctx context.Context)
	if err != nil {
	    return err
	}
     println(out) // number of git revisions

func New deprecated 

func New(db DBTX) *Queries

New creates a new instance of the Queries with the provided transaction. The provided transaction must be committed and rolled back when the instance is no longer needed.

Example: 

        db, err := sql.Open("sqlite", "my.db")
	if err != nil {
		log.Fatal(err)
	}
	tx, err := db.Begin()
	if err != nil {
	    return err
	}
	q := data.New(tx)
	defer q.Close()

Deprecated: use NewLogsDatabase instead

func NewLogsDatabase 

func NewLogsDatabase(
	getenv func(string) (string, error),
	db *sql.DB,
) (*Queries, error)

NewLogsDatabase creates a new logs database queries for an logs database. It takes as input a sql database and returns the queries struct for a logs database. additionaly, it will execute the sql schema for the logs database.

Example: 

db, err := sql.Open("sqlite", "my.db")
if err != nil {
	log.Fatal(err)
}
defer db.Close()
getenv := func(key string) string {
	switch key {
	case "DEPLOYMENT":
		return "staging"
	default:
		return ""
	}
}
q := NewLogsDatabase(db)

func (*Queries) CountBuildSums 

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

file: build_sums.sql url: github.com/conneroisu/dblogger/data/queries/build_sums.sql description: build_sums.sql is 

SELECT
    COUNT(*)
FROM
    build_sums

func (*Queries) CountDeployments 

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

file: deployments.sql url: github.com/conneroisu/dblogger/data/queries/deployments.sql description: deployments.sql is 

SELECT
    COUNT(*)
FROM
    deployments

func (*Queries) CountGitRevisions 

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

file: git_revisions.sql url: github.com/conneroisu/dblogger/data/queries/git_revisions.sql description: git_revisions.sql is 

SELECT
    COUNT(*)
FROM
    git_revisions

func (*Queries) CountGoVersions 

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

file: go_versions.sql url: github.com/conneroisu/dblogger/data/queries/go_versions.sql description: go_versions.sql is 

SELECT
    COUNT(*)
FROM
    go_versions

func (*Queries) CountLogLevels 

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

file: log_levels.sql url: github.com/conneroisu/dblogger/data/queries/log_levels.sql description: log_levels.sql is 

SELECT
    COUNT(*)
FROM
    log_levels

func (*Queries) CountLogs 

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

file: api_logs.sql url: github.com/conneroisu/dblogger/data/queries/api_logs.sql description: api_logs.sql is 

SELECT
    COUNT(*)
FROM
    api_logs

func (*Queries) CountURLs 

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

file: urls.sql url: github.com/conneroisu/dblogger/data/queries/urls.sql description: urls.sql is 

SELECT
    COUNT(*)
FROM
    urls

func (*Queries) DeleteBuildSumByID 

func (q *Queries) DeleteBuildSumByID(
	ctx context.Context,
	arg *DeleteBuildSumByIDParams,
) error

DeleteBuildSumByID 

DELETE FROM
    build_sums
WHERE
    id = ?

func (*Queries) DeleteDeploymentByID 

func (q *Queries) DeleteDeploymentByID(
	ctx context.Context,
	arg *DeleteDeploymentByIDParams,
) error

DeleteDeploymentByID 

DELETE FROM
    deployments
WHERE
    id = ?

func (*Queries) DeleteGitRevisionByID 

func (q *Queries) DeleteGitRevisionByID(
	ctx context.Context,
	arg *DeleteGitRevisionByIDParams,
) error

DeleteGitRevisionByID 

DELETE FROM
    git_revisions
WHERE
    id = ?

func (*Queries) DeleteGoVersionByID 

func (q *Queries) DeleteGoVersionByID(ctx context.Context) error

DeleteGoVersionByID 

DELETE FROM
    go_versions
WHERE
    id = 1

func (*Queries) DeleteLogByID 

func (q *Queries) DeleteLogByID(
	ctx context.Context,
	arg *DeleteLogByIDParams,
) error

DeleteLogByID 

DELETE FROM
    api_logs
WHERE
    id = ?

func (*Queries) DeleteLogLevelByID 

func (q *Queries) DeleteLogLevelByID(
	ctx context.Context,
	arg *DeleteLogLevelByIDParams,
) error

DeleteLogLevelByID 

DELETE FROM
    log_levels
WHERE
    id = ?

func (*Queries) DeleteURLByID 

func (q *Queries) DeleteURLByID(
	ctx context.Context,
	arg *DeleteURLByIDParams,
) error

DeleteURLByID 

DELETE FROM
    urls
WHERE
    id = ?

func (*Queries) GetBuildSumByID 

func (q *Queries) GetBuildSumByID(
	ctx context.Context,
	arg *GetBuildSumByIDParams,
) (BuildSum, error)

GetBuildSumByID 

SELECT
    id, build_sum, created_at
FROM
    build_sums
WHERE
    id = ?

func (*Queries) GetBuildSumsByDate 

func (q *Queries) GetBuildSumsByDate(
	ctx context.Context,
	arg *GetBuildSumsByDateParams,
) ([]BuildSum, error)

GetBuildSumsByDate 

SELECT
    id, build_sum, created_at
FROM
    build_sums
WHERE
    created_at >= ?

func (*Queries) GetBuildSumsBySubstring 

func (q *Queries) GetBuildSumsBySubstring(
	ctx context.Context,
	arg *GetBuildSumsBySubstringParams,
) ([]BuildSum, error)

GetBuildSumsBySubstring 

SELECT
    id, build_sum, created_at
FROM
    build_sums
WHERE
    build_sum LIKE ?

func (*Queries) GetDeploymentByID 

func (q *Queries) GetDeploymentByID(
	ctx context.Context,
	arg *GetDeploymentByIDParams,
) (Deployment, error)

GetDeploymentByID 

SELECT
    id, name, created_at, updated_at
FROM
    deployments
WHERE
    id = ?

func (*Queries) GetDeploymentsByDate 

func (q *Queries) GetDeploymentsByDate(
	ctx context.Context,
	arg *GetDeploymentsByDateParams,
) ([]Deployment, error)

GetDeploymentsByDate 

SELECT
    id, name, created_at, updated_at
FROM
    deployments
WHERE
    created_at >= ?

func (*Queries) GetDeploymentsByDateRange 

func (q *Queries) GetDeploymentsByDateRange(
	ctx context.Context,
	arg *GetDeploymentsByDateRangeParams,
) ([]Deployment, error)

GetDeploymentsByDateRange 

SELECT
    id, name, created_at, updated_at
FROM
    deployments
WHERE
    created_at BETWEEN ? AND ?

func (*Queries) GetDeploymentsBySubstring 

func (q *Queries) GetDeploymentsBySubstring(
	ctx context.Context,
	arg *GetDeploymentsBySubstringParams,
) ([]Deployment, error)

GetDeploymentsBySubstring 

SELECT
    id, name, created_at, updated_at
FROM
    deployments
WHERE
    name LIKE ?

func (*Queries) GetGitRevisionByID 

func (q *Queries) GetGitRevisionByID(
	ctx context.Context,
	arg *GetGitRevisionByIDParams,
) (GitRevision, error)

GetGitRevisionByID 

SELECT
    id, git_revision, created_at
FROM
    git_revisions
WHERE
    id = ?

func (*Queries) GetGitRevisionsByDate 

func (q *Queries) GetGitRevisionsByDate(
	ctx context.Context,
	arg *GetGitRevisionsByDateParams,
) ([]GitRevision, error)

GetGitRevisionsByDate 

SELECT
    id, git_revision, created_at
FROM
    git_revisions
WHERE
    created_at >= ?

func (*Queries) GetGitRevisionsByName 

func (q *Queries) GetGitRevisionsByName(
	ctx context.Context,
	arg *GetGitRevisionsByNameParams,
) (GitRevision, error)

GetGitRevisionsByName 

SELECT
    id, git_revision, created_at
FROM
    git_revisions
WHERE
    git_revision = ?

func (*Queries) GetGoVersionByID 

func (q *Queries) GetGoVersionByID(
	ctx context.Context,
	arg *GetGoVersionByIDParams,
) (GoVersion, error)

GetGoVersionByID 

SELECT
    id, name, version, created_at
FROM
    go_versions
WHERE
    id = ?

func (*Queries) GetGoVersionIdByName 

func (q *Queries) GetGoVersionIdByName(
	ctx context.Context,
	arg *GetGoVersionIdByNameParams,
) (int64, error)

GetGoVersionIdByName 

SELECT
    id
FROM
    go_versions
WHERE
    name = ?

func (*Queries) GetGoVersionsByDate 

func (q *Queries) GetGoVersionsByDate(
	ctx context.Context,
	arg *GetGoVersionsByDateParams,
) ([]GoVersion, error)

GetGoVersionsByDate 

SELECT
    id, name, version, created_at
FROM
    go_versions
WHERE
    created_at >= ?

func (*Queries) GetGoVersionsBySubstring 

func (q *Queries) GetGoVersionsBySubstring(
	ctx context.Context,
	arg *GetGoVersionsBySubstringParams,
) ([]GoVersion, error)

GetGoVersionsBySubstring 

SELECT
    id, name, version, created_at
FROM
    go_versions
WHERE
    name LIKE ?
    OR version LIKE ?

func (*Queries) GetLogByID 

func (q *Queries) GetLogByID(
	ctx context.Context,
	arg *GetLogByIDParams,
) (ApiLog, error)

GetLogByID 

SELECT
    id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
FROM
    api_logs
WHERE
    id = ?

func (*Queries) GetLogLevelsBySubstring 

func (q *Queries) GetLogLevelsBySubstring(
	ctx context.Context,
	arg *GetLogLevelsBySubstringParams,
) ([]LogLevel, error)

GetLogLevelsBySubstring 

SELECT
    id, name
FROM
    log_levels
WHERE
    name LIKE ?

func (*Queries) GetLogsByBuildSumID 

func (q *Queries) GetLogsByBuildSumID(
	ctx context.Context,
	arg *GetLogsByBuildSumIDParams,
) ([]ApiLog, error)

GetLogsByBuildSumID 

SELECT
    id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
FROM
    api_logs
WHERE
    build_sum_id = ?

func (*Queries) GetLogsByDate 

func (q *Queries) GetLogsByDate(
	ctx context.Context,
	arg *GetLogsByDateParams,
) ([]ApiLog, error)

GetLogsByDate 

SELECT
    id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
FROM
    api_logs
WHERE
    created_at >= ?

func (*Queries) GetLogsByDateRange 

func (q *Queries) GetLogsByDateRange(
	ctx context.Context,
	arg *GetLogsByDateRangeParams,
) ([]ApiLog, error)

GetLogsByDateRange 

SELECT
    id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
FROM
    api_logs
WHERE
    created_at BETWEEN ? AND ?

func (*Queries) GetLogsByElapsedRange 

func (q *Queries) GetLogsByElapsedRange(
	ctx context.Context,
	arg *GetLogsByElapsedRangeParams,
) ([]ApiLog, error)

GetLogsByElapsedRange 

SELECT
    id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
FROM
    api_logs
WHERE
    elapsed_ns BETWEEN ? AND ?

func (*Queries) GetLogsByGitRevisionID 

func (q *Queries) GetLogsByGitRevisionID(
	ctx context.Context,
	arg *GetLogsByGitRevisionIDParams,
) ([]ApiLog, error)

GetLogsByGitRevisionID 

SELECT
    id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
FROM
    api_logs
WHERE
    git_revision_id = ?

func (*Queries) GetLogsByGoVersionID 

func (q *Queries) GetLogsByGoVersionID(
	ctx context.Context,
	arg *GetLogsByGoVersionIDParams,
) ([]ApiLog, error)

GetLogsByGoVersionID 

SELECT
    id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
FROM
    api_logs
WHERE
    go_version_id = ?

func (*Queries) GetLogsByURLSubstring 

func (q *Queries) GetLogsByURLSubstring(
	ctx context.Context,
	arg *GetLogsByURLSubstringParams,
) ([]ApiLog, error)

GetLogsByURLSubstring 

SELECT
    id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
FROM
    api_logs
WHERE
    url LIKE ?

func (*Queries) GetURLByID 

func (q *Queries) GetURLByID(
	ctx context.Context,
	arg *GetURLByIDParams,
) (Url, error)

GetURLByID 

SELECT
    id, url, created_at
FROM
    urls
WHERE
    id = ?

func (*Queries) GetURLsByDate 

func (q *Queries) GetURLsByDate(
	ctx context.Context,
	arg *GetURLsByDateParams,
) ([]Url, error)

GetURLsByDate 

SELECT
    id, url, created_at
FROM
    urls
WHERE
    created_at >= ?

func (*Queries) GetURLsBySubstring 

func (q *Queries) GetURLsBySubstring(
	ctx context.Context,
	arg *GetURLsBySubstringParams,
) ([]Url, error)

GetURLsBySubstring 

SELECT
    id, url, created_at
FROM
    urls
WHERE
    url LIKE ?

func (*Queries) InsertBuildSum 

func (q *Queries) InsertBuildSum(
	ctx context.Context,
	arg *InsertBuildSumParams,
) (BuildSum, error)

InsertBuildSum 

INSERT INTO
    build_sums (build_sum)
VALUES
    (?) RETURNING id, build_sum, created_at

func (*Queries) InsertBuildSumReturningID 

func (q *Queries) InsertBuildSumReturningID(
	ctx context.Context,
	arg *InsertBuildSumReturningIDParams,
) (int64, error)

InsertBuildSumReturningID 

INSERT INTO
    build_sums (build_sum)
VALUES
    (?) RETURNING id

func (*Queries) InsertBuildSumWithParam 

func (q *Queries) InsertBuildSumWithParam(
	ctx context.Context,
	arg *InsertBuildSumWithParamParams,
) error

InsertBuildSumWithParam 

INSERT INTO
    build_sums (build_sum)
VALUES
    (?)

func (*Queries) InsertDeployment 

func (q *Queries) InsertDeployment(
	ctx context.Context,
	arg *InsertDeploymentParams,
) (Deployment, error)

InsertDeployment 

INSERT INTO
    deployments (name)
VALUES
    (?) RETURNING id, name, created_at, updated_at

func (*Queries) InsertDeploymentReturningID 

func (q *Queries) InsertDeploymentReturningID(
	ctx context.Context,
	arg *InsertDeploymentReturningIDParams,
) (int64, error)

InsertDeploymentReturningID 

INSERT INTO
    deployments (name)
VALUES
    (?) RETURNING id

func (*Queries) InsertGitRevision 

func (q *Queries) InsertGitRevision(
	ctx context.Context,
	arg *InsertGitRevisionParams,
) (GitRevision, error)

InsertGitRevision 

INSERT INTO
    git_revisions (git_revision)
VALUES
    (?) RETURNING id, git_revision, created_at

func (*Queries) InsertGitRevisionReturningID 

func (q *Queries) InsertGitRevisionReturningID(
	ctx context.Context,
	arg *InsertGitRevisionReturningIDParams,
) (int64, error)

InsertGitRevisionReturningID 

INSERT INTO
    git_revisions (git_revision)
VALUES
    (?) RETURNING id

func (*Queries) InsertGitRevisionWithParam 

func (q *Queries) InsertGitRevisionWithParam(
	ctx context.Context,
	arg *InsertGitRevisionWithParamParams,
) error

InsertGitRevisionWithParam 

INSERT INTO
    git_revisions (git_revision)
VALUES
    (?)

func (*Queries) InsertGoVersion 

func (q *Queries) InsertGoVersion(
	ctx context.Context,
	arg *InsertGoVersionParams,
) (GoVersion, error)

InsertGoVersion 

INSERT INTO
    go_versions (name, version)
VALUES
    (?, ?) RETURNING id, name, version, created_at

func (*Queries) InsertGoVersionReturningID 

func (q *Queries) InsertGoVersionReturningID(
	ctx context.Context,
	arg *InsertGoVersionReturningIDParams,
) (int64, error)

InsertGoVersionReturningID 

INSERT INTO
    go_versions (name, version)
VALUES
    (?, ?) RETURNING id

func (*Queries) InsertLogEntry 

func (q *Queries) InsertLogEntry(
	ctx context.Context,
	arg *InsertLogEntryParams,
) error

InsertLogEntry 

INSERT INTO
    api_logs (
        go_version_id,
        build_sum_id,
        git_revision_id,
        user_agent,
        method,
        url,
        elapsed_ns,
        deployment_id,
        level_id
    )
VALUES
    (?, ?, ?, ?, ?, ?, ?, ?, ?)

func (*Queries) InsertLogLevel 

func (q *Queries) InsertLogLevel(
	ctx context.Context,
	arg *InsertLogLevelParams,
) error

InsertLogLevel 

INSERT INTO
    log_levels (name)
VALUES
    (?)

func (*Queries) InsertURL 

func (q *Queries) InsertURL(ctx context.Context, arg *InsertURLParams) error

InsertURL 

INSERT INTO
    urls (url)
VALUES
    (?)

func (*Queries) InsertURLWithParam 

func (q *Queries) InsertURLWithParam(
	ctx context.Context,
	arg *InsertURLWithParamParams,
) error

InsertURLWithParam 

INSERT INTO
    urls (url)
VALUES
    (?)

func (*Queries) ListBuildSums 

func (q *Queries) ListBuildSums(ctx context.Context) ([]BuildSum, error)

ListBuildSums 

SELECT
    id, build_sum, created_at
FROM
    build_sums

func (*Queries) ListBuildSumsPaginated 

func (q *Queries) ListBuildSumsPaginated(
	ctx context.Context,
	arg *ListBuildSumsPaginatedParams,
) ([]BuildSum, error)

ListBuildSumsPaginated 

SELECT
    id, build_sum, created_at
FROM
    build_sums
LIMIT
    ? OFFSET ?

func (*Queries) ListDeployments 

func (q *Queries) ListDeployments(ctx context.Context) ([]Deployment, error)

ListDeployments 

SELECT
    id, name, created_at, updated_at
FROM
    deployments

func (*Queries) ListDeploymentsPaginated 

func (q *Queries) ListDeploymentsPaginated(
	ctx context.Context,
	arg *ListDeploymentsPaginatedParams,
) ([]Deployment, error)

ListDeploymentsPaginated 

SELECT
    id, name, created_at, updated_at
FROM
    deployments
LIMIT
    ? OFFSET ?

func (*Queries) ListGitRevisions 

func (q *Queries) ListGitRevisions(
	ctx context.Context,
) ([]GitRevision, error)

ListGitRevisions 

SELECT
    id, git_revision, created_at
FROM
    git_revisions

func (*Queries) ListGitRevisionsPaginated 

func (q *Queries) ListGitRevisionsPaginated(
	ctx context.Context,
	arg *ListGitRevisionsPaginatedParams,
) ([]GitRevision, error)

ListGitRevisionsPaginated 

SELECT
    id, git_revision, created_at
FROM
    git_revisions
LIMIT
    ? OFFSET ?

func (*Queries) ListGoVersions 

func (q *Queries) ListGoVersions(ctx context.Context) ([]GoVersion, error)

ListGoVersions 

SELECT
    id, name, version, created_at
FROM
    go_versions

func (*Queries) ListGoVersionsPaginated 

func (q *Queries) ListGoVersionsPaginated(
	ctx context.Context,
	arg *ListGoVersionsPaginatedParams,
) ([]GoVersion, error)

ListGoVersionsPaginated 

SELECT
    id, name, version, created_at
FROM
    go_versions
LIMIT
    ? OFFSET ?

func (*Queries) ListLogLevels 

func (q *Queries) ListLogLevels(ctx context.Context) ([]LogLevel, error)

ListLogLevels 

SELECT
    id, name
FROM
    log_levels

func (*Queries) ListLogLevelsPaginated 

func (q *Queries) ListLogLevelsPaginated(
	ctx context.Context,
	arg *ListLogLevelsPaginatedParams,
) ([]LogLevel, error)

ListLogLevelsPaginated 

SELECT
    id, name
FROM
    log_levels
LIMIT
    ? OFFSET ?

func (*Queries) ListLogs 

func (q *Queries) ListLogs(ctx context.Context) ([]ApiLog, error)

ListLogs 

SELECT
    id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
FROM
    api_logs

func (*Queries) ListLogsByDeploymentID 

func (q *Queries) ListLogsByDeploymentID(
	ctx context.Context,
	arg *ListLogsByDeploymentIDParams,
) ([]ApiLog, error)

ListLogsByDeploymentID 

SELECT
    id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
FROM
    api_logs
WHERE
    deployment_id = ?

func (*Queries) ListLogsByMethod 

func (q *Queries) ListLogsByMethod(
	ctx context.Context,
	arg *ListLogsByMethodParams,
) ([]ApiLog, error)

ListLogsByMethod 

SELECT
    id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
FROM
    api_logs
WHERE
    method = ?

func (*Queries) ListLogsByUserAgent 

func (q *Queries) ListLogsByUserAgent(
	ctx context.Context,
	arg *ListLogsByUserAgentParams,
) ([]ApiLog, error)

ListLogsByUserAgent 

SELECT
    id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
FROM
    api_logs
WHERE
    user_agent = ?

func (*Queries) ListLogsPaginated 

func (q *Queries) ListLogsPaginated(
	ctx context.Context,
	arg *ListLogsPaginatedParams,
) ([]ApiLog, error)

ListLogsPaginated 

SELECT
    id, level_id, created_at, go_version_id, build_sum_id, git_revision_id, user_agent, method, url, elapsed_ns, deployment_id
FROM
    api_logs
LIMIT
    ? OFFSET ?

func (*Queries) ListLogsWithJoin 

func (q *Queries) ListLogsWithJoin(
	ctx context.Context,
) ([]ListLogsWithJoinRow, error)

ListLogsWithJoin 

SELECT
    l.id,
    l.created_at,
    l.user_agent,
    l.method,
    l.url,
    l.elapsed_ns,
    l.level_id,
    le.name AS level_name,
    gv.name AS go_version_name,
    gv.version AS go_version,
    bs.build_sum,
    gr.git_revision
FROM
    api_logs l
    JOIN log_levels le ON l.level_id = le.id
    JOIN deployments d ON l.deployment_id = d.id
    JOIN go_versions gv ON l.go_version_id = gv.id
    JOIN build_sums bs ON l.build_sum_id = bs.id
    JOIN git_revisions gr ON l.git_revision_id = gr.id

func (*Queries) ListLogsWithJoinByBuildSumID 

func (q *Queries) ListLogsWithJoinByBuildSumID(
	ctx context.Context,
	arg *ListLogsWithJoinByBuildSumIDParams,
) ([]ListLogsWithJoinByBuildSumIDRow, error)

ListLogsWithJoinByBuildSumID 

SELECT
    l.id,
    l.created_at,
    l.user_agent,
    l.method,
    l.url,
    l.elapsed_ns,
    l.level_id,
    le.name AS level_name,
    gv.name AS go_version_name,
    gv.version AS go_version,
    bs.build_sum,
    gr.git_revision
FROM
    api_logs l
    JOIN log_levels le ON l.level_id = le.id
    JOIN deployments d ON l.deployment_id = d.id
    JOIN go_versions gv ON l.go_version_id = gv.id
    JOIN build_sums bs ON l.build_sum_id = bs.id
    JOIN git_revisions gr ON l.git_revision_id = gr.id
WHERE
    bs.id = ?

func (*Queries) ListLogsWithJoinByBuildSumIDPaginated 

func (q *Queries) ListLogsWithJoinByBuildSumIDPaginated(
	ctx context.Context,
	arg *ListLogsWithJoinByBuildSumIDPaginatedParams,
) ([]ListLogsWithJoinByBuildSumIDPaginatedRow, error)

ListLogsWithJoinByBuildSumIDPaginated 

SELECT
    l.id,
    l.created_at,
    l.user_agent,
    l.method,
    l.url,
    l.elapsed_ns,
    l.level_id,
    le.name AS level_name,
    gv.name AS go_version_name,
    gv.version AS go_version,
    bs.build_sum,
    gr.git_revision
FROM
    api_logs l
    JOIN log_levels le ON l.level_id = le.id
    JOIN deployments d ON l.deployment_id = d.id
    JOIN go_versions gv ON l.go_version_id = gv.id
    JOIN build_sums bs ON l.build_sum_id = bs.id
    JOIN git_revisions gr ON l.git_revision_id = gr.id
WHERE
    bs.id = ?

func (*Queries) ListLogsWithJoinByDate 

func (q *Queries) ListLogsWithJoinByDate(
	ctx context.Context,
	arg *ListLogsWithJoinByDateParams,
) ([]ListLogsWithJoinByDateRow, error)

ListLogsWithJoinByDate 

SELECT
    l.id,
    l.created_at,
    l.user_agent,
    l.method,
    l.url,
    l.elapsed_ns,
    l.level_id,
    le.name AS level_name,
    gv.name AS go_version_name,
    gv.version AS go_version,
    bs.build_sum,
    gr.git_revision
FROM
    api_logs l
    JOIN log_levels le ON l.level_id = le.id
    JOIN deployments d ON l.deployment_id = d.id
    JOIN go_versions gv ON l.go_version_id = gv.id
    JOIN build_sums bs ON l.build_sum_id = bs.id
    JOIN git_revisions gr ON l.git_revision_id = gr.id
WHERE
    created_at BETWEEN ? AND ?

func (*Queries) ListLogsWithJoinByDatePaginated 

func (q *Queries) ListLogsWithJoinByDatePaginated(
	ctx context.Context,
	arg *ListLogsWithJoinByDatePaginatedParams,
) ([]ListLogsWithJoinByDatePaginatedRow, error)

ListLogsWithJoinByDatePaginated 

SELECT
    l.id,
    l.created_at,
    l.user_agent,
    l.method,
    l.url,
    l.elapsed_ns,
    l.level_id,
    le.name AS level_name,
    gv.name AS go_version_name,
    gv.version AS go_version,
    bs.build_sum,
    gr.git_revision
FROM
    api_logs l
    JOIN log_levels le ON l.level_id = le.id
    JOIN deployments d ON l.deployment_id = d.id
    JOIN go_versions gv ON l.go_version_id = gv.id
    JOIN build_sums bs ON l.build_sum_id = bs.id
    JOIN git_revisions gr ON l.git_revision_id = gr.id
WHERE
    created_at BETWEEN ? AND ?
LIMIT
    ? OFFSET ?

func (*Queries) ListLogsWithJoinByDateRange 

func (q *Queries) ListLogsWithJoinByDateRange(
	ctx context.Context,
	arg *ListLogsWithJoinByDateRangeParams,
) ([]ListLogsWithJoinByDateRangeRow, error)

ListLogsWithJoinByDateRange 

SELECT
    l.id,
    l.created_at,
    l.user_agent,
    l.method,
    l.url,
    l.elapsed_ns,
    l.level_id,
    le.name AS level_name,
    gv.name AS go_version_name,
    gv.version AS go_version,
    bs.build_sum,
    gr.git_revision
FROM
    api_logs l
    JOIN log_levels le ON l.level_id = le.id
    JOIN deployments d ON l.deployment_id = d.id
    JOIN go_versions gv ON l.go_version_id = gv.id
    JOIN build_sums bs ON l.build_sum_id = bs.id
    JOIN git_revisions gr ON l.git_revision_id = gr.id
WHERE
    created_at BETWEEN ? AND ?

func (*Queries) ListLogsWithJoinByDateRangePaginated 

func (q *Queries) ListLogsWithJoinByDateRangePaginated(
	ctx context.Context,
	arg *ListLogsWithJoinByDateRangePaginatedParams,
) ([]ListLogsWithJoinByDateRangePaginatedRow, error)

ListLogsWithJoinByDateRangePaginated 

SELECT
    l.id,
    l.created_at,
    l.user_agent,
    l.method,
    l.url,
    l.elapsed_ns,
    l.level_id,
    le.name AS level_name,
    gv.name AS go_version_name,
    gv.version AS go_version,
    bs.build_sum,
    gr.git_revision
FROM
    api_logs l
    JOIN log_levels le ON l.level_id = le.id
    JOIN deployments d ON l.deployment_id = d.id
    JOIN go_versions gv ON l.go_version_id = gv.id
    JOIN build_sums bs ON l.build_sum_id = bs.id
    JOIN git_revisions gr ON l.git_revision_id = gr.id
WHERE
    created_at BETWEEN ? AND ?
LIMIT
    ? OFFSET ?

func (*Queries) ListLogsWithJoinByElapsedRange 

func (q *Queries) ListLogsWithJoinByElapsedRange(
	ctx context.Context,
	arg *ListLogsWithJoinByElapsedRangeParams,
) ([]ListLogsWithJoinByElapsedRangeRow, error)

ListLogsWithJoinByElapsedRange 

SELECT
    l.id,
    l.created_at,
    l.user_agent,
    l.method,
    l.url,
    l.elapsed_ns,
    l.level_id,
    le.name AS level_name,
    gv.name AS go_version_name,
    gv.version AS go_version,
    bs.build_sum,
    gr.git_revision
FROM
    api_logs l
    JOIN log_levels le ON l.level_id = le.id
    JOIN deployments d ON l.deployment_id = d.id
    JOIN go_versions gv ON l.go_version_id = gv.id
    JOIN build_sums bs ON l.build_sum_id = bs.id
    JOIN git_revisions gr ON l.git_revision_id = gr.id
WHERE
    elapsed_ns BETWEEN ? AND ?

func (*Queries) ListLogsWithJoinByElapsedRangePaginated 

func (q *Queries) ListLogsWithJoinByElapsedRangePaginated(
	ctx context.Context,
	arg *ListLogsWithJoinByElapsedRangePaginatedParams,
) ([]ListLogsWithJoinByElapsedRangePaginatedRow, error)

ListLogsWithJoinByElapsedRangePaginated 

SELECT
    l.id,
    l.created_at,
    l.user_agent,
    l.method,
    l.url,
    l.elapsed_ns,
    l.level_id,
    le.name AS level_name,
    gv.name AS go_version_name,
    gv.version AS go_version,
    bs.build_sum,
    gr.git_revision
FROM
    api_logs l
    JOIN log_levels le ON l.level_id = le.id
    JOIN deployments d ON l.deployment_id = d.id
    JOIN go_versions gv ON l.go_version_id = gv.id
    JOIN build_sums bs ON l.build_sum_id = bs.id
    JOIN git_revisions gr ON l.git_revision_id = gr.id
WHERE
    elapsed_ns BETWEEN ? AND ?
LIMIT
    ? OFFSET ?

func (*Queries) ListLogsWithJoinByGitRevisionID 

func (q *Queries) ListLogsWithJoinByGitRevisionID(
	ctx context.Context,
	arg *ListLogsWithJoinByGitRevisionIDParams,
) ([]ListLogsWithJoinByGitRevisionIDRow, error)

ListLogsWithJoinByGitRevisionID 

SELECT
    l.id,
    l.created_at,
    l.user_agent,
    l.method,
    l.url,
    l.elapsed_ns,
    l.level_id,
    le.name AS level_name,
    gv.name AS go_version_name,
    gv.version AS go_version,
    bs.build_sum,
    gr.git_revision
FROM
    api_logs l
    JOIN log_levels le ON l.level_id = le.id
    JOIN deployments d ON l.deployment_id = d.id
    JOIN go_versions gv ON l.go_version_id = gv.id
    JOIN build_sums bs ON l.build_sum_id = bs.id
    JOIN git_revisions gr ON l.git_revision_id = gr.id
WHERE
    gr.id = ?

func (*Queries) ListLogsWithJoinByGitRevisionIDPaginated 

func (q *Queries) ListLogsWithJoinByGitRevisionIDPaginated(
	ctx context.Context,
	arg *ListLogsWithJoinByGitRevisionIDPaginatedParams,
) ([]ListLogsWithJoinByGitRevisionIDPaginatedRow, error)

ListLogsWithJoinByGitRevisionIDPaginated 

SELECT
    l.id,
    l.created_at,
    l.user_agent,
    l.method,
    l.url,
    l.elapsed_ns,
    l.level_id,
    le.name AS level_name,
    gv.name AS go_version_name,
    gv.version AS go_version,
    bs.build_sum,
    gr.git_revision
FROM
    api_logs l
    JOIN log_levels le ON l.level_id = le.id
    JOIN deployments d ON l.deployment_id = d.id
    JOIN go_versions gv ON l.go_version_id = gv.id
    JOIN build_sums bs ON l.build_sum_id = bs.id
    JOIN git_revisions gr ON l.git_revision_id = gr.id
WHERE
    gr.id = ?

func (*Queries) ListLogsWithJoinByGoVersionID 

func (q *Queries) ListLogsWithJoinByGoVersionID(
	ctx context.Context,
	arg *ListLogsWithJoinByGoVersionIDParams,
) ([]ListLogsWithJoinByGoVersionIDRow, error)

ListLogsWithJoinByGoVersionID 

SELECT
    l.id,
    l.created_at,
    l.user_agent,
    l.method,
    l.url,
    l.elapsed_ns,
    l.level_id,
    le.name AS level_name,
    gv.name AS go_version_name,
    gv.version AS go_version,
    bs.build_sum,
    gr.git_revision
FROM
    api_logs l
    JOIN log_levels le ON l.level_id = le.id
    JOIN deployments d ON l.deployment_id = d.id
    JOIN go_versions gv ON l.go_version_id = gv.id
    JOIN build_sums bs ON l.build_sum_id = bs.id
    JOIN git_revisions gr ON l.git_revision_id = gr.id
WHERE
    gv.id = ?

func (*Queries) ListLogsWithJoinByGoVersionIDPaginated 

func (q *Queries) ListLogsWithJoinByGoVersionIDPaginated(
	ctx context.Context,
	arg *ListLogsWithJoinByGoVersionIDPaginatedParams,
) ([]ListLogsWithJoinByGoVersionIDPaginatedRow, error)

ListLogsWithJoinByGoVersionIDPaginated 

SELECT
    l.id,
    l.created_at,
    l.user_agent,
    l.method,
    l.url,
    l.elapsed_ns,
    l.level_id,
    le.name AS level_name,
    gv.name AS go_version_name,
    gv.version AS go_version,
    bs.build_sum,
    gr.git_revision
FROM
    api_logs l
    JOIN log_levels le ON l.level_id = le.id
    JOIN deployments d ON l.deployment_id = d.id
    JOIN go_versions gv ON l.go_version_id = gv.id
    JOIN build_sums bs ON l.build_sum_id = bs.id
    JOIN git_revisions gr ON l.git_revision_id = gr.id
WHERE
    gv.id = ?

func (*Queries) ListLogsWithJoinPaginated 

func (q *Queries) ListLogsWithJoinPaginated(
	ctx context.Context,
	arg *ListLogsWithJoinPaginatedParams,
) ([]ListLogsWithJoinPaginatedRow, error)

ListLogsWithJoinPaginated 

SELECT
    l.id,
    l.created_at,
    l.user_agent,
    l.method,
    l.url,
    l.elapsed_ns,
    l.level_id,
    le.name AS level_name,
    gv.name AS go_version_name,
    gv.version AS go_version,
    bs.build_sum,
    gr.git_revision
FROM
    api_logs l
    JOIN log_levels le ON l.level_id = le.id
    JOIN deployments d ON l.deployment_id = d.id
    JOIN go_versions gv ON l.go_version_id = gv.id
    JOIN build_sums bs ON l.build_sum_id = bs.id
    JOIN git_revisions gr ON l.git_revision_id = gr.id
LIMIT
    ? OFFSET ?

func (*Queries) ListURLs 

func (q *Queries) ListURLs(ctx context.Context) ([]Url, error)

ListURLs 

SELECT
    id, url, created_at
FROM
    urls

func (*Queries) ListURLsPaginated 

func (q *Queries) ListURLsPaginated(
	ctx context.Context,
	arg *ListURLsPaginatedParams,
) ([]Url, error)

ListURLsPaginated 

SELECT
    id, url, created_at
FROM
    urls
LIMIT
    ? OFFSET ?

func (*Queries) UpdateGoVersionByID 

func (q *Queries) UpdateGoVersionByID(
	ctx context.Context,
	arg *UpdateGoVersionByIDParams,
) error

UpdateGoVersionByID 

UPDATE
    go_versions
SET
    name = ?,
    version = ?
WHERE
    id = 1

func (*Queries) WithTx 

func (q *Queries) WithTx(tx *sql.Tx) *Queries

WithTx returns a new Queries instance that is already associated with the provided transaction.

Example: 

tx, err := db.Begin()
if err != nil {
    return err
}
q := dblogger.New(tx)

func (*Queries) Write 

func (q *Queries) Write(p []byte) (n int, err error)

Write writes the data to the database. This makes the Queries type implement the io.Writer interface.

func (*Queries) WriteLevel 

func (q *Queries) WriteLevel(
	level zerolog.Level,
	p []byte,
) (n int, err error)

WriteLevel writes the data to the database with the provided level. This makes the Queries type implement the zerolog.LevelWriter interface.

type UpdateGoVersionByIDParams 

type UpdateGoVersionByIDParams struct {
	Name    string `db:"name"    json:"name"`
	Version string `db:"version" json:"version"`
}

type Url 

type Url struct {
	ID        int64  `db:"id"         json:"id"`
	Url       string `db:"url"        json:"url"`
	CreatedAt string `db:"created_at" json:"created_at"`
}

Source Files

View all Source files

Directories

Path Synopsis
examples
sqlite command

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.