db

package
v0.0.0-...-2ed2780 Latest Latest
Warning

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

 Go to latest Published: Aug 27, 2023 License: AGPL-3.0 Imports: 5 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type Application 

type Application struct {
	ID          int32                 `json:"id"`
	JobSeekerID sql.NullInt32         `json:"job_seeker_id"`
	JobID       sql.NullInt32         `json:"job_id"`
	CoverLetter sql.NullString        `json:"cover_letter"`
	Resume      sql.NullString        `json:"resume"`
	Status      NullApplicationStatus `json:"status"`
	CreatedAt   sql.NullTime          `json:"created_at"`
	UpdatedAt   sql.NullTime          `json:"updated_at"`
}

type ApplicationStatus 

type ApplicationStatus string
const (
	ApplicationStatusApplied     ApplicationStatus = "applied"
	ApplicationStatusInterviewed ApplicationStatus = "interviewed"
	ApplicationStatusOffered     ApplicationStatus = "offered"
	ApplicationStatusRejected    ApplicationStatus = "rejected"
)

func (*ApplicationStatus) Scan 

func (e *ApplicationStatus) Scan(src interface{}) error

type Chatbotconversation 

type Chatbotconversation struct {
	ID                 int32          `json:"id"`
	ChatbotInterviewID sql.NullInt32  `json:"chatbot_interview_id"`
	SenderType         sql.NullString `json:"sender_type"`
	Content            string         `json:"content"`
	CreatedAt          sql.NullTime   `json:"created_at"`
}

type Chatbotinterview 

type Chatbotinterview struct {
	ID          int32               `json:"id"`
	JobSeekerID sql.NullInt32       `json:"job_seeker_id"`
	JobID       sql.NullInt32       `json:"job_id"`
	Status      NullInterviewStatus `json:"status"`
	Review      sql.NullString      `json:"review"`
	CreatedAt   sql.NullTime        `json:"created_at"`
	UpdatedAt   sql.NullTime        `json:"updated_at"`
}

type Company 

type Company struct {
	ID          int32          `json:"id"`
	UserID      sql.NullInt32  `json:"user_id"`
	Name        string         `json:"name"`
	Email       string         `json:"email"`
	Phone       sql.NullString `json:"phone"`
	Website     sql.NullString `json:"website"`
	Description sql.NullString `json:"description"`
	CreatedAt   sql.NullTime   `json:"created_at"`
	UpdatedAt   sql.NullTime   `json:"updated_at"`
}

type Companyentity 

type Companyentity struct {
	ID   int32          `json:"id"`
	Name sql.NullString `json:"name"`
}

type CreateJobParams 

