| Fri, 25 Jul 2014 15:15:16 +0200 |
Radek Brich |
Fix autocommit mode in oursql.
default tip
|
changeset |
files
|
| Wed, 09 Jul 2014 18:04:11 +0200 |
Radek Brich |
Move batchquery, listtables tools under pgtool.
|
changeset |
files
|
| Wed, 09 Jul 2014 18:03:54 +0200 |
Radek Brich |
Rename to pydbkit.
|
changeset |
files
|
| Mon, 26 May 2014 18:18:21 +0200 |
Radek Brich |
Update bigtables tool: Sort by size with indexes, not just data.
|
changeset |
files
|
| Wed, 07 May 2014 18:33:50 +0200 |
Radek Brich |
Update ToolBase: Load cascade of config files, add -c parameter.
|
changeset |
files
|
| Tue, 06 May 2014 18:37:43 +0200 |
Radek Brich |
Refactor ToolBase to allow tool composition. Add TableSync tool (composited). Move more tools under pgtool.
|
changeset |
files
|
| Tue, 06 May 2014 18:37:41 +0200 |
Radek Brich |
Add pgtool wrapper for all tools. Only this script will be installed into system bin.
|
changeset |
files
|
| Tue, 06 May 2014 18:34:38 +0200 |
Radek Brich |
Update runquery tool: Add --one-query-per-line parameter.
|
changeset |
files
|
| Tue, 29 Apr 2014 17:50:15 +0200 |
Radek Brich |
Update batchcopy: When target record exists, allow to ignore / update the error (--dst-exists parameter).
|
changeset |
files
|
| Mon, 14 Apr 2014 22:28:12 +0200 |
Radek Brich |
Add batchcopy tool.
|
changeset |
files
|
| Mon, 14 Apr 2014 22:28:12 +0200 |
Radek Brich |
Update tablecopy tool: Add --disable-triggers option.
|
changeset |
files
|
| Thu, 20 Mar 2014 16:33:34 +0100 |
Radek Brich |
Update bigtables tool: Add size of indexes.
|
changeset |
files
|
| Tue, 04 Feb 2014 16:10:04 +0100 |
Radek Brich |
PgDiff: Add patch support for SQL functions.
|
changeset |
files
|
| Tue, 10 Dec 2013 11:39:57 +0100 |
Radek Brich |
Change python3.2 to python3 in scripts.
|
changeset |
files
|
| Mon, 09 Dec 2013 13:57:31 +0100 |
Radek Brich |
Fix.
|
changeset |
files
|
| Mon, 09 Dec 2013 11:39:28 +0100 |
Radek Brich |
Add to runquery tool: Parameters for query, output file and format for output file. Fix loopquery tool.
|
changeset |
files
|
| Fri, 04 Oct 2013 16:38:24 +0200 |
Radek Brich |
Update runquery: Add parameter to read queries from file.
|
changeset |
files
|
| Fri, 04 Oct 2013 16:37:29 +0200 |
Radek Brich |
Fix PgManager logging.
|
changeset |
files
|
| Tue, 24 Sep 2013 13:34:17 +0200 |
Radek Brich |
Update analyzeall tool: Allow combination of vacuum and reindex.
|
changeset |
files
|
| Tue, 24 Sep 2013 13:34:15 +0200 |
Radek Brich |
PgDiff: Add support for indexes.
|
changeset |
files
|
| Fri, 16 Aug 2013 13:19:26 +0200 |
Radek Brich |
Fix: ConfigParser add_argument -> add_option.
|
changeset |
files
|
| Thu, 08 Aug 2013 15:26:24 +0200 |
Radek Brich |
Add basic support for types in browser and schema diff.
|
changeset |
files
|
| Wed, 24 Jul 2013 13:11:37 +0200 |
Radek Brich |
Fix.
|
changeset |
files
|
| Sat, 13 Apr 2013 15:22:05 +0200 |
Radek Brich |
Add dependency on pycolib. Move common modules to pycolib. Add example table schema for meta DB.
|
changeset |
files
|
| Wed, 10 Apr 2013 11:22:15 +0200 |
Radek Brich |
Bump version.
|
changeset |
files
|
| Wed, 03 Apr 2013 15:57:36 +0200 |
Radek Brich |
PgManager: Update RowDict, add write support.
|
changeset |
files
|
| Thu, 21 Mar 2013 17:40:11 +0100 |
Radek Brich |
PgManager: add support for str, repr of RowDict.
|
changeset |
files
|
| Tue, 19 Mar 2013 16:46:36 +0100 |
Radek Brich |
Update PgManager doc.
|
changeset |
files
|
| Tue, 19 Mar 2013 16:45:37 +0100 |
Radek Brich |
Rename config module to configparser.
|
changeset |
files
|
| Fri, 15 Mar 2013 15:13:42 +0100 |
Radek Brich |
PgManager, MyManager: Change log level of SQL queries to debug. Fix MyManager: Wrong query logged when exception occurs.
|
changeset |
files
|
| Sun, 10 Mar 2013 16:14:53 +0100 |
Radek Brich |
Port pgconsole to Python3 + GTK3.
|
changeset |
files
|
| Thu, 07 Mar 2013 18:26:52 +0100 |
Radek Brich |
MyManager: Add Cursor.mogrify(). Fix query logging. Update tests.
|
changeset |
files
|
| Thu, 07 Mar 2013 15:42:47 +0100 |
Radek Brich |
Fix MyManager.
|
changeset |
files
|
| Tue, 05 Mar 2013 13:47:32 +0100 |
Radek Brich |
Update longqueries tool: add --age parameter.
|
changeset |
files
|
| Tue, 05 Mar 2013 11:27:34 +0100 |
Radek Brich |
Update browser tool to work with current Tuikit. Add RPM's BuildRequires to setup.cfg.
|
changeset |
files
|
| Tue, 05 Mar 2013 11:24:47 +0100 |
Radek Brich |
Update MyManager.
|
changeset |
files
|
| Mon, 04 Mar 2013 15:39:34 +0100 |
Radek Brich |
Update docs.
|
changeset |
files
|
| Thu, 28 Feb 2013 12:55:25 +0100 |
Radek Brich |
Add doc for PgManager.
|
changeset |
files
|
| Tue, 26 Feb 2013 14:40:39 +0100 |
Radek Brich |
Add listtables tool.
|
changeset |
files
|
| Fri, 15 Feb 2013 16:38:23 +0100 |
Radek Brich |
Add runquery tool. Update setup.py.
|
changeset |
files
|
| Wed, 13 Feb 2013 15:30:37 +0100 |
Radek Brich |
Fix loopquery timing.
|
changeset |
files
|
| Tue, 05 Feb 2013 11:26:18 +0100 |
Radek Brich |
Update loopquery tool.
|
changeset |
files
|
| Thu, 31 Jan 2013 13:41:48 +0100 |
Radek Brich |
Drop colordiff, implement it in PgDiff directly.
|
changeset |
files
|
| Thu, 31 Jan 2013 13:24:57 +0100 |
Radek Brich |
PgDiff, schemadiff.py: Add function filter. Add --body parameter to diff function source.
|
changeset |
files
|
| Thu, 31 Jan 2013 11:02:04 +0100 |
Radek Brich |
Update loopquery: allow any number of queries, support reading parameters from config file.
|
changeset |
files
|
| Fri, 25 Jan 2013 18:04:17 +0100 |
Radek Brich |
PgDiff: check schema existance.
|
changeset |
files
|
| Fri, 25 Jan 2013 17:44:49 +0100 |
Radek Brich |
PgDiff: Update patch for table column changed.
|
changeset |
files
|
| Fri, 25 Jan 2013 17:06:54 +0100 |
Radek Brich |
PgBrowser: add function arguments as another level in hierarchy. PgDiff: compare function arguments one by one.
|
changeset |
files
|
| Thu, 24 Jan 2013 17:11:17 +0100 |
Radek Brich |
PgBrowser: Add functions. PgDiff: Compare functions.
|
changeset |
files
|
| Mon, 17 Dec 2012 21:12:04 +0100 |
Radek Brich |
Update browser tool: Add Schemas and Tables nodes, populate nodes when expanded.
|
changeset |
files
|
| Mon, 17 Dec 2012 16:48:12 +0100 |
Radek Brich |
Add reverse parameter for diff tools.
|
changeset |
files
|
| Thu, 13 Dec 2012 17:15:10 +0100 |
Radek Brich |
Fix PgDataDiff.
|
changeset |
files
|
| Thu, 13 Dec 2012 16:07:13 +0100 |
Radek Brich |
Fix PgDataDiff.
|
changeset |
files
|
| Tue, 11 Dec 2012 11:25:06 +0100 |
Radek Brich |
Update PgDiff: Support SQL patch for constraints. Fix changes of column default value.
|
changeset |
files
|
| Tue, 11 Dec 2012 10:49:42 +0100 |
Radek Brich |
Update analyzeall tool: add REINDEX option. Add ibrowser tool (useful for PgBrowser testing). Fix PgBrowser.list_columns default value.
|
changeset |
files
|
| Fri, 05 Oct 2012 14:31:25 +0200 |
Radek Brich |
Add loopquery tool. Log notices to console from all tools (toolbase).
|
changeset |
files
|
| Sat, 29 Sep 2012 14:01:47 +0200 |
Radek Brich |
Add test_prettysize to tests.py.
|
changeset |
files
|
| Sat, 29 Sep 2012 13:53:54 +0200 |
Radek Brich |
Add test for MyManager (enable only when MySQLdb is available). Configure tests using pgtoolkit.conf (same as used by other executables).
|
changeset |
files
|
| Sat, 29 Sep 2012 12:08:47 +0200 |
Radek Brich |
PgManager: Fix logging, log queries before executing, possible exceptions are logged after. Add tests for RowDict. Add tests.py - runs all tests.
|
changeset |
files
|
| Wed, 26 Sep 2012 23:32:02 +0200 |
Radek Brich |
PgDiff: add partial support for SQL patch.
|
changeset |
files
|
| Wed, 26 Sep 2012 23:29:54 +0200 |
Radek Brich |
Fix query logging.
|
changeset |
files
|
| Wed, 26 Sep 2012 16:43:53 +0200 |
Radek Brich |
Fix.
|
changeset |
files
|
| Wed, 26 Sep 2012 16:28:28 +0200 |
Radek Brich |
Update longqueries tool: add client IP, waiting attributes.
|
changeset |
files
|
| Wed, 26 Sep 2012 16:21:59 +0200 |
Radek Brich |
PgManager: rewrite RowDict class.
|
changeset |
files
|
| Wed, 26 Sep 2012 16:20:26 +0200 |
Radek Brich |
PgManager: update comments.
|
changeset |
files
|
| Fri, 17 Aug 2012 11:14:31 +0200 |
Radek Brich |
PgDataDiff: Fix sorting - do not adapt primary key before sort condition.
|
changeset |
files
|
| Fri, 17 Aug 2012 11:07:22 +0200 |
Radek Brich |
Add listserial tool. PgBrowser: Add list_sequences.
|
changeset |
files
|
| Mon, 09 Jul 2012 10:29:47 +0200 |
Radek Brich |
Fixes.
|
changeset |
files
|
| Thu, 31 May 2012 11:28:41 +0200 |
Radek Brich |
Update bigtables tool: scan all schemas.
|
changeset |
files
|
| Wed, 23 May 2012 16:02:53 +0200 |
Radek Brich |
Fixes.
|
changeset |
files
|
| Wed, 23 May 2012 11:11:16 +0200 |
Radek Brich |
pgmanager: Add create_conn_listen() which should be used with wait_for_notify. Update wait_for_notify() to not use put_conn(). Add name to ConnectionInfo. Log queries before they are called. Log exceptions. Add notifyexample.
|
changeset |
files
|
| Fri, 11 May 2012 14:16:36 +0200 |
Radek Brich |
TableCopyTool: order tables with respect to references.
|
changeset |
files
|
| Thu, 10 May 2012 08:42:21 +0200 |
Radek Brich |
Add PgDataCopy. Add TableCopyTool.Add SrcDstTablesTool class to toolbase, use in tablecopy, tablediff.
|
changeset |
files
|
| Wed, 28 Mar 2012 17:25:18 +0200 |
Radek Brich |
PgManager: log connection name with queries. BatchUpdateTool: handle some possible exceptions and try reconnect to database.
|
changeset |
files
|
| Fri, 23 Mar 2012 14:54:04 +0100 |
Radek Brich |
Add batchupdate tool. PgBrowser: add constraints to list_column_usage().
|
changeset |
files
|
| Mon, 05 Mar 2012 18:36:46 +0100 |
Radek Brich |
Add browser - database schema browser using tuikit (curses UI). Add listdepends - tool which shows depending views for column. Update pgdatadiff - allow composite primary key. Update pgmanager - RowDict is now OrderedDict. Drop support for Python2.x.
|
changeset |
files
|
| Mon, 27 Feb 2012 15:12:40 +0100 |
Radek Brich |
Fix analyzeall tool. Add user output formating to batchquery tool. Add isolation_level setting support to ToolBase.
|
changeset |
files
|
| Tue, 14 Feb 2012 18:15:56 +0100 |
Radek Brich |
Add batchquery tool.
|
changeset |
files
|
| Tue, 07 Feb 2012 11:32:07 +0100 |
Radek Brich |
analyzeall: analyze tables from all schemas by default
|
changeset |
files
|
| Tue, 07 Feb 2012 10:40:35 +0100 |
Radek Brich |
Add analyzeall tool. Updates, fixes.
|
changeset |
files
|
| Fri, 13 Jan 2012 15:49:24 +0100 |
Radek Brich |
Add logging mechanism for notices from postgres server. Rename SQL log to "pgmanager_sql".
|
changeset |
files
|
| Thu, 15 Dec 2011 18:26:04 +0100 |
Radek Brich |
Fix bad name.
|
changeset |
files
|
| Thu, 15 Dec 2011 18:21:41 +0100 |
Radek Brich |
PgManager: Add partial support for multiprocessing.
|
changeset |
files
|
| Wed, 14 Dec 2011 16:29:33 +0100 |
Radek Brich |
Add keep_open parameter to create_conn.
|
changeset |
files
|
| Tue, 06 Dec 2011 17:11:21 +0100 |
Radek Brich |
Add test for PgManager.
|
changeset |
files
|
| Tue, 06 Dec 2011 16:45:29 +0100 |
Radek Brich |
Add test for delayedquery.
|
changeset |
files
|
| Tue, 06 Dec 2011 16:20:53 +0100 |
Radek Brich |
PgManager: Do not add NullHandler to logger. Rewrite get_instance(). ToolBase: fix prepare_conns() method.
|
changeset |
files
|
| Sun, 27 Nov 2011 17:02:42 +0100 |
Radek Brich |
Add documentation for create_conn(). Fix keep_alive - do not crash if socket settings are not supported.
|
changeset |
files
|
| Fri, 25 Nov 2011 18:17:27 +0100 |
Radek Brich |
Fix MyManager. Add patch for MySQLdb and Python3.2. Add DelayedQuery.
|
changeset |
files
|
| Mon, 21 Nov 2011 10:47:24 +0100 |
Radek Brich |
ToolBase - implement 'database' config option.
|
changeset |
files
|
| Mon, 21 Nov 2011 10:43:37 +0100 |
Radek Brich |
MyManager - create_conn() - allow same parameters as for PgManager.
|
changeset |
files
|
| Mon, 14 Nov 2011 18:00:53 +0100 |
Radek Brich |
Add MyManager - replica of PgManager for MySQLdb. Intentionally not inherited from common base class.
|
changeset |
files
|
| Thu, 20 Oct 2011 13:54:35 +0200 |
Radek Brich |
TableDiffTool: add arguments to set different destination schema and table. PgDataDiff: fixes.
|
changeset |
files
|
| Fri, 09 Sep 2011 11:56:37 +0200 |
Radek Brich |
ToolBase: add -d parameter, which triggers debug mode (print SQL queries).
|
changeset |
files
|
| Tue, 06 Sep 2011 17:55:15 +0200 |
Radek Brich |
Fix pgdatadiff.
|
changeset |
files
|
| Fri, 19 Aug 2011 17:08:34 +0200 |
Radek Brich |
PgConsole: add app.py, splitted from pgconsole.py.
|
changeset |
files
|
| Tue, 16 Aug 2011 23:53:54 +0200 |
Radek Brich |
Added pgconsole. It is my older project, a GUI query console. It uses GTK+ and asynchronous queries.
|
changeset |
files
|
| Tue, 16 Aug 2011 16:03:46 +0200 |
Radek Brich |
Reorganize again :-) Add setup.py.
|
changeset |
files
|
| Tue, 16 Aug 2011 15:12:53 +0200 |
Radek Brich |
pgmanager: Add keep_alive support.
|
changeset |
files
|
| Fri, 12 Aug 2011 14:39:49 +0200 |
Radek Brich |
Reorganize directories. PgDataDiff - reworked. PgManager - add fetchone_adapted, fetchall_adapted to cursor.
|
changeset |
files
|
| Wed, 10 Aug 2011 18:34:54 +0200 |
Radek Brich |
Add table diff tool.
|
changeset |
files
|
| Wed, 20 Jul 2011 10:54:07 +0200 |
Radek Brich |
Clean up tools.
|
changeset |
files
|
| Wed, 20 Jul 2011 10:51:18 +0200 |
Radek Brich |
Merge.
|
changeset |
files
|
| Tue, 19 Jul 2011 14:36:33 +0200 |
Radek Brich |
pgmanager: fix logging of queries
|
changeset |
files
|
| Mon, 18 Jul 2011 17:39:37 +0200 |
Radek Brich |
Fix pgmanager exceptions.
|
changeset |
files
|
| Wed, 01 Jun 2011 11:48:07 +0200 |
Radek Brich |
Fix pgmanager logging in Python3.
|
changeset |
files
|
| Thu, 26 May 2011 18:09:05 +0200 |
Radek Brich |
Postgres tools.
|
changeset |
files
|