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.
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__.