import mergeOptions from "../helpers/mergeOptions.js"
import queryDB from "../helpers/queryDB.js"
import SimpleWebTable from "../class/SimpleWebTable.js"

export default async function getTop(
    simpleWebTable: SimpleWebTable,
    count: number,
    options: {
        condition?: string
    } = {}
) {
    const rows = await queryDB(
        simpleWebTable,
        `SELECT * FROM ${simpleWebTable.name}${
            options.condition ? ` WHERE ${options.condition}` : ""
        } LIMIT ${count}`,
        mergeOptions(simpleWebTable, {
            table: simpleWebTable.name,
            returnDataFrom: "query",
            method: "getTop()",
            parameters: { count, options },
        })
    )

    if (!rows) {
        throw new Error("no rows")
    }

    simpleWebTable.debug && console.log("Top rows:")
    simpleWebTable.debug && console.table(rows)

    return rows
}