MailManager

Email Archive: mailmanager-cvs (read-only)

2004:	_Jan	_Feb	_Mar	_Apr	_May	_Jun	_Jul	_Aug	_Sep	_Oct	_Nov	_Dec (39)
2005:	_Jan (19)	_Feb (21)	_Mar (136)	_Apr (258)	_May (183)	_Jun (93)	_Jul (67)	_Aug (180)	_Sep (213)	_Oct (112)	_Nov (136)	_Dec (91)
2006:	_Jan (333)	_Feb (248)	_Mar (401)	_Apr (77)	_May (168)	_Jun (156)	_Jul (79)	_Aug (213)	_Sep (65)	_Oct (59)	_Nov (43)	_Dec (27)
2007:	_Jan (38)	_Feb (29)	_Mar (24)	_Apr (37)	_May (15)	_Jun (10)	_Jul (3)	_Aug (7)	_Sep (1)	_Oct (9)	_Nov (11)	_Dec (3)
2008:	_Jan (10)	_Feb (8)	_Mar (13)	_Apr (29)	_May (20)	_Jun (24)	_Jul (36)	_Aug (3)	_Sep (18)	_Oct (22)	_Nov (59)	_Dec (52)
2009:	_Jan (83)	_Feb (23)	_Mar (47)	_Apr (48)	_May (118)	_Jun (111)	_Jul (80)	_Aug (37)	_Sep (26)	_Oct (46)	_Nov (11)	_Dec (22)
2010:	_Jan (19)	_Feb (10)	_Mar (51)	_Apr (61)	_May (79)	_Jun (91)	_Jul (50)	_Aug (64)	_Sep (49)	_Oct (31)	_Nov (22)	_Dec (17)
2011:	_Jan (20)	_Feb (25)	_Mar (15)	_Apr (23)	_May (15)	_Jun (18)	_Jul (35)	_Aug (83)	_Sep (109)	_Oct (151)	_Nov (155)	_Dec (68)
2012:	_Jan (94)	_Feb (92)	_Mar (157)	_Apr (139)	_May (208)	_Jun (305)	_Jul (263)	_Aug (192)	_Sep (199)	_Oct (260)	_Nov (304)	_Dec (471)
2013:	_Jan (485)	_Feb (425)	_Mar (427)	_Apr (680)	_May (700)	_Jun (294)	_Jul	_Aug	_Sep	_Oct	_Nov	_Dec


S	M	T	W	T	F	S
			1	2	3	4
			(7)
5	6	7	8	9	10	11
	(3)	(1)
12	13	14	15	16	17	18
(1)	(1)	(3)		(2)	(1)
19	20	21	22	23	24	25
			(1)			(3)
26	27	28	29	30
(18)		(1)		(1)

SF.net SVN: mailmanager: [3704] MailManager/branches/RELENG_2_2

From: <kevca@us...> - 2006-11-25 13:51

Revision: 3704
          http://svn.sourceforge.net/mailmanager/?rev=3704&view=rev
Author:   kevca
Date:     2006-11-25 05:51:38 -0800 (Sat, 25 Nov 2006)

Log Message:
-----------
More MS SQL Fixes

Modified Paths:
--------------
    MailManager/branches/RELENG_2_2/MailManager.py
    MailManager/branches/RELENG_2_2/Makefile
    MailManager/branches/RELENG_2_2/sql/v2_2/getSession.zsql
    MailManager/branches/RELENG_2_2/sql/v2_2/listTickets.zsql
    MailManager/branches/RELENG_2_2/support/Database.py
    MailManager/branches/RELENG_2_2/www/AccountSettings.zpt
    MailManager/branches/RELENG_2_2/www/UserSettings.zpt
    MailManager/branches/RELENG_2_2/www/manage_addMailManagerForm.zpt

