bash - how to achieve a test -d on list of file paths

kevinyeandel · 05-26-2012, 06:10 PM

Hello

If I execute:

echo -e "set pagesize 0 \n select file_system_path from dm_location_s;" | sqlplus -s user/pass@schema | grep ^\/

I get back a load of file paths:

/data/dev_store/dev/content_storage_01
/opt/documentum/dba/log
/opt/documentum/dba/config
/opt/documentum/dba
/opt/documentum/dba/auth
/opt/documentum/dba/secure/ldapdb
<snip>

What I want to do is append to my command a 'test -d' type of thing so I can determine that each of the file paths actually exists. I need to do it as a single line and was looking for some sort of solution, e.g like -exec test -d {} \;

Could someone suggest how I can achieve this?

Many thanks in advance.

Kevin

Nominal Animal · 05-26-2012, 07:48 PM

Assuming you use Bash:

Code:

printf 'set pagesize 0\nselect file_system_path from dm_location_s;\n' | sqlplus -s user/pass@schema | while read item ; do [ "${item:0:1}" = "/" ] && [ -e "$item" ] && echo "$item" ; done

This outputs only those lines that begin with a slash and exist in the filesystem.

Note that -e only tests for existence; it does not care what it is, or whether it is readable, writable, or executable. -d would test the existence of a directory. See man 1 test for detailed descriptions of the various possible tests.

kevinyeandel · 05-28-2012, 07:32 AM

Thanks for getting me over the hurdles on this NA. I managed to get it all into one (long, long) line, pull out the data and put it into xml format.
I can see already I could make the line a bit shorter but this will do!

Kevin

Code:

echo "<locations>" ;printf 'set feedback off \n set pagesize 0\n set linesize 300\n select file_system_path from dm_location_s;\n' | sqlplus -s user/pass@schema | while read item ; do  [ "${item:0:1}" = "/" ] && df -P -h "$item" | sed -e 1d|head -3 | awk -v ITEM=$item '{print " <location>\n  <name>" ITEM "</name>\n  <max>" $2 "</max>\n  <avail>" $4 "</avail>\n  <used>" $3 "</used>\n  <pc>" $5 "</pc>\n </location>\n"} END { } ' ; done ; echo "</locations>"

Output

Code:

<locations>
<location>
<name>/data/nas_store/repo/content_storage_01</name>
<max>350G</max>
<avail>86G</avail>
<used>265G</used>
<pc>76%</pc>
</location>

<location>
<name>/opt/documentum/dba/log</name>
<max>15G</max>
<avail>1.4G</avail>
<used>13G</used>
<pc>91%</pc>
</location>
<snip>