sqldb

Documentation

Index

• type SQLDB
  • func NewSQLDB(connection types.SQLConnection) (*SQLDB, error)
  • func (db *SQLDB) CleanTables(chainID, burrowVersion string) error
  • func (db *SQLDB) Close()
  • func (db *SQLDB) GetBlock(height uint64) (types.EventData, error)
  • func (db *SQLDB) GetLastBlockHeight() (uint64, error)
  • func (db *SQLDB) Ping() error
  • func (db *SQLDB) RestoreDB(time time.Time, prefix string) error
  • func (db *SQLDB) SetBlock(eventTables types.EventTables, eventData types.EventData) error
  • func (db *SQLDB) SynchronizeDB(eventTables types.EventTables) error

Types

type SQLDB

type SQLDB struct {
	DB        *sql.DB
	DBAdapter adapters.DBAdapter
	Schema    string
	Log       *logger.Logger
}

SQLDB implements the access to a sql database

func NewSQLDB

func NewSQLDB(connection types.SQLConnection) (*SQLDB, error)

NewSQLDB delegates work to a specific database adapter implementation, opens database connection and create log tables

func (*SQLDB) CleanTables

func (db *SQLDB) CleanTables(chainID, burrowVersion string) error

CleanTables, drop tables if stored chainID is different from the given one & store new chainID if the chainID is the same, do nothing

func (*SQLDB) Close

func (db *SQLDB) Close()

Close database connection

func (*SQLDB) GetBlock

func (db *SQLDB) GetBlock(height uint64) (types.EventData, error)

GetBlock returns all tables structures and row data for given block

func (*SQLDB) GetLastBlockHeight

func (db *SQLDB) GetLastBlockHeight() (uint64, error)

GetLastBlockID returns last inserted blockId from log table

func (*SQLDB) Ping

func (db *SQLDB) Ping() error

Ping database

func (*SQLDB) RestoreDB

func (db *SQLDB) RestoreDB(time time.Time, prefix string) error

RestoreDB restores the DB to a given moment in time

func (*SQLDB) SetBlock

func (db *SQLDB) SetBlock(eventTables types.EventTables, eventData types.EventData) error

SetBlock inserts or updates multiple rows and stores log info in SQL tables

func (*SQLDB) SynchronizeDB

func (db *SQLDB) SynchronizeDB(eventTables types.EventTables) error

SynchronizeDB synchronize db tables structures from given tables specifications