Description

test mycli using pexpect (this way the tty code path can be tested)

Checklist

• [x] I've added this contribution to the changelog.md.
• [x] I've added my name to the AUTHORS file (or it's already there).

Description

• Adds a generic OutputFormatter class with all of tabulate's output formats.
• Moves expanded output to the output formatter.
• Adds terminaltables formats.

Checklist

• [x] I've added this contribution to the changelog.md.
• [x] I've added my name to the AUTHORS file (or it's already there).

This error:

SyntaxError: ('invalid syntax', ('/usr/lib/python2.6/site-packages/mycli/main.py', 174, 29, ' return {x: get(x) for x in keys}\n'))

This pull request adds support for reading commands from stdin. It works similar to the mysql client. If you pipe commands to mycli like this:

cat test.sql | mycli

or this

mycli < test.sql

Then, mycli will output the results in a plain, tab-separated format (no padding or status messages). If you use the -t/--table argument, then mycli will output the results in your configured table format.

After processing stdin, mycli will quit.

I can also see use for a yet-to-be-added (different PR) verbose mode that will add support for displaying the commands that are running as well as possibly status messages.

This addresses #179.

@meeuw @tsroten @j-bennet

This is my first attempt at replacing the tabulate library with an alternative. It is in no way near shippable quality. I'm just putting it out there as a prototype. I'll keep polishing it and you're all welcome to take a stab at it as well. Let's collaborate on this branch.

Checklist

• [ ] I've added this contribution to the changelog.md.
• [ ] I've added my name to the AUTHORS file (or it's already there).

Just a list of options I'm currently using and that would be nice to have automatcially in mycli

[mysql]
pager = mypager  # https://github.com/romuald/mypager
safe-updates
max-join-size=1000000000

They all seem to work nicely within the CLI, but aren't loaded automatically

Description

This adds styled output (headers, odd row, even rows). Configuring it is the same as the current styles (i.e. Pygments token-type strings). It defaults the config file to do bold headers.

This addresses #364.

~~The tests will fail until CLI Helpers is released with https://github.com/dbcli/cli_helpers/pull/10.~~

Checklist

• [x] I've added this contribution to the changelog.md.
• [x] I've added my name to the AUTHORS file (or it's already there).

When multi_line is set to true and pasting, e.g.:

use mysql;
select User from user;

The last command is not executed.

The command pastes on a single line with the semi colon delimiter but the last command is not executed, pasting:

use mysql;
select User from user;
select User from user;

only returns one resultset from the user query.

EDIT: This is on version 1.4.0 on Debian Jessie.

I occasionally pressed arrow keys on the prompt, then Ctrl+C and got the CLI aborted. I think it would be more convenient to accept the combination as 'No' answer.

Description

output via generator to prevent:

• buffering of the complete output
• joining and splitting the output

Checklist

• [x] I've added this contribution to the changelog.md.

Description

I've did some quite naïve tests (only run pytest & start mycli) and changed the following minimum requirements for mycli.

Pygments lowered to >= 1.6 PyMySQL raised to >= 0.6.7 configobj lowered to 5.0.5 pycryptodome set minimum to 3

Checklist

• [x] I've added this contribution to the changelog.md.
• [x] I've added my name to the AUTHORS file (or it's already there).

The terminal show query results is awful when the table have so many fields. Can you do something like textual scrolling up and down and left and right to view data?

https://github.com/Textualize/textual Textual is a Python framework for creating interactive applications that run in your terminal.

Hi dbcli/mycli!

This is a one-off automatically generated pull request from LGTM.com :robot:. You might have heard that we’ve integrated LGTM’s underlying CodeQL analysis engine natively into GitHub. The result is GitHub code scanning!

With LGTM fully integrated into code scanning, we are focused on improving CodeQL within the native GitHub code scanning experience. In order to take advantage of current and future improvements to our analysis capabilities, we suggest you enable code scanning on your repository. Please take a look at our blog post for more information.

This pull request enables code scanning by adding an auto-generated codeql.yml workflow file for GitHub Actions to your repository — take a look! We tested it before opening this pull request, so all should be working :heavy_check_mark:. In fact, you might already have seen some alerts appear on this pull request!

