Smarter conditional script with Table Post: 302826543

Sponsored Content

Top Forums Shell Programming and Scripting Smarter conditional script with Table Post 302826543 by jazzyzha on Wednesday 26th of June 2013 11:07:24 PM

06-27-2013

Registered User

Smarter conditional script with Table

Hi, currently I have a script with conditional checking. But it's not flexible to use, because i must create a more conditional script if there are more keyword (see table) required. Question is: Can I create a more smarter script that will be more flexible?
I appreciate any help anyone can give me here to get this to work.
Gracias!

My Table:

Code:

mysql> select * from kontak_group;
+-----------------------------+----------+-------------+-------------------------------+
| group_name                  | group_ID | sms_keyword | email_group                   |
+-----------------------------+----------+-------------+-------------------------------+
| IT Dev                      |        1 | IT          | it.patra@acme.com      |
| IR & Complain               |        2 | IRC         | irc.patra@acme.com     |
| Payroll & Travel Management |        3 | PTM         | ptm.patra@acme.com |
| Adm & Document              |        4 | ADM         | adm.patra@acme.com     |
| Business Support            |        5 | BS          | bs.patra@acme.com      |
+-----------------------------+----------+-------------+-------------------------------+

My script:

Code:

KRITERIA=$(mysql -u root --password=123456 smsd -e "select concat_ws ( '', group_concat(sms_keyword separator '|') ) from kontak_group")

CHECKER=$(mysql -u root --password=123456 smsd -e "SELECT ID, SenderNumber, TextDecoded FROM inbox ORDER BY ReceivingDateTime DESC LIMIT 1  \G" |egrep -w '$KRITERIA' 2> /dev/null)

SPAM=$(mysql -uroot -p123456 smsd -e "INSERT INTO inbox_spam SELECT * FROM inbox WHERE TextDecoded NOT regexp ( select concat_ws ( '', '^(', group_concat(sms_keyword separator '|'), ').*' ) from kontak_group)")

echo $CHECKER | grep ADM > /dev/null
if [ $? -eq 0 ]
then
	message=$message2
	for address in $ADMemails
        do
	      echo $message | mailx -s "$ADMSubject" -a From:$SENDER $EMAIL_ADDRESS
	done
	echo " email sent to ADM contacts"
else
	$SPAM
fi

echo $CHECKER | grep IRC > /dev/null
if [ $? -eq 0 ]
then
	message=$message2
	for address in $HCSemails
        do
	      echo $message | mailx -s "$IRCSubject" -a From:$SENDER $EMAIL_ADDRESS
	done
	echo " email sent to IRC contacts"
else
	$SPAM
fi

echo $CHECKER | grep PTM > /dev/null
if [ $? -eq 0 ]
then
	message=$message2
	for address in $PTMemails
        do
	      echo $message | mailx -s "$PTMSubject" -a From:$SENDER $EMAIL_ADDRESS
	done
	echo " email sent to PTM contacts"
else
	$SPAM
fi

echo $CHECKER | grep BS > /dev/null
if [ $? -eq 0 ]
then
	message=$message2
	for address in $BSemails
        do
	      echo $message | mailx -s "$BSSubject" -a From:$SENDER $EMAIL_ADDRESS
	done
	echo " email sent to BS contacts"
else
	$SPAM
fi

Last edited by jazzyzha; 06-27-2013 at 12:15 AM..

jazzyzha

View Public Profile for jazzyzha

Find all posts by jazzyzha

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Confusion over a small conditional script

