create SQL-statements from textfile with awk

2010-03-08 1 min read Linux

<a href="http://feedproxy.google.com/~r/Command-line-fu/~3/lz9uEhVxEEk/create-sql-statements-from-textfile-with-awk">create SQL-statements from textfile with awk

  <td>
    <div class="text codecolorer">
      $ $ awk \'{printf "select * from table where id = %c%s%c;\\n",39,$1,39; }\' inputfile.txt
    </div>
  </td>
</tr>

inputfile.txt is a space-separated textfile, 1st column contains the items (id) I want to put into my SQL statement.

39 = charactercode for single tick \’

    <td>
      <div class="text codecolorer">
        1 = first column
      </div>
    </td>
  </tr>
</table>

If inputfile.txt is a CSV-file separated by \”,\” use FS= to define your own field-separator:

Bash histoy – common history in different terminals

2010-03-04 1 min read Bash Linux

I have been looking to do this for sometime. The bash history is per
session basis and the last session to quit overwrites the bash_history
file and thus all other terminals started between the time last terminal
lasted does not get to write the commands in the history file. Secondly
the history gets cluttered with lot of duplicate entries and entries
with ls and cd commands. So finally I added these to the bashrc file:

Bash Sub Shells

2010-03-02 1 min read Bash

Taken from <a href="http://www.linuxjournal.com/content/bash-sub-shells" target="_blank">here.

<span class=\"c\">#!/bin/bash</span>

server_cmd=server pid_file=$(basename $server_cmd .sh).pid log_file=$(basename $server_cmd .sh).log

( echo "Starting server" echo "Doing some init work" $server_cmd # server becomes a daemon

&lt;span class=\"k\">while &lt;/span>&lt;span class=\"nb\">true&lt;/span>

do if [[ -f $pid_file ]]; then sleep 15 else break fi done mail -s "Server exitted" joe@blow.com <<<CRAP

bash script with sql to get the number of records from multiple tables.

2010-02-10 1 min read Bash Database Learning Linux Solaris

Here is the bash script:

#!/bin/sh
names[1]=errorlog
names[2]=amit1log
names[3]=amit2log
names[4]=amit3log
names[5]=amit4log
j=1
echo $1
for i in $( sqlplus amit/passwd@tns @get_count.sql |sed -n ’/COUNT/,/Disconnected/p’|sed ’/COUNT/ d’|sed ’/—/ d’|sed ’/Disconnected/ d’|tr ’n’ ’ ’ )
do
temp=${names[$j]}
let count=30-${#temp}
for ((I=1; I <= $count ; I++))
do
printf ” ”
done
echo ”${names[$j]} : $i”
# echo $j
let j=j+1
done
echo
echo

and the required sql script:

select count() from errorlog;
select count() from amit1log;
select count() from amit2log;
select count() from amit3log;
select count(*) from amit4log;
quit;
Continue reading

Bash styling(themeing), the stylist way.

2010-02-04 1 min read Bash

For last couple of days, I have been looking for solutions to make stlying my bash easier. So, first a screenshot of the effort:

I was looking for the simplest solutions to do this. So, I installed two packages to make my life easier : bashstyle and fortune.

sudo yum install fortune\*

For bash-style you can download the source files <a href="http://www.nanolx.org/bashstyle-ng/" target="_blank">here. Download the file, then do the following:

grep -v with multiple patterns.

2010-01-25 1 min read Bash Linux

$ sed '/test/{/error|critical|warning/d}' somefile If you wanted to do all in one command, you could go w/ sed instead

<a href="http://www.commandlinefu.com/commands/view/3882/grep-v-with-multiple-patterns.">View this command to comment, vote or add to favourites
<a href="http://feeds2.feedburner.com/commands/by/pipping">View all commands by <a href="http://feeds2.feedburner.com/commands/by/pipping">pipping

by David Winterbottom (<a href="http://codeinthehole.com">codeinthehole.com)

URL: <a href="http://feedproxy.google.com/~r/Command-line-fu/~3/LjKzo7FpzDU/grep-v-with-multiple-patterns.">http://feedproxy.google.com/~r/Command-line-fu/~3/LjKzo7FpzDU/grep-v-with-multiple-patterns.<h6 class="zemanta-related-title" style="font-size: 1em;">Related articles by Zemanta <ul class="zemanta-article-ul"> <li class="zemanta-article-ul-li"><a href="http://www.seroundtable.com/archives/020935.html">Google’s ”Show More Results” Plus Box (seroundtable.com) <li class="zemanta-article-ul-li"><a href="http://www.macworld.com/article/143351/2009/10/netprocesses.html?lsrc=rss_main">See which processes are using the Internet (macworld.com) <div class="zemanta-pixie" style="margin-top: 10px; height: 15px;"><a class="zemanta-pixie-a" title="Reblog this post [with Zemanta]" href="http://reblog.zemanta.com/zemified/cc60245b-7397-4d48-83b2-7bfb345ae7a9/"><img class="zemanta-pixie-img" style="border: medium none; float: right;" src="http://blog.amit-agarwal.co.in/wp-content/uploads/2010/08/reblog_e20.png" alt="Reblog this post [with Zemanta]" />

sed tutorial and help

2010-01-21 1 min read Linux

A very nice turorial and help <a href="http://sed.sourceforge.net/grabbag/tutorials/">here.

Older posts Newer posts

Bilberry Hugo Theme