# # ChangeLog for /pykota/trunk/pykota/storages/pgstorage.py # # Generated by Trac 0.11rc1 # 05/09/24 22:01:30 Wed, 19 Jan 2005 08:48:17 GMT jalet [2031] * pykota/trunk/pykota/storages/pgstorage.py (modified) Fix exception's name wrt newer versions of PygreSQL Tue, 14 Sep 2004 22:29:13 GMT jalet [1717] * pykota/trunk/bin/dumpykota (modified) * pykota/trunk/MANIFEST.in (modified) * pykota/trunk/NEWS (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/storages/sql.py (modified) * pykota/trunk/pykota/version.py (modified) * pykota/trunk/setup.py (modified) First version of dumpykota. Works fine but only with ... Thu, 03 Jun 2004 23:14:11 GMT jalet [1520] * pykota/trunk/bin/cupspykota (modified) * pykota/trunk/initscripts/ldap/pykota.schema (modified) * pykota/trunk/initscripts/postgresql/dbschema.png (deleted) * pykota/trunk/initscripts/postgresql/pykota-postgresql.sql (modified) * pykota/trunk/initscripts/postgresql/upgrade-to-1.19.sql (modified) * pykota/trunk/pykota/storage.py (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/storages/sql.py (modified) Now stores the job's size in bytes in the database. Preliminary work on ... Mon, 02 Feb 2004 22:44:16 GMT jalet [1327] * pykota/trunk/pykota/storages/dbistorage.py (added) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/storages/sql.py (added) Preliminary work on Relationnal Database Independance via DB-API 2.0 Mon, 12 Jan 2004 15:12:50 GMT jalet [1277] * pykota/trunk/pykota/reporters/html.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) Small fix for history Mon, 12 Jan 2004 14:44:47 GMT jalet [1275] * pykota/trunk/pykota/storages/pgstorage.py (modified) Missing space in SQL query Mon, 12 Jan 2004 14:35:02 GMT jalet [1274] * pykota/trunk/cgi-bin/printquota.cgi (modified) * pykota/trunk/NEWS (modified) * pykota/trunk/pykota/reporters/html.py (modified) * pykota/trunk/pykota/storage.py (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/stylesheets/README (modified) Printing history added to CGI script. Sat, 10 Jan 2004 09:44:02 GMT jalet [1269] * pykota/trunk/NEWS (modified) * pykota/trunk/pykota/storage.py (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/version.py (modified) Fixed potential accuracy problem if a user printed on several printers ... Thu, 08 Jan 2004 16:33:27 GMT jalet [1259] * pykota/trunk/pykota/storage.py (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) Additionnal check to not create a circular printers group. Thu, 08 Jan 2004 16:24:49 GMT jalet [1258] * pykota/trunk/bin/edpykota (modified) * pykota/trunk/NEWS (modified) * pykota/trunk/pykota/storage.py (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/version.py (modified) edpykota now supports adding printers to printer groups. Thu, 08 Jan 2004 14:10:33 GMT jalet [1257] * pykota/trunk/bin/cupspykota (modified) * pykota/trunk/bin/edpykota (modified) * pykota/trunk/bin/mailandpopup.sh (modified) * pykota/trunk/bin/papwaitprinter.sh (modified) * pykota/trunk/bin/pykota (modified) * pykota/trunk/bin/pykotme (modified) * pykota/trunk/bin/README (modified) * pykota/trunk/bin/repykota (modified) * pykota/trunk/bin/waitprinter.sh (modified) * pykota/trunk/bin/warnpykota (modified) * pykota/trunk/cgi-bin/printquota.cgi (modified) * pykota/trunk/clean.sh (modified) * pykota/trunk/conf/pykota.conf.sample (modified) * pykota/trunk/conf/pykotadmin.conf.sample (modified) * pykota/trunk/conf/README (modified) * pykota/trunk/contributed/pagecount.pl (modified) * pykota/trunk/CREDITS (modified) * pykota/trunk/debian/README (modified) * pykota/trunk/docs/README (modified) * pykota/trunk/initscripts/ldap/README.ldap (modified) * pykota/trunk/initscripts/postgresql/pykota-postgresql.sql (modified) * pykota/trunk/initscripts/postgresql/README.postgresql (modified) * pykota/trunk/initscripts/postgresql/upgrade-from-before-1.03.py (modified) * pykota/trunk/initscripts/postgresql/upgrade-to-1.14.sql (modified) * pykota/trunk/initscripts/postgresql/upgrade-to-1.16.sql (modified) * pykota/trunk/initscripts/postgresql/VERYOLDpykota-upgrade-postgresql.sql (modified) * pykota/trunk/initscripts/README (modified) * pykota/trunk/LICENSE (modified) * pykota/trunk/logos/README (modified) * pykota/trunk/man/README (modified) * pykota/trunk/NEWS (modified) * pykota/trunk/po/en/pykota.po (modified) * pykota/trunk/po/es/pykota.po (modified) * pykota/trunk/po/fr/pykota.po (modified) * pykota/trunk/po/pt/pykota.po (modified) * pykota/trunk/po/pykota.pot (modified) * pykota/trunk/po/README (modified) * pykota/trunk/pykota/accounter.py (modified) * pykota/trunk/pykota/accounters/external.py (modified) * pykota/trunk/pykota/accounters/__init__.py (modified) * pykota/trunk/pykota/accounters/querying.py (modified) * pykota/trunk/pykota/accounters/stupid.py (modified) * pykota/trunk/pykota/config.py (modified) * pykota/trunk/pykota/__init__.py (modified) * pykota/trunk/pykota/logger.py (modified) * pykota/trunk/pykota/loggers/__init__.py (modified) * pykota/trunk/pykota/loggers/stderr.py (modified) * pykota/trunk/pykota/loggers/system.py (modified) * pykota/trunk/pykota/reporter.py (modified) * pykota/trunk/pykota/reporters/html.py (modified) * pykota/trunk/pykota/reporters/__init__.py (modified) * pykota/trunk/pykota/reporters/text.py (modified) * pykota/trunk/pykota/requester.py (modified) * pykota/trunk/pykota/requesters/external.py (modified) * pykota/trunk/pykota/requesters/__init__.py (modified) * pykota/trunk/pykota/requesters/snmp.py (modified) * pykota/trunk/pykota/storage.py (modified) * pykota/trunk/pykota/storages/__init__.py (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/tool.py (modified) * pykota/trunk/pykota/version.py (modified) * pykota/trunk/README (modified) * pykota/trunk/SECURITY (modified) * pykota/trunk/setup.py (modified) * pykota/trunk/TODO (modified) * pykota/trunk/untested/postscript/pagecount.sh (modified) * pykota/trunk/untested/README (modified) Copyright year changed. Tue, 06 Jan 2004 14:24:59 GMT jalet [1249] * pykota/trunk/NEWS (modified) * pykota/trunk/pykota/storage.py (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) Printer groups should be cached now, if caching is enabled. Mon, 29 Dec 2003 14:12:48 GMT uid67467 [1244] * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) Tries to workaround possible integrity violations when ... Sat, 27 Dec 2003 16:49:25 GMT uid67467 [1240] * pykota/trunk/bin/cupspykota (modified) * pykota/trunk/bin/pykota (modified) * pykota/trunk/bin/waitprinter.sh (modified) * pykota/trunk/cgi-bin/printquota.cgi (modified) * pykota/trunk/conf/pykota.conf.sample (modified) * pykota/trunk/CREDITS (modified) * pykota/trunk/initscripts/ldap/pykota.schema (modified) * pykota/trunk/initscripts/postgresql/pykota-postgresql.sql (modified) * pykota/trunk/initscripts/postgresql/upgrade-to-1.16.sql (modified) * pykota/trunk/MANIFEST.in (modified) * pykota/trunk/NEWS (modified) * pykota/trunk/po/en/pykota.po (modified) * pykota/trunk/po/es/pykota.po (modified) * pykota/trunk/po/fr/pykota.po (modified) * pykota/trunk/po/pt/pykota.po (modified) * pykota/trunk/po/pykota.pot (modified) * pykota/trunk/pykota/accounter.py (modified) * pykota/trunk/pykota/accounters/external.py (modified) * pykota/trunk/pykota/accounters/querying.py (modified) * pykota/trunk/pykota/accounters/stupid.py (modified) * pykota/trunk/pykota/logger.py (modified) * pykota/trunk/pykota/reporter.py (modified) * pykota/trunk/pykota/reporters/html.py (modified) * pykota/trunk/pykota/reporters/text.py (modified) * pykota/trunk/pykota/requester.py (modified) * pykota/trunk/pykota/storage.py (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/tool.py (modified) * pykota/trunk/pykota/version.py (modified) * pykota/trunk/setup.py (modified) Should be ok now. Sat, 29 Nov 2003 22:02:14 GMT jalet [1228] * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) Don't try to retrieve the user print quota information if ... Sun, 23 Nov 2003 19:01:37 GMT jalet [1203] * pykota/trunk/bin/cupspykota (modified) * pykota/trunk/initscripts/ldap/pykota.schema (modified) * pykota/trunk/initscripts/postgresql/pykota-postgresql.sql (modified) * pykota/trunk/initscripts/postgresql/README.postgresql (modified) * pykota/trunk/initscripts/postgresql/upgrade-to-1.16.sql (modified) * pykota/trunk/NEWS (modified) * pykota/trunk/pykota/accounters/external.py (modified) * pykota/trunk/pykota/accounters/stupid.py (modified) * pykota/trunk/pykota/storage.py (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/version.py (modified) Job price added to history Fri, 21 Nov 2003 14:28:46 GMT jalet [1200] * pykota/trunk/bin/cupspykota (modified) * pykota/trunk/initscripts/ldap/pykota-sample.ldif (modified) * pykota/trunk/initscripts/ldap/pykota.schema (modified) * pykota/trunk/initscripts/ldap/README.ldap (modified) * pykota/trunk/initscripts/postgresql/pykota-postgresql.sql (modified) * pykota/trunk/initscripts/postgresql/README.postgresql (modified) * pykota/trunk/initscripts/README (modified) * pykota/trunk/NEWS (modified) * pykota/trunk/pykota/accounters/external.py (modified) * pykota/trunk/pykota/accounters/querying.py (modified) * pykota/trunk/pykota/accounters/stupid.py (modified) * pykota/trunk/pykota/storage.py (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/tool.py (modified) * pykota/trunk/pykota/version.py (modified) More complete job history. Wed, 12 Nov 2003 13:06:38 GMT jalet [1179] * pykota/trunk/bin/edpykota (modified) * pykota/trunk/NEWS (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/version.py (modified) Bug fix wrt no user/group name command line argument to edpykota Thu, 09 Oct 2003 21:25:26 GMT jalet [1156] * pykota/trunk/bin/edpykota (modified) * pykota/trunk/bin/pykotme (modified) * pykota/trunk/bin/repykota (modified) * pykota/trunk/bin/warnpykota (modified) * pykota/trunk/NEWS (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/version.py (modified) Multiple printer names or wildcards can be passed on the command ... Wed, 08 Oct 2003 07:01:20 GMT jalet [1149] * pykota/trunk/conf/pykota.conf.sample (modified) * pykota/trunk/NEWS (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/version.py (modified) * pykota/trunk/README (modified) * pykota/trunk/setup.py (modified) Job history can be disabled. Some typos in README. More messages in ... Tue, 07 Oct 2003 09:07:30 GMT jalet [1144] * pykota/trunk/bin/edpykota (modified) * pykota/trunk/bin/pykota (modified) * pykota/trunk/bin/pykotme (modified) * pykota/trunk/bin/repykota (modified) * pykota/trunk/bin/warnpykota (modified) * pykota/trunk/pykota/accounter.py (modified) * pykota/trunk/pykota/accounters/external.py (modified) * pykota/trunk/pykota/accounters/__init__.py (modified) * pykota/trunk/pykota/accounters/querying.py (modified) * pykota/trunk/pykota/accounters/stupid.py (modified) * pykota/trunk/pykota/config.py (modified) * pykota/trunk/pykota/__init__.py (modified) * pykota/trunk/pykota/logger.py (modified) * pykota/trunk/pykota/loggers/__init__.py (modified) * pykota/trunk/pykota/loggers/stderr.py (modified) * pykota/trunk/pykota/loggers/system.py (modified) * pykota/trunk/pykota/reporter.py (modified) * pykota/trunk/pykota/reporters/__init__.py (modified) * pykota/trunk/pykota/reporters/text.py (modified) * pykota/trunk/pykota/requester.py (modified) * pykota/trunk/pykota/requesters/external.py (modified) * pykota/trunk/pykota/requesters/__init__.py (modified) * pykota/trunk/pykota/requesters/snmp.py (modified) * pykota/trunk/pykota/storage.py (modified) * pykota/trunk/pykota/storages/__init__.py (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/tool.py (modified) * pykota/trunk/pykota/version.py (modified) * pykota/trunk/setup.py (modified) Character encoding added to please latest version of Python Mon, 06 Oct 2003 13:12:28 GMT jalet [1137] * pykota/trunk/pykota/storage.py (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) More work on caching Fri, 03 Oct 2003 18:01:49 GMT jalet [1136] * pykota/trunk/pykota/storages/pgstorage.py (modified) Nothing interesting... Fri, 03 Oct 2003 12:27:03 GMT jalet [1133] * pykota/trunk/bin/edpykota (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) Several optimizations, especially with LDAP backend Fri, 03 Oct 2003 08:57:55 GMT jalet [1131] * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) Caching mechanism now caches all that's cacheable. Thu, 02 Oct 2003 20:23:18 GMT jalet [1130] * pykota/trunk/conf/pykota.conf.sample (modified) * pykota/trunk/NEWS (modified) * pykota/trunk/pykota/config.py (modified) * pykota/trunk/pykota/storage.py (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/tool.py (modified) * pykota/trunk/pykota/version.py (modified) Storage caching mechanism added. Sun, 17 Aug 2003 14:20:25 GMT jalet [1115] * pykota/trunk/CREDITS (modified) * pykota/trunk/NEWS (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/version.py (modified) Bug fix by Oleg Biteryakov Tue, 29 Jul 2003 20:55:17 GMT jalet [1113] * pykota/trunk/bin/edpykota (modified) * pykota/trunk/bin/pykota (modified) * pykota/trunk/bin/pykotme (modified) * pykota/trunk/bin/repykota (modified) * pykota/trunk/bin/warnpykota (modified) * pykota/trunk/cgi-bin/printquota.cgi (modified) * pykota/trunk/NEWS (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/tool.py (modified) * pykota/trunk/pykota/version.py (modified) * pykota/trunk/setup.py (modified) 1.14 is out ! Wed, 16 Jul 2003 21:53:08 GMT jalet [1087] * pykota/trunk/conf/pykota.conf.sample (modified) * pykota/trunk/conf/pykotadmin.conf.sample (added) * pykota/trunk/initscripts/postgresql/pykota-postgresql.sql (modified) * pykota/trunk/initscripts/postgresql/upgrade-to-1.14.sql (modified) * pykota/trunk/NEWS (modified) * pykota/trunk/pykota/config.py (modified) * pykota/trunk/pykota/storage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/tool.py (modified) * pykota/trunk/pykota/version.py (modified) * pykota/trunk/SECURITY (modified) * pykota/trunk/setup.py (modified) Really big modifications wrt new configuration file's location ... Mon, 14 Jul 2003 17:20:15 GMT jalet [1085] * pykota/trunk/NEWS (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/version.py (modified) Bug in postgresql storage when modifying the prices for a printer Mon, 14 Jul 2003 14:18:17 GMT jalet [1084] * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) Wrong documentation strings Wed, 09 Jul 2003 20:17:07 GMT jalet [1079] * pykota/trunk/initscripts/postgresql/pykota-postgresql.sql (modified) * pykota/trunk/initscripts/postgresql/README.postgresql (modified) * pykota/trunk/initscripts/postgresql/upgrade-to-1.14.sql (added) * pykota/trunk/NEWS (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/tool.py (modified) * pykota/trunk/pykota/version.py (modified) Email field added to PostgreSQL schema Mon, 07 Jul 2003 11:49:24 GMT jalet [1068] * pykota/trunk/NEWS (modified) * pykota/trunk/pykota/accounters/external.py (modified) * pykota/trunk/pykota/accounters/querying.py (modified) * pykota/trunk/pykota/config.py (modified) * pykota/trunk/pykota/logger.py (modified) * pykota/trunk/pykota/loggers/system.py (modified) * pykota/trunk/pykota/reporters/text.py (modified) * pykota/trunk/pykota/requester.py (modified) * pykota/trunk/pykota/requesters/external.py (modified) * pykota/trunk/pykota/requesters/snmp.py (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/tool.py (modified) * pykota/trunk/pykota/version.py (modified) Lots of small fixes with the help of PyChecker Mon, 07 Jul 2003 08:33:19 GMT jalet [1067] * pykota/trunk/NEWS (modified) * pykota/trunk/pykota/storage.py (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/version.py (modified) Bug fix due to a typo in LDAP code Mon, 30 Jun 2003 13:54:21 GMT jalet [1051] * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) Sorts by user / group name Wed, 25 Jun 2003 14:10:01 GMT jalet [1041] * pykota/trunk/bin/edpykota (modified) * pykota/trunk/bin/pykota (modified) * pykota/trunk/bin/repykota (modified) * pykota/trunk/bin/warnpykota (modified) * pykota/trunk/initscripts/ldap/pykota.schema (modified) * pykota/trunk/NEWS (modified) * pykota/trunk/pykota/accounters/external.py (modified) * pykota/trunk/pykota/accounters/querying.py (modified) * pykota/trunk/pykota/accounters/stupid.py (modified) * pykota/trunk/pykota/config.py (modified) * pykota/trunk/pykota/storage.py (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (modified) * pykota/trunk/pykota/tool.py (modified) Hey, it may work (edpykota --reset excepted) ! Thu, 12 Jun 2003 21:09:57 GMT jalet [1024] * pykota/trunk/pykota/storages/pgstorage.py (modified) wrongly placed code. Tue, 10 Jun 2003 16:37:54 GMT jalet [1021] * pykota/trunk/bin/repykota (modified) * pykota/trunk/conf/pykota.conf.sample (modified) * pykota/trunk/docs/installation.sgml (modified) * pykota/trunk/initscripts/postgresql/pykota-postgresql.sql (modified) * pykota/trunk/NEWS (modified) * pykota/trunk/pykota/config.py (modified) * pykota/trunk/pykota/logger.py (modified) * pykota/trunk/pykota/storage.py (modified) * pykota/trunk/pykota/storages/ldapstorage.py (modified) * pykota/trunk/pykota/storages/pgstorage.py (added) * pykota/trunk/pykota/storages/postgresql.py (deleted) * pykota/trunk/pykota/storages/sql.py (deleted) * pykota/trunk/pykota/tool.py (modified) * pykota/trunk/pykota/version.py (modified) Deletion of the second user which is not needed anymore. Added a debug ...