sql

package

v0.9.5 Latest Latest Go to latest Published: May 15, 2024 License: GPL-3.0 Imports: 11 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

Repository

git.sxidc.com/service-supports/ds-sdk

Links

Open Source Insights

Documentation ¶

Index ¶

func CheckExist(executor Executor, executeParams *sql_tpl.CheckExistExecuteParams) (bool, error)
func CheckHasOnlyOne(executor Executor, executeParams *sql_tpl.CheckHasOnlyOneExecuteParams) (bool, error)
func Count(executor Executor, executeParams *sql_tpl.CountExecuteParams) (int64, error)
func Delete(executor Executor, executeParams *sql_tpl.DeleteExecuteParams) error
func DeleteEntity[T any](executor Executor, tableName string, e T) error
func ExecuteRawSql(executor Executor, sql string, executeParams map[string]any) ([]sdk.SqlResult, error)
func ExecuteSql(executor Executor, name string, executeParams map[string]any) ([]sdk.SqlResult, error)
func Insert(executor Executor, executeParams *sql_tpl.InsertExecuteParams) error
func InsertBatch(executor Executor, executeParams *sql_tpl.InsertBatchExecuteParams) error
func InsertEntity[T any](executor Executor, tableName string, e T) error
func ParseSqlResult[T any](input any) (T, error)
func Query(executor Executor, executeParams *sql_tpl.QueryExecuteParams) ([]sdk.SqlResult, int64, error)
func QueryOne(executor Executor, executeParams *sql_tpl.QueryOneExecuteParams) (sdk.SqlResult, error)
func Update(executor Executor, executeParams *sql_tpl.UpdateExecuteParams) error
func UpdateEntity[T any](executor Executor, tableName string, e T) error
type Executor
type Mapping
- func ParseSqlMappingTag(e any) (*Mapping, error)
type MappingColumn
type Result
- func ParseSqlResultTag(e any) (*Result, error)
type ResultColumn

Constants ¶

This section is empty.

Variables ¶

This section is empty.

Functions ¶

func CheckExist ¶

func CheckExist(executor Executor, executeParams *sql_tpl.CheckExistExecuteParams) (bool, error)

func CheckHasOnlyOne ¶

func CheckHasOnlyOne(executor Executor, executeParams *sql_tpl.CheckHasOnlyOneExecuteParams) (bool, error)

func Count ¶

func Count(executor Executor, executeParams *sql_tpl.CountExecuteParams) (int64, error)

func Delete ¶

func Delete(executor Executor, executeParams *sql_tpl.DeleteExecuteParams) error

func DeleteEntity ¶

func DeleteEntity[T any](executor Executor, tableName string, e T) error

func ExecuteRawSql ¶

func ExecuteRawSql(executor Executor, sql string, executeParams map[string]any) ([]sdk.SqlResult, error)

func ExecuteSql ¶

func ExecuteSql(executor Executor, name string, executeParams map[string]any) ([]sdk.SqlResult, error)

func Insert ¶

func Insert(executor Executor, executeParams *sql_tpl.InsertExecuteParams) error

func InsertBatch ¶ added in v0.9.0

func InsertBatch(executor Executor, executeParams *sql_tpl.InsertBatchExecuteParams) error

func InsertEntity ¶

func InsertEntity[T any](executor Executor, tableName string, e T) error

func ParseSqlResult ¶ added in v0.7.0

func ParseSqlResult[T any](input any) (T, error)

func Query ¶

func Query(executor Executor, executeParams *sql_tpl.QueryExecuteParams) ([]sdk.SqlResult, int64, error)

func QueryOne ¶

func QueryOne(executor Executor, executeParams *sql_tpl.QueryOneExecuteParams) (sdk.SqlResult, error)

func Update ¶

func Update(executor Executor, executeParams *sql_tpl.UpdateExecuteParams) error

func UpdateEntity ¶

func UpdateEntity[T any](executor Executor, tableName string, e T) error

Types ¶

type Executor ¶ added in v0.6.1

type Executor interface {
	ExecuteRawSql(sql string, executeParams map[string]any) ([]sdk.SqlResult, error)
	ExecuteSql(name string, executeParams map[string]any) ([]sdk.SqlResult, error)
}

type Mapping ¶ added in v0.6.1

type Mapping struct {
	MappingElement map[string]any
}

func ParseSqlMappingTag ¶ added in v0.8.0

func ParseSqlMappingTag(e any) (*Mapping, error)

type MappingColumn ¶ added in v0.6.1

type MappingColumn struct {
	Name           string
	IsKey          bool
	CanUpdate      bool
	CanUpdateClear bool
	AESKey         string
	JoinWith       string

	// 原字段的反射结构
	OriginFieldType  reflect.Type
	OriginFieldValue reflect.Value

	// 值类型的反射结构
	FieldTypeElem  reflect.Type
	FieldValueElem reflect.Value
}

type Result ¶ added in v0.7.0

type Result struct {
	ResultElement map[string]any
}

func ParseSqlResultTag ¶ added in v0.8.0

func ParseSqlResultTag(e any) (*Result, error)

type ResultColumn ¶ added in v0.7.0

type ResultColumn struct {
	Name      string
	ParseTime string
	AESKey    string
	SplitWith string

	// 原字段的反射结构
	OriginFieldType  reflect.Type
	OriginFieldValue reflect.Value

	// 值类型的反射结构
	FieldTypeElem  reflect.Type
	FieldValueElem reflect.Value
}

Source Files ¶

View all Source files

Directories ¶

Path	Synopsis
sql_tpl

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL