#format: nodename IP/hostname OStype root/Admin
#e.g.: specjdriver 192.168.6.67 windows Administrator
#| nodename hostname ostype admin |
specjdriver 192.168.6.67 windows Administrator
specjsut 192.168.6.252 linux root
specjdb 192.168.6.70 windows Admin
specjemulator 192.168.6.66 linux root
192.168.6.70
[root@rac1 config]# ./simple_select nodes.conf ostype=windows nodename
specjdriver
specjdb
# condition,columnids
BEGIN{
# read condition
count = split(condition,condstrs,"=");
if(count != 2 )
exit -1;
keyid = condstrs[1];
keyval = condstrs[2];
# read schema
do{
res = getline;
}while(res != 0 && $0 !~ /#\|.*\|/);
if(res ==0 ){
# print "no schema found!!"
exit -1;
}
count = split($0,schema);
colidcount = split(columnids,columnidarray,",")
for(i=1;i<=colidcount;i++)
columnindexarray[i] = -1;
keyindex = -1;
# printf "searched: |%s|%s|\n",keyid,columnid;
for(i=2;i<count;i++){
# printf "|%s| - %d \n",schema[i], i;
if(schema[i] == keyid)
keyindex = i - 1;
for(j=1;j<=colidcount;j++)
if(schema[i] == columnidarray[j])
columnindexarray[j] = i - 1;
}
if(keyindex == -1){
# print "no column found!", keyindex,columnindex;
exit -1;
}
for(i=1;i<=colidcount;i++)
if(columnindexarray[i]==-1)
exit -1;
# print "Columns found!", keyindex,columnindex;
do{
res = getline row;
if( res == 0){
# print "reached the end";
exit -1;
}
count = split(row,columns);
# print count, ":", row;
if(columns[keyindex] == keyval){
for(i=1;i<=colidcount;i++)
printf ("%s\t",columns[columnindexarray[i]]);
printf("\n");
continue;
}
}while(1);
}
/.*/{printf("");}
CONDITION=$2
COL_ID=$3
awk -v condition="$CONDITION" -v columnids=$COL_ID -f ./plaindb.awk $1