type CreateJobParams struct {
	Title        string         `json:"title"`
	Description  sql.NullString `json:"description"`
	Requirements sql.NullString `json:"requirements"`
	Location     sql.NullString `json:"location"`
	Salary       sql.NullInt32  `json:"salary"`
	CompanyID    sql.NullInt32  `json:"company_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
}

type DeleteJobSeekerSkillParams 

type DeleteJobSeekerSkillParams struct {
	JobSeekerID    int32           `json:"job_seeker_id"`
	TechnicalSkill Technicalskills `json:"technical_skill"`
	PassiveSkill   Passiveskills   `json:"passive_skill"`
}

type Education 

type Education struct {
	ID            int32          `json:"id"`
	JobSeekerID   sql.NullInt32  `json:"job_seeker_id"`
	InstitutionID sql.NullInt32  `json:"institution_id"`
	Degree        sql.NullString `json:"degree"`
	FieldOfStudy  sql.NullString `json:"field_of_study"`
	StartDate     sql.NullTime   `json:"start_date"`
	EndDate       sql.NullTime   `json:"end_date"`
	CreatedAt     sql.NullTime   `json:"created_at"`
	UpdatedAt     sql.NullTime   `json:"updated_at"`
}

type Experience 

type Experience struct {
	ID          int32          `json:"id"`
	JobSeekerID sql.NullInt32  `json:"job_seeker_id"`
	Title       sql.NullString `json:"title"`
	CompanyID   sql.NullInt32  `json:"company_id"`
	Location    sql.NullString `json:"location"`
	StartDate   sql.NullTime   `json:"start_date"`
	EndDate     sql.NullTime   `json:"end_date"`
	TypeID      sql.NullInt32  `json:"type_id"`
	Description sql.NullString `json:"description"`
	CreatedAt   sql.NullTime   `json:"created_at"`
	UpdatedAt   sql.NullTime   `json:"updated_at"`
}

type Experiencetype 

type Experiencetype struct {
	ID   int32          `json:"id"`
	Name sql.NullString `json:"name"`
}

type GetJobsRow 

type GetJobsRow struct {
	ID           int32          `json:"id"`
	Title        string         `json:"title"`
	Description  sql.NullString `json:"description"`
	Requirements sql.NullString `json:"requirements"`
	Location     sql.NullString `json:"location"`
	Salary       sql.NullInt32  `json:"salary"`
	CompanyID    sql.NullInt32  `json:"company_id"`
	CreatedAt    sql.NullTime   `json:"created_at"`
	UpdatedAt    sql.NullTime   `json:"updated_at"`
}

type InsertApplicationParams 

type InsertApplicationParams struct {
	JobSeekerID sql.NullInt32         `json:"job_seeker_id"`
	JobID       sql.NullInt32         `json:"job_id"`
	CoverLetter sql.NullString        `json:"cover_letter"`
	Resume      sql.NullString        `json:"resume"`
	Status      NullApplicationStatus `json:"status"`
}

type InsertChatbotConversationParams 

type InsertChatbotConversationParams struct {
	ChatbotInterviewID sql.NullInt32  `json:"chatbot_interview_id"`
	SenderType         sql.NullString `json:"sender_type"`
	Content            string         `json:"content"`
}

type InsertChatbotInterviewParams 

type InsertChatbotInterviewParams struct {
	JobSeekerID sql.NullInt32       `json:"job_seeker_id"`
	JobID       sql.NullInt32       `json:"job_id"`
	Status      NullInterviewStatus `json:"status"`
	Review      sql.NullString      `json:"review"`
}

type InsertCompanyParams 

type InsertCompanyParams struct {
	UserID      sql.NullInt32  `json:"user_id"`
	Name        string         `json:"name"`
	Email       string         `json:"email"`
	Phone       sql.NullString `json:"phone"`
	Website     sql.NullString `json:"website"`
	Description sql.NullString `json:"description"`
}

type InsertEducationParams 

type InsertEducationParams struct {
	JobSeekerID   sql.NullInt32  `json:"job_seeker_id"`
	InstitutionID sql.NullInt32  `json:"institution_id"`
	Degree        sql.NullString `json:"degree"`
	FieldOfStudy  sql.NullString `json:"field_of_study"`
	StartDate     sql.NullTime   `json:"start_date"`
	EndDate       sql.NullTime   `json:"end_date"`
}

type InsertExperienceParams 

type InsertExperienceParams struct {
	JobSeekerID sql.NullInt32  `json:"job_seeker_id"`
	Title       sql.NullString `json:"title"`
	CompanyID   sql.NullInt32  `json:"company_id"`
	Location    sql.NullString `json:"location"`
	StartDate   sql.NullTime   `json:"start_date"`
	EndDate     sql.NullTime   `json:"end_date"`
	TypeID      sql.NullInt32  `json:"type_id"`
	Description sql.NullString `json:"description"`
}

type InsertJobSeekerSkillParams 

type InsertJobSeekerSkillParams struct {
	JobSeekerID    int32           `json:"job_seeker_id"`
	TechnicalSkill Technicalskills `json:"technical_skill"`
	PassiveSkill   Passiveskills   `json:"passive_skill"`
}

type InsertJobViewParams 

type InsertJobViewParams struct {
	JobID     int32         `json:"job_id"`
	ViewCount sql.NullInt32 `json:"view_count"`
}

type InsertMessageParams 

type InsertMessageParams struct {
	SenderID   int32          `json:"sender_id"`
	ReceiverID int32          `json:"receiver_id"`
	Content    string         `json:"content"`
	SenderType sql.NullString `json:"sender_type"`
}

type InsertScheduledInterviewParams 

type InsertScheduledInterviewParams struct {
	JobSeekerID sql.NullInt32  `json:"job_seeker_id"`
	CompanyID   sql.NullInt32  `json:"company_id"`
	ScheduledAt sql.NullTime   `json:"scheduled_at"`
	Location    sql.NullString `json:"location"`
	Notes       sql.NullString `json:"notes"`
	MeetingLink sql.NullString `json:"meeting_link"`
}

type InsertUserParams 

type InsertUserParams struct {
	Name  string         `json:"name"`
	Email string         `json:"email"`
	Phone sql.NullString `json:"phone"`
	Role  sql.NullString `json:"role"`
}

type Institution 

type Institution struct {
	ID   int32          `json:"id"`
	Name sql.NullString `json:"name"`
}

type InterviewStatus 

type InterviewStatus string
const (
	InterviewStatusPending InterviewStatus = "pending"
	InterviewStatusPassed  InterviewStatus = "passed"
	InterviewStatusFailed  InterviewStatus = "failed"
)

func (*InterviewStatus) Scan 

func (e *InterviewStatus) Scan(src interface{}) error

type Job 

type Job struct {
	ID           int32          `json:"id"`
	Title        string         `json:"title"`
	Description  sql.NullString `json:"description"`
	Requirements sql.NullString `json:"requirements"`
	Location     sql.NullString `json:"location"`
	Salary       sql.NullInt32  `json:"salary"`
	CompanyID    sql.NullInt32  `json:"company_id"`
	CategoryID   sql.NullInt32  `json:"category_id"`
	Status       NullJobStatus  `json:"status"`
	CreatedAt    sql.NullTime   `json:"created_at"`
	UpdatedAt    sql.NullTime   `json:"updated_at"`
}

type JobStatus 

type JobStatus string
const (
	JobStatusActive JobStatus = "active"
	JobStatusClosed JobStatus = "closed"
	JobStatusDraft  JobStatus = "draft"
	JobStatusPaused JobStatus = "paused"
)

func (*JobStatus) Scan 

func (e *JobStatus) Scan(src interface{}) error

type Jobcategory 

type Jobcategory struct {
	ID   int32          `json:"id"`
	Name sql.NullString `json:"name"`
}

type Jobseeker 

type Jobseeker struct {
	ID        int32         `json:"id"`
	UserID    sql.NullInt32 `json:"user_id"`
	CreatedAt sql.NullTime  `json:"created_at"`
	UpdatedAt sql.NullTime  `json:"updated_at"`
}

type Jobseekerskill 

type Jobseekerskill struct {
	JobSeekerID    int32           `json:"job_seeker_id"`
	TechnicalSkill Technicalskills `json:"technical_skill"`
	PassiveSkill   Passiveskills   `json:"passive_skill"`
}

type Jobview 

type Jobview struct {
	JobID     int32         `json:"job_id"`
	ViewCount sql.NullInt32 `json:"view_count"`
}

type Message 

type Message struct {
	ID         int32          `json:"id"`
	SenderID   int32          `json:"sender_id"`
	ReceiverID int32          `json:"receiver_id"`
	Content    string         `json:"content"`
	SenderType sql.NullString `json:"sender_type"`
	CreatedAt  sql.NullTime   `json:"created_at"`
}

type NullApplicationStatus 

type NullApplicationStatus struct {
	ApplicationStatus ApplicationStatus
	Valid             bool // Valid is true if ApplicationStatus is not NULL
}

func (*NullApplicationStatus) Scan 

func (ns *NullApplicationStatus) Scan(value interface{}) error

Scan implements the Scanner interface.

func (NullApplicationStatus) Value 

func (ns NullApplicationStatus) Value() (driver.Value, error)

Value implements the driver Valuer interface.

type NullInterviewStatus 

type NullInterviewStatus struct {
	InterviewStatus InterviewStatus
	Valid           bool // Valid is true if InterviewStatus is not NULL
}

func (*NullInterviewStatus) Scan 

func (ns *NullInterviewStatus) Scan(value interface{}) error

Scan implements the Scanner interface.

func (NullInterviewStatus) Value 

func (ns NullInterviewStatus) Value() (driver.Value, error)

Value implements the driver Valuer interface.

type NullJobStatus 

type NullJobStatus struct {
	JobStatus JobStatus
	Valid     bool // Valid is true if JobStatus is not NULL
}

func (*NullJobStatus) Scan 

func (ns *NullJobStatus) Scan(value interface{}) error

Scan implements the Scanner interface.

func (NullJobStatus) Value 

func (ns NullJobStatus) Value() (driver.Value, error)

Value implements the driver Valuer interface.

type NullPassiveskills 

type NullPassiveskills struct {
	Passiveskills Passiveskills
	Valid         bool // Valid is true if Passiveskills is not NULL
}

func (*NullPassiveskills) Scan 

func (ns *NullPassiveskills) Scan(value interface{}) error

Scan implements the Scanner interface.

func (NullPassiveskills) Value 

func (ns NullPassiveskills) Value() (driver.Value, error)

Value implements the driver Valuer interface.

type NullTechnicalskills 

type NullTechnicalskills struct {
	Technicalskills Technicalskills
	Valid           bool // Valid is true if Technicalskills is not NULL
}

func (*NullTechnicalskills) Scan 

func (ns *NullTechnicalskills) Scan(value interface{}) error

Scan implements the Scanner interface.

func (NullTechnicalskills) Value 

func (ns NullTechnicalskills) Value() (driver.Value, error)

Value implements the driver Valuer interface.

type Passiveskills 

type Passiveskills string
const (
	PassiveskillsCommunication       Passiveskills = "Communication"
	PassiveskillsProblemSolving      Passiveskills = "Problem Solving"
	PassiveskillsTeamwork            Passiveskills = "Teamwork"
	PassiveskillsAdaptability        Passiveskills = "Adaptability"
	PassiveskillsCriticalThinking    Passiveskills = "Critical Thinking"
	PassiveskillsCreativity          Passiveskills = "Creativity"
	PassiveskillsLeadership          Passiveskills = "Leadership"
	PassiveskillsTimeManagement      Passiveskills = "Time Management"
	PassiveskillsAttentiontoDetail   Passiveskills = "Attention to Detail"
	PassiveskillsDecisionMaking      Passiveskills = "Decision Making"
	PassiveskillsFlexibility         Passiveskills = "Flexibility"
	PassiveskillsInitiative          Passiveskills = "Initiative"
	PassiveskillsInterpersonalSkills Passiveskills = "Interpersonal Skills"
	PassiveskillsResilience          Passiveskills = "Resilience"
	PassiveskillsPositiveAttitude    Passiveskills = "Positive Attitude"
)

func (*Passiveskills) Scan 

func (e *Passiveskills) Scan(src interface{}) error

type Queries 

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

func New 

func New(db DBTX) *Queries

func Prepare 

func Prepare(ctx context.Context, db DBTX) (*Queries, error)

func (*Queries) Close 

func (q *Queries) Close() error

func (*Queries) CreateJob 

func (q *Queries) CreateJob(ctx context.Context, arg CreateJobParams) (int32, error)

job.sql Insert

func (*Queries) CreateJobSeeker 

func (q *Queries) CreateJobSeeker(ctx context.Context, userID sql.NullInt32) (int32, error)

Insert

func (*Queries) DeleteApplication 

func (q *Queries) DeleteApplication(ctx context.Context, id int32) error

func (*Queries) DeleteChatbotConversation 

func (q *Queries) DeleteChatbotConversation(ctx context.Context, id int32) error

Delete (Delete)

func (*Queries) DeleteChatbotInterview 

func (q *Queries) DeleteChatbotInterview(ctx context.Context, id int32) error

func (*Queries) DeleteCompany 

func (q *Queries) DeleteCompany(ctx context.Context, id int32) error

func (*Queries) DeleteCompanyEntity 

func (q *Queries) DeleteCompanyEntity(ctx context.Context, id int32) error

func (*Queries) DeleteEducation 

func (q *Queries) DeleteEducation(ctx context.Context, id int32) error

func (*Queries) DeleteExperience 

func (q *Queries) DeleteExperience(ctx context.Context, id int32) error

func (*Queries) DeleteExperienceType 

func (q *Queries) DeleteExperienceType(ctx context.Context, id int32) error

func (*Queries) DeleteInstitution 

func (q *Queries) DeleteInstitution(ctx context.Context, id int32) error

func (*Queries) DeleteJob 

func (q *Queries) DeleteJob(ctx context.Context, id int32) error

Delete

func (*Queries) DeleteJobCategory 

func (q *Queries) DeleteJobCategory(ctx context.Context, id int32) error

func (*Queries) DeleteJobSeeker 

func (q *Queries) DeleteJobSeeker(ctx context.Context, id int32) error

Delete

func (*Queries) DeleteJobSeekerSkill 

func (q *Queries) DeleteJobSeekerSkill(ctx context.Context, arg DeleteJobSeekerSkillParams) error

func (*Queries) DeleteMessage 

func (q *Queries) DeleteMessage(ctx context.Context, id int32) error

func (*Queries) DeleteScheduledInterview 

func (q *Queries) DeleteScheduledInterview(ctx context.Context, id int32) error

func (*Queries) DeleteSkill 

func (q *Queries) DeleteSkill(ctx context.Context, id int32) error

func (*Queries) DeleteUser 

func (q *Queries) DeleteUser(ctx context.Context, id int32) error

func (*Queries) GetEducations 

func (q *Queries) GetEducations(ctx context.Context) ([]Education, error)

func (*Queries) GetJobSeekers 

func (q *Queries) GetJobSeekers(ctx context.Context) ([]Jobseeker, error)

Select all

func (*Queries) GetJobs 

func (q *Queries) GetJobs(ctx context.Context) ([]GetJobsRow, error)

Select all

func (*Queries) InsertApplication 

func (q *Queries) InsertApplication(ctx context.Context, arg InsertApplicationParams) error

func (*Queries) InsertChatbotConversation 

func (q *Queries) InsertChatbotConversation(ctx context.Context, arg InsertChatbotConversationParams) error

Insert (Create)

func (*Queries) InsertChatbotInterview 

func (q *Queries) InsertChatbotInterview(ctx context.Context, arg InsertChatbotInterviewParams) error

func (*Queries) InsertCompany 

func (q *Queries) InsertCompany(ctx context.Context, arg InsertCompanyParams) error

func (*Queries) InsertCompanyEntity 

func (q *Queries) InsertCompanyEntity(ctx context.Context, name sql.NullString) error

func (*Queries) InsertEducation 

func (q *Queries) InsertEducation(ctx context.Context, arg InsertEducationParams) error

func (*Queries) InsertExperience 

func (q *Queries) InsertExperience(ctx context.Context, arg InsertExperienceParams) error

func (*Queries) InsertExperienceType 

func (q *Queries) InsertExperienceType(ctx context.Context, name sql.NullString) error

func (*Queries) InsertInstitution 

func (q *Queries) InsertInstitution(ctx context.Context, name sql.NullString) error

func (*Queries) InsertJobCategory 

func (q *Queries) InsertJobCategory(ctx context.Context, name sql.NullString) error

func (*Queries) InsertJobSeekerSkill 

func (q *Queries) InsertJobSeekerSkill(ctx context.Context, arg InsertJobSeekerSkillParams) error

func (*Queries) InsertJobView 

func (q *Queries) InsertJobView(ctx context.Context, arg InsertJobViewParams) error

func (*Queries) InsertMessage 

func (q *Queries) InsertMessage(ctx context.Context, arg InsertMessageParams) error

func (*Queries) InsertScheduledInterview 

func (q *Queries) InsertScheduledInterview(ctx context.Context, arg InsertScheduledInterviewParams) error

func (*Queries) InsertSkill 

func (q *Queries) InsertSkill(ctx context.Context, name sql.NullString) error

func (*Queries) InsertUser 

func (q *Queries) InsertUser(ctx context.Context, arg InsertUserParams) error

func (*Queries) SelectAllApplications 

func (q *Queries) SelectAllApplications(ctx context.Context) ([]Application, error)

func (*Queries) SelectAllChatbotConversations 

func (q *Queries) SelectAllChatbotConversations(ctx context.Context) ([]Chatbotconversation, error)

Select All (Read)

func (*Queries) SelectAllChatbotInterviews 

func (q *Queries) SelectAllChatbotInterviews(ctx context.Context) ([]Chatbotinterview, error)

func (*Queries) SelectAllCompanies 

func (q *Queries) SelectAllCompanies(ctx context.Context) ([]Company, error)

func (*Queries) SelectAllCompanyEntities 

func (q *Queries) SelectAllCompanyEntities(ctx context.Context) ([]Companyentity, error)

func (*Queries) SelectAllExperienceTypes 

func (q *Queries) SelectAllExperienceTypes(ctx context.Context) ([]Experiencetype, error)

func (*Queries) SelectAllExperiences 

func (q *Queries) SelectAllExperiences(ctx context.Context) ([]Experience, error)

func (*Queries) SelectAllInstitutions 

func (q *Queries) SelectAllInstitutions(ctx context.Context) ([]Institution, error)

func (*Queries) SelectAllJobCategories 

func (q *Queries) SelectAllJobCategories(ctx context.Context) ([]Jobcategory, error)

func (*Queries) SelectAllScheduledInterviews 

func (q *Queries) SelectAllScheduledInterviews(ctx context.Context) ([]Scheduledinterview, error)

func (*Queries) SelectAllSkills 

func (q *Queries) SelectAllSkills(ctx context.Context) ([]Skill, error)

func (*Queries) SelectApplicationByID 

func (q *Queries) SelectApplicationByID(ctx context.Context, id int32) (Application, error)

func (*Queries) SelectChatbotConversationsByInterviewID 

func (q *Queries) SelectChatbotConversationsByInterviewID(ctx context.Context, chatbotInterviewID sql.NullInt32) ([]Chatbotconversation, error)

Select by chatbot_interview_id (Read)

func (*Queries) SelectChatbotInterviewByID 

func (q *Queries) SelectChatbotInterviewByID(ctx context.Context, id int32) (Chatbotinterview, error)

func (*Queries) SelectCompanyByID 

func (q *Queries) SelectCompanyByID(ctx context.Context, id int32) (Company, error)

func (*Queries) SelectCompanyEntityByID 

func (q *Queries) SelectCompanyEntityByID(ctx context.Context, id int32) (Companyentity, error)

func (*Queries) SelectExperienceByID 

func (q *Queries) SelectExperienceByID(ctx context.Context, id int32) (Experience, error)

func (*Queries) SelectExperienceTypeByID 

func (q *Queries) SelectExperienceTypeByID(ctx context.Context, id int32) (Experiencetype, error)

func (*Queries) SelectInstitutionByID 

func (q *Queries) SelectInstitutionByID(ctx context.Context, id int32) (Institution, error)

func (*Queries) SelectJobCategoryByID 

func (q *Queries) SelectJobCategoryByID(ctx context.Context, id int32) (Jobcategory, error)

func (*Queries) SelectJobSeekerSkillsByJobSeekerID 

func (q *Queries) SelectJobSeekerSkillsByJobSeekerID(ctx context.Context, jobSeekerID int32) ([]Jobseekerskill, error)

func (*Queries) SelectJobViewsByJobID 

func (q *Queries) SelectJobViewsByJobID(ctx context.Context, jobID int32) (Jobview, error)

func (*Queries) SelectMessagesBySenderAndReceiver 

func (q *Queries) SelectMessagesBySenderAndReceiver(ctx context.Context, arg SelectMessagesBySenderAndReceiverParams) ([]Message, error)

func (*Queries) SelectScheduledInterviewByCompanyID 

func (q *Queries) SelectScheduledInterviewByCompanyID(ctx context.Context, companyID sql.NullInt32) ([]Scheduledinterview, error)

func (*Queries) SelectScheduledInterviewByID 

func (q *Queries) SelectScheduledInterviewByID(ctx context.Context, id int32) (Scheduledinterview, error)

func (*Queries) SelectScheduledInterviewByJobSeekerID 

func (q *Queries) SelectScheduledInterviewByJobSeekerID(ctx context.Context, jobSeekerID sql.NullInt32) ([]Scheduledinterview, error)

func (*Queries) SelectSkillByID 

func (q *Queries) SelectSkillByID(ctx context.Context, id int32) (Skill, error)

func (*Queries) SelectUserByID 

func (q *Queries) SelectUserByID(ctx context.Context, id int32) (User, error)

func (*Queries) SelectUsers 

func (q *Queries) SelectUsers(ctx context.Context) ([]User, error)

func (*Queries) UpdateApplication 

func (q *Queries) UpdateApplication(ctx context.Context, arg UpdateApplicationParams) error

func (*Queries) UpdateChatbotConversation 

func (q *Queries) UpdateChatbotConversation(ctx context.Context, arg UpdateChatbotConversationParams) error

Update (Update)

func (*Queries) UpdateChatbotInterview 

func (q *Queries) UpdateChatbotInterview(ctx context.Context, arg UpdateChatbotInterviewParams) error

func (*Queries) UpdateCompany 

func (q *Queries) UpdateCompany(ctx context.Context, arg UpdateCompanyParams) error

func (*Queries) UpdateCompanyEntity 

func (q *Queries) UpdateCompanyEntity(ctx context.Context, arg UpdateCompanyEntityParams) error

func (*Queries) UpdateEducation 

func (q *Queries) UpdateEducation(ctx context.Context, arg UpdateEducationParams) error

func (*Queries) UpdateExperience 

func (q *Queries) UpdateExperience(ctx context.Context, arg UpdateExperienceParams) error

func (*Queries) UpdateExperienceType 

func (q *Queries) UpdateExperienceType(ctx context.Context, arg UpdateExperienceTypeParams) error

func (*Queries) UpdateInstitution 

func (q *Queries) UpdateInstitution(ctx context.Context, arg UpdateInstitutionParams) error

func (*Queries) UpdateJob 

func (q *Queries) UpdateJob(ctx context.Context, arg UpdateJobParams) error

Update

func (*Queries) UpdateJobCategory 

func (q *Queries) UpdateJobCategory(ctx context.Context, arg UpdateJobCategoryParams) error

func (*Queries) UpdateJobSeeker 

func (q *Queries) UpdateJobSeeker(ctx context.Context, arg UpdateJobSeekerParams) error

Update

func (*Queries) UpdateJobViews 

func (q *Queries) UpdateJobViews(ctx context.Context, arg UpdateJobViewsParams) error

func (*Queries) UpdateScheduledInterview 

func (q *Queries) UpdateScheduledInterview(ctx context.Context, arg UpdateScheduledInterviewParams) error

func (*Queries) UpdateSkill 

func (q *Queries) UpdateSkill(ctx context.Context, arg UpdateSkillParams) error

func (*Queries) UpdateUser 

func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) error

func (*Queries) WithTx 

func (q *Queries) WithTx(tx *sql.Tx) *Queries

type Scheduledinterview 

type Scheduledinterview struct {
	ID          int32          `json:"id"`
	JobSeekerID sql.NullInt32  `json:"job_seeker_id"`
	CompanyID   sql.NullInt32  `json:"company_id"`
	ScheduledAt sql.NullTime   `json:"scheduled_at"`
	Location    sql.NullString `json:"location"`
	Notes       sql.NullString `json:"notes"`
	MeetingLink sql.NullString `json:"meeting_link"`
	CreatedAt   sql.NullTime   `json:"created_at"`
}

type SelectMessagesBySenderAndReceiverParams 

type SelectMessagesBySenderAndReceiverParams struct {
	SenderID   int32 `json:"sender_id"`
	ReceiverID int32 `json:"receiver_id"`
}

type Skill 

type Skill struct {
	ID   int32          `json:"id"`
	Name sql.NullString `json:"name"`
}

type Store 

type Store struct {
	*Queries
	// contains filtered or unexported fields
}

func NewStore 

func NewStore(db *sql.DB) *Store

type Technicalskills 

type Technicalskills string
const (
	TechnicalskillsJava                   Technicalskills = "Java"
	TechnicalskillsPython                 Technicalskills = "Python"
	TechnicalskillsJavaScript             Technicalskills = "JavaScript"
	TechnicalskillsC                      Technicalskills = "C++"
	TechnicalskillsSQL                    Technicalskills = "SQL"
	TechnicalskillsReact                  Technicalskills = "React"
	TechnicalskillsAngular                Technicalskills = "Angular"
	TechnicalskillsVue                    Technicalskills = "Vue"
	TechnicalskillsSvelte                 Technicalskills = "Svelte"
	TechnicalskillsNextjs                 Technicalskills = "Next.js"
	TechnicalskillsNodejs                 Technicalskills = "Node.js"
	TechnicalskillsExpressjs              Technicalskills = "Express.js"
	TechnicalskillsDjango                 Technicalskills = "Django"
	TechnicalskillsFlask                  Technicalskills = "Flask"
	TechnicalskillsRubyonRails            Technicalskills = "Ruby on Rails"
	TechnicalskillsSpring                 Technicalskills = "Spring"
	TechnicalskillsASPNET                 Technicalskills = "ASP.NET"
	TechnicalskillsTypeScript             Technicalskills = "TypeScript"
	TechnicalskillsDocker                 Technicalskills = "Docker"
	TechnicalskillsKubernetes             Technicalskills = "Kubernetes"
	TechnicalskillsAWS                    Technicalskills = "AWS"
	TechnicalskillsAzure                  Technicalskills = "Azure"
	TechnicalskillsGCP                    Technicalskills = "GCP"
	TechnicalskillsMachineLearning        Technicalskills = "Machine Learning"
	TechnicalskillsDataAnalysis           Technicalskills = "Data Analysis"
	TechnicalskillsCyberSecurity          Technicalskills = "Cyber Security"
	TechnicalskillsSwift                  Technicalskills = "Swift"
	TechnicalskillsGo                     Technicalskills = "Go"
	TechnicalskillsDevOps                 Technicalskills = "DevOps"
	TechnicalskillsHTMLCSS                Technicalskills = "HTML/CSS"
	TechnicalskillsAgileMethodology       Technicalskills = "Agile Methodology"
	TechnicalskillsEmbeddedSystems        Technicalskills = "Embedded Systems"
	TechnicalskillsNetworking             Technicalskills = "Networking"
	TechnicalskillsVersionControl         Technicalskills = "Version Control"
	TechnicalskillsAPIDevelopment         Technicalskills = "API Development"
	TechnicalskillsBlockchain             Technicalskills = "Blockchain"
	TechnicalskillsTestAutomation         Technicalskills = "Test Automation"
	TechnicalskillsManualTesting          Technicalskills = "Manual Testing"
	TechnicalskillsPerformanceTesting     Technicalskills = "Performance Testing"
	TechnicalskillsCICD                   Technicalskills = "CI/CD"
	TechnicalskillsScrum                  Technicalskills = "Scrum"
	TechnicalskillsKanban                 Technicalskills = "Kanban"
	TechnicalskillsSoftwareArchitecture   Technicalskills = "Software Architecture"
	TechnicalskillsMicroservices          Technicalskills = "Microservices"
	TechnicalskillsBigData                Technicalskills = "Big Data"
	TechnicalskillsIoT                    Technicalskills = "IoT"
	TechnicalskillsMobileDevelopment      Technicalskills = "Mobile Development"
	TechnicalskillsUXUIDesign             Technicalskills = "UX/UI Design"
	TechnicalskillsDatabaseAdministration Technicalskills = "Database Administration"
	TechnicalskillsWebSecurity            Technicalskills = "Web Security"
	TechnicalskillsSelenium               Technicalskills = "Selenium"
	TechnicalskillsJenkins                Technicalskills = "Jenkins"
	TechnicalskillsGit                    Technicalskills = "Git"
	TechnicalskillsLinux                  Technicalskills = "Linux"
	TechnicalskillsServerAdministration   Technicalskills = "Server Administration"
	TechnicalskillsLaravel                Technicalskills = "Laravel"
	TechnicalskillsMeteor                 Technicalskills = "Meteor"
	TechnicalskillsEmber                  Technicalskills = "Ember"
	TechnicalskillsBackbone               Technicalskills = "Backbone"
	TechnicalskillsCherryPy               Technicalskills = "CherryPy"
	TechnicalskillsFastAPI                Technicalskills = "FastAPI"
	TechnicalskillsSymfony                Technicalskills = "Symfony"
	TechnicalskillsHibernate              Technicalskills = "Hibernate"
	TechnicalskillsQt                     Technicalskills = "Qt"
	TechnicalskillsTensorFlow             Technicalskills = "TensorFlow"
	TechnicalskillsPyTorch                Technicalskills = "PyTorch"
	TechnicalskillsRedux                  Technicalskills = "Redux"
)

func (*Technicalskills) Scan 

func (e *Technicalskills) Scan(src interface{}) error

type UpdateApplicationParams 

type UpdateApplicationParams struct {
	CoverLetter sql.NullString        `json:"cover_letter"`
	Resume      sql.NullString        `json:"resume"`
	Status      NullApplicationStatus `json:"status"`
	ID          int32                 `json:"id"`
}

type UpdateChatbotConversationParams 

type UpdateChatbotConversationParams struct {
	ChatbotInterviewID sql.NullInt32  `json:"chatbot_interview_id"`
	SenderType         sql.NullString `json:"sender_type"`
	Content            string         `json:"content"`
	ID                 int32          `json:"id"`
}

type UpdateChatbotInterviewParams 

type UpdateChatbotInterviewParams struct {
	Status NullInterviewStatus `json:"status"`
	Review sql.NullString      `json:"review"`
	ID     int32               `json:"id"`
}

type UpdateCompanyEntityParams 

type UpdateCompanyEntityParams struct {
	Name sql.NullString `json:"name"`
	ID   int32          `json:"id"`
}

type UpdateCompanyParams 

type UpdateCompanyParams struct {
	Name        string         `json:"name"`
	Email       string         `json:"email"`
	Phone       sql.NullString `json:"phone"`
	Website     sql.NullString `json:"website"`
	Description sql.NullString `json:"description"`
	ID          int32          `json:"id"`
}

type UpdateEducationParams 

type UpdateEducationParams struct {
	InstitutionID sql.NullInt32  `json:"institution_id"`
	Degree        sql.NullString `json:"degree"`
	FieldOfStudy  sql.NullString `json:"field_of_study"`
	StartDate     sql.NullTime   `json:"start_date"`
	EndDate       sql.NullTime   `json:"end_date"`
	ID            int32          `json:"id"`
}

type UpdateExperienceParams 

type UpdateExperienceParams struct {
	Title       sql.NullString `json:"title"`
	Location    sql.NullString `json:"location"`
	StartDate   sql.NullTime   `json:"start_date"`
	EndDate     sql.NullTime   `json:"end_date"`
	TypeID      sql.NullInt32  `json:"type_id"`
	Description sql.NullString `json:"description"`
	ID          int32          `json:"id"`
}

type UpdateExperienceTypeParams 

type UpdateExperienceTypeParams struct {
	Name sql.NullString `json:"name"`
	ID   int32          `json:"id"`
}

type UpdateInstitutionParams 

type UpdateInstitutionParams struct {
	Name sql.NullString `json:"name"`
	ID   int32          `json:"id"`
}

type UpdateJobCategoryParams 

type UpdateJobCategoryParams struct {
	Name sql.NullString `json:"name"`
	ID   int32          `json:"id"`
}

type UpdateJobParams 

type UpdateJobParams struct {
	Title        string         `json:"title"`
	Description  sql.NullString `json:"description"`
	Requirements sql.NullString `json:"requirements"`
	Location     sql.NullString `json:"location"`
	Salary       sql.NullInt32  `json:"salary"`
	ID           int32          `json:"id"`
}

type UpdateJobSeekerParams 

type UpdateJobSeekerParams struct {
	UserID sql.NullInt32 `json:"user_id"`
	ID     int32         `json:"id"`
}

type UpdateJobViewsParams 

type UpdateJobViewsParams struct {
	ViewCount sql.NullInt32 `json:"view_count"`
	JobID     int32         `json:"job_id"`
}

type UpdateScheduledInterviewParams 

type UpdateScheduledInterviewParams struct {
	ScheduledAt sql.NullTime   `json:"scheduled_at"`
	Location    sql.NullString `json:"location"`
	Notes       sql.NullString `json:"notes"`
	MeetingLink sql.NullString `json:"meeting_link"`
	ID          int32          `json:"id"`
}

type UpdateSkillParams 

type UpdateSkillParams struct {
	Name sql.NullString `json:"name"`
	ID   int32          `json:"id"`
}

type UpdateUserParams 

type UpdateUserParams struct {
	Name  string         `json:"name"`
	Email string         `json:"email"`
	Phone sql.NullString `json:"phone"`
	Role  sql.NullString `json:"role"`
	ID    int32          `json:"id"`
}

type User 

type User struct {
	ID        int32          `json:"id"`
	Name      string         `json:"name"`
	Email     string         `json:"email"`
	Phone     sql.NullString `json:"phone"`
	Role      sql.NullString `json:"role"`
	CreatedAt sql.NullTime   `json:"created_at"`
	UpdatedAt sql.NullTime   `json:"updated_at"`
}

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.