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
Old 06-27-2013
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..
 

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 Replies)
Discussion started by: amit4g
2 Replies

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... (2 Replies)
Discussion started by: cpd259
2 Replies

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... (3 Replies)
Discussion started by: Mihirjani
3 Replies

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... (3 Replies)
Discussion started by: mohtashims
3 Replies

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... (1 Reply)
Discussion started by: Jamessteevens
1 Replies

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... (5 Replies)
Discussion started by: vrupatel
5 Replies

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.... (3 Replies)
Discussion started by: baris35
3 Replies
PYTHON-CONFIG(1)					      General Commands Manual						  PYTHON-CONFIG(1)

NAME
python-config - output build options for python C/C++ extensions or embedding SYNOPSIS
python-config [ --prefix ] [ --exec-prefix ] [ --includes ] [ --libs ] [ --cflags ] [ --ldflags ] [ --help ] DESCRIPTION
python-config helps compiling and linking programs, which embed the Python interpreter, or extension modules that can be loaded dynamically (at run time) into the interpreter. OPTIONS
--cflags print the C compiler flags. --ldflags print the flags that should be passed to the linker. --includes similar to --cflags but only with -I options (path to python header files). --libs similar to --ldflags but only with -l options (used libraries). --prefix prints the prefix (base directory) under which python can be found. --exec-prefix print the prefix used for executable program directories (such as bin, sbin, etc). --help print the usage message. EXAMPLES
To build the singe-file c program prog against the python library, use gcc $(python-config --cflags --ldflags) progr.cpp -o progr.cpp The same in a makefile: CFLAGS+=$(shell python-config --cflags) LDFLAGS+=$(shell python-config --ldflags) all: progr To build a dynamically loadable python module, use gcc $(python-config --cflags --ldflags) -shared -fPIC progr.cpp -o progr.so SEE ALSO
python (1) http://docs.python.org/extending/extending.html /usr/share/doc/python/faq/extending.html AUTHORS
This manual page was written by Johann Felix Soden <johfel@gmx.de> for the Debian project (and may be used by others). November 27, 2011 PYTHON-CONFIG(1)
All times are GMT -4. The time now is 08:20 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy