wowinterface, addon not approved for download

[torkus]

@layday , ever seen this one before?

Got it from attempting to download The Undermine Journal from wowinterface https://cdn.wowinterface.com/downloads/getfile.php?id=19662

$ curl -I  https://cdn.wowinterface.com/downloads/getfile.php?id=19662
HTTP/2 200 
date: Sat, 11 Sep 2021 12:01:29 GMT
content-type: text/html; charset=ISO-8859-1
set-cookie: bblastvisit=1631361689; expires=Sun, 11-Sep-2022 12:01:29 GMT; path=/; domain=.wowinterface.com
cache-control: private
pragma: private
vary: Accept-Encoding
cf-cache-status: BYPASS
set-cookie: bblastactivity=0; expires=Sun, 11-Sep-2022 12:01:29 GMT; path=/; domain=.wowinterface.com
expect-ct: max-age=604800, report-uri="https://report-uri.cloudflare.com/cdn-cgi/beacon/expect-ct"
report-to: {"endpoints":[{"url":"https:\/\/a.nel.cloudflare.com\/report\/v3?s=AT8NIlv9E3PuVuMWxqjhTU0%2FFPPGidZS%2B%2B8V9NdImGCAIwbjCRFV9hMxTjFRlwfMJJfqx7QDECN4x%2F95wKe2bCNNXODgxD6fk3MWP9lqEzLLpufVx0pZxZsv6BSmbSdreVmk3VyT"}],"group":"cf-nel","max_age":604800}
nel: {"success_fraction":0,"report_to":"cf-nel","max_age":604800}
server: cloudflare
cf-ray: 68d0bdddbf7e3e70-ADL
alt-svc: h3=":443"; ma=86400, h3-29=":443"; ma=86400, h3-28=":443"; ma=86400, h3-27=":443"; ma=86400

addon info

$ curl https://api.mmoui.com/v3/game/WOW/filedetails/19662.json | jq .
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100   838    0   838    0     0   2135      0 --:--:-- --:--:-- --:--:--  2132
[
  {
    "UID": "19662",
    "UICATID": "98",
    "UIVersion": "5.6.20210907",
    "UIDate": 1631009549000,
    "UIMD5": null,
    "UIFileName": "TheUndermineJournal.zip",
    "UIDownload": "https://cdn.wowinterface.com/downloads/getfile.php?id=19662&aid=119903&d=1631009549&minion",
    "UIPending": "1",
    "UIName": "The Undermine Journal",
    "UIAuthorName": "TheUndermineJournal",
    "UIDescription": "This addon, from [url=\"https://theunderminejournal.com/\"]The Undermine Journal[/url], shows realm-specific pricing information in item tooltips for all US and EU realms. It should be updated twice each week, on Tuesday and Saturday mornings.\r\n\r\nSee [URL=\"https://theunderminejournal.com#addon\"]this page[/URL] for more information.",
    "UIChangeLog": "Automatic data update for Saturday, September 11, 2021",
    "UIHitCount": "260258",
    "UIHitCountMonthly": "581",
    "UIFavoriteTotal": "143"
  }
]

[torkus]

this works however: https://cdn.wowinterface.com/downloads/getfile.php?id=19662&aid=119903

[layday]

I guess it's because it's "awaiting approval" (UIPending is set to "1"), and somehow providing the add-on ID bypasses the approval check. I don't know why they update the file metadata in the API before the new file's been approved.

[layday]

Yeah I'm alright, how are you doing? Not had a lot of time to work on instawow lately and every time I do open it up in my editor I get the urge to refactor all the things (especially that ORM layer, yuck).

[torkus]

I never quite got along with sqlalchemy, I got spoiled by Django's ORM fairly early on. And Clojure+ORMs aren't really a thing. I think there are a few libraries to make raw SQL a little nicer but it's an idea solidly from the OOP world so it doesn't get much traction. Mapping objects to SQL and normalised databases has always been awkward anyway. Going back to raw SQL was actually quite a bit of fun, it's very powerful.

Strongbox tootles along, I'm looking at performance improvements this month.

I meant to ask, have you come across Nuitka yet? I just discovered it the other week, I'm thinking it will really help bundle and deploy a few apps at work.

[layday]

I tried Nuitka once upon a time, ran into errors and gave up. I use PyOxidizer and PyInstaller to distribute Python code. Distribution is a major pain point still with using Python.

[layday]

I've finally got around to ripping the ORM out (though I've kept the query engine from SQLAlchemy). The most annoying part is how it adds about 100 ms to Python start-up. I've got a simple instawow invocation down to ~250 ms on my machine by lazily importing most of instawow's core in the CLI. I suppose that's still nowhere near as bad as firing up the JVM ;P

[torkus]

JVM is actually pretty good these days. Loading Clojure takes seconds - it sucks.

I'm playing with a splash screen right now but even that takes a little while to come up.