'use strict';
const common = require('../../common');
+const Enum = require('../../enum');
const Database = require('../abstract');
const DBErrors = require('../errors');
const { unappliedSchemaVersions } = require('../schema-version-helper');
},
max: {
major: 1,
- minor: 0,
+ minor: 2,
patch: 0,
},
};
_purgeTables(really) {
if (really) {
[
+ 'almanac',
'authentication',
'profile',
+ 'redeemed_ticket',
+ 'resource',
'token',
- ].map((table) => {
+ ].forEach((table) => {
const result = this.db.prepare(`DELETE FROM ${table}`).run();
this.logger.debug(_fileScope('_purgeTables'), 'success', { table, result });
});
};
}
+
+ static _almanacErrorThrow() {
+ throw new DBErrors.UnexpectedResult('did not update almanac');
+ }
+
+
almanacGetAll(dbCtx) { // eslint-disable-line no-unused-vars
const _scope = _fileScope('almanacGetAll');
this.logger.debug(_scope, 'called');
}
+ almanacUpsert(dbCtx, event, date) {
+ const _scope = _fileScope('almanacUpsert');
+ this.logger.debug(_scope, 'called', { event, date });
+
+ try {
+ const epoch = common.dateToEpoch(date);
+ const result = this.statement.almanacUpsert.run({ event, epoch });
+ if (result.changes != 1) {
+ this.constructor._almanacErrorThrow();
+ }
+ } catch (e) {
+ this.logger.error(_scope, 'failed', { error: e, event, date });
+ throw e;
+ }
+ }
+
+
static _authenticationToNative(authentication) {
if (authentication) {
authentication.created = new Date(Number(authentication.created) * 1000);
}
- authenticationUpsert(dbCtx, identifier, credential) {
+ authenticationUpsert(dbCtx, identifier, credential, otpKey) {
const _scope = _fileScope('authenticationUpsert');
const scrubbedCredential = '*'.repeat((credential || '').length);
- this.logger.debug(_scope, 'called', { identifier, scrubbedCredential });
+ const scrubbedOTPKey = '*'.repeat((otpKey || '').length);
+ this.logger.debug(_scope, 'called', { identifier, scrubbedCredential, scrubbedOTPKey });
- let result;
try {
- result = this.statement.authenticationUpsert.run({ identifier, credential });
+ const result = this.statement.authenticationUpsert.run({ identifier, credential, otpKey });
if (result.changes != 1) {
throw new DBErrors.UnexpectedResult('did not upsert authentication');
}
+ } catch (e) {
+ this.logger.error(_scope, 'failed', { error: e, identifier, scrubbedCredential, scrubbedOTPKey });
+ throw e;
+ }
+ }
+
+
+ authenticationUpdateCredential(dbCtx, identifier, credential) {
+ const _scope = _fileScope('authenticationUpdateCredential');
+ const scrubbedCredential = '*'.repeat((credential || '').length);
+ this.logger.debug(_scope, 'called', { identifier, scrubbedCredential });
+
+ try {
+ const result = this.statement.authenticationUpdateCredential.run({ identifier, credential });
+ if (result.changes != 1) {
+ throw new DBErrors.UnexpectedResult('did not update credential');
+ }
} catch (e) {
this.logger.error(_scope, 'failed', { error: e, identifier, scrubbedCredential });
throw e;
}
+ authenticationUpdateOTPKey(dbCtx, identifier, otpKey) {
+ const _scope = _fileScope('authenticationUpdateOTPKey');
+ const scrubbedOTPKey = '*'.repeat((otpKey || '').length);
+ this.logger.debug(_scope, 'called', { identifier, scrubbedOTPKey });
+
+ try {
+ const result = this.statement.authenticationUpdateOtpKey.run({ identifier, otpKey });
+ if (result.changes != 1) {
+ throw new DBErrors.UnexpectedResult('did not update otpKey');
+ }
+ } catch (e) {
+ this.logger.error(_scope, 'failed', { error: e, identifier, scrubbedOTPKey });
+ throw e;
+ }
+ }
+
+
profileIdentifierInsert(dbCtx, profile, identifier) {
const _scope = _fileScope('profileIdentifierInsert');
this.logger.debug(_scope, 'called', { profile, identifier });
const _scope = _fileScope('scopeCleanup');
this.logger.debug(_scope, 'called', { atLeastMsSinceLast });
- const almanacEvent = 'scopeCleanup';
+ const almanacEvent = Enum.AlmanacEntry.ScopeCleanup;
try {
return this.db.transaction(() => {
// Update the last cleanup time
const result = this.statement.almanacUpsert.run({ event: almanacEvent, epoch: nowEpoch });
if (result.changes != 1) {
- throw new DBErrors.UnexpectedResult('did not update almanac');
+ this.constructor._almanacErrorThrow();
}
this.logger.debug(_scope, 'finished', { scopesRemoved, atLeastMsSinceLast });
const _scope = _fileScope('tokenCleanup');
this.logger.debug(_scope, 'called', { codeLifespanSeconds, atLeastMsSinceLast });
- const almanacEvent = 'tokenCleanup';
+ const almanacEvent = Enum.AlmanacEntry.TokenCleanup;
try {
return this.db.transaction(() => {
// Update the last cleanup time
const result = this.statement.almanacUpsert.run({ event: almanacEvent, epoch: nowEpoch });
if (result.changes != 1) {
- throw new DBErrors.UnexpectedResult('did not update almanac');
+ this.constructor._almanacErrorThrow();
}
this.logger.debug(_scope, 'finished', { tokensRemoved, codeLifespanSeconds, atLeastMsSinceLast });
}
}
+
+ 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) {
+ this.constructor._almanacErrorThrow();
+ }
+
+ } 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;
+ }
+ }
+
}
-module.exports = DatabaseSQLite;
\ No newline at end of file
+module.exports = DatabaseSQLite;