Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql

Source identity

Field	Recorded value
Source type	GitHub source
Original record	Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql
Date	Not specified in source
Repository	Janady13/AI_Brain
Revision	11aa50ef5d7692e8abd1b8d74ae31c5c29201b14
Branch	codex/build-online-github-ani-irqa7y
Path or archive member	sub_brains/money_agents/sql/init.sql
Original SHA-256	4fd6ce310dd10f532cf873d654d7f200cc32f9595ee54e7dd1435b172bb59c63
Git blob SHA	1f54174babf15e7feaef57038a39aaaa1c58e5c5
Reading-copy SHA-256	4fd6ce310dd10f532cf873d654d7f200cc32f9595ee54e7dd1435b172bb59c63

Original source ↗

Every recorded occurrence

These 25 records contain identical original source bytes. Their paths and revisions remain part of the archive.

Original record	Branch or archive	Revision / identifier	Original location
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	codex/build-online-github-ani-irqa7y	11aa50ef5d7692e8abd1b8d74ae31c5c29201b14	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	codex/build-online-github-ani-hr4y0z	366ab848896ae49159cfb3f6c201b8c5a731e9c8	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	codex/build-online-github-ani-i3cigl	3a6e002311c48c27ffd41ef4a2a31c63947128cd	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	codex/build-online-github-ani	49db80a641b10ab62d16cc7643bd0b367f93951c	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	codex/build-online-github-ani-hrtsoc	50285aff347685f043e7a72e4d72891eebaa6cd6	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	codex/build-online-github-ani-7v4kug	5cd0bbf744b0aee9445913337e852889d9a8098e	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	copilot/convert-python-files-to-csharp	6d0767aad08781eb5c4e1eb14a42ec92c437be78	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	codex/build-online-github-ani-nbgsix	840945d70b88674d8f40d330001cc63d871dc8e2	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	copilot/vscode1760283895982	9e1c1a5b171addb5bb4a83b2ea7dede50c1cc81e	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	codex/build-online-github-ani-jf5olo	c6653627c453ab428d665226167fa5f4aa05e9a5	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	feature/seeder-engine-tests	cdb497ece2d1a770ca8c83eb1de8923cfaa9eceb	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	codex/build-online-github-ani-7nmb21	d0f50071c85cddaaebbf9c4dd1313bd7676986da	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	codex/build-online-github-ani-0etkns	e250b19d446bdffd542c9eea31cead12e30800d6	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	codex/build-online-github-ani-hr4y0z	366ab848896ae49159cfb3f6c201b8c5a731e9c8	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	codex/build-online-github-ani-irqa7y	11aa50ef5d7692e8abd1b8d74ae31c5c29201b14	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	codex/build-online-github-ani-i3cigl	3a6e002311c48c27ffd41ef4a2a31c63947128cd	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	copilot/convert-python-files-to-csharp	6d0767aad08781eb5c4e1eb14a42ec92c437be78	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	codex/build-online-github-ani-7v4kug	5cd0bbf744b0aee9445913337e852889d9a8098e	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	codex/build-online-github-ani-nbgsix	840945d70b88674d8f40d330001cc63d871dc8e2	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	copilot/vscode1760283895982	9e1c1a5b171addb5bb4a83b2ea7dede50c1cc81e	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	codex/build-online-github-ani-7nmb21	d0f50071c85cddaaebbf9c4dd1313bd7676986da	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	feature/seeder-engine-tests	cdb497ece2d1a770ca8c83eb1de8923cfaa9eceb	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	codex/build-online-github-ani	49db80a641b10ab62d16cc7643bd0b367f93951c	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	codex/build-online-github-ani-jf5olo	c6653627c453ab428d665226167fa5f4aa05e9a5	Open original
Janady13/AI_Brain / sub_brains/money_agents/sql/init.sql	codex/build-online-github-ani-hrtsoc	50285aff347685f043e7a72e4d72891eebaa6cd6	Open original

Recovered source transcript

Download complete source text ↓68 lines · 2.3 KB

-- Schema migrations for money agents

CREATE TABLE IF NOT EXISTS logs (
  id SERIAL PRIMARY KEY,
  worker_id INT,
  job_id INT,
  message TEXT,
  level TEXT,
  ts TIMESTAMP DEFAULT NOW()
);

CREATE TABLE IF NOT EXISTS jobs (
  id SERIAL PRIMARY KEY,
  status TEXT DEFAULT 'pending',
  payload TEXT,
  amount NUMERIC(12,2) DEFAULT 0.0,
  started_at TIMESTAMP,
  finished_at TIMESTAMP,
  worker_id INT
);

DO $$
BEGIN
  IF NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_name='jobs' AND column_name='status') THEN
    EXECUTE 'ALTER TABLE jobs ADD COLUMN status TEXT DEFAULT ''pending''';
  END IF;
  IF NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_name='jobs' AND column_name='payload') THEN
    EXECUTE 'ALTER TABLE jobs ADD COLUMN payload TEXT';
  END IF;
  IF NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_name='jobs' AND column_name='amount') THEN
    EXECUTE 'ALTER TABLE jobs ADD COLUMN amount NUMERIC(12,2) DEFAULT 0.0';
  END IF;
  IF NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_name='jobs' AND column_name='started_at') THEN
    EXECUTE 'ALTER TABLE jobs ADD COLUMN started_at TIMESTAMP';
  END IF;
  IF NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_name='jobs' AND column_name='finished_at') THEN
    EXECUTE 'ALTER TABLE jobs ADD COLUMN finished_at TIMESTAMP';
  END IF;
  IF NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_name='jobs' AND column_name='worker_id') THEN
    EXECUTE 'ALTER TABLE jobs ADD COLUMN worker_id INT';
  END IF;
END$$;

CREATE TABLE IF NOT EXISTS transactions (
  id SERIAL PRIMARY KEY,
  job_id INT,
  amount NUMERIC(12,2) NOT NULL DEFAULT 0.0,
  service TEXT,
  status TEXT,
  ts TIMESTAMP DEFAULT NOW()
);

CREATE OR REPLACE VIEW revenue_v AS
SELECT COALESCE(SUM(amount), 0)::NUMERIC(20,2) AS revenue
FROM transactions
WHERE status = 'success';

-- Seed starter jobs
INSERT INTO jobs (status, payload, amount)
VALUES
('pending', 'curl https://api.stripe.com/v1/charges -X GET', 0.00),
('pending', 'curl https://api.paypal.com/v1/payments/payment -X GET', 0.00),
('pending', 'curl https://cash.app/ -I', 0.00),
('pending', 'curl https://api.stripe.com/v1/customers -X GET', 0.00),
('pending', 'curl https://api.paypal.com/v1/invoicing/invoices -X GET', 0.00)
ON CONFLICT DO NOTHING;