This package provides the following services:
atom-dbex-mariadb
Dbex MariaDB engine for Atom Editor.
This engine supports most of the basic aspects of a MariaDB connection including:
- Listing schemas, tables, views, functions, procedures and table triggers
- Distintion about Primary/Foreign keys, and normal fields;
- Double click on Table and Views shows a limited query;
- Actions to show structures for tables, views, functions, procedures and table triggers;
TODO
- cover "DELIMITER" on queries;
- multiple lines are not working
- example:
SET FOREIGN_KEY_CHECKS=0; UPDATE
storeSET store_id = 0 WHERE code='admin'; UPDATE
store_groupSET group_id = 0 WHERE name='Default'; UPDATE
store_websiteSET website_id = 0 WHERE code='admin'; UPDATE
customer_groupSET customer_group_id = 0 WHERE customer_group_code='NOT LOGGED IN'; SET FOREIGN_KEY_CHECKS=1;
- example:
- implement ssl connection
- export/import data/structure (dump/restore)