oracledb

package
v0.0.0-...-2ec961a Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Nov 10, 2023 License: MIT Imports: 9 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

View Source
var G_dbtables map[string]interface{}
View Source
var G_fd_list map[string]interface{}

Functions

This section is empty.

Types

type Oraclecon

type Oraclecon struct {
	Masterdb *sql.DB
	//Slavedb     []*sql.DB
	Db_host     string
	Db_user     string
	Db_port     string
	Db_name     string
	Db_password string
	Where_param []interface{}
	SqlTx       *sql.Tx
	Slock       sync.RWMutex
	Page_start  int
	Page_end    int
	Tablename   string
	Sql_where   string
	Sql_order   string
	Sql_fields  string
	Is_open     bool
	Sql_param   []interface{}
	//Sql_limit   string
	Db_perfix   string
	PRK_editfd  string
	Query_data  []map[string]interface{}
	LastSqltext string
}
var G_Dbcon *Oraclecon

func Get_New_Main_DB

func Get_New_Main_DB() *Oraclecon

func NewOracle_Server_DB

func NewOracle_Server_DB(action string) *Oraclecon

func (*Oraclecon) BeginStart

func (this *Oraclecon) BeginStart() bool

func (*Oraclecon) Build_where

func (this *Oraclecon) Build_where() (string, []interface{})

func (*Oraclecon) Check_PK

func (this *Oraclecon) Check_PK(fdname string) bool

func (*Oraclecon) Check_data_fields

func (this *Oraclecon) Check_data_fields(fieldname string) bool

func (*Oraclecon) Commit

func (this *Oraclecon) Commit()

func (*Oraclecon) Count

func (this *Oraclecon) Count() int64

func (*Oraclecon) Dbinit

func (this *Oraclecon) Dbinit()

* 初始化结构

func (*Oraclecon) Delete

func (this *Oraclecon) Delete() (sql.Result, error)

func (*Oraclecon) Excute

func (this *Oraclecon) Excute(sqltext string, param []interface{}) (sql.Result, error)

func (*Oraclecon) Fileds

func (this *Oraclecon) Fileds(name string) *Oraclecon

func (*Oraclecon) Find

func (this *Oraclecon) Find() map[string]string

func (*Oraclecon) GetLastSql

func (this *Oraclecon) GetLastSql() string

func (*Oraclecon) Get_fields_sql

func (this *Oraclecon) Get_fields_sql(fd_name, val_name string) (result string)

func (*Oraclecon) Get_fun_fields

func (this *Oraclecon) Get_fun_fields(fd_name, val_name string) (result string, flag bool)

func (*Oraclecon) Get_new_add

func (this *Oraclecon) Get_new_add() map[string]string

func (*Oraclecon) Get_where_data

func (this *Oraclecon) Get_where_data(postdata map[string]interface{}) map[string]interface{}

func (*Oraclecon) Init_Redis_Struct

func (this *Oraclecon) Init_Redis_Struct()

func (*Oraclecon) Insert

func (this *Oraclecon) Insert(postdata map[string]interface{}) (sql.Result, error)

func (*Oraclecon) Merge_And_where

func (this *Oraclecon) Merge_And_where(where_str, new_str string) string

func (*Oraclecon) Merge_OR_where

func (this *Oraclecon) Merge_OR_where(where_str, new_str string) string

func (*Oraclecon) Order

func (this *Oraclecon) Order(orderstr string) *Oraclecon

func (*Oraclecon) PageLimit

func (this *Oraclecon) PageLimit(startct, endct int) *Oraclecon

func (*Oraclecon) Query

func (this *Oraclecon) Query(sqltext string, param []interface{}) []map[string]string

func (*Oraclecon) Query_One

func (this *Oraclecon) Query_One(sqltext string, param []interface{}) map[string]string

func (*Oraclecon) Rollback

func (this *Oraclecon) Rollback()

func (*Oraclecon) Select

func (this *Oraclecon) Select() []map[string]string

func (*Oraclecon) SetDec

func (this *Oraclecon) SetDec(fdname string, quantity int) (sql.Result, error)

func (*Oraclecon) SetInc

func (this *Oraclecon) SetInc(fdname string, quantity int) (sql.Result, error)

func (*Oraclecon) SetOpen

func (this *Oraclecon) SetOpen(flag bool) *Oraclecon

func (*Oraclecon) SetPK

func (this *Oraclecon) SetPK(str_val string) *Oraclecon

func (*Oraclecon) SetWhere

func (this *Oraclecon) SetWhere(where string, param ...interface{}) *Oraclecon

func (*Oraclecon) Sum

func (this *Oraclecon) Sum(fd string) float64

func (*Oraclecon) Tbname

func (this *Oraclecon) Tbname(name string) *Oraclecon

设置数据表

func (*Oraclecon) Type2str

func (this *Oraclecon) Type2str(val interface{}) string

func (*Oraclecon) Update

func (this *Oraclecon) Update(postdata map[string]interface{}) (sql.Result, error)

func (*Oraclecon) Update_redis

func (this *Oraclecon) Update_redis(tbname string)

func (*Oraclecon) Where

func (this *Oraclecon) Where(where interface{}) *Oraclecon

Jump to

Keyboard shortcuts

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