database

type Driver interface {
	// Open returns a new driver instance configured with parameters
	// coming from the URL string. Migrate will call this function
	// only once per instance.
	Open(url string) (Driver, error)

	// Close closes the underlying database instance managed by the driver.
	// Migrate will call this function only once per instance.
	Close() error

	// Lock should acquire a database lock to control concurrency if required by
	// the application.
	Lock() error

	// Unlock should release the lock. Applications should call this when they
	// have completed interacting with the driver.
	Unlock() error

	// Begin should begin a transaction in the database. It should return an error if there is
	// already an active transaction in the database.
	Begin() error

	// Rollback should rollback a transaction in the database. It should return an error
	// if there is currently no active transaction.
	Rollback() error

	// Commit should commit the active transaction in the database. It should return an error
	// if there is currently no active transaction.
	Commit() error

	// Execute should execute the given command against the database.
	Exec(command io.Reader, params ...interface{}) error

	// ImportCSV imports a csv file into the database.
	ImportCSV(filePath, schemaName, tableName, delimiter string, header bool) error
}

type Error struct {
	// Optional: the line number
	Line uint

	// Query is a query excerpt
	Query []byte

	// Err is a useful/helping error message for humans
	Err string

	// OrigErr is the underlying error
	OrigErr error
}