Modified: MailManager/branches/RELENG_2_2/MailManager.py
===================================================================
--- MailManager/branches/RELENG_2_2/MailManager.py	2006-11-14 21:02:44 UTC (rev 3703)
+++ MailManager/branches/RELENG_2_2/MailManager.py	2006-11-25 13:51:38 UTC (rev 3704)
@@ -2295,7 +2295,8 @@
             for entry in res:
                 newentry = {}
                 for state in states:
-                    newentry[state] = entry['%s_count' % state]
+                    newentry[state] = getattr(entry, '%s_count' % state, 0)
+                newentry['email'] = entry.email
                 mapres.append(newentry)
             return mapres
         else:
@@ -2308,7 +2309,8 @@
                 for entry in res:
                     newentry = {}
                     for state in states:
-                        newentry[state] = entry['%s_count' % state]
+                        newentry[state] = getattr(entry, '%s_count' % state, 0)
+                    newentry['email'] = entry.email
                     mapres.append(newentry)
                 return mapres
                         
@@ -4594,7 +4596,10 @@
         search['account_id'] = unicode(account_id, 'utf-8')
         search['from_date'] = from_date
         search['to_date'] = to_date
-        search['assigned'] = unicode(assigned, 'utf-8')
+        if type(assigned) is list:
+            search['assigned'] = unicode(assigned, 'utf-8')
+        else:
+            search['assigned'] = [unicode(a, 'utf-8') for a in assigned]
         search['state'] = unicode(state, 'utf-8')
         search['priority'] = priority or ''
         search['category0'] = unicode(category0, 'utf-8')

Modified: MailManager/branches/RELENG_2_2/Makefile
===================================================================
--- MailManager/branches/RELENG_2_2/Makefile	2006-11-14 21:02:44 UTC (rev 3703)
+++ MailManager/branches/RELENG_2_2/Makefile	2006-11-25 13:51:38 UTC (rev 3704)
@@ -30,6 +30,10 @@
 API_DOCS = apidocs
 
 TESTS = $(addprefix tests/, \
+	testRulesetEngine.py \
+	testTicket.py \
+	testQueueing.py \
+	testAutoLogout.py \
 	testGetMail.py \
 	testAPI.py \
 	testXSS.py \
@@ -45,11 +49,7 @@
 	testFilters.py )
 
 MSSQLBROKEN=\
-	testTicket.py \
-	testRulesetEngine.py \
-	testQueueing.py \
 	testZSQL.py \
-	testAutoLogout.py \
 
 DEVTESTS = testConcurrency.py \
 	testPerformance.py

Modified: MailManager/branches/RELENG_2_2/sql/v2_2/getSession.zsql
===================================================================
--- MailManager/branches/RELENG_2_2/sql/v2_2/getSession.zsql	2006-11-14 21:02:44 UTC (rev 3703)
+++ MailManager/branches/RELENG_2_2/sql/v2_2/getSession.zsql	2006-11-25 13:51:38 UTC (rev 3704)
@@ -5,9 +5,18 @@
 arguments:sqv_session_id
 </dtml-comment>
 
-SELECT * FROM <dtml-var schema>mm_session 
+SELECT
+
+<dtml-if expr="sql_database=='mssql'">
+  TOP 1
+</dtml-if>
+
+  * FROM <dtml-var schema>mm_session  
   <dtml-sqlgroup where>
     <dtml-sqltest sqv_session_id column="session_id" type="nb" optional>
   </dtml-sqlgroup>
   ORDER BY accessed DESC
-LIMIT 1
+
+<dtml-if expr="sql_database!='mssql'">
+  LIMIT 1
+</dtml-if>

Modified: MailManager/branches/RELENG_2_2/sql/v2_2/listTickets.zsql
===================================================================
--- MailManager/branches/RELENG_2_2/sql/v2_2/listTickets.zsql	2006-11-14 21:02:44 UTC (rev 3703)
+++ MailManager/branches/RELENG_2_2/sql/v2_2/listTickets.zsql	2006-11-25 13:51:38 UTC (rev 3704)
@@ -27,6 +27,13 @@
 
 SELECT
 
