root / pykota / trunk / pykota / storages / sql.py

Revision Log Mode:


Legend:

Added
Modified
Copied or renamed
Rev Chgset Date Author Log Message
(edit) @3531 [3531] 14 years jerome Fix which fixes 56 for good. References 60.
(edit) @3524 [3524] 14 years jerome Improved the retrival of printers and billingcodes as well as users. …
(edit) @3521 [3521] 14 years jerome Removed some code specific to Python v2.2 and earlier. Improved the work …
(edit) @3489 [3489] 15 years jerome Removed bad copy and paste artifact.
(edit) @3481 [3481] 15 years jerome Changed copyright years. Copyright years are now dynamic when displayed by …
(edit) @3413 [3413] 16 years jerome Removed unnecessary spaces at EOL.
(edit) @3411 [3411] 16 years jerome Minor change to please emacs…
(edit) @3388 [3388] 16 years jerome Fixed an SQL incompatibilities problem, thanks to Jens Weibler. Fixes #17.
(edit) @3302 [3302] 16 years jerome Fixed string interpolation method.
(edit) @3301 [3301] 16 years jerome Found the solution to missing "LIMIT" SQL statement under DB2. Noted it as …
(edit) @3294 [3294] 16 years jerome Added modules to store utility functions and application intialization …
(edit) @3293 [3293] 16 years jerome Added a TODO item.
(edit) @3292 [3292] 16 years jerome Removed the LIMIT SQL keyword to accomodate DB2 which apparently lacks …
(edit) @3291 [3291] 16 years jerome Database backends now convert from and to unicode instead of UTF-8. The …
(edit) @3275 [3275] 16 years jerome Updated copyright years. Changed some remaining ISO-8859-15 markers to …
(edit) @3260 [3260] 16 years jerome Changed license to GNU GPL v3 or later. Changed Python source encoding …
(edit) @3258 [3258] 16 years jerome Removed LIMIT where it's not needed (unique key), because LIMIT is not …
(edit) @3184 [3184] 17 years jerome Added some docstrings.
(edit) @3165 [3165] 17 years jerome Added --orderby command line switch to dumpykota. Doesn't work yet with …
(edit) @3164 [3164] 17 years jerome Added missing 'ASC' statements.
(edit) @3142 [3142] 17 years jerome Make start= and end= filters also work with payments. For an …
(edit) @3139 [3139] 17 years jerome Fixed a bug which caused edpykota (and other) to fail when deleting …
(edit) @3133 [3133] 17 years jerome Changed copyright years.
(edit) @3056 [3056] 17 years jerome The code to refund jobs is there and works (at least with …
(edit) @2949 [2949] 18 years jerome Missing self.
(edit) @2948 [2948] 18 years jerome Code cleaning. Set instances' attributes in a single place. The same has …
(edit) @2857 [2857] 18 years jerome Initializes the denied banners counter in all cases.
(edit) @2830 [2830] 18 years jerome Improved the code's quality a bit with pylint.
(edit) @2787 [2787] 18 years jerome I had to slowdown data creation because PostgreSQL 7.4 (the one I …
(edit) @2775 [2775] 18 years jerome Fixed billing code extraction : it didn't have the speed improvements that …
(edit) @2773 [2773] 18 years jerome pkusers is now optimized like pkprinters, pkbcodes and edpykota.
(edit) @2771 [2771] 18 years jerome Modified a method's name.
(edit) @2768 [2768] 18 years jerome Optimized pkprinters like pkbcodes and edpykota.
(edit) @2765 [2765] 18 years jerome Optimized pkbcodes like edpykota.
(edit) @2763 [2763] 18 years jerome Added some multiple deletions routines.
(edit) @2758 [2758] 18 years jerome Fixed incorrect initialization of page counters.
(edit) @2756 [2756] 18 years jerome Removed unneeded stuff.
(edit) @2754 [2754] 18 years jerome Huge speed improvement in data retrieval when wildcards are not used.
(edit) @2749 [2749] 18 years jerome Now manage print quota entries the way it should be done (c) (tm) !
(edit) @2743 [2743] 18 years jerome Big improvement for data extraction.
(edit) @2742 [2742] 18 years jerome Now ouputs some timing info even when debug:no is used. Also uses psyco, …
(edit) @2735 [2735] 18 years jerome Completely untested modification stuff…
(edit) @2734 [2734] 18 years jerome Fixed another problem with large dictionnaries : better to fill it in any …
(edit) @2726 [2726] 18 years jerome Renamed methods.
(edit) @2722 [2722] 18 years jerome Added userful helpers to retrieve all interesting datas with a single …
(edit) @2721 [2721] 18 years jerome Added missing description handling stuff
(edit) @2718 [2718] 18 years jerome Fixed deletion code for print quota entries.
(edit) @2717 [2717] 18 years jerome Added deletion methods for user and group print quota entries.
(edit) @2707 [2707] 18 years jerome Improved user modification speed by around 15%.
(edit) @2706 [2706] 18 years jerome pkusers now mostly works. Removing an user from a group with LDAP is not …
(edit) @2698 [2698] 18 years jerome Typos
(edit) @2697 [2697] 18 years jerome Add the description attribute on creation
(edit) @2686 [2686] 18 years jerome Modified pkprinters to improve speed just like I did for pkbcodes …
(edit) @2678 [2678] 18 years jerome Incorrect variable name
(edit) @2676 [2676] 18 years jerome The duration for the modification of billing codes has been more than …
(edit) @2665 [2665] 18 years jerome Ensures that date based filtering works consistently between LDAP and …
(edit) @2657 [2657] 18 years jerome Huge speed improvements when using the --delete command line option for …
(edit) @2654 [2654] 18 years jerome Now non-ascii characters are accepted as part of usernames, groupnames or …
(edit) @2653 [2653] 18 years jerome Return values translated to user charset instead.
(edit) @2651 [2651] 18 years jerome Cleaned the code a bit. Now more similar to LDAP code, this will help …
(edit) @2638 [2638] 18 years matt Initial MySQL support
(edit) @2622 [2622] 18 years jerome Added 2006 to the copyright's years.
(edit) @2599 [2599] 18 years jerome Fixed bad import, because some code moved
(edit) @2596 [2596] 18 years jerome Removed ambiguity in history retrieval.
(edit) @2593 [2593] 18 years jerome Added support for SQLite3 database backend. NEEDS TESTERS !
(edit) @2464 [2464] 19 years jerome Added support to write the maxjobsize and passthrough attributes for …
(edit) @2459 [2459] 19 years jerome Did some work to prepare the integration of MaxJobSize? and …
(edit) @2455 [2455] 19 years jerome Added the precomputed job's size and price to the history.
(edit) @2452 [2452] 19 years jerome Upgraded database schema. Added -i | --ingroups command line option to …
(edit) @2388 [2388] 19 years jerome Fixed an LDAP filtering problem when several billing codes were passed on …
(edit) @2374 [2374] 19 years jerome Removed unnecessary code
(edit) @2371 [2371] 19 years jerome Minor fixes to ensure that the billing code is stored as utf8
(edit) @2369 [2369] 19 years jerome Ensures that the billing code is stored as an utf8 encoded string.
(edit) @2342 [2342] 19 years jerome The pkbcodes command line tool now works fine with the PostgreSQL backend. …
(edit) @2320 [2320] 19 years jerome Fix for user groups, the recent database changes broke this code
(edit) @2302 [2302] 19 years jerome Updated the FSF's address
(edit) @2287 [2287] 19 years jerome Now stores 'hidden' in the title, filename and options fields instead of …
(edit) @2266 [2266] 19 years jerome Now dumpykota and dumpykota.cgi accept start= and end= to specify the …
(edit) @2222 [2222] 19 years jerome Fixed history retrieval for nonexisting printers or users
(edit) @2220 [2220] 19 years jerome Job's billing code is now clicable in the print job history viewed from …
(edit) @2218 [2218] 19 years jerome The data dumper now supports filtering by hostname or billing code.
(edit) @2217 [2217] 19 years jerome The job-billing info is now saved into the database if present.
(edit) @2147 [2147] 19 years jerome Removed all references to $Log$
(edit) @2146 [2146] 19 years jerome It seems that $Log$ is not implemented or doesn't work for some reason
(edit) @2139 [2139] 19 years jerome Added the Log keyword property
(edit) @2066 [2066] 19 years jalet Fixed the maxdenybanners directive. Introduced the denyduplicates …
(edit) @2057 [2057] 19 years jalet Added the md5sum to the history
(edit) @2054 [2054] 19 years jalet Big database structure changes. Upgrade script is now included as well …
(edit) @2030 [2030] 19 years jalet Big bug fix wrt the datelimit attribute
(edit) @1999 [1999] 19 years jalet Fixed a problem which occured when 'limitby' was unset in the …
(edit) @1992 [1992] 19 years jalet Fixed the problem with dumpykota's filtering of printers groups membership
(edit) @1991 [1991] 19 years jalet The dumpykota command now supports extended filtering capabilities …
(edit) @1990 [1990] 19 years jalet Prepared dumpykota to accept the new --filter command line option. …
(edit) @1875 [1875] 19 years jalet For URGENT legal reasons (Italy), a new "privacy" directive was added to …
(edit) @1806 [1806] 20 years jalet Now warnpykota only warns users who have already printed, to not …
(edit) @1792 [1792] 20 years jalet Improved SQL queries for groups. Same work has to be done for groups print …
(edit) @1790 [1790] 20 years jalet Hopefully final fix for data encoding to and from the database
(edit) @1787 [1787] 20 years jalet Fixes recently introduced bug wrt users groups (was it three days ago ?)
(edit) @1778 [1778] 20 years jalet UnicodeEncodeError? isn't defined in Python2.1
(edit) @1777 [1777] 20 years jalet Restore compatibility with Python 2.1
Note: See TracRevisionLog for help on using the revision log.