1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
|
//////////////////////////////////////////////////////////////////////////
//
// pgAdmin III - PostgreSQL Tools
//
// Copyright (C) 2002 - 2014, The pgAdmin Development Team
// This software is released under the PostgreSQL Licence
//
// pgOperatorFamily.cpp - OperatorFamily class
//
//////////////////////////////////////////////////////////////////////////
// wxWindows headers
#include <wx/wx.h>
// App headers
#include "pgAdmin3.h"
#include "utils/misc.h"
#include "schema/pgOperatorFamily.h"
#include "schema/pgFunction.h"
pgOperatorFamily::pgOperatorFamily(pgSchema *newSchema, const wxString &newName)
: pgSchemaObject(newSchema, operatorFamilyFactory, newName)
{
}
pgOperatorFamily::~pgOperatorFamily()
{
}
wxString pgOperatorFamily::GetTranslatedMessage(int kindOfMessage) const
{
wxString message = wxEmptyString;
switch (kindOfMessage)
{
case RETRIEVINGDETAILS:
message = _("Retrieving details on operator family");
message += wxT(" ") + GetName();
break;
case REFRESHINGDETAILS:
message = _("Refreshing operator family");
message += wxT(" ") + GetName();
break;
case DROPINCLUDINGDEPS:
message = wxString::Format(_("Are you sure you wish to drop operator family \"%s\" including all objects that depend on it?"),
GetFullIdentifier().c_str());
break;
case DROPEXCLUDINGDEPS:
message = wxString::Format(_("Are you sure you wish to drop operator family \"%s\"?"),
GetFullIdentifier().c_str());
break;
case DROPCASCADETITLE:
message = _("Drop operator family cascaded?");
break;
case DROPTITLE:
message = _("Drop operator family?");
break;
case PROPERTIESREPORT:
message = _("Operator family properties report");
message += wxT(" - ") + GetName();
break;
case PROPERTIES:
message = _("Operator family properties");
break;
case DDLREPORT:
message = _("Operator family DDL report");
message += wxT(" - ") + GetName();
break;
case DDL:
message = _("Operator family DDL");
break;
case DEPENDENCIESREPORT:
message = _("Operator family dependencies report");
message += wxT(" - ") + GetName();
break;
case DEPENDENCIES:
message = _("Operator family dependencies");
break;
case DEPENDENTSREPORT:
message = _("Operator family dependents report");
message += wxT(" - ") + GetName();
break;
case DEPENDENTS:
message = _("Operator family dependents");
break;
}
return message;
}
bool pgOperatorFamily::DropObject(wxFrame *frame, ctlTree *browser, bool cascaded)
{
wxString sql = wxT("DROP OPERATOR FAMILY ") + this->GetSchema()->GetQuotedIdentifier() + wxT(".") + this->GetQuotedIdentifier() + wxT(" USING ") + GetAccessMethod();
if (cascaded)
sql += wxT(" CASCADE");
return GetDatabase()->ExecuteVoid(sql);
}
wxString pgOperatorFamily::GetSql(ctlTree *browser)
{
if (sql.IsNull())
{
sql = wxT("-- Operator Family: ") + GetName() + wxT("\n\n")
+ wxT("-- DROP OPERATOR FAMILY ") + GetQuotedFullIdentifier() + wxT(" USING ") + GetAccessMethod() + wxT(";")
+ wxT("\n\nCREATE OPERATOR FAMILY ") + GetQuotedFullIdentifier()
+ wxT(" USING ") + GetAccessMethod()
+ wxT(";");
}
return sql;
}
void pgOperatorFamily::ShowTreeDetail(ctlTree *browser, frmMain *form, ctlListView *properties, ctlSQLBox *sqlPane)
{
if (properties)
{
CreateListColumns(properties);
properties->AppendItem(_("Name"), GetName());
properties->AppendItem(_("OID"), GetOid());
properties->AppendItem(_("Owner"), GetOwner());
properties->AppendItem(_("Access method"), GetAccessMethod());
properties->AppendYesNoItem(_("System operator family?"), GetSystemObject());
properties->AppendItem(_("Comment"), firstLineOnly(GetComment()));
}
}
pgObject *pgOperatorFamily::Refresh(ctlTree *browser, const wxTreeItemId item)
{
pgObject *operatorFamily = 0;
pgCollection *coll = browser->GetParentCollection(item);
if (coll)
operatorFamily = operatorFamilyFactory.CreateObjects(coll, 0, wxT("\n AND opf.oid=") + GetOidStr());
return operatorFamily;
}
///////////////////////////////////////////////////
pgOperatorFamilyCollection::pgOperatorFamilyCollection(pgaFactory *factory, pgSchema *sch)
: pgSchemaObjCollection(factory, sch)
{
}
wxString pgOperatorFamilyCollection::GetTranslatedMessage(int kindOfMessage) const
{
wxString message = wxEmptyString;
switch (kindOfMessage)
{
case RETRIEVINGDETAILS:
message = _("Retrieving details on operator families");
break;
case REFRESHINGDETAILS:
message = _("Refreshing operator families");
break;
case OBJECTSLISTREPORT:
message = _("Operator families list report");
break;
}
return message;
}
///////////////////////////////////////////////////
pgObject *pgOperatorFamilyFactory::CreateObjects(pgCollection *collection, ctlTree *browser, const wxString &restriction)
{
pgOperatorFamily *operatorFamily = 0;
pgSet *operatorFamilies;
operatorFamilies = collection->GetDatabase()->ExecuteSet(
wxT("SELECT opf.oid, opf.*, pg_get_userbyid(opf.opfowner) as opowner, amname\n")
wxT(" FROM pg_opfamily opf\n")
wxT(" JOIN pg_am am ON am.oid=opf.opfmethod\n")
wxT(" WHERE opfnamespace = ") + collection->GetSchema()->GetOidStr()
+ restriction + wxT("\n")
wxT(" ORDER BY opfname"));
if (operatorFamilies)
{
while (!operatorFamilies->Eof())
{
operatorFamily = new pgOperatorFamily(
collection->GetSchema(), operatorFamilies->GetVal(wxT("opfname")));
operatorFamily->iSetOid(operatorFamilies->GetOid(wxT("oid")));
operatorFamily->iSetOwner(operatorFamilies->GetVal(wxT("opowner")));
operatorFamily->iSetAccessMethod(operatorFamilies->GetVal(wxT("amname")));
if (browser)
{
browser->AppendObject(collection, operatorFamily);
operatorFamilies->MoveNext();
}
else
break;
}
delete operatorFamilies;
}
return operatorFamily;
}
#include "images/operatorfamily.pngc"
#include "images/operatorfamilies.pngc"
pgOperatorFamilyFactory::pgOperatorFamilyFactory()
: pgSchemaObjFactory(__("Operator Family"), __("New Operator Family..."), __("Create a new Operator Family."), operatorfamily_png_img)
{
metaType = PGM_OPFAMILY;
}
dlgProperty *pgOperatorFamilyFactory::CreateDialog(frmMain *frame, pgObject *node, pgObject *parent)
{
return 0; // not implemented
}
pgCollection *pgOperatorFamilyFactory::CreateCollection(pgObject *obj)
{
return new pgOperatorFamilyCollection(GetCollectionFactory(), (pgSchema *)obj);
}
pgOperatorFamilyFactory operatorFamilyFactory;
static pgaCollectionFactory cf(&operatorFamilyFactory, __("Operator Families"), operatorfamilies_png_img);
|