+    <dtml-if sqv_limit>
+      <dtml-if expr="sql_database == 'mssql'">
+        TOP <dtml-var sqv_limit>
+      </dtml-if>
+    </dtml-if>
+
+
     <dtml-if sqv_count>
       COUNT(1) AS count
     <dtml-else>

Modified: MailManager/branches/RELENG_2_2/support/Database.py
===================================================================
--- MailManager/branches/RELENG_2_2/support/Database.py	2006-11-14 21:02:44 UTC (rev 3703)
+++ MailManager/branches/RELENG_2_2/support/Database.py	2006-11-25 13:51:38 UTC (rev 3704)
@@ -124,7 +124,7 @@
             'sql_true': 1,
             'sql_false': 0,
             'sql_varchar': 'NVARCHAR',
-            'sql_smalltext': 'NVARCHAR(800)',
+            'sql_smalltext': 'NVARCHAR(256)',
             'sql_largetext': 'NTEXT',
             'sql_integer': 'INT',
             'sql_bigint': 'BIGINT',

Modified: MailManager/branches/RELENG_2_2/www/AccountSettings.zpt
===================================================================
--- MailManager/branches/RELENG_2_2/www/AccountSettings.zpt	2006-11-14 21:02:44 UTC (rev 3703)
+++ MailManager/branches/RELENG_2_2/www/AccountSettings.zpt	2006-11-25 13:51:38 UTC (rev 3704)
@@ -261,7 +261,7 @@
           </tr>
 
           <tr tal:define="current_categories python:(default_category0, default_category1, default_category2)"
-              tal:repeat="cat python:here.sql.listCategories(sqv_enabled=here.sql_truevar)">
+              tal:repeat="cat python:here.sql.listCategories(sqv_enabled=here.sql_bool(True))">
             <td>
               <label tal:attributes="for string:default_category${cat/id}"
                      tal:content="cat/label">Category</label>

Modified: MailManager/branches/RELENG_2_2/www/UserSettings.zpt
===================================================================
--- MailManager/branches/RELENG_2_2/www/UserSettings.zpt	2006-11-14 21:02:44 UTC (rev 3703)
+++ MailManager/branches/RELENG_2_2/www/UserSettings.zpt	2006-11-25 13:51:38 UTC (rev 3704)
@@ -170,7 +170,7 @@
 
       <h2 i18n:translate="categories_user_can_deal">Categories of tickets this user can deal with</h2>
       <table border="0" cellpadding="0" cellspacing="0">
-        <tr tal:repeat="cat python:here.sql.listCategories(sqv_enabled=here.sql_truevar)">
+        <tr tal:repeat="cat python:here.sql.listCategories(sqv_enabled=here.sql_bool(True))">
           <td>
             <!-- User abilities for queue assignment. 
             For each category, list all options in that category, and mark any

Modified: MailManager/branches/RELENG_2_2/www/manage_addMailManagerForm.zpt
===================================================================
--- MailManager/branches/RELENG_2_2/www/manage_addMailManagerForm.zpt	2006-11-14 21:02:44 UTC (rev 3703)
+++ MailManager/branches/RELENG_2_2/www/manage_addMailManagerForm.zpt	2006-11-25 13:51:38 UTC (rev 3704)
@@ -110,6 +110,7 @@
         <select name="dbplatform">
           <option value="postgres">PostgreSQL</option>
           <option value="mysql">MySQL</option>
+          <option value="mssql">Microsoft SQL Server</option>
         </select>
       </td>
     </tr>


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

SF.net SVN: mailmanager: [3706] MailManager/branches/RELENG_2_2

From: <kevca@us...> - 2006-11-25 18:48

Revision: 3706
          http://svn.sourceforge.net/mailmanager/?rev=3706&view=rev
