How to access a database from Yate's Javascript module
From Yate Documentation
(Difference between revisions)
Line 1: | Line 1: | ||
+ | ===Configure script in Javascript module=== | ||
+ | |||
+ | To configure a script for Javascript routing it must be listed in the javascript.conf file: | ||
+ | |||
+ | [general] | ||
+ | routing=example.js | ||
+ | |||
+ | |||
+ | ===Configure database account=== | ||
+ | |||
+ | |||
+ | |||
=== DB Example=== | === DB Example=== | ||
Revision as of 12:13, 19 March 2013
Configure script in Javascript module
To configure a script for Javascript routing it must be listed in the javascript.conf file:
[general] routing=example.js
Configure database account
DB Example
This example uses Javascript to retrieve information from DB
// Get DB Object var m = new Message("database"); // Specify connection to use m.account = "yateadmin"; // Define Query m.query = "SELECT * FROM lines WHERE location IS NOT NULL ORDER BY line LIMIT 5"; // Run the Query if (m.dispatch()) { if (m.rows > 0) { Engine.output("Got " + m.rows + " records of " + m.columns + " fields"); Engine.output("result[0,0] = " + m.getResult(0,0)); var res = m.getColumn("location"); for (var i = 0; i < res.length; i++) { Engine.output("location[" + i + "] = " + res[i]); } } } else { Engine.output("Query failed"); }