QueryReleasesExtra
From Sega Retro
 |
This task is unfinished This is a wiki task that requires more thought or peer review. An important issue that needs to be solved, which will appear at the top of Sega Retro:Todo until this message is removed. |
So here's a vague plan - Special:CargoTables/releases doesn't house all the information I'd like, so I've made Special:CargoTables/releasesextra.
This template lets us query the latter "easily" and generates a list of bullet points with a result.
e.g.
{{QueryReleasesExtra|field=rating|value=e}}
Query: SELECT `table1`.`name` AS `name`,`table1`.`value` AS `value1`,`table2`.`value` AS `value2`,`table3`.`value` AS `value3` FROM `cargo__releasesextra` `table1` LEFT OUTER JOIN `cargo__releasesextra` `table2` ON ((`table1`.`releaseid`=`table2`.`releaseid`)) LEFT OUTER JOIN `cargo__releasesextra` `table3` ON ((`table1`.`releaseid`=`table3`.`releaseid`)) WHERE table1.type="releasename" and table2.type="date" and table3.type="rating" and table3.value="e" ORDER BY table1.name,table1.value,table2.value,table3.value LIMIT 5000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-28d833-81.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Should get us every E rated video game.
{{QueryReleasesExtra|field=rating|value=e|format=PS3}}
Query: SELECT `table1`.`name` AS `name`,`table1`.`value` AS `value1`,`table2`.`value` AS `value2`,`table3`.`value` AS `value3` FROM `cargo__releasesextra` `table1` LEFT OUTER JOIN `cargo__releasesextra` `table2` ON ((`table1`.`releaseid`=`table2`.`releaseid`)) LEFT OUTER JOIN `cargo__releasesextra` `table3` ON ((`table1`.`releaseid`=`table3`.`releaseid`)) LEFT OUTER JOIN `cargo__releasesextra` `table4` ON ((`table1`.`releaseid`=`table4`.`releaseid`)) WHERE table1.type="releasename" and table2.type="date" and table3.type="rating" and table3.value="e" and table4.type="format" and table4.value="PS3" ORDER BY table1.name,table1.value,table2.value,table3.value LIMIT 5000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-28d833-86.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Should get us every E rated video game on the PS3.
The problem is getting information into the table. It's currently populated from Template:ReleaseTest2, which attempts to pull as much data from the game bobs as possible, and then you add extra things.
But if I want all the Kixx re-releases, it's going to struggle because I've just learnt that the bobs aren't storing these properly.
This is the point where it would be nice to have someone reasonably well versed in wiki knowledge to bounce ideas off. -Black Squirrel (talk) 11:59, 1 July 2023 (EDT)