Author:   kevca
Date:     2006-11-25 10:48:02 -0800 (Sat, 25 Nov 2006)

Log Message:
-----------
Changes for MS-SQL
Can now use the schema variable as a prefix on tables to separate them.

Modified Paths:
--------------
    MailManager/branches/RELENG_2_2/MailManager.py
    MailManager/branches/RELENG_2_2/sql/v2_2/accountPriority.zsql
    MailManager/branches/RELENG_2_2/sql/v2_2/getNextMessageId.zsql
    MailManager/branches/RELENG_2_2/sql/v2_2/getNextRulesetTransitionId.zsql
    MailManager/branches/RELENG_2_2/sql/v2_2/listTickets.zsql
    MailManager/branches/RELENG_2_2/sql/v2_2/userPriority.zsql
    MailManager/branches/RELENG_2_2/sql/v2_2/userStatus.zsql

Modified: MailManager/branches/RELENG_2_2/MailManager.py
===================================================================
--- MailManager/branches/RELENG_2_2/MailManager.py	2006-11-25 17:53:20 UTC (rev 3705)
+++ MailManager/branches/RELENG_2_2/MailManager.py	2006-11-25 18:48:02 UTC (rev 3706)
@@ -262,10 +262,6 @@
              raise BadRequest, translateString('Admin Password and Confirm Admin Password fields must match.', 
                                  'admin_password_mismatch',
                                  REQUEST=self)
-         if schema and dbplatform != 'postgres':
-             raise BadRequest, translateString('Schemas are only supported on PostgreSQL.', 
-                                'schemas_unavailable',
-                                REQUEST=self)
      except BadRequest, msg:
          if REQUEST is not None:
              REQUEST.set('manage_tabs_message', msg)
@@ -913,10 +909,16 @@
         # support a schema, so it defaults to the empty string.  Adding a
         # trailing '.' here vastly simplifies the zsql methods.
         schema = getattr(self, 'schema', schema)
-        if schema.endswith('.') or not schema:
-            self.schema = schema.lower()
+
+        # Map to schemas in postgres. With other database platforms, schema can be
+        # used as a prefix instead.
+        if dbplatform == 'postgres':
+            if schema.endswith('.') or not schema:
+                self.schema = schema.lower()
+            else:
+                self.schema = schema.lower() + '.'
         else:
-            self.schema = schema.lower() + '.'
+            self.schema = schema
 
         # Always replace the SQL object, as we need to sync this with the
         # directory contents of the filesystem

Modified: MailManager/branches/RELENG_2_2/sql/v2_2/accountPriority.zsql
===================================================================
--- MailManager/branches/RELENG_2_2/sql/v2_2/accountPriority.zsql	2006-11-25 17:53:20 UTC (rev 3705)
+++ MailManager/branches/RELENG_2_2/sql/v2_2/accountPriority.zsql	2006-11-25 18:48:02 UTC (rev 3706)
@@ -6,16 +6,16 @@
 </dtml-comment>
 SELECT email,
        (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket
-        WHERE priority=1 AND mm_ticket.account_id=email) AS junk,
+        WHERE priority=1 AND <dtml-var schema>mm_ticket.account_id=email) AS junk,
        (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket
-        WHERE priority=2 AND mm_ticket.account_id=email) AS low,
+        WHERE priority=2 AND <dtml-var schema>mm_ticket.account_id=email) AS low,
        (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket
-        WHERE priority=3 AND mm_ticket.account_id=email) AS normal,
+        WHERE priority=3 AND <dtml-var schema>mm_ticket.account_id=email) AS normal,
        (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket
-        WHERE priority=4 AND mm_ticket.account_id=email) AS high,
+        WHERE priority=4 AND <dtml-var schema>mm_ticket.account_id=email) AS high,
        (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket
-        WHERE priority=5 AND mm_ticket.account_id=email) AS critical
+        WHERE priority=5 AND <dtml-var schema>mm_ticket.account_id=email) AS critical
 FROM <dtml-var schema>mm_account, <dtml-var schema>mm_ticket
