def deleteLogs(): for i in range(0, 16): for j in range(0, 16): logpath = getLogPath(i, j) filelist = [ f for f in os.listdir(logpath) if f.endswith(".log") ] for f in filelist: os.remove(logpath+'/'+f) return
def checkDirs(): if not os.path.exists(u.LOGS_ROOT_DIR): os.mkdir(u.LOGS_ROOT_DIR) for i in range(0, 16): for j in range(0, 16): logpath = getLogPath(i, j) if not os.path.exists(logpath): os.mkdir(logpath) return
def main(): starttime = time.time() db = _mysql.connect('localhost', 'wtol', 'wtol', 'wtol') db.query('DELETE FROM qso') for i in range(0, 16): for j in range(0, 16): logpath = getLogPath(i, j) print 'scanning ' + logpath filelist = [ f for f in os.listdir(logpath) if f.endswith(".log") ] for filename in filelist: callsign = filename.split('.') callsign = callsign[0] for line in open(logpath + '/' + filename, 'r'): line = line.split('|') callsign_dx = line[0] qso_timestamp = line[1] qso_frequency = line[2] qso_mode = line[3] qso_timestamp_min = toTimeStamp(toUnixTime(qso_timestamp) - (60 * u.QSO_TIME_VARIANCE)) qso_timestamp_max = toTimeStamp(toUnixTime(qso_timestamp) + (60 * u.QSO_TIME_VARIANCE)) qso_frequency_min = str(int(qso_frequency) - u.QSO_FREQ_VARIANCE) qso_frequency_max = str(int(qso_frequency) + u.QSO_FREQ_VARIANCE) sql = "SELECT COUNT(callsign) AS tot FROM qso WHERE (callsign = '" + callsign_dx + "') AND (callsign_dx = '" + callsign + "') AND (datestart BETWEEN '" + qso_timestamp_min + "' AND '" + qso_timestamp_max + "') AND (frequency BETWEEN '" + qso_frequency_min + "' AND '" + qso_frequency_max + "') AND (mode = '" + qso_mode + "') AND (qsl = 0)" result = getQueryResult(db, sql) if result[0][0] == '0': qsl = '0' else: qsl = '1' sql = "UPDATE qso SET qsl = 1 WHERE (callsign = '" + callsign_dx + "') AND (callsign_dx = '" + callsign + "') AND (datestart BETWEEN '" + qso_timestamp_min + "' AND '" + qso_timestamp_max + "') AND (frequency BETWEEN '" + qso_frequency_min + "' AND '" + qso_frequency_max + "') AND (qsl = 0)" db.query(sql) sql = "INSERT INTO qso VALUES ('" + callsign + "', '" + callsign_dx + "', '" + qso_timestamp + "', '" + qso_frequency + "', '" + qso_mode + "', " + qsl + ")" try: db.query(sql) except: pass print 'Elapsed time: ' + str(time.time() - starttime) + ' seconds' return