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 PHP

ingres_pconnect

INGRES_PCONNECT(3)							 1							INGRES_PCONNECT(3)

ingres_pconnect - Open a persistent connection to an Ingres database

SYNOPSIS

       resource ingres_pconnect ([string  $database], [string  $username], [string  $password], [array	$options])

DESCRIPTION

	Open a persistent connection to an Ingres database.

	There  are  only  two  differences between this function and ingres_connect(3): First, when connecting, the function will initially try to
       find a (persistent) link that is already opened with the same parameters. If one is found, an identifier for it will be returned instead of
       opening	a  new	connection. Second, the connection to the Ingres server will not be closed when the execution of the script ends. Instead,
       the link will remain open for future use (ingres_close(3) will not close links established by ingres_pconnect(3)). This	type  of  link	is
       therefore called "persistent".

PARAMETERS

	      o $database
		- The database name. Must follow the syntax: $[vnode::]dbname[/svr_class]

	      o $username
		- The Ingres user name

	      o $password
		- The password associated with $username

	      o $options
		- See ingres_connect(3) for the list of options that can be passed

RETURN VALUES

	Returns an Ingres link resource on success or FALSE on failure

SEE ALSO

       ingres_connect(3), ingres_close(3).

PHP Documentation Group 													INGRES_PCONNECT(3)