|
|
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
locale::script
Locale::Script(3perl) Perl Programmers Reference Guide Locale::Script(3perl) NAME
Locale::Script - standard codes for script identification SYNOPSIS
use Locale::Script; $script = code2script('phnx'); # 'Phoenician' $code = script2code('Phoenician'); # 'Phnx' $code = script2code('Phoenician', LOCALE_CODE_NUMERIC); # 115 @codes = all_script_codes(); @scripts = all_script_names(); DESCRIPTION
The "Locale::Script" module provides access to standards codes used for identifying scripts, such as those defined in ISO 15924. Most of the routines take an optional additional argument which specifies the code set to use. If not specified, the default ISO 15924 four-letter codes will be used. SUPPORTED CODE SETS
There are several different code sets you can use for identifying scripts. The ones currently supported are: alpha This is a set of four-letter (capitalized) codes from ISO 15924 such as 'Phnx' for Phoenician. This code set is identified with the symbol "LOCALE_SCRIPT_ALPHA". The Zxxx, Zyyy, and Zzzz codes are not used. This is the default code set. numeric This is a set of three-digit numeric codes from ISO 15924 such as 115 for Phoenician. This code set is identified with the symbol "LOCALE_SCRIPT_NUMERIC". ROUTINES
code2script ( CODE [,CODESET] ) script2code ( NAME [,CODESET] ) script_code2code ( CODE ,CODESET ,CODESET2 ) all_script_codes ( [CODESET] ) all_script_names ( [CODESET] ) Locale::Script::rename_script ( CODE ,NEW_NAME [,CODESET] ) Locale::Script::add_script ( CODE ,NAME [,CODESET] ) Locale::Script::delete_script ( CODE [,CODESET] ) Locale::Script::add_script_alias ( NAME ,NEW_NAME ) Locale::Script::delete_script_alias ( NAME ) Locale::Script::rename_script_code ( CODE ,NEW_CODE [,CODESET] ) Locale::Script::add_script_code_alias ( CODE ,NEW_CODE [,CODESET] ) Locale::Script::delete_script_code_alias ( CODE [,CODESET] ) These routines are all documented in the Locale::Codes man page. SEE ALSO
Locale::Codes Locale::Constants http://www.unicode.org/iso15924/ Home page for ISO 15924. AUTHOR
See Locale::Codes for full author history. Currently maintained by Sullivan Beck (sbeck@cpan.org). COPYRIGHT
Copyright (c) 1997-2001 Canon Research Centre Europe (CRE). Copyright (c) 2001-2010 Neil Bowers Copyright (c) 2010-2011 Sullivan Beck This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.14.2 2011-09-26 Locale::Script(3perl)