lonjil/derploader - Change J3DFWD2RVW3Q7GRKBVGE6FZR7JN5FKH33ECU4HH3PCZLOVJHBUEQC

Stuff.

Created by Lonnie on December 1, 2021

J3DFWD2RVW3Q7GRKBVGE6FZR7JN5FKH33ECU4HH3PCZLOVJHBUEQC

Dependencies

In channels

main

Change contents

Insertion in build.zig at line 4 [3.57]

[3.123]

fn blah(val: anytype, val2: anytype) bool {
    return val != null and val.? == val2;
}

Replacement in build.zig at line 36 [3.57]
B:BD[3.956] → [3.956:976]
```
    exe.linkLibC();
```
[3.956]
[2.1]
```
    //exe.linkLibC();
```

Replacement in build.zig at line 38 [3.57]

∅:D[2.33] → [3.976:1014]

B:BD[3.976] → [3.976:1014]

    exe.linkSystemLibrary("libcurl");

[2.33]

[3.1014]

    if (blah(static, true)) {
        exe.addIncludeDir("/usr/include/");
        exe.addObjectFile("/usr/lib/libcurl.a");
        exe.addObjectFile("/usr/lib/libssl.a");
        exe.addObjectFile("/usr/lib/libcrypto.a");
        exe.addObjectFile("/usr/lib/libnghttp2.a");
        exe.addObjectFile("/usr/lib/libbrotlicommon.a");
        exe.addObjectFile("/usr/lib/libbrotlidec.a");
        exe.addObjectFile("/usr/lib/libbrotlienc.a");
        exe.addObjectFile("/lib/libz.a");
    } else {
        exe.linkSystemLibrary("libcurl");
    }

Deletion in src/main.zig at line 8 [3.1454]

B:BD[4.3] → [4.3:71]

const zfetch = @import("zfetch");
const tls = @import("iguanaTLS");

Deletion in src/main.zig at line 106 [3.1454]

B:BD[3.4059] → [3.4059:4129]


    //const key = try std.process.getEnvVarOwned(alloc, "derpikey");

Replacement in src/main.zig at line 134 [3.1454]

B:BD[3.4857] → [4.1456:1541]

    db.exec(create, .{}, .{}) catch sqliteErrorReport("Couldn't create table", &db);

[3.4857]

[3.4937]

    db.exec(create, .{}, .{ 0, 0, 0 }) catch sqliteErrorReport("Couldn't create table", &db);

Replacement in src/main.zig at line 435 [3.1454]

B:BD[4.10882] → [2.2287:2336]

        "SELECT true FROM image WHERE eid = ?;",

[4.10882]

[4.10930]

        "SELECT true FROM image WHERE id = ?;",

Replacement in src/main.zig at line 437 [3.1454]
B:BD[4.10943] → [2.2337:2361]
```
        .{ .eid = id },
```
[4.10943]
[4.10966]
```
        .{ .id = id },
```
Replacement in src/main.zig at line 450 [3.1454]
B:BD[4.11337] → [2.2362:2391]
```
        \\  INTO image (eid)
```
[4.11337]
[4.11365]
```
        \\  INTO image (id)
```

Replacement in src/main.zig at line 471 [3.1454]

B:BD[4.11852] → [2.2392:2466]

        "SELECT true FROM image WHERE eid = ? AND metadata IS NOT NULL;",

[4.11852]

[4.11925]

        "SELECT true FROM image WHERE id = ? AND metadata IS NOT NULL;",

Replacement in src/main.zig at line 473 [3.1454]
B:BD[4.11938] → [2.2467:2491]
```
        .{ .eid = id },
```
[4.11938]
[4.11961]
```
        .{ .id = id },
```

Replacement in src/main.zig at line 490 [3.1454]

B:BD[4.12469] → [2.2492:2532]

            \\    image (eid, metadata)

[4.12469]

[4.12508]

            \\    image (id, metadata)

Replacement in src/main.zig at line 492 [3.1454]
B:BD[4.12540] → [2.2533:2567]
```
            \\  ON CONFLICT (eid)
```
[4.12540]
[4.12573]
```
            \\  ON CONFLICT (id)
```

