|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
Script help: Finding Files on a server with no DB reference
Post 302631107 by Clark_Griswold on Thursday 26th of April 2012 08:30:37 PM
04-26-2012
Script help: Finding Files on a server with no DB reference
Hey Everyone,
This is my first post here so I hope I'm in the right spot. I need some help with a script. I don't have much experience in UNIX besides the basic command line stuff which I haven't used much so bear with me.
I've got a web application which acts as a document repository with an Oracle database and mostly pdf documents stored on the file system of a UNIX server. Each document is supposed to have a reference in the database with it's full path. Over the years people have been playing around in the file system and moving/deleting documents. We are running out of space and we need to do a massive clean up and re-org to get rid of orphaned documents.
I'm looking to write a script that will look at all the files in the file system and check against the database to see if there is a reference or not. If the file is not referenced in the database I'd like to list it in a file so we can analyze if the file should be deleted or moved back to it's proper place.
I have access to the file system via FTP and the DB with SQL Developer. I was thinking of writing a script to list all the files in the file system and then use that in SQL Developer somehow to search against the DB but I'm wondering it isn't possible to do it all in one big bang and not have to run two seperate scripts/processes.
Again, any help is more than welcome and thanks for taking the time to read this.
Thanks!
This is my first post here so I hope I'm in the right spot. I need some help with a script. I don't have much experience in UNIX besides the basic command line stuff which I haven't used much so bear with me.
I've got a web application which acts as a document repository with an Oracle database and mostly pdf documents stored on the file system of a UNIX server. Each document is supposed to have a reference in the database with it's full path. Over the years people have been playing around in the file system and moving/deleting documents. We are running out of space and we need to do a massive clean up and re-org to get rid of orphaned documents.
I'm looking to write a script that will look at all the files in the file system and check against the database to see if there is a reference or not. If the file is not referenced in the database I'd like to list it in a file so we can analyze if the file should be deleted or moved back to it's proper place.
I have access to the file system via FTP and the DB with SQL Developer. I was thinking of writing a script to list all the files in the file system and then use that in SQL Developer somehow to search against the DB but I'm wondering it isn't possible to do it all in one big bang and not have to run two seperate scripts/processes.
Again, any help is more than welcome and thanks for taking the time to read this.
Thanks!
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I want to reference a directory on another Unix server. I have looked at the ln command but have seen information only relating to directories on the same server. Any suggestions?
It is IBM AIX Unix 4.3 server. (1 Reply)
Discussion started by: pengwyn
1 Replies
2. Shell Programming and Scripting
Hi,
I have a challenging task,in which i have to find the duplicate files by its name and size,then i need to take anyone of the file.Then i need to open the file and find for more than one pattern and count of that pattern.
Note:These are the samples of two files,but i can have more... (2 Replies)
Discussion started by: jerome Sukumar
2 Replies
3. UNIX for Dummies Questions & Answers
I need to write a Unix shell script which will list top 10 files in a directory tree on basis of size. i.e. first file should be the biggest in the whole directory and all its sub directories.
Please suggest any ideas (10 Replies)
Discussion started by: abhilashnair
10 Replies
4. Shell Programming and Scripting
I would like to find whether a file exists in the UNIX machine. That i can check using
if ;then
echo "exists"
echo " `cat $file` "
else
echo "invalid file"
fi.
and i can find out using :
find / -name "filename" . But it i have wanted to search in all directories. How to get... (3 Replies)
Discussion started by: rparsa001
3 Replies
5. Shell Programming and Scripting
Hello All,
After a HDD crash, I would like to selectively back up all my script files. What is the most efficient way to do this?
The pseudo code I was thinking of was something like this:
for a in `find ./ -name "*"`
do
if (file $a) == Bourne|Tcsh|... then
echo $a >>... (7 Replies)
Discussion started by: pru
7 Replies
6. Shell Programming and Scripting
script for to take files from FTP server to UNIX server and Unzipped that files (1 Reply)
Discussion started by: sunilamarnadh
1 Replies
7. Shell Programming and Scripting
Hello,
I have a shell script like the one below but cannot get it working:
#!/bin/bash
#$ -cwd
CHR=$2
# directories
ROOT_DIR=./
RESULTS_DIR=${ROOT_DIR}results/
# executable
SHAPEIT_EXEC=${ROOT_DIR}shapeit.v2.r727.linux.x64/shapeit.v2.r727.linux.x64
# parameters
THREAT=5... (1 Reply)
Discussion started by: wmelroy
1 Replies
8. Solaris
Hi,
I am trying to automate the process of fetching files from remote server to local server through sftp. I have the username and password for the remote solaris server. But I need to give password manually everytime i run the script.
Can anyone help me in automating the script such that it... (3 Replies)
Discussion started by: ssk250
3 Replies
9. Shell Programming and Scripting
Dear All,
I have a situation where I want to copy some files of type .txt.
These files are o/p from one program. Some of the files are named as
fileName .txt instead of fileName.txt
after fileName by mistake I have specified "space". Now I want to move these files as follows.
mv fileName*... (13 Replies)
Discussion started by: linuxUser_
13 Replies
10. Shell Programming and Scripting
Hi All ,
I have multiple pipe delimited csv files are present in a directory.I need to find out distinct count on a column on those files and need the total distinct
count on all files.
We can't merge all the files here as file size are huge in millions.I have tried in below way for each... (9 Replies)
Discussion started by: STCET22
9 Replies
LEARN ABOUT DEBIAN
cscope-indexer
cscope-indexer(1) General Commands Manual cscope-indexer(1) NAME
cscope-indexer - Script to index files for cscope SYNOPSIS
cscope-indexer [-v] [-f database_file] [-i list_file] [-l] [-r] DESCRIPTION
This script generates a list of files to index (cscope.out), which is then (optionally) used to generate a cscope database. You can use this script to just build a list of files, or it can be used to build a list and database. This script is not used to just build a data- base (skipping the list of files step), as this can be simply done by just calling "cscope -b". Normally, cscope will do its own indexing, but this script can be used to force indexing. This is useful if you need to recurse into sub- directories, or have many files to index (you can run this script from a cron job, during the night). It is especially useful for large projects, which can contstantly have source files added and deleted; by using this script, the changing sources files are automatically handled. Currently, any paths containing "/CVS/" or "/RCS/" are stripped out (ignored). OPTIONS
-f database_file Specifies the cscope database file (default: cscope.out). -i list_file Specifies the name of the file into which the list of files to index is placed (default: cscope.files). -l Suppress the generation/updating of the cscope database file. Only a list of files is generated. -r Recurse into subdirectories to locate files to index. Without this option, only the current directory is searched. -v Be verbose. Output simple progress messages. SEE ALSO
cscope(1) AUTHOR
This manual page was written for the Debian GNU/Linux system by Robert Lemmen <robertle@semistable.com> (but may be used by others, of course) Script to index files for cscope 30. December 2002 cscope-indexer(1)