"use strict";
var __awaiter = (this && this.__awaiter) || function (thisArg, _arguments, P, generator) {
    function adopt(value) { return value instanceof P ? value : new P(function (resolve) { resolve(value); }); }
    return new (P || (P = Promise))(function (resolve, reject) {
        function fulfilled(value) { try { step(generator.next(value)); } catch (e) { reject(e); } }
        function rejected(value) { try { step(generator["throw"](value)); } catch (e) { reject(e); } }
        function step(result) { result.done ? resolve(result.value) : adopt(result.value).then(fulfilled, rejected); }
        step((generator = generator.apply(thisArg, _arguments || [])).next());
    });
};
var __importDefault = (this && this.__importDefault) || function (mod) {
    return (mod && mod.__esModule) ? mod : { "default": mod };
};
Object.defineProperty(exports, "__esModule", { value: true });
exports.default = DbUpdate;
const _1 = __importDefault(require("."));
const lodash_1 = __importDefault(require("lodash"));
const sql_generator_1 = __importDefault(require("../../utils/sql-generator"));
function DbUpdate(_a) {
    return __awaiter(this, arguments, void 0, function* ({ table, data, query, targetId, }) {
        var _b;
        try {
            let finalQuery = query || {};
            if (targetId) {
                finalQuery = lodash_1.default.merge(finalQuery, {
                    query: {
                        id: {
                            value: String(targetId),
                        },
                    },
                });
            }
            const sqlQueryObj = (0, sql_generator_1.default)({
                tableName: table,
                genObject: finalQuery,
            });
            let values = [];
            const whereClause = (_b = sqlQueryObj.string.match(/WHERE .*/)) === null || _b === void 0 ? void 0 : _b[0];
            if (whereClause) {
                let sql = `UPDATE ${table} SET`;
                const finalData = Object.assign(Object.assign({}, data), { updated_at: Date.now() });
                const keys = Object.keys(finalData);
                for (let i = 0; i < keys.length; i++) {
                    const key = keys[i];
                    if (!key)
                        continue;
                    const isLast = i == keys.length - 1;
                    sql += ` ${key}=?`;
                    values.push(String(finalData[key]));
                    if (!isLast) {
                        sql += `,`;
                    }
                }
                sql += ` ${whereClause}`;
                values = [...values, ...sqlQueryObj.values];
                const res = _1.default.prepare(sql).run(...values);
                return {
                    success: Boolean(res.changes),
                    postInsertReturn: {
                        affectedRows: res.changes,
                        insertId: Number(res.lastInsertRowid),
                    },
                    debug: {
                        sql,
                        values,
                    },
                };
            }
            else {
                return {
                    success: false,
                    msg: `No WHERE clause`,
                };
            }
        }
        catch (error) {
            return {
                success: false,
                error: error.message,
            };
        }
    });
}