sql

package
v0.2.54 Latest Latest
Warning

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

Go to latest
Published: Dec 20, 2023 License: MIT Imports: 18 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type SqlDb

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

func (*SqlDb) ApplyMigration

func (d *SqlDb) ApplyMigration(migration db.Migration) error

ApplyMigration runs executes a database migration

func (*SqlDb) Close

func (d *SqlDb) Close(token string)

func (*SqlDb) Connect

func (d *SqlDb) Connect(token string)

func (*SqlDb) CreateAPIToken

func (d *SqlDb) CreateAPIToken(token db.APIToken) (db.APIToken, error)

func (*SqlDb) CreateAccessKey

func (d *SqlDb) CreateAccessKey(key db.AccessKey) (newKey db.AccessKey, err error)

func (*SqlDb) CreateEnvironment

func (d *SqlDb) CreateEnvironment(env db.Environment) (newEnv db.Environment, err error)

func (*SqlDb) CreateEvent

func (d *SqlDb) CreateEvent(evt db.Event) (newEvent db.Event, err error)

func (*SqlDb) CreateInventory

func (d *SqlDb) CreateInventory(inventory db.Inventory) (newInventory db.Inventory, err error)

func (*SqlDb) CreateProject

func (d *SqlDb) CreateProject(project db.Project) (newProject db.Project, err error)

func (*SqlDb) CreateProjectUser

func (d *SqlDb) CreateProjectUser(projectUser db.ProjectUser) (newProjectUser db.ProjectUser, err error)

func (*SqlDb) CreateRepository

func (d *SqlDb) CreateRepository(repository db.Repository) (newRepo db.Repository, err error)

func (*SqlDb) CreateRunner

func (d *SqlDb) CreateRunner(runner db.Runner) (newRunner db.Runner, err error)

func (*SqlDb) CreateSchedule

func (d *SqlDb) CreateSchedule(schedule db.Schedule) (newSchedule db.Schedule, err error)

func (*SqlDb) CreateSession

func (d *SqlDb) CreateSession(session db.Session) (db.Session, error)

func (*SqlDb) CreateTask

func (d *SqlDb) CreateTask(task db.Task) (db.Task, error)

func (*SqlDb) CreateTaskOutput

func (d *SqlDb) CreateTaskOutput(output db.TaskOutput) (db.TaskOutput, error)

func (*SqlDb) CreateTemplate

func (d *SqlDb) CreateTemplate(template db.Template) (newTemplate db.Template, err error)

func (*SqlDb) CreateUser

func (d *SqlDb) CreateUser(user db.UserWithPwd) (newUser db.User, err error)

func (*SqlDb) CreateUserWithoutPassword

func (d *SqlDb) CreateUserWithoutPassword(user db.User) (newUser db.User, err error)

func (*SqlDb) CreateView

func (d *SqlDb) CreateView(view db.View) (newView db.View, err error)

func (*SqlDb) DeleteAPIToken

func (d *SqlDb) DeleteAPIToken(userID int, tokenID string) (err error)

func (*SqlDb) DeleteAccessKey

func (d *SqlDb) DeleteAccessKey(projectID int, accessKeyID int) error

func (*SqlDb) DeleteEnvironment

func (d *SqlDb) DeleteEnvironment(projectID int, environmentID int) error

func (*SqlDb) DeleteGlobalRunner

func (d *SqlDb) DeleteGlobalRunner(runnerID int) (err error)

func (*SqlDb) DeleteInventory

func (d *SqlDb) DeleteInventory(projectID int, inventoryID int) error

func (*SqlDb) DeleteProject

func (d *SqlDb) DeleteProject(projectID int) error

func (*SqlDb) DeleteProjectUser

func (d *SqlDb) DeleteProjectUser(projectID, userID int) error

func (*SqlDb) DeleteRepository

func (d *SqlDb) DeleteRepository(projectID int, repositoryId int) error

func (*SqlDb) DeleteRunner

func (d *SqlDb) DeleteRunner(projectID int, runnerID int) (err error)

func (*SqlDb) DeleteSchedule

func (d *SqlDb) DeleteSchedule(projectID int, scheduleID int) error

func (*SqlDb) DeleteTaskWithOutputs

func (d *SqlDb) DeleteTaskWithOutputs(projectID int, taskID int) (err error)

func (*SqlDb) DeleteTemplate

func (d *SqlDb) DeleteTemplate(projectID int, templateID int) error

func (*SqlDb) DeleteUser

func (d *SqlDb) DeleteUser(userID int) error

func (*SqlDb) DeleteView

func (d *SqlDb) DeleteView(projectID int, viewID int) error

func (*SqlDb) ExpireAPIToken

