import sqlite from "better-sqlite3";

// Path to your SQLite database file
const dbPath = "../../mydatabase.db";

// Open the SQLite database connection
const db = sqlite(dbPath);

const userId = "p1pczcq94xsbdcj";

// Function to print all entries from the user table
function printAllUsers() {
  //check for empty database
  
  const users = db.prepare("SELECT * FROM user").all();
  console.log("All Users:");
  console.table(users);
}

// Disable foreign key constraints
db.pragma("foreign_keys = OFF");

// Perform the delete operation
const result = db.prepare("DELETE FROM user WHERE id = ?").run(userId);

// Re-enable foreign key constraints
db.pragma("foreign_keys = ON");

// Function to delete a user by ID
function deleteUserById(userId) {
  const result = db.prepare("DELETE FROM user WHERE id = ?").run(userId);
  if (result.changes > 0) {
    console.log(`User with ID ${userId} deleted successfully.`);
  } else {
    console.log(`No user found with ID ${userId}.`);
  }
}

// Example usage:
printAllUsers();
deleteUserById(userId);