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
|
//////////////////////////////////////////////////////////////////////////
//
// pgAdmin III - PostgreSQL Tools
//
// Copyright (C) 2002 - 2014, The pgAdmin Development Team
// This software is released under the PostgreSQL Licence
//
// dlgMoveTablespace.cpp - Reassign or drop owned objects
//
//////////////////////////////////////////////////////////////////////////
#include "pgAdmin3.h"
// wxWindows headers
#include <wx/wx.h>
// App headers
#include "pgAdmin3.h"
#include "utils/pgDefs.h"
#include "frm/frmMain.h"
#include "dlg/dlgMoveTablespace.h"
#include "utils/misc.h"
#include "schema/pgTablespace.h"
// pointer to controls
#define cbMoveTo CTRL_COMBOBOX("cbMoveTo")
#define cbKind CTRL_COMBOBOX("cbKind")
#define cbOwner CTRL_COMBOBOX("cbOwner")
#define btnOK CTRL_BUTTON("wxID_OK")
BEGIN_EVENT_TABLE(dlgMoveTablespace, pgDialog)
EVT_BUTTON(wxID_OK, dlgMoveTablespace::OnOK)
END_EVENT_TABLE()
dlgMoveTablespace::dlgMoveTablespace(frmMain *win, pgConn *conn, pgTablespace *tblspc)
{
wxString query;
connection = conn;
parent = win;
SetFont(settings->GetSystemFont());
LoadResource(win, wxT("dlgMoveTablespace"));
RestorePosition();
cbKind->Clear();
cbKind->Append(_("All"));
cbKind->Append(_("Tables"));
cbKind->Append(_("Indexes"));
cbKind->Append(_("Materialized views"));
cbKind->SetSelection(0);
cbMoveTo->Clear();
query = wxT("SELECT spcname FROM pg_tablespace WHERE spcname<>") + conn->qtDbString(tblspc->GetName()) + wxT(" ORDER BY spcname");
pgSetIterator tblspcs(connection, query);
while (tblspcs.RowsLeft())
{
cbMoveTo->Append(tblspcs.GetVal(wxT("spcname")));
}
cbMoveTo->SetSelection(0);
cbOwner->Clear();
cbOwner->Append(wxEmptyString);
query = wxT("SELECT rolname FROM pg_roles ORDER BY rolname");
pgSetIterator roles(connection, query);
while (roles.RowsLeft())
{
cbOwner->Append(roles.GetVal(wxT("rolname")));
}
cbOwner->SetSelection(0);
cbOwner->Enable(cbOwner->GetStrings().Count() > 0);
SetSize(330, 160);
}
dlgMoveTablespace::~dlgMoveTablespace()
{
SavePosition();
}
void dlgMoveTablespace::OnOK(wxCommandEvent &ev)
{
EndModal(wxID_OK);
}
void dlgMoveTablespace::OnCancel(wxCommandEvent &ev)
{
EndModal(wxID_CANCEL);
}
wxString dlgMoveTablespace::GetTablespace()
{
return cbMoveTo->GetValue();
}
wxString dlgMoveTablespace::GetKind()
{
wxString kind;
if (cbKind->GetValue().Cmp(_("Tables")) == 0)
return wxT("TABLES");
if (cbKind->GetValue().Cmp(_("Indexes")) == 0)
return wxT("INDEXES");
if (cbKind->GetValue().Cmp(_("Materialized views")) == 0)
return wxT("MATERIALIZED VIEWS");
return wxT("ALL");
}
wxString dlgMoveTablespace::GetOwner()
{
return cbOwner->GetValue();
}
|
