| 76 | } |
| 77 | |
| 78 | func NewPostgresPeeksTable(db *sql.DB) (tables.Peeks, error) { |
| 79 | _, err := db.Exec(peeksSchema) |
| 80 | if err != nil { |
| 81 | return nil, err |
| 82 | } |
| 83 | s := &peekStatements{ |
| 84 | db: db, |
| 85 | } |
| 86 | if s.insertPeekStmt, err = db.Prepare(insertPeekSQL); err != nil { |
| 87 | return nil, err |
| 88 | } |
| 89 | if s.deletePeekStmt, err = db.Prepare(deletePeekSQL); err != nil { |
| 90 | return nil, err |
| 91 | } |
| 92 | if s.deletePeeksStmt, err = db.Prepare(deletePeeksSQL); err != nil { |
| 93 | return nil, err |
| 94 | } |
| 95 | if s.selectPeeksInRangeStmt, err = db.Prepare(selectPeeksInRangeSQL); err != nil { |
| 96 | return nil, err |
| 97 | } |
| 98 | if s.selectPeekingDevicesStmt, err = db.Prepare(selectPeekingDevicesSQL); err != nil { |
| 99 | return nil, err |
| 100 | } |
| 101 | if s.selectMaxPeekIDStmt, err = db.Prepare(selectMaxPeekIDSQL); err != nil { |
| 102 | return nil, err |
| 103 | } |
| 104 | return s, nil |
| 105 | } |
| 106 | |
| 107 | func (s *peekStatements) InsertPeek( |
| 108 | ctx context.Context, txn *sql.Tx, roomID, userID, deviceID string, |