atom-dbex-mysql

Dbex MySQL engine for Atom Editor.

This engine supports most of the basic aspects of a MySQL 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

• install MySQL language support if not installed;
• cover "DELIMITER" on queries;
• multiple lines are not working
  • example: SET FOREIGN_KEY_CHECKS=0; UPDATE storeSET store_id = 0 WHERE code='admin'; UPDATEstore_groupSET group_id = 0 WHERE name='Default'; UPDATEstore_websiteSET website_id = 0 WHERE code='admin'; UPDATEcustomer_group SET customer_group_id = 0 WHERE customer_group_code='NOT LOGGED IN'; SET FOREIGN_KEY_CHECKS=1;
• implement ssl connection
• export/import data/structure (dump/restore)