24 lines
788 B
TypeScript
24 lines
788 B
TypeScript
import {db} from './db';
|
|
import Settings from './settings';
|
|
|
|
export const getSettings = async (): Promise<Settings> => {
|
|
const [result] = await db.executeSql(`SELECT * FROM settings LIMIT 1`);
|
|
return result.rows.item(0);
|
|
};
|
|
|
|
export const updateSettings = async (value: Settings) => {
|
|
console.log(`${updateSettings.name}`, {value});
|
|
const keys = Object.keys(value) as (keyof Settings)[];
|
|
const sets = keys.map(key => `${key}=?`).join(',');
|
|
const update = `UPDATE settings SET ${sets}`;
|
|
const values = keys.map(key => value[key]);
|
|
return db.executeSql(update, values);
|
|
};
|
|
|
|
export const getNext = async (): Promise<string | undefined> => {
|
|
const [result] = await db.executeSql(
|
|
`SELECT nextAlarm FROM settings LIMIT 1`,
|
|
);
|
|
return result.rows.item(0)?.nextAlarm;
|
|
};
|