Documentation
¶
Index ¶
- Variables
- type ApiLog
- type BuildSum
- type DBTX
- type DeleteBuildSumByIDParams
- type DeleteDeploymentByIDParams
- type DeleteGitRevisionByIDParams
- type DeleteLogByIDParams
- type DeleteLogLevelByIDParams
- type DeleteURLByIDParams
- type Deployment
- type GetBuildSumByIDParams
- type GetBuildSumsByDateParams
- type GetBuildSumsBySubstringParams
- type GetDeploymentByIDParams
- type GetDeploymentsByDateParams
- type GetDeploymentsByDateRangeParams
- type GetDeploymentsBySubstringParams
- type GetGitRevisionByIDParams
- type GetGitRevisionsByDateParams
- type GetGitRevisionsByNameParams
- type GetGoVersionByIDParams
- type GetGoVersionIdByNameParams
- type GetGoVersionsByDateParams
- type GetGoVersionsBySubstringParams
- type GetLogByIDParams
- type GetLogLevelsBySubstringParams
- type GetLogsByBuildSumIDParams
- type GetLogsByDateParams
- type GetLogsByDateRangeParams
- type GetLogsByElapsedRangeParams
- type GetLogsByGitRevisionIDParams
- type GetLogsByGoVersionIDParams
- type GetLogsByURLSubstringParams
- type GetURLByIDParams
- type GetURLsByDateParams
- type GetURLsBySubstringParams
- type GitRevision
- type GoVersion
- type InsertBuildSumParams
- type InsertBuildSumReturningIDParams
- type InsertBuildSumWithParamParams
- type InsertDeploymentParams
- type InsertDeploymentReturningIDParams
- type InsertGitRevisionParams
- type InsertGitRevisionReturningIDParams
- type InsertGitRevisionWithParamParams
- type InsertGoVersionParams
- type InsertGoVersionReturningIDParams
- type InsertLogEntryParams
- type InsertLogLevelParams
- type InsertURLParams
- type InsertURLWithParamParams
- type ListBuildSumsPaginatedParams
- type ListDeploymentsPaginatedParams
- type ListGitRevisionsPaginatedParams
- type ListGoVersionsPaginatedParams
- type ListLogLevelsPaginatedParams
- type ListLogsByDeploymentIDParams
- type ListLogsByMethodParams
- type ListLogsByUserAgentParams
- type ListLogsPaginatedParams
- type ListLogsWithJoinByBuildSumIDPaginatedParams
- type ListLogsWithJoinByBuildSumIDPaginatedRow
- type ListLogsWithJoinByBuildSumIDParams
- type ListLogsWithJoinByBuildSumIDRow
- type ListLogsWithJoinByDatePaginatedParams
- type ListLogsWithJoinByDatePaginatedRow
- type ListLogsWithJoinByDateParams
- type ListLogsWithJoinByDateRangePaginatedParams
- type ListLogsWithJoinByDateRangePaginatedRow
- type ListLogsWithJoinByDateRangeParams
- type ListLogsWithJoinByDateRangeRow
- type ListLogsWithJoinByDateRow
- type ListLogsWithJoinByElapsedRangePaginatedParams
- type ListLogsWithJoinByElapsedRangePaginatedRow
- type ListLogsWithJoinByElapsedRangeParams
- type ListLogsWithJoinByElapsedRangeRow
- type ListLogsWithJoinByGitRevisionIDPaginatedParams
- type ListLogsWithJoinByGitRevisionIDPaginatedRow
- type ListLogsWithJoinByGitRevisionIDParams
- type ListLogsWithJoinByGitRevisionIDRow
- type ListLogsWithJoinByGoVersionIDPaginatedParams
- type ListLogsWithJoinByGoVersionIDPaginatedRow
- type ListLogsWithJoinByGoVersionIDParams
- type ListLogsWithJoinByGoVersionIDRow
- type ListLogsWithJoinPaginatedParams
- type ListLogsWithJoinPaginatedRow
- type ListLogsWithJoinRow
- type ListURLsPaginatedParams
- type LogLevel
- type Querier
- type Queries
- func (q *Queries) CountBuildSums(ctx context.Context) (int64, error)
- func (q *Queries) CountDeployments(ctx context.Context) (int64, error)
- func (q *Queries) CountGitRevisions(ctx context.Context) (int64, error)
- func (q *Queries) CountGoVersions(ctx context.Context) (int64, error)
- func (q *Queries) CountLogLevels(ctx context.Context) (int64, error)
- func (q *Queries) CountLogs(ctx context.Context) (int64, error)
- func (q *Queries) CountURLs(ctx context.Context) (int64, error)
- func (q *Queries) DeleteBuildSumByID(ctx context.Context, arg *DeleteBuildSumByIDParams) error
- func (q *Queries) DeleteDeploymentByID(ctx context.Context, arg *DeleteDeploymentByIDParams) error
- func (q *Queries) DeleteGitRevisionByID(ctx context.Context, arg *DeleteGitRevisionByIDParams) error
- func (q *Queries) DeleteGoVersionByID(ctx context.Context) error
- func (q *Queries) DeleteLogByID(ctx context.Context, arg *DeleteLogByIDParams) error
- func (q *Queries) DeleteLogLevelByID(ctx context.Context, arg *DeleteLogLevelByIDParams) error
- func (q *Queries) DeleteURLByID(ctx context.Context, arg *DeleteURLByIDParams) error
- func (q *Queries) GetBuildSumByID(ctx context.Context, arg *GetBuildSumByIDParams) (BuildSum, error)
- func (q *Queries) GetBuildSumsByDate(ctx context.Context, arg *GetBuildSumsByDateParams) ([]BuildSum, error)
- func (q *Queries) GetBuildSumsBySubstring(ctx context.Context, arg *GetBuildSumsBySubstringParams) ([]BuildSum, error)
- func (q *Queries) GetDeploymentByID(ctx context.Context, arg *GetDeploymentByIDParams) (Deployment, error)
- func (q *Queries) GetDeploymentsByDate(ctx context.Context, arg *GetDeploymentsByDateParams) ([]Deployment, error)
- func (q *Queries) GetDeploymentsByDateRange(ctx context.Context, arg *GetDeploymentsByDateRangeParams) ([]Deployment, error)
- func (q *Queries) GetDeploymentsBySubstring(ctx context.Context, arg *GetDeploymentsBySubstringParams) ([]Deployment, error)
- func (q *Queries) GetGitRevisionByID(ctx context.Context, arg *GetGitRevisionByIDParams) (GitRevision, error)
- func (q *Queries) GetGitRevisionsByDate(ctx context.Context, arg *GetGitRevisionsByDateParams) ([]GitRevision, error)
- func (q *Queries) GetGitRevisionsByName(ctx context.Context, arg *GetGitRevisionsByNameParams) (GitRevision, error)
- func (q *Queries) GetGoVersionByID(ctx context.Context, arg *GetGoVersionByIDParams) (GoVersion, error)
- func (q *Queries) GetGoVersionIdByName(ctx context.Context, arg *GetGoVersionIdByNameParams) (int64, error)
- func (q *Queries) GetGoVersionsByDate(ctx context.Context, arg *GetGoVersionsByDateParams) ([]GoVersion, error)
- func (q *Queries) GetGoVersionsBySubstring(ctx context.Context, arg *GetGoVersionsBySubstringParams) ([]GoVersion, error)
- func (q *Queries) GetLogByID(ctx context.Context, arg *GetLogByIDParams) (ApiLog, error)
- func (q *Queries) GetLogLevelsBySubstring(ctx context.Context, arg *GetLogLevelsBySubstringParams) ([]LogLevel, error)
- func (q *Queries) GetLogsByBuildSumID(ctx context.Context, arg *GetLogsByBuildSumIDParams) ([]ApiLog, error)
- func (q *Queries) GetLogsByDate(ctx context.Context, arg *GetLogsByDateParams) ([]ApiLog, error)
- func (q *Queries) GetLogsByDateRange(ctx context.Context, arg *GetLogsByDateRangeParams) ([]ApiLog, error)
- func (q *Queries) GetLogsByElapsedRange(ctx context.Context, arg *GetLogsByElapsedRangeParams) ([]ApiLog, error)
- func (q *Queries) GetLogsByGitRevisionID(ctx context.Context, arg *GetLogsByGitRevisionIDParams) ([]ApiLog, error)
- func (q *Queries) GetLogsByGoVersionID(ctx context.Context, arg *GetLogsByGoVersionIDParams) ([]ApiLog, error)
- func (q *Queries) GetLogsByURLSubstring(ctx context.Context, arg *GetLogsByURLSubstringParams) ([]ApiLog, error)
- func (q *Queries) GetURLByID(ctx context.Context, arg *GetURLByIDParams) (Url, error)
- func (q *Queries) GetURLsByDate(ctx context.Context, arg *GetURLsByDateParams) ([]Url, error)
- func (q *Queries) GetURLsBySubstring(ctx context.Context, arg *GetURLsBySubstringParams) ([]Url, error)
- func (q *Queries) InsertBuildSum(ctx context.Context, arg *InsertBuildSumParams) (BuildSum, error)
- func (q *Queries) InsertBuildSumReturningID(ctx context.Context, arg *InsertBuildSumReturningIDParams) (int64, error)
- func (q *Queries) InsertBuildSumWithParam(ctx context.Context, arg *InsertBuildSumWithParamParams) error
- func (q *Queries) InsertDeployment(ctx context.Context, arg *InsertDeploymentParams) (Deployment, error)
- func (q *Queries) InsertDeploymentReturningID(ctx context.Context, arg *InsertDeploymentReturningIDParams) (int64, error)
- func (q *Queries) InsertGitRevision(ctx context.Context, arg *InsertGitRevisionParams) (GitRevision, error)
- func (q *Queries) InsertGitRevisionReturningID(ctx context.Context, arg *InsertGitRevisionReturningIDParams) (int64, error)
- func (q *Queries) InsertGitRevisionWithParam(ctx context.Context, arg *InsertGitRevisionWithParamParams) error
- func (q *Queries) InsertGoVersion(ctx context.Context, arg *InsertGoVersionParams) (GoVersion, error)
- func (q *Queries) InsertGoVersionReturningID(ctx context.Context, arg *InsertGoVersionReturningIDParams) (int64, error)
- func (q *Queries) InsertLogEntry(ctx context.Context, arg *InsertLogEntryParams) error
- func (q *Queries) InsertLogLevel(ctx context.Context, arg *InsertLogLevelParams) error
- func (q *Queries) InsertURL(ctx context.Context, arg *InsertURLParams) error
- func (q *Queries) InsertURLWithParam(ctx context.Context, arg *InsertURLWithParamParams) error
- func (q *Queries) ListBuildSums(ctx context.Context) ([]BuildSum, error)
- func (q *Queries) ListBuildSumsPaginated(ctx context.Context, arg *ListBuildSumsPaginatedParams) ([]BuildSum, error)
- func (q *Queries) ListDeployments(ctx context.Context) ([]Deployment, error)
- func (q *Queries) ListDeploymentsPaginated(ctx context.Context, arg *ListDeploymentsPaginatedParams) ([]Deployment, error)
- func (q *Queries) ListGitRevisions(ctx context.Context) ([]GitRevision, error)
- func (q *Queries) ListGitRevisionsPaginated(ctx context.Context, arg *ListGitRevisionsPaginatedParams) ([]GitRevision, error)
- func (q *Queries) ListGoVersions(ctx context.Context) ([]GoVersion, error)
- func (q *Queries) ListGoVersionsPaginated(ctx context.Context, arg *ListGoVersionsPaginatedParams) ([]GoVersion, error)
- func (q *Queries) ListLogLevels(ctx context.Context) ([]LogLevel, error)
- func (q *Queries) ListLogLevelsPaginated(ctx context.Context, arg *ListLogLevelsPaginatedParams) ([]LogLevel, error)
- func (q *Queries) ListLogs(ctx context.Context) ([]ApiLog, error)
- func (q *Queries) ListLogsByDeploymentID(ctx context.Context, arg *ListLogsByDeploymentIDParams) ([]ApiLog, error)
- func (q *Queries) ListLogsByMethod(ctx context.Context, arg *ListLogsByMethodParams) ([]ApiLog, error)
- func (q *Queries) ListLogsByUserAgent(ctx context.Context, arg *ListLogsByUserAgentParams) ([]ApiLog, error)
- func (q *Queries) ListLogsPaginated(ctx context.Context, arg *ListLogsPaginatedParams) ([]ApiLog, error)
- func (q *Queries) ListLogsWithJoin(ctx context.Context) ([]ListLogsWithJoinRow, error)
- func (q *Queries) ListLogsWithJoinByBuildSumID(ctx context.Context, arg *ListLogsWithJoinByBuildSumIDParams) ([]ListLogsWithJoinByBuildSumIDRow, error)
- func (q *Queries) ListLogsWithJoinByBuildSumIDPaginated(ctx context.Context, arg *ListLogsWithJoinByBuildSumIDPaginatedParams) ([]ListLogsWithJoinByBuildSumIDPaginatedRow, error)
- func (q *Queries) ListLogsWithJoinByDate(ctx context.Context, arg *ListLogsWithJoinByDateParams) ([]ListLogsWithJoinByDateRow, error)
- func (q *Queries) ListLogsWithJoinByDatePaginated(ctx context.Context, arg *ListLogsWithJoinByDatePaginatedParams) ([]ListLogsWithJoinByDatePaginatedRow, error)
- func (q *Queries) ListLogsWithJoinByDateRange(ctx context.Context, arg *ListLogsWithJoinByDateRangeParams) ([]ListLogsWithJoinByDateRangeRow, error)
- func (q *Queries) ListLogsWithJoinByDateRangePaginated(ctx context.Context, arg *ListLogsWithJoinByDateRangePaginatedParams) ([]ListLogsWithJoinByDateRangePaginatedRow, error)
- func (q *Queries) ListLogsWithJoinByElapsedRange(ctx context.Context, arg *ListLogsWithJoinByElapsedRangeParams) ([]ListLogsWithJoinByElapsedRangeRow, error)
- func (q *Queries) ListLogsWithJoinByElapsedRangePaginated(ctx context.Context, arg *ListLogsWithJoinByElapsedRangePaginatedParams) ([]ListLogsWithJoinByElapsedRangePaginatedRow, error)
- func (q *Queries) ListLogsWithJoinByGitRevisionID(ctx context.Context, arg *ListLogsWithJoinByGitRevisionIDParams) ([]ListLogsWithJoinByGitRevisionIDRow, error)
- func (q *Queries) ListLogsWithJoinByGitRevisionIDPaginated(ctx context.Context, arg *ListLogsWithJoinByGitRevisionIDPaginatedParams) ([]ListLogsWithJoinByGitRevisionIDPaginatedRow, error)
- func (q *Queries) ListLogsWithJoinByGoVersionID(ctx context.Context, arg *ListLogsWithJoinByGoVersionIDParams) ([]ListLogsWithJoinByGoVersionIDRow, error)
- func (q *Queries) ListLogsWithJoinByGoVersionIDPaginated(ctx context.Context, arg *ListLogsWithJoinByGoVersionIDPaginatedParams) ([]ListLogsWithJoinByGoVersionIDPaginatedRow, error)
- func (q *Queries) ListLogsWithJoinPaginated(ctx context.Context, arg *ListLogsWithJoinPaginatedParams) ([]ListLogsWithJoinPaginatedRow, error)
- func (q *Queries) ListURLs(ctx context.Context) ([]Url, error)
- func (q *Queries) ListURLsPaginated(ctx context.Context, arg *ListURLsPaginatedParams) ([]Url, error)
- func (q *Queries) UpdateGoVersionByID(ctx context.Context, arg *UpdateGoVersionByIDParams) error
- func (q *Queries) WithTx(tx *sql.Tx) *Queries
- func (q *Queries) Write(p []byte) (n int, err error)
- func (q *Queries) WriteLevel(level zerolog.Level, p []byte) (n int, err error)
- type UpdateGoVersionByIDParams
- type Url
Constants ¶
This section is empty.
Variables ¶
var SQLQueries string
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 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 GetBuildSumByIDParams ¶
type GetBuildSumByIDParams struct {
ID int64 `db:"id" json:"id"`
}
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 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 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 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 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 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 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 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 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 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 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 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
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 ¶
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 ¶
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 ¶
file: deployments.sql url: github.com/conneroisu/dblogger/data/queries/deployments.sql description: deployments.sql is
SELECT COUNT(*) FROM deployments
func (*Queries) CountGitRevisions ¶
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 ¶
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 ¶
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 ¶
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 ¶
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) 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 ¶
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 ¶
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) GetURLsByDate ¶
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) 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 ¶
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) ListLogLevelsPaginated ¶
func (q *Queries) ListLogLevelsPaginated( ctx context.Context, arg *ListLogLevelsPaginatedParams, ) ([]LogLevel, error)
ListLogLevelsPaginated
SELECT id, name FROM log_levels LIMIT ? OFFSET ?
func (*Queries) ListLogs ¶
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) 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 ¶
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)