summaryrefslogtreecommitdiff
path: root/src/lib/databaseUpdates.js
blob: e27b8d8d69d53d889d508b1f70da6c49da553be9 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
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);