Sponsored Content
Homework and Emergencies Homework & Coursework Questions UNIX- Database creating/viewing/updating assignment Post 302472391 by pludi on Wednesday 17th of November 2010 04:52:57 AM
Old 11-17-2010
Quick outline (pseudocode, no guarantee for correctness):
Code:
db=arg1
command=arg2

switch command:
    create:
        if exists db
            error
        if arg3 != ""
            echo arg3 > db
        else
            echo "Automobile Database" > db
        echo "New database created"
    add:
        make = arg3
        model = arg4
        year = arg5
        color = arg6

        if arg3 == ""
            ask make
        if arg4 == ""
            ask model
        if arg5 == ""
            ask year
        if arg6 == ""
            ask color
        if year < 1870 || year > 2020
            error
        echo "make, model, year, color" >> db
        echo "Successfully added a record to the database"
    view:
        switch arg3:
            max=$( wc -l db )
            all:
                cat db
            single:
                if arg4 > max
                    error
	        sed -ne "1p;arg4p" db
            range:
                if arg4 > max || arg5 > max || arg4 > arg5
                    error
	        sed -ne "1p;arg4,arg5p" db
    delete:
        switch arg3:
            max=$( wc -l db )
            all:
                sed -ie '2,$d' db
            single:
                if arg4 > max
                    error
	        sed -ie "arg4d" db
            range:
                if arg4 > max || arg5 > max || arg4 > arg5
                    error
	        sed -ie "arg4,arg5d" db
     *:
         show help

Useful reading:
Bash Beginners Guide
sed manpage
This User Gave Thanks to pludi For This Post:
 

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Updating and Creating Web pages wiht Unix

I am new to Unix and would like to update a website as well as add new content to the site but it must be done with UNIX. Can anyone give me some pointers as to what types of references are on the web or maybe even some basic commands? Thanks so much! (1 Reply)
Discussion started by: gsensebe
1 Replies

2. UNIX for Advanced & Expert Users

Creating database in shell, how?!

Hi, i'm newbie in Unix. How can i create my own database in unix shell? Not to create a database through shell to MySql, oracle etc, but to create a completely mine database system through shell. Please help me, give me directions, i'm desperate :( (1 Reply)
Discussion started by: vants
1 Replies

3. UNIX for Dummies Questions & Answers

Creating a table (graphic not database)

Hi, I want to create a table on our unix box that allows the user to tab through it and select certain option by putting an asterix or similair into it. e.g. -------------- |Start App | | |Stop App |*| etc... Can this be done using a script (never seen any graphics options in ksh, but... (2 Replies)
Discussion started by: dlam
2 Replies

4. UNIX for Dummies Questions & Answers

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. echo "Enter your name." read NAME location=`find . -name... (2 Replies)
Discussion started by: fufaso
2 Replies

5. 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: ... (2 Replies)
Discussion started by: SkySmart
2 Replies

6. UNIX for Dummies Questions & Answers

Viewing XLSB file in Unix

Hello, Does anyone know how to view an XLSB file in unix? Thank you. (1 Reply)
Discussion started by: narachaid
1 Replies

7. UNIX for Advanced & Expert Users

Creating the script for updating or replacing the existing http.conf file

Hi I need some help with a task, i am an absolute newbie to any form of shell scripting and request guidance. I have been building a proxy server using the apache mod proxy currently my solution is working , but i need to automate the process , suppose if any changes need to be made on... (0 Replies)
Discussion started by: satej
0 Replies
KTR(9)							   BSD Kernel Developer's Manual						    KTR(9)

NAME
CTR0, CTR1, CTR2, CTR3, CTR4, CTR5 -- kernel tracing facility SYNOPSIS
#include <sys/param.h> #include <sys/ktr.h> extern int ktr_cpumask; extern int ktr_entries; extern int ktr_extend; extern int ktr_mask; extern int ktr_verbose; extern struct ktr_entry ktr_buf[]; void CTR0(u_int mask, char *format); void CTR1(u_int mask, char *format, arg1); void CTR2(u_int mask, char *format, arg1, arg2); void CTR3(u_int mask, char *format, arg1, arg2, arg3); void CTR4(u_int mask, char *format, arg1, arg2, arg3, arg4); void CTR5(u_int mask, char *format, arg1, arg2, arg3, arg4, arg5); void CTR6(u_int mask, char *format, arg1, arg2, arg3, arg4, arg5, arg6); DESCRIPTION
KTR provides a circular buffer of events that can be logged in a printf(9) style fashion. These events can then be dumped with ddb(4), gdb(1) or ktrdump(8). Events are created and logged in the kernel via the CTRx macros. The first parameter is a mask of event types (KTR_*) defined in <sys/ktr.h>. The event will be logged only if any of the event types specified in mask are enabled in the global event mask stored in ktr_mask. The format argument is a printf(9) style format string used to build the text of the event log message. Following the format string are zero to five arguments referenced by format. Each event is logged with a file name and source line number of the originating CTR call, and a timestamp in addition to the log message. The event is stored in the circular buffer with supplied arguments as is, and formatting is done at the dump time. Do not use pointers to the objects with limited lifetime, for instance, strings, because the pointer may become invalid when buffer is printed. Note that the different macros differ only in the number of arguments each one takes, as indicated by its name. The ktr_entries variable contains the number of entries in the ktr_buf array. These variables are mostly useful for post-mortem crash dump tools to locate the base of the circular trace buffer and its length. The ktr_mask variable contains the run time mask of events to log. The CPU event mask is stored in the ktr_cpumask variable. The ktr_verbose variable stores the verbose flag that controls whether events are logged to the console in addition to the event buffer. EXAMPLES
This example demonstrates the use of tracepoints at the KTR_PROC logging level. void mi_switch() { ... /* * Pick a new current process and record its start time. */ ... CTR3(KTR_PROC, "mi_switch: old proc %p (pid %d)", p, p->p_pid); ... cpu_switch(); ... CTR3(KTR_PROC, "mi_switch: new proc %p (pid %d)", p, p->p_pid); ... } SEE ALSO
ktr(4), ktrdump(8) HISTORY
The KTR kernel tracing facility first appeared in BSD/OS 3.0 and was imported into FreeBSD 5.0. BUGS
Currently there is one global buffer shared among all CPUs. It might be profitable at some point in time to use per-CPU buffers instead so that if one CPU halts or starts spinning, then the log messages it emitted just prior to halting or spinning will not be drowned out by events from the other CPUs. The arguments given in CTRx() macros are stored as u_long, so do not pass arguments larger than size of an u_long type. For example passing 64bit arguments on 32bit architectures will give incorrect results. BSD
November 30, 2008 BSD
All times are GMT -4. The time now is 03:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy