handlers

README

Pre-Configured Handlers

Usage

See an example.

List of Handlers

Bank

• handlers.RakutenBankStatement: Statements of Rakuten Bank (楽天銀行 入出金明細)
• handlers.SBISumishinNetBankStatement: Statements of Sumishin SBI Net Bank (住信SBIネット銀行 入出金明細)
• handlers.SMBCStatement: Statements of SMBC (三井住友銀行 入出金明細)
• handlers.SonyBankStatement: Statements of Sony Bank (ソニー銀行 入出金明細)

Credit Card

• handlers.RakutenCardStatement: Statements of Rakuten Card (楽天カード)
• handlers.SMBCCardStatement: Statements of SMBC Card (三井住友カード)

Securities

• handlers.SBISecuritiesGlobalBankingStatement: Receive and pay of SBI Securities Global (SBI証券 外国株 入出金明細)
• handlers.SBISecuritiesGlobalExecutionHistory: Execution hisotry of SBI Securities Global (SBI証券 外国株 約定履歴)

Documentation

Overview

Package handlers includes pre-configured handlers for bqloader.

See an example. https://github.com/nownabe/go-bqloader/blob/main/examples/pre_configured_handlers/bqload.go

Index

• func AMEXStatement(name, pattern string, table Table, notifier bqloader.Notifier) *bqloader.Handler
• func AMEXStatementCSV(name, pattern string, table Table, notifier bqloader.Notifier) *bqloader.Handler
• func CleanNumber(n string) string
• func MustAddHandlers(ctx context.Context, loader bqloader.BQLoader, handlers ...*bqloader.Handler)
• func PartialCSVParser(skipHeadRows uint, skipTailRows uint, sep string) bqloader.Parser
• func RakutenBankStatement(name, pattern string, table Table, notifier bqloader.Notifier) *bqloader.Handler
• func RakutenCardStatement(name, pattern string, table Table, notifier bqloader.Notifier) *bqloader.Handler
• func SBISecuritiesGlobalBankingStatement(name, pattern string, table Table, notifier bqloader.Notifier) *bqloader.Handler
• func SBISecuritiesGlobalExecutionHistory(name, pattern string, table Table, notifier bqloader.Notifier) *bqloader.Handler
• func SBISumishinNetBankStatement(name, pattern string, table Table, notifier bqloader.Notifier) *bqloader.Handler
• func SMBCCardStatement(name, pattern string, table Table, notifier bqloader.Notifier) *bqloader.Handler
• func SMBCStatement(name, pattern string, t Table, n bqloader.Notifier) *bqloader.Handler
• func SonyBankStatement(name, pattern string, table Table, notifier bqloader.Notifier) *bqloader.Handler
• func TableGenerator(project, dataset string) func(string) Table
• type Table

Functions

func AMEXStatement

func AMEXStatement(name, pattern string, table Table, notifier bqloader.Notifier) *bqloader.Handler

AMEXStatement build a *bqloader.Handler for statements of AMEX (American Express). To add column of payment month, keep the file name as the payment month like '2022-07.xls'.

func AMEXStatementCSV

func AMEXStatementCSV(name, pattern string, table Table, notifier bqloader.Notifier) *bqloader.Handler

func CleanNumber

func CleanNumber(n string) string

CleanNumber cleans numbers includes commas and currency marks.

func MustAddHandlers

func MustAddHandlers(ctx context.Context, loader bqloader.BQLoader, handlers ...*bqloader.Handler)

MustAddHandlers adds handlers into BQLoader.

func PartialCSVParser

func PartialCSVParser(skipHeadRows uint, skipTailRows uint, sep string) bqloader.Parser

PartialCSVParser builds a parser for CSV with invalid head and tail lines.

func RakutenBankStatement

func RakutenBankStatement(name, pattern string, table Table, notifier bqloader.Notifier) *bqloader.Handler

RakutenBankStatement build a handler for statements for Rakuten Bank (楽天銀行 入出金明細).

func RakutenCardStatement

func RakutenCardStatement(name, pattern string, table Table, notifier bqloader.Notifier) *bqloader.Handler

RakutenCardStatement build a handler for statements of Rakuten Card (楽天カード 明細). To add column of payment month, keep the file name when you downloaded it.

func SBISecuritiesGlobalBankingStatement

func SBISecuritiesGlobalBankingStatement(name, pattern string, table Table, notifier bqloader.Notifier) *bqloader.Handler

SBISecuritiesGlobalBankingStatement build a handler for banking statement of SBI Securities Global (SBI証券 外国株式 入出金明細).

func SBISecuritiesGlobalExecutionHistory

func SBISecuritiesGlobalExecutionHistory(name, pattern string, table Table, notifier bqloader.Notifier) *bqloader.Handler

SBISecuritiesGlobalExecutionHistory build a handler for execution history of SBI Securities Global (SBI証券 外国株式 約定履歴).

func SBISumishinNetBankStatement

func SBISumishinNetBankStatement(name, pattern string, table Table, notifier bqloader.Notifier) *bqloader.Handler

SBISumishinNetBankStatement build a handler for statements of SBI bank (住信SBIネット銀行).

func SMBCCardStatement

func SMBCCardStatement(name, pattern string, table Table, notifier bqloader.Notifier) *bqloader.Handler

SMBCCardStatement build a *bqloader.Handler for statements of SMBC card (三井住友VISAカード). To add column of payment month, keep the file name when you downloaded it.

func SMBCStatement

func SMBCStatement(name, pattern string, t Table, n bqloader.Notifier) *bqloader.Handler

SMBCStatement builds a handler for statements for SMBC (三井住友銀行 入出金明細).

func SonyBankStatement

func SonyBankStatement(name, pattern string, table Table, notifier bqloader.Notifier) *bqloader.Handler

SonyBankStatement build a handler for statements of Sony Bank (ソニー銀行).

func TableGenerator

func TableGenerator(project, dataset string) func(string) Table

TableGenerator returns Table generator func.

Types

type Table

type Table struct {
	Project string
	Dataset string
	Table   string
}

Table identifies BigQuery table.