Download the PHP package webmatch/wbm-query-manager without Composer
On this page you can find all versions of the php package webmatch/wbm-query-manager. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download webmatch/wbm-query-manager
More information about webmatch/wbm-query-manager
Files in webmatch/wbm-query-manager
Package wbm-query-manager
Short Description Database-Management plugin for Shopware
License GPL3
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package wbm-query-manager
WbmQueryManager - Database-Management plugin for Shopware
This plugin integrates a new module within the Shopware backend that allows for a simple management of SQL queries and their manual or automated execution.
The plugin offers the following features:
- Write, edit, delete, duplicate and run queries
- Shows fetched rows within backend immediately
- Download fetched rows as CSV format
- Execute queries in regular intervals as cron-jobs
- Cron-Jobs: Logging of fetched rows in CSV format
- Cron-Jobs: Send emails with attached log-files
- SQL syntax highlighting (Codemirror)
- Syntax and table structure autocompletion (Codemirror)
Requirements
- Shopware >= 5.2.0
Optional:
- MySQL Improved Extension (MySQLi)
- enables the fetching of more than one rowsets per query by multiple statements (multi_query)
Installation
Clone this repository into a folder WbmQueryManager within the custom/plugins directory of the Shopware installation.
Install the plugin through the Plugin-Manager within the Shopware backend. Activate the plugin and when prompted allow for the clearing of the listed caches. Reload the backend to complete the installation.
Install with composer
- Change to your root Installation of shopware
- Run command
composer require webmatch/wbm-query-managerand install and activate plugin with Plugin Manager
Usage
The module will be accessible in backend through a new menu point under the Settings menu tab.
The plugin comes with a few example queries which can be safely deleted.
Configuration
The plugin offers a few basic configuration options:
- Send CSV Exports to an E-Mail Address
- (see Cron-Jobs below)
- CSV Field Separator
- (see Cron-Jobs below)
- Active SQL Autocompletion
- if the autocompletion of syntax isn't desired it can be disabled
Cron-Jobs
To use the cron-job features of this plugin please first make sure the plugin Cron is installed in Plugin Manager and the Cron-Job Query Manager is activated in the cron job settings.
Shopware Cron-Jobs can be executed via request of the URL (e.g. http://your-shop.tld/backend/cron) or by console command php bin/console sw:cron:run (recommended)
Your server has to be setup accordingly to either request the cron URL or run the console command in regular intervals. This interval naturally also determines the minimum interval that Shopware cron-jobs can be executed at.
Fetched rows of SELECT statements executed through cron-jobs will be logged as CSV files in the directory var/logs of the Shopware installation. By specifying an email address in the plugin configuration logged files will also be transmitted by email.
License
MIT
This plugin is also commercially available through Shopware's community store. While the code itself is released under MIT license, the commercial distribution includes support through Webmatch GmbH and continous auto-updates. You may use this plugin without purchase but please be aware that you may receive notifications through Shopware about missing the according license. We have no influence on those notifications.
