localhorst/LocationHub
SHA256
1
0
Fork 0
Code Issues 2 Pull Requests 1 Actions Packages Projects Releases Wiki Activity

add TTN Gateway based location to DB model

Browse Source
This commit is contained in:
Hendrik Schutter
2024-12-31 14:00:32 +01:00
parent 393eab2b45
commit c27763fc11
2 changed files with 12 additions and 0 deletions
Download Patch File Download Diff File Expand all files Collapse all files

2
server/sql/tables.sql
View File

@ -46,6 +46,8 @@ CREATE TABLE IF NOT EXISTS location (
wifi_longitude DOUBLE,
gnss_latitude DOUBLE,
gnss_longitude DOUBLE,
ttn_gw_latitude DOUBLE,
ttn_gw_longitude DOUBLE,
created_at_utc TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at_utc TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
FOREIGN KEY (lp_ttn_end_device_uplinks_id) REFERENCES lp_ttn_end_device_uplinks(lp_ttn_end_device_uplinks_id)

10
server/src/models/location.ts
View File

@ -8,6 +8,8 @@ export class Location extends Model {
public wifi_longitude!: number;
public gnss_latitude!: number;
public gnss_longitude!: number;
public ttn_gw_latitude!: number;
public ttn_gw_longitude!: number;
public created_at_utc!: Date;
public updated_at_utc!: Date;
}
@ -40,6 +42,14 @@ Location.init(
type: DataTypes.NUMBER,
allowNull: true,
},
ttn_gw_latitude: {
type: DataTypes.NUMBER,
allowNull: true,
},
ttn_gw__longitude: {
type: DataTypes.NUMBER,
allowNull: true,
},
created_at_utc: {
type: DataTypes.DATE,
defaultValue: DataTypes.NOW,