Re: "timer" script from SAMS book or equivalent?

From: John Wells <jb(at)sourceillustrated(dot)com>
To: John Wells <jb(at)sourceillustrated(dot)com>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>, Felipe de Jesús Molina Bravo <felipe(dot)molina(at)inegi(dot)gob(dot)mx>, Owen Hartnett <owen(at)clipboardinc(dot)com>
Subject: Re: "timer" script from SAMS book or equivalent?
Date: 2007-10-10 12:43:29
Message-ID: 5187489.2851192020209886.JavaMail.root@cayman.devsea.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Could someone explain to me how the connection is initialized below? I'm re-writing the script in Ruby...but this is a stumbling block for me in the way the C++ libs work. Does the library initial conn automagically? How would one emulate this in another language...would it be to run it as the postgres user and connection to template1?

Thanks,
John

int main( int argc, char * argv[] )
{
// how is this being initialized?
connection conn;

work tran1( conn, "getBegValues" );

const result & begTupleValues = getTupleValues( tran1, argc > 2 ?
argv[2] : 0 );
const result & begBlockValues = getBlockValues( tran1, argc > 2 ?
argv[2] : 0 );

const result & ignore = tran1.exec( argv[1] );

tran1.commit();

sleep( 1 );

work tran2( conn, "getEndValues" );

const result & endTupleValues = getTupleValues( tran2, argc > 2 ?
argv[2] : 0 );
const result & endBlockValues = getBlockValues( tran2, argc > 2 ?
argv[2] : 0 );

printDeltas( begTupleValues, endTupleValues, begBlockValues,
endBlockValues );


}

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2007-10-10 14:02:27 Re: disjoint union types
Previous Message Owen Hartnett 2007-10-10 11:22:34 Re: Generating subtotal reports direct from SQL