db_client

Documentation

Index

• type DbClient
  • func NewDbClient(connectionString string) (*DbClient, error)
  • func (c *DbClient) AcquireSession(ctx context.Context) *db_common.AcquireSessionResult
  • func (c *DbClient) CacheClear() error
  • func (c *DbClient) CacheOff() error
  • func (c *DbClient) CacheOn() error
  • func (c *DbClient) Close() error
  • func (c *DbClient) ConnectionMap() *steampipeconfig.ConnectionDataMap
  • func (c *DbClient) ContructSearchPath(requiredSearchPath []string, searchPathPrefix []string, ...) ([]string, error)
  • func (c *DbClient) Execute(ctx context.Context, query string, disableSpinner bool) (*queryresult.Result, error)
  • func (c *DbClient) ExecuteInSession(ctx context.Context, session *db_common.DatabaseSession, query string, ...) (res *queryresult.Result, err error)
  • func (c *DbClient) ExecuteSync(ctx context.Context, query string, disableSpinner bool) (*queryresult.SyncQueryResult, error)
  • func (c *DbClient) ExecuteSyncInSession(ctx context.Context, session *db_common.DatabaseSession, query string, ...) (*queryresult.SyncQueryResult, error)
  • func (c *DbClient) GetCurrentSearchPath() ([]string, error)
  • func (c *DbClient) LoadSchema()
  • func (c *DbClient) RefreshConnectionAndSearchPaths() *steampipeconfig.RefreshConnectionResult
  • func (c *DbClient) RefreshSessions(ctx context.Context) *db_common.AcquireSessionResult
  • func (c *DbClient) SchemaMetadata() *schema.Metadata
  • func (c *DbClient) SetEnsureSessionDataFunc(f db_common.EnsureSessionStateCallback)
  • func (c *DbClient) SetSessionSearchPath(currentUserSearchPath ...string) error

Types

type DbClient

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

DbClient wraps over `sql.DB` and gives an interface to the database

func NewDbClient

func NewDbClient(connectionString string) (*DbClient, error)

func (*DbClient) AcquireSession

func (c *DbClient) AcquireSession(ctx context.Context) *db_common.AcquireSessionResult

func (*DbClient) CacheClear

func (c *DbClient) CacheClear() error

CacheClear implements Client

func (*DbClient) CacheOff

func (c *DbClient) CacheOff() error

CacheOff implements Client

func (*DbClient) CacheOn

func (c *DbClient) CacheOn() error

CacheOn implements Client

func (*DbClient) Close

func (c *DbClient) Close() error

Close implements Client closes the connection to the database and shuts down the backend

func (*DbClient) ConnectionMap

func (c *DbClient) ConnectionMap() *steampipeconfig.ConnectionDataMap

func (*DbClient) ContructSearchPath

func (c *DbClient) ContructSearchPath(requiredSearchPath []string, searchPathPrefix []string, currentUserSearchPath []string) ([]string, error)

func (*DbClient) Execute

func (c *DbClient) Execute(ctx context.Context, query string, disableSpinner bool) (*queryresult.Result, error)

Execute implements Client execute the provided query against the Database in the given context.Context Bear in mind that whenever ExecuteQuery is called, the returned `queryresult.Result` MUST be fully read - otherwise the transaction is left open, which will block the connection and will prevent subsequent communications with the service

func (*DbClient) ExecuteInSession

func (c *DbClient) ExecuteInSession(ctx context.Context, session *db_common.DatabaseSession, query string, onComplete func(), disableSpinner bool) (res *queryresult.Result, err error)

func (*DbClient) ExecuteSync

func (c *DbClient) ExecuteSync(ctx context.Context, query string, disableSpinner bool) (*queryresult.SyncQueryResult, error)

ExecuteSync implements Client execute a query against this client and wait for the result

func (*DbClient) ExecuteSyncInSession

func (c *DbClient) ExecuteSyncInSession(ctx context.Context, session *db_common.DatabaseSession, query string, disableSpinner bool) (*queryresult.SyncQueryResult, error)

ExecuteSyncInSession implements Client execute a query against this client and wait for the result

func (*DbClient) GetCurrentSearchPath

func (c *DbClient) GetCurrentSearchPath() ([]string, error)

GetCurrentSearchPath implements Client query the database to get the current search path

func (*DbClient) LoadSchema

func (c *DbClient) LoadSchema()

LoadSchema implements Client retrieve both the raw query result and a sanitised version in list form

func (*DbClient) RefreshConnectionAndSearchPaths

func (c *DbClient) RefreshConnectionAndSearchPaths() *steampipeconfig.RefreshConnectionResult

RefreshConnectionAndSearchPaths implements Client

func (*DbClient) RefreshSessions

func (c *DbClient) RefreshSessions(ctx context.Context) *db_common.AcquireSessionResult

RefreshSessions terminates the current connections and creates a new one - repopulating session data

func (*DbClient) SchemaMetadata

func (c *DbClient) SchemaMetadata() *schema.Metadata

SchemaMetadata implements Client return the latest schema metadata

func (*DbClient) SetEnsureSessionDataFunc

func (c *DbClient) SetEnsureSessionDataFunc(f db_common.EnsureSessionStateCallback)

func (*DbClient) SetSessionSearchPath

func (c *DbClient) SetSessionSearchPath(currentUserSearchPath ...string) error

SetSessionSearchPath implements Client if either a search-path or search-path-prefix is set in config, set the search path (otherwise fall back to user search path) this just sets the required search path for this client - when creating a database session, we will actually set the searchPath