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

Directories

Path Synopsis
examples

Jump to

Keyboard shortcuts

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