+
+ ticketRedeemed(dbCtx, redeemedData) {
+ const _scope = _fileScope('ticketRedeemed');
+ this.logger.debug(_scope, 'called', { ...redeemedData });
+
+ try {
+ const result = this.statement.ticketRedeemed.run(redeemedData);
+ if (result.changes != 1) {
+ throw new DBErrors.UnexpectedResult('did not store redeemed ticket');
+ }
+ } catch (e) {
+ this.logger.error(_scope, 'failed', { error: e });
+ throw e;
+ }
+ }
+
+
+ ticketTokenPublished(dbCtx, redeemedData) {
+ const _scope = _fileScope('ticketRedeemed');
+ this.logger.debug(_scope, 'called', { ...redeemedData });
+
+ const almanacEvent = Enum.AlmanacEntry.TicketPublished;
+ try {
+ const result = this.statement.ticketTokenPublished.run(redeemedData);
+ if (result.changes != 1) {
+ throw new DBErrors.UnexpectedResult('did not store redeemed ticket');
+ }
+ const epoch = common.dateToEpoch();
+ const almanacResult = this.statement.almanacUpsert.run({ event: almanacEvent, epoch });
+ if (almanacResult.changes != 1) {
+ throw new DBErrors.UnexpectedResult('did not update almanac');
+ }
+
+ } catch (e) {
+ this.logger.error(_scope, 'failed', { error: e });
+ throw e;
+ }
+ }
+
+ static _redeemedTicketToNative(redeemedTicket) {
+ redeemedTicket.created = new Date(Number(redeemedTicket.created) * 1000);
+ if (redeemedTicket.published) {
+ redeemedTicket.published = new Date(Number(redeemedTicket.published) * 1000);
+ }
+ return redeemedTicket;
+ }
+
+ ticketTokenGetUnpublished() {
+ const _scope = _fileScope('ticketTokenGetUnpublished');
+ this.logger.debug(_scope, 'called');
+
+ try {
+ const unpublished = this.statement.ticketTokenGetUnpublished.all();
+ return unpublished.map((x) => DatabaseSQLite._redeemedTicketToNative(x));
+ } catch (e) {
+ this.logger.error(_scope, 'failed', { error: e });
+ throw e;
+ }
+ }
+