func (d *SqlDb) ExpireAPIToken(userID int, tokenID string) (err error)

func (*SqlDb) ExpireSession

func (d *SqlDb) ExpireSession(userID int, sessionID int) error

func (*SqlDb) GetAPIToken

func (d *SqlDb) GetAPIToken(tokenID string) (token db.APIToken, err error)

func (*SqlDb) GetAPITokens

func (d *SqlDb) GetAPITokens(userID int) (tokens []db.APIToken, err error)

func (*SqlDb) GetAccessKey

func (d *SqlDb) GetAccessKey(projectID int, accessKeyID int) (key db.AccessKey, err error)

func (*SqlDb) GetAccessKeyRefs

func (d *SqlDb) GetAccessKeyRefs(projectID int, keyID int) (db.ObjectReferrers, error)

func (*SqlDb) GetAccessKeys

func (d *SqlDb) GetAccessKeys(projectID int, params db.RetrieveQueryParams) ([]db.AccessKey, error)

func (*SqlDb) GetAllProjects

func (d *SqlDb) GetAllProjects() (projects []db.Project, err error)

func (*SqlDb) GetEnvironment

func (d *SqlDb) GetEnvironment(projectID int, environmentID int) (db.Environment, error)

func (*SqlDb) GetEnvironmentRefs

func (d *SqlDb) GetEnvironmentRefs(projectID int, environmentID int) (db.ObjectReferrers, error)

func (*SqlDb) GetEnvironments

func (d *SqlDb) GetEnvironments(projectID int, params db.RetrieveQueryParams) ([]db.Environment, error)

func (*SqlDb) GetEvents

func (d *SqlDb) GetEvents(projectID int, params db.RetrieveQueryParams) ([]db.Event, error)

func (*SqlDb) GetGlobalRunner

func (d *SqlDb) GetGlobalRunner(runnerID int) (runner db.Runner, err error)

func (*SqlDb) GetGlobalRunners

func (d *SqlDb) GetGlobalRunners() (runners []db.Runner, err error)

func (*SqlDb) GetInventories

func (d *SqlDb) GetInventories(projectID int, params db.RetrieveQueryParams) ([]db.Inventory, error)

func (*SqlDb) GetInventory

func (d *SqlDb) GetInventory(projectID int, inventoryID int) (inventory db.Inventory, err error)

func (*SqlDb) GetInventoryRefs

func (d *SqlDb) GetInventoryRefs(projectID int, inventoryID int) (db.ObjectReferrers, error)

func (*SqlDb) GetProject

func (d *SqlDb) GetProject(projectID int) (project db.Project, err error)

func (*SqlDb) GetProjectTasks

func (d *SqlDb) GetProjectTasks(projectID int, params db.RetrieveQueryParams) (tasks []db.TaskWithTpl, err error)

func (*SqlDb) GetProjectUser

func (d *SqlDb) GetProjectUser(projectID, userID int) (db.ProjectUser, error)

func (*SqlDb) GetProjectUsers

func (d *SqlDb) GetProjectUsers(projectID int, params db.RetrieveQueryParams) (users []db.UserWithProjectRole, err error)

func (*SqlDb) GetProjects

func (d *SqlDb) GetProjects(userID int) (projects []db.Project, err error)

func (*SqlDb) GetRepositories

func (d *SqlDb) GetRepositories(projectID int, params db.RetrieveQueryParams) (repositories []db.Repository, err error)

func (*SqlDb) GetRepository

func (d *SqlDb) GetRepository(projectID int, repositoryID int) (db.Repository, error)

func (*SqlDb) GetRepositoryRefs

func (d *SqlDb) GetRepositoryRefs(projectID int, repositoryID int) (db.ObjectReferrers, error)

func (*SqlDb) GetRunner

func (d *SqlDb) GetRunner(projectID int, runnerID int) (runner db.Runner, err error)

func (*SqlDb) GetRunners

func (d *SqlDb) GetRunners(projectID int) (runners []db.Runner, err error)

func (*SqlDb) GetSchedule

func (d *SqlDb) GetSchedule(projectID int, scheduleID int) (template db.Schedule, err error)

func (*SqlDb) GetSchedules

func (d *SqlDb) GetSchedules() (schedules []db.Schedule, err error)

func (*SqlDb) GetSession

func (d *SqlDb) GetSession(userID int, sessionID int) (session db.Session, err error)

func (*SqlDb) GetTask

func (d *SqlDb) GetTask(projectID int, taskID int) (task db.Task, err error)

func (*SqlDb) GetTaskOutputs

func (d *SqlDb) GetTaskOutputs(projectID int, taskID int) (output []db.TaskOutput, err error)

func (*SqlDb) GetTemplate