Replacement in src/main.zig at line 495 [3.1454]

B:BD[4.12651] → [2.2568:2629]

        , .{}, .{ .eid = id, .metadata = metadata }) catch {

[4.12651]

[4.12711]

        , .{}, .{ .id = id, .metadata = metadata }) catch {

Replacement in src/main.zig at line 504 [3.1454]

B:BD[4.13014] → [2.2630:2702]

            "UPDATE OR ROLLBACK image SET hash_meta = ? WHERE eid = ?",

[4.13014]

[3.7417]

            "UPDATE OR ROLLBACK image SET hash_meta = ? WHERE id = ?",

Replacement in src/main.zig at line 527 [3.1454]

B:BD[4.13599] → [2.2703:2777]

        "SELECT true FROM image WHERE eid = ? AND metadata IS NOT NULL;",

[4.13599]

[4.13672]

        "SELECT true FROM image WHERE id = ? AND metadata IS NOT NULL;",

Replacement in src/main.zig at line 529 [3.1454]
B:BD[4.13685] → [2.2778:2802]
```
        .{ .eid = id },
```
[4.13685]
[4.13708]
```
        .{ .id = id },
```

Replacement in src/main.zig at line 555 [3.1454]

B:BD[4.14470] → [2.2832:2872]

            \\    image (eid, metadata)

[4.14470]

[4.14509]

            \\    image (id, metadata)

Replacement in src/main.zig at line 557 [3.1454]
B:BD[4.14541] → [2.2873:2907]
```
            \\  ON CONFLICT (eid)
```
[4.14541]
[4.14574]
```
            \\  ON CONFLICT (id)
```

Replacement in src/main.zig at line 560 [3.1454]

B:BD[4.14652] → [2.2908:2971]

        , .{}, .{ .eid = id, .metadata = resp.items }) catch {

[4.14652]

[4.14714]

        , .{}, .{ .id = id, .metadata = resp.items }) catch {

Replacement in src/main.zig at line 569 [3.1454]

B:BD[4.15009] → [2.2972:3044]

            "UPDATE OR ROLLBACK image SET hash_meta = ? WHERE eid = ?",

[4.15009]

[5.2790]

            "UPDATE OR ROLLBACK image SET hash_meta = ? WHERE id = ?",

Replacement in src/main.zig at line 600 [3.1454]

B:BD[4.15826] → [2.3045:3108]

        "SELECT full_url, thumb_url FROM image WHERE eid = ?",

[4.15826]

[4.15888]

        "SELECT full_url, thumb_url FROM image WHERE id = ?",

Replacement in src/main.zig at line 602 [3.1454]
B:BD[4.15901] → [2.3109:3133]
```
        .{ .eid = id },
```
[4.15901]
[4.15924]
```
        .{ .id = id },
```

Replacement in src/main.zig at line 612 [3.1454]

B:BD[4.16225] → [2.3134:3194]

                \\  WHERE eid = ? AND image_id IS NOT NULL;

[4.16225]

[4.16281]

                \\  WHERE id = ? AND image IS NOT NULL;

Deletion in src/main.zig at line 620 [3.1454]

B:BD[4.16599] → [2.3195:3379]

            }
            defer {
                resp.clearRetainingCapacity();
                std.mem.set(u8, hash_buf[0..], 0);
                std.mem.set(u8, hash_buf2[0..], 0);

Insertion in src/main.zig at line 625 [3.1454]

[4.17274]

            try db.exec("BEGIN IMMEDIATE;", .{}, .{});
            errdefer db.exec("ROLLBACK;", .{}, .{}) catch {};
            db.exec(
                "UPDATE OR ROLLBACK image SET image = ? WHERE id = ?",
                .{},
                .{
                    .image = resp.items,
                    .id = id,
                },
            ) catch {
                sqliteErrorReport("Couldn't add image to DB.", db);
                return error.GO_ON;
            };

Deletion in src/main.zig at line 642 [3.1454]

B:BD[4.17448] → [2.3380:3658]

            try db.exec("BEGIN IMMEDIATE;", .{}, .{});
            errdefer db.exec("ROLLBACK;", .{}, .{}) catch {};
            try db.exec(
                \\INSERT INTO blob (data, hash)
                \\  VALUES (?, ?);
            , .{}, .{ resp.items, hash_buf2[0..] });

Replacement in src/main.zig at line 643 [3.1454]

B:BD[4.17469] → [2.3659:3785]

                \\UPDATE OR ROLLBACK image
                \\  SET image_id = last_insert_rowid() WHERE eid = ?
            ,

[4.17469]

[4.17544]

                "UPDATE OR ROLLBACK image SET hash_full = ? WHERE id = ?",

Replacement in src/main.zig at line 645 [3.1454]
B:BD[4.17565] → [2.3786:3809]
```
                .{id},
```
[4.17565]
[4.17606]
```
                .{ hash_buf2[0..], id },
```

Replacement in src/main.zig at line 647 [3.1454]

B:BD[4.17628] → [2.3810:3878]

                sqliteErrorReport("Couldn't add image to DB.", db);

[4.17628]

[4.17694]

                sqliteErrorReport("Couldn't set iamge hash", db);

Insertion in src/main.zig at line 654 [3.1454]

[4.17918]

[4.18056]

            resp.clearRetainingCapacity();
            std.mem.set(u8, hash_buf[0..], 0);
            std.mem.set(u8, hash_buf2[0..], 0);

Replacement in src/main.zig at line 662 [3.1454]

B:BD[4.18223] → [2.3879:3939]

                \\  WHERE eid = ? AND thumb_id IS NOT NULL;

[4.18223]

[4.18279]

                \\  WHERE id = ? AND thumb IS NOT NULL;

Replacement in src/main.zig at line 664 [3.1454]

B:BD[4.18313] → [2.3940:4041]

                sqliteErrorReport("SQLite error while checking if image is already downloaded", db);

[4.18313]

[4.18414]

                sqliteErrorReport("SQLite error while checking if thumb is already downloaded", db);

Replacement in src/main.zig at line 668 [3.1454]

B:BD[4.18496] → [2.4042:4115]

                log.info("Image for ID {d} already downloaded.", .{id});

[4.18496]

[4.18569]

                log.info("Thumb for ID {d} already downloaded.", .{id});

Replacement in src/main.zig at line 672 [3.1454]

B:BD[4.18660] → [2.4116:4233]

∅:D[2.4233] → [4.19257:19317]

B:BD[4.19257] → [4.19257:19317]

B:BD[4.19317] → [2.4234:4312]

                log.info("Failed to download fullsize image for ID {d}", .{id});
                return error.FATAL;
            };
            hashit(resp.items) catch |err| {
                log.err("Couldn't hash image for ID {d}: {s}", .{ id, err });

[4.18660]

[4.19395]

                log.info("Failed to download thumbnail image for ID {d}", .{id});

Replacement in src/main.zig at line 677 [3.1454]

B:BD[2.4430] → [2.4430:4591]

            try db.exec(
                \\INSERT INTO blob (data, hash)
                \\  VALUES (?, ?);
            , .{}, .{ resp.items, hash_buf2[0..] });

[2.4430]

[4.19446]

            db.exec(
                "UPDATE OR ROLLBACK image SET thumb = ? WHERE id = ?",
                .{},
                .{
                    .thumb = resp.items,
                    .id = id,
                },
            ) catch {
                sqliteErrorReport("Couldn't add thumb to DB", db);
                return error.GO_ON;
            };
            hashit(resp.items) catch |err| {
                log.err("Couldn't hash thumb for ID {d}: {s}", .{ id, err });
                return error.GO_ON;
            };

Replacement in src/main.zig at line 693 [3.1454]

B:BD[4.19467] → [2.4592:4718]

                \\UPDATE OR ROLLBACK image
                \\  SET thumb_id = last_insert_rowid() WHERE eid = ?
            ,

[4.19467]

[4.19543]

                "UPDATE OR ROLLBACK image SET hash_thumb = ? WHERE id = ?",

Replacement in src/main.zig at line 695 [3.1454]
B:BD[4.19564] → [2.4719:4742]
```
                .{id},
```
[4.19564]
[4.19605]
```
                .{ hash_buf2[0..], id },
```

Replacement in src/main.zig at line 697 [3.1454]

B:BD[4.19627] → [2.4743:4811]

                sqliteErrorReport("Couldn't add image to DB.", db);

[4.19627]

[4.19693]

                sqliteErrorReport("Couldn't add thumb hash", db);

Replacement in src/main.zig at line 715 [3.1454]

B:BD[4.20200] → [2.4812:4868]

            image: ?[]u8,
            extension: ?[]u8,

[4.20200]

[4.20260]

            image: ?[:0]u8,
            extension: ?[:0]u8,

Replacement in src/main.zig at line 719 [3.1454]

B:BD[4.20286] → [2.4869:4975]

        "SELECT blob.data, image.extension FROM blob, image WHERE eid = ? AND image.image_id = blob.id;",

[4.20286]

[4.20345]

        "SELECT image, extension FROM image WHERE id = ?",

Replacement in src/main.zig at line 721 [3.1454]
B:BD[4.20358] → [2.4976:4991]
```
        .{id},
```
[4.20358]
[4.20381]
```
        .{ .id = id },
```

Replacement in zig.mod at line 31 [3.18992]

B:BD[2.5746] → [2.5746:5810]

      - ../../../../../../sqlite-amalgamation-3360000/sqlite3.c

[2.5746]

[4.21882]

      - ../../../../../../sqlite/sqlite3.c

Deletion in zig.mod at line 33 [3.18992]

B:BD[4.21930] → [4.21930:22031]

  - src: git https://github.com/truemedian/zfetch
  - src: git https://github.com/alexnask/iguanaTLS

Replacement in zigmod.lock at line 2 [3.19314]

B:BD[3.19317] → [2.5812:5992]

∅:D[2.5992] → [4.22177:22264]

B:BD[4.22177] → [4.22177:22264]

B:BD[4.22264] → [2.5993:6169]

∅:D[2.6169] → [4.22440:22712]

B:BD[4.22440] → [4.22440:22712]

git https://github.com/Hejsil/zig-clap commit-c5fb22823a9a4a699acaefc1e9febfee0b8e506c
git https://github.com/vrischmann/zig-sqlite commit-4954c419d379ffbb637904b41d25ef910c6bb02b
git https://github.com/nektro/zig-json commit-72e555fbc0776f2600aee19b01e5ab1855ebec7a
git https://github.com/truemedian/zfetch commit-6ba2ba136ec7cfc887811039cd4a7d8a43ba725b
git https://github.com/truemedian/hzzp commit-492107d44caa2676c7b5aa4e934e1e937232d652
git https://github.com/alexnask/iguanaTLS commit-0d39a361639ad5469f8e4dcdaea35446bbe54b48
git https://github.com/MasterQ32/zig-network commit-b9c91769d8ebd626c8e45b2abb05cbc28ccc50da
git https://github.com/MasterQ32/zig-uri commit-52cdd2061bec0579519f0d30280597f3a1db8b75

[3.19317]

git https://github.com/Hejsil/zig-clap commit-844c9370bcecf063daff697f296d6ae979190649
git https://github.com/vrischmann/zig-sqlite commit-3dc73fbe5bbe043e31b12637cb693b9bf6ceba95
git https://github.com/nektro/zig-json commit-7f0e661371d41cfdc8b1649ed00e7a750c82e57a
git https://github.com/nektro/zig-extras commit-090ee5f1834af4ed7714101b24d7daec84572390
git https://github.com/nektro/zig-range commit-890ca308fe09b3d5c866d5cfb3b3d7a95dbf939f
git https://github.com/MasterQ32/zig-uri/ commit-52cdd2061bec0579519f0d30280597f3a1db8b75