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