36 Commits

Author SHA1 Message Date
Le Philousophe e2e60dd537 WEB: Fail if database update was not successful
This helps to spot problems in spreadsheet before website update.
2025-11-23 12:25:02 +01:00
Le Philousophe e48391c4e6 WEB: Migrate from deprecated method 2025-10-31 17:27:41 +01:00
Le Philousophe 710b95a5f4 WEB: Better error handling
When PHP functions fail they often return false instead of the expected
object type.
CHeck for this value and fail properly.
2025-08-24 12:32:47 +02:00
Le Philousophe cc9fa80181 WEB: Add typing 2025-08-24 12:32:47 +02:00
Le Philousophe 1c9380ef3e JANITORIAL: Fix code style
This should not have any behavioral changes
2025-08-24 12:32:46 +02:00
Le Philousophe 303573e590 BUILD: Fix phpstan error
The connection object (ConnectionInterface) doesn't officially expose
the isCommittable function.
Try to commit and, if it fails, rollback.
2025-08-09 17:39:22 +02:00
Le Philousophe 558eab0e55 BUILD: Improve error handling when importing data
Try to insert again when it failed without the faulty elements.
2025-06-21 11:17:40 +02:00
Le Philousophe 2ec02d4627 BUILD: Make promises run as soon as they can
Instead of waiting to download everything and process the results,
process each result when it comes.
2024-09-21 16:19:48 +02:00
Le Philousophe 2d41648004 BUILD: Use a transaction to feed the database
This avoids Propel to issue a transaction at each save which causes
SQLite to sync to disk after every single insertion.
This speeds up the process dramatically on slow drives.
2024-09-21 16:15:32 +02:00
Thunderforge ecfba7047b WEB: Using full game id across the site (#288)
Previously, game ids were displayed in the form of `monkey`. Now they are displayed in the form of `scumm:monkey`.

Note that this changes some of the URLs for the screenshots and compatibility pages.
2023-04-26 10:09:06 +02:00
Thunderforge 0c89fb51e1 WEB: Using new game_downloads table (backwards compatible)
Pulling data from a sheet with the new id
2023-01-23 20:05:04 -06:00
Thunderforge 89c2c79174 WEB: Using new game_downloads table (backwards compatible)
Pulling data from a sheet with the new id
2023-01-23 19:59:33 -06:00
Thunderforge c3679beffa WEB: Using new screenshots table (backwards compatible)
Pulling data from a sheet with the new id
2023-01-23 19:17:28 -06:00
Thunderforge f0e1c30770 WEB: Using new compatibility table (backwards compatible)
Pulling data from a sheet with the new id
2023-01-23 19:15:22 -06:00
Thunderforge d9e02ca090 WEB: Using new games table backwards compatibility
Pulling data from a sheet with the new id
2023-01-23 18:58:14 -06:00
Thunderforge fdd8ec9857 Revert "WEB: Changing Compatibility ids to engine_id:game_id (#267)"
This reverts commit 777834c50b.
2022-11-10 18:44:59 -06:00
Thunderforge 777834c50b WEB: Changing Compatibility ids to engine_id:game_id (#267) 2022-11-10 18:23:28 -06:00
Thunderforge 286aaa5739 IMAGES: Moving screenshots from company/game to engine/game (#207)
Includes a recalculation of how screenshot files are counted due to the removal of the `filemask` field.
2022-02-19 20:32:15 -06:00
Thunderforge 60e02dbf54 DATA: Changing downloads table to use version column (#174)
In order to simplify the process of updating version downloads, [downloads spreadsheet table](https://docs.google.com/spreadsheets/d/1QzwFleEKXOsE59cYMOcQB7C2f0Np48uAQOCG8kicX_s/edit#gid=1057392663) now includes a `version` column and the `url` field is much simpler. In order to update a new version, simply change the value in the `version` field.

Further improvements can be made, but for now this is an improvement that keeps parity with the previous code.
2021-11-18 16:04:20 -06:00
mataniko 7b0b6b8bb1 WEB: Add Director Demo data model 2021-08-23 21:39:04 -04:00
Mataniko 2c280bfe12 WEB: Fix potential race condition when building data 2021-01-25 15:18:42 -05:00
Mataniko 4292507fcb WEB: Convert localization utils to a static class 2021-01-01 10:07:47 -05:00
Mataniko 6589516321 WEB: Restore number of shots in screenshots page 2020-12-31 04:49:44 -05:00
Mataniko c6be8fea6a WEB: ORM cleanups 2020-12-31 04:49:44 -05:00
Mataniko 8e2c5cd7da WEB: Model remaining data into the ORM schema 2020-12-31 04:49:44 -05:00
Mataniko c80da556c0 WEB: Load data into the ORM from YAML 2020-12-31 04:49:44 -05:00
Mataniko bc727c5db3 BUILD: Run data update concurrently 2020-12-07 18:30:01 -05:00
Mataniko a540a7a98f WEB: Properly clear cache after data update 2020-12-01 22:14:16 -05:00
Mataniko ebe03e04d6 DATA: Update downloads filenames 2020-11-24 14:51:10 -05:00
Mataniko 6ca7a7c72d DATA: Move Downloads and Games to YAML 2020-11-24 14:51:10 -05:00
Mataniko 41f028310c WEB: Use symfony/yaml and predis if redis is not available
This removes the hard requirements on pecl modules making development easier.
2020-10-21 23:08:08 -04:00
Mataniko 527ea385fa WEB: Update data util to save to the new data folder 2020-10-10 01:34:06 -04:00
Mataniko 08ea2cfcde WEB: Lint and static analysis cleanup 2020-09-27 22:08:07 -04:00
Mataniko 2bdcfa3aef DATA: Add Screenshots data and update data 2020-09-27 22:08:07 -04:00
Mataniko b5636d15e0 WEB: Clean up data and fix spelling errors 2020-09-27 22:08:07 -04:00
Mataniko b4bb9c119b DATA: Create a class to update the existing data model from spreadsheet 2020-09-27 22:08:07 -04:00