vladbalmos/mitzasql

MySQL command line / text based interface client

mitzasql's Issues

Request confirmation when exiting

Correctly handle "set" data type

Don't fetch schema when table is a view

Catch ctrc-c and do cleanup on exit

Install signal handler to catch ctr-c
Do cleanup on exist (close connection, etc)

Running 'describe table' shows hex encoded type column

Resizing cols breaks rows alignment during scroll

Broken row rendering in sakilla.address table (spatial data type issue)

Encode spatial data to base64

Implement query editor history

Store all the queries in a single location to preserve history

Fix emacs edit widget

When deleting word forward, stop at the first non-word character

Create auto-refresh functionality for queries

• command line argument

Cleanup action bar on db views

'show full processlist' shows the info column as binary

'show full processlist' shows the info column as binary

Add license info to source code

Scroll through command history using ctrl-p, ctrl-n

When scrolling rows up down re-render only the rows visible to improve performance

Write tests for the existing functionality

Implement query log widget

Text widget displaying all the queries stored in the connection query log

Implement query editor syntax highlighting

Create a new edit widget from scratch based on urwid.Text in order to highlight words using different colors

Log each query for later displaying in a log widget

Add ssl options to connection screen

Close connection on exit

Handle query errors

Show "loading" when executing custom query

Update README

Crash on resize db_tables_view

:resize create_time 10 - CRASH

Bug on join query

When pressing 0 in db_tables_view the columns are not scrolled to the first column

db: papucei_aoo

Create documentation & website

Create "go to table" popup

View full row data when selecting a row in a table view

If in table view show row data.
If in database tables view, if row is a stored procedure, show create code

Implement basic mysql filtering commands

:like [column] keyword => WHERE col LIKE "%keyword%"
:llike [column] keyword => WHERE col LIKE "%keyword"
:rlike [column] keyword => WHERE col LIKE "keyword%"
:eq column value
:lt column value
:lte column value
:gt column value
:gte column value
:in column v1, v2, v2
:between column v1, v2
:null column

Command ending in !, will be negated. Ex: between! col v1, ve => where col not between v1 and v2

Show procedures in the database tables views

Implement query editor widget & query data view

Cache db views widgets

When refreshing the widget, if the model params != from existing ones, replace the model & table view, making sure that any install signal handlers are disconnected first

ordering is broken

Due to model reload, the ordering is broken

Test UI with data using different collations & encodings

Error when running multiple query statements separated by ;

Should use a a new connection each time running a custom query to avoid changing delimiter and other variables for the rest of the program

Read query from command line

Create help widget

Implement consistent logging

Show notifications for commands in the status bar

When executing commands, display error/info notifications in the status bar

Show table information & indexes

Implement query editor autocomplete

The suggestions are based on:

• the existing mysql keywords
• columns in active table
• strings entered previously in other queries

The suggestions will be displayed in a status bar widget attached to the bottom of the editor

Caching db views breaks command autocomplete of column names

Make query editor resizable

Resize query editor with ctrl-shift up/down

Inconsistent breadcrumbs during query and widget caching

Preserve columns sizes when refreshing table

Connection drops due to inactivity

Connection drops due to inactivity

DBTablesView: If object is not table, show create function/proc/trigger

Show last command when entering command mode