Hi, I was going through a file containing hundreds of lines of codes having conditional statement written as: log() { echo $@ } num=$(/usr/bin/rsh <one_machine> -l root 'ls -d /home/user/db* 2> /dev/null' | wc -w) (( num > 0 )) && log "db info:" so,if here the return value(stored in...

2. Shell Programming and Scripting

Conditional Date Script

I am learning Unix for the first time. I am playing around with my default profile file to add some script in the KSH. The time format is GMT and I am in eastern time zone. I am trying to script some greetings based upon the time of day using the IF/ELIF conditions. I am getting errors. I have...

3. Shell Programming and Scripting

unix script for conditional execution

Below is my shell script. I am trying to execute two different BTEQ scripts depending on the day of the week. So on a saturday I will execute a certain BTEQ script and on other weekdays I will run the other script. #!/bin/ksh dt=`date +"%a"` if then bteq > final_output <<- EOF .run...

4. Shell Programming and Scripting

Conditional Execution of a Script.

I have a unix shell script Test.sh more Test.sh echo "Calling dbquery1.sh...." ./dbquery1.sh echo "Calling dbquery2.sh...." ./dbquery2.sh more dbquery1.sh sqlplus -s user1/password1@DB_SID @/tmp/storedprocedures/Hello.rcp I run Test.sh However, I do not want dbquery2.sh to be...

5. Shell Programming and Scripting

Help with conditional clauses for script output

Hello. I am new this site as well as new to shell scripting and this is my first form... Please help me with the following shell script. I am executing a shell script to run every 15 min (scheduled in cronjob) and it gives an output in an output file which is e-mailed. CONCCOUNT=`cat...

6. UNIX for Dummies Questions & Answers

Conditional Script

Hi, I have a script file which has some simple commands. I want these commands to be executed based on the input. Ia m good with IF statement also. At the end it has to be based on incoming value. Example CASE 1 : Execute some commands where Input value as 1 CASE 2 : Execute...

7. Shell Programming and Scripting

Smarter way to read $1 $2 in php

Hello, I am running under ubuntu14.04 with php5. When I run below php, it creates a token, then adds axaxax and bxbxbx into pc database, and at last, kills created token. What I am trying to do is to add userid and password read from a file. I do not wish to enter username and password manually....

LEARN ABOUT DEBIAN

gammu-smsd-inject

GAMMU-SMSD-INJECT(1)						       Gammu						      GAMMU-SMSD-INJECT(1)

NAME

       gammu-smsd-inject - Inject messages into queue of SMS daemon for Gammu

SYNOPSIS

       gammu-smsd-inject [OPTION]... MESSAGETYPE RECIPIENT [MESSAGE_PARAMETER]...

DESCRIPTION

       This manual page documents briefly the gammu-smsd-inject command.

       gammu-smsd-inject is a program that enqueues message in Gammu SMS Daemon, which will be later sent by the daemon using connected GSM modem.

       Support	for this program depends on features available in currently used SMSD service backend, however currently it is supported by all of
       them.

       Program accepts following options (please note that long options might be not accepted on some platforms):

       -h, --help
	      Shows help.

       -v, --version
	      Shows version information and compiled in features.

       -c, --config=file
	      Configuration file to use, default is /etc/gammu-smsdrc, on Windows there is no default and configuration file path has to be always
	      specified.

       -l, --use-log
	      Use logging as configured in config file.

       -L, --no-use-log
	      Do not use logging as configured in config file (default).

       For description of message types and their parameters, please check documentation for gammu savesms.

EXAMPLES

       To check it out, you need to have configuration file for SMSD, see gammu-smsdrc for more details about it.

       Inject text message up to standard 160 chars:

       echo "All your base are belong to us" | gammu-smsd-inject TEXT 123456

       or

       gammu-smsd-inject TEXT 123456 -text "All your base are belong to us"

       Inject long text message:

       echo "All your base are belong to us" | gammu-smsd-inject TEXT 123456 -len 400

       or

       gammu-smsd-inject TEXT 123456 -len 400 -text "All your base are belong to us"

       or

       gammu-smsd-inject EMS 123456 -text "All your base are belong to us"

       Inject some funky message with predefined sound and animation from 2 bitmaps:

       gammu-smsd-inject EMS 123456 -text "Greetings" -defsound 1 -text "from Gammu" -tone10 axelf.txt -animation 2 file1.bmp file2.bmp

       Inject protected message with ringtone:

       gammu-smsd-inject EMS 123456 -protected 2 -variablebitmaplong ala.bmp -toneSElong axelf.txt -toneSE ring.txt

AUTHOR

       Michal iha <michal@cihar.com>

COPYRIGHT

       2009-2012, Michal iha <michal@cihar.com>

1.31.90 							 February 24, 2012					      GAMMU-SMSD-INJECT(1)