Skip to content

README.md

Latest commit

 

History

History
71 lines (46 loc) · 1.14 KB

README.md

File metadata and controls

71 lines (46 loc) · 1.14 KB
Raw

🇩🇿 Algeria Cities Data (Wilayas, Dairas, Communes) for PostgreSQL

A simple CLI tool to import structured data of Algerian

Features:

  • Automatically creates tables: wilaya, daira, communes
  • Populates them with full official data from a structured JSON file
  • Minimal setup – just provide your database credentials

Installation:

npm install -g algeriacitiesdata

Usage:

algeriacitiesdata

You will be prompted to enter your database connection:

DB_HOST: 127.0.0.1
DB_PORT: 5432
DB_USER: your_user
DB_PASSWORD: your_password
DB_NAME: your_database

If the connection is valid, the tool will:

  • Create necessary tables if they don't exist
  • Insert all wilayas, their dairas, and communes

Example Output:

✔ Tables created successfully  
✔ All data inserted successfully

Tables created:

  • wilaya(id, code, name, name_ar)
  • daira(id, name, name_ar, wilaya_id)
  • communes(id, name, name_ar, wilaya_id, daira_id)

Author: Fares Djefaflia GitHub: https://github.com/faresdjefaflia

License: MIT