[AsteriskBrasil] QueueLog/Mysql

[Wendell Silva]

Vi alguns artigos para armazenas os logs do QueueLog diretamente no Mysql
bom na versão que uso não funcionou, que é 1.4.18.1, então criei alguns
scripts para inserção lendo os arquivos de logs
e inserindo no Mysql vou compartilhar com o pessoal, creio que será
muito interessante para a lista.

Usei Ruby que se torna muito fácil o entendimento do que foi feito.

Segue abaixo:


#############INICIO#########################

require 'rubygems'
require 'mysql'

file="queuelog"
file=File.open(file,"r")
logs={}
i = 1

file.each_line do |linha|
logs[i] = linha.split("|")
i+=1
end

logs.keys.each do |k|
event = logs[k][4]
if event == "COMPLETEAGENT" or event == "COMPLETECALLER"
db = Mysql.real_connect("127.0.0.1", "root", "senha", "banco")
db.real_query("INSERT INTO queue_log values
(NULL,'#{logs[k][3]}','#{logs[k][4]}',NULL,#{logs[k][5]},#{logs[k][6]},#{logs[k][0]},#{logs[k][1]},'#{logs[k][2]}')
")
k+=1

elsif event == "CONNECT"

db = Mysql.real_connect("127.0.0.1", "root", "senha", "banco")
db.real_query("INSERT INTO queue_log values
(NULL,'#{logs[k][3]}','#{logs[k][4]}',NULL,#{logs[k][5]},NULL,#{logs[k][0]},#{logs[k][1]},'#{logs[k][2]}')
")

elsif event == "ENTERQUEUE"

db = Mysql.real_connect("127.0.0.1", "root", "senha", "banco")
db.real_query("INSERT INTO queue_log values
(NULL,NULL,'#{logs[k][4]}','#{logs[k][6]}',NULL,NULL,'#{logs[k][0]}','#{logs[k][1]}','#{logs[k][2]}')
")

elsif event == "AGENTCALLBACKLOGIN"

db = Mysql.real_connect("127.0.0.1", "root", "senha", "banco")
db.real_query("INSERT INTO queue_log values
(NULL,'#{logs[k][3]}','#{logs[k][4]}','#{logs[k][5]}',NULL,NULL,'#{logs[k][0]}','#{logs[k][1]}',NULL)
")

elsif event == "AGENTCALLBACKLOGOFF"
db = Mysql.real_connect("127.0.0.1", "root", "senha", "banco")
db.real_query("INSERT INTO queue_log values
(NULL,'#{logs[k][3]}','#{logs[k][4]}','#{logs[k][5]}',NULL,NULL,'#{logs[k][0]}',NULL,NULL)
")

elsif event == "ABANDON"
db = Mysql.real_connect("127.0.0.1", "root", "senha", "banco")
db.real_query("INSERT INTO queue_log values
(NULL,NULL,'#{logs[k][4]}',NULL,'#{logs[k][5]}','#{logs[k][6]}','#{logs[k][0]}','#{logs[k][1]}','#{logs[k][2]}')
")

else

 puts "Nao existe"

end
end

logs

######################FIM#################################


Att.
-- 
Wendell Silva Bandeira
-------------- Próxima Parte ----------
Um anexo em HTML foi limpo...
URL: http://listas.asteriskbrasil.org/pipermail/asteriskbrasil/attachments/20110210/49f0816b/attachment.htm