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

Source Files

View all Source files

Jump to

Keyboard shortcuts

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