[Astlinux-commits] SF.net SVN: astlinux:[5990] branches/1.0/package

[<abe...@us...>]

Revision: 5990
          http://astlinux.svn.sourceforge.net/astlinux/?rev=5990&view=rev
Author:   abelbeck
Date:     2013-03-13 19:43:54 +0000 (Wed, 13 Mar 2013)
Log Message:
-----------
add ODBC DSN 'asterisk-cdr' and automatically support Asterisk ODBC CDR using file /mnt/kd/cdr-sqlite3/cdr-odbc.sqlite3

Modified Paths:
--------------
    branches/1.0/package/asterisk/asterisk.init
    branches/1.0/package/unixodbc/unixodbc.init

Modified: branches/1.0/package/asterisk/asterisk.init
===================================================================
--- branches/1.0/package/asterisk/asterisk.init	2013-03-12 22:11:33 UTC (rev 5989)
+++ branches/1.0/package/asterisk/asterisk.init	2013-03-13 19:43:54 UTC (rev 5990)
@@ -66,8 +66,37 @@
 
   make_symlink_or_dir "/mnt/kd/cdr-custom" "/var/log/asterisk/cdr-custom"
 
+  # Automatically create "/mnt/kd/cdr-sqlite3" directory if it doesn't exist
+  if [ ! -d /mnt/kd/cdr-sqlite3 ]; then
+    mkdir /mnt/kd/cdr-sqlite3 2>/dev/null     # will fail on virgin RO filesystem, ignore stderr
+  fi
   if [ -d /mnt/kd/cdr-sqlite3 ]; then
     ln -sf /mnt/kd/cdr-sqlite3/master.db /var/log/asterisk/master.db
+
+    if [ ! -f /mnt/kd/cdr-sqlite3/cdr-odbc.sqlite3 ]; then
+      sqlite3 -batch /mnt/kd/cdr-sqlite3/cdr-odbc.sqlite3 <<EOF
+CREATE TABLE 'cdr' (
+  'id' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
+  'calldate' TEXT,
+  'clid' TEXT,
+  'src' TEXT,
+  'dst' TEXT,
+  'dcontext' TEXT,
+  'channel' TEXT,
+  'dstchannel' TEXT,
+  'lastapp' TEXT,
+  'lastdata' TEXT,
+  'duration' REAL,
+  'billsec' REAL,
+  'disposition' TEXT,
+  'amaflags' INTEGER,
+  'accountcode' TEXT,
+  'uniqueid' TEXT,
+  'userfield' TEXT
+);
+CREATE VIEW 'standard' AS SELECT calldate, clid, dst, dcontext, billsec, userfield from cdr ORDER BY calldate DESC;
+EOF
+    fi
   fi
 }
 

Modified: branches/1.0/package/unixodbc/unixodbc.init
===================================================================
--- branches/1.0/package/unixodbc/unixodbc.init	2013-03-12 22:11:33 UTC (rev 5989)
+++ branches/1.0/package/unixodbc/unixodbc.init	2013-03-13 19:43:54 UTC (rev 5990)
@@ -86,14 +86,22 @@
 "
   install_odbc_driver "SQLite3" "$DATA"
 
-  # Install DSN
+  # Install DSN's
   DATA="
-Description=SQLite3 database
+Description=Asterisk database
 Driver=SQLite3
 Database=/mnt/kd/asterisk-odbc.sqlite3
 Timeout=2000
 "
   install_odbc_dsn "asterisk" "$DATA"
+
+  DATA="
+Description=CDR ODBC database
+Driver=SQLite3
+Database=/mnt/kd/cdr-sqlite3/cdr-odbc.sqlite3
+Timeout=2000
+"
+  install_odbc_dsn "asterisk-cdr" "$DATA"
 }
 
 stop () {
@@ -101,8 +109,9 @@
   # Remove Driver
   remove_odbc_driver "SQLite3"
 
-  # Remove DSN
+  # Remove DSN's
   remove_odbc_dsn "asterisk"
+  remove_odbc_dsn "asterisk-cdr"
 }
 
 case $1 in

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.