Add future winds and allow use in Plan

[apps4av]

[no-lex]

Does this mean future winds aloft forecasts, or some other wind product? I intend to extend winds-aloft to cover other time brackets at some point.

[apps4av]

Yes, I started making modifications for the database. But if you want to take it that's fine. Need to add a 'fore' column and parse for +12 and +24. However because of unique parameters upgrade of same database is not possible?

…

On Sun, Jan 5, 2025, 3:39 PM Alex Foster ***@***.***> wrote: Does this mean future winds aloft forecasts, or some other wind product? I intend to extend winds-aloft to cover other time brackets at some point. — Reply to this email directly, view it on GitHub <#49 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAWPRTYSVJGCUQ3BDEB4JOL2JGKBHAVCNFSM6AAAAABUTMQJEOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDKNZRG42DINZUG4> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[no-lex]

I messed with the database scheme a bit to see if the high altitude (45 and 53k) observations could be added easily, and I ran into similar issues. Probably worth doing both changes at the same time. I can take a look after finishing my current PR #48, if it's proving to be a difficult problem.

I can extend the winds parsing and UI stuff pretty easily if that problem gets solved.

[apps4av]

Might have to do something like this, as modifying the existing table is not possible as it uses unique:

      onUpgrade: (Database db, int oldVersion, int newVersion) async {
        if (oldVersion == 1 && newVersion == 2) {
          await db.execute("create table windsAloft12 ("
              "id            integer primary key autoincrement, "
              "station       text, "
              "utcMs         int, "
              "w0k           text, "
              "w3k           text, "
              "w6k           text, "
              "w9k           text, "
              "w12k          text, "
              "w18k          text, "
              "w24k          text, "
              "w30k          text, "
              "w34k          text, "
              "w39k          text, "
              "unique(station) on conflict replace);");
          await db.execute("create table windsAloft24 ("
              "id            integer primary key autoincrement, "
              "station       text, "
              "utcMs         int, "
              "w0k           text, "
              "w3k           text, "
              "w6k           text, "
              "w9k           text, "
              "w12k          text, "
              "w18k          text, "
              "w24k          text, "
              "w30k          text, "
              "w34k          text, "
              "w39k          text, "
              "unique(station) on conflict replace);");
        }
      },
      onCreate: (Database db, int version) async {
        await db.execute("create table windsAloft ("
            "id            integer primary key autoincrement, "
            "station       text, "
            "utcMs         int, "
            "w0k           text, "
            "w3k           text, "
            "w6k           text, "
            "w9k           text, "
            "w12k          text, "
            "w18k          text, "
            "w24k          text, "
            "w30k          text, "
            "w34k          text, "
            "w39k          text, "
            "unique(station) on conflict replace);");
        await db.execute("create table windsAloft12 ("
            "id            integer primary key autoincrement, "
            "station       text, "
            "utcMs         int, "
            "w0k           text, "
            "w3k           text, "
            "w6k           text, "
            "w9k           text, "
            "w12k          text, "
            "w18k          text, "
            "w24k          text, "
            "w30k          text, "
            "w34k          text, "
            "w39k          text, "
            "unique(station) on conflict replace);");
        await db.execute("create table windsAloft24 ("
            "id            integer primary key autoincrement, "
            "station       text, "
            "utcMs         int, "
            "w0k           text, "
            "w3k           text, "
            "w6k           text, "
            "w9k           text, "
            "w12k          text, "
            "w18k          text, "
            "w24k          text, "
            "w30k          text, "
            "w34k          text, "
            "w39k          text, "
            "unique(station) on conflict replace);");

[no-lex]

Makes sense, I tried to add w45k and w53k entries to the original database and ran into backwards compatibility issues. It might be impracticable to implement, and I don't think the use case of the app includes flying above the tropopause anyways.