saifur/dbhelper

This a package all about DB helper

v1.0.1 2023-07-06 08:34 UTC

Requires

• php: ^7.3.11|^8.0

MIT

• Mohamed Saifur Rahman

• laravel
• db-backup
• db-helper
• db-structure-backup
• db-data-backup
• db-full-backup
• db-full-backup-zip
• db-table-structure-backup
• db-view-structure-backup
• db-procedure-structure-backup
• db-function-structure-backup

README

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.