/*--------------------------------------------------------------------------------*/
bool PostgresDatabase::TableExists(const AString& name)
{
SQLQuery *query = NULL;
if ((query = RunQuery(AString("select count(*) from %").Arg(name))) != NULL) {
bool success = query->GetResult();
delete query;
return success;
}
return false;
}
/*--------------------------------------------------------------------------------*/
bool PostgresDatabase::CreateTable(const AString& name, const AString& columns)
{
AString sql;
SQLQuery *query = NULL;
uint_t i, n = columns.CountColumns();
sql.printf("create table %s (", name.str());
for (i = 0; i < n; i++) {
AString column = columns.Column(i);
if (i > 0) sql.printf(", ");
sql.printf("%s %s", column.Word(0).str(), GetColumnType(column).str());
}
sql.printf(")");
if ((query = RunQuery(sql)) != NULL) {
bool success = query->GetResult();
delete query;
return success;
}
return false;
}