XML-DB-Import Project Documentation

This repository contains code for importing and managing XML data in a database using Laravel.

Installation

• Clone the repository:

git clone https://github.com/DelvinNJ/xml-db-import.git

cd xml-db-import

• Install dependencies using Composer:

composer install

• Copy the environment file and generate application key:

cp .env.example .env

php artisan key:generate

Database Setup

• Configure the database in .env file.
• Create the SQLite database file:

touch database/db.sqlite

Run database migrations to set up the database schema:

php artisan migrate

Running Unit Tests

To run the unit tests:

php artisan test

XML Operations

Store XML Data

To store XML data into the database from a file:

php artisan store-xml-data "file_name"

Replace "file_name" with the actual path of your XML file.

php artisan store-xml-data "file_name"

Update XML Data

To update XML data from a file:

php artisan update-xml-data "file_name"

Replace "file_name" with the actual path of your XML file.

php artisan update-xml-data feed.xml

Logging

Logs for XML operations are stored in:

storage/logs/xml_operation.log

Log Viewer

To view logs, start the Laravel development server:

php artisan serve

Then, navigate to the following URL in your web browser:

http://127.0.0.1:8000/log-viewer

Contact If you have any questions or feedback, feel free to reach out:

Email: delvinnj02@gmail.com

Happy coding!