INNER CODE UNIT · JavaScript

setClauses

currycan/HaTickets · desktop/src/sql/index.js:113

    const setClauses = keys.map(k => `${k} = ?`).join(", ");
    const values = keys.map(k => {
        const v = params[k];
        return typeof v === "object" ? JSON.stringify(v) : v;
    });

    return await db.execute(
        `UPDATE ${tableName} SET ${setClauses}`,
        values
    );
};

export const execute = async (query, params = []) => {
    return await db.execute(query, params);
};

// 获取指定 - parameterized queries
export const select = async (query, params = []) => {

View source record →