UNIX for Dummies Questions & Answers

Hi,

I have a sql file which has CREATE and INSERT commands in it. Basically, inside this file, a table will be created and the data will be inserted into the table. I was wondering if there is a way for me to create directories from this file?

Thanks in advance

Yes, there is.

Not from within SQL, of course, but another script should be able
to grep the required information from it, and create some directories.

Post the sample data file and any script you're trying to use.

quirkasaurus,

Thanks for your reply. What I would like to do is to take the two sql files and the directory and write a piece of code that reads the two sql files and creates a directory tree.

About the code in one.sql we have a create table file statement plus so many insert to commands and in two.sql we have a create file gallery command with again some insert to.

(which the values will be separated by comma)

Now as my first step, I need to write code to create the directories from "two.sql". Please help me with this.

Thanks in advance!

if I'm reading you right:

script called "frogs":

Code:

grep 'CREATE TABLE' a.sql |
while read create table gallery junk ; do

  echo mkdir $gallery

done

Run it first to verify that it's doing what you want:

Code:

% frogs

mkdir table_name
mkdir table_name
...

Things look good, run it again like so:

Code:

frogs | ksh

... Then it'll actually make the directories.

quirkasaurus,

Thanks so much, that's exactly what I needed. Can you please let me know if I used your command correctly?

This is what I did: I created a new file and named it frogs. Then, inside it I pasted the code below:

grep 'CREATE TABLE' galleries.sql |
while read create table gallery junk ; do

echo mkdir $gallery

done


I run this file and the result (echo) was exactly as I needed.

So, I run frogs | ksh and one directory gets created.

The thing is galleries.sql was a table so I only got one category. So what I did was I use this program on a database.sql, it'll create the directory AND all the subdirectories.

Thanks again, you've been really helpful, I really appreciate it :-)

Tez