Wed, 24 Jul 2013 13:11:37 +0200 Fix.
Radek Brich <radek.brich@devl.cz> [Wed, 24 Jul 2013 13:11:37 +0200] rev 84
Fix.
Sat, 13 Apr 2013 15:22:05 +0200 Add dependency on pycolib. Move common modules to pycolib. Add example table schema for meta DB.
Radek Brich <radek.brich@devl.cz> [Sat, 13 Apr 2013 15:22:05 +0200] rev 83
Add dependency on pycolib. Move common modules to pycolib. Add example table schema for meta DB.
Wed, 10 Apr 2013 11:22:15 +0200 Bump version.
Radek Brich <brich.radek@ifortuna.cz> [Wed, 10 Apr 2013 11:22:15 +0200] rev 82
Bump version.
Wed, 03 Apr 2013 15:57:36 +0200 PgManager: Update RowDict, add write support.
Radek Brich <radek.brich@devl.cz> [Wed, 03 Apr 2013 15:57:36 +0200] rev 81
PgManager: Update RowDict, add write support.
Thu, 21 Mar 2013 17:40:11 +0100 PgManager: add support for str, repr of RowDict.
Radek Brich <radek.brich@devl.cz> [Thu, 21 Mar 2013 17:40:11 +0100] rev 80
PgManager: add support for str, repr of RowDict.
Tue, 19 Mar 2013 16:46:36 +0100 Update PgManager doc.
Radek Brich <radek.brich@devl.cz> [Tue, 19 Mar 2013 16:46:36 +0100] rev 79
Update PgManager doc.
Tue, 19 Mar 2013 16:45:37 +0100 Rename config module to configparser.
Radek Brich <radek.brich@devl.cz> [Tue, 19 Mar 2013 16:45:37 +0100] rev 78
Rename config module to configparser.
Fri, 15 Mar 2013 15:13:42 +0100 PgManager, MyManager: Change log level of SQL queries to debug. Fix MyManager: Wrong query logged when exception occurs.
Radek Brich <radek.brich@devl.cz> [Fri, 15 Mar 2013 15:13:42 +0100] rev 77
PgManager, MyManager: Change log level of SQL queries to debug. Fix MyManager: Wrong query logged when exception occurs.
Sun, 10 Mar 2013 16:14:53 +0100 Port pgconsole to Python3 + GTK3.
Radek Brich <radek.brich@devl.cz> [Sun, 10 Mar 2013 16:14:53 +0100] rev 76
Port pgconsole to Python3 + GTK3.
Thu, 07 Mar 2013 18:26:52 +0100 MyManager: Add Cursor.mogrify(). Fix query logging. Update tests.
Radek Brich <radek.brich@devl.cz> [Thu, 07 Mar 2013 18:26:52 +0100] rev 75
MyManager: Add Cursor.mogrify(). Fix query logging. Update tests.
Thu, 07 Mar 2013 15:42:47 +0100 Fix MyManager.
Radek Brich <radek.brich@devl.cz> [Thu, 07 Mar 2013 15:42:47 +0100] rev 74
Fix MyManager.
Tue, 05 Mar 2013 13:47:32 +0100 Update longqueries tool: add --age parameter.
Radek Brich <radek.brich@devl.cz> [Tue, 05 Mar 2013 13:47:32 +0100] rev 73
Update longqueries tool: add --age parameter.
Tue, 05 Mar 2013 11:27:34 +0100 Update browser tool to work with current Tuikit. Add RPM's BuildRequires to setup.cfg.
Radek Brich <radek.brich@devl.cz> [Tue, 05 Mar 2013 11:27:34 +0100] rev 72
Update browser tool to work with current Tuikit. Add RPM's BuildRequires to setup.cfg.
Tue, 05 Mar 2013 11:24:47 +0100 Update MyManager.
Radek Brich <radek.brich@devl.cz> [Tue, 05 Mar 2013 11:24:47 +0100] rev 71
Update MyManager.
Mon, 04 Mar 2013 15:39:34 +0100 Update docs.
Radek Brich <radek.brich@devl.cz> [Mon, 04 Mar 2013 15:39:34 +0100] rev 70
Update docs.
Thu, 28 Feb 2013 12:55:25 +0100 Add doc for PgManager.
Radek Brich <radek.brich@devl.cz> [Thu, 28 Feb 2013 12:55:25 +0100] rev 69
Add doc for PgManager.
Tue, 26 Feb 2013 14:40:39 +0100 Add listtables tool.
Radek Brich <radek.brich@devl.cz> [Tue, 26 Feb 2013 14:40:39 +0100] rev 68
Add listtables tool.
Fri, 15 Feb 2013 16:38:23 +0100 Add runquery tool. Update setup.py.
Radek Brich <radek.brich@devl.cz> [Fri, 15 Feb 2013 16:38:23 +0100] rev 67
Add runquery tool. Update setup.py.
Wed, 13 Feb 2013 15:30:37 +0100 Fix loopquery timing.
Radek Brich <radek.brich@devl.cz> [Wed, 13 Feb 2013 15:30:37 +0100] rev 66
Fix loopquery timing.
Tue, 05 Feb 2013 11:26:18 +0100 Update loopquery tool.
Radek Brich <radek.brich@devl.cz> [Tue, 05 Feb 2013 11:26:18 +0100] rev 65
Update loopquery tool.
Thu, 31 Jan 2013 13:41:48 +0100 Drop colordiff, implement it in PgDiff directly.
Radek Brich <radek.brich@devl.cz> [Thu, 31 Jan 2013 13:41:48 +0100] rev 64
Drop colordiff, implement it in PgDiff directly.
Thu, 31 Jan 2013 13:24:57 +0100 PgDiff, schemadiff.py: Add function filter. Add --body parameter to diff function source.
Radek Brich <radek.brich@devl.cz> [Thu, 31 Jan 2013 13:24:57 +0100] rev 63
PgDiff, schemadiff.py: Add function filter. Add --body parameter to diff function source.
Thu, 31 Jan 2013 11:02:04 +0100 Update loopquery: allow any number of queries, support reading parameters from config file.
Radek Brich <radek.brich@devl.cz> [Thu, 31 Jan 2013 11:02:04 +0100] rev 62
Update loopquery: allow any number of queries, support reading parameters from config file.
Fri, 25 Jan 2013 18:04:17 +0100 PgDiff: check schema existance.
Radek Brich <radek.brich@devl.cz> [Fri, 25 Jan 2013 18:04:17 +0100] rev 61
PgDiff: check schema existance.
Fri, 25 Jan 2013 17:44:49 +0100 PgDiff: Update patch for table column changed.
Radek Brich <radek.brich@devl.cz> [Fri, 25 Jan 2013 17:44:49 +0100] rev 60
PgDiff: Update patch for table column changed.
Fri, 25 Jan 2013 17:06:54 +0100 PgBrowser: add function arguments as another level in hierarchy. PgDiff: compare function arguments one by one.
Radek Brich <radek.brich@devl.cz> [Fri, 25 Jan 2013 17:06:54 +0100] rev 59
PgBrowser: add function arguments as another level in hierarchy. PgDiff: compare function arguments one by one.
Thu, 24 Jan 2013 17:11:17 +0100 PgBrowser: Add functions. PgDiff: Compare functions.
Radek Brich <radek.brich@devl.cz> [Thu, 24 Jan 2013 17:11:17 +0100] rev 58
PgBrowser: Add functions. PgDiff: Compare functions.
Mon, 17 Dec 2012 21:12:04 +0100 Update browser tool: Add Schemas and Tables nodes, populate nodes when expanded.
Radek Brich <radek.brich@devl.cz> [Mon, 17 Dec 2012 21:12:04 +0100] rev 57
Update browser tool: Add Schemas and Tables nodes, populate nodes when expanded.
Mon, 17 Dec 2012 16:48:12 +0100 Add reverse parameter for diff tools.
Radek Brich <radek.brich@devl.cz> [Mon, 17 Dec 2012 16:48:12 +0100] rev 56
Add reverse parameter for diff tools.
Thu, 13 Dec 2012 17:15:10 +0100 Fix PgDataDiff.
Radek Brich <radek.brich@devl.cz> [Thu, 13 Dec 2012 17:15:10 +0100] rev 55
Fix PgDataDiff.
Thu, 13 Dec 2012 16:07:13 +0100 Fix PgDataDiff.
Radek Brich <radek.brich@devl.cz> [Thu, 13 Dec 2012 16:07:13 +0100] rev 54
Fix PgDataDiff.
Tue, 11 Dec 2012 11:25:06 +0100 Update PgDiff: Support SQL patch for constraints. Fix changes of column default value.
Radek Brich <radek.brich@devl.cz> [Tue, 11 Dec 2012 11:25:06 +0100] rev 53
Update PgDiff: Support SQL patch for constraints. Fix changes of column default value.
Tue, 11 Dec 2012 10:49:42 +0100 Update analyzeall tool: add REINDEX option. Add ibrowser tool (useful for PgBrowser testing). Fix PgBrowser.list_columns default value.
Radek Brich <radek.brich@devl.cz> [Tue, 11 Dec 2012 10:49:42 +0100] rev 52
Update analyzeall tool: add REINDEX option. Add ibrowser tool (useful for PgBrowser testing). Fix PgBrowser.list_columns default value.
Fri, 05 Oct 2012 14:31:25 +0200 Add loopquery tool. Log notices to console from all tools (toolbase).
Radek Brich <radek.brich@devl.cz> [Fri, 05 Oct 2012 14:31:25 +0200] rev 51
Add loopquery tool. Log notices to console from all tools (toolbase).
Sat, 29 Sep 2012 14:01:47 +0200 Add test_prettysize to tests.py.
Radek Brich <radek.brich@devl.cz> [Sat, 29 Sep 2012 14:01:47 +0200] rev 50
Add test_prettysize to tests.py.
Sat, 29 Sep 2012 13:53:54 +0200 Add test for MyManager (enable only when MySQLdb is available). Configure tests using pgtoolkit.conf (same as used by other executables).
Radek Brich <radek.brich@devl.cz> [Sat, 29 Sep 2012 13:53:54 +0200] rev 49
Add test for MyManager (enable only when MySQLdb is available). Configure tests using pgtoolkit.conf (same as used by other executables).
Sat, 29 Sep 2012 12:08:47 +0200 PgManager: Fix logging, log queries before executing, possible exceptions are logged after. Add tests for RowDict. Add tests.py - runs all tests.
Radek Brich <radek.brich@devl.cz> [Sat, 29 Sep 2012 12:08:47 +0200] rev 48
PgManager: Fix logging, log queries before executing, possible exceptions are logged after. Add tests for RowDict. Add tests.py - runs all tests.
Wed, 26 Sep 2012 23:32:02 +0200 PgDiff: add partial support for SQL patch.
Radek Brich <radek.brich@devl.cz> [Wed, 26 Sep 2012 23:32:02 +0200] rev 47
PgDiff: add partial support for SQL patch.
Wed, 26 Sep 2012 23:29:54 +0200 Fix query logging.
Radek Brich <radek.brich@devl.cz> [Wed, 26 Sep 2012 23:29:54 +0200] rev 46
Fix query logging.
Wed, 26 Sep 2012 16:43:53 +0200 Fix.
Radek Brich <radek.brich@devl.cz> [Wed, 26 Sep 2012 16:43:53 +0200] rev 45
Fix.
Wed, 26 Sep 2012 16:28:28 +0200 Update longqueries tool: add client IP, waiting attributes.
Radek Brich <radek.brich@devl.cz> [Wed, 26 Sep 2012 16:28:28 +0200] rev 44
Update longqueries tool: add client IP, waiting attributes.
Wed, 26 Sep 2012 16:21:59 +0200 PgManager: rewrite RowDict class.
Radek Brich <radek.brich@devl.cz> [Wed, 26 Sep 2012 16:21:59 +0200] rev 43
PgManager: rewrite RowDict class.
Wed, 26 Sep 2012 16:20:26 +0200 PgManager: update comments.
Radek Brich <radek.brich@devl.cz> [Wed, 26 Sep 2012 16:20:26 +0200] rev 42
PgManager: update comments.
Fri, 17 Aug 2012 11:14:31 +0200 PgDataDiff: Fix sorting - do not adapt primary key before sort condition.
Radek Brich <radek.brich@devl.cz> [Fri, 17 Aug 2012 11:14:31 +0200] rev 41
PgDataDiff: Fix sorting - do not adapt primary key before sort condition.
Fri, 17 Aug 2012 11:07:22 +0200 Add listserial tool. PgBrowser: Add list_sequences.
Radek Brich <radek.brich@devl.cz> [Fri, 17 Aug 2012 11:07:22 +0200] rev 40
Add listserial tool. PgBrowser: Add list_sequences.
Mon, 09 Jul 2012 10:29:47 +0200 Fixes.
Radek Brich <radek.brich@devl.cz> [Mon, 09 Jul 2012 10:29:47 +0200] rev 39
Fixes.
Thu, 31 May 2012 11:28:41 +0200 Update bigtables tool: scan all schemas.
Radek Brich <radek.brich@devl.cz> [Thu, 31 May 2012 11:28:41 +0200] rev 38
Update bigtables tool: scan all schemas.
Wed, 23 May 2012 16:02:53 +0200 Fixes.
Radek Brich <radek.brich@devl.cz> [Wed, 23 May 2012 16:02:53 +0200] rev 37
Fixes.
Wed, 23 May 2012 11:11:16 +0200 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.
Radek Brich <radek.brich@devl.cz> [Wed, 23 May 2012 11:11:16 +0200] rev 36
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.
Fri, 11 May 2012 14:16:36 +0200 TableCopyTool: order tables with respect to references.
Radek Brich <radek.brich@devl.cz> [Fri, 11 May 2012 14:16:36 +0200] rev 35
TableCopyTool: order tables with respect to references.
Thu, 10 May 2012 08:42:21 +0200 Add PgDataCopy. Add TableCopyTool.Add SrcDstTablesTool class to toolbase, use in tablecopy, tablediff.
Radek Brich <radek.brich@devl.cz> [Thu, 10 May 2012 08:42:21 +0200] rev 34
Add PgDataCopy. Add TableCopyTool.Add SrcDstTablesTool class to toolbase, use in tablecopy, tablediff.
Wed, 28 Mar 2012 17:25:18 +0200 PgManager: log connection name with queries. BatchUpdateTool: handle some possible exceptions and try reconnect to database.
Radek Brich <radek.brich@devl.cz> [Wed, 28 Mar 2012 17:25:18 +0200] rev 33
PgManager: log connection name with queries. BatchUpdateTool: handle some possible exceptions and try reconnect to database.
Fri, 23 Mar 2012 14:54:04 +0100 Add batchupdate tool. PgBrowser: add constraints to list_column_usage().
Radek Brich <radek.brich@devl.cz> [Fri, 23 Mar 2012 14:54:04 +0100] rev 32
Add batchupdate tool. PgBrowser: add constraints to list_column_usage().
Mon, 05 Mar 2012 18:36:46 +0100 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.
Radek Brich <radek.brich@devl.cz> [Mon, 05 Mar 2012 18:36:46 +0100] rev 31
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.
Mon, 27 Feb 2012 15:12:40 +0100 Fix analyzeall tool. Add user output formating to batchquery tool. Add isolation_level setting support to ToolBase.
Radek Brich <radek.brich@devl.cz> [Mon, 27 Feb 2012 15:12:40 +0100] rev 30
Fix analyzeall tool. Add user output formating to batchquery tool. Add isolation_level setting support to ToolBase.
Tue, 14 Feb 2012 18:15:56 +0100 Add batchquery tool.
Radek Brich <radek.brich@devl.cz> [Tue, 14 Feb 2012 18:15:56 +0100] rev 29
Add batchquery tool.
Tue, 07 Feb 2012 11:32:07 +0100 analyzeall: analyze tables from all schemas by default
Radek Brich <radek.brich@devl.cz> [Tue, 07 Feb 2012 11:32:07 +0100] rev 28
analyzeall: analyze tables from all schemas by default
Tue, 07 Feb 2012 10:40:35 +0100 Add analyzeall tool. Updates, fixes.
Radek Brich <radek.brich@devl.cz> [Tue, 07 Feb 2012 10:40:35 +0100] rev 27
Add analyzeall tool. Updates, fixes.
Fri, 13 Jan 2012 15:49:24 +0100 Add logging mechanism for notices from postgres server. Rename SQL log to "pgmanager_sql".
Radek Brich <radek.brich@devl.cz> [Fri, 13 Jan 2012 15:49:24 +0100] rev 26
Add logging mechanism for notices from postgres server. Rename SQL log to "pgmanager_sql".
Thu, 15 Dec 2011 18:26:04 +0100 Fix bad name.
Radek Brich <radek.brich@devl.cz> [Thu, 15 Dec 2011 18:26:04 +0100] rev 25
Fix bad name.
Thu, 15 Dec 2011 18:21:41 +0100 PgManager: Add partial support for multiprocessing.
Radek Brich <radek.brich@devl.cz> [Thu, 15 Dec 2011 18:21:41 +0100] rev 24
PgManager: Add partial support for multiprocessing.
Wed, 14 Dec 2011 16:29:33 +0100 Add keep_open parameter to create_conn.
Radek Brich <brich.radek@ifortuna.cz> [Wed, 14 Dec 2011 16:29:33 +0100] rev 23
Add keep_open parameter to create_conn.
Tue, 06 Dec 2011 17:11:21 +0100 Add test for PgManager.
Radek Brich <radek.brich@devl.cz> [Tue, 06 Dec 2011 17:11:21 +0100] rev 22
Add test for PgManager.
Tue, 06 Dec 2011 16:45:29 +0100 Add test for delayedquery.
Radek Brich <radek.brich@devl.cz> [Tue, 06 Dec 2011 16:45:29 +0100] rev 21
Add test for delayedquery.
Tue, 06 Dec 2011 16:20:53 +0100 PgManager: Do not add NullHandler to logger. Rewrite get_instance(). ToolBase: fix prepare_conns() method.
Radek Brich <radek.brich@devl.cz> [Tue, 06 Dec 2011 16:20:53 +0100] rev 20
PgManager: Do not add NullHandler to logger. Rewrite get_instance(). ToolBase: fix prepare_conns() method.
Sun, 27 Nov 2011 17:02:42 +0100 Add documentation for create_conn(). Fix keep_alive - do not crash if socket settings are not supported.
Radek Brich <radek.brich@devl.cz> [Sun, 27 Nov 2011 17:02:42 +0100] rev 19
Add documentation for create_conn(). Fix keep_alive - do not crash if socket settings are not supported.
Fri, 25 Nov 2011 18:17:27 +0100 Fix MyManager. Add patch for MySQLdb and Python3.2. Add DelayedQuery.
Radek Brich <radek.brich@devl.cz> [Fri, 25 Nov 2011 18:17:27 +0100] rev 18
Fix MyManager. Add patch for MySQLdb and Python3.2. Add DelayedQuery.
Mon, 21 Nov 2011 10:47:24 +0100 ToolBase - implement 'database' config option.
Radek Brich <radek.brich@devl.cz> [Mon, 21 Nov 2011 10:47:24 +0100] rev 17
ToolBase - implement 'database' config option.
Mon, 21 Nov 2011 10:43:37 +0100 MyManager - create_conn() - allow same parameters as for PgManager.
Radek Brich <brich.radek@ifortuna.cz> [Mon, 21 Nov 2011 10:43:37 +0100] rev 16
MyManager - create_conn() - allow same parameters as for PgManager.
Mon, 14 Nov 2011 18:00:53 +0100 Add MyManager - replica of PgManager for MySQLdb. Intentionally not inherited from common base class.
Radek Brich <radek.brich@devl.cz> [Mon, 14 Nov 2011 18:00:53 +0100] rev 15
Add MyManager - replica of PgManager for MySQLdb. Intentionally not inherited from common base class.
Thu, 20 Oct 2011 13:54:35 +0200 TableDiffTool: add arguments to set different destination schema and table. PgDataDiff: fixes.
Radek Brich <radek.brich@devl.cz> [Thu, 20 Oct 2011 13:54:35 +0200] rev 14
TableDiffTool: add arguments to set different destination schema and table. PgDataDiff: fixes.
Fri, 09 Sep 2011 11:56:37 +0200 ToolBase: add -d parameter, which triggers debug mode (print SQL queries).
Radek Brich <radek.brich@devl.cz> [Fri, 09 Sep 2011 11:56:37 +0200] rev 13
ToolBase: add -d parameter, which triggers debug mode (print SQL queries).
Tue, 06 Sep 2011 17:55:15 +0200 Fix pgdatadiff.
Radek Brich <radek.brich@devl.cz> [Tue, 06 Sep 2011 17:55:15 +0200] rev 12
Fix pgdatadiff.
Fri, 19 Aug 2011 17:08:34 +0200 PgConsole: add app.py, splitted from pgconsole.py.
Radek Brich <radek.brich@devl.cz> [Fri, 19 Aug 2011 17:08:34 +0200] rev 11
PgConsole: add app.py, splitted from pgconsole.py.
Tue, 16 Aug 2011 23:53:54 +0200 Added pgconsole. It is my older project, a GUI query console. It uses GTK+ and asynchronous queries.
Radek Brich <radek.brich@devl.cz> [Tue, 16 Aug 2011 23:53:54 +0200] rev 10
Added pgconsole. It is my older project, a GUI query console. It uses GTK+ and asynchronous queries.
Tue, 16 Aug 2011 16:03:46 +0200 Reorganize again :-) Add setup.py.
Radek Brich <radek.brich@devl.cz> [Tue, 16 Aug 2011 16:03:46 +0200] rev 9
Reorganize again :-) Add setup.py.
Tue, 16 Aug 2011 15:12:53 +0200 pgmanager: Add keep_alive support.
Radek Brich <radek.brich@devl.cz> [Tue, 16 Aug 2011 15:12:53 +0200] rev 8
pgmanager: Add keep_alive support.
Fri, 12 Aug 2011 14:39:49 +0200 Reorganize directories. PgDataDiff - reworked. PgManager - add fetchone_adapted, fetchall_adapted to cursor.
Radek Brich <radek.brich@devl.cz> [Fri, 12 Aug 2011 14:39:49 +0200] rev 7
Reorganize directories. PgDataDiff - reworked. PgManager - add fetchone_adapted, fetchall_adapted to cursor.
Wed, 10 Aug 2011 18:34:54 +0200 Add table diff tool.
Radek Brich <radek.brich@devl.cz> [Wed, 10 Aug 2011 18:34:54 +0200] rev 6
Add table diff tool.
Wed, 20 Jul 2011 10:54:07 +0200 Clean up tools.
Radek Brich <radek.brich@devl.cz> [Wed, 20 Jul 2011 10:54:07 +0200] rev 5
Clean up tools.
Wed, 20 Jul 2011 10:51:18 +0200 Merge.
Radek Brich <radek.brich@devl.cz> [Wed, 20 Jul 2011 10:51:18 +0200] rev 4
Merge.
Tue, 19 Jul 2011 14:36:33 +0200 pgmanager: fix logging of queries
Radek Brich <radek.brich@devl.cz> [Tue, 19 Jul 2011 14:36:33 +0200] rev 3
pgmanager: fix logging of queries
Mon, 18 Jul 2011 17:39:37 +0200 Fix pgmanager exceptions.
Radek Brich <radek.brich@devl.cz> [Mon, 18 Jul 2011 17:39:37 +0200] rev 2
Fix pgmanager exceptions. Add CLI tools: bigtables, longqueries, schemadiff.
Wed, 01 Jun 2011 11:48:07 +0200 Fix pgmanager logging in Python3.
Radek Brich <radek.brich@devl.cz> [Wed, 01 Jun 2011 11:48:07 +0200] rev 1
Fix pgmanager logging in Python3.
Thu, 26 May 2011 18:09:05 +0200 Postgres tools.
Radek Brich <radek.brich@devl.cz> [Thu, 26 May 2011 18:09:05 +0200] rev 0
Postgres tools.
(0) tip