Chris A. Icide
2004-Nov-04 14:28 UTC
[Asterisk-Users] Looking for a SQL or ODBC Application
Is anyone aware of an Asterisk application that allows you to read and write values to multiple tables in a database. Im not looking for an app that will let me externalize asterisk's database. I'm looking for one that will let me do normal SQL like queries and inserts. An example: exten => _XX.,1,SQL(PEER=Select peer from egress where route_id=1) ... exten => _XX.,1,SQL(update egress set technology='Zap' where route_id=1) etc. Chris
Kristian Kielhofner
2004-Nov-04 14:36 UTC
[Asterisk-Users] Looking for a SQL or ODBC Application
Chris A. Icide wrote:> Is anyone aware of an Asterisk application that allows you to read and > write values to multiple tables in a database. Im not looking for an > app that will let me externalize asterisk's database. I'm looking for > one that will let me do normal SQL like queries and inserts. An example: > > exten => _XX.,1,SQL(PEER=Select peer from egress where route_id=1) > > ... > > exten => _XX.,1,SQL(update egress set technology='Zap' where route_id=1) > > etc. > > Chris >Chris, Look at res_sqlite (if you can find it, wiki still seems to be down) I think that should work for you. -- Kristian Kielhofner
William Suffill
2004-Nov-04 14:37 UTC
[Asterisk-Users] Looking for a SQL or ODBC Application
there should be 1 addons for mysql and anthm wrote res_sqlite which would add the same functionality but use sqlite to backend it
Chris A. Icide
2004-Nov-04 14:52 UTC
[Asterisk-Users] Looking for a SQL or ODBC Application
Thanks, I just found the add-ons one while searching mantis. This looks like exactly what I was looking for. -Chris On 01:37 PM 11/4/2004, William Suffill wrote: >there should be 1 addons for mysql and anthm wrote res_sqlite which >would add the same functionality but use sqlite to backend it >_______________________________________________ >Asterisk-Users mailing list >Asterisk-Users@lists.digium.com >http://lists.digium.com/mailman/listinfo/asterisk-users >To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users
Chris A. Icide wrote:> Is anyone aware of an Asterisk application that allows you to read and > write values to multiple tables in a database. Im not looking for an > app that will let me externalize asterisk's database. I'm looking for > one that will let me do normal SQL like queries and inserts. An example: > > exten => _XX.,1,SQL(PEER=Select peer from egress where route_id=1) > > ... > > exten => _XX.,1,SQL(update egress set technology='Zap' where route_id=1) > > etc. > > Chris > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > > >There along the with others already mentioned, there is also app_sql_postgres that allows execution of any SQL against Postgresql. It's commented out in the apps/Makefile file by default so you will need to uncomment it to build it. David