Updating a database Post: 302378021

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Updating a database Post 302378021 by fufaso on Sunday 6th of December 2009 12:55:58 PM

12-06-2009

Registered User

Updating a database

i've got a database setup that references user inputs to see if they are already inputted. What I am wanting to do is allow the user to update the database by typing
"update: name" where name is someone already in the database.

Code:

echo "Enter your name."
read NAME

location=`find . -name tes.txt`

if
        grep -qi "$NAME" $location
        then
        echo "User alreay inputted"
        cut -d: -f 1-3,5 $location | sed -e 's/:/,/gi' > temp.txt
else
 echo "User not found - name will be added to database."
        echo "$NAME" >> tes.txt
fi

access=`cut -d: -f5 $location`
case $access in
"A") echo "Administrator Access" >> temp.txt;;
"B") echo "Business Access" >> temp.txt;;
"S") echo "Student Access" >> temp.txt;;
"G") echo "General Access" >> temp.txt;;
*) echo "General Access" >> tempt.txt;;
esac

echo "To update files type 'update: name'"
read UPDATE

if
cut -d: -f 1 $UPDATE > updatetemp.txt
grep -qi "$NAME" updatetemp.txt
.
.
.

I want to cut out the name part and then cross-reference with the current database to see if the name is already inputted. I was wanting to have the cut outside of the if statement, but it wasn't working.

Am I close to getting it right here?

fufaso

View Public Profile for fufaso

Find all posts by fufaso

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk updating one file with another, comparing, updating

Hello, I read and search through this wonderful forum and tried different approaches but it seems I lack some knowledge and neurones ^^ Here is what I'm trying to achieve : file1: test filea 3495; test fileb 4578; test filec 7689; test filey 9978; test filez 12300; file2: test filea...

2. AIX

.sh_profile not updating

Dear Gurus i have read a lot written on this topic but i just wanna ask that the /etc/profile file is present but the .sh_profile in the users $HOME directory is not being updated, any guesses why??? Also that i need to get the information about the date, time, IP and the user name from which...

3. Homework & Coursework Questions

UNIX- Database creating/viewing/updating assignment

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: I have posted the assignment below, I am new to unix programming and am having a very hard time knowing where...

4. Solaris

redirect solaris database from linux database..

hi.. i have a need .. my php runs on my linux redhat box with mysql.. i want my php code to refer another mysql database which is in solaris 10 x86... can u tell me the procedure .. how it can be done through php .. sorry am new to php... is it possible to redirect from linux mysql to...

5. Solaris

Can't create database after Oracle Database installation

I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options. OPERATION_TYPE = "createDatabase" GDBNAME = "solaris_user.domain.com" SID = "solaris_user" TEMPLATENAME = "General...

6. AIX

Updating AIX OS

Hello I have a server whose os level reads 5300-01-00-0000. It has to be upgraded to the latest level which is 5300-12-04-1119. What would I need to do go get the server to this point? Would I need to go through each patch level until I get it to current? If so, would anyone happen to know...

7. Web Development

Updating Records in Mysql Database

so when i issue a command like the below: # mysql --pager=/usr/bin/less -u cactiman -p -e 'select * from data_input' cacti Enter password: ...

8. Shell Programming and Scripting

CRON Job to copy database and replace existing database

I have a reseller account with hostgator, which means i have WHM and Cpanel. I have set up a staging environment for one of my wordpress installations (client website), which is essentially sitting at staging.domain.com (live site is at domain.com). The staging website is a complete copy of the...

9. Ubuntu

16.04 not updating

Just installed the latest version on my hp stream, was tired of windows. Of the few times I've used Linux, this is the first time it won't update. Im connected to the net the updater recognizes that the OS needs 21 updates. But it won't download/install the updates. It also won't load the...

LEARN ABOUT DEBIAN

biomaj

biomaj(1)							   USER COMMANDS							 biomaj(1)

NAME

       biomaj - downloads and transform remote biological data banks

SYNOPSIS

       biomaj [-h]

DESCRIPTION

       BioMAJ (BIOlogie Mise A Jour) is a workflow engine dedicated
	to data synchronization and processing.The Software automates
	the update cycle and the supervision of the locally mirrored
	databank repository.  User must have roots rights to run biomaj.

OPTIONS

       -h     display the list of commands.

INSTALL

       At  installation, BioMAJ requires a database to run (MySQL), installer should first create a database (biomaj_log) and a database user (the
       one used at installation setup).
	The database configuration for biomaj can be set or modified in /etc/biomaj/db_properties/global.properties.

       In the install fails due to a SQL error, the install script must be manually run to create/upgrade the database:

       perl /usr/share/biomaj/sql/migration/update.pl

       The script will create/upgrade the database and update the configuration files.

ADMIN USER

       A default admin user (admin) is created by the scripts.	If using the biomaj-watcher, the default password (admin) MUST be changed  immedi-
       atly via the watcher interface.

       If only biomaj core is used, password is useless.
	.PP

UPGRADE

	In the case of a package upgrade, if properly configured, the migration scripts will be ran automatically at install.
	It is possible to run manually the script:
	.B See perl /usr/share/biomaj/sql/migration/update.pl -h
	for usage.

DATA BANKS

       By default, biomaj is configured (data.dir in global.properties) to write banks to /var/lib/biomaj.

EXAMPLES

       Update a bank:
	      biomaj --update genbank

       Show console
	      biomaj --update genbank --console

       Show status:
	      biomaj --status

EXIT STATUS

       biomaj returns a zero exist status if it succeeds, it does not represent the bank update status.

AUTHOR

       Olivier Sallou (olivier.sallou (at) irisa.fr) Romaric Sabas (romaric.sabas (at) irisa.fr)

version 1.2.0							September 14, 2011							 biomaj(1)