-
Notifications
You must be signed in to change notification settings - Fork 0
/
adif_log.py
57 lines (37 loc) · 1.42 KB
/
adif_log.py
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
import tempfile
import psycopg2
import psycopg2.extras
import adif
class StringWrapper:
def __init__(self):
self.string = ""
def write(self, string):
self.string += string
def produce_adif_log():
db = psycopg2.connect(dbname='ham_station')
cur = db.cursor(cursor_factory=psycopg2.extras.RealDictCursor)
cur.execute("""SELECT callsign as CALL, date as QSO_DATE, time as TIME_ON, band as FREQ, band as BAND, propmode as PROP_MODE,
tx as RST_SENT, rx as RST_RCVD,
locator as GRIDSQUARE,
txmode as MODE
FROM nac_log_new WHERE complete=True
ORDER BY date,time""")
rows = cur.fetchall()
qsos = [{k.upper(): v for k, v in record.items()} for record in rows]
print("Fetched %d qsos" % len(qsos))
adif_log = adif.ADIF()
filename = tempfile.NamedTemporaryFile()
adif_log.write(qsos, filename.name)
with open(filename.name,"r") as fd:
lines = fd.read().splitlines()
for line in lines:
print(line)
if __name__ == '__main__':
import logging
logger = logging.getLogger(__name__)
logger.setLevel("DEBUG")
hdlr = logging.StreamHandler()
hdlr.setFormatter(logging.Formatter('%(asctime)s %(levelname)8s %(filename)20s:%(lineno)-5s %(message)s'))
logger.addHandler(hdlr)
logger.info("Starting adif_log")
produce_adif_log()