src/store.ts


1
2
3
4
5
6
7
8
9
10

import { ProductInfo } from "./gather";

export async function storePriceRecord(db: D1Database, product: ProductInfo): Promise<boolean> {
    const query = 'INSERT INTO Prices (CompanyName, ProductName, Price, AccessDate, Picture) VALUES (?1, ?2, ?3, ?4, ?5)'
    const { results, success } = await db.prepare(query)
        .bind(product.companyName, product.productName, product.price, product.accessDate, product.picture)
        .run();
    console.log(results, success)
    return success
}