bool pgForeignServer::DropObject(wxFrame *frame, ctlTree *browser, bool cascaded)
{
wxString sql = wxT("DROP SERVER ") + GetQuotedFullIdentifier();
if (cascaded)
sql += wxT(" CASCADE");
return GetDatabase()->ExecuteVoid(sql);
}
bool gpExtTable::DropObject(wxFrame *frame, ctlTree *browser, bool cascaded)
{
wxString sql = wxT("DROP EXTERNAL TABLE ") + this->GetSchema()->GetQuotedIdentifier() + wxT(".") + this->GetQuotedIdentifier();
if (cascaded)
sql += wxT(" CASCADE");
return GetDatabase()->ExecuteVoid(sql);
}
bool pgDatabaseObjCollection::CanCreate()
{
if (IsCollectionForType(PGM_CATALOG))
return false;
return GetDatabase()->GetCreatePrivilege();
}
bool pgCast::DropObject(wxFrame *frame, ctlTree *browser, bool cascaded)
{
wxString sql = wxT("DROP CAST (") + GetSourceType() + wxT(" AS ") + GetTargetType() + wxT(")");
if (cascaded)
sql += wxT(" CASCADE");
return GetDatabase()->ExecuteVoid(sql);
}
bool pgCheck::DropObject(wxFrame *frame, ctlTree *browser, bool cascaded)
{
wxString sql = wxT("ALTER ") + objectKind + wxT(" ") + qtIdent(objectSchema) + wxT(".") + qtIdent(objectName)
+ wxT(" DROP CONSTRAINT ") + GetQuotedIdentifier();
if (cascaded)
sql += wxT(" CASCADE");
return GetDatabase()->ExecuteVoid(sql);
}
bool slPath::DropObject(wxFrame *frame, ctlTree *browser, bool cascaded)
{
return GetDatabase()->ExecuteVoid(
wxT("SELECT ") + GetCluster()->GetSchemaPrefix()
+ wxT("droppath(") + NumToStr(GetSlId())
+ wxT(", ") + NumToStr(GetNode()->GetSlId())
+ wxT(");\n"));
}
bool pgForeignKey::DropObject(wxFrame *frame, ctlTree *browser, bool cascaded)
{
wxString sql = wxT("ALTER TABLE ") + this->GetSchema()->GetQuotedIdentifier() + wxT(".") + qtIdent(fkTable)
+ wxT(" DROP CONSTRAINT ") + GetQuotedIdentifier();
if (cascaded)
sql += wxT(" CASCADE");
return GetDatabase()->ExecuteVoid(sql);
}
bool pgProcedure::DropObject(wxFrame *frame, ctlTree *browser, bool cascaded)
{
if (!GetConnection()->EdbMinimumVersion(8, 0))
return pgFunction::DropObject(frame, browser, cascaded);
wxString sql = wxT("DROP PROCEDURE ") + this->GetSchema()->GetQuotedIdentifier() + wxT(".") + this->GetQuotedIdentifier();
return GetDatabase()->ExecuteVoid(sql);
}
void pgView::RefreshMatView(bool concurrently)
{
wxString sql = wxT("REFRESH MATERIALIZED VIEW ");
if (concurrently)
sql += wxT("CONCURRENTLY ");
sql += GetQuotedFullIdentifier();
GetDatabase()->ExecuteVoid(sql);
}
void CDialogT3::Fresh()
{
SetTimer(T3_MODEL,1000,NULL);
GetDatabase();
ShowDialogData();
//Updatedatabase();
}
void pgForeignKey::Validate(frmMain *form)
{
wxString sql = wxT("ALTER TABLE ") + GetQuotedSchemaPrefix(fkSchema) + qtIdent(fkTable)
+ wxT("\n VALIDATE CONSTRAINT ") + GetQuotedIdentifier();
GetDatabase()->ExecuteVoid(sql);
iSetValid(true);
UpdateIcon(form->GetBrowser());
}
bool pgTextSearchParser::DropObject(wxFrame *frame, ctlTree *browser, bool cascaded)
{
wxString sql = wxT("DROP TEXT SEARCH PARSER ") + this->GetSchema()->GetQuotedIdentifier() + wxT(".") + this->GetIdentifier();
if (cascaded)
sql += wxT(" CASCADE");
return GetDatabase()->ExecuteVoid(sql);
}
bool pgTextSearchConfiguration::DropObject(wxFrame *frame, ctlTree *browser, bool cascaded)
{
wxString sql = wxT("DROP TEXT SEARCH CONFIGURATION ") + this->GetSchema()->GetQuotedIdentifier() + wxT(".") + qtIdent(this->GetIdentifier());
if (cascaded)
sql += wxT(" CASCADE");
return GetDatabase()->ExecuteVoid(sql);
}
bool slSubscription::DropObject(wxFrame *frame, ctlTree *browser, bool cascaded)
{
return GetDatabase()->ExecuteVoid(
wxT("SELECT ") + GetCluster()->GetSchemaPrefix()
+ wxT("unsubscribeset(") + NumToStr(GetSet()->GetSlId())
+ wxT(", ") + NumToStr(GetReceiverId())
+ wxT(");"));
}
void pgDomain::Validate(frmMain *form)
{
wxString sql = wxT("ALTER DOMAIN ") + GetQuotedFullIdentifier()
+ wxT("\n VALIDATE CONSTRAINT ") + GetCheckConstraintName();
GetDatabase()->ExecuteVoid(sql);
iSetValid(true);
UpdateIcon(form->GetBrowser());
}
bool edbPrivateSynonym::DropObject(wxFrame *frame, ctlTree *browser, bool cascaded)
{
wxString sql;
if (isPublic)
sql = wxT("DROP PUBLIC SYNONYM ") + GetQuotedIdentifier();
else
sql = wxT("DROP SYNONYM ") + this->GetSchema()->GetQuotedIdentifier() + wxT(".") + GetQuotedIdentifier();
return GetDatabase()->ExecuteVoid(sql);
}
void CConnection::SetDbName(const string& name, CDB_Connection* conn)
{
m_database = name;
if( GetDatabase().empty() )
return;
CDB_Connection* work = (conn == 0 ? GetCDB_Connection() : conn);
work->SetDatabaseName(name);
}
long slNode::GetOutstandingAcks()
{
long l = StrToLong(GetDatabase()->ExecuteScalar(
wxT("SELECT SUM(st_lag_num_events) AS sumlagevents\n")
wxT(" FROM ") + GetCluster()->GetSchemaPrefix() + wxT("sl_status\n")
wxT(" WHERE st_origin = ") + NumToStr(GetCluster()->GetLocalNodeID()) + wxT("\n")
wxT(" GROUP BY st_last_event")));
return l;
}
MockImapSession& MockTestSetup::GetSession()
{
if(!m_session.get()) {
m_session.reset(new MockImapSession(GetClientPtr(), GetDatabase()));
m_session->SetBusClient(*GetClientPtr());
m_session->SetAccount(m_account);
}
return *m_session;
}
void pgCheck::Validate(frmMain *form)
{
wxString sql = wxT("ALTER ") + objectKind + wxT(" ")
+ GetQuotedSchemaPrefix(objectSchema) + qtIdent(objectName)
+ wxT("\n VALIDATE CONSTRAINT ") + GetQuotedIdentifier();
GetDatabase()->ExecuteVoid(sql);
iSetValid(true);
UpdateIcon(form->GetBrowser());
}
FdoPtr<FdoSmPhRdSchemaReader> FdoSmPhOdbcMgr::CreateRdSchemaReader( FdoSmPhRowsP rows, FdoSmPhOwnerP owner, bool dsInfo )
{
rdbi_vndr_info_def info;
rdbi_vndr_info(GetRdbiContext(), &info );
if( info.dbversion == RDBI_DBVERSION_ODBC_TERADATA )
return new FdoSmPhRdTeraSchemaReader( rows, GetDatabase(), owner );
else
return new FdoSmPhRdOdbcSchemaReader( rows, owner, dsInfo );
}
bool Query::execute(const std::string& sql)
{ // query, no result
m_last_query = sql;
if (odb && res)
{
GetDatabase().error(*this, "execute: query busy");
}
if (odb && !res)
{
if (mysql_real_query(&odb -> mysql,sql.c_str(),sql.length()))
{
GetDatabase().error(*this,"query failed");
}
else
{
return true;
}
}
return false;
}
bool pgView::DropObject(wxFrame *frame, ctlTree *browser, bool cascaded)
{
if (GetMaterializedView())
sql = wxT("DROP MATERIALIZED VIEW ") + this->GetSchema()->GetQuotedIdentifier() + wxT(".") + this->GetQuotedIdentifier();
else
sql = wxT("DROP VIEW ") + this->GetSchema()->GetQuotedIdentifier() + wxT(".") + this->GetQuotedIdentifier();
if (cascaded)
sql += wxT(" CASCADE");
return GetDatabase()->ExecuteVoid(sql);
}
wxString pgDomain::GetSql(ctlTree *browser)
{
if (sql.IsNull())
{
sql = wxT("-- Domain: ") + GetQuotedFullIdentifier() + wxT("\n\n")
+ wxT("-- DROP DOMAIN ") + GetQuotedFullIdentifier() + wxT(";")
+ wxT("\n\nCREATE DOMAIN ") + GetQuotedFullIdentifier()
+ wxT("\n AS ") + GetQuotedBasetype();
if (GetCollationOid() > 0)
sql += wxT("\n COLLATE ") + GetQuotedCollation();
AppendIfFilled(sql, wxT("\n DEFAULT "), GetDefault());
// CONSTRAINT Name Dont know where it's stored, may be omitted anyway
if (notNull)
sql += wxT("\n NOT NULL");
// Get a count of the constraints.
int consCount = 0;
pgCollection *constraints = browser->FindCollection(checkFactory, GetId());
if (constraints)
{
constraints->ShowTreeDetail(browser);
treeObjectIterator consIt(browser, constraints);
pgObject *data;
while ((data = consIt.GetNextObject()) != 0)
{
data->ShowTreeDetail(browser);
sql += wxT("\n CONSTRAINT ") + data->GetQuotedIdentifier()
+ wxT(" ") + data->GetTypeName().Upper()
+ wxT(" ") ;
switch (data->GetMetaType())
{
case PGM_CHECK:
sql += wxT("(") + ((pgCheck *)data)->GetDefinition() + wxT(")");
if (GetDatabase()->BackendMinimumVersion(9, 2) && !((pgCheck *)data)->GetValid())
sql += wxT(" NOT VALID");
break;
}
}
}
sql += wxT(";\n")
+ GetOwnerSql(7, 4)
+ GetCommentSql();
if (GetConnection()->BackendMinimumVersion(9, 1))
sql += GetSeqLabelsSql();
}
return sql;
}
Query::~Query()
{
if (res)
{
GetDatabase().error(*this, "mysql_free_result in destructor");
mysql_free_result(res);
}
if (odb)
{
m_db.freedb(odb);
}
}
bool Query::Connected()
{
if (odb)
{
if (mysql_ping(&odb -> mysql))
{
GetDatabase().error(*this, "mysql_ping() failed");
return false;
}
}
return odb ? true : false;
}
Query::~Query()
{
if (res)
{
GetDatabase().error(*this, "sqlite3_finalize in destructor");
sqlite3_finalize(res);
}
if (odb)
{
m_db.freedb(odb);
}
}
sqlite3_stmt *Query::get_result(const std::string& sql)
{
// query, result
m_last_query = sql;
if (odb && res)
{
GetDatabase().error(*this, "get_result: query busy");
}
if (odb && !res)
{
const char *s = NULL;
int rc = sqlite3_prepare(odb -> db, sql.c_str(), sql.size(), &res, &s);
if (rc != SQLITE_OK)
{
GetDatabase().error(*this, "get_result: prepare query failed");
return NULL;
}
if (!res)
{
GetDatabase().error(*this, "get_result: query failed");
return NULL;
}
// get column names from result
{
int i = 0;
do
{
const char *p = sqlite3_column_name(res, i);
if (!p)
break;
m_nmap[p] = ++i;
} while (true);
m_num_cols = i;
}
cache_rc = sqlite3_step(res);
cache_rc_valid = true;
m_row_count = (cache_rc == SQLITE_ROW) ? 1 : 0;
}
return res;
}
void CApplicationImpl::OpenDataFile(const CString& csFileName)
{
if (!IsDataFileOpened(csFileName))
{
Database::IDataFile* pTempDataFile = GetDatabase()->OpenDataFile(csFileName);
try
{
if (pTempDataFile->IsEmpty())
{
CreateDefaultContent(pTempDataFile);
}
else
{
CheckContent(pTempDataFile);
}
CheckModules(pTempDataFile);
if (!m_spDataFile.is_null())
{
GetDatabase()->CloseDataFile(m_spDataFile.get());
}
m_spDataFile = pTempDataFile;
m_mru.AddToList(m_spDataFile->GetFileName());
m_mru.WriteToRegistry(GetOptionsPath(_T("Application")));
UpdateViews(UNM_FILE_OPENED, (WPARAM)m_spDataFile->GetFileName());
}
catch(...)
{
// close new opened temp data file and throw exception up
GetDatabase()->CloseDataFile(pTempDataFile);
throw;
}
}
}
void pgTrigger::SetEnabled(ctlTree *browser, const bool b)
{
if (GetQuotedFullTable().Len() > 0 && ((enabled && !b) || (!enabled && b)))
{
wxString sql = wxT("ALTER TABLE ") + GetQuotedFullTable() + wxT(" ");
if (enabled && !b)
sql += wxT("DISABLE");
else if (!enabled && b)
sql += wxT("ENABLE");
sql += wxT(" TRIGGER ") + GetQuotedIdentifier();
GetDatabase()->ExecuteVoid(sql);
}
enabled = b;
UpdateIcon(browser);
}
