Add frames.phg_rate field #46

Open
opened 2023-12-14 09:01:51 -06:00 by W1CDN · 0 comments
Owner
2023-12-14 09:00:28,648 - K0RQ-1>APDW16,KB0UGF-3,WIDE1,WIDE2-1:}KD0IOE>APRX29,TCPIP,K0RQ-1*:;KD0IOE-R *111111z4651.16N/09652.75WrPHG41504/444.625MHz +5 CC1 https://kd0ioe.com/repeater
2023-12-14 09:00:28,649 - Parsing: K0RQ-1>APDW16,KB0UGF-3,WIDE1,WIDE2-1:}KD0IOE>APRX29,TCPIP,K0RQ-1*:;KD0IOE-R *111111z4651.16N/09652.75WrPHG41504/444.625MHz +5 CC1 https://kd0ioe.com/repeater
2023-12-14 09:00:28,651 - Packet is third-party
2023-12-14 09:00:28,652 - Parsing: KD0IOE>APRX29,TCPIP,K0RQ-1*:;KD0IOE-R *111111z4651.16N/09652.75WrPHG41504/444.625MHz +5 CC1 https://kd0ioe.com/repeater
2023-12-14 09:00:28,653 - Attempting to parse object report format
2023-12-14 09:00:28,655 - Parsed as normal position report
2023-12-14 09:00:28,656 - Parsed ok.
2023-12-14 09:00:28,656 - Parsed ok.
2023-12-14 09:00:28,660 - "raw", "from", "to", "path", "via", "format", "subpacket", "station_call", "station_lat", "station_lon", "created_unix", "party"
2023-12-14 09:00:28,662 - dict_values(['K0RQ-1>APDW16,KB0UGF-3,WIDE1,WIDE2-1:}KD0IOE>APRX29,TCPIP,K0RQ-1*:;KD0IOE-R *111111z4651.16N/09652.75WrPHG41504/444.625MHz +5 CC1 https://kd0ioe.com/repeater', 'K0RQ-1', 'APDW16', "['KB0UGF-3', 'WIDE1', 'WIDE2-1']", '', 'thirdparty', "{'raw': 'KD0IOE>APRX29,TCPIP,K0RQ-1*:;KD0IOE-R *111111z4651.16N/09652.75WrPHG41504/444.625MHz +5 CC1 https://kd0ioe.com/repeater', 'from': 'KD0IOE', 'to': 'APRX29', 'path': ['TCPIP', 'K0RQ-1*'], 'via': '', 'object_name': 'KD0IOE-R ', 'alive': True, 'raw_timestamp': '111111z', 'timestamp': 1702293060, 'format': 'object', 'posambiguity': 0, 'symbol': 'r', 'symbol_table': '/', 'latitude': 46.852666666666664, 'longitude': -96.87916666666666, 'phg': '41504', 'phg_power': 16, 'phg_height': 6.096, 'phg_gain': 3.1622776601683795, 'phg_dir': 'omni', 'phg_range': 12.836608564895092, 'phg_rate': 4, 'comment': '444.625MHz +5 CC1 https://kd0ioe.com/repeater', 'object_format': 'uncompressed'}", 'W1CDN-1', '47.941500', '-97.027000', 1702566028, 1])
2023-12-14 09:00:28,664 - "raw", "from", "to", "path", "via", "object_name", "alive", "raw_timestamp", "timestamp", "format", "posambiguity", "symbol", "symbol_table", "latitude", "longitude", "phg", "phg_power", "phg_height", "phg_gain", "phg_dir", "phg_range", "phg_rate", "comment", "object_format", "party", "header_raw", "station_call", "station_lat", "station_lon", "created_unix"
2023-12-14 09:00:28,665 - dict_values(['KD0IOE>APRX29,TCPIP,K0RQ-1*:;KD0IOE-R *111111z4651.16N/09652.75WrPHG41504/444.625MHz +5 CC1 https://kd0ioe.com/repeater', 'KD0IOE', 'APRX29', "['TCPIP', 'K0RQ-1*']", '', 'KD0IOE-R ', True, '111111z', 1702293060, 'object', 0, 'r', '/', 46.852666666666664, -96.87916666666666, '41504', 16, 6.096, 3.1622776601683795, 'omni', 12.836608564895092, 4, '444.625MHz +5 CC1 https://kd0ioe.com/repeater', 'uncompressed', 3, 'K0RQ-1>APDW16,KB0UGF-3,WIDE1,WIDE2-1:', 'W1CDN-1', '47.941500', '-97.027000', 1702566028])
2023-12-14 09:00:28,667 - Inserting into database
2023-12-14 09:00:28,673 - Error with SQLite!
Traceback (most recent call last):
  File "kiss_and_db.py", line 117, in main
    conn.execute(b_sql, list(b.values()))
