Saifur-DBHelper

A DB Helper providing features like DB backup

Contents

• Saifur-DBHelper
  • Contents
  • Documentation, Installation, and Usage Instructions
    • Commands
    • API
      • Request: Server DB Full Backup
      • Request: Server DB Structure Backup
      • Request: Server DB Data Backup
      • Request: Server DB Status
  • Contributor
  • Alternatives
  • License

Documentation, Installation, and Usage Instructions

This package allows you to manage your logs.

Once installed you can do stuff like this:

Commands

composer require saifur/dbhelper
composer dump-autoload
php artisan vendor:publish --tag=public --force

API

Request: Server DB Full Backup

• Method: POST
• URL: http://localhost:8001/saifur/db-helper/db-backup/server-db-full-backup
• Headers:
  • Authorization: Bearer <your_token>
  • Content-Type: application/json
• Body:
  • form-data: | Key | Value | |------------------------------|---------------| | except_tables[0] | activity_log | | except_tables[1] | audit_trail | | table_rules[0][table_name] | audit_trail | | table_rules[0][row_limit] | 100 | | table_rules[0][order_by] | id | | table_rules[0][order_type] | DESC | | table_rules[1][table_name] | activity_log | | table_rules[1][row_limit] | 100 | | table_rules[1][order_by] | id | | table_rules[1][order_type] | DESC |

Request: Server DB Structure Backup

• Method: POST
• URL: http://localhost:8001/saifur/db-helper/db-backup/server-db-structure-backup
• Headers:
  • Authorization: Bearer <your_token>
  • Content-Type: application/json

Request: Server DB Data Backup

• Method: POST
• URL: http://localhost:8001/saifur/db-helper/db-backup/server-db-data-backup
• Headers:
  • Authorization: Bearer <your_token>
  • Content-Type: application/json
• Body:
  • form-data:
    • except_tables[0]: activity_log
    • except_tables[1]: audit_trail
    • table_rules[0][table_name]: audit_trail
    • table_rules[0][row_limit]: 100
    • table_rules[0][order_by]: id
    • table_rules[0][order_type]: DESC
    • table_rules[1][table_name]: activity_log
    • table_rules[1][row_limit]: 100
    • table_rules[1][order_by]: id
    • table_rules[1][order_type]: DESC

Request: Server DB Status

• Method: POST
• URL: http://localhost:8001/saifur/db-helper/db-backup/server-db-status
• Headers:
  • Authorization: Bearer <your_token>
  • Content-Type: application/json
• Body:
  • form-data:
    • view: html

Contributor

• Md. Saifur Rahman

| | | | | | |-|-|-|-|-| | | | | | |

Alternatives

License

The MIT License (MIT). Please see License File for more information.