🗺️ PlacesCheck

A beautiful terminal application to verify place names against a large Supabase database, featuring a colorful and responsive TUI interface with smart parsing and progress tracking.

✨ Features

• One-Click Operations: Easily fetch and compare places from terminal
• Smart Parsing: Supports comma-separated, bulleted, and numbered lists
• Progress Bars: Clear visual progress using rich.progress
• Colorful Output: Displays results in neatly formatted tables
• Windows Friendly: Built-in Unicode handling

🛠️ Setup

1. Clone the repository:

   git clone https://github.com/raulkolaric/PlacesCheck.git
   cd PlacesCheck

2. Install dependencies:

   pip install -r requirements.txt

3. Configure Supabase credentials: Create a .env file:

   SUPABASE_URL=your_project_url
   SUPABASE_SERVICE_ROLE_KEY=your_service_key

🚀 Usage

Run the app:

python src/main.py

Menu Options:

1. Fetch Data – Loads existing place names from Supabase table google_places
2. Compare – Parses insert.txt and compares each name
3. Exit – Closes the program

📁 Project Structure

PlacesCheck/
├── src/
│   └── main.py             # Main application
│   └── compare.py
│   └── fetch.py
├── data/          # Input list of place names
│   └── fetched_data.json       # Cached data from Supabase
│   └── missing_places.txt      # Auto-saved unmatched entries
│   └── insert.txt              # Your input against the data from Supabase
├── .env                    # Your Supabase credentials
├── requirements.txt        # Python dependencies
└── README.md               # Project overview

⚙️ Configuration

Default values:

TABLE_NAME = "google_places"
COLUMN_NAME = "name"

Change these in main.py to use a different table or column.

💡 Tips

• Supports copy-pasting from various formats (e.g., Excel, Google Docs)
• Automatically saves unmatched entries to missing_places.txt
• Press Ctrl+C to exit safely at any time

📜 License

MIT License – Free to use, modify, and distribute!