func (d *SqlDb) GetTemplate(projectID int, templateID int) (template db.Template, err error)

func (*SqlDb) GetTemplateRefs

func (d *SqlDb) GetTemplateRefs(projectID int, templateID int) (db.ObjectReferrers, error)

func (*SqlDb) GetTemplateSchedules

func (d *SqlDb) GetTemplateSchedules(projectID int, templateID int) (schedules []db.Schedule, err error)

func (*SqlDb) GetTemplateTasks

func (d *SqlDb) GetTemplateTasks(projectID int, templateID int, params db.RetrieveQueryParams) (tasks []db.TaskWithTpl, err error)

func (*SqlDb) GetTemplates

func (d *SqlDb) GetTemplates(projectID int, filter db.TemplateFilter, params db.RetrieveQueryParams) (templates []db.Template, err error)

func (*SqlDb) GetUser

func (d *SqlDb) GetUser(userID int) (db.User, error)

GetUser retrieves a user from the database by ID

func (*SqlDb) GetUserByLoginOrEmail

func (d *SqlDb) GetUserByLoginOrEmail(login string, email string) (existingUser db.User, err error)

func (*SqlDb) GetUserEvents

func (d *SqlDb) GetUserEvents(userID int, params db.RetrieveQueryParams) ([]db.Event, error)

func (*SqlDb) GetUsers

func (d *SqlDb) GetUsers(params db.RetrieveQueryParams) (users []db.User, err error)

func (*SqlDb) GetView

func (d *SqlDb) GetView(projectID int, viewID int) (view db.View, err error)

func (*SqlDb) GetViews

func (d *SqlDb) GetViews(projectID int) (views []db.View, err error)

func (*SqlDb) IsInitialized

func (d *SqlDb) IsInitialized() (bool, error)

func (*SqlDb) IsMigrationApplied

func (d *SqlDb) IsMigrationApplied(migration db.Migration) (bool, error)

IsMigrationApplied queries the database to see if a migration table with this version id exists already

func (*SqlDb) PermanentConnection

func (d *SqlDb) PermanentConnection() bool

func (*SqlDb) PrepareQuery

func (d *SqlDb) PrepareQuery(query string) string

func (*SqlDb) RekeyAccessKeys

func (d *SqlDb) RekeyAccessKeys(oldKey string) error

func (*SqlDb) SetScheduleCommitHash

func (d *SqlDb) SetScheduleCommitHash(projectID int, scheduleID int, hash string) error

func (*SqlDb) SetScheduleLastCommitHash

func (d *SqlDb) SetScheduleLastCommitHash(projectID int, scheduleID int, lastCommentHash string) error

func (*SqlDb) SetUserPassword

func (d *SqlDb) SetUserPassword(userID int, password string) error

func (*SqlDb) SetViewPositions

func (d *SqlDb) SetViewPositions(projectID int, positions map[int]int) error

func (*SqlDb) Sql

func (d *SqlDb) Sql() *gorp.DbMap

func (*SqlDb) TouchSession

func (d *SqlDb) TouchSession(userID int, sessionID int) error

func (*SqlDb) TryRollbackMigration

func (d *SqlDb) TryRollbackMigration(version db.Migration)

TryRollbackMigration attempts to rollback the database to an earlier version if a rollback exists

func (*SqlDb) UpdateAccessKey

func (d *SqlDb) UpdateAccessKey(key db.AccessKey) error

func (*SqlDb) UpdateEnvironment

func (d *SqlDb) UpdateEnvironment(env db.Environment) error

func (*SqlDb) UpdateInventory

func (d *SqlDb) UpdateInventory(inventory db.Inventory) error

func (*SqlDb) UpdateProject

func (d *SqlDb) UpdateProject(project db.Project) error

func (*SqlDb) UpdateProjectUser

func (d *SqlDb) UpdateProjectUser(projectUser db.ProjectUser) error

func (*SqlDb) UpdateRepository

func (d *SqlDb) UpdateRepository(repository db.Repository) error

func (*SqlDb) UpdateRunner

func (d *SqlDb) UpdateRunner(runner db.Runner) (err error)

func (*SqlDb) UpdateSchedule

func (d *SqlDb) UpdateSchedule(schedule db.Schedule) error

func (*SqlDb) UpdateTask

func (d *SqlDb) UpdateTask(task db.Task) error

func (*SqlDb) UpdateTemplate

func (d *SqlDb) UpdateTemplate(template db.Template) error

func (*SqlDb) UpdateUser

func (d *SqlDb) UpdateUser(user db.UserWithPwd) error

func (*SqlDb) UpdateView

func (d *SqlDb) UpdateView(view db.View) error

Jump to

Keyboard shortcuts

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