{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'Package': "VARCHAR(255) NOT NULL DEFAULT ''", 'Bssid': 'VARCHAR(17)', 'Ssid': 'VARCHAR(255)', 'FrequencyGhz': 'DECIMAL(5,3) DEFAULT 0', 'Channel': 'INT DEFAULT 0', 'SignalDbm': 'INT DEFAULT 0', 'Quality': 'INT DEFAULT 0', 'QualityMax': 'INT DEFAULT 70', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'Module': 'VARCHAR(255)'}
{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'Package': "VARCHAR(255) NOT NULL DEFAULT ''", 'Address': 'VARCHAR(17)', 'Name': 'VARCHAR(255)', 'RssiDbm': 'INT', 'KnownLabel': 'VARCHAR(128)', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'Module': 'VARCHAR(255)'}
INSERT INTO data_wireless_wifi
(Guid, Package, Bssid, Ssid,
FrequencyGhz, Channel, SignalDbm,
Quality, QualityMax, Module)
VALUES
('{guid}', '{package}', '{bssid}', '{ssid}',
{frequency_ghz}, {channel}, {signal_dbm},
{quality}, {quality_max},
'ObjServiceWireless')
INSERT INTO data_wireless_bt
(Guid, Package, Address, Name,
RssiDbm, KnownLabel, Module)
VALUES
('{guid}', '{package}', '{address}', '{name}',
{rssi_dbm}, '{known_label}',
'ObjServiceWireless')
SELECT Bssid, Ssid, FrequencyGhz, Channel,
SignalDbm, Quality, QualityMax, CreateTime
FROM data_wireless_wifi WHERE Package = '{package}' ORDER BY CreateTime DESC LIMIT {limit}
SELECT Address, Name, RssiDbm, KnownLabel, CreateTime FROM data_wireless_bt WHERE Package = '{package}'
AND CreateTime >= NOW() - INTERVAL 15 MINUTE
ORDER BY CreateTime DESC
SELECT Ssid, Bssid,
AVG(SignalDbm) AS AvgDbm,
MIN(SignalDbm) AS MinDbm,
MAX(SignalDbm) AS MaxDbm,
COUNT(*) AS Samples,
DATE(CreateTime) AS Day
FROM data_wireless_wifi WHERE Package = '{package}'
AND CreateTime >= '{since}'
GROUP BY Ssid, Bssid, DATE(CreateTime) ORDER BY Day DESC, AvgDbm DESC
SELECT Address, Name, KnownLabel,
MAX(CreateTime) AS LastSeen,
COUNT(*) AS Sightings
FROM data_wireless_bt WHERE Package = '{package}'
AND CreateTime >= '{since}'
GROUP BY Address, Name, KnownLabel ORDER BY LastSeen DESC