Page MenuHomePhorge
Files F32527891

D8555.1767145099.diff
No OneTemporary
Actions

Size
3 KB
Referenced Files
None
Subscribers
None

D8555.1767145099.diff
View Options

diff --git a/web/database/queries/metadata-queries.test.js b/web/database/queries/metadata-queries.test.js
--- a/web/database/queries/metadata-queries.test.js
+++ b/web/database/queries/metadata-queries.test.js
@@ -1,70 +1,58 @@
// @flow
-import initSqlJs from 'sql.js';
-
-import { setupSQLiteDB } from './db-queries.js';
-import { clearMetadata, getMetadata, setMetadata } from './metadata-queries.js';
+import { getDatabaseModule } from '../db-module.js';
const TEST_USER_ID_KEY = 'current_user_id';
const TEST_USER_ID_VAL = 'qwerty1234';
describe('Metadata queries', () => {
- let db;
+ let queryExecutor;
beforeAll(async () => {
- const SQL = await initSqlJs();
- db = new SQL.Database();
+ const module = getDatabaseModule();
+ queryExecutor = new module.SQLiteQueryExecutor('test.sqlite');
});
beforeEach(() => {
- setupSQLiteDB(db);
- const query = `
- INSERT INTO metadata (name, data)
- VALUES ($name, $val)
- `;
- const values = {
- $name: TEST_USER_ID_KEY,
- $val: TEST_USER_ID_VAL,
- };
- db.exec(query, values);
+ queryExecutor.setMetadata(TEST_USER_ID_KEY, TEST_USER_ID_VAL);
});
afterEach(() => {
- db.exec(`DELETE FROM metadata`);
+ queryExecutor.clearMetadata(TEST_USER_ID_KEY);
});
it('should return the data of an existing name', () => {
- expect(getMetadata(db, TEST_USER_ID_KEY)).toBe(TEST_USER_ID_VAL);
+ expect(queryExecutor.getMetadata(TEST_USER_ID_KEY)).toBe(TEST_USER_ID_VAL);
});
it('should return undefined for a non-existing name', () => {
const nonExistingName = 'non_existing_name';
- expect(getMetadata(db, nonExistingName)).toBeUndefined();
+ expect(queryExecutor.getMetadata(nonExistingName)).toBe('');
});
it('should set the data of an existing name', () => {
const newUserID = 'newID123';
- setMetadata(db, TEST_USER_ID_KEY, newUserID);
- expect(getMetadata(db, TEST_USER_ID_KEY)).toBe(newUserID);
+ queryExecutor.setMetadata(TEST_USER_ID_KEY, newUserID);
+ expect(queryExecutor.getMetadata(TEST_USER_ID_KEY)).toBe(newUserID);
});
it('should set the data of a non-existing name', () => {
const newEntry = 'testEntry';
const newData = 'testData';
- setMetadata(db, newEntry, newData);
- expect(getMetadata(db, newEntry)).toBe(newData);
- expect(getMetadata(db, TEST_USER_ID_KEY)).toBe(TEST_USER_ID_VAL);
+ queryExecutor.setMetadata(newEntry, newData);
+ expect(queryExecutor.getMetadata(newEntry)).toBe(newData);
+ expect(queryExecutor.getMetadata(TEST_USER_ID_KEY)).toBe(TEST_USER_ID_VAL);
});
it('should clear an existing entry', () => {
- clearMetadata(db, TEST_USER_ID_KEY);
- expect(getMetadata(db, TEST_USER_ID_KEY)).toBeUndefined();
+ queryExecutor.clearMetadata(TEST_USER_ID_KEY);
+ expect(queryExecutor.getMetadata(TEST_USER_ID_KEY)).toBe('');
});
it('should do nothing when clearing a non-existing entry', () => {
const nonExistingName = 'non_existing_name';
- clearMetadata(db, nonExistingName);
- expect(getMetadata(db, nonExistingName)).toBeUndefined();
- expect(getMetadata(db, TEST_USER_ID_KEY)).toBe(TEST_USER_ID_VAL);
+ queryExecutor.clearMetadata(nonExistingName);
+ expect(queryExecutor.getMetadata(nonExistingName)).toBe('');
+ expect(queryExecutor.getMetadata(TEST_USER_ID_KEY)).toBe(TEST_USER_ID_VAL);
});
});

File Metadata

Mime Type
text/plain
Expires
Wed, Dec 31, 1:38 AM (12 h, 34 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
5871257
Default Alt Text
D8555.1767145099.diff (3 KB)

Event Timeline