Help fixing my database script Post: 302867163

Sponsored Content

Homework and Emergencies Homework & Coursework Questions Help fixing my database script Post 302867163 by gamernerd101 on Wednesday 23rd of October 2013 02:35:59 PM

10-23-2013

Registered User

Help fixing my database script

1. The problem statement, all variables and given/known data:
I need help I get a variant of syntax errors when compiling my script to maintain a database. It's a simple database meant to create/view/maintain vehicles.

2. Relevant commands, code, scripts, algorithms:
my if statements have many syntax errors and I'm lost as to why. One key lines is line 8 my first if statement. Thanks in advance.

3. The attempts at a solution (include all code and scripts):

Code:

#! /bin/bash
# Automobile database

db=arg1
command=arg2
case $db in
    #create:
if [ -f "$db" ]; then
echo "DATABASE EXSISTS"

 if [ $arg3 != "" ]
 echo $arg3 > db

else
echo "Automobile Database" > db
echo "New database created"
fi
  esac

#add

read -p "Make of the car: " make

read -p "Model of the car: " model

read -p "Year of the car: " year

read -p "Color of the car: " color


if $year < 1870 || $year > 2020
echo "Error with $year"
fi
echo "$make, $model, $year, $color" >> db
echo "Successfully added a record to the database"

case $arg3:
 max=$( wc -l db )
 #all:
 cat db

 if $arg4 > $max
 echo "Error"
 fi
 sed -ne "1p;arg4p" db

#range:
if $arg4 > $max || $arg5 > $max || $arg4 > $arg5
error
fi
sed -ne "1p;arg4,arg5p" $db
esac



#delete:
        case $arg3:
        max=$( wc -l db )
      sed -ie '2,$d' db
     single:
     if $arg4 > $max
     echo "error"
     fi

     sed -ie "$arg4d" db


     range:
     if $arg4 > $max || $arg5 > $max || $arg4 > $arg5
           echo "Error"
           fi
     sed -ie "arg4,arg5d" db
esac

4. Complete Name of School (University), City (State), Country, Name of Professor, and Course Number (Link to Course):
NIU, dekalb il USA, Ege, CSCI 330

Note: Without school/professor/course information, you will be banned if you post here! You must complete the entire template (not just parts of it).

gamernerd101

View Public Profile for gamernerd101

Find all posts by gamernerd101

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script: want to insert values in database when update script runs

Hi , I am new to linux and also also to shell scripting. I have one shell script which unpacks .tgz file and install software on machine. When this script runs I want to insert id,filename,description(which will be in readme file),log(which will be in log file) and name of unpacked folder...

2. Linux

fixing with sed

I am trying to replace the value of $f3 but its not working . I don't know what I am missing here . cat dim_copy.20080516.sql | grep -i "create view" | grep -v OPSDM002 | while read f1 f2 f3 f4 f5 f6 f7 f8 f9 do echo " $f3 " sed -e...

3. Shell Programming and Scripting

Fixing corrupted vcard files.

KDE's Kontact PIM breaks quoted-printable vcard files because it linebreaks in the middle of a word. Take this text for example: NOTE;CHARSET=UTF-8;ENCODING=QUOTED-PRINTABLE:=D7=A9=D7=95=D7=A8=D7=94 =D7=A 8=D7=90=D7=A9=D7=95=D7=A0=D7=94.\n=D7=94=D7=A9=D7=95=D7=A8=D7=94 =D7=94=D7= ...

4. Shell Programming and Scripting

Fixing the width of a word

Is there a way to fix the width of the word being printed to a file? I am trying to create an output to a file with columns , like a spread sheet. I have used "\t" to adjust the columns but still it does not show well in the file, mainly due to the variable length values in the column so \t does...

5. Shell Programming and Scripting

help fixing awk statement

awk "BEGIN {if($MessageREAD<$ThresholdW) {print \"OK\" ; exit 0} else if(($MessageREAD>=$ThresholdW) && ($MessageREAD<$ThresholdC)) {print \"WARNING\" ; exit 1}" else if($MessageREAD<=$ThresholdC) {print \"CRITICAL\" ;...

6. AIX

Fixing security problem

Hi I use Rapid 7 to check some servers ( AIX 5.3 ) for security problems. There are 2 problems I don't know to deal with 1. Problem : TCP Sequence Number Approximation Vulnerability Solution : _Enable TCP MD5 Signature 2. Problem : HTTP Basic Authentication Enable Solution : _ Use...

7. Shell Programming and Scripting

Fixing a shell script

I have this shell script that I wrote to check an input file to see if it is empty or not, and then clean the file from any line that starts with the sign "<" (without quotation marks" and then spell the number of line of the file, and the empty lines, too. The script then will create two output...

8. UNIX for Advanced & Expert Users

Help with fixing screen position

Hey guys, I am trying to make print a pattern with * on a 10*10 two dimensional array in a for loop and I want the incoming 10*10 to overlap the previous 10*10 so that the * look like it is moving. is there a way to fix the screen position? ever time it prints a 10*10 the screen moves. ...

9. Shell Programming and Scripting

Help fixing awk code

can someone please help me spot and fix the issue with the following code: awk -F, -v SEARCHPATT="(Wed|Tue)" -v ADDISTR="Mon|Tue|Wed|Thu|Fri|Sat|Sun" -vVF="$VALFOUND" "BEGIN{ {D = D = 1 D = D = 2 } $0 ~ "," VF "," {L = 1 ...

LEARN ABOUT SUNOS

asadmin-restart

asadmin-hadbm-restart(1ASS)					   User Commands				       asadmin-hadbm-restart(1ASS)

NAME

       asadmin-hadbm-restart, hadbm-restart, restart - restarts the database

SYNOPSIS

       restart [--no-rolling] [database_name]

       Use  the  restart command to restart the database. Once the database is restarted, the database should return to the previous state. If the
       database name is specified, the database should exist. If a database is not identified, the default  database  is  restarted.  The  default
       database is hadb.

       In interactive mode, the restart command prompts for a confirmation before restarting the database.

OPTIONS

       -g --no-rolling	       restarts all nodes in HADB at once with possible loss of service.

OPERANDS

       database_name	       name of the database. The default database is hadb.

       Example 1: Using restart with a database identified

       hadbm> restart --rolling mydatabase
       This command will restart the named database.
       Type "yes" or "y" to confirm this operation,
       anything else to cancel:y
       Database successfully restarted

EXIT STATUS

       105		       database is not running

       106		       database could not be restarted

       107		       database could not return to a previous state

       asadmin-hadbm-status(1ASS),    asadmin-hadbm-nodestatus(1ASS),	asadmin-hadbm-list(1ASS),   asadmin-hadbm-addnodes(1ASS),   asadmin-hadbm-
       clear(1ASS), asadmin-hadbm-refragment(1ASS), asadmin-hadbm-delete(1ASS), asadmin-hadbm-start(1ASS), asadmin-hadbm-stop(1ASS)

Sun ONE Application Server 7 Enterprise Edition Early Access	   7 March 2003 				       asadmin-hadbm-restart(1ASS)