#!/usr/bin/python
from ca.cogeco.home.camstuff import agi
import MySQLdb
myagi = agi.AGI()
Result = myagi.Cmd('SAY NUMBER 123 "*#"')
myagi.Write(Result[0])
db = MySQLdb.connect('192.168.1.102')
db.select_db('asterisk_rac')
cursor=db.cursor()
cursor.execute("SELECT datastring FROM test WHERE keystring = '2345'")
result = cursor.fetchone()[0]
Result = myagi.Cmd('SAY DIGITS %s "*#"' % result)
myagi.Write(Result[0])
Result = myagi.Cmd('SET VARIABLE GARBAGE %s' % result)
myagi.Write(Result[0])