Petr Viktorin [Sun, 3 Apr 2011 17:59:09 +0000 (19:59 +0200)]
Add usage text for --langs
Petr Viktorin [Sun, 3 Apr 2011 17:05:21 +0000 (19:05 +0200)]
Load translations in pokedex load.
Petr Viktorin [Sun, 3 Apr 2011 17:05:21 +0000 (19:05 +0200)]
Don't dump unofficial translations in `pokedex dump`
(Translations cannot be dumped properly because the source string hash
isn't in the database.)
By default, unofficial texts are only dumped for English, but that can
be configured if someone wants CSVs for different language(s).
Official texts (<thing>_names rows for official languages) are always
dumped.
Petr Viktorin [Wed, 6 Apr 2011 23:31:18 +0000 (02:31 +0300)]
Make poupdate work correctly without a i18n directory
Petr Viktorin [Wed, 6 Apr 2011 23:30:31 +0000 (02:30 +0300)]
Add current Czech translations
This makes Git track csv/translations
Petr Viktorin [Wed, 6 Apr 2011 22:28:54 +0000 (01:28 +0300)]
Reading, merging, and writing translations
Eevee [Mon, 11 Apr 2011 01:51:03 +0000 (18:51 -0700)]
Fix a misuse of a set as a dictionary in db loading.
Eevee [Mon, 11 Apr 2011 01:22:05 +0000 (18:22 -0700)]
Merge branch '247-item-rewrite'
Eevee [Sun, 10 Apr 2011 05:22:38 +0000 (22:22 -0700)]
Dozen or so more item effects rewritten. #247
Eevee [Mon, 4 Apr 2011 02:38:23 +0000 (19:38 -0700)]
Effects for the remaining B/W items. #247
Eevee [Wed, 30 Mar 2011 06:15:13 +0000 (23:15 -0700)]
Update item effects with English names. Added new stone evos.
Eevee [Sun, 2 Jan 2011 08:20:20 +0000 (00:20 -0800)]
Remaining B/W item effects, save for some gimmicks and key items. #377
Eevee [Sun, 2 Jan 2011 06:23:19 +0000 (22:23 -0800)]
B/W item effects up through the jewels. #377
Eevee [Thu, 16 Dec 2010 05:08:01 +0000 (21:08 -0800)]
B/W item effects and mail item effects. #377
Eevee [Mon, 13 Dec 2010 01:30:55 +0000 (17:30 -0800)]
Great Item Effect Rewrite, part 2: up through berries. #247
Eevee [Mon, 13 Dec 2010 00:49:21 +0000 (16:49 -0800)]
Addressed Zhorken's myriad comments on the item rewrite so far. #247
Eevee [Mon, 13 Dec 2010 00:42:52 +0000 (16:42 -0800)]
Great Item Effect Rewrite, part 1; up through the flutes. #247
Eevee [Sun, 10 Apr 2011 23:33:18 +0000 (16:33 -0700)]
Rearranged evolution table; added new B/W evolutions. #378
There are now (well, have been for a while) multiple ways to evolve
a Pokémon from its unique parent, so the current schema wasn't working.
The parent Pokémon has moved back to the main pokemon table, and
pokemon_evolution has grown an artificial primary key.
New evolution methods for Milotic, Leafeon, Glaceon, Magnezone, and
Probopass have been added.
Eevee [Sun, 10 Apr 2011 07:54:14 +0000 (00:54 -0700)]
Fix default language assignment once and for all.
Stop trying to be clever and magical and just make the caller pass in a
damn primary key.
Eevee [Sun, 10 Apr 2011 05:58:40 +0000 (22:58 -0700)]
Remove old move effect categories. #389
Eevee [Sun, 10 Apr 2011 05:22:58 +0000 (22:22 -0700)]
Added identifiers for move meta categories.
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.