🧠 db-shifter

_Because someone switched your fking DB URL again._**

---

👶 Did your intern point production to the wrong DB?

🤡 Did your devops guy swear "nothing changed" before disappearing?

🔥 Did your CTO say “just restore from backup” like you weren’t already crying?

Yeah. We’ve all been there.

Welcome to db-shifter — the little script that digs through your old PostgreSQL database and copies only the missing rows into your new one.

No overwrites. No dumbass pg_dump. Just cold, calculated migration for the chaotic neutral in you.

---

⚡ Why?

Because your CTO is a clown.
Because your devops team “accidentally” pointed production at the wrong motherf**king database.
Because you need to copy missing shit table-by-table and you’re too pretty to do it manually.

---

🧰 Features

• ✅ Auto-detects all tables in public schema
• ✅ Finds primary keys like a bloodhound
• ✅ Copies only rows missing in the new DB
• ✅ Skips duplicates (doesn’t ruin your existing data)
• ✅ FK errors? Nah — this ain’t your grandma’s pg_dump

---

💾 Installation

pip install db-shifter

Or if you're a real one:

git clone https://github.com/goodness5/db-shifter.git
cd db-shifter
pip install -e .

---

🚀 Usage

db-shifter --old-db-url postgresql://user:pass@oldhost/db   --new-db-url postgresql://user:pass@newhost/db

---

🧨 Command-line options

Flag	What it does
--dry-run	Simulate the transfer, no data is hurt
--verbose	Prints detailed logs of every row
--table users	Sync just one table
--skip-fk	Ignores foreign key errors

---

🧠 How It Works

1. Connects to both DBs
2. Lists all public tables
3. Checks the primary key (like a snitch)
4. Pulls rows missing from the new DB
5. Inserts them without wrecking existing rows

---

⚠️ Caution

• Assumes you have primary keys (don’t be a barbarian)
• Does NOT handle circular FK hell — yet
• If you’re syncing 50GB of trash, don’t cry when it lags
• Backups are your friend. Don’t be a dumbass.

---

✨ Coming Soon

• Auto topological sorting to avoid FK explosions
• Timestamp-based syncing (created_at support)
• GUI with a "FIX EVERYTHING" button (for product managers lol)

---

🪦 Contributing

Found a bug? Good.
Fix it, submit a PR, and don't drop your cashapp in the description.

---

📜 License

MIT. Do whatever the f**k you want. Just don’t call me if you drop prod again.