Write Data to Database with CLI

Introduction

This Laravel project includes custom Artisan commands, XmlStructure, and InsertProductData, designed to inspect an XML file, transform its structure, and store the data in a database with CLI. This can be particularly useful for handling XML data seamlessly in a Laravel application.

Prerequisites

GitHub Clone and Composer Install

Clone the repository from GitHub:

git clone git@github.com:shoaib0300/write-data-to-database-with-CLI.git

Navigate to the project directory:

cd write-data-to-database-with-CLI

Run Composer to install project dependencies:

composer install

Ensure your Laravel environment is properly configured, and the database connection details are set in the .env file.

DB_CONNECTION=mysql                       # Database connection type (e.g., mysql)
DB_HOST=localhost                         # Database host (e.g., localhost)
DB_PORT=3306                              # Database port (usually 3306 for MySQL)
DB_DATABASE=laravel_project               # Database name
DB_USERNAME=root                          # Database username
DB_PASSWORD=                              # Database password

Database Migration

Run database migrations:

php artisan migrate

Insert XML Data to JSON Form to Check Table Columns

Before using the XmlStructure and InsertProductData commands, make sure to follow these steps: Upload the XML file you want to process into the storage/app/uploads/ directory.

No additional installation steps are required. The command is ready to use once you've uploaded your XML file.

Execute the following command in your terminal to see the uploaded file content in JSON format:

php artisan xml:inspect {filename}

# Example:
php artisan xml:inspect feed.xml

Insert Product Data into Database

To insert product data into the database from the XML file, you can use the product:insert Artisan command. Follow these steps:

1. Ensure that you have a valid feed.xml file in the storage/app/uploads/ directory.

2. Open a terminal or command prompt and navigate to your Laravel project's root directory.

3. Run the following command to insert product data into the database:

   php artisan product:insert

4. The command will process the XML file, check for duplicates, and insert non-duplicate product data into the database.

5. If any errors occur during the process, they will be logged in /storage/logs/custom.log, and you'll be notified.

Note: Make sure your database connection settings in the .env file are correctly configured.

PHPUnit Test Cases

To run PHPUnit test cases for XmlStructureTest, use the following command:

php artisan test --filter XmlStructureTest

To run PHPUnit test cases for InsertProductDataTest, use the following command:

php artisan test --filter InsertProductDataTest

To clear the configuration cache, use:

php artisan config:clear