MCP-RSS-Crawler

#!/usr/bin/env node import Database from 'better-sqlite3'; import path from 'path'; import os from 'os'; import fs from 'fs'; // Database file path - using the same path as the main application const DB_DIR = process.env.DB_DIR || path.join(os.homedir(), '.mcp-rss-crawler'); const DB_FILE = process.env.DB_FILE || path.join(DB_DIR, 'feeds.db'); // Check if the database file exists if (!fs.existsSync(DB_FILE)) { console.error(`Database file not found: ${DB_FILE}`); process.exit(1); } // Create a database connection with write access const db = new Database(DB_FILE); try { console.log(`Connected to database at ${DB_FILE}`); // Begin transaction db.transaction(() => { // Clear articles table const articlesResult = db.prepare('DELETE FROM articles').run(); console.log(`Deleted ${articlesResult.changes} records from articles table`); // Clear items table const itemsResult = db.prepare('DELETE FROM items').run(); console.log(`Deleted ${itemsResult.changes} records from items table`); // Clear categories table const categoriesResult = db.prepare('DELETE FROM categories').run(); console.log(`Deleted ${categoriesResult.changes} records from categories table`); // Reset last_updated timestamp in feeds table const feedsResult = db.prepare('UPDATE feeds SET last_updated = 0').run(); console.log(`Reset last_updated timestamp for ${feedsResult.changes} feeds`); })(); console.log('Database cleared successfully'); } catch (error) { console.error('Error clearing database:', error); process.exit(1); } finally { // Close the database connection db.close(); }