Alligator has asked for the wisdom of the Perl Monks concerning the following question:

Hi Geeks.. I've a problem here, It would be great if anyone can come with a sample script. My company uses ClearCase (CVS system), and the problem is 1) how do i read each of the files and dump the data into an oracle database. Here i've to read each file in the ClearCase system and dump its URL and content into the Oracle DB. 2) Every day the script should update the DB with the newer files added to the CVS system. Can anyone help..?? Thanks in advance
  • Comment on Reading files from ClearCase and dumping the data into Oracle

Replies are listed 'Best First'.
Re: Reading files from ClearCase and dumping the data into Oracle
by Aristotle (Chancellor) on Sep 08, 2002 at 12:30 UTC

    Re 1): You want to have a look at Text::xSV as well as probably the venerable DBI module, although different interfaces to Oracle exist as well. Have a look around CPAN.

    Re 2): you can use the stat function to check a bunch of properties for a file like its creation/modification time.

    Makeshifts last the longest.

Re: Reading files from ClearCase and dumping the data into Oracle
by krisahoch (Deacon) on Sep 08, 2002 at 12:40 UTC

    Alligator,

    • Here i've to read each file in the ClearCase system and dump its URL and content into the Oracle DB
    .

    What have you been able to to so far before posting this question? We need more information to be able to help.

    Kristofer Hoch.

      Hoch, Pardon me if i made any mistake..im a newbie here.. Here is what i need to do: I have a ClearCase system. Developers use the system to maintain there documents, commit changes and so forth. 1) first the perl file should recursively the directories in the ClearCase system and dump each of the file URLs and the files content into the Oracle DB. 2) secondly the script should track any commited changes done to a file and update such file url and the content. (The changes can be the file may be deleted and soforth) Hope i made my point clear :)