Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

sqlclient

package

Go to main page

Versions in this module

v0

v0.4.2

Jul 17, 2025

Changes in this version

+ const SelectScannerLastScanTimestamp

type SQLClient

+ func (a SQLClient) GetScannerLastScanTimestamp() (*time.Time, error)

v0.4.1

May 20, 2025

Changes in this version

+ const CheckStatusQuery

+ const DeleteAccountQuery

+ const DeleteClusterQuery

+ const DeleteInstanceQuery

+ const DeleteScheduledActionsQuery

+ const DeleteTagsQuery

+ const DisableActionQuery

+ const EnableActionQuery

+ const InsertAccountsQuery

+ const InsertClustersQuery

+ const InsertCronActionsQuery

+ const InsertEventQuery

+ const InsertExpensesQuery

+ const InsertInstancesQuery

+ const InsertScheduledActionsQuery

+ const InsertTagsQuery

+ const PatchActionStatusQuery

+ const PatchCronActionsQuery

+ const PatchScheduledActionsQuery

+ const SelectAccountsByNameQuery

+ const SelectAccountsQuery

+ const SelectClusterAccountNameQuery

+ const SelectClusterEventsQuery

+ const SelectClusterRegionQuery

+ const SelectClusterTags

+ const SelectClustersByIDuery

+ const SelectClustersOnAccountQuery

+ const SelectClustersOverview

+ const SelectClustersQuery

+ const SelectExpensesByInstanceQuery

+ const SelectExpensesQuery

+ const SelectInstancesByIDQuery

+ const SelectInstancesOnClusterQuery

+ const SelectInstancesOverview

+ const SelectInstancesQuery

+ const SelectLastExpensesQuery

+ const SelectLastExpensesQueryVOPT

+ const SelectProvidersOverviewQuery

+ const SelectScheduledActionsByIDQuery

+ const SelectScheduledActionsQuery

+ const SelectScheduledActionsQueryConditionsPlaceholder

+ const SelectSystemEventsQuery

+ const UpdateEventStatusQuery

+ const UpdateStatusClusterByClusterIDQuery

+ const UpdateStatusInstancesByClusterIDQuery

+ const UpdateTerminatedClustersQuery

+ const UpdateTerminatedInstancesQuery

+ type SQLClient struct

+ func NewSQLClient(dbURL string, logger *zap.Logger) (*SQLClient, error)

+ func (a SQLClient) AddEvent(event models.AuditLog) (int64, error)

+ func (a SQLClient) CheckStatusValue(status string) (bool, error)

+ func (a SQLClient) DeleteAccount(accountName string) error

+ func (a SQLClient) DeleteCluster(clusterName string) error

+ func (a SQLClient) DeleteInstance(instanceID string) error

+ func (a SQLClient) DeleteScheduledAction(actionID string) error

+ func (a SQLClient) DisableScheduledAction(actionID string) error

+ func (a SQLClient) EnableScheduledAction(actionID string) error

+ func (a SQLClient) GetAccountByName(accountName string) ([]inventory.Account, error)

+ func (a SQLClient) GetAccounts() ([]inventory.Account, error)

+ func (a SQLClient) GetClusterAccountName(clusterID string) (string, error)

+ func (a SQLClient) GetClusterByID(clusterID string) ([]inventory.Cluster, error)

+ func (a SQLClient) GetClusterEvents(clusterID string) ([]models.AuditLog, error)

+ func (a SQLClient) GetClusterRegion(clusterID string) (string, error)

+ func (a SQLClient) GetClusterTags(clusterID string) ([]inventory.Tag, error)

+ func (a SQLClient) GetClusters() ([]inventory.Cluster, error)

+ func (a SQLClient) GetClustersOnAccount(accountName string) ([]inventory.Cluster, error)

+ func (a SQLClient) GetClustersOverview() (models.ClustersSummary, error)

+ func (a SQLClient) GetExpenses() ([]inventory.Expense, error)

+ func (a SQLClient) GetExpensesByInstance(instanceID string) ([]inventory.Expense, error)

+ func (a SQLClient) GetInstanceByID(instanceID string) ([]inventory.Instance, error)

+ func (a SQLClient) GetInstances() ([]inventory.Instance, error)

+ func (a SQLClient) GetInstancesOnCluster(clusterID string) ([]inventory.Instance, error)

+ func (a SQLClient) GetInstancesOutdatedBilling() ([]inventory.Instance, error)

+ func (a SQLClient) GetInstancesOverview() (models.InstancesSummary, error)

+ func (a SQLClient) GetProvidersOverview() (models.ProvidersSummary, error)

+ func (a SQLClient) GetScheduledActionByID(actionID string) ([]actions.Action, error)

+ func (a SQLClient) GetScheduledActions(conditions []string, args []interface{}) ([]actions.Action, error)

+ func (a SQLClient) GetSystemEvents() ([]models.SystemAuditLogs, error)

+ func (a SQLClient) PatchScheduledAction(newActions []actions.Action) error

+ func (a SQLClient) PatchScheduledActionStatus(actionID string, status string) error

+ func (a SQLClient) Ping() error

+ func (a SQLClient) RefreshInventory() error

+ func (a SQLClient) UpdateClusterStatusByClusterID(status string, clusterID string) error

+ func (a SQLClient) UpdateEventStatus(eventID int64, result string) error

+ func (a SQLClient) WriteAccounts(accounts []inventory.Account) error

+ func (a SQLClient) WriteClusters(clusters []inventory.Cluster) error

+ func (a SQLClient) WriteExpenses(expenses []inventory.Expense) error

+ func (a SQLClient) WriteInstances(instances []inventory.Instance) error

+ func (a SQLClient) WriteScheduledActions(newActions []actions.Action) error