Skip to content

Wallos: Open-source, self-hostable personal subscription tracker. Visualize your recurring expenses, manage your budget, and save money.

2.0 KB
Raw Blame
<?php

/* 
* This migration adds tables to store the date about the new notification methods (telegram, webhooks and gotify)
* Existing values on the notifications table will be split and migrated to the new tables.
*/

$db->exec("CREATE TABLE IF NOT EXISTS telegram_notifications (
    enabled BOOLEAN DEFAULT 0,
    bot_token TEXT DEFAULT '',
    chat_id TEXT DEFAULT ''
)");

$db->exec("CREATE TABLE IF NOT EXISTS webhook_notifications (
    enabled BOOLEAN DEFAULT 0,
    headers TEXT DEFAULT '',
    url TEXT DEFAULT '',
    request_method TEXT DEFAULT 'POST',
    payload TEXT DEFAULT '',
    iterator TEXT DEFAULT ''
)");

$db->exec("CREATE TABLE IF NOT EXISTS gotify_notifications (
    enabled BOOLEAN DEFAULT 0,
    url TEXT DEFAULT '',
    token TEXT DEFAULT ''
)");

$db->exec("CREATE TABLE IF NOT EXISTS email_notifications (
    enabled BOOLEAN DEFAULT 0,
    smtp_address TEXT DEFAULT '',
    smtp_port INTEGER DEFAULT 587,
    smtp_username TEXT DEFAULT '',
    smtp_password TEXT DEFAULT '',
    from_email TEXT DEFAULT '',
    encryption TEXT DEFAULT 'tls'
)");

$db->exec('CREATE TABLE IF NOT EXISTS notification_settings (
    days INTEGER DEFAULT 0
)');

// Check if old email notifications table has data and migrate it
$result = $db->query('SELECT COUNT(*) as count FROM notifications');
$row = $result->fetchArray(SQLITE3_ASSOC);

if ($row['count'] > 0) {
    // Copy data from notifications to email_notifications
    $db->exec('INSERT INTO email_notifications (enabled, smtp_address, smtp_port, smtp_username, smtp_password, from_email, encryption)
               SELECT enabled, smtp_address, smtp_port, smtp_username, smtp_password, from_email, encryption FROM notifications');

    // Copy data from notifications to notification_settings
    $db->exec('INSERT INTO notification_settings (days)
               SELECT days FROM notifications');

    if ($db->changes() > 0) {
        $db->exec('DROP TABLE IF EXISTS notifications');
    }
} else {
    $db->exec('DROP TABLE IF EXISTS notifications');
}

?>