jshrake / healthkit-to-sqlite Goto Github PK

[2023-08-12T04:25:38Z INFO  sqlx::query] INSERT INTO Workout (`workoutActivityType`, …; rows affected: 0, rows returned: 0, elapsed: 29.500µs

    INSERT INTO
      Workout (
        `workoutActivityType`,
        `duration`,
        `durationUnit`,
        `totalDistance`,
        `totalDistanceUnit`,
        `totalEnergyBurned`,
        `totalEnergyBurnedUnit`,
        `sourceName`,
        `sourceVersion`,
        `device`,
        `creationDate`,
        `startDate`,
        `endDate`,
        `metadata_HKIndoorWorkout`,
        `metadata_HKTimeZone`,
        `metadata_HKWeatherTemperature`,
        `metadata_HKWeatherHumidity`,
        `workoutEvents`,
        `workoutStatistics`,
        `geometry`
      )
    VALUES
      (
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?,
        ?
      )

Error: error returned from database: (code: 1) table Workout has no column named workoutStatistics

Caused by:
    (code: 1) table Workout has no column named workoutStatistics

CREATE TABLE `workout`
  (
     `creationdate`                         DATE,
     `device`                               TEXT,
     `duration`                             REAL,
     `durationunit`                         TEXT,
     `enddate`                              DATE,
     `geometry`                             JSON,
     `metadata_hkaveragemets`               TEXT,
     `metadata_hkelevationascended`         TEXT,
     `metadata_hkindoorworkout`             INTEGER,
     `metadata_hkmetadatakeysyncidentifier` TEXT,
     `metadata_hkmetadatakeysyncversion`    INTEGER,
     `metadata_hktimezone`                  TEXT,
     `metadata_hkweatherhumidity`           TEXT,
     `metadata_hkweathertemperature`        TEXT,
     `sourcename`                           TEXT,
     `sourceversion`                        TEXT,
     `startdate`                            DATE,
     `totaldistance`                        REAL,
     `totaldistanceunit`                    TEXT,
     `totalenergyburned`                    REAL,
     `totalenergyburnedunit`                TEXT,
     `workoutactivitytype`                  TEXT,
     `workoutevents`                        JSON
  );