Petr Viktorin [Sat, 9 Apr 2011 15:20:58 +0000 (18:20 +0300)]
Test media accessors, and the media organization itself
A few tests of the accessors, along with a very dumb, long-running script
to ensure everything is in its proper place, and there's nothing but the
proper things.
For now it still finds some beta form cruft for Burmy, Pichu and Cherrim.
Petr Viktorin [Sat, 9 Apr 2011 13:39:27 +0000 (16:39 +0300)]
Add media accessors
Petr Viktorin [Sat, 9 Apr 2011 14:10:43 +0000 (17:10 +0300)]
Add Lillipup and Gothitelle Sugimori art
From the official Japanese Flash dex (with shadows) for now. Hopefully
all of this will get replaced by something better soon.
Petr Viktorin [Sat, 9 Apr 2011 09:34:02 +0000 (12:34 +0300)]
Remove some cruft from the sprite directories
Removed:
- Blank Special_02 image
- Blank Shadow image
- Several blank sprites of Burmy's Beta form
- Cropped egg icon (should be in spline-pokedex)
Renamed:
- Substitute backsprite: Special_02 → substitute
- HGSS sprite shadow moved to chrome
- items/underground/rocks.png → chrome/underground-rocks.png
Petr Viktorin [Fri, 8 Apr 2011 23:59:52 +0000 (02:59 +0300)]
Remove bogus 'berry bag' and 'gen3/itemfinder2' item sprites
Petr Viktorin [Sat, 9 Apr 2011 09:34:46 +0000 (12:34 +0300)]
Rename pokemon/cropped-pokemon to just pokemon/cropped
Petr Viktorin [Sat, 9 Apr 2011 02:13:17 +0000 (05:13 +0300)]
Rename pokémon form sprites to use identifiers. Helps #365
Unown !: 201-! → 201-exclamation
Unown ?: 201-? → 201-question
??? Arceus: 493-??? → 493-unknown
Petr Viktorin [Sat, 9 Apr 2011 01:19:06 +0000 (04:19 +0300)]
Add duplicate overworld sprites for named default forms
- Unown A: 201-a.png → 201.png
- Normal Deoxys: 386-normal.png → 386.png
- Plant Burmy: 412-plant.png → 412.png
- Plant Wormadam: 413-plant.png → 413.png
- West Shellos: 422-west.png → 422.png
- West Gastrodon: 423-west.png → 423.png
Petr Viktorin [Fri, 8 Apr 2011 20:08:26 +0000 (23:08 +0300)]
Put emerald animated shiny sprites in animated/shiny, not shiny/animated
This how they are for Crystal.
mv emerald/shiny/animated emerald/animated/shiny
Petr Viktorin [Sat, 9 Apr 2011 00:26:24 +0000 (03:26 +0300)]
Add 'underground' flag to Iron Ball and Light Clay
Petr Viktorin [Fri, 8 Apr 2011 23:58:24 +0000 (02:58 +0300)]
Rename a bunch of sprites to use identifiers. Helps #365
- pokémon body shapes
- the unknown (???) type
- poké- items (poké ball, poké toy, pokéblock case, etc.)
Petr Viktorin [Sat, 9 Apr 2011 13:57:21 +0000 (16:57 +0300)]
fixup! Rename font images to Unicode values or ASCII-only identifiers. Helps #365
Petr Viktorin [Fri, 8 Apr 2011 19:29:48 +0000 (22:29 +0300)]
Remove images that don't belong in pokedex
These are:
gender-rates/* encounters/* versions/*
chrome/sprite-frame* chrome/trainer-*
Petr Viktorin [Fri, 8 Apr 2011 19:11:37 +0000 (22:11 +0300)]
Rename font images to Unicode values or ASCII-only identifiers. Helps #365
Petr Viktorin [Fri, 8 Apr 2011 18:21:52 +0000 (21:21 +0300)]
Reorganize chrome images
chrome/damage-classes → damage-classes
chrome/habitats → habitats
chrome/bag → item-pockets. item-pockets/selected
chrome/contest → contest-types/en (except appeal.png & jam.png)
chrome/types → types/en
New directories:
chrome/time-of-day
chrome/pokeathlon
Petr Viktorin [Fri, 8 Apr 2011 17:50:59 +0000 (20:50 +0300)]
Split items/big into items/berries and items/underground
Petr Viktorin [Fri, 8 Apr 2011 17:34:44 +0000 (20:34 +0300)]
Move pokémon media to a pokemon/ directory
Main sprites go to pokemon/main-sprites/
Eevee [Wed, 6 Apr 2011 06:34:28 +0000 (23:34 -0700)]
hurp durp default language
Eevee [Wed, 6 Apr 2011 05:32:51 +0000 (22:32 -0700)]
Merge remote-tracking branch 'origin/encounters-i18n'
Conflicts:
pokedex/db/__init__.py
Eevee [Wed, 6 Apr 2011 04:46:11 +0000 (21:46 -0700)]
Unbreak db.connect(), whoops.
Eevee [Wed, 6 Apr 2011 04:04:32 +0000 (21:04 -0700)]
Merge branch 'encukou'
Eevee [Wed, 6 Apr 2011 04:03:41 +0000 (21:03 -0700)]
Remove the responsibility of setting a default language from multilang.
Caller now has to do it. No need to avoid circular deps, no need to do
much of anything at all.
Eevee [Wed, 6 Apr 2011 03:48:10 +0000 (20:48 -0700)]
Always joinedload the local_language for a full language map.
a_magical_me [Mon, 4 Apr 2011 09:42:29 +0000 (02:42 -0700)]
Add FR/LG encounters. #136
a_magical_me [Sun, 3 Apr 2011 22:09:45 +0000 (15:09 -0700)]
Add R/S/E encounters. #136
- They actually have LocationAreaEncounterRates this time!
- Make EncounterSlots.rarity nullable, since my script requires it.
a_magical_me [Sun, 3 Apr 2011 13:34:49 +0000 (06:34 -0700)]
Rename terrain => method. #375
They aren't actually terrains, and i need that name for another table.
a_magical_me [Sun, 3 Apr 2011 12:16:15 +0000 (05:16 -0700)]
Add script for adding B/W locations
in the hope that it will be useful in future generations.
a_magical_me [Sun, 3 Apr 2011 12:12:09 +0000 (05:12 -0700)]
Add B/W locations. #375
English and Japanese. Woo!
The text dump contained a bunch of duplicate location names (possibly
for the Entralink?). I've merged them in the locations table, but
location_game_indices still has the duplicates—that is, a location can
now have multiple game_index values in one generation (necessitating a
small schema change).
Petr Viktorin [Mon, 4 Apr 2011 18:51:12 +0000 (21:51 +0300)]
Make MultilangSession's language class configurable
Petr Viktorin [Sun, 3 Apr 2011 19:05:56 +0000 (22:05 +0300)]
Make session.default_language set/get work
a_magical_me [Sun, 3 Apr 2011 11:49:34 +0000 (04:49 -0700)]
Add identifier_from_name() function.
Adapted from name2ident() in scripts/migration-i18n.py.
a_magical_me [Sun, 3 Apr 2011 11:38:26 +0000 (04:38 -0700)]
Re-add scripts/migration-i18n.py.
Believe it or not, i actually needed to refer to this.
And it was an *absolute pain* to find.
a_magical_me [Sun, 3 Apr 2011 11:28:29 +0000 (04:28 -0700)]
Revert "Added a bunch of autoincrement=False."
This reverts commit
e68f43a5aee1b8fe145c416df6fa0015b54efd5c,
because it was a bloody terrible idea.
Petr Viktorin [Sun, 3 Apr 2011 18:00:58 +0000 (21:00 +0300)]
Add __repr__ to mapped classes
This makes string representations of lists, tuples, dicts, etc. with the
DB objects make sense
Petr Viktorin [Sun, 3 Apr 2011 16:34:44 +0000 (19:34 +0300)]
Make a bunch of text columns nullable to support missing translations
Petr Viktorin [Sun, 3 Apr 2011 16:42:46 +0000 (19:42 +0300)]
Enable nullable MarkdownColumns
Petr Viktorin [Sun, 3 Apr 2011 16:34:18 +0000 (19:34 +0300)]
Change item short effect format to markdown
a_magical_me [Sun, 3 Apr 2011 11:26:45 +0000 (04:26 -0700)]
Make load.py more idiomatic.
Also snuck an idiom into db/__init__.py.
a_magical_me [Sun, 3 Apr 2011 10:21:54 +0000 (03:21 -0700)]
Add usage text for --safe.
a_magical_me [Sun, 3 Apr 2011 09:10:33 +0000 (02:10 -0700)]
load: Add --recursive option.
Helps somewhat with #526 (`pokedex load` is slow) by making it easier to
load only the tables you're interested in.
a_magical_me [Sun, 3 Apr 2011 00:30:08 +0000 (17:30 -0700)]
Alter some identifiers. #207
As per http://bugs.veekun.com/projects/pokedex/wiki/Identifiers?version=3.
- The following tables were handled in commit "2090e34 Move English
texts to language-specific tables": berry_firmness, item_categories,
move_battle_styles, move_damage_classes, move_effect_categories,
pokeathlon_stats, pokemon_colors, pokemon_habitats, regions, types,
versions.
- These tables are skipped, pending further discussion:
generations, growth_rates, move_targets, stats.
- Deviations from the wiki:
- egg_groups: 'no-eggs' is not changed to 'noeggs'
- encounter_terrains: the 'old-rod' alternative is used.
- types: 'unknown' is not changed to '???'
- pokemon_move_methods:
- 'level-up' is not changed to 'level'
- 'colosseum-purification' and 'xd-purification' are left alone,
because colosseum and xd have not yet been added as versions.
- 'xd-shadow' is left alone for consistency with 'xd-purificaiton'.
a_magical_me [Thu, 31 Mar 2011 20:51:19 +0000 (13:51 -0700)]
Add MarkdownString.__html__().
a_magical_me [Tue, 29 Mar 2011 21:39:54 +0000 (14:39 -0700)]
Remove all uses of str.format().
For Python 2.5 compatibility.
a_magical_me [Tue, 29 Mar 2011 03:49:17 +0000 (20:49 -0700)]
Speed up `import pokedex.db` slightly.
Importing pokedex can take several seconds due to its rather large
dependencies—in particular, sqlalchemy, whoosh, and pkg_resources seem
to be the largest offenders. Normally, it would be possible to import
only the submodules one needs (pokedex.db, say), but pokedex.__init__
brings in all the submodules, for use by the command-line interface.
The fix is rather obvious:
- Move the command-line stuff into pokedex.main.
Note: because the submodules are no longer imported by default, any
script which expects `import pokedex` to be useful will likely break.
Note: the `pokedex` command will not work until you re-run `python
setup.py develop`, to update entry_points.txt.
- Don't import pkg_resources until necessary.
Eevee [Sun, 3 Apr 2011 09:16:15 +0000 (02:16 -0700)]
Change item short effects to markdown.
Eevee [Sun, 3 Apr 2011 08:56:27 +0000 (01:56 -0700)]
Random lookup algorithm is now more naive, but less broken.
Eevee [Sun, 3 Apr 2011 08:26:55 +0000 (01:26 -0700)]
Added a truckload of innerjoins and joinedloads.
Also reformatted the relationship definitions. Now less of a clusterfuck.
Eevee [Sun, 3 Apr 2011 08:26:31 +0000 (01:26 -0700)]
Fix the i18n test; now uses multilang's session subclasses.
Eevee [Sun, 3 Apr 2011 08:25:59 +0000 (01:25 -0700)]
Split up MoveEffectProperty; don't detect dict proxies.
(It didn't work anyway!)
Eevee [Sun, 3 Apr 2011 08:23:48 +0000 (01:23 -0700)]
Fix `pokedex load` with empty tables.
Eevee [Sat, 2 Apr 2011 00:59:42 +0000 (17:59 -0700)]
Added a bunch of autoincrement=False.
Eevee [Sat, 2 Apr 2011 00:10:13 +0000 (17:10 -0700)]
Merge branch 'encukou'
Eevee [Sat, 2 Apr 2011 00:07:28 +0000 (17:07 -0700)]
Created flavor summary tables.
Petr Viktorin [Thu, 31 Mar 2011 13:15:53 +0000 (16:15 +0300)]
Add the Czech language
Petr Viktorin [Wed, 30 Mar 2011 01:47:18 +0000 (04:47 +0300)]
Add 'ripped' to column info
Eevee [Fri, 1 Apr 2011 23:47:52 +0000 (16:47 -0700)]
Create flavor_summary tables for Pokemon, Move, Item.
Petr Viktorin [Tue, 29 Mar 2011 23:24:52 +0000 (02:24 +0300)]
Remove a bad test
Petr Viktorin [Tue, 29 Mar 2011 21:15:28 +0000 (00:15 +0300)]
Reorder the classes in tables.py alphabetically. Also, test the order.
Petr Viktorin [Tue, 29 Mar 2011 20:50:23 +0000 (23:50 +0300)]
Update the comment for the Postgres version of pokedex load.
Petr Viktorin [Tue, 29 Mar 2011 18:01:57 +0000 (21:01 +0300)]
Remove the test for filter(Pokemon.name > u"Xatu")
__gt__ and friends, you will be missed.
Petr Viktorin [Tue, 29 Mar 2011 17:44:43 +0000 (20:44 +0300)]
Update test_schema to the new API. Add some missing column metadata.
Petr Viktorin [Tue, 29 Mar 2011 16:54:20 +0000 (19:54 +0300)]
Update test_strings.py to the new API (still fails though)
Petr Viktorin [Tue, 29 Mar 2011 16:53:16 +0000 (19:53 +0300)]
Add a mapped_classes list, and a translation_classes list to each mapped class
Eevee [Fri, 1 Apr 2011 22:59:14 +0000 (15:59 -0700)]
Shapes for gen 5 Pokémon.
Eevee [Thu, 31 Mar 2011 16:22:16 +0000 (09:22 -0700)]
Disable autoincrement for MoveMetaAilment.
Eevee [Wed, 30 Mar 2011 04:26:57 +0000 (21:26 -0700)]
Add Stat.is_battle_only.
Eevee [Wed, 30 Mar 2011 03:20:08 +0000 (20:20 -0700)]
Update the pokedex.db.tables docs.
Eevee [Wed, 30 Mar 2011 03:15:41 +0000 (20:15 -0700)]
Match default language by id, not identifier.
Eevee [Wed, 30 Mar 2011 01:39:37 +0000 (18:39 -0700)]
Joinedload current-language names.
Eevee [Tue, 29 Mar 2011 15:06:34 +0000 (08:06 -0700)]
Merge remote-tracking branch 'origin/encukou'
Petr Viktorin [Wed, 26 Jan 2011 01:14:42 +0000 (02:14 +0100)]
Add Czech romanization
Petr Viktorin [Tue, 29 Mar 2011 14:36:45 +0000 (17:36 +0300)]
Print progress for dropping/creating tables
Petr Viktorin [Mon, 14 Mar 2011 03:11:27 +0000 (05:11 +0200)]
Faster `pokedex load` for PostgreSQL #526
Also added the -S (--safe) option, which disables the backend-specific
optimizations.
This gives over 3× speedup on my machine :)
Eevee [Tue, 29 Mar 2011 05:13:33 +0000 (22:13 -0700)]
Merge remote-tracking branch 'origin/ability-changes'
Eevee [Tue, 29 Mar 2011 04:59:23 +0000 (21:59 -0700)]
Add the 1% held items in B/W.
Eevee [Tue, 29 Mar 2011 04:39:42 +0000 (21:39 -0700)]
We finally know what the last B/W move flag is.
Eevee [Tue, 29 Mar 2011 04:26:44 +0000 (21:26 -0700)]
Recent changes to Bide and Feint. #570
Lynn "Zhorken" Vaughan [Tue, 29 Mar 2011 03:40:30 +0000 (23:40 -0400)]
Some more ability fixes/changes. #561
Eevee [Tue, 29 Mar 2011 02:55:53 +0000 (19:55 -0700)]
Fix short effects for Grudge, Glaciate. #570
Eevee [Tue, 29 Mar 2011 02:36:05 +0000 (19:36 -0700)]
Fix ancient bug with Pursuit description. #569
Eevee [Tue, 29 Mar 2011 02:30:10 +0000 (19:30 -0700)]
Mud/Water Sport last until the user leaves battle. #568
Not until the end of battle.
Eevee [Tue, 29 Mar 2011 02:25:29 +0000 (19:25 -0700)]
Metal Burst returns 1.5× damage, not 2×. #567
Eevee [Tue, 29 Mar 2011 02:14:24 +0000 (19:14 -0700)]
Merge branch 'schema-sanity'
Eevee [Tue, 29 Mar 2011 02:12:30 +0000 (19:12 -0700)]
language_id -> local_language_id
Eevee [Fri, 25 Mar 2011 03:44:08 +0000 (20:44 -0700)]
Remove back_populates, which doesn't seem to work.
Eevee [Fri, 25 Mar 2011 03:02:00 +0000 (20:02 -0700)]
Remove a bunch of imports from tables.py.
Eevee [Fri, 25 Mar 2011 02:37:12 +0000 (19:37 -0700)]
Rename internal_id to game_index.
Eevee [Fri, 25 Mar 2011 01:46:46 +0000 (18:46 -0700)]
Rename *_texts tables to *_names.
Eevee [Fri, 25 Mar 2011 00:17:24 +0000 (17:17 -0700)]
Whoops; preserve column order.
Eevee [Thu, 24 Mar 2011 05:39:21 +0000 (22:39 -0700)]
Remove LanguageSpecific.
Eevee [Thu, 24 Mar 2011 05:17:02 +0000 (22:17 -0700)]
Removed ProseColumn and TextColumn. Huzzah.
Eevee [Tue, 22 Mar 2011 05:32:52 +0000 (22:32 -0700)]
Started switching to create_translation_table.
- Moved the function to its own file.
- Implemented the session-based default language switching.
- Migrated a couple tables.
Eevee [Tue, 22 Mar 2011 00:54:28 +0000 (17:54 -0700)]
Sigh! Remove support for strings as keys; use Language objects.
Eevee [Sun, 20 Mar 2011 08:06:45 +0000 (01:06 -0700)]
New i18n schema thing impl, and fixed the new tests to match.
Eevee [Sat, 19 Mar 2011 01:22:18 +0000 (18:22 -0700)]
Added a test for the i18n dynamic table generation.
It fails spectacularly, but hopefully documents what I'm ultimately
going for.
Eevee [Sat, 19 Mar 2011 00:15:34 +0000 (17:15 -0700)]
Rename some meta-schema variables for ease of debugging.
Eevee [Tue, 15 Mar 2011 05:32:06 +0000 (22:32 -0700)]
Add missing effect chance to Twister. #565
Eevee [Tue, 15 Mar 2011 05:24:29 +0000 (22:24 -0700)]
Replace String* sqla stuff with association_proxy.
Eevee [Tue, 15 Mar 2011 03:51:31 +0000 (20:51 -0700)]
Give every db table a __str__.
Eevee [Mon, 14 Mar 2011 06:43:08 +0000 (23:43 -0700)]
Tidy up relation creation for name tables.