Home
About
Blog
Products
Forum
Support
Contact
Sunbelt Computer Software
PL/B Language Development and Support
Home
About
Blog
Products
Forum
Support
Contact
sqlitebrowser/src/RemoteDock.cpp at master · jiangdon2007/sqlitebrowser · GitHub
Skip to content
Navigation Menu
Sign in
Appearance settings
Platform
AI CODE CREATION
GitHub Copilot
Write better code with AI
GitHub Copilot app
Direct agents from issue to merge
MCP Registry
Integrate external tools
DEVELOPER WORKFLOWS
Actions
Automate any workflow
Codespaces
Instant dev environments
Issues
Plan and track work
Code Review
Manage code changes
Code Quality
Enforce quality at merge
APPLICATION SECURITY
GitHub Advanced Security
Find and fix vulnerabilities
Code security
Secure your code as you build
Secret protection
Stop leaks before they start
EXPLORE
Why GitHub
Documentation
Blog
Changelog
Marketplace
View all features
Solutions
BY COMPANY SIZE
Enterprises
Small and medium teams
Startups
Nonprofits
BY USE CASE
App Modernization
DevSecOps
DevOps
CI/CD
View all use cases
BY INDUSTRY
Healthcare
Financial services
Manufacturing
Government
View all industries
View all solutions
Resources
EXPLORE BY TOPIC
AI
Software Development
DevOps
Security
View all topics
EXPLORE BY TYPE
Customer stories
Events & webinars
Ebooks & reports
Business insights
GitHub Skills
SUPPORT & SERVICES
Documentation
Customer support
Community forum
Trust center
Partners
View all resources
Open Source
COMMUNITY
GitHub Sponsors
Fund open source developers
PROGRAMS
Security Lab
Maintainer Community
GitHub Stars
Archive Program
REPOSITORIES
Topics
Trending
Collections
Enterprise
ENTERPRISE SOLUTIONS
Enterprise platform
AI-powered developer platform
AVAILABLE ADD-ONS
GitHub Advanced Security
Enterprise-grade security features
Copilot for Business
Enterprise-grade AI features
Premium Support
Enterprise-grade 24/7 support
Pricing
Search
/
Sign in
Sign up
Appearance settings
You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.
You switched accounts on another tab or window.
Reload
to refresh your session.
Dismiss alert
{{ message }}
jiangdon2007
sqlitebrowser
Repository navigation
Code
Pull requests
Actions
Projects
Security and quality
Insights
More
items
Files
Expand file tree
master
Breadcrumbs
sqlitebrowser
/
src
/
RemoteDock.cpp
Copy path
Blame
More file actions
Blame
More file actions
Latest commit
History
History
History
172 lines (143 loc) · 5.95 KB
master
Breadcrumbs
sqlitebrowser
/
src
/
RemoteDock.cpp
Copy path
Top
File metadata and controls
Code
Blame
172 lines (143 loc) · 5.95 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
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
#
include
<
QDesktopServices
>
#
include
<
QFileInfo
>
#
include
<
QUrl
>
#
include
"
RemoteDock.h
"
#
include
"
ui_RemoteDock.h
"
#
include
"
Settings.h
"
#
include
"
RemoteDatabase.h
"
#
include
"
RemoteModel.h
"
#
include
"
MainWindow.h
"
#
include
"
RemotePushDialog.h
"
#
include
"
PreferencesDialog.h
"
RemoteDock::RemoteDock
(MainWindow* parent)
: QDialog(parent),
ui(
new
Ui::RemoteDock),
mainWindow(parent),
remoteDatabase(parent->
getRemote
()),
remoteModel(
new
RemoteModel(
this
, parent->
getRemote
()))
{
ui->
setupUi
(
this
);
//
Set up model
ui->
treeStructure
->
setModel
(remoteModel);
//
Reload the directory tree when a database upload has finished
connect
(&remoteDatabase, &RemoteDatabase::uploadFinished,
this
, &RemoteDock::setNewIdentity);
//
Whenever a new directory listing has been parsed, check if it was a new root dir and, if so, open the user's directory
connect
(remoteModel, &RemoteModel::directoryListingParsed,
this
, &RemoteDock::newDirectoryNode);
//
When the Preferences link is clicked in the no-certificates-label, open the preferences dialog. For other links than the ones we know,
//
just open them in a web browser
connect
(ui->
labelNoCert
, &QLabel::linkActivated, [
this
](
const
QString& link) {
if
(link ==
"
#preferences
"
)
{
PreferencesDialog
dialog
(mainWindow, PreferencesDialog::TabRemote);
if
(dialog.
exec
())
mainWindow->
reloadSettings
();
}
else
{
QDesktopServices::openUrl
(
QUrl
(link));
}
});
//
Initial setup
reloadSettings
();
}
RemoteDock::~RemoteDock
()
{
delete
ui;
}
void
RemoteDock::reloadSettings
()
{
//
Load list of client certs
ui->
comboUser
->
clear
();
QStringList client_certs =
Settings::getValue
(
"
remote
"
,
"
client_certificates
"
).
toStringList
();
for
(
const
QString& file : client_certs)
{
auto
certs =
QSslCertificate::fromPath
(file);
for
(
const
QSslCertificate& cert : certs)
ui->
comboUser
->
addItem
(cert.
subjectInfo
(QSslCertificate::CommonName).
at
(
0
), file);
}
//
Add public certificate for anonymous read-only access to dbhub.io
ui->
comboUser
->
addItem
(
tr
(
"
Public
"
),
"
:/user_certs/public.cert.pem
"
);
}
void
RemoteDock::setNewIdentity
()
{
//
Get identity
QString identity = ui->
comboUser
->
currentText
();
if
(identity.
isEmpty
())
return
;
//
Get certificate file name
QString cert = ui->
comboUser
->
itemData
(ui->
comboUser
->
findText
(identity), Qt::UserRole).
toString
();
if
(cert.
isEmpty
())
return
;
//
Open root directory. Get host name from client cert
QString host = remoteDatabase.
getInfoFromClientCert
(cert, RemoteDatabase::CertInfoServer);
remoteModel->
setNewRootDir
(
QString
(
"
https://%1:5550/
"
).
arg
(host), cert);
//
Enable buttons if necessary
enableButtons
();
}
void
RemoteDock::fetchDatabase
(
const
QModelIndex& idx)
{
if
(!idx.
isValid
())
return
;
//
Get item
const
RemoteModelItem* item = remoteModel->
modelIndexToItem
(idx);
//
Only open database file
if
(item->
value
(RemoteModelColumnType).
toString
() ==
"
database
"
)
remoteDatabase.
fetch
(item->
value
(RemoteModelColumnUrl).
toString
(), RemoteDatabase::RequestTypeDatabase, remoteModel->
currentClientCertificate
());
}
void
RemoteDock::enableButtons
()
{
bool
db_opened = mainWindow->
getDb
().
isOpen
();
bool
logged_in = !remoteModel->
currentClientCertificate
().
isEmpty
();
ui->
buttonPushDatabase
->
setEnabled
(db_opened && logged_in);
}
void
RemoteDock::pushDatabase
()
{
//
If the currently active identity is the read-only public access to dbhub.io, don't show the Push Database dialog because it won't work anyway.
//
Instead switch to an explanation offering some advice to create and import a proper certificate.
if
(remoteModel->
currentClientCertificate
() ==
"
:/user_certs/public.cert.pem
"
)
{
ui->
stack
->
setCurrentIndex
(
1
);
return
;
}
//
The default suggestion for a database name is the local file name. If it is a remote file (like when it initially was fetched using DB4S),
//
the extra bit of information at the end of the name gets removed first.
QString name =
QFileInfo
(mainWindow->
getDb
().
currentFile
()).
fileName
();
name = name.
remove
(
QRegExp
(
"
_[0-9]+.remotedb$
"
));
//
Show the user a dialog for setting all the commit details
QString host =
QString
(
"
https://%1:5550/
"
).
arg
(remoteDatabase.
getInfoFromClientCert
(remoteModel->
currentClientCertificate
(), RemoteDatabase::CertInfoServer));
RemotePushDialog
pushDialog
(
this
, remoteDatabase, host, remoteModel->
currentClientCertificate
(), name);
if
(pushDialog.
exec
() != QDialog::Accepted)
return
;
//
Build push URL
QString url = host;
url.
append
(remoteDatabase.
getInfoFromClientCert
(remoteModel->
currentClientCertificate
(), RemoteDatabase::CertInfoUser));
url.
append
(
"
/
"
);
url.
append
(pushDialog.
name
());
//
Push database
remoteDatabase.
push
(mainWindow->
getDb
().
currentFile
(), url, remoteModel->
currentClientCertificate
(), pushDialog.
name
(),
pushDialog.
commitMessage
(), pushDialog.
licence
(), pushDialog.
isPublic
(), pushDialog.
branch
(), pushDialog.
forcePush
());
}
void
RemoteDock::newDirectoryNode
(
const
QModelIndex& parent)
{
//
Was this a new root dir?
if
(!parent.
isValid
())
{
//
Then check if there is a directory with the current user name
//
Get current user name
QString user = remoteDatabase.
getInfoFromClientCert
(remoteModel->
currentClientCertificate
(), RemoteDatabase::CertInfoUser);
for
(
int
i=
0
;i<remoteModel->
rowCount
(parent);i++)
{
QModelIndex child = remoteModel->
index
(i, RemoteModelColumnName, parent);
if
(child.
data
().
toString
() == user)
ui->
treeStructure
->
expand
(child);
}
}
}
void
RemoteDock::reject
()
{
//
We override this, to ensure the Escape key doesn't make this dialog
//
dock go away
return
;
}
void
RemoteDock::switchToMainView
()
{
ui->
stack
->
setCurrentIndex
(
0
);
}
You can’t perform that action at this time.