dbtools

package module

v0.0.21 Latest Latest Go to latest Published: Jul 18, 2023 License: MIT Imports: 8 Imported by: 1

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/cdvelop/dbtools

Links

Open Source Insights

README ¶

dbtools

Operaciones en Base de datos, elimination tablas, creación db copia de data etc...

Documentation ¶

Index ¶

func AddColumn(table_name, column_name, data_type string, tx *sql.Tx, ctx context.Context) bool
func ClonDATABLE(o dboAdapter, table model.Object) bool
func ClonOneTableInTransaction(o dboAdapter, table model.Object, tx *sql.Tx, ctx context.Context) bool
func CreateAllTABLES(dba dbAdapter, tables ...model.Object) (ok bool)
func CreateOneTABLE(dba dbAdapter, table model.Object) bool
func CreateTableInTransaction(table model.Object, tx *sql.Tx, ctx context.Context) bool
func DeleteDataFromTABLE(dba dbAdapter, table_name string)
func DeleteTABLE(o dboAdapter, table_name string)
func DeleteTableInTransaction(table model.Object, o OrmAdapter, tx *sql.Tx, ctx context.Context) bool
func FetchAll(rows *sql.Rows) ([]map[string]string, error)
func FetchOne(rows *sql.Rows) (map[string]string, error)
func IdpkTABLA(keyNameIN, table_name string) (primarykey, primaryKeyThisTable bool)
func RenameColumn(table_name, old_column, new_column string, tx *sql.Tx, ctx context.Context) bool
func RenameTable(old_name, new_name string, tx *sql.Tx, ctx context.Context) bool
func ScanOne(rows *sql.Rows, columnCount int, columns []string) (map[string]string, error)
func SelectAll(sql string, dba dbAdapter, ctx context.Context) (rowsMap []map[string]string, ok bool)
func SelectOne(sql string, dba dbAdapter, ctx context.Context) (rowsMap map[string]string, ok bool)
func UpdateTABLES(o dboAdapter, tables ...model.Object) bool
func UpdateTablesTransaction(o dboAdapter, tx *sql.Tx, ctx context.Context, tables ...model.Object) bool
type OrmAdapter
type UnixID
- func NewUnixIdHandler() *UnixID
- func (id *UnixID) GetNewID() string

Constants ¶

This section is empty.

Variables ¶

This section is empty.

Functions ¶

func AddColumn ¶

func AddColumn(table_name, column_name, data_type string, tx *sql.Tx, ctx context.Context) bool

func ClonDATABLE ¶ added in v0.0.13

func ClonDATABLE(o dboAdapter, table model.Object) bool

ClonDATABLE copia la data de una tabla a otra nueva

func ClonOneTableInTransaction ¶ added in v0.0.13

func ClonOneTableInTransaction(o dboAdapter, table model.Object, tx *sql.Tx, ctx context.Context) bool

ClonOneTableInTransaction copia la data de una tabla a otra nueva

func CreateAllTABLES ¶ added in v0.0.13

func CreateAllTABLES(dba dbAdapter, tables ...model.Object) (ok bool)

CreateAllTABLES crea todas las tablas de la base de datos

func CreateOneTABLE ¶ added in v0.0.13

func CreateOneTABLE(dba dbAdapter, table model.Object) bool

CreateOneTABLE según nombre tabla y solo con un id_nombretabla correlativo por defecto

func CreateTableInTransaction ¶

func CreateTableInTransaction(table model.Object, tx *sql.Tx, ctx context.Context) bool

func DeleteDataFromTABLE ¶ added in v0.0.13

func DeleteDataFromTABLE(dba dbAdapter, table_name string)

DeleteDataFromTABLE borra data de una tabla en db

func DeleteTABLE ¶ added in v0.0.13

func DeleteTABLE(o dboAdapter, table_name string)

DeleteTABLE elimina tabla de una base de datos

func DeleteTableInTransaction ¶ added in v0.0.13

func DeleteTableInTransaction(table model.Object, o OrmAdapter, tx *sql.Tx, ctx context.Context) bool

func FetchAll ¶

func FetchAll(rows *sql.Rows) ([]map[string]string, error)

func FetchOne ¶

func FetchOne(rows *sql.Rows) (map[string]string, error)

FetchOne .

func IdpkTABLA ¶

func IdpkTABLA(keyNameIN, table_name string) (primarykey, primaryKeyThisTable bool)

IdpkTABLA recibe kname y tabla name retorna 2 true si: es fk y pkey de la tabla

func RenameColumn ¶

func RenameColumn(table_name, old_column, new_column string, tx *sql.Tx, ctx context.Context) bool

func RenameTable ¶

func RenameTable(old_name, new_name string, tx *sql.Tx, ctx context.Context) bool

func ScanOne ¶

func ScanOne(rows *sql.Rows, columnCount int, columns []string) (map[string]string, error)

ScanOne

func SelectAll ¶

func SelectAll(sql string, dba dbAdapter, ctx context.Context) (rowsMap []map[string]string, ok bool)

SelectAll...

func SelectOne ¶

func SelectOne(sql string, dba dbAdapter, ctx context.Context) (rowsMap map[string]string, ok bool)

func UpdateTABLES ¶ added in v0.0.13

func UpdateTABLES(o dboAdapter, tables ...model.Object) bool

UpdateTABLES revisa si tienen data las tablas para actualizarlas y respaldar la data

func UpdateTablesTransaction ¶ added in v0.0.13

func UpdateTablesTransaction(o dboAdapter, tx *sql.Tx, ctx context.Context, tables ...model.Object) bool

UpdateTABLES revisa si tienen data las tablas para actualizarlas y respaldar la data

Types ¶

type OrmAdapter ¶ added in v0.0.3

type OrmAdapter interface {
	//ej postgres:"$1", sqlite: "?"
	PlaceHolders(index ...uint8) string
	DeleteDataBase()
	// SQLTableInfo() string //sql como obtiene la base de datos el nombre de la tabla
	SQLTableInfo() string
	// SQLColumName() string //sql como se llama a la columna en el motor de base de datos
	SQLColumName() string
	// SQLDropTable() string //sql de eliminación de tabla
	SQLDropTable() string
	//ej: pg: DROP TABLE IF EXISTS $1 CASCADE; sqlite:
	DropTable() string
}

type UnixID ¶ added in v0.0.12

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

func NewUnixIdHandler ¶ added in v0.0.12

func NewUnixIdHandler() *UnixID

func (*UnixID) GetNewID ¶ added in v0.0.12

func (id *UnixID) GetNewID() string

GetNewID retorna un id único para el ingreso a la base de datos tipo unix time

Source Files ¶

View all Source files

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