U++ forum: Welcome to the forum

Quick explanation of function calls for postgresql [message #16598]

Mon, 30 June 2008 22:50

captainc
Messages: 278
Registered: December 2006
Location: New Jersey, USA

Experienced Member

I've been looking over the examples for postgres as I would like to use the functionality, but I am confused as to what exactly some of the functions do. I have been browsing the source, but I think it would help if we had a quick explanation of the structure of the code and some of these functions.

from the example, this is the section that confuses me most:

Progress p;
p.SetText(t_("Creating _DEBUG database"));
SqlSchema sch(PGSQL);
StdStatementExecutor se(m_session);
All_Tables(sch);
if(sch.ScriptChanged(SqlSchema::UPGRADE))
PostgreSQLPerformScript(sch.Upgrade(),se, p);
if(sch.ScriptChanged(SqlSchema::ATTRIBUTES)) {
PostgreSQLPerformScript(sch.Attributes(),se, p);
}
if(sch.ScriptChanged(SqlSchema::CONFIG)) {
PostgreSQLPerformScript(sch.ConfigDrop(),se, p);
PostgreSQLPerformScript(sch.Config(),se, p);
}
sch.SaveNormal();

The functions/lines I am not sure about are
All_Tables() --> Load information from all the tables of the db?
ScriptChanged() --> Check if table info different from defined schema?
PostgreSQLPerformScript()
Attributes()
ConfigDrop()
Config()
SaveNormal() --> Save all changes back to database?

Report message to a moderator