sqlite3.OperationalError: table frames has no column named phg_rate
``` 2023-12-14 09:00:28,648 - K0RQ-1>APDW16,KB0UGF-3,WIDE1,WIDE2-1:}KD0IOE>APRX29,TCPIP,K0RQ-1*:;KD0IOE-R *111111z4651.16N/09652.75WrPHG41504/444.625MHz +5 CC1 https://kd0ioe.com/repeater 2023-12-14 09:00:28,649 - Parsing: K0RQ-1>APDW16,KB0UGF-3,WIDE1,WIDE2-1:}KD0IOE>APRX29,TCPIP,K0RQ-1*:;KD0IOE-R *111111z4651.16N/09652.75WrPHG41504/444.625MHz +5 CC1 https://kd0ioe.com/repeater 2023-12-14 09:00:28,651 - Packet is third-party 2023-12-14 09:00:28,652 - Parsing: KD0IOE>APRX29,TCPIP,K0RQ-1*:;KD0IOE-R *111111z4651.16N/09652.75WrPHG41504/444.625MHz +5 CC1 https://kd0ioe.com/repeater 2023-12-14 09:00:28,653 - Attempting to parse object report format 2023-12-14 09:00:28,655 - Parsed as normal position report 2023-12-14 09:00:28,656 - Parsed ok. 2023-12-14 09:00:28,656 - Parsed ok. 2023-12-14 09:00:28,660 - "raw", "from", "to", "path", "via", "format", "subpacket", "station_call", "station_lat", "station_lon", "created_unix", "party" 2023-12-14 09:00:28,662 - dict_values(['K0RQ-1>APDW16,KB0UGF-3,WIDE1,WIDE2-1:}KD0IOE>APRX29,TCPIP,K0RQ-1*:;KD0IOE-R *111111z4651.16N/09652.75WrPHG41504/444.625MHz +5 CC1 https://kd0ioe.com/repeater', 'K0RQ-1', 'APDW16', "['KB0UGF-3', 'WIDE1', 'WIDE2-1']", '', 'thirdparty', "{'raw': 'KD0IOE>APRX29,TCPIP,K0RQ-1*:;KD0IOE-R *111111z4651.16N/09652.75WrPHG41504/444.625MHz +5 CC1 https://kd0ioe.com/repeater', 'from': 'KD0IOE', 'to': 'APRX29', 'path': ['TCPIP', 'K0RQ-1*'], 'via': '', 'object_name': 'KD0IOE-R ', 'alive': True, 'raw_timestamp': '111111z', 'timestamp': 1702293060, 'format': 'object', 'posambiguity': 0, 'symbol': 'r', 'symbol_table': '/', 'latitude': 46.852666666666664, 'longitude': -96.87916666666666, 'phg': '41504', 'phg_power': 16, 'phg_height': 6.096, 'phg_gain': 3.1622776601683795, 'phg_dir': 'omni', 'phg_range': 12.836608564895092, 'phg_rate': 4, 'comment': '444.625MHz +5 CC1 https://kd0ioe.com/repeater', 'object_format': 'uncompressed'}", 'W1CDN-1', '47.941500', '-97.027000', 1702566028, 1]) 2023-12-14 09:00:28,664 - "raw", "from", "to", "path", "via", "object_name", "alive", "raw_timestamp", "timestamp", "format", "posambiguity", "symbol", "symbol_table", "latitude", "longitude", "phg", "phg_power", "phg_height", "phg_gain", "phg_dir", "phg_range", "phg_rate", "comment", "object_format", "party", "header_raw", "station_call", "station_lat", "station_lon", "created_unix" 2023-12-14 09:00:28,665 - dict_values(['KD0IOE>APRX29,TCPIP,K0RQ-1*:;KD0IOE-R *111111z4651.16N/09652.75WrPHG41504/444.625MHz +5 CC1 https://kd0ioe.com/repeater', 'KD0IOE', 'APRX29', "['TCPIP', 'K0RQ-1*']", '', 'KD0IOE-R ', True, '111111z', 1702293060, 'object', 0, 'r', '/', 46.852666666666664, -96.87916666666666, '41504', 16, 6.096, 3.1622776601683795, 'omni', 12.836608564895092, 4, '444.625MHz +5 CC1 https://kd0ioe.com/repeater', 'uncompressed', 3, 'K0RQ-1>APDW16,KB0UGF-3,WIDE1,WIDE2-1:', 'W1CDN-1', '47.941500', '-97.027000', 1702566028]) 2023-12-14 09:00:28,667 - Inserting into database 2023-12-14 09:00:28,673 - Error with SQLite! Traceback (most recent call last): File "kiss_and_db.py", line 117, in main conn.execute(b_sql, list(b.values())) sqlite3.OperationalError: table frames has no column named phg_rate ```
Sign in to join this conversation.
No Milestone
No project
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: W1CDN/aprs_tool#46
No description provided.