Untitled

-- 1-38 arası account_id'leri oluştur
WITH AccountList AS (
    SELECT 1 AS account_id UNION ALL
    SELECT 2 UNION ALL
    SELECT 3 UNION ALL
    SELECT 4 UNION ALL
    SELECT 5 UNION ALL
    SELECT 6 UNION ALL
    SELECT 7 UNION ALL
    SELECT 8 UNION ALL
    SELECT 9 UNION ALL
    SELECT 10 UNION ALL
    SELECT 11 UNION ALL
    SELECT 12 UNION ALL
    SELECT 13 UNION ALL
    SELECT 14 UNION ALL
    SELECT 15 UNION ALL
    SELECT 16 UNION ALL
    SELECT 17 UNION ALL
    SELECT 18 UNION ALL
    SELECT 19 UNION ALL
    SELECT 20 UNION ALL
    SELECT 21 UNION ALL
    SELECT 22 UNION ALL
    SELECT 23 UNION ALL
    SELECT 24 UNION ALL
    SELECT 25 UNION ALL
    SELECT 26 UNION ALL
    SELECT 27 UNION ALL
    SELECT 28 UNION ALL
    SELECT 29 UNION ALL
    SELECT 30 UNION ALL
    SELECT 31 UNION ALL
    SELECT 32 UNION ALL
    SELECT 33 UNION ALL
    SELECT 34 UNION ALL
    SELECT 35 UNION ALL
    SELECT 36 UNION ALL
    SELECT 37 UNION ALL
    SELECT 38
),
EligibleAccounts AS (
    SELECT account_id
    FROM AccountList
    WHERE NOT EXISTS (
        SELECT 1 
        FROM Jobs 
        WHERE Jobs.account_id = AccountList.account_id 
          AND Jobs.bot_id = 4 
          AND Jobs.status = 'Pending'
    )
)

-- Jobs tablosuna yeni kayıt ekle
INSERT INTO Jobs (account_id, bot_id, execution_time, status)
SELECT 
    ea.account_id, 
    4 AS bot_id, 
    DATETIME('now') AS execution_time, 
    'Pending' AS status
FROM EligibleAccounts ea;

-- Yeni eklenen işlere ait JobData bilgilerini ekle
INSERT INTO JobData (job_id, data_key, data_value)
SELECT j.job_id, 'amount', '10'
FROM Jobs j
WHERE j.bot_id = 4 AND j.status = 'Pending';

INSERT INTO JobData (job_id, data_key, data_value)
SELECT j.job_id, 'recipient_rr_id', '2001474745'
FROM Jobs j
WHERE j.bot_id = 4 AND j.status = 'Pending';

INSERT INTO JobData (job_id, data_key, data_value)
SELECT j.job_id, 'resource_type', '0'
FROM Jobs j
WHERE j.bot_id = 4 AND j.status = 'Pending';