fastflo/emma

emma's Issues

Edit table brings AttributeError

Environment:
OS: Ubuntu 14.04
Emma 0.7

Step to reproduce:

1.Right click on table kjv from kjv database
2.Choose from dropdown list item - edit table

reproduced in 100% of cases

Feature Request: Multiple queries in editor, Run single query

Some SQL tools, like sqliteman allow the query field to include multiple queries, each of which can be run separately.

When the cursor is in a particular query, that is the query that will be run. This is very convenient as it allows you to easily set up a file with multiple queries you often run, which can easily be run individually as needed. This also makes it easy to copy a query, paste it and then modify it while keeping the original intact.

Can't add, edit or drop table index

glushko311 commented 38 minutes ago
Environment: OS - Ubuntu 14.04
Emma 0.7

Steps to reproduce:

1.Insert a table
2.Choose bookmark "Indexes"
3.Try to add new index
4.Try to edit index
5.Try to drop index

Open table (name contane space) bring error

Environment:
OS: Ubuntu 14.04
Emma 0.7

Steps to reproduce:
1.Create a table name contane space
2.Choice creating table

Droping database(name containe special characters) brings error

Environment:
OS: Ubuntu 14.04
Emma 0.7

Steps to reproduce
1.Create database name = 'rt!@$%!&^^&^%^^_&^&('
2.Drop database name = 'rt!@$%!&^^&^%^^_&^&('

Reproduced in 10% of cases

Check tables in database brings AttributeError

Environment: Ubuntu 14.04.
Emma 0.7

Steps to reproduce:

1.Create database name = '[]'.
2.Create in database [] table with name ='111'.
3.Right click on database [] and select 'Check tables'.

Reproduce in 10% of cases

Rename field of table(new name contain specific symbols) brings error

Environment:
OS: Ubuntu 14.04
Emma 0.7

Steps to reproduce:
1.Right click to field of table
2.Select edit field
3.Change name of field to "Имя!"№"&;№%№%?*&(//,||&\l;:~&"

Reproduce in 20% of cases

Editing table name brings IndexError

Environment:
Ubuntu 14.04
Emma 0.7

Steps to reproduce:
1.Create table 'department'
2.Select table 'department' and rigt click on it
3.Select edit table
4.Change table name to 'department23'
5.Click 'OK' and then click 'Yes'

Creating table(name contain special characters) brings error

Environment:
OS: Ubuntu 14.04
Emma 0.7

Steps to reproduce:

1.Create database name = 'test1'
2.Create table, table name ='@#$%$^&%&^()()('

Reproduce in 30% of cases

Add "Edit/Modify database" dialog

Sugestion: Cache pervious parsed table information

I use emma quite a lot to work on wordpress multisite databases (50k+) tables ... there is not much in the tables, but there are many of them, a start of emma takes about 20min ... the layout almost never changes.

It would be nice if emma could "remember" the database layout until someone pressen a "refresh" button ... I tried to read trough the sourcecode, but i m not good enough in python to understand how to add such caching

Function "Truncate" isn't working

Environment:
OS: Ubuntu 14.04
Emma 0.7

Steps to reproduce:

1.Choice a table
2.Click the button "Truncate"
3. Click "Yes"

Checking tables brings mysql error

Environment:
Ubuntu 14.04
Emma 0.7

Steps to reproduce:

1.Right click to any database
2.Select "Check tables"