xsql

type DB interface {
	Query(dql string, args ...interface{}) Query
	NamedQuery(dql string, args map[string]interface{}) (Query, error)
	Sifter(sifts ...domain.Sift) Sifter

	Get(out entity.Interface) error

	Insert(e entity.Interface) (int64, error)
	Update(e entity.Interface) (int64, error)
	Delete(e entity.Interface) (int64, error)
	Disable(e entity.Interface) (int64, error)

	Exec(dml string, args ...interface{}) (sql.Result, error)

	Begin() (Tx, error)

	Close() error

	Dialect() dialect.Interface

	Ping() error
}

type Query interface {
	Rows(out entity.Interfaces) error
	Row(out entity.Interface) error
	Int() (int, error)
	Float() (float64, error)
	Str() (string, error)
	Time() (time.Time, error)
	Page(content entity.Interfaces, pageable domain.Pageable) (domain.Page, error)

	String() string
}

type Sifter interface {
	Rows(out entity.Interfaces) error
	Row(out entity.Interface) error
	Count(e entity.Interface) (int, error)
	Page(content entity.Interfaces, pageable domain.Pageable) (domain.Page, error)
}

type Tx interface {
	Exec(dml string, args ...interface{}) (sql.Result, error)
	Commit() error
	Rollback() error
}