FinceptTerminal is a modern finance application offering advanced market analytics, investment research, and economic data tools, designed for interactive exploration and data-driven decision-making in a user-friendly environment.
C++ ai-agentsalgorithmic-tradingbloomberg-terminalcppfinancefinancial-marketsfintechgood-first-issueinvestmentinvestment-researchmachine-learningopensourcepythonqtquantitative-financestock-markettrading
// v031_rss_feeds — User overlay table for RSS feed sources.
//
// Built-in feeds remain hardcoded in NewsService_Feeds.cpp. This table stores
// user overrides:
// is_builtin = 1 → patch over a default feed (same id as default); may
// override name/url/category/region/source/tier and/or
// set enabled = 0 to hide the default.
// is_builtin = 0 → fully user-added feed (id prefixed "usr-<uuid>").
//
// Effective feed list is computed at runtime in NewsService::effective_feeds().
#include "storage/sqlite/migrations/MigrationRunner.h"
#include <QSqlError>
#include <QSqlQuery>
namespace fincept {
namespace {
static Result<void> sql(QSqlDatabase& db, const char* stmt) {
QSqlQuery q(db);
if (!q.exec(stmt))
return Result<void>::err(q.lastError().text().toStdString());
return Result<void>::ok();
}
Result<void> apply_v031(QSqlDatabase& db) {
auto r = sql(db, "CREATE TABLE IF NOT EXISTS rss_feeds ("
" id TEXT PRIMARY KEY,"
" name TEXT NOT NULL,"
" url TEXT NOT NULL,"
" category TEXT NOT NULL DEFAULT 'MARKETS',"
" region TEXT NOT NULL DEFAULT 'GLOBAL',"
" source TEXT NOT NULL,"
" tier INTEGER NOT NULL DEFAULT 3,"
" is_builtin INTEGER NOT NULL DEFAULT 0,"
" enabled INTEGER NOT NULL DEFAULT 1,"
" created_at TEXT DEFAULT (datetime('now')),"
" updated_at TEXT DEFAULT (datetime('now'))"
")");
if (r.is_err())
return r;
r = sql(db, "CREATE INDEX IF NOT EXISTS idx_rss_feeds_enabled "
"ON rss_feeds(enabled)");
if (r.is_err())
return r;
return Result<void>::ok();
}
} // anonymous namespace
void register_migration_v031() {
static bool done = false;
if (done)
return;
done = true;
MigrationRunner::register_migration({31, "rss_feeds", apply_v031});
}
} // namespace fincept