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
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>CQRLOG - SQL console</title>
</head>
<body>
<table border="0" cellpadding="5" cellspacing="2" width="100%">
<tbody>
<tr>
<td valign="top"><img src="img/exc.png"></td>
<td bgcolor=ffffcc valign="top" align="justify"><strong>
<font color="red">WARNING!</font></strong>
Backup your data often! BACKUP your log directory at the end of EVERY session!
All that you need to backup and store in a safe place is the log database directory
located in the ~/.config/cqrlog/database folder, or you can enable the autobackup function
in Preferences. This autobackup function creates an ADIF file with a backup of your log.
</td>
</tr>
</tbody>
</table>
<table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="2">
<tbody>
<tr>
<td width="33%" align="center">[<a href="index.html" target="_top">Menu</a>]</td>
</tr>
</tbody>
</table>
<br>
<div style="text-align: left;"><strong>CQRLOG for LINUX by OK2CQR & OK1RR</strong></div>
<p align=center><img src=img/line.png></p>
<h2><strong>SQL Console</strong></h2>
<div style="text-align: justify;">To enter the SQL Console, go to QSO list (Ctrl-O)
and in the upper menu bar go to <em>Filter -> SQL console.</em>
<div align="left">
<table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="2">
<tbody>
<tr>
<td width="50%" align="left"><img src=img/h114.png border="0"></td>
</tr>
<tr>
<td width="50%" align="left"><img src=img/h115.png border="0"></td>
</tr>
</tbody>
</table>
<br>
The icons in the upper menu allow the following actions:<br><br>
<strong>1st icon</strong>
Execute SQL statement<br>
<strong>2nd icon</strong>
Previous SQL command<br>
<strong>3rd icon</strong>
Next SQL command<br>
<strong>4th icon</strong>
Load SQL command from a file<br>
<strong>5th icon</strong>
Save SQL command to a file<br>
<strong>6th icon</strong>
Export data to a csv or html file<br>
<strong>7th icon</strong>
Get SQL command currently used in the main database. For example,
if a filter is set, clicking this icon allows you to edit the SQL command created
by the filter.<br><br>
<h3><strong>Tables in cqrlogXXX:</strong></h3><br>
where XXX is numer of the log e.g. cqrlog001 for the first log.<br><br>
<strong>cqrlog_main</strong><br>
the main table with all QSO records<br><br>
<strong>notes</strong><br>
table containing the call sign related notes<br><br>
<strong>profiles</strong><br>
list of QTH profiles<br><br>
<strong>db_version</strong><br>
database version<br><br>
<strong>award1 ... award5</strong><br>
external tables used for memberships<br><br>
<strong>zipcode1 ... zipcode3</strong><br>
external tables used for zip codes<br><br>
<strong>long_note</strong><br>
a long note valid for the whole log<br><br>
<strong>cqrlog_config</strong><br>
configuration file<br><br>
<strong>dxcc_id</strong><br>
a list of DXCC countries<br><br>
<strong>log_changes</strong><br>
a list of changes made to cqrlog_main database filled by
triggers (only when log upload function is enabled)<br><br>
<strong>upload_status</strong><br>
last IDs of uploaded QSO to online logs<br><br>
<strong>call_alert</strong>
list of callsigns with mode and band for dxcluster alert function<br><br>
<strong>freqmem</strong>
list of memories for fast frequency switching<br><br>
<strong>view_cqrlog_main_by_callsign</strong><br>
a view to show QSO sorted by callsign<br><br>
<strong>view_cqrlog_main_by_qsodate</strong><br>
a view to show QSO sorted by qsodate<br><br>
<h3><strong>Tables in cqrlog_common:</strong></h3><br>
The common database used by all logs. <br>
<strong>bands</strong><br>
band limits (lower/upper end)<br><br>
<strong>db_version</strong><br>
database version<br><br>
<strong>bandcn</strong><br>
info if the country is worked and confirmed by a paper QSL or via LoTW<br><br>
<strong>dxcc_ref</strong><br>
the current DXCC reference table<br><br>
<strong>dxclusters</strong><br>
list of DX cluster nodes<br><br>
<strong>iota_list</strong><br>
IOTA reference list<br><br>
<strong>log_list</strong><br>
list of logs created in cqrlog<br><br>
<strong>qslmngr</strong><br>
list of QSL managers<br><br>
</div>
<strong>Example:</strong><br><br>
<div align="justify">Select from the database date, call sign, frequency and mode,
where the QSO date is from timespan between Jan. 1. 2009 and Dec. 31. 2009 and the WAZ
zone is 15.<br><br>
<strong>SQL command:</strong><br>
<pre>
SELECT qsodate, callsign, freq, mode FROM view_cqrlog_main_by_qsodate WHERE
qsodate >= '2009-01-01' and qsodate <= '2009-31-12' and waz = 15
</pre>
<br>
The databases structures are listed <a href=sql_console.html><strong>here</strong>.</a></div>
</div>
<p align=center><img src=img/line.png></p><br>
<table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="2">
<tbody>
<tr>
<td width="33%" align="center">[<a href="index.html" target="_top">Menu</a>]</td>
</tr>
</tbody>
</table>
<br>
</body>
</html>
|
