02.01.2017       Выпуск 159 (02.01.2017 - 08.01.2017)       Релизы

pgcli - 1.3.0

REPL для Postgres. Изменения описаны по ссылке https://allmychanges.com/p/python/pgcli/#1.3.0. Скачать можно по ссылке: https://pypi.python.org/pypi/pgcli/

Читать>>



Экспериментальная функция:

Ниже вы видите текст статьи по ссылке. По нему можно быстро понять ссылка достойна прочтения или нет

Просим обратить внимание, что текст по ссылке и здесь может не совпадать.

Description:
Postgres CLI with autocompletion and syntax highlighting
Tracked by:
, , , ,
Moderated by:
Last update was:
1 day, 7 hours ago
Time to next update:
0 minutes
Versions:
  • Discovered at Dec. 30, 2016 Tweet
    Source: changelog.rst

    Bug Fixes:

    • Fix a crashing bug due to sqlparse upgrade. (Thanks: Darik Gamble)
  • Discovered at Dec. 30, 2016
    Source: changelog.rst

    IMPORTANT: Python 2.6 is not officially supported anymore.

    Features:

    • Add delimiters to displayed numbers. This can be configured via the config file. (Thanks: Sergii).
    • Fix broken ‘SHOW ALL’ in redshift. (Thanks: Manuel Barkhau).
    • Support configuring keyword casing preferences. (Thanks: Darik Gamble).
    • Add a new multi_line_mode option in config file. The values can be psql or safe. (Thanks: Joakim Koljonen) Setting multi_line_mode = safe will make sure that a query will only be executed when Alt+Enter is pressed.

    Bug Fixes:

    • Fix crash bug with leading parenthesis. (Thanks: Joakim Koljonen).
    • Remove cumulative addition of timing data. (Thanks: Amjith Ramanujam).
    • Handle unrecognized keywords gracefully. (Thanks: Darik Gamble)
    • Use raw strings in regex specifiers. This preemptively fixes a crash in Python 3.6. (Thanks Emanuele Gaifas)
  • Discovered at Sept. 3, 2016 Tweet
    Source: changelog.rst

    Features:

    • Add more specifiers to pgcli prompt. (Thanks: Julien Rouhaud).

      \p for port info \# for super user and \i for pid.

    • Add watch command to periodically execute a command. (Thanks: Stuart Quin).

      > SELECT * FROM django_migrations; \watch 1  /* Runs the command every second */

    • Add command-line option –single-connection to prevent pgcli from using multiple connections. (Thanks: Joakim Koljonen).

    • Add priority to the suggestions to sort based on relevance. (Thanks: Joakim Koljonen).

    • Configurable null format via the config file. (Thanks: Adrian Dries).

    • Add support for CTE aware auto-completion. (Thanks: Darik Gamble).

    • Add host and user information to default pgcli prompt. (Thanks: Lim H).

    • Better scoping for tables in insert statements to improve suggestions. (Thanks: Joakim Koljonen).

    Bug Fixes:

    • Do not install setproctitle on cygwin. (Thanks: Janus Troelsen).
    • Work around sqlparse crashing after AS keyword. (Thanks: Joakim Koljonen).
    • Fix a crashing bug with named queries. (Thanks: Joakim Koljonen).
    • Replace timestampz alias since AWS Redshift does not support it. (Thanks: Tahir Butt).
    • Prevent pgcli from hanging indefinitely when Postgres instance is not running. (Thanks: Darik Gamble)
  • Discovered at July 4, 2016 Tweet
    Source: changelog.rst

    Bugs:

    • Fix the crash at startup while parsing the postgres url with port number. (Thanks: Eric Wald)
    • Fix the crash with Redshift databases. (Thanks: Darik Gamble)
  • Discovered at June 29, 2016
    Source: changelog.rst

    Features:

    • Upgrade to prompt-toolkit 1.0.0. (Thanks: Jonathan Slenders).
    • Add support for o command to redirect query output to a file. (Thanks: Tim Sanders).
    • Add i path completion. (Thanks: Anthony Lai).
    • Connect to a dsn saved in config file. (Thanks: Rodrigo Ramírez Norambuena).
    • Upgrade sqlparse requirement to version 0.1.19. (Thanks: Fernando L. Canizo).
    • Add timestamptz to DATE custom extension. (Thanks: Fernando Mora).
    • Ensure target dir exists when copying config. (Thanks: David Szotten).
    • Handle dates that fall in the B.C. range. (Thanks: Stuart Quin).
    • Pager is selected from config file or else from environment variable. (Thanks: Fernando Mora).
    • Add support for Amazon Redshift. (Thanks: Timothy Cleaver).
    • Add support for Postgres 8.x. (Thanks: Timothy Cleaver and Darik Gamble)
    • Don’t error when completing parameter-less functions. (Thanks: David Szotten).
    • Concat and return all available notices. (Thanks: Stuart Quin).
    • Handle unicode in record type. (Thanks: Amjith Ramanujam).
    • Added humanized time display. Connect #396. (Thanks: Irina Truong).
    • Add EXPLAIN keyword to the completion list. (Thanks: Amjith Ramanujam).
    • Added sdist upload to release script. (Thanks: Irina Truong).
    • Sort completions based on most recently used. (Thanks: Darik Gamble)
    • Expand ‘*’ into column list during completion. This can be triggered by hitting <tab> after the ‘*’ character in the sql while typing. (Thanks: Joakim Koljonen)
    • Add a limit to the warning about too many rows. This is controlled by a new config value in ~/.config/pgcli/config. (Thanks: Anže Pečar)
    • Improved argument list in function parameter completions. (Thanks: Joakim Koljonen)
    • Column suggestions after the COLUMN keyword. (Thanks: Darik Gamble)
    • Filter out trigger implemented functions from the suggestion list. (Thanks: Daniel Rocco)
    • State of the art JOIN clause completions that suggest entire conditions. (Thanks: Joakim Koljonen)
    • Suggest fully formed JOIN clauses based on Foreign Key relations. (Thanks: Joakim Koljonen)
    • Add support for dx meta command to list the installed extensions. (Thanks: Darik Gamble)
    • Add support for copy command. (Thanks: Catherine Devlin)

    Bugs:

    • Fix bug where config writing would leave a ‘~’ dir. (Thanks: James Munson).
    • Fix auto-completion breaking for table names with caps. (Thanks: Anthony Lai).
    • Fix lexical ordering bug. (Thanks: Anthony Lai).
    • Use lexical order to break ties when fuzzy matching. (Thanks: Daniel Rocco).
    • Fix the bug in auto-expand mode when there are no rows to display. (Thanks: Amjith Ramanujam).
    • Fix broken i after #395. (Thanks: David Szotten).
    • Fix multi-way joins in auto-completion. (Thanks: Darik Gamble)
    • Display null values as <null> in expanded output. (Thanks: Amjith Ramanujam).
    • Robust support for Postgres version less than 9.x. (Thanks: Darik Gamble)

    Internal Changes:

    • Update config file location in README. (Thanks: Ari Summer).
    • Explicitly add wcwidth as a dependency. (Thanks: Amjith Ramanujam).
    • Add tests for the format_output. (Thanks: Amjith Ramanujam).
    • Lots of tests for pgcompleter. (Thanks: Darik Gamble).
    • Update pgspecial dependency to 1.4.0.
  • Discovered at June 29, 2016
    Source: changelog.rst
  • Discovered at Dec. 7, 2015
    Source: changelog.rst

    Features:

    • Perform auto-completion refresh in background. (Thanks: Amjith, Darik Gamble, Iryna Cherniavska). When the auto-completion entries are refreshed, the update now happens in a background thread. This means large databases with thousands of tables are handled without blocking.
    • Add CONCURRENTLY to keyword completion. (Thanks: Johannes Hoff).
    • Add support for \h command. (Thanks: Stuart Quin). This is a huge deal. Users can now get help on an SQL command by typing: \h COMMAND_NAME in the pgcli prompt.
    • Add support for \x auto. (Thanks: Stuart Quin). \\x auto will automatically switch to expanded mode if the output is wider than the display window.
    • Don’t hide functions from pg_catalog. (Thanks: Darik Gamble).
    • Suggest set-returning functions as tables. (Thanks: Darik Gamble). Functions that return table like results will now be suggested in places of tables.
    • Suggest fields from functions used as tables. (Thanks: Darik Gamble).
    • Using pgspecial as a separate module. (Thanks: Iryna Cherniavska).
    • Make “enter” key behave as “tab” key when the completion menu is displayed. (Thanks: Matheus Rosa).
    • Support different error-handling options when running multiple queries. (Thanks: Darik Gamble). When on_error = STOP in the config file, pgcli will abort execution if one of the queries results in an error.
    • Hide the password displayed in the process name in ps. (Thanks: Stuart Quin)

    Bug Fixes:

    • Fix the ordering bug in \d+ display, this bug was displaying the wrong table name in the reference. (Thanks: Tamas Boros).
    • Only show expanded layout if valid list of headers provided. (Thanks: Stuart Quin).
    • Fix suggestions in compound join clauses. (Thanks: Darik Gamble).
    • Fix completion refresh in multiple query scenario. (Thanks: Darik Gamble).
    • Fix the broken timing information.
    • Fix the removal of whitespaces in the output. (Thanks: Jacek Wielemborek)
    • Fix PyPI badge. (Thanks: Artur Dryomov).

    Improvements:

    • Move config file to ~/.config/pgcli/config instead of ~/.pgclirc (Thanks: inkn).
    • Move literal definitions to standalone JSON files. (Thanks: Darik Gamble).

    Internal Changes:

    • Improvements to integration tests to make it more robust. (Thanks: Iryna Cherniavska).
  • Discovered at Aug. 29, 2015
    Source: changelog.rst

    Features:

    • Autocompletion for database name in c and connect. (Thanks: Darik Gamble).
    • Improved multiline query support by correctly handling open quotes. (Thanks: Darik Gamble).
    • Added pager command.
    • Enhanced i to run multiple queries and display the results for each of them
    • Added keywords to suggestions after WHERE clause.
    • Enabled autocompletion in named queries. (Thanks: Iryna Cherniavska).
    • Path to .pgclirc can be specified in command line. (Thanks: Iryna Cherniavska).
    • Added support for pg_service_conf file. (Thanks: Iryna Cherniavska).
    • Added custom styles. (Contributor: Darik Gamble).

    BugFixes:

    • Fixed the completer crashing on invalid SQL. (Thanks: Darik Gamble).
    • Fixed unicode issues, updated tests and fixed broken tests.
  • Discovered at Aug. 4, 2015
    Source: changelog.rst

    BugFixes:

    • Fix an autocompletion bug that was crashing the completion engine when unknown keyword is entered. (Thanks: Darik Gamble)
  • Discovered at Aug. 3, 2015
    Source: changelog.rst

    Features:

    • Wider completion menus can be enabled via the config file. (Thanks: Jonathan Slenders)

      Open the config file (~/.pgclirc) and check if you have wider_completion_menu option available. If not add it in and set it to True.

    • Completion menu now has metadata information such as schema, table, column, view, etc., next to the suggestions. (Thanks: Darik Gamble)

    • Customizable history file location via config file. (Thanks: Çağatay Yüksel)

      Add this line to your config file (~/.pgclirc) to customize where to store the history file.

    • Add support for running queries from a file using \i special command. (Thanks: Michael Kaminsky)

    BugFixes:

    • Always use utf-8 for database encoding regardless of the default encoding used by the database.
    • Fix for None dereference on \d schemaname. with sequence. (Thanks: Nathan Jhaveri)
    • Fix a crashing bug in the autocompletion engine for some JOIN queries.
    • Handle KeyboardInterrupt in pager and not quit pgcli as a consequence.
  • Discovered at July 6, 2015
    Source: changelog.rst

    Features:

    • Add fuzzy matching for the table names and column names.

      Matching very long table/column names are now easier with fuzzy matching. The fuzzy match works like the fuzzy open in SublimeText or Vim’s Ctrl-P plugin.

      eg: Typing djmv will match django_migration_views since it is able to match parts of the input to the full table name.

    • Change the timing information to seconds.

      The Command Time and Format Time are now displayed in seconds instead of a unitless number displayed in scientific notation.

    • Support for named queries (favorite queries). (Thanks: Brett Atoms)

      Frequently typed queries can now be saved and recalled using a name using newly added special commands (\n[+], \ns, \nd).

      eg:

    # Save a query
    pgcli> \ns simple select * from foo
    saved
    
    # List all saved queries
    pgcli> \n+
    
    # Execute a saved query
    pgcli> \n simple
    
    # Delete a saved query
    pgcli> \nd simple
    
    • Pasting queries into the pgcli repl is orders of magnitude faster. (Thanks: Jonathan Slenders)
    • Add support for PGPASSWORD environment variable to pass the password for the postgres database. (Thanks: Iryna Cherniavska)
    • Add the ability to manually refresh autocompletions by typing \# or \refresh. This is useful if the database was updated by an external means and you’d like to refresh the auto-completions to pick up the new change.

    Bug Fixes:

    • Fix an error when running \d table_name when running on a table with rules. (Thanks: Ali Kargın)
    • Fix a pgcli crash when entering non-ascii characters in Windows. (Thanks: Darik Gamble, Jonathan Slenders)
    • Faster rendering of expanded mode output by making the horizontal separator a fixed length string.
    • Completion suggestions for the \c command are not auto-escaped by default.

    Internal Changes:

    • Complete refactor of handling the back-slash commands.
    • Upgrade prompt_toolkit to 0.42. (Thanks: Jonathan Slenders)
    • Change the config file management to use ConfigObj.(Thanks: Brett Atoms)
    • Add integration tests using behave. (Thanks: Iryna Cherniavska)
  • Discovered at June 4, 2015
    Source: changelog.rst

    Features:

    • Add support for auto-completing view names. (Thanks: Darik Gamble)
    • Add support for building RPM and DEB packages. (Thanks: dp)
    • Add subsequence matching for completion. (Thanks: Daniel Rocco) Previously completions only matched a table name if it started with the partially typed word. Now completions will match even if the partially typed word is in the middle of a suggestion. eg: When you type ‘mig’, ‘django_migrations’ will be suggested.
    • Completion for built-in tables and temporary tables are suggested after entering a prefix of pg_. (Thanks: Darik Gamble)
    • Add place holder doc strings for special commands that are planned for implementation. (Thanks: Iryna Cherniavska)
    • Updated version of prompt_toolkit, now matching braces are highlighted. (Thanks: Jonathan Slenders)
    • Added support of \\e command. Queries can be edited in an external editor. (Thanks: Iryna Cherniavska) eg: When you type SELECT * FROM \e it will be opened in an external editor.
    • Add special command \dT to show datatypes. (Thanks: Darik Gamble)
    • Add auto-completion support for datatypes in CREATE, SELECT etc. (Thanks: Darik Gamble)
    • Improve the auto-completion in WHERE clause with logical operators. (Thanks: Darik Gamble)

    Bug Fixes:

    • Fix the table formatting while printing multi-byte characters (Chinese, Japanese etc). (Thanks: 蔡佳男)
    • Fix a crash when pg_catalog was present in search path. (Thanks: Darik Gamble)
    • Fixed a bug that broke \e when prompt_tookit was updated. (Thanks: François Pietka)
    • Fix the display of triggers as shown in the \d output. (Thanks: Dimitar Roustchev)
    • Fix broken auto-completion for INNER JOIN, LEFT JOIN etc. (Thanks: Darik Gamble)
    • Fix incorrect super() calls in pgbuffer, pgtoolbar and pgcompleter. No change in functionality but protects against future problems. (Thanks: Daniel Rocco)
    • Add missing schema completion for CREATE and DROP statements. (Thanks: Darik Gamble)
    • Minor fixes around cursor cleanup.
  • Discovered at May 5, 2015
    Source: changelog.rst

    Bug Fixes:

    • Add more SQL keywords for auto-complete suggestion.
    • Messages raised as part of stored procedures are no longer ignored.
    • Use postgres flavored syntax highlighting instead of generic ANSI SQL.
  • Discovered at May 5, 2015
    Source: changelog.rst

    Bug Fixes:

    • Fix a bug where the schema qualifier was ignored by the auto-completion. As a result the suggestions for tables vs functions are cleaner. (Thanks: Darik Gamble)
    • Remove scientific notation when formatting large numbers. (Thanks: Daniel Rocco)
    • Add the FUNCTION keyword to auto-completion.
    • Display NULL values as <null> instead of empty strings.
    • Fix the completion refresh when \connect is executed.
  • Discovered at May 5, 2015
    Source: changelog.rst

    Bug Fixes:

    • Fix unicode issues with hstore.
    • Fix a silent error when database is changed using \c.
  • Discovered at May 5, 2015
    Source: changelog.rst

    Features:

    • Add ds special command to show sequences.
    • Add Vi mode for keybindings. This can be enabled by adding ‘vi = True’ in ~/.pgclirc. (Thanks: Jay Zeng)
    • Add a -v/–version flag to pgcli.
    • Add completion for TEMPLATE keyword and smart-completion for ‘CREATE DATABASE blah WITH TEMPLATE <tab>’. (Thanks: Daniel Rocco)
    • Add custom decoders to json/jsonb to emulate the behavior of psql. This removes the unicode prefix (eg: u’Éowyn’) in the output. (Thanks: Daniel Rocco)
    • Add df special command to show functions. (Thanks: Darik Gamble)
    • Make suggestions for special commands smarter. eg: dn - only suggests schemas. (Thanks: Darik Gamble)
    • Print out the version and other meta info about pgcli at startup.

    Bug Fixes:

    • Fix a rare crash caused by adding new schemas to a database. (Thanks: Darik Gamble)
    • Make dt command honor the explicit schema specified in the arg. (Thanks: Darik Gamble)
    • Print BIGSERIAL type as Integer instead of Float.
    • Show completions for special commands at the beginning of a statement. (Thanks: Daniel Rocco)
    • Allow special commands to work in a multi-statement case where multiple sql statements are separated by semi-colon in the same line.
  • Discovered at May 5, 2015
    Source: changelog.rst
    • Dummy version to replace accidental PyPI entry deletion.
  • Discovered at May 5, 2015
    Source: changelog.rst
    • Override the LESS options completely instead of appending to it.
  • Discovered at May 5, 2015
    Source: changelog.rst
    • Revert back to using psycopg2 as the postgres adapter. psycopg2cffi fails for some tests in Python 3.
  • Discovered at May 5, 2015
    Source: changelog.rst

    Features:

    • Add syntax color styles to config.
    • Add auto-completion for COPY statements.
    • Change Postgres adapter to psycopg2cffi, to make it PyPy compatible. Now pgcli can be run by PyPy.

    Bug Fixes:

    • Treat boolean values as strings instead of ints.
    • Make di, dv and dt to be schema aware. (Thanks: Darik Gamble)
    • Make column name display unicode compatible.
  • Discovered at May 5, 2015
    Source: changelog.rst

    Features:

    • Add alias completion support to ON keyword. (Thanks: Iryna Cherniavska)
    • Add LIMIT keyword to completion.
    • Auto-completion for Postgres schemas. (Thanks: Darik Gamble)
    • Better unicode handling for datatypes, dbname and roles.
    • Add timing command to time the sql commands. This can be set via config file (~/.pgclirc) using timing = True.
    • Add different table styles for displaying output. This can be changed via config file (~/.pgclirc) using table_format = fancy_grid.
    • Add confirmation before printing results that have more than 1000 rows.

    Bug Fixes:

    • Performance improvements to expanded view display (x).
    • Cast bytea files to text while displaying. (Thanks: Daniel Rocco)
    • Added a list of reserved words that should be auto-escaped.
    • Auto-completion is now case-insensitive.
    • Fix the broken completion for multiple sql statements. (Thanks: Darik Gamble)
  • Discovered at May 5, 2015
    Source: changelog.rst

    Features:

    • Add -d/–dbname option to the commandline. eg: pgcli -d database
    • Add the username as an argument after the database. eg: pgcli dbname user

    Bug Fixes:

    • Fix the crash when c fails.
    • Fix the error thrown by d when triggers are present.
    • Fix broken behavior on ?. (Thanks: Darik Gamble)
  • Discovered at May 5, 2015
    Source: changelog.rst

    Features:

    • Upgrade to prompt_toolkit version 0.26 (Thanks: https://github.com/macobo) * Adds Ctrl-left/right to move the cursor one word left/right respectively. * Internal API changes.
    • IPython integration through ipython-sql (Thanks: Darik Gamble) * Add an ipython magic extension to embed pgcli inside ipython. * Results from a pgcli query are sent back to ipython.
    • Multiple sql statments in the same line separated by semi-colon. (Thanks: https://github.com/macobo)

    Bug Fixes:

    • Fix ‘message’ attribute not found exception in Python 3. (Thanks: https://github.com/GMLudo)
    • Use the database username as the database name instead of defaulting to OS username. (Thanks: https://github.com/fpietka)
    • Auto-completion for auto-escaped column/table names.
    • Fix i-reverse-search to work in prompt_toolkit version 0.26.
  • Discovered at May 5, 2015
    Source: changelog.rst


Лучшая Python рассылка

Нас поддерживает


Python Software Foundation



Разместим вашу рекламу

Пиши: mail@pythondigest.ru

Нашли опечатку?

Выделите фрагмент и отправьте нажатием Ctrl+Enter.

Система Orphus