oracle

Documentation

Index

• func New(id common.RegDbID, url string) (common.Database, error)
• func NewInstance(id common.RegDbID, reference *common.Reference, password string) (common.Database, error)
• type Oracle
  • func (oracle *Oracle) AdaptTable(string, any) error
  • func (oracle *Oracle) Batch(batch string) error
  • func (oracle *Oracle) BatchSelect(batch string) ([][]interface{}, error)
  • func (oracle *Oracle) BatchSelectFct(search *common.Query, fct common.ResultFunction) error
  • func (oracle *Oracle) BeginTransaction() error
  • func (oracle *Oracle) ByteArrayAvailable() bool
  • func (oracle *Oracle) Clone() common.Database
  • func (oracle *Oracle) Close()
  • func (oracle *Oracle) Commit() error
  • func (oracle *Oracle) CreateTable(name string, columns any) error
  • func (oracle *Oracle) Delete(name string, remove *common.Entries) (int64, error)
  • func (oracle *Oracle) DeleteTable(name string) error
  • func (oracle *Oracle) EndTransaction(commit bool) (err error)
  • func (oracle *Oracle) FreeHandler()
  • func (oracle *Oracle) GetTableColumn(tableName string) ([]string, error)
  • func (oracle *Oracle) ID() common.RegDbID
  • func (oracle *Oracle) IndexNeeded() bool
  • func (oracle *Oracle) Insert(name string, insert *common.Entries) ([][]any, error)
  • func (oracle *Oracle) Maps() ([]string, error)
  • func (oracle *Oracle) Open() (dbOpen any, err error)
  • func (oracle *Oracle) Ping() error
  • func (oracle *Oracle) Query(search *common.Query, f common.ResultFunction) (*common.Result, error)
  • func (oracle *Oracle) Reference() (string, string)
  • func (oracle *Oracle) Rollback() error
  • func (oracle *Oracle) SetCredentials(user, password string) error
  • func (oracle *Oracle) StartTransaction() (*sql.Tx, context.Context, error)
  • func (oracle *Oracle) Stream(search *common.Query, sf common.StreamFunction) error
  • func (oracle *Oracle) URL() string
  • func (oracle *Oracle) Update(name string, insert *common.Entries) ([][]any, int64, error)

Functions

func New

func New(id common.RegDbID, url string) (common.Database, error)

New create new oracle reference instance

func NewInstance

func NewInstance(id common.RegDbID, reference *common.Reference, password string) (common.Database, error)

NewInstance create new oracle reference instance

Types

type Oracle

type Oracle struct {
	common.CommonDatabase

	Protocol string

	Host        string
	Port        int
	ServiceName string
	// contains filtered or unexported fields
}

Oracle instance for MySQL

func (*Oracle) AdaptTable

func (oracle *Oracle) AdaptTable(string, any) error

AdaptTable adapt a new table

func (*Oracle) Batch

func (oracle *Oracle) Batch(batch string) error

Batch batch SQL query in table

func (*Oracle) BatchSelect

func (oracle *Oracle) BatchSelect(batch string) ([][]interface{}, error)

BatchSelect batch SQL query in table with values returned

func (*Oracle) BatchSelectFct

func (oracle *Oracle) BatchSelectFct(search *common.Query, fct common.ResultFunction) error

BatchSelectFct batch SQL query in table with fct called

func (*Oracle) BeginTransaction

func (oracle *Oracle) BeginTransaction() error

StartTransaction start transaction the database connection

func (*Oracle) ByteArrayAvailable

func (oracle *Oracle) ByteArrayAvailable() bool

ByteArrayAvailable byte array available in SQL database

func (*Oracle) Clone

func (oracle *Oracle) Clone() common.Database

func (*Oracle) Close

func (oracle *Oracle) Close()

Close close the database connection

func (*Oracle) Commit

func (oracle *Oracle) Commit() error

Commit commit the transaction

func (*Oracle) CreateTable

func (oracle *Oracle) CreateTable(name string, columns any) error

CreateTable create a new table

func (*Oracle) Delete

func (oracle *Oracle) Delete(name string, remove *common.Entries) (int64, error)

Delete Delete database records

func (*Oracle) DeleteTable

func (oracle *Oracle) DeleteTable(name string) error

DeleteTable delete a table

func (*Oracle) EndTransaction

func (oracle *Oracle) EndTransaction(commit bool) (err error)

func (*Oracle) FreeHandler

func (oracle *Oracle) FreeHandler()

FreeHandler don't use the driver anymore

func (*Oracle) GetTableColumn

func (oracle *Oracle) GetTableColumn(tableName string) ([]string, error)

GetTableColumn get table columne names

func (*Oracle) ID

func (oracle *Oracle) ID() common.RegDbID

ID current id used

func (*Oracle) IndexNeeded

func (oracle *Oracle) IndexNeeded() bool

IndexNeeded index needed for the SELECT statement value reference

func (*Oracle) Insert

func (oracle *Oracle) Insert(name string, insert *common.Entries) ([][]any, error)

Insert insert record into table

func (*Oracle) Maps

func (oracle *Oracle) Maps() ([]string, error)

Maps database maps, tables or views

func (*Oracle) Open

func (oracle *Oracle) Open() (dbOpen any, err error)

Open open the database connection

func (*Oracle) Ping

func (oracle *Oracle) Ping() error

Ping create short test database connection

func (*Oracle) Query

func (oracle *Oracle) Query(search *common.Query, f common.ResultFunction) (*common.Result, error)

Query query database records with search or SELECT

func (*Oracle) Reference

func (oracle *Oracle) Reference() (string, string)

Reference reference to oracle URL

func (*Oracle) Rollback

func (oracle *Oracle) Rollback() error

Rollback rollback the transaction

func (*Oracle) SetCredentials

func (oracle *Oracle) SetCredentials(user, password string) error

SetCredentials set credentials to connect to database

func (*Oracle) StartTransaction

func (oracle *Oracle) StartTransaction() (*sql.Tx, context.Context, error)

StartTransaction start transaction

func (*Oracle) Stream

func (oracle *Oracle) Stream(search *common.Query, sf common.StreamFunction) error

func (*Oracle) URL

func (oracle *Oracle) URL() string

URL current URL used

func (*Oracle) Update

func (oracle *Oracle) Update(name string, insert *common.Entries) ([][]any, int64, error)

Update update record in table