Subscriptions - Revision history

Monica: /* subscription_set */

2015-04-07T15:05:16Z

‎subscription_set

2015-04-07T15:05:07Z

‎subscription_set

2015-04-07T15:04:54Z

‎subscription_set

2015-04-07T15:04:20Z

‎subscription_set

2013-11-04T11:22:06Z

2013-06-05T08:54:00Z

2013-06-05T08:43:47Z

‎Example create tables

2013-06-05T08:43:18Z

‎Example create tables

2013-06-05T08:38:00Z

‎Example for stored procedures

2013-06-05T08:08:30Z

@@ Line 97: / Line 97: @@
       END IF;
       <!--return '''';-->
-      return '''''''''';
+      return ''''''''';
   END;
   $_$

@@ Line 97: / Line 97: @@
       END IF;
       <!--return '''';-->
-      return '''''''';
+      return '''''''''';
   END;
   $_$

@@ Line 96: / Line 96: @@
           UPDATE roster SET subscription=_sub WHERE username=_username AND contact=_contact;
       END IF;
-      return \'\'\'\';
+      <!--return '''';-->
   END;
   $_$

@@ Line 96: / Line 96: @@
           UPDATE roster SET subscription=_sub WHERE username=_username AND contact=_contact;
       END IF;
-      return '''';
+      return \'\'\'\';
   END;
   $_$

← Older revision		Revision as of 11:22, 4 November 2013
Line 159:		Line 159:
	* [[Telephony]]		* [[Telephony]]
	* [[Modules#Resource_subscribe.2Fnotify_modules\|Modules]]		* [[Modules#Resource_subscribe.2Fnotify_modules\|Modules]]
		+
		+	[[Category:Database]] [[Category:Subscribe]]

@@ Line 2: / Line 2: @@
 This module permit to configure the database account name and queries used to retrieve and update users' roster.<br>
 You can use database stored procedures to make sure that the update is done for the existing rows that were already added.
 == Example create tables==
@@ Line 24: / Line 26: @@
   );
-== Configuration ==
+== Configuration file ==
 subscription.conf

@@ Line 17: / Line 17: @@
         groups text
   );
-−
   CREATE TABLE subscriptions (
         notifier text NOT NULL,
         event text NOT NULL,
-        subscription text
+        subscriber text
   );

@@ Line 16: / Line 16: @@
         name text,
         groups text
   );

@@ Line 70: / Line 70: @@
 ==Example for stored procedures==
-'''subscription_set''' will be used to add or update a roster item subscription. Return values will be the added/updated row.
+===subscription_set===
   CREATE FUNCTION subscription_set(text, text, text) RETURNS text
@@ Line 90: / Line 92: @@
   $_$
       LANGUAGE plpgsql;
 roster_set
-Add or update a roster item
+===roster_set===
-Return added/updated row
   CREATE FUNCTION roster_set(text, text, text, text) RETURNS SETOF record
      AS $_$
@@ Line 115: / Line 119: @@
      LANGUAGE plpgsql;

@@ Line 2: / Line 2: @@
 This module permit to configure the database account name and queries used to retrieve and update users' roster.<br>
 You can use database stored procedures to make sure that the update is done for the existing rows that were already added.
 == Example create tables==
@@ Line 8: / Line 9: @@
       password text,
   );
-−
   CREATE TABLE roster (
         username text NOT NULL,
@@ Line 66: / Line 67: @@
   ; contact_delete: string: Database query used to delete a specific contact
   ;contact_delete=DELETE FROM roster WHERE username='${username}' AND contact='${contact}'