topic Re: How to extract a value from database - using command line ? in Operating System - HP-UX

How to extract a value from database - using command line ?

Syed Madar J S — Mon, 19 May 2008 12:53:47 GMT

Hi,
i guess it would be possible to extract a value from database - using command line or shell scripting.

Please throw some light on this as i am new to this concept.

Re: How to extract a value from database - using command line ?

Steven E. Protter — Mon, 19 May 2008 13:00:02 GMT

Shalom,

It would be helpful to know what database we're talking about here.

Bottom line is most database servers come with a binary for extracting data from the database files. Now due to security concerns the raw database files may have encrypted data in them, making it impossible to extract anything from the command line but gibberish.

SEP

Re: How to extract a value from database - using command line ?

OldSchool — Mon, 19 May 2008 13:05:43 GMT

most databases have a command line interface, and it varies by db...

if it does, then you can use "here-docs" to extract data using a shell script. see the "man" page for whatever shell you are using. the concept is something along the lines of:

my_query_command <<-EOF
select blah from blahblah
EOF

Re: How to extract a value from database - using command line ?

Syed Madar J S — Mon, 19 May 2008 13:07:45 GMT

we are trying to extract value from "Postgre SQL"

we are using a method "cldb_getAllElements"

This method is suppose to return the list of elements in the set.

But when we remove all elements, and then try using the above method - we are encountering an error - as it tries to access an empty-list.!!

### This was the main problem ####

so i thought of extracting elements from database to check if the list is empty - through command line (Unix Shell) itself.

I guessed this might be a possible solution.

Re: How to extract a value from database - using command line ?

Syed Madar J S — Tue, 20 May 2008 03:36:05 GMT

/*#### this is the C++ method used to get the list ####*/

void Cldb::getAllElements(string * result, int *status) {

string sql = string("SELECT short_name ");

sql.append(" FROM node, element ");
sql.append(" WHERE element.management_node_id != node.node_id;\n");

char *answer;

mysqlResult(sql, "getAllElements", status, &answer);
if( *status == 0) {
*result = trimHeaderFromSqlOutput(answer);
} else {
*result = string("");
}
}

=================================

Any idea as how to deal with an empty-list when this method is called ?

Re: How to extract a value from database - using command line ?

Syed Madar J S — Wed, 17 Jun 2009 10:36:50 GMT

Thanks all