Macros For MySQL Functions - Revision history

Casey at 19:45, 13 June 2013

2013-06-13T19:45:30Z

Casey at 19:44, 13 June 2013

2013-06-13T19:44:04Z

Casey at 19:42, 13 June 2013

2013-06-13T19:42:25Z

Casey at 19:36, 13 June 2013

2013-06-13T19:36:39Z

Casey at 19:12, 13 June 2013

2013-06-13T19:12:58Z

Casey at 19:10, 13 June 2013

2013-06-13T19:10:55Z

Casey at 19:03, 13 June 2013

2013-06-13T19:03:24Z

Casey: Created page with "

 ; ==== MYSQL FETCH ============================================================ [macro-MYSQL..."

2013-06-13T18:56:55Z

Created page with "<PRE style="color:white;background-color:black;font-weight:bold;font-size:1.2em;"> ; ==== MYSQL FETCH ============================================================ [macro-MYSQL..."

New page

<PRE style="color:white;background-color:black;font-weight:bold;font-size:1.2em;">
; ==== MYSQL FETCH ============================================================
[macro-MYSQLFETCH]

exten => s,1,MYSQL(Connect connid localhost asterisk yourpassword asterisk)
exten => s,n,MYSQL(Query resultid ${connid} ${ARG2})
exten => s,n,MYSQL(Fetch fetchid ${resultid} ${ARG1})
exten => s,n,MYSQL(Clear ${resultid})
exten => s,n,MYSQL(Disconnect ${connid})

; ==== MYSQL UPDATE ===========================================================
[macro-MYSQLUPDATE]
exten => s,1,MYSQL(Connect connid localhost asterisk yourpassword asterisk)
exten => s,n,MYSQL(Query resultid ${connid} ${URIDECODE(${ARG1})})
exten => s,n,MYSQL(Disconnect ${connid})
</PRE>

@@ Line 8: / Line 8: @@
 ===Macro===
-<PRE style="color:white;background-color:black;font-weight:bold;font-size:1.2em;">
+<PRE>
 [macro-MYSQLFETCH]
 exten => s,1,MYSQL(Connect CONNID localhost databaseuser databasepassword databasename)
@@ Line 42: / Line 42: @@
 ===Macro===
-<PRE style="color:white;background-color:black;font-weight:bold;font-size:1.2em;">
+<PRE>
 [macro-MYSQLUPDATE]
 exten => s,1,MYSQL(Connect CONNID localhost databaseuser databasepassword databasename)

← Older revision		Revision as of 19:44, 13 June 2013
Line 38:		Line 38:
	This is used for doing inserts, updates, deletes, etc.		This is used for doing inserts, updates, deletes, etc.

−	Note the use of the URIENCODE and URIDECODE functions. This allows the values in the query to contain commas (ie. "Smith, John"). Otherwise, if a macro is called, and an argument contains a comma, it will appears as multiple arguments.	+	Note the use of the URIENCODE and URIDECODE functions. This allows the values in the query to contain commas (ie. "Smith, John"). Otherwise, if a macro is called, and an argument contains a comma, it will appears as multiple arguments. For example, if MYMACRO were called with ARG1 as "Smith, John" and ARG2 as "123-456-7890", the result would be: '''s,n,Macro(MYMACRO,<FONT COLOR=red>"Smith</FONT>,<FONT COLOR=blue>John"</FONT>,<FONT COLOR=GREEN>123-456-7890</FONT>)''' which would be three arguments, not two.
−
−	~~Ie:~~ if MYMACRO were called with ARG1 as "Smith, John" and ARG2 as "123-456-7890", the result would be: '''s,n,Macro(MYMACRO,"Smith,John",123-456-7890)''' which would be three arguments, not two.

@@ Line 1: / Line 1: @@
 ==To Fetch Data From MySQL==
 <PRE style="color:white;background-color:black;font-weight:bold;font-size:1.2em;">
 [macro-MYSQLFETCH]
@@ Line 10: / Line 17: @@
 </PRE>
-To call the macro:
 <PRE>
 Macro(MYSQLFETCH,RETURNEDVALUE,QUERY)
@@ Line 16: / Line 24: @@
 RETURNEDVALUE is the value to be returned from the database query.  QUERY is the query to be issued to the database.
 ====Example====
@@ Line 27: / Line 36: @@
 ==To Perform Other Queries MySQL==
 This is used for doing inserts, updates, deletes, etc.
 <PRE style="color:white;background-color:black;font-weight:bold;font-size:1.2em;">
 [macro-MYSQLUPDATE]
@@ Line 36: / Line 51: @@
 </PRE>
-To call the macro:
 <PRE>
 Macro(MYSQLUPDATE,${URIENCODE(QUERY)})
@@ Line 42: / Line 58: @@
 QUERY is the query/action to be issued to the database.
 ====Example====
@@ Line 47: / Line 64: @@
 exten => s,n,Macro(MYSQLUPDATE,${URIENCODE(UPDATE blacklist SET lastcalled=NOW() WHERE number="${CALLERID(number)}")})
 </PRE>

@@ Line 11: / Line 11: @@
 To call the macro:
 <PRE style="color:white;background-color:black;font-weight:bold;font-size:1.2em;">
 exten => s,n,Macro(MYSQLFETCH,DNDVALUE,SELECT value FROM features WHERE name="dnd" AND subname="status")
 exten => s,n,GotoIf($[${DNDVALUE} = 1 ]?LINEISDND,s,1)
 </PRE>
 ==To Perform Other Queries MySQL==
@@ Line 29: / Line 37: @@
 To call the macro:
 <PRE style="color:white;background-color:black;font-weight:bold;font-size:1.2em;">
 exten => s,n,Macro(MYSQLUPDATE,${URIENCODE(UPDATE blacklist SET lastcalled=NOW() WHERE number="${CALLERID(number)}")})
 </PRE>
-Not the use of the URIENCODE and URIDECODE functions.  This allows the values in the query to contain commas (ie. "Smith, John").  Otherwise, if a macro is called, and an argument contains a comma, it will appears as multiple arguments.
+Note the use of the URIENCODE and URIDECODE functions.  This allows the values in the query to contain commas (ie. "Smith, John").  Otherwise, if a macro is called, and an argument contains a comma, it will appears as multiple arguments.
 Ie: if MYMACRO were called with ARG1 as "Smith, John" and ARG2 as "123-456-7890", the result would be:  '''s,n,Macro(MYMACRO,"Smith,John",123-456-7890)''' which would be three arguments, not two.

@@ Line 3: / Line 3: @@
 <PRE style="color:white;background-color:black;font-weight:bold;font-size:1.2em;">
 [macro-MYSQLFETCH]
-exten => s,1,MYSQL(Connect connid localhost asterisk yourpassword asterisk)
+exten => s,1,MYSQL(Connect CONNID localhost databaseuser databasepassword databasename)
-exten => s,n,MYSQL(Query resultid ${connid} ${ARG2})
+exten => s,n,MYSQL(Query RESULTID ${CONNID} ${ARG2})
-exten => s,n,MYSQL(Fetch fetchid ${resultid} ${ARG1})
+exten => s,n,MYSQL(Fetch FETCHID ${RESULTID} ${ARG1})
-exten => s,n,MYSQL(Clear ${resultid})
+exten => s,n,MYSQL(Clear ${RESULTID})
-exten => s,n,MYSQL(Disconnect ${connid})
+exten => s,n,MYSQL(Disconnect ${RESULTID})
 </PRE>
@@ Line 23: / Line 23: @@
 <PRE style="color:white;background-color:black;font-weight:bold;font-size:1.2em;">
 [macro-MYSQLUPDATE]
-exten => s,1,MYSQL(Connect connid localhost databaseuser databasepassword databasename)
+exten => s,1,MYSQL(Connect CONNID localhost databaseuser databasepassword databasename)
-exten => s,n,MYSQL(Query resultid ${connid} ${URIDECODE(${ARG1})})
+exten => s,n,MYSQL(Query RESULTID ${CONNID} ${URIDECODE(${ARG1})})
-exten => s,n,MYSQL(Disconnect ${connid})
+exten => s,n,MYSQL(Disconnect ${CONNID})
 </PRE>