mysql output to an array for easy parsing.

2011-05-11 2 min read Bash Database

Today I was looking for some way to put the output of the mysql output in an array in a bash script. Quick google search yeilded to results something like this:

  <td>
    <div class="text codecolorer">
      output=$(mysql -e "select * from table")
    </div>
  </td>
</tr>

The problem with the above approach is that all the words go into separate index. So if you have a line that has space then that is split into multiple index’s. Not good…

Easy ssh configuration with .ssh/config file

2011-04-11 1 min read Bash Learning Linux

If you ssh to many hosts then you are aware of the pain that it takes to ssh with different username and hostname. There is an alias that you can creat with native ssh though. Here I will show you the same with an example.

  <td>
    <div class="text codecolorer">
      cat <<EOF >>~/.ssh/config<br /> Host <alias><br /> Username <user name><br /> Port <port number><br /> Hostname <hostname>
    </div>
  </td>
</tr>

1
2
3
4
5

You can optionally omit the parameters that you do not require explicitly. For example, if your port number is default then you can simply ignore the parameter.

using wordpress CLI to post to wordpress

2011-03-24 1 min read Bash Wordpress

There is a very nice post here: How to post content to a WordPress blog from the command line

I tried this in Fedora 14 and here is the way to get this working in Fedora

  <td>
    <div class="text codecolorer">
      su -<br /> <br /> cpan<br /> <br /> install WordPress::CLI WordPress::Post
    </div>
  </td>
</tr>

1
2
3
4
5

Now, once the above completes make sure that the path /usr/local/bin is in you path.

Try all colors in xterm with script before setting the color

2011-03-18 2 min read Bash Fedora Learning Linux

If you are looking for testing the colors on how they would look like in the xterm before you set the color then here is a small script for you.

  <td>
    <div class="text codecolorer">
      #!/bin/bash -<br /> #===============================================================================<br /> #<br /> #          FILE:  xterm_colors-test.sh<br /> #<br /> #         USAGE:  ./xterm_colors-test.sh<br /> #<br /> #   DESCRIPTION:  Test all the colors for xterm bg<br /> #<br /> #       OPTIONS:  ---<br /> #  REQUIREMENTS:  ---<br /> #          BUGS:  ---<br /> #         NOTES:  ---<br /> #        AUTHOR:   Amit Agarwal (amit.agarwal@amit-agarwal.co.in), aka<br /> #       COMPANY:  Individual<br /> #       VERSION:  1.0<br /> #       CREATED:  02/18/2011 01:02:51 PM IST<br /> #      REVISION:  1.0<br /> #===============================================================================<br /> <br /> cat /usr/share/X11/rgb.txt |sed 's/\([0-9]\{1,3\}[ \t]*\)\{3\}//'|sed 's/^ *//' >~/rgb.txt<br /> while read line<br /> do<br /> bg=$(echo $line)<br /> echo $line<br /> echo "Trying $bg color"<br /> xterm -bg "$bg"&<br /> sleep 5<br /> kill -9 $!<br /> done < ~/rgb.txt
    </div>
  </td>
</tr>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

This can be used in various ways but I will leave the choice to you. One option that I should probably still tell is :

cd across parallel directories

2011-03-14 1 min read Bash Linux

Here is a simple and fast way to cd across parallel directory.

  <td>
    <div class="text codecolorer">
      cd ${PWD/test/actual}
    </div>
  </td>
</tr>

Linux command line tips: wget (ghacks.net)
Article Directory Submissions (tjantunen.com)
Article Directory Submissions (cash-bandit.com)
Create a repository from your fedora DVD (annupandey.wordpress.com)

All in one solution for all the scripts of vim from vim.org

2011-03-09 9 min read Bash Fedora Learning Linux Vim Tips

For quite sometime now, I was looking for some console based program which would help me get the scripts from vim.org. A simple solution would have been to do a wget for the scripts. But since there are so many scripts coming up daily and with a need to search based on script ID and name of the script, I thought better to write a script that can do all of those things. Now, what was required was that the script should be either able to download this or add to the GLVS script. Also note that, I had done something similar in the past here. There are some additions in the below script. You can download a copy of the script get_vim_scripts. Or you can copy the script from below:

print every nth line

2011-03-01 2 min read Bash Linux

Some time back I was working with lot of data and wanted to analyze only the every 10 line sometimes and sometimes every 20th line. I had to keep doing these changes in vim or otherwise so finally I wrote a program to do this for me. If you need such a program then here it is:

  <td>
    <div class="text codecolorer">
      #!/bin/bash -<br /> #===============================================================================<br /> #<br /> #          FILE:  print_nth_line.sh<br /> #<br /> #         USAGE:  ./print_nth_line.sh<br /> #<br /> #   DESCRIPTION:  Print every nth line<br /> #<br /> #       OPTIONS:  ---<br /> #  REQUIREMENTS:  ---<br /> #          BUGS:  ---<br /> #         NOTES:  ---<br /> #        AUTHOR:   (),<br /> #       COMPANY:<br /> #       VERSION:  1.0<br /> #       CREATED:  12/08/2010 05:36:53 PM IST<br /> #      REVISION:  ---<br /> #===============================================================================<br /> <br /> if [ x"$1" == "x" ]<br /> then<br /> echo "Please provide the line numbers to print .. .ex 3 will print 3,6,9"<br /> exit -1;<br /> fi<br /> if [ x"$2" == "x" ]<br /> then<br /> echo "Please provide the filename"<br /> exit -2;<br /> fi<br /> awk 'temp++ { if ( temp % '$1' == 0) print $1};' $2
    </div>
  </td>
</tr>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

Older posts Newer posts

Related articles