User:Illviljan/cargo: Difference between revisions
Jump to navigation
Jump to search
>Illviljan mNo edit summary |
>Illviljan mNo edit summary |
||
Line 11: | Line 11: | ||
|offset = 2 | |offset = 2 | ||
}} | }} | ||
<pre> | |||
tables = 'versions' | |||
fields = 'versions.version, versions.release_date' | |||
query = { | |||
where = 'versions.version <> ""', | |||
orderBy = 'versions.version DESC, versions.release_date ASC', | |||
limit = 10, | |||
offset = 2, | |||
} | |||
results = mw.ext.cargo.query(tables, fields, query) | |||
print(results[1]['versions.version']) | |||
</pre> | |||
{{#cargo_query: | |||
tables = mods, spawn_weights | |||
|join on = mods._pageID=spawn_weights._pageID | |||
|fields = mods.id, spawn_weights.weight | |||
|where = mods.domain=5 AND mods.name="Fecund" AND spawn_weights.weight > 0 | |||
|orderBy = | |||
|limit = 10 | |||
|offset = 2 | |||
}} | |||
<pre> | |||
tables = 'mods, spawn_weights' | |||
fields = 'mods.id, spawn_weights.weight' | |||
query = { | |||
join = 'mods._pageID=spawn_weights._pageID', | |||
where = 'mods.domain=5 AND mods.name="Fecund" AND spawn_weights.weight > 0', | |||
limit = 10, | |||
offset = 2 | |||
} | |||
results = mw.ext.cargo.query(tables, fields, query) | |||
print( | |||
results[1]['mods.id'], | |||
results[1]['spawn_weights.weight'] | |||
) | |||
</pre> |
Revision as of 14:36, 16 December 2017
- https://www.mediawiki.org/wiki/Extension:Cargo/Querying_data
- Lua: https://www.mediawiki.org/wiki/Extension:Cargo/Other_features
- results[2][version.version]
version | release date |
---|---|
0.10.0c | 2013-01-26 |
0.10.0d | 2013-01-27 |
0.10.0e | 2013-01-30 |
0.10.0f | 2013-02-04 |
0.10.0g | 2013-02-07 |
0.10.1 | 2013-02-12 |
0.10.1b | 2013-02-13 |
0.10.1c | 2013-02-19 |
0.10.1d | 2013-02-21 |
0.10.1e | 2013-02-22 |
tables = 'versions' fields = 'versions.version, versions.release_date' query = { where = 'versions.version <> ""', orderBy = 'versions.version DESC, versions.release_date ASC', limit = 10, offset = 2, } results = mw.ext.cargo.query(tables, fields, query) print(results[1]['versions.version'])
No results
tables = 'mods, spawn_weights' fields = 'mods.id, spawn_weights.weight' query = { join = 'mods._pageID=spawn_weights._pageID', where = 'mods.domain=5 AND mods.name="Fecund" AND spawn_weights.weight > 0', limit = 10, offset = 2 } results = mw.ext.cargo.query(tables, fields, query) print( results[1]['mods.id'], results[1]['spawn_weights.weight'] )