let { messages2 } = await import("https://esm.town/v/stevekrouse/messages2");
export const tell2 = async (msg) => {
const { DB } = await import("https://deno.land/x/sqlite/mod.ts");
const db = new DB();
if (messages2 !== undefined) {
db.deserialize(messages2);
}
db.execute(`
CREATE TABLE IF NOT EXISTS messages (
id INTEGER PRIMARY KEY AUTOINCREMENT,
message TEXT,
time INTEGER
);
`);
db.query("INSERT INTO messages (message, time) VALUES (?, ?)", [
msg,
Date.now(),
]);
const data = db.serialize();
messages2 = Array.from(data);
const allMessages = db.query("SELECT * from messages;");
console.log(db.query("SELECT * from messages;"));
console.log("messages data size:", data.length);
db.close();
return `thanks! ${allMessages.length} messages so far!`;
};