db

package
v0.0.0-...-d457aa5 Latest Latest
Warning

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

Go to latest
Published: Oct 12, 2023 License: MIT Imports: 7 Imported by: 0

Documentation

Index

Constants

View Source
const (
	AlreadyExists = "already exists"
	UserNotFound  = "user not found"
	RepoNotFound  = "repo not found"
)

AlreadyExists ...

Variables

This section is empty.

Functions

func AddRepoLinkIfNotExist

func AddRepoLinkIfNotExist(db *sql.DB, user *GithubUser, repo *GithubRepo, updatedAt time.Time) error

AddRepoLinkIfNotExist ...

func DeleteRepoUserLinkDB

func DeleteRepoUserLinkDB(db *sql.DB, user *GithubUser, repo *GithubRepo) error

DeleteRepoUserLinkDB ...

func ExecSQL

func ExecSQL(db *sql.DB, sql string) error

ExecSQL ...

func InitDB

func InitDB() (*sql.DB, error)

InitDB ...

func QuerySQLList

func QuerySQLList(db *sql.DB, returnModel interface{}, sql string, args ...interface{}) ([]reflect.Value, error)

QuerySQLList ...

func QuerySQLObject

func QuerySQLObject(db *sql.DB, returnModel interface{}, sql string, args ...interface{}) (reflect.Value, error)

QuerySQLObject ...

func StoreTelegramMessage

func StoreTelegramMessage(db *sql.DB, message TelegramMessage) error

StoreTelegramMessage ...

func UpdateUserRepoLink(db *sql.DB, userRepoResult *UsersReposResult) error

UpdateUserRepoLink ...

Types

type GithubRepo

type GithubRepo struct {
	ID        int64     `sql:"id"`
	Name      string    `sql:"name"`
	RepoName  string    `sql:"repo_name"`
	CreatedAt time.Time `sql:"created_at"`
}

GithubRepo ...

func AddRepoIfNotExist

func AddRepoIfNotExist(db *sql.DB, repo *GithubRepo) (*GithubRepo, error)

AddRepoIfNotExist ...

func GetGithubRepoByNameFromDB

func GetGithubRepoByNameFromDB(db *sql.DB, repo_name string) (*GithubRepo, error)

GetGithubRepoByNameFromDB ...

type GithubUser

type GithubUser struct {
	ID             int64     `sql:"id"`
	Name           string    `sql:"name"`
	UserName       string    `sql:"user_name"`
	TelegramUserID string    `sql:"telegram_user_id"`
	Token          string    `sql:"token"`
	CreatedAt      time.Time `sql:"created_at"`
}

GithubUser ...

func AddUserIfNotExist

func AddUserIfNotExist(db *sql.DB, user *GithubUser) (*GithubUser, error)

AddUserIfNotExist ...

func GetGithubUserFromDB

func GetGithubUserFromDB(db *sql.DB, id string) (*GithubUser, error)

GetGithubUserFromDB ...

func GetUsers

func GetUsers(db *sql.DB) (users []*GithubUser, err error)

GetUsers ...

type TelegramMessage

type TelegramMessage struct {
	ID       int
	UserID   int
	UserName string
	Message  string
	Date     time.Time
}

TelegramMessage ...

type UserRepo

type UserRepo struct {
	ID        int64     `sql:"id"`
	UserID    int64     `sql:"user_id"`
	RepoID    int64     `sql:"repo_id"`
	CreatedAt time.Time `sql:"created_at"`
	UpdatedAt time.Time `sql:"updated_at"`
}

UserRepo ...

type UsersReposResult

type UsersReposResult struct {
	UserID         int64
	RepoID         int64
	TelegramUserID string
	Token          string
	RepoName       string
	UpdatedAt      time.Time
}

UsersReposResult ...

func GetUserRepos

func GetUserRepos(db *sql.DB) (usersRepos []*UsersReposResult, err error)

GetUserRepos ...

Jump to

Keyboard shortcuts

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