creating a schema Post: 302263526

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers creating a schema Post 302263526 by zodester on Monday 1st of December 2008 08:52:43 PM

12-01-2008

Registered User

creating a schema

hi guys,
Unix dummy here.
I need help creating a script for class.
The assignment reads as follows:

create a script that will create a new schema in schema.txt, it must accept 7 arguments (the first being the name of the schema) the other 6 being the 6 field names. the schema has to be tested to make sure it isn't in the file schema.txt and if all passes then the arguments should be appended to the file schema.txt

this is what I have so far:

#!/bin/sh
if [ ! $# -ge 2 ] && [ ! $# -le 7 ]
then
echo "Usage: ns.sh <schema_name> <field_names>"
elif [ ! -f schemas.txt ]
echo "schemas.txt": file could not be found.
elif [ ! -r schemas.txt ]
echo "schemas.txt": unable to read file.
elif [ ! -w schemas.txt ]
echo "schemas.txt": unable to write upon file.
elif [ "`grep"^$1\" schema.txt`" ]
echo schema already defined as $1
else
$@ >> schema.txt
fi

when I run it, this happens:

sena@linprog1.cs.fsu.edu:~/a5>ns.sh cars make model year
ns.sh: line 7: syntax error near unexpected token `elif'
ns.sh: line 7: `elif [ ! -r schemas.txt ]'

As far as appending the arguments to schema I don't know what to do
Any help would be awesome!

zodester

View Public Profile for zodester

Find all posts by zodester

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script for checking schema satistics in Oracle

I have a script which gives the output of schemas in Oracle DB : #!/bin/ksh ps -ef | grep -v grep | grep ora_pmon_$1 | wc -l | while read CONTROL do if ; then ORACLE_HOME=/u01/app/oracle/product/9.2.0 export ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH:/bin:/usr/bin:usr/local/bin:. ...

2. Shell Programming and Scripting

find a column in a schema

Hi, I need my script to accept a column name and give all the tables and its schema. Any kind of help is appreciated... Thanks in advance...

3. UNIX and Linux Applications

Toad for Oracle 11G - schema browser not working

Need a help Schema browser in Toad not listing the tables when i connected to Oracle 11g schema did any body faced the issue... ? How to resolve the issue

4. Emergency UNIX and Linux Support

Toad for Oracle 11G Schema browser

Need a help ..Schema browser in Toad not listing the tables when i connected to Oracle 11g schema did any body faced the issue... ? How to resolve the issue.. I need it asap thats y posted here Thanks

5. Cybersecurity

LDAP rfc2307bis.schema or nis.schema?

Hi guys, we are implementing new ldap in our organization exclusively for Linux authentication purposes. As we are new to the subject, I would appreciate help regarding which schema to use to create group of users and accounts / passwords entries? I see both schemas listed in subject above...

6. Shell Programming and Scripting

Parallel export of all oracle DB schema.

In my Oracle db there are 4 schemas. All the username & passwords are stored in a text file. I am using a while loop to export all the schemas. It read the first line and doing the export. For all users it export one by one. But I need all the schemas will exported simultaneously. i.e. all the...

7. UNIX for Dummies Questions & Answers

How can I import a particular schema from full dump in Oracle?

Hi All, I have a full oracle dump file that I have exported from a production server. I want to import a specific schema out of the full dump. Is that possible in oracle. What will be the command for that?

LEARN ABOUT DEBIAN

lire::derivedschema

DerivedSchema(3pm)					  LogReport's Lire Documentation					DerivedSchema(3pm)

NAME

       Lire::DerivedSchema - Defines a schema for which the records are derived from another schema

SYNOPSIS

	 my $schema = Lire::DlfSchema::load_schema( 'www-user_session' );
	 my $fields = $schema->fields();

DESCRIPTION

       A Lire::DerivedSchema defines a schema for which the records are computed by an analyser using the records of a base schema. An example of
       a derived schema is the www-user_session schema which computes session information from the records in the www schema.

   base()
       Returns the Lire::DlfSchema object from which this schema's records are derived.

   can_join_schema( $schema )
       Returns true if $schema can be joined with this schema. For a DerivedSchema, this will be true only when $schema is an ExtendedSchema of
       this schema or this schema's base. It is also possible to join the DerivedSchema with its base.

AUTHOR

       Francis J. Lacoste <flacoste@logreport.org>

VERSION

       $Id: DerivedSchema.pm,v 1.19 2006/07/23 13:16:28 vanbaal Exp $

COPYRIGHT

       Copyright (C) 2001, 2004 Stichting LogReport Foundation LogReport@LogReport.org

       This file is part of Lire.

       Lire is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free
       Software Foundation; either version 2 of the License, or (at your option) any later version.

       This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more details.

       You should have received a copy of the GNU General Public License along with this program (see COPYING); if not, check with
       http://www.gnu.org/copyleft/gpl.html.

Lire 2.1.1							    2006-07-23							DerivedSchema(3pm)