Changeset 1079

Timestamp:

07/09/03 22:17:07 (21 years ago)

Author:

jalet

Message:

Email field added to PostgreSQL schema

Location:

pykota/trunk

Files:

• initscripts/postgresql/pykota-postgresql.sql (modified) (2 diffs)
• initscripts/postgresql/README.postgresql (modified) (1 diff)
• initscripts/postgresql/upgrade-to-1.14.sql (added)
• NEWS (modified) (1 diff)
• pykota/storages/pgstorage.py (modified) (3 diffs)
• pykota/tool.py (modified) (6 diffs)
• pykota/version.py (modified) (1 diff)

pykota/trunk/initscripts/postgresql/pykota-postgresql.sql

@@ -20 +20 @@
 --
 -- $Log$
+-- Revision 1.3  2003/07/09 20:17:07  jalet
+-- Email field added to PostgreSQL schema
+--
 -- Revision 1.2  2003/06/10 16:37:54  jalet
 -- Deletion of the second user which is not needed anymore.
@@ -59 +62 @@
 CREATE TABLE users(id SERIAL PRIMARY KEY NOT NULL,
                    username TEXT UNIQUE NOT NULL,
+                   email TEXT, 
                    balance FLOAT DEFAULT 0.0,
                    lifetimepaid FLOAT DEFAULT 0.0,

pykota/trunk/initscripts/postgresql/README.postgresql

@@ -56 +56 @@
   version of PyKota.
   
-* An sql script to upgrade a pre-1.01 PyKota Quota Storage DataBase to 
-  1.01 is still included for historical reasons. PLEASE DON'T USE IT ! 
   
-* If you are already running an old version of PyKota (<1.03) and 
-  want to upgrade to 1.03, YOU HAVE TO RUN the 
-  upgrade-from-before-1.03.py shell script. NOT LAUNCHING THIS SCRIPT 
-  WILL CAUSE PYKOTA TO STOP WORKING ! PLEASE NEVER RUN THIS SCRIPT IF 
-  YOUR EXISTING VERSION OF PYKOTA IS ALREADY 1.03 OR HIGHER. 
+  * An SQL script to upgrade a pre-1.14 PyKota Storage DataBase to
+    1.14 is included. Launch it this way on the Quota Storage Server :
+    
+        $ psql -U postgres pykota
+        pykota=# \i upgrade-to-1.14.sql
+        pykota=# \q
+        $
+        
+    This script adds an "email" field for each user. This field, if not    
+    NULL, is used as the email address of the user when sending warning
+    messages in case he is over quota.
+    
+What is below is for historical reasons only, real people don't use  
+such old beasts, and YOU SHOULDN'T EITHER !
+
+  * An sql script to upgrade a pre-1.01 PyKota Quota Storage DataBase to 
+    1.01 is still included for historical reasons. PLEASE DON'T USE IT ! 
+  
+  * If you are already running an old version of PyKota (<1.03) and 
+    want to upgrade to 1.03, YOU HAVE TO RUN the 
+    upgrade-from-before-1.03.py shell script. NOT LAUNCHING THIS SCRIPT 
+    WILL CAUSE PYKOTA TO STOP WORKING ! PLEASE NEVER RUN THIS SCRIPT IF 
+    YOUR EXISTING VERSION OF PYKOTA IS ALREADY 1.03 OR HIGHER. 

pykota/trunk/NEWS

@@ -22 +22 @@
 PyKota NEWS :
 
+    - 1.14alpha3 :
+    
+        - Email field added to PostgreSQL database. An upgrade script
+          is included in initscripts/postgresql.
+        
     - 1.14alpha2 :
     

pykota/trunk/pykota/storages/pgstorage.py

@@ -21 +21 @@
 #
 # $Log$
+# Revision 1.7  2003/07/09 20:17:07  jalet
+# Email field added to PostgreSQL schema
+#
 # Revision 1.6  2003/07/07 11:49:24  jalet
 # Lots of small fixes with the help of PyChecker
@@ -283 +286 @@
         """Returns the list of users who uses a given printer, along with their quotas."""
         usersandquotas = []
-        result = self.doSearch("SELECT users.id as uid,username,balance,lifetimepaid,limitby,userpquota.id,lifepagecounter,pagecounter,softlimit,hardlimit,datelimit FROM users JOIN userpquota ON users.id=userpquota.userid AND printerid=%s ORDER BY username ASC" % self.doQuote(printer.ident))
+        result = self.doSearch("SELECT users.id as uid,username,balance,lifetimepaid,limitby,email,userpquota.id,lifepagecounter,pagecounter,softlimit,hardlimit,datelimit FROM users JOIN userpquota ON users.id=userpquota.userid AND printerid=%s ORDER BY username ASC" % self.doQuote(printer.ident))
         if result :
             for record in result :
@@ -292 +295 @@
                     user.AccountBalance = record.get("balance")
                     user.LifeTimePaid = record.get("lifetimepaid")
-                    user.Email = record.get("email")    # TODO : Always None here
+                    user.Email = record.get("email") 
                     user.Exists = 1
                     userpquota = StorageUserPQuota(self, user, printer)

pykota/trunk/pykota/tool.py

@@ -21 +21 @@
 #
 # $Log$
+# Revision 1.46  2003/07/09 20:17:07  jalet
+# Email field added to PostgreSQL schema
+#
 # Revision 1.45  2003/07/08 19:43:51  jalet
 # Configurable warning messages.
@@ -327 +330 @@
         server.quit()
         
-    def sendMessageToUser(self, admin, adminmail, username, subject, message) :
+    def sendMessageToUser(self, admin, adminmail, user, subject, message) :
         """Sends an email message to a user."""
         message += _("\n\nPlease contact your system administrator :\n\n\t%s - <%s>\n") % (admin, adminmail)
-        self.sendMessage(adminmail, username, "Subject: %s\n\n%s" % (subject, message))
+        self.sendMessage(adminmail, user.Email or user.Name, "Subject: %s\n\n%s" % (subject, message))
         
     def sendMessageToAdmin(self, adminmail, subject, message) :
@@ -477 +480 @@
             for user in self.storage.getGroupMembers(group) :
                 if mailto in [ "BOTH", "USER" ] :
-                    self.sendMessageToUser(admin, adminmail, user.Name, _("Print Quota Exceeded"), self.config.getHardWarn(printer.Name))
+                    self.sendMessageToUser(admin, adminmail, user, _("Print Quota Exceeded"), self.config.getHardWarn(printer.Name))
         elif action == "WARN" :    
             adminmessage = _("Print Quota soft limit exceeded for group %s on printer %s") % (group.Name, printer.Name)
@@ -489 +492 @@
             for user in self.storage.getGroupMembers(group) :
                 if mailto in [ "BOTH", "USER" ] :
-                    self.sendMessageToUser(admin, adminmail, user.Name, _("Print Quota Exceeded"), message)
+                    self.sendMessageToUser(admin, adminmail, user, _("Print Quota Exceeded"), message)
         return action        
         
@@ -506 +509 @@
             self.logger.log_message(adminmessage)
             if mailto in [ "BOTH", "USER" ] :
-                self.sendMessageToUser(admin, adminmail, user.Name, _("Print Quota Exceeded"), self.config.getHardWarn(printer.Name))
+                self.sendMessageToUser(admin, adminmail, user, _("Print Quota Exceeded"), self.config.getHardWarn(printer.Name))
             if mailto in [ "BOTH", "ADMIN" ] :
                 self.sendMessageToAdmin(adminmail, _("Print Quota"), adminmessage)
@@ -517 +520 @@
                 else :     
                     message = self.config.getSoftWarn(printer.Name)
-                self.sendMessageToUser(admin, adminmail, user.Name, _("Print Quota Low"), message)
+                self.sendMessageToUser(admin, adminmail, user, _("Print Quota Low"), message)
             if mailto in [ "BOTH", "ADMIN" ] :
                 self.sendMessageToAdmin(adminmail, _("Print Quota"), adminmessage)

pykota/trunk/pykota/version.py

@@ -21 +21 @@
 #
 
-__version__ = "1.14alpha2_unofficial"
+__version__ = "1.14alpha3_unofficial"
 
 __doc__ = """PyKota : a complete Printing Quota Solution for CUPS and LPRng."""