28 lines
706 B
TypeScript
28 lines
706 B
TypeScript
import {db} from './db';
|
|
import Workout from './workout';
|
|
|
|
export const getWorkout = async (name: string): Promise<Workout> => {
|
|
const select = `
|
|
SELECT * FROM workouts
|
|
WHERE workouts.name = ?
|
|
LIMIT 1
|
|
`;
|
|
const [result] = await db.executeSql(select, [name]);
|
|
return result.rows.raw()[0];
|
|
};
|
|
|
|
export const updateSteps = (name: string, steps: string): Promise<unknown> => {
|
|
const select = `
|
|
UPDATE workouts SET steps = ? WHERE name = ?
|
|
`;
|
|
return db.executeSql(select, [steps, name]);
|
|
};
|
|
|
|
export const addWorkout = (value: Workout) => {
|
|
const insert = `
|
|
INSERT INTO workouts(name, steps)
|
|
VALUES (?, ?)
|
|
`;
|
|
return db.executeSql(insert, [value.name, value.steps]);
|
|
};
|