warehouse

type AsWarehouse ¶

type AsWarehouse interface {

	// AsWarehouse returns a data warehouse so end-user can run SQL operations and
	// queries on top the native dialect of the database.
	AsWarehouse() (*Warehouse, error)
}

AsWarehouse can be implemented by sources and destinations to benefit a template SQL syntax on top of a SQL database for TLT.

Note: It is implemented by the third-party package sqlike to easily leverage the standard database/sql and run operations / queries on top of the SQL database. See Go module at https://pkg.go.dev/github.com/nunchistudio/blacksmith-modules/sqlike for more details.

type Options ¶

type Options struct {

	// Name indicates the identifier of the SQL database which will be used as name
	// for the warehouse.
	//
	// Example: "sqlike(mypostgres)"
	// Required.
	Name string

	// DB is the database connection created using the package database/sql of the
	// standard library.
	//
	// Required.
	DB *sql.DB
}

Options is the options a source or destination can pass to be leveraged as a data warehouse.

type Warehouse ¶

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

Warehouse represents a data warehouse. End-users can run SQL template syntax which compile to SQL, on top of the native dialect of the database.

func New(opts *Options) (*Warehouse, error)

func (wh *Warehouse) Compile(filename string, data map[string]interface{}) (string, error)

func (wh *Warehouse) Exec(query string) error

func (wh *Warehouse) Query(query string) (*sql.Rows, error)