asked on

I need a little python script to do what this bash script does

IFS=,
while read h i m ; do
if [ `hostname` == $h ] ; then
ip=$i
make=$m
fi
done << here
fred,10.10.10.10,dell
barny,10.10.10.11,toshiba
wilma,10.10.10.12,hp
here

This works great on my linux systems

problem is that windows, aix and solaris, and linux have only python as a common scripting language.

can someone try to do this in python ? I am really new at python

ASKER CERTIFIED SOLUTION

gelonida

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gelonida

In case you have any problems on one of your platforms with the function
socket.gethostname(), you can try one of the following alternative implementations of
get_hostname()

import platform

def get_hostname():
    return platform.node()

Open in new window

import platform

def get_hostname():
    return platform.uname()[1]

Open in new window

TIMFOX123

ASKER

Hello

This is a good answer however there is another point I did not make.

info_by_hostname = {
'fred' : ('dell', '10.10.10.10'),
'barny': ('toshiba', '10.10.10.11'),
'wilma' : ('hp', '10.10.10.12'),
}

this information gets pasted in from a CSV file and creating all this formatting with the single quotes and all is not that practical. I was really hoping for it to read the data as a,b,c

if there is not another solution a script to read the csv and format it like this will work :) it adds another step I was hoping to avoid

gelonida

Well you didn't mention that ;-)

Do you want to perform only one look up in the script or multiple ones.
Is the csv file huge (does it fit into memory)

This will impact the suggested solution.

For the time being I assume you want to perform only one lookup and that there is thus no need to keep the csv table in memory

gelonida

Following code should work then.

However it is not optimized for multiple lookups as it will open the csv file for each look up.
Whether this is what you want depends on the context.

#!/usr/bin/env python

# following import line must be first python command in script
# it ensures python 2 / 3 compatibility
from __future__ import print_function

import socket
import csv

def get_hostname():
    return socket.gethostname()

def get_info_for_host(hostname, csv_fname):
    with open(csv_fname, 'rb') as fin:
        reader = csv.reader(fin, delimiter=',')
        for row in reader:
            if len(row) != 3:
                #print("ignoring row", repr(row))
                continue
            name, ip, make = row
            if hostname == name:
                return ip, make
        return ("unknown", "unknown")

hostname = get_hostname()
ip, make = get_info_for_host(hostname, 'data.csv')
print(hostname, ip, make)

Open in new window

if the script is too slow, then it could be accelerated by NOT using the csv module and doing a 'grep' like search.
On the other hand:
In most cases I prefer robust code over fastest code and the csv module can handle many particular cases of csv files, though probably not needed in your current example