Skip to content

TaskView is a self-hosted project and task management platform focused on clarity, ownership, and control. TaskView is built for teams that want a transparent, self-hosted alternative to SaaS task managers.

661 B
Raw Blame
type UpdateData = { table: string; data: Record<string, any>; where: Record<string, any> };
export function updateQuery(data: UpdateData) {
    let i = 1;
    const args = [];
    let query = `UPDATE ${data.table} SET `;
    let fields: string[] = [];
    for (const name in data.data) {
        fields.push(`${name} = $${i}`);
        i++;
        args.push(data.data[name]);
    }
    query += fields.join(', ');

    fields = [];
    for (const name in data.where) {
        fields.push(`${name} = $${i}`);
        i++;
        args.push(data.where[name]);
    }
    query += ` WHERE ${fields.join(', ')}`;
    return {
        query,
        args,
    };
}