databaseService

type DatabaseService interface {
	AddTable(accountId string, projectName string, tableName string, isPublic, isWritePublic bool) error
	DeleteTable(accountId string, projectName string, tableName string) error
	IsTablePublic(projectTag string, tableName string) (bool, error)
	IsWriteToTablePublic(projectTag string, tableName string) (bool, error)
	SetTableAccess(accountId, projectName, tableName string, isPublic bool) error
	SetWriteToTableAccess(accountId, projectName, tableName string, isWritePublic bool) error
	AddTableColumn(accountId string, projectName string, tableName string, columnName string, columnType string) error
	DeleteTableColumn(accountId string, projectName string, tableName string, columnName string) error
	GetTablesList(accountId string, projectName string) ([]string, error)
	ListTableColumns(accountId string, projectName string, tableName string) ([]models.PgColumn, error)
	RunDatabaseQuery(projectTag string, query string) (map[string]interface{}, error)

	DeleteDatabase(accountId string, projectName string) error
	DeleteDatabaseUser(accountId string, projectName string) error

	InsertRow(tpAccountId string, projectTag string, tableName string, row map[string]interface{}) error
	ImportCsvFile(file *multipart.FileHeader, accountId string, projectName string, projectTag string, tableName string) error
	UpdateRow(tpAccountId string, projectTag string, tableName string, id int, row map[string]interface{}) error
	DeleteRow(tpAccountId string, projectTag string, tableName string, id int, filters databaseStore.ConditionGroup) error
	SelectRows(tpAccountId string, projectTag string, tableName string, columns []string, functions []databaseStore.Function, filters databaseStore.ConditionGroup, orderBy string, descending bool, page int, size int) (map[string]interface{}, error)
	SelectRowById(tpAccountId string, projectTag string, tableName string, id int) (map[string]interface{}, error)

	UpsertView(accountId string, projectName string, viewName string, tableName string, columns []string, filters databaseStore.ConditionGroup, jsonQuery map[string]interface{}, isPublic bool) error
	GetViewsList(accountId string, projectName string) ([]models.DatabaseView, error)
	GetViewDetails(accountId string, projectName string, viewName string) (models.DatabaseView, error)
	DeleteView(accountId string, projectName string, viewName string) error
	RunViewQuery(tpAccountId string, projectTag string, viewName string, page int, size int) (map[string]interface{}, error)
	IsViewPublic(projectTag string, viewName string) (bool, error)

	RunDatabaseJob(accountId, projectName, job string) error
	GetDatabaseJob(accountId string, projectName string) (models.DatabaseJob, error)
}