Asterisk Engine

Tables:

guid - request reference guid params - add reference to the audio and csv status 0,1 - process start / stop notification

common cdr

id phoneno dialedtime answeredtime dialstatus endtime reason calltype - ivr,voiceplay sipdomain - ipaddress sipcodec -

summary cdr

id
guid
userid
callerid
source
destination
templateid
dialedtime
answeredtime
endtime
dialstatus
reason 
created
updated
deleted

rails g scaffold Record guid:string userid:integer callerid:string source:string destination:string templateid:integer dialedtime:integer answeredtime:integer endtime:integer dialstatus:string reason:string call templates

id name desc flocation mode - 0 - active , 1- inactive timestamp

rails g scaffold CallTemplate name:string desc:string flocation:text mode:integer,{comment => '0- active mode,1 -inactive mode'}

Concept:

/usr/bin/sox "output1.wav" -r 8000 -c 1 -s -2 "output1x.wav"

balaji@balaji-HP-ProBook-440-G1:~$ cat csv\ db/1lakh.csv | wc -l 99999

balaji@balaji-HP-ProBook-440-G1:~$ head -99999 csv\ db/1lakh.csv

To print the fields from second fields to last field, you can omit the last field position.

cut -d':' -f2- file.txt

sed -n 16224,16482p filename > newfile

sed -n 1,16p csv\ db/1lakh.csv

audiomaps

userid audioid guid cliporder status

rails g scaffold AudioMap userid:integer audioid:integer guid:text cliporder:integer status:integer

csvmaps

userid csvid guid status

rails g scaffold CsvMap userid:integer csvid:integer guid:text status:integer

generators

guid userid csvfile csvcount processedcount status

rails g scaffold Generator userid:integer guid:text csvfile:text csvcount:string processedcount:string status:integer

Dialplan Importants

exten => s,1,Set(foo=${CURL(http://somewhere.com/somepage.html?x=5&y=4)}) exten => test,1,NoOp(${FOO})

http://www.voip-info.org/wiki/view/Asterisk+variables

http://www.voip-info.org/wiki/view/Asterisk+func+curl

http://www.voip-info.org/wiki/view/Asterisk+cmd+BackGroundDetect

http://www.voip-info.org/wiki/view/Asterisk+standard+extensions http://the-asterisk-book.com/1.6/besondere-extensions.html http://the-asterisk-book.com/1.6/besondere-extensions.html#o-und-a-extension http://stackoverflow.com/questions/27941411/recursion-in-phpagi-script-of-asterisk-server

Association

rails g scaffold Customer name:string

rails g scaffold Order customer:belongs_to{:index,true} order_date:datetime => Its not properly created

rails g scaffold Order customer:references order_date:datetime

code push into the gitlab local Test Cases

1 million file with 10 mb size tested with 1mb chunk it splitted 10 files into chunk
git remote add origin https://10.20.80.125/barumugam/voicegateway.git

Rspec Notes:

put gem 'rspec-rails', :group => [:development, :test] on gemfile

bundle install

Error: Spring version 1.3.6 is updated in gemfile lock file

rails generate rspec:install

rake db:migrate && rake db:test:prepare

rake spec

rails g rspec:controller Basic -s

Reference : http://stackoverflow.com/questions/4235763/how-do-i-generate-specs-for-existing-controllers