| 76 | } |
| 77 | |
| 78 | func NewPostgresQueuePDUsTable(db *sql.DB) (s *queuePDUsStatements, err error) { |
| 79 | s = &queuePDUsStatements{ |
| 80 | db: db, |
| 81 | } |
| 82 | _, err = s.db.Exec(queuePDUsSchema) |
| 83 | if err != nil { |
| 84 | return |
| 85 | } |
| 86 | if s.insertQueuePDUStmt, err = s.db.Prepare(insertQueuePDUSQL); err != nil { |
| 87 | return |
| 88 | } |
| 89 | if s.deleteQueuePDUsStmt, err = s.db.Prepare(deleteQueuePDUSQL); err != nil { |
| 90 | return |
| 91 | } |
| 92 | if s.selectQueuePDUsStmt, err = s.db.Prepare(selectQueuePDUsSQL); err != nil { |
| 93 | return |
| 94 | } |
| 95 | if s.selectQueuePDUReferenceJSONCountStmt, err = s.db.Prepare(selectQueuePDUReferenceJSONCountSQL); err != nil { |
| 96 | return |
| 97 | } |
| 98 | if s.selectQueuePDUsCountStmt, err = s.db.Prepare(selectQueuePDUsCountSQL); err != nil { |
| 99 | return |
| 100 | } |
| 101 | if s.selectQueuePDUServerNamesStmt, err = s.db.Prepare(selectQueuePDUServerNamesSQL); err != nil { |
| 102 | return |
| 103 | } |
| 104 | return |
| 105 | } |
| 106 | |
| 107 | func (s *queuePDUsStatements) InsertQueuePDU( |
| 108 | ctx context.Context, |