wxString edbSynonym::GetSql(ctlTree *browser)
{
if (sql.IsNull())
{
sql = wxT("-- Public synonym: ") + GetQuotedIdentifier() + wxT("\n\n")
wxT("-- DROP PUBLIC SYNONYM ") + GetQuotedIdentifier();
sql += wxT("\n\nCREATE OR REPLACE PUBLIC SYNONYM ") + GetQuotedIdentifier() + wxT(" FOR ");
if (GetTargetSchema() != wxEmptyString)
sql += qtIdent(GetTargetSchema()) + wxT(".");
sql += qtIdent(GetTargetObject()) + wxT(";\n");
}
return sql;
}
void edbSynonym::ShowTreeDetail(ctlTree *browser, frmMain *form, ctlListView *properties, ctlSQLBox *sqlPane)
{
if (properties)
{
CreateListColumns(properties);
properties->AppendItem(_("Name"), GetName());
properties->AppendItem(_("Owner"), GetOwner());
properties->AppendItem(_("Target type"), GetTargetType());
properties->AppendItem(_("Target schema"), GetTargetSchema());
properties->AppendItem(_("Target object"), GetTargetObject());
properties->AppendYesNoItem(_("System synonym?"), GetSystemObject());
}
}
void edbPrivateSynonym::ShowTreeDetail(ctlTree *browser, frmMain *form, ctlListView *properties, ctlSQLBox *sqlPane)
{
if (properties)
{
CreateListColumns(properties);
properties->AppendItem(_("Public Synonym"), isPublic ? _("Yes") : _("No"));
properties->AppendItem(_("Name"), GetName());
if (!isPublic)
properties->AppendItem(_("Schema"), GetSchema()->GetName());
properties->AppendItem(_("Owner"), GetOwner());
properties->AppendItem(_("Target type"), GetTargetType());
properties->AppendItem(_("Target schema"), GetTargetSchema());
properties->AppendItem(_("Target object"), GetTargetObject());
properties->AppendItem(_("System synonym?"), GetSystemObject());
}
}
