| 73 | } |
| 74 | |
| 75 | func NewPostgresAccountDataTable(db *sql.DB) (tables.AccountData, error) { |
| 76 | s := &accountDataStatements{} |
| 77 | _, err := db.Exec(accountDataSchema) |
| 78 | if err != nil { |
| 79 | return nil, err |
| 80 | } |
| 81 | if s.insertAccountDataStmt, err = db.Prepare(insertAccountDataSQL); err != nil { |
| 82 | return nil, err |
| 83 | } |
| 84 | if s.selectAccountDataInRangeStmt, err = db.Prepare(selectAccountDataInRangeSQL); err != nil { |
| 85 | return nil, err |
| 86 | } |
| 87 | if s.selectMaxAccountDataIDStmt, err = db.Prepare(selectMaxAccountDataIDSQL); err != nil { |
| 88 | return nil, err |
| 89 | } |
| 90 | return s, nil |
| 91 | } |
| 92 | |
| 93 | func (s *accountDataStatements) InsertAccountData( |
| 94 | ctx context.Context, txn *sql.Tx, |