(venv) root@vmi2694310:/var/www/google_maps_extractor# python consolidate_data.py
2025-08-06 11:28:00,665 - INFO - Starting Google Maps Data Consolidation
2025-08-06 11:28:00,665 - INFO - Starting data consolidation process...
2025-08-06 11:28:00,665 - INFO - Loaded 20 records from hasil_gabungan.json
2025-08-06 11:28:00,666 - INFO - Selected category from metadata: Tempat Fitness
2025-08-06 11:28:00,666 - INFO - Processed 20 businesses
2025-08-06 11:28:00,666 - INFO - Processed 20 addresses
2025-08-06 11:28:00,666 - INFO - Processed 1 categories
2025-08-06 11:28:00,666 - INFO - Processed 136 opening hours
2025-08-06 11:28:00,675 - INFO - CSV files saved to database/
2025-08-06 11:28:00,677 - INFO - Consolidated JSON saved to database/consolidated_data.json
2025-08-06 11:28:00,677 - INFO - === CONSOLIDATION SUMMARY ===
2025-08-06 11:28:00,677 - INFO - Total Businesses: 20
2025-08-06 11:28:00,677 - INFO - Total Categories: 1
2025-08-06 11:28:00,677 - INFO - Cities: Jakarta, Jakarta Pusat, Central Jakarta City, Jakarta Selatan, South Jakarta City, Jakarta Barat
2025-08-06 11:28:00,677 - INFO - Categories: Tempat Fitness
2025-08-06 11:28:00,677 - INFO - Data consolidation completed successfully!
2025-08-06 11:28:00,677 - INFO - Next step: Run create_database.py to create SQLite database
(venv) root@vmi2694310:/var/www/google_maps_extractor# python create_database.py
2025-08-06 11:28:11,884 - INFO - Starting SQLite Database Creation
2025-08-06 11:28:11,885 - INFO - Connected to database: database/business_directory.db
2025-08-06 11:28:11,885 - INFO - Database schema created successfully
2025-08-06 11:28:11,886 - INFO - Loaded consolidated data from database/consolidated_data.json
2025-08-06 11:28:11,886 - INFO - Importing categories...
2025-08-06 11:28:11,886 - INFO - Importing businesses...
2025-08-06 11:28:11,887 - INFO - Importing addresses...
2025-08-06 11:28:11,887 - INFO - Importing business categories...
2025-08-06 11:28:11,887 - INFO - Importing opening hours...
2025-08-06 11:28:11,890 - INFO - Data import completed successfully
2025-08-06 11:28:11,891 - INFO - Database views created successfully
2025-08-06 11:28:11,891 - INFO - === DATABASE VERIFICATION ===
2025-08-06 11:28:11,891 - INFO - businesses: 20 records
2025-08-06 11:28:11,891 - INFO - addresses: 20 records
2025-08-06 11:28:11,891 - INFO - categories: 9 records
2025-08-06 11:28:11,891 - INFO - business_categories: 20 records
2025-08-06 11:28:11,891 - INFO - opening_hours: 136 records
2025-08-06 11:28:11,891 - INFO -
=== SAMPLE QUERIES ===
2025-08-06 11:28:11,891 - INFO - Sample businesses with locations:
2025-08-06 11:28:11,891 - INFO - - Empire Fit Club in Jakarta Pusat, Daerah Khusus Ibukota Jakarta
2025-08-06 11:28:11,891 - INFO - - Emporium Gym Square 1 in Jakarta Barat, Daerah Khusus Ibukota Jakarta
2025-08-06 11:28:11,891 - INFO - - Fitness First Senayan City in Jakarta Pusat, Daerah Khusus Ibukota Jakarta
2025-08-06 11:28:11,891 - INFO - - Anytime Fitness Setiabudi One in Jakarta Selatan, Daerah Khusus Ibukota Jakarta
2025-08-06 11:28:11,891 - INFO - - Willfitness Benhil in Jakarta Pusat, Daerah Khusus Ibukota Jakarta
2025-08-06 11:28:11,892 - INFO -
Categories: Lesehan, Prasmanan, Restoran, Seafood, Seblak, Snack Bar, Tempat Fitness, Toko Plastik, Warung Makan
2025-08-06 11:28:11,892 - INFO -
=== DATABASE CREATION COMPLETED ===
2025-08-06 11:28:11,892 - INFO - Database file: database/business_directory.db
2025-08-06 11:28:11,892 - INFO - Next step: Run api_server.py to start the REST API
2025-08-06 11:28:11,892 - INFO - Database connection closed
(venv) root@vmi2694310:/var/www/google_maps_extractor#

Edit

Pub: 06 Aug 2025 09:34 UTC

Views: 8