# py-sailboat

**Repository Path**: fun-study/py-sailboat

## Basic Information

- **Project Name**: py-sailboat
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-03-19
- **Last Updated**: 2025-09-20

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

```sql
CREATE STABLE mobile.compute_data_v2(
  ts TIMESTAMP,
  longitude NCHAR ( 20 ),
  latitude NCHAR ( 20 ),
  heading_t NCHAR( 6 ),
  heading_m NCHAR( 6 ),
  sail_status NCHAR ( 4 ),
  leeway NCHAR ( 4 ),
  speed NCHAR( 14 ),
  standard_speed NCHAR( 14 ),
  custom_standard_speed NCHAR( 14 ),
  angle NCHAR( 4 ),
  vmg NCHAR( 14 ),
  standard_vmg NCHAR( 14 ),
  custom_angle NCHAR( 4 ),
  custom_vmg NCHAR( 14 ),
  custom_standard_vmg NCHAR( 14 ),
  wind_source_boat_code NCHAR ( 2 ),
  wind_speed NCHAR( 14 ),
  wind_direction NCHAR( 4 ),
  custom_wind_speed NCHAR( 14 ),
  custom_wind_direction NCHAR( 4 ),
  yaw NCHAR( 4 ),
  pitch NCHAR( 4 ),
  rol NCHAR(4),
  posture NCHAR ( 4 ),
  pitchPosture NCHAR ( 4 ),
  hr NCHAR( 20 )
) 
TAGS(tenant_code NCHAR ( 32 ), level_id NCHAR ( 32 ), m_hm_id NCHAR ( 32 ))
```

```shell
# 获取超级表中所有子表的标签信息
SHOW TABLE TAGS FROM mobile.compute_data;
# 获取超级表中所有子表信息
SELECT DISTINCT TBNAME FROM mobile.compute_data;

# 增加列
ALTER STABLE mobile.compute_data ADD COLUMN heading_m NCHAR(4);
# 修改列宽
ALTER STABLE mobile.compute_data MODIFY COLUMN heading_m NCHAR(6);
# 删除列
ALTER STABLE mobile.compute_data DROP COLUMN heading_m;
```

```shell
# 废弃
# mobile/up/heading/1188/1798629937202163714/1787386044490051586

# 开窗计算-航向数据
{
    "mHmId": "1787386044490051586",
    "ts": "2025-03-05 15:39:21",
    "data": {
        "headingT": 90,
        "headingM": 93,
        "leeway": "+15",
        "sailStatus": "D_P",
        "tt": "c"
    }
}

# mobile/up/yaw/1188/1798629937202163714/1787386044490051586

#开窗计算-船首向数据
{
    "mHmId": "1787386044490051586",
    "ts": "2025-03-05 15:49:00",
    "data": {
        "yaw": 0,
        "leeway": "+17",
        "sailStatus": "D_S",
        "tt": "t"
    }
}

# mobile/up/rol/1188/1798629937202163714/1787386044490051586

#开窗计算-平衡数据
{
  "data": {
    "posture": "平衡",
    "rol": 0,
    "sailStatus": "U_P",
    "tt": "c"
  },
  "mHmId": "1787386044490051586",
  "ts": "2025-02-13 08:41:18"
}

# mobile/up/heartrate/0/1188/1798629937202163714/1787386044490051586
#开窗计算-心率数据
{
  "data": {
    "hr": 109,
    "hrType": "0",
    "tt": "c"
  },
  "mHmId": "1787386044490051586",
  "ts": "2025-02-13 08:38:44"
}
# mobile/up/heartrate/1/1188/1798629937202163714/1787386044490051586

{
  "data": {
    "hr": 109,
    "hrType": "1",
    "tt": "c"
  },
  "mHmId": "1787386044490051586",
  "ts": "2025-02-13 08:38:44"
}

# mobile/up/speed-vmg-wind/1188/1798629937202163714/1787386044490051586

#开窗计算-船速+VMG+风数据
{
  "data": {
    "angle": 6,
    "customAngle": 50,
    "customStandardSpeed": 230.4512,
    "customStandardVmg": 181.5832,
    "customVmg": 2.1855,
    "customWindDirection": 100,
    "customWindSpeed": 514.44,
    "speed": 3.4,
    "standardSpeed": 237.1384,
    "standardVmg": 187.2416,
    "tt": "c",
    "vmg": 3.3814,
    "windDirection": 56,
    "windSourceBoatCode": "1",
    "windSpeed": 955.2139
  },
  "mHmId": "1787386044490051586",
  "ts": "2025-02-13 08:43:08"
}
```

```bash
pyinstaller.exe -i sailboat.ico -n sailboat -F main.py
```

```bash
uv pip install -e .
uv pip install .
```