Where needed and if possible, we’ve adjusted the configuration to the needs of your particular repository. But of course, you should feel free to tweak it further! Check this page for detailed documentation.

Questions? Check out the FAQ below!

FAQ

I started seeing this error a month or two ago, when running mycli on the server:

% mycli -u myuser
Connecting to socket /var/run/mysqld/mysqld.sock, owned by user mysql
[Errno 13] Permission denied

Similar response with mycli -u root (as user root).

The .mycli.log showed:

2022-10-23 12:32:15,299 (279176/MainThread) mycli.config WARNING - Unable to parse line None of config file '/etc/mysql/my.cnf'.
2022-10-23 12:32:15,299 (279176/MainThread) mycli.config WARNING - Using successfully parsed config values.
2022-10-23 12:32:15,300 (279176/MainThread) mycli.config WARNING - Unable to parse line None of config file '/etc/mysql/conf.d/mysqldump.cnf'.
2022-10-23 12:32:15,300 (279176/MainThread) mycli.config WARNING - Using successfully parsed config values.
2022-10-23 12:32:15,302 (279176/MainThread) mycli.config WARNING - Unable to parse line None of config file '/etc/mysql/my.cnf'.
2022-10-23 12:32:15,302 (279176/MainThread) mycli.config WARNING - Using successfully parsed config values.
2022-10-23 12:32:15,303 (279176/MainThread) mycli.config WARNING - Unable to parse line None of config file '/etc/mysql/conf.d/mysqldump.cnf'.
2022-10-23 12:32:15,303 (279176/MainThread) mycli.config WARNING - Using successfully parsed config values.
2022-10-23 12:32:15,309 (279176/MainThread) mycli.main
ERROR - traceback: 'Traceback (most recent call last):\n  File
  "/usr/lib/python3/dist-packages/mycli/main.py", line 482, in connect\n
  _connect()\n  File "/usr/lib/python3/dist-packages/mycli/main.py",
  line 456, in _connect\n    self.sqlexecute = SQLExecute(\n
  File "/usr/lib/python3/dist-packages/mycli/sqlexecute.py",
  line 119, in __init__\n    self.connect()\n  File
  "/usr/lib/python3/dist-packages/mycli/sqlexecute.py",
  line 179, in connect\n    conn = pymysql.connect(\n  File
  "/usr/lib/python3/dist-packages/pymysql/connections.py", line 285,
  in __init__\n    self.ctx = self._create_ssl_ctx(ssl)\n  File
  "/usr/lib/python3/dist-packages/pymysql/connections.py", line
  387, in _create_ssl_ctx\n    ctx.load_cert_chain(sslp["cert"],
  keyfile=sslp.get("key"))\nPermissionError: [Errno 13] Permission denied\n'

indicating some SSL cert problem. Since I didn't care about SSL in this case and just wanted to connect via mysqld.sock, I opened sqlexecute.py in /usr/lib/python3/dist-packages/mycli and edited this line

conn = pymysql.connect(
            database=db, user=user, password=password, host=host, port=port,
            unix_socket=socket, use_unicode=True, charset=charset,
            autocommit=True, client_flag=client_flag,
            local_infile=local_infile, conv=conv, ssl=ssl, program_name="mycli",
            defer_connect=defer_connect, init_command=init_command
        )

changing ssl=ssl to ssl=''. This fixed the problem, but obviously not a permanent fix.

Is this a bug, or is my system misconfigured? No trouble with anything else on the system, including SSL.

Server: Ubuntu 22.04, mysqld Ver 8.0.30-0ubuntu0.22.04.1 for Linux

Description

Fixes #1087 .

I thought this implementation was correct, but I don't use vi-mode, and we have an issue from a user who does. Best to remove the vi bindings. Perhaps someone who uses vi-mode can PR better bindings.

Checklist

• [x] I've added this contribution to the changelog.md.
• [x] I've added my name to the AUTHORS file (or it's already there).

Hello I've installed this program using pip install mycli. All the commands are working fine, but none of the data (tables, databases, are being displayed on the screen).

Rather I keep getting the error: 'less' is not recognized as an internal or external command, operable program or batch file.