-WHERE mm_ticket.account_id=mm_account.email
-GROUP BY mm_account.email
-ORDER BY mm_account.email;
+WHERE <dtml-var schema>mm_ticket.account_id=<dtml-var schema>mm_account.email
+GROUP BY <dtml-var schema>mm_account.email
+ORDER BY <dtml-var schema>mm_account.email;

Modified: MailManager/branches/RELENG_2_2/sql/v2_2/getNextMessageId.zsql
===================================================================
--- MailManager/branches/RELENG_2_2/sql/v2_2/getNextMessageId.zsql	2006-11-25 17:53:20 UTC (rev 3705)
+++ MailManager/branches/RELENG_2_2/sql/v2_2/getNextMessageId.zsql	2006-11-25 18:48:02 UTC (rev 3706)
@@ -7,7 +7,7 @@
 <dtml-if expr="sql_database == 'postgres'">
   SELECT nextval('<dtml-var schema>mm_message_id_seq') AS id
 <dtml-elif expr="sql_database == 'mssql'">
-  SELECT COALESCE(MAX(id),0)+1 AS id FROM mm_message 
+  SELECT COALESCE(MAX(id),0)+1 AS id FROM <dtml-var schema>mm_message 
 <dtml-else>
-  SELECT COALESCE(MAX(id),0)+1 AS id FROM mm_message FOR UPDATE
+  SELECT COALESCE(MAX(id),0)+1 AS id FROM <dtml-var schema>mm_message FOR UPDATE
 </dtml-if>

Modified: MailManager/branches/RELENG_2_2/sql/v2_2/getNextRulesetTransitionId.zsql
===================================================================
--- MailManager/branches/RELENG_2_2/sql/v2_2/getNextRulesetTransitionId.zsql	2006-11-25 17:53:20 UTC (rev 3705)
+++ MailManager/branches/RELENG_2_2/sql/v2_2/getNextRulesetTransitionId.zsql	2006-11-25 18:48:02 UTC (rev 3706)
@@ -8,7 +8,7 @@
 <dtml-if expr="sql_database == 'postgres'">
   SELECT nextval('<dtml-var schema>mm_ruleset_transitions_transition_id_seq') AS transition_id
 <dtml-elif expr="sql_database == 'mssql'">
-  SELECT COALESCE(MAX(transition_id),0)+1 AS transition_id FROM mm_ruleset_transitions 
+  SELECT COALESCE(MAX(transition_id),0)+1 AS transition_id FROM <dtml-var schema>mm_ruleset_transitions 
 <dtml-else>
-  SELECT COALESCE(MAX(transition_id),0)+1 AS transition_id FROM mm_ruleset_transitions FOR UPDATE
+  SELECT COALESCE(MAX(transition_id),0)+1 AS transition_id FROM <dtml-var schema>mm_ruleset_transitions FOR UPDATE
 </dtml-if>

Modified: MailManager/branches/RELENG_2_2/sql/v2_2/listTickets.zsql
===================================================================
--- MailManager/branches/RELENG_2_2/sql/v2_2/listTickets.zsql	2006-11-25 17:53:20 UTC (rev 3705)
+++ MailManager/branches/RELENG_2_2/sql/v2_2/listTickets.zsql	2006-11-25 18:48:02 UTC (rev 3706)
@@ -40,11 +40,11 @@
 
       <dtml-if sqv_id_only>
 
-        mm_ticket.id 
+        <dtml-var schema>mm_ticket.id 
 
       <dtml-else>
 
-        mm_ticket.*
+        <dtml-var schema>mm_ticket.*
         <dtml-if sqv_searchText>
           <dtml-if expr="sql_database == 'postgres'">
     
@@ -71,7 +71,7 @@
 FROM <dtml-var schema>mm_ticket
 
 <dtml-if expr="sql_database == 'mysql'">
-  INNER JOIN mm_ticket_index ON mm_ticket.id = mm_ticket_index.id
+  INNER JOIN mm_ticket_index ON <dtml-var schema>mm_ticket.id = <dtml-var schema>mm_ticket_index.id
 </dtml-if>
 
 <dtml-comment>    
@@ -107,11 +107,11 @@
 
       <dtml-if sqv_sort_on>
         <dtml-if expr="not sqv_sort_on=='state'">
-          WHERE mm_ticket.id IN (SELECT id
+          WHERE <dtml-var schema>mm_ticket.id IN (SELECT id
           FROM <dtml-var schema>mm_ticket
         </dtml-if>
       <dtml-else>
-        WHERE mm_ticket.id IN (SELECT id
+        WHERE <dtml-var schema>mm_ticket.id IN (SELECT id
         FROM <dtml-var schema>mm_ticket
       </dtml-if>
       
@@ -120,11 +120,11 @@
 
     <dtml-if sqv_sort_on>
       <dtml-if expr="not sqv_sort_on=='state'">
-        WHERE mm_ticket.id IN (SELECT id
+        WHERE <dtml-var schema>mm_ticket.id IN (SELECT id
         FROM <dtml-var schema>mm_ticket
       </dtml-if>
     <dtml-else>
-      WHERE mm_ticket.id IN (SELECT id
+      WHERE <dtml-var schema>mm_ticket.id IN (SELECT id
       FROM <dtml-var schema>mm_ticket
     </dtml-if>
 
@@ -133,7 +133,9 @@
 
 
 <dtml-sqlgroup where>
-    <dtml-sqltest sqv_ticket_id type="int" column="mm_ticket.id" optional>
+    <dtml-if sqv_ticket_id>
+      <dtml-var schema>mm_ticket.id = <dtml-sqlvar sqv_ticket_id type="int">
+    </dtml-if>
   <dtml-and>
     <dtml-sqltest sqv_state column="state" type="nb" multiple optional>
   <dtml-and>

Modified: MailManager/branches/RELENG_2_2/sql/v2_2/userPriority.zsql
===================================================================
--- MailManager/branches/RELENG_2_2/sql/v2_2/userPriority.zsql	2006-11-25 17:53:20 UTC (rev 3705)
+++ MailManager/branches/RELENG_2_2/sql/v2_2/userPriority.zsql	2006-11-25 18:48:02 UTC (rev 3706)
@@ -6,16 +6,16 @@
 </dtml-comment>
 SELECT username,
        (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket
-        WHERE priority=1 AND mm_ticket.assigned=username) AS junk,
+        WHERE priority=1 AND <dtml-var schema>mm_ticket.assigned=username) AS junk,
        (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket
-        WHERE priority=2 AND mm_ticket.assigned=username) AS low,
+        WHERE priority=2 AND <dtml-var schema>mm_ticket.assigned=username) AS low,
        (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket
-        WHERE priority=3 AND mm_ticket.assigned=username) AS normal,
+        WHERE priority=3 AND <dtml-var schema>mm_ticket.assigned=username) AS normal,
        (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket
-        WHERE priority=4 AND mm_ticket.assigned=username) AS high,
+        WHERE priority=4 AND <dtml-var schema>mm_ticket.assigned=username) AS high,
        (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket
-        WHERE priority=5 AND mm_ticket.assigned=username) AS critical
+        WHERE priority=5 AND <dtml-var schema>mm_ticket.assigned=username) AS critical
 FROM <dtml-var schema>mm_user, <dtml-var schema>mm_ticket
-WHERE mm_ticket.assigned=mm_user.username
-GROUP BY mm_user.username
-ORDER BY mm_user.username;
+WHERE <dtml-var schema>mm_ticket.assigned=<dtml-var schema>mm_user.username
+GROUP BY <dtml-var schema>mm_user.username
+ORDER BY <dtml-var schema>mm_user.username;

Modified: MailManager/branches/RELENG_2_2/sql/v2_2/userStatus.zsql
===================================================================
--- MailManager/branches/RELENG_2_2/sql/v2_2/userStatus.zsql	2006-11-25 17:53:20 UTC (rev 3705)
+++ MailManager/branches/RELENG_2_2/sql/v2_2/userStatus.zsql	2006-11-25 18:48:02 UTC (rev 3706)
@@ -9,19 +9,19 @@
 </dtml-comment>
 SELECT username,
        (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket
-        WHERE state='Open' AND mm_ticket.assigned=username) AS open_count,
+        WHERE state='Open' AND <dtml-var schema>mm_ticket.assigned=username) AS open_count,
        (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket
-        WHERE state='Hold' AND mm_ticket.assigned=username) AS hold_count,
+        WHERE state='Hold' AND <dtml-var schema>mm_ticket.assigned=username) AS hold_count,
        (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket
-        WHERE state='Closed' AND mm_ticket.assigned=username) AS closed_count,
+        WHERE state='Closed' AND <dtml-var schema>mm_ticket.assigned=username) AS closed_count,
        (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket
-        WHERE state='Spam' AND mm_ticket.assigned=username) AS spam_count,
+        WHERE state='Spam' AND <dtml-var schema>mm_ticket.assigned=username) AS spam_count,
        (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket
-        WHERE unread=<dtml-var sql_true> AND mm_ticket.assigned=username) AS new_count,
+        WHERE unread=<dtml-var sql_true> AND <dtml-var schema>mm_ticket.assigned=username) AS new_count,
        (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket
         WHERE respond_by < <dtml-var sql_now> AND state='Open'
-        AND date_responded IS NULL AND mm_ticket.assigned=username) AS overdue_count
+        AND date_responded IS NULL AND <dtml-var schema>mm_ticket.assigned=username) AS overdue_count
 FROM <dtml-var schema>mm_user, <dtml-var schema>mm_ticket
-WHERE mm_ticket.assigned=mm_user.username
-GROUP BY mm_user.username
-ORDER BY mm_user.username;
+WHERE <dtml-var schema>mm_ticket.assigned=<dtml-var schema>mm_user.username
+GROUP BY <dtml-var schema>mm_user.username
+ORDER BY <dtml-var schema>mm_user.username;


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

SF.net SVN: mailmanager: [3705] MailManager/branches/RELENG_2_2/sql/v2_2/ performanceByCategory.zsql

From: <kevca@us...> - 2006-11-25 17:53

Revision: 3705
          http://svn.sourceforge.net/mailmanager/?rev=3705&view=rev
Author:   kevca
Date:     2006-11-25 09:53:20 -0800 (Sat, 25 Nov 2006)

Log Message:
-----------
Fix from MSSQL port

Modified Paths:
--------------
    MailManager/branches/RELENG_2_2/sql/v2_2/performanceByCategory.zsql

Modified: MailManager/branches/RELENG_2_2/sql/v2_2/performanceByCategory.zsql
===================================================================
--- MailManager/branches/RELENG_2_2/sql/v2_2/performanceByCategory.zsql	2006-11-25 13:51:38 UTC (rev 3704)
+++ MailManager/branches/RELENG_2_2/sql/v2_2/performanceByCategory.zsql	2006-11-25 17:53:20 UTC (rev 3705)
@@ -30,7 +30,7 @@
          </dtml-raise>
        </dtml-if>
 FROM <dtml-var schema>mm_ticket
-INNER JOIN <dtml-var schema>
+INNER JOIN 
     ( SELECT choice as category<dtml-var sqv_category_id> FROM <dtml-var schema>mm_category_choices 
         WHERE category_id = <dtml-sqlvar sqv_category_id type="nb">
     ) AS cat_select


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.