sql

Documentation

Index

• Constants
• type ReadPgStr
• type WritePgStr
• type Writer
  • func NewWriter(db *sqlx.DB) *Writer
  • func (w *Writer) Close() error
  • func (w *Writer) Write(pgStr WritePgStr, models interface{}) error

Constants

const (
	PgReadBrokenLogsStr ReadPgStr = `` /* 417-byte string literal not displayed */

	PgReadNodesStr ReadPgStr = `SELECT client_name, genesis_block, network_id, node_id, nodes_chain_id
						FROM public.nodes`

	PgReadEthUnclesStr ReadPgStr = `` /* 199-byte string literal not displayed */

	PgReadEthTransactionsStr ReadPgStr = `` /* 315-byte string literal not displayed */

	PgReadEthStorageStr ReadPgStr = `` /* 306-byte string literal not displayed */

	PgReadEthStateStr ReadPgStr = `` /* 245-byte string literal not displayed */

	PgReadEthReceiptsStr ReadPgStr = `` /* 296-byte string literal not displayed */

	PgReadEthLogsStr ReadPgStr = `` /* 360-byte string literal not displayed */

	PgReadEthHeadersStr ReadPgStr = `` /* 218-byte string literal not displayed */

	PgReadEthAccountsStr ReadPgStr = `` /* 375-byte string literal not displayed */

	PgReadAccessListElementsStr ReadPgStr = `` /* 328-byte string literal not displayed */

	PgWriteIPLDsStr WritePgStr = `INSERT INTO public.blocks (key, data) VALUES (:key, :data)
									ON CONFLICT (key) DO NOTHING`

	PgWriteEthUnclesStr WritePgStr = `` /* 169-byte string literal not displayed */

	PgWriteEthTransactionsStr WritePgStr = `` /* 228-byte string literal not displayed */

	PgWriteEthStorageStr WritePgStr = `` /* 236-byte string literal not displayed */

	PgWriteEthStateStr WritePgStr = `` /* 186-byte string literal not displayed */

	PgWriteNodesStr WritePgStr = `` /* 162-byte string literal not displayed */

	PgWriteEthReceiptsStr WritePgStr = `` /* 249-byte string literal not displayed */

	PgWriteEthLogsStr WritePgStr = `` /* 242-byte string literal not displayed */

	PgWriteEthHeadersStr WritePgStr = `` /* 403-byte string literal not displayed */

	PgWriteEthAccountsStr WritePgStr = `` /* 180-byte string literal not displayed */

	PgWriteAccessListElementsStr WritePgStr = `` /* 132-byte string literal not displayed */

)

Types

type ReadPgStr

type ReadPgStr string

ReadPgStr provides explicit typing for read postgres statements

type WritePgStr

type WritePgStr string

WritePgStr provides explicit typing for write postgres statements

type Writer

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

Writer struct for writing v3 DB public.nodes models

func NewWriter

func NewWriter(db *sqlx.DB) *Writer

NewWriter satisfies interfaces.WriterConstructor for public.nodes

func (*Writer) Close

func (w *Writer) Close() error

Close satisfies io.Closer

func (*Writer) Write

func (w *Writer) Write(pgStr WritePgStr, models interface{}) error

Write satisfies interfaces.Writer for v3 database