Real Estate Company Portal (Test Scaffold)

This project is a simple real estate company portal for local testing and demonstration purposes. All data is synthetic/test only. No real or realistic personal data is generated.

Tech Stack

• Backend: Python (Flask)
• Database: MySQL
• Frontend: HTML, CSS, JavaScript (vanilla)

Features

1. Database Seeder: create_and_seed_db.py creates and seeds a MySQL database (real_estate_test) with synthetic customers.
2. Flask API: app.py runs a local server and provides /search?name=... endpoint to search customers by name.
3. Frontend: index.html provides a search bar and displays results in a table, styled with simple CSS.

Setup Instructions

1. Install Python 3 and MySQL server locally.
2. Install required Python packages:

   pip install flask mysql-connector-python
   

3. Run create_and_seed_db.py to create and seed the database:

   python create_and_seed_db.py
   

4. Start the Flask server:

   python app.py
   

5. Open index.html in your browser and use the search bar.

Notes

• All sensitive values are sanitized for testing (see code comments).
• Default dataset size: 1000 synthetic users.
• See code comments for further instructions and details.