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.
Eevee [Mon, 14 Mar 2011 06:12:17 +0000 (23:12 -0700)]
Remove OfficiallyNamed and UnofficiallyNamed.
Eevee [Sun, 13 Mar 2011 22:51:17 +0000 (15:51 -0700)]
Merge branch 'encukou'
Eevee [Sun, 13 Mar 2011 02:06:16 +0000 (18:06 -0800)]
Fix some i18n schema issues when running under a Real Database™.
Petr Viktorin [Sun, 13 Mar 2011 15:47:31 +0000 (17:47 +0200)]
Make the string properties mutable
Petr Viktorin [Sun, 13 Mar 2011 15:08:18 +0000 (17:08 +0200)]
Use DefaultLangProperty for Markdown columns
Petr Viktorin [Sun, 13 Mar 2011 13:42:50 +0000 (15:42 +0200)]
Rename StatHint.text to .message (clashed with the all-texts attribute)
Petr Viktorin [Sat, 12 Mar 2011 20:43:29 +0000 (22:43 +0200)]
fixup! I18n for the database schema
Petr Viktorin [Sat, 12 Mar 2011 15:30:15 +0000 (17:30 +0200)]
Actually test :foo in test_crash_empty_prefix
Petr Viktorin [Sat, 12 Mar 2011 14:46:04 +0000 (16:46 +0200)]
Fix connect() without arguments
Petr Viktorin [Sat, 12 Mar 2011 12:36:08 +0000 (14:36 +0200)]
Support filtering by strings (Pokemon.name, Pokemon.names['fr'], etc.)
Petr Viktorin [Sat, 12 Mar 2011 14:42:41 +0000 (16:42 +0200)]
Add descriptions to new tables
Petr Viktorin [Tue, 8 Mar 2011 21:09:08 +0000 (23:09 +0200)]
Use a class + mapper instead of dynamic declarative magic
Petr Viktorin [Tue, 8 Mar 2011 20:55:47 +0000 (22:55 +0200)]
Replace all_tables by table_classes; get rid of globals()
Petr Viktorin [Sat, 12 Mar 2011 14:07:14 +0000 (16:07 +0200)]
Fix up the migration
The script got some things wrong; fix those up manually.
Also remove the migration script, as it won't work any more.
Petr Viktorin [Sat, 12 Mar 2011 16:05:37 +0000 (18:05 +0200)]
Move English texts to language-specific tables
(See parent commit for rebasing instructions)
Eevee [Sun, 13 Mar 2011 22:25:10 +0000 (15:25 -0700)]
Preserve the order of TextColumns and ProseColumns.
Petr Viktorin [Fri, 4 Feb 2011 04:34:00 +0000 (06:34 +0200)]
Add migration script to move English texts to language-specific tables
The next commit will apply this script, changing nearly all of the CSV files.
When your rebases stops there, run::
git reset --hard
python scripts/migration-i18n.py
git add -A pokedex/data/csv/
git rebase --continue
Petr Viktorin [Fri, 4 Feb 2011 04:25:23 +0000 (06:25 +0200)]
Make lookup index respect the moved names
Petr Viktorin [Fri, 4 Feb 2011 04:24:33 +0000 (06:24 +0200)]
Add data to language table
Add English as a language
Add columns:
identifier: same as iso639 except 'roomaji' for Roomaji
order: English first, then Japanese and Roomaji, others undefined
official: True for all the languages so far
Petr Viktorin [Fri, 4 Feb 2011 04:22:44 +0000 (06:22 +0200)]
Multi-language markdown move properties
Singular property name for English text
Plural property name for dict of texts keyed by language
Petr Viktorin [Sat, 12 Mar 2011 15:59:01 +0000 (17:59 +0200)]
I18n for the database schema
- Helper base class: Named
Subclasses: OfficiallyNamed, UnofficiallyNamed
for these, a 'name' column is created in the appropriate text table
also, they get automatic __str__/__repr__/__unicode__
- Faux columns: ProseColumn, TextColumn
these become columns in the appropriate text tables
these text tables (*_text, *_prose) are auto-generated at the end
the main table gets one property (singular name) that gets the English text
and one (plural name) with dict of texts keyed by language
- Every named table gets 'identifier'
- Languages compare & hash equal to their identifiers
- Existing foreign-name tables replaced by the autogenerated ones
- order_by: names replaced by identifiers
- New function: all_tables(), yields all tables
- Markdown move properties removed for now
- Schema test suite
Lynn "Zhorken" Vaughan [Sun, 13 Mar 2011 02:57:34 +0000 (21:57 -0500)]
Some ability changes/fixes. #561
Brigit Lemanski [Sun, 13 Mar 2011 02:41:03 +0000 (21:41 -0500)]
Fixing short desc for Acid Spray.
Eevee [Fri, 11 Mar 2011 06:11:16 +0000 (22:11 -0800)]
Give calculated_stat and calculated_hp the same signature.
Lynn "Zhorken" Vaughan [Thu, 10 Mar 2011 17:00:37 +0000 (12:00 -0500)]
Add Spanish B/W names.
Lynn "Zhorken" Vaughan [Thu, 10 Mar 2011 16:46:14 +0000 (11:46 -0500)]
Add Italian names for B/W stuff.
Lynn "Zhorken" Vaughan [Thu, 10 Mar 2011 16:26:43 +0000 (11:26 -0500)]
Add German names for B/W stuff.
Lynn "Zhorken" Vaughan [Sun, 6 Mar 2011 05:58:37 +0000 (00:58 -0500)]
Remove the erroneous Dusclops-only Thief tutor.
Eevee [Sun, 6 Mar 2011 09:13:19 +0000 (01:13 -0800)]
"Characteristic" text, here called stat hints.
Eevee [Sun, 6 Mar 2011 08:00:40 +0000 (00:00 -0800)]
Add B/W move metadata. #389
Eevee [Sun, 6 Mar 2011 00:04:05 +0000 (16:04 -0800)]
Add a SaveFilePokemon accessor to get the form.
Lynn "Zhorken" Vaughan [Thu, 3 Mar 2011 18:16:05 +0000 (13:16 -0500)]
Add French names from B/W for everything. #252
Also give la Passe Éon an accent to match the Latis being les Pokémon
Éon. (No other items not in B/W seem to need accents added.)
Lynn "Zhorken" Vaughan [Thu, 3 Mar 2011 00:37:06 +0000 (19:37 -0500)]
Add B/W ability flavour text.
Lynn "Zhorken" Vaughan [Wed, 2 Mar 2011 23:58:36 +0000 (18:58 -0500)]
Add B/W Pokémon flavour text!
Lynn "Zhorken" Vaughan [Wed, 2 Mar 2011 23:43:25 +0000 (18:43 -0500)]
Add B/W move flavour text.
Lynn "Zhorken" Vaughan [Wed, 2 Mar 2011 23:35:15 +0000 (18:35 -0500)]
Add B/W item flavour text.
Lynn "Zhorken" Vaughan [Wed, 2 Mar 2011 23:20:35 +0000 (18:20 -0500)]
Rename item icons.
Lynn "Zhorken" Vaughan [Wed, 2 Mar 2011 23:04:18 +0000 (18:04 -0500)]
B/W item names. #451
The god stone is listed as ???, so I'm keeping it as it is for now.
Lynn "Zhorken" Vaughan [Wed, 2 Mar 2011 22:31:32 +0000 (17:31 -0500)]
Fix Markdown references to Gen V stuff.
Lynn "Zhorken" Vaughan [Wed, 2 Mar 2011 21:38:50 +0000 (16:38 -0500)]
English names for everything! #451
Lynn "Zhorken" Vaughan [Fri, 11 Feb 2011 02:50:16 +0000 (21:50 -0500)]
Shorten some over-long move effect changelog entries.
I couldn't really shorten Dig and Fly's bug descriptions to 255
characters, so I also gave the column more space.
Lynn "Zhorken" Vaughan [Fri, 11 Feb 2011 02:45:03 +0000 (21:45 -0500)]
Fix references to Dragon Tail and Round.
Lynn "Zhorken" Vaughan [Fri, 11 Feb 2011 02:00:53 +0000 (21:00 -0500)]
Support null PP for Struggle and Shadow moves. #190
Lynn "Zhorken" Vaughan [Sun, 6 Feb 2011 18:31:20 +0000 (13:31 -0500)]
Support null pre-D/P damage class for ??? and Shadow.
Rather than marking them "non-damaging".
Lynn "Zhorken" Vaughan [Fri, 11 Feb 2011 01:58:46 +0000 (20:58 -0500)]
Add names revealed 2011-02-10. #451
Actually from pokemonblackwhite.com this time! Woo!
Eevee [Thu, 10 Feb 2011 07:37:41 +0000 (23:37 -0800)]
Add a couple relations for move effect changelogs.
Eevee [Mon, 31 Jan 2011 06:29:23 +0000 (22:29 -0800)]
Use engine_from_config for database connections. #390
Brigit Lemanski [Wed, 9 Feb 2011 23:38:02 +0000 (18:38 -0500)]
Cleaning up move_changelog and move_effect_changelog, #78 #530
Probably will need a second passthrough to make it more sensible.
Also probably missed some effect changes.
Still, it's a step or two.
a_magical_me [Sun, 6 Feb 2011 08:16:55 +0000 (00:16 -0800)]
Load/dump dance.
a_magical_me [Sun, 6 Feb 2011 08:26:46 +0000 (00:26 -0800)]
Rename Basculin's sprites. #451
Lynn "Zhorken" Vaughan [Wed, 2 Feb 2011 07:46:15 +0000 (02:46 -0500)]
Tympole and Timburr; also Basculin's forms are Stripe*d*. #451
Tympole and Timburr:
http://www.officialnintendomagazine.co.uk/article.php?id=23389
Lynn "Zhorken" Vaughan [Tue, 1 Feb 2011 16:15:38 +0000 (11:15 -0500)]
Add more newly-revealed names. #451
Lynn "Zhorken" Vaughan [Mon, 31 Jan 2011 22:02:34 +0000 (17:02 -0500)]
Order Ability's Pokémon relations by Pokemon.order.
Lynn "Zhorken" Vaughan [Mon, 31 Jan 2011 21:36:20 +0000 (16:36 -0500)]
Make Type.moves a proper relation with an order_by.
Lynn "Zhorken" Vaughan [Mon, 31 Jan 2011 19:38:12 +0000 (14:38 -0500)]
Morning is not a separate time of day for evolution.
As far as evolution is concerned, it's always day or night--there is no
in-between period when Eevee will not evolve into Espeon or Umbreon, and
there are no Pokémon that only evolve during the early part of the day.
Having 'morning' as a separate value is thus misleading, albeit not
terribly misleading since it never appeared outside of tables.py.
Lynn "Zhorken" Vaughan [Fri, 28 Jan 2011 20:09:11 +0000 (15:09 -0500)]
Add Sugimori art for Basculin.
Lifted from Bulbapedia, of course.
Lynn "Zhorken" Vaughan [Fri, 28 Jan 2011 19:52:58 +0000 (14:52 -0500)]
Castform's forms are all "the Weather Pokémon".
Lynn "Zhorken" Vaughan [Fri, 28 Jan 2011 18:46:57 +0000 (13:46 -0500)]
Add new names revealed by IGN on 2011-01-27. #451
http://ds.ign.com/articles/114/1143911p2.html
Petr Viktorin [Sat, 8 Jan 2011 22:21:44 +0000 (23:21 +0100)]
Speed tweaks for pokedex load in SQLite
Eevee [Fri, 28 Jan 2011 04:27:42 +0000 (20:27 -0800)]
Remove useless encounter_slot_conditions table. #297
Eevee [Fri, 28 Jan 2011 04:20:08 +0000 (20:20 -0800)]
Merge fishing and surfing swarms into regular swarms. #297
Eevee [Thu, 27 Jan 2011 06:28:41 +0000 (22:28 -0800)]
Removed a ton of nonsensical HG/SS swarm encounters. #297
Eevee [Thu, 27 Jan 2011 05:33:03 +0000 (21:33 -0800)]
Lots of encounters were using slots that claimed to be for other games. #297 #281
Lynn "Zhorken" Vaughan [Fri, 28 Jan 2011 04:04:27 +0000 (23:04 -0500)]
Delete some B/W female sprites identical to the male ones.
I don't like this, but at least I'm making it consistent for now!
Files deleted based on having md5sums matching the equivalent male
sprites'.
Lynn "Zhorken" Vaughan [Tue, 25 Jan 2011 05:36:38 +0000 (00:36 -0500)]
Rename the Liberty Pass's icon.
Lynn "Zhorken" Vaughan [Tue, 25 Jan 2011 05:14:11 +0000 (00:14 -0500)]
Add names for Victini and the Liberty Pass. #451
http://bulbanews.bulbagarden.net/wiki/Liberty_Pass_event_announced_for_North_America_and_PAL_regions
I have no idea where they actually got this press release, but whatever.
Lynn "Zhorken" Vaughan [Mon, 24 Jan 2011 20:47:47 +0000 (15:47 -0500)]
Merge the fem_sprite columns into has_gender_differences. #363
Chimecho does not have gender differences; its Platinum and HG/SS second-
frame female backsprites have one hand posed a little differently, but
no actual design differences.
Torchic does count even though the only difference is a single-pixel dark
speck on the male's rear; the speck was carried over into B/W even though
the backsprites were entirely redone, so I'm guessing it either was
deliberate or has ascended into canon via "let's throw it in anyway."
Lynn "Zhorken" Vaughan [Mon, 24 Jan 2011 20:33:18 +0000 (15:33 -0500)]
Add properties for getting a Pokemon from a PokemonForm, and vice-versa.
Brigit Lemanski [Wed, 19 Jan 2011 16:49:28 +0000 (11:49 -0500)]
BW names from Nintendo Magazine UK
Lynn "Zhorken" Vaughan [Fri, 14 Jan 2011 07:49:24 +0000 (02:49 -0500)]
Fix some references to Sky Drop in move effects.
Lynn "Zhorken" Vaughan [Fri, 14 Jan 2011 03:02:41 +0000 (22:02 -0500)]
Add the monkey names from Gamestop preorder boxes. #451
Lynn "Zhorken" Vaughan [Fri, 14 Jan 2011 02:41:51 +0000 (21:41 -0500)]
Add new names revealed 2011-01-13. #451
Lynn "Zhorken" Vaughan [Thu, 13 Jan 2011 22:26:06 +0000 (17:26 -0500)]
Add foreign move/ability names revealed 2010-12-27.
The French section of pokemonblackwhite.com updated and fixed the Tail
Slap issue! \o/
"Coeur de Coq" and "Eclair Fou" are spelled like that to match the game
names—no "œ"; no accents on capital letters. They'd be preferable, but
I'd rather keep our names consistent until I can get them for
*everything*.
Lynn "Zhorken" Vaughan [Wed, 5 Jan 2011 17:12:46 +0000 (12:12 -0500)]
Change "toxic poison" to "bad poison" in Synchronize's changelog.
Lynn "Zhorken" Vaughan [Wed, 5 Jan 2011 16:59:56 +0000 (11:59 -0500)]
Reorganize the Sugimori art a bit.
- Move female art into a female/ directory, like we have for other
categories
- Copy a few images so that every named form (that we have art for) has a
###-form.png, and every Pokémon has a plain ###.png
Lynn "Zhorken" Vaughan [Thu, 30 Dec 2010 01:58:30 +0000 (20:58 -0500)]
Replace "Forme" with "form" in the Rotom Form move method.
Lynn "Zhorken" Vaughan [Mon, 27 Dec 2010 20:27:39 +0000 (15:27 -0500)]
Use Darmanitan's English name in its forms' description.
Brigit Lemanski [Tue, 28 Dec 2010 00:43:44 +0000 (19:43 -0500)]
Chinese names for some pokémon
Lynn "Zhorken" Vaughan [Mon, 27 Dec 2010 18:36:44 +0000 (13:36 -0500)]
Fix a reference to Darmanitan in daruma mode's effect.
Lynn "Zhorken" Vaughan [Mon, 27 Dec 2010 18:27:50 +0000 (13:27 -0500)]
Add new French and German Pokémon names.
Nothing but Pokémon yet because a) I don't feel like it right now;
b) the French section on pokemonblackwhite.com calls Tail Slap two
different things.
Lynn "Zhorken" Vaughan [Mon, 27 Dec 2010 18:14:48 +0000 (13:14 -0500)]
Add a bunch of newly-revealed English names. #451
Lynn "Zhorken" Vaughan [Sat, 25 Dec 2010 02:01:51 +0000 (21:01 -0500)]
Some more ability changes. #78 #376
Lynn "Zhorken" Vaughan [Sat, 25 Dec 2010 01:56:58 +0000 (20:56 -0500)]
Improve a bunch of schema documentation.
I didn't get to a bunch, but I wanted this to stop clogging up my working
tree.
Lynn "Zhorken" Vaughan [Fri, 24 Dec 2010 01:26:04 +0000 (20:26 -0500)]
Support kaburumo and chobomaki's trade-for-each other evolution. #378
Eevee [Fri, 24 Dec 2010 05:21:57 +0000 (21:21 -0800)]
Fix cross thunder short effect.
Eevee [Fri, 24 Dec 2010 03:51:50 +0000 (19:51 -0800)]
Crashfix: Bunch of move effect syntax fixes.
a_magical_me [Tue, 21 Dec 2010 04:58:51 +0000 (20:58 -0800)]
Add a script for setting pokemon.order
a_magical_me [Tue, 21 Dec 2010 04:26:26 +0000 (20:26 -0800)]
Add order_by=Pokemon.order to a few relations.
a_magical_me [Wed, 15 Dec 2010 04:53:31 +0000 (20:53 -0800)]
Fix Rotom's forms' order.
a_magical_me [Thu, 9 Dec 2010 02:20:21 +0000 (18:20 -0800)]
Give Pokemon an order column.
Basically national order, but with families grouped together.
Lynn "Zhorken" Vaughan [Tue, 14 Dec 2010 01:24:14 +0000 (20:24 -0500)]
Give move changelogs a few more relations. #78
Lynn "Zhorken" Vaughan [Tue, 14 Dec 2010 00:25:14 +0000 (19:25 -0500)]
Add a bunch more move changes from Gen I-III.