自学教程：C++ GetFullIdentifier函数代码示例

wxString pgOperator::GetSql(ctlTree *browser){    if (sql.IsNull())    {        sql = wxT("-- Operator: ") + GetFullIdentifier() + wxT("(") + GetOperands() + wxT(")/n/n")            + wxT("-- DROP OPERATOR ") + GetFullIdentifier()	    + wxT("(") + GetOperands() + wxT(");/n/n")              wxT("CREATE OPERATOR ") + GetFullIdentifier()            + wxT("(/n  PROCEDURE = ") + qtIdent(GetOperatorFunction());        AppendIfFilled(sql, wxT(",/n  LEFTARG = "), qtTypeIdent(GetLeftType()));        AppendIfFilled(sql, wxT(",/n  RIGHTARG = "), qtTypeIdent(GetRightType()));        AppendIfFilled(sql, wxT(",/n  COMMUTATOR = "), GetCommutator());        AppendIfFilled(sql, wxT(",/n  RESTRICT = "), qtIdent(GetRestrictFunction()));        AppendIfFilled(sql, wxT(",/n  JOIN = "), qtIdent(GetJoinFunction()));        if (GetHashJoins()) sql += wxT(",/n  HASHES");        if (GetMergeJoins()) sql += wxT(",/n  MERGES");		if (!GetDatabase()->BackendMinimumVersion(8, 3))		{			AppendIfFilled(sql, wxT(",/n  SORT1 = "), GetLeftSortOperator());			AppendIfFilled(sql, wxT(",/n  SORT2 = "), GetRightSortOperator());			AppendIfFilled(sql, wxT(",/n  LTCMP = "), GetLessOperator());			AppendIfFilled(sql, wxT(",/n  GTCMP = "), GetGreaterOperator());		}        sql += wxT(");/n");	if (!GetComment().IsNull())	    sql += wxT("COMMENT ON OPERATOR ") + GetFullIdentifier()	    + wxT("(") + GetOperands() + wxT(") IS ")		+ qtDbString(GetComment()) + wxT(";/n");    }    return sql;}

wxString pgExtension::GetTranslatedMessage(int kindOfMessage) const{	wxString message = wxEmptyString;	switch (kindOfMessage)	{		case RETRIEVINGDETAILS:			message = _("Retrieving details on extension");			message += wxT(" ") + GetName();			break;		case REFRESHINGDETAILS:			message = _("Refreshing extension");			message += wxT(" ") + GetName();			break;		case DROPINCLUDINGDEPS:			message = wxString::Format(_("Are you sure you wish to drop extension /"%s/" including all objects that depend on it?"),			                           GetFullIdentifier().c_str());			break;		case DROPEXCLUDINGDEPS:			message = wxString::Format(_("Are you sure you wish to drop extension /"%s/"?"),			                           GetFullIdentifier().c_str());			break;		case DROPCASCADETITLE:			message = _("Drop extension cascaded?");			break;		case DROPTITLE:			message = _("Drop extension?");			break;		case PROPERTIESREPORT:			message = _("Extension properties report");			message += wxT(" - ") + GetName();			break;		case PROPERTIES:			message = _("Extension properties");			break;		case DDLREPORT:			message = _("Extension DDL report");			message += wxT(" - ") + GetName();			break;		case DDL:			message = _("Extension DDL");			break;		case DEPENDENCIESREPORT:			message = _("Extension dependencies report");			message += wxT(" - ") + GetName();			break;		case DEPENDENCIES:			message = _("Extension dependencies");			break;		case DEPENDENTSREPORT:			message = _("Extension dependents report");			message += wxT(" - ") + GetName();			break;		case DEPENDENTS:			message = _("Extension dependents");			break;	}	return message;}

wxString pgUser::GetTranslatedMessage(int kindOfMessage) const{    wxString message = wxEmptyString;    switch (kindOfMessage)    {    case RETRIEVINGDETAILS:        message = _("Retrieving details on user");        message += wxT(" ") + GetName();        break;    case REFRESHINGDETAILS:        message = _("Refreshing user");        message += wxT(" ") + GetName();        break;    case GRANTWIZARDTITLE:        message = _("Privileges for user");        message += wxT(" ") + GetName();        break;    case DROPINCLUDINGDEPS:        message = wxString::Format(_("Are you sure you wish to drop user /"%s/" including all objects that depend on it?"),                                   GetFullIdentifier().c_str());        break;    case DROPEXCLUDINGDEPS:        message = wxString::Format(_("Are you sure you wish to drop user /"%s/"?"),                                   GetFullIdentifier().c_str());        break;    case DROPCASCADETITLE:        message = _("Drop user cascaded?");        break;    case DROPTITLE:        message = _("Drop user?");        break;    case PROPERTIES:        message = _("User properties");        break;    case DDL:        message = _("User DDL");        break;    case DEPENDENCIES:        message = _("User dependencies");        break;    case DEPENDENTS:        message = _("User dependents");        break;    }    return message;}

wxString pgaJob::GetTranslatedMessage(int kindOfMessage) const{	wxString message = wxEmptyString;	switch (kindOfMessage)	{		case RETRIEVINGDETAILS:			message = _("Retrieving details on pgAgent job");			break;		case REFRESHINGDETAILS:			message = _("Refreshing pgAgent job");			break;		case PROPERTIES:			message = _("pgAgent job properties");			break;		case DEPENDENCIES:			message = _("pgAgent job dependencies");			break;		case DEPENDENTS:			message = _("pgAgent job dependents");			break;		case DROPEXCLUDINGDEPS:			message = wxString::Format(_("Are you sure you wish to drop job /"%s/"?"),			                           GetFullIdentifier().c_str());			break;		case DROPTITLE:			message = _("Drop job?");			break;	}	if (!message.IsEmpty() && !(kindOfMessage == DROPEXCLUDINGDEPS || kindOfMessage == DROPTITLE))		message += wxT(" ") + GetName();	return message;}

wxString pgForeignTable::GetTranslatedMessage(int kindOfMessage) const{	wxString message = wxEmptyString;	switch (kindOfMessage)	{		case RETRIEVINGDETAILS:			message = _("Retrieving details on foreign table");			message += wxT(" ") + GetName();			break;		case REFRESHINGDETAILS:			message = _("Refreshing foreign table");			message += wxT(" ") + GetName();			break;		case DROPINCLUDINGDEPS:			message = wxString::Format(_("Are you sure you wish to drop foreign table /"%s/" including all objects that depend on it?"),			                           GetFullIdentifier().c_str());			break;		case DROPEXCLUDINGDEPS:			message = wxString::Format(_("Are you sure you wish to drop foreign table /"%s/"?"),			                           GetFullIdentifier().c_str());			break;		case DROPCASCADETITLE:			message = _("Drop foreign table cascaded?");			break;		case DROPTITLE:			message = _("Drop foreign table?");			break;		case PROPERTIES:			message = _("Foreign table properties");			break;		case DDL:			message = _("Foreign table DDL");			break;		case DEPENDENCIES:			message = _("Foreign table dependencies");			break;		case DEPENDENTS:			message = _("Foreign table dependents");			break;	}	return message;}

wxString pgTextSearchDictionary::GetSql(ctlTree *browser){	if (sql.IsNull())	{		sql = wxT("-- Text Search Dictionary: ") + GetFullIdentifier() + wxT("/n/n")		      + wxT("-- DROP TEXT SEARCH DICTIONARY ") + GetFullIdentifier() + wxT("/n/n")		      + wxT("CREATE TEXT SEARCH DICTIONARY ") + GetFullIdentifier() + wxT(" (")		      + wxT("/n   TEMPLATE = ") + qtTypeIdent(GetTemplate());		if (options.Length() > 0)			sql += wxT(",/n   ") + options;		sql += wxT("/n);/n");		if (!GetComment().IsNull())			sql += wxT("COMMENT ON TEXT SEARCH DICTIONARY ") + GetFullIdentifier()			       + wxT(" IS ") + qtDbString(GetComment()) + wxT(";/n");	}	return sql;}

wxString pgTextSearchParser::GetSql(ctlTree *browser){	if (sql.IsNull())	{		sql = wxT("-- Text Search Parser: ") + GetFullIdentifier() + wxT("/n/n")		      + wxT("-- DROP TEXT SEARCH PARSER ") + GetFullIdentifier() + wxT("/n/n")		      + wxT("CREATE TEXT SEARCH PARSER ") + GetFullIdentifier() + wxT(" (")		      + wxT("/n  START = ") + qtTypeIdent(GetStart())		      + wxT(",/n  GETTOKEN = ") + qtTypeIdent(GetGettoken())		      + wxT(",/n  END = ") + qtTypeIdent(GetEnd())		      + wxT(",/n  LEXTYPES = ") + qtTypeIdent(GetLextypes());		AppendIfFilled(sql, wxT(",/n  HEADLINE = "), GetHeadline());		sql += wxT("/n);/n");		if (!GetComment().IsNull())			sql += wxT("COMMENT ON TEXT SEARCH PARSER ") + GetFullIdentifier()			       + wxT(" IS ") + qtDbString(GetComment()) + wxT(";/n");	}	return sql;}

wxString pgTextSearchConfiguration::GetSql(ctlTree *browser){	if (sql.IsNull())	{		sql = wxT("-- Text Search Configuration: ") + GetFullIdentifier() + wxT("/n/n")		      + wxT("-- DROP TEXT SEARCH CONFIGURATION ") + GetFullIdentifier() + wxT("/n/n")		      + wxT("CREATE TEXT SEARCH CONFIGURATION ") + GetFullIdentifier() + wxT(" (")		      + wxT("/n  PARSER = ") + qtTypeIdent(GetParser())		      + wxT("/n);/n");		for (size_t i = 0 ; i < tokens.GetCount() ; i++)			sql += wxT("ALTER TEXT SEARCH CONFIGURATION ") + GetQuotedFullIdentifier()			       +  wxT(" ADD MAPPING FOR ") + tokens.Item(i).BeforeFirst('/')			       +  wxT(" WITH ") + tokens.Item(i).AfterFirst('/')			       +  wxT(";/n");		if (!GetComment().IsNull())			sql += wxT("COMMENT ON TEXT SEARCH CONFIGURATION ") + GetFullIdentifier()			       + wxT(" IS ") + qtDbString(GetComment()) + wxT(";/n");	}	return sql;}

wxString edbPrivateSynonym::GetTranslatedMessage(int kindOfMessage) const{	wxString message = wxEmptyString;	switch (kindOfMessage)	{		case DROPEXCLUDINGDEPS:			message = wxString::Format(_("Are you sure you wish to drop synonym /"%s/"?"),			                           GetFullIdentifier().c_str());			break;		case DROPTITLE:			message = _("Drop synonym?");			break;	}	return message;}

void pgDatabase::ShowHint(frmMain *form, bool force){	wxArrayString hints;	int rc = -1;	if (encoding == wxT("SQL_ASCII"))		hints.Add(HINT_ENCODING_ASCII);	else if (encoding == wxT("UNICODE"))	{		wxString ver = GetServer()->GetVersionString();		if (ver.Find(wxT("mingw32")) > 0 && ver.Find(wxT("SQL 8.0.")) > 0)			hints.Add(HINT_ENCODING_UNICODE);	}	if (GetServer()->GetConnection() == GetConnection() &&	        GetConnection()->BackendMinimumVersion(8, 0) &&	        !GetConnection()->HasFeature(FEATURE_FILEREAD))	{		// if the server release is 9.1 or more and the server has no adminpack		if (GetConnection()->BackendMinimumVersion(9, 1))		{			// Search the adminpack extension			pgSet *set = GetConnection()->ExecuteSet(wxT("SELECT 1 FROM pg_available_extensions WHERE name='adminpack'"));			if (set->NumRows() == 1)				hints.Add(HINT_INSTRUMENTATION_91_WITH);			else				hints.Add(HINT_INSTRUMENTATION_91_WITHOUT);			delete set;		}		else			hints.Add(HINT_INSTRUMENTATION);	}	if (force || !hintShown)	{		rc = frmHint::ShowHint(form, hints, GetFullIdentifier(), force);		if (rc == HINT_RC_FIX)			GetConnection()->ExecuteVoid(wxT("CREATE EXTENSION adminpack"), true);	}	hintShown = true;}

wxString pgForeignServer::GetTranslatedMessage(int kindOfMessage) const{	wxString message = wxEmptyString;	switch (kindOfMessage)	{		case RETRIEVINGDETAILS:			message = _("Retrieving details on foreign server");			message += wxT(" ") + GetName();			break;		case REFRESHINGDETAILS:			message = _("Refreshing foreign server");			message += wxT(" ") + GetName();			break;		case DROPINCLUDINGDEPS:			message = wxString::Format(_("Are you sure you wish to drop foreign server /"%s/" including all objects that depend on it?"),			                           GetFullIdentifier().c_str());			break;		case DROPEXCLUDINGDEPS:			message = wxString::Format(_("Are you sure you wish to drop foreign server /"%s/"?"),			                           GetFullIdentifier().c_str());			break;		case DROPCASCADETITLE:			message = _("Drop foreign server cascaded?");			break;		case DROPTITLE:			message = _("Drop foreign server?");			break;		case PROPERTIESREPORT:			message = _("Foreign server properties report");			message += wxT(" - ") + GetName();			break;		case PROPERTIES:			message = _("Foreign server properties");			break;		case DDLREPORT:			message = _("Foreign server DDL report");			message += wxT(" - ") + GetName();			break;		case DDL:			message = _("Foreign server DDL");			break;		case STATISTICSREPORT:			message = _("Foreign server statistics report");			message += wxT(" - ") + GetName();			break;		case OBJSTATISTICS:			message = _("Foreign server statistics");			break;		case DEPENDENCIESREPORT:			message = _("Foreign server dependencies report");			message += wxT(" - ") + GetName();			break;		case DEPENDENCIES:			message = _("Foreign server dependencies");			break;		case DEPENDENTSREPORT:			message = _("Foreign server dependents report");			message += wxT(" - ") + GetName();			break;		case DEPENDENTS:			message = _("Foreign server dependents");			break;	}	return message;}

void pgView::ShowHint(frmMain *form, bool force){	wxArrayString hints;	hints.Add(HINT_OBJECT_EDITING);	frmHint::ShowHint((wxWindow *)form, hints, GetFullIdentifier(), force);}

void pgaJob::ShowStatistics(frmMain *form, ctlListView *statistics){	wxString sql =	    wxT("SELECT jlgid")	    wxT(", jlgstatus")	    wxT(", jlgstart")	    wxT(", jlgduration")	    wxT(", (jlgstart + jlgduration) AS endtime")	    wxT("  FROM pgagent.pga_joblog/n")	    wxT(" WHERE jlgjobid = ") + NumToStr(GetRecId()) +	    wxT(" ORDER BY jlgstart DESC") +	    wxT(" LIMIT ") + NumToStr(settings->GetMaxRows());	if (statistics)	{		wxLogInfo(wxT("Displaying statistics for job %s"), GetFullIdentifier().c_str());		// Add the statistics view columns		statistics->ClearAll();		statistics->AddColumn(_("Run"), 50);		statistics->AddColumn(_("Status"), 60);		statistics->AddColumn(_("Start time"), 95);		statistics->AddColumn(_("End time"), 95);		statistics->AddColumn(_("Duration"), 70);		pgSet *stats = GetConnection()->ExecuteSet(sql);		wxString status;		wxDateTime startTime;		wxDateTime endTime;		if (stats)		{			while (!stats->Eof())			{				if (stats->GetVal(1) == wxT("r"))					status = _("Running");				else if (stats->GetVal(1) == wxT("s"))					status = _("Successful");				else if (stats->GetVal(1) == wxT("f"))					status = _("Failed");				else if (stats->GetVal(1) == wxT("d"))					status = _("Aborted");				else if (stats->GetVal(1) == wxT("i"))					status = _("No steps");				else					status = _("Unknown");				startTime.ParseDateTime(stats->GetVal(2));				endTime.ParseDateTime(stats->GetVal(4));				long pos = statistics->AppendItem(stats->GetVal(0), status, startTime.Format());				if (stats->GetVal(4).Length() > 0)					statistics->SetItem(pos, 3, endTime.Format());				statistics->SetItem(pos, 4, stats->GetVal(3));				stats->MoveNext();			}			delete stats;		}	}}