zzz-pokedex.git
13 years agoMerge remote-tracking branch 'origin/ability-changes'
Eevee [Tue, 29 Mar 2011 05:13:33 +0000 (22:13 -0700)] 
Merge remote-tracking branch 'origin/ability-changes'

13 years agoAdd the 1% held items in B/W.
Eevee [Tue, 29 Mar 2011 04:59:23 +0000 (21:59 -0700)] 
Add the 1% held items in B/W.

13 years agoWe finally know what the last B/W move flag is.
Eevee [Tue, 29 Mar 2011 04:39:42 +0000 (21:39 -0700)] 
We finally know what the last B/W move flag is.

13 years agoRecent changes to Bide and Feint. #570
Eevee [Tue, 29 Mar 2011 04:26:44 +0000 (21:26 -0700)] 
Recent changes to Bide and Feint.  #570

13 years agoSome more ability fixes/changes. #561
Lynn "Zhorken" Vaughan [Tue, 29 Mar 2011 03:40:30 +0000 (23:40 -0400)] 
Some more ability fixes/changes. #561

13 years agoFix short effects for Grudge, Glaciate. #570
Eevee [Tue, 29 Mar 2011 02:55:53 +0000 (19:55 -0700)] 
Fix short effects for Grudge, Glaciate.  #570

13 years agoFix ancient bug with Pursuit description. #569
Eevee [Tue, 29 Mar 2011 02:36:05 +0000 (19:36 -0700)] 
Fix ancient bug with Pursuit description.  #569

13 years agoMud/Water Sport last until the user leaves battle. #568
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.

13 years agoMetal Burst returns 1.5× damage, not 2×. #567
Eevee [Tue, 29 Mar 2011 02:25:29 +0000 (19:25 -0700)] 
Metal Burst returns 1.5× damage, not 2×.  #567

13 years agoMerge branch 'schema-sanity'
Eevee [Tue, 29 Mar 2011 02:14:24 +0000 (19:14 -0700)] 
Merge branch 'schema-sanity'

13 years agolanguage_id -> local_language_id
Eevee [Tue, 29 Mar 2011 02:12:30 +0000 (19:12 -0700)] 
language_id -> local_language_id

13 years agoRemove back_populates, which doesn't seem to work.
Eevee [Fri, 25 Mar 2011 03:44:08 +0000 (20:44 -0700)] 
Remove back_populates, which doesn't seem to work.

13 years agoRemove a bunch of imports from tables.py.
Eevee [Fri, 25 Mar 2011 03:02:00 +0000 (20:02 -0700)] 
Remove a bunch of imports from tables.py.

13 years agoRename internal_id to game_index.
Eevee [Fri, 25 Mar 2011 02:37:12 +0000 (19:37 -0700)] 
Rename internal_id to game_index.

13 years agoRename *_texts tables to *_names.
Eevee [Fri, 25 Mar 2011 01:46:46 +0000 (18:46 -0700)] 
Rename *_texts tables to *_names.

13 years agoWhoops; preserve column order.
Eevee [Fri, 25 Mar 2011 00:17:24 +0000 (17:17 -0700)] 
Whoops; preserve column order.

13 years agoRemove LanguageSpecific.
Eevee [Thu, 24 Mar 2011 05:39:21 +0000 (22:39 -0700)] 
Remove LanguageSpecific.

13 years agoRemoved ProseColumn and TextColumn. Huzzah.
Eevee [Thu, 24 Mar 2011 05:17:02 +0000 (22:17 -0700)] 
Removed ProseColumn and TextColumn.  Huzzah.

13 years agoStarted switching to create_translation_table.
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.

13 years agoSigh! Remove support for strings as keys; use Language objects.
Eevee [Tue, 22 Mar 2011 00:54:28 +0000 (17:54 -0700)] 
Sigh!  Remove support for strings as keys; use Language objects.

13 years agoNew i18n schema thing impl, and fixed the new tests to match.
Eevee [Sun, 20 Mar 2011 08:06:45 +0000 (01:06 -0700)] 
New i18n schema thing impl, and fixed the new tests to match.

13 years agoAdded a test for the i18n dynamic table generation.
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.

13 years agoRename some meta-schema variables for ease of debugging.
Eevee [Sat, 19 Mar 2011 00:15:34 +0000 (17:15 -0700)] 
Rename some meta-schema variables for ease of debugging.

13 years agoAdd missing effect chance to Twister. #565
Eevee [Tue, 15 Mar 2011 05:32:06 +0000 (22:32 -0700)] 
Add missing effect chance to Twister.  #565

13 years agoReplace String* sqla stuff with association_proxy.
Eevee [Tue, 15 Mar 2011 05:24:29 +0000 (22:24 -0700)] 
Replace String* sqla stuff with association_proxy.

13 years agoGive every db table a __str__.
Eevee [Tue, 15 Mar 2011 03:51:31 +0000 (20:51 -0700)] 
Give every db table a __str__.

13 years agoTidy up relation creation for name tables.
Eevee [Mon, 14 Mar 2011 06:43:08 +0000 (23:43 -0700)] 
Tidy up relation creation for name tables.

13 years agoRemove OfficiallyNamed and UnofficiallyNamed.
Eevee [Mon, 14 Mar 2011 06:12:17 +0000 (23:12 -0700)] 
Remove OfficiallyNamed and UnofficiallyNamed.

13 years agoMerge branch 'encukou'
Eevee [Sun, 13 Mar 2011 22:51:17 +0000 (15:51 -0700)] 
Merge branch 'encukou'

13 years agoFix some i18n schema issues when running under a Real Database™.
Eevee [Sun, 13 Mar 2011 02:06:16 +0000 (18:06 -0800)] 
Fix some i18n schema issues when running under a Real Database™.

13 years agoMake the string properties mutable
Petr Viktorin [Sun, 13 Mar 2011 15:47:31 +0000 (17:47 +0200)] 
Make the string properties mutable

13 years agoUse DefaultLangProperty for Markdown columns
Petr Viktorin [Sun, 13 Mar 2011 15:08:18 +0000 (17:08 +0200)] 
Use DefaultLangProperty for Markdown columns

13 years agoRename StatHint.text to .message (clashed with the all-texts attribute)
Petr Viktorin [Sun, 13 Mar 2011 13:42:50 +0000 (15:42 +0200)] 
Rename StatHint.text to .message (clashed with the all-texts attribute)

13 years agofixup! I18n for the database schema
Petr Viktorin [Sat, 12 Mar 2011 20:43:29 +0000 (22:43 +0200)] 
fixup! I18n for the database schema

13 years agoActually test :foo in test_crash_empty_prefix
Petr Viktorin [Sat, 12 Mar 2011 15:30:15 +0000 (17:30 +0200)] 
Actually test :foo in test_crash_empty_prefix

13 years agoFix connect() without arguments
Petr Viktorin [Sat, 12 Mar 2011 14:46:04 +0000 (16:46 +0200)] 
Fix connect() without arguments

13 years agoSupport filtering by strings (Pokemon.name, Pokemon.names['fr'], etc.)
Petr Viktorin [Sat, 12 Mar 2011 12:36:08 +0000 (14:36 +0200)] 
Support filtering by strings (Pokemon.name, Pokemon.names['fr'], etc.)

13 years agoAdd descriptions to new tables
Petr Viktorin [Sat, 12 Mar 2011 14:42:41 +0000 (16:42 +0200)] 
Add descriptions to new tables

13 years agoUse a class + mapper instead of dynamic declarative magic
Petr Viktorin [Tue, 8 Mar 2011 21:09:08 +0000 (23:09 +0200)] 
Use a class + mapper instead of dynamic declarative magic

13 years agoReplace all_tables by table_classes; get rid of globals()
Petr Viktorin [Tue, 8 Mar 2011 20:55:47 +0000 (22:55 +0200)] 
Replace all_tables by table_classes; get rid of globals()

13 years agoFix up the migration
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.

13 years agoMove English texts to language-specific tables
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)

13 years agoPreserve the order of TextColumns and ProseColumns.
Eevee [Sun, 13 Mar 2011 22:25:10 +0000 (15:25 -0700)] 
Preserve the order of TextColumns and ProseColumns.

13 years agoAdd migration script to move English texts to language-specific tables
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

13 years agoMake lookup index respect the moved names
Petr Viktorin [Fri, 4 Feb 2011 04:25:23 +0000 (06:25 +0200)] 
Make lookup index respect the moved names

13 years agoAdd data to language table
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

13 years agoMulti-language markdown move properties
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

13 years agoI18n for the database schema
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

13 years agoSome ability changes/fixes. #561
Lynn "Zhorken" Vaughan [Sun, 13 Mar 2011 02:57:34 +0000 (21:57 -0500)] 
Some ability changes/fixes. #561

13 years agoFixing short desc for Acid Spray.
Brigit Lemanski [Sun, 13 Mar 2011 02:41:03 +0000 (21:41 -0500)] 
Fixing short desc for Acid Spray.

13 years agoGive calculated_stat and calculated_hp the same signature.
Eevee [Fri, 11 Mar 2011 06:11:16 +0000 (22:11 -0800)] 
Give calculated_stat and calculated_hp the same signature.

13 years agoAdd Spanish B/W names.
Lynn "Zhorken" Vaughan [Thu, 10 Mar 2011 17:00:37 +0000 (12:00 -0500)] 
Add Spanish B/W names.

13 years agoAdd Italian names for B/W stuff.
Lynn "Zhorken" Vaughan [Thu, 10 Mar 2011 16:46:14 +0000 (11:46 -0500)] 
Add Italian names for B/W stuff.

13 years agoAdd German 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.

13 years agoRemove the erroneous Dusclops-only Thief tutor.
Lynn "Zhorken" Vaughan [Sun, 6 Mar 2011 05:58:37 +0000 (00:58 -0500)] 
Remove the erroneous Dusclops-only Thief tutor.

13 years ago"Characteristic" text, here called stat hints.
Eevee [Sun, 6 Mar 2011 09:13:19 +0000 (01:13 -0800)] 
"Characteristic" text, here called stat hints.

13 years agoAdd B/W move metadata. #389
Eevee [Sun, 6 Mar 2011 08:00:40 +0000 (00:00 -0800)] 
Add B/W move metadata.  #389

13 years agoAdd a SaveFilePokemon accessor to get the form.
Eevee [Sun, 6 Mar 2011 00:04:05 +0000 (16:04 -0800)] 
Add a SaveFilePokemon accessor to get the form.

13 years agoAdd French names from B/W for everything. #252
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.)

13 years agoAdd B/W ability flavour text. veekun-promotions/2011030302
Lynn "Zhorken" Vaughan [Thu, 3 Mar 2011 00:37:06 +0000 (19:37 -0500)] 
Add B/W ability flavour text.

13 years agoAdd B/W Pokémon flavour text! veekun-promotions/2011030301
Lynn "Zhorken" Vaughan [Wed, 2 Mar 2011 23:58:36 +0000 (18:58 -0500)] 
Add B/W Pokémon flavour text!

13 years agoAdd B/W move flavour text.
Lynn "Zhorken" Vaughan [Wed, 2 Mar 2011 23:43:25 +0000 (18:43 -0500)] 
Add B/W move flavour text.

13 years agoAdd B/W item flavour text.
Lynn "Zhorken" Vaughan [Wed, 2 Mar 2011 23:35:15 +0000 (18:35 -0500)] 
Add B/W item flavour text.

13 years agoRename item icons.
Lynn "Zhorken" Vaughan [Wed, 2 Mar 2011 23:20:35 +0000 (18:20 -0500)] 
Rename item icons.

13 years agoB/W item names. #451
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.

13 years agoFix Markdown references to Gen V stuff.
Lynn "Zhorken" Vaughan [Wed, 2 Mar 2011 22:31:32 +0000 (17:31 -0500)] 
Fix Markdown references to Gen V stuff.

13 years agoEnglish names for everything! #451
Lynn "Zhorken" Vaughan [Wed, 2 Mar 2011 21:38:50 +0000 (16:38 -0500)] 
English names for everything! #451

13 years agoShorten some over-long move effect changelog entries. veekun-promotions/2011021501 veekun-promotions/2011021502 veekun-promotions/2011022101
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.

13 years agoFix references to Dragon Tail and Round.
Lynn "Zhorken" Vaughan [Fri, 11 Feb 2011 02:45:03 +0000 (21:45 -0500)] 
Fix references to Dragon Tail and Round.

13 years agoSupport null PP for Struggle and Shadow moves. #190
Lynn "Zhorken" Vaughan [Fri, 11 Feb 2011 02:00:53 +0000 (21:00 -0500)] 
Support null PP for Struggle and Shadow moves. #190

13 years agoSupport null pre-D/P damage class for ??? and Shadow.
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".

13 years agoAdd names revealed 2011-02-10. #451
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!

13 years agoAdd a couple relations for move effect changelogs.
Eevee [Thu, 10 Feb 2011 07:37:41 +0000 (23:37 -0800)] 
Add a couple relations for move effect changelogs.

13 years agoUse engine_from_config for database connections. #390
Eevee [Mon, 31 Jan 2011 06:29:23 +0000 (22:29 -0800)] 
Use engine_from_config for database connections.  #390

13 years agoCleaning up move_changelog and move_effect_changelog, #78 #530
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.

13 years agoLoad/dump dance.
a_magical_me [Sun, 6 Feb 2011 08:16:55 +0000 (00:16 -0800)] 
Load/dump dance.

13 years agoRename Basculin's sprites. #451
a_magical_me [Sun, 6 Feb 2011 08:26:46 +0000 (00:26 -0800)] 
Rename Basculin's sprites.  #451

13 years agoTympole and Timburr; also Basculin's forms are Stripe*d*. #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

13 years agoAdd more newly-revealed names. #451
Lynn "Zhorken" Vaughan [Tue, 1 Feb 2011 16:15:38 +0000 (11:15 -0500)] 
Add more newly-revealed names. #451

13 years agoOrder Ability's Pokémon relations by Pokemon.order.
Lynn "Zhorken" Vaughan [Mon, 31 Jan 2011 22:02:34 +0000 (17:02 -0500)] 
Order Ability's Pokémon relations by Pokemon.order.

13 years agoMake Type.moves a proper relation with an order_by.
Lynn "Zhorken" Vaughan [Mon, 31 Jan 2011 21:36:20 +0000 (16:36 -0500)] 
Make Type.moves a proper relation with an order_by.

13 years agoMorning is not a separate time of day for evolution.
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.

13 years agoAdd Sugimori art for Basculin.
Lynn "Zhorken" Vaughan [Fri, 28 Jan 2011 20:09:11 +0000 (15:09 -0500)] 
Add Sugimori art for Basculin.

Lifted from Bulbapedia, of course.

13 years agoCastform's forms are all "the Weather Pokémon".
Lynn "Zhorken" Vaughan [Fri, 28 Jan 2011 19:52:58 +0000 (14:52 -0500)] 
Castform's forms are all "the Weather Pokémon".

13 years agoAdd new names revealed by IGN on 2011-01-27. #451
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

13 years agoSpeed tweaks for pokedex load in SQLite
Petr Viktorin [Sat, 8 Jan 2011 22:21:44 +0000 (23:21 +0100)] 
Speed tweaks for pokedex load in SQLite

13 years agoRemove useless encounter_slot_conditions table. #297
Eevee [Fri, 28 Jan 2011 04:27:42 +0000 (20:27 -0800)] 
Remove useless encounter_slot_conditions table.  #297

13 years agoMerge fishing and surfing swarms into regular swarms. #297
Eevee [Fri, 28 Jan 2011 04:20:08 +0000 (20:20 -0800)] 
Merge fishing and surfing swarms into regular swarms.  #297

13 years agoRemoved a ton of nonsensical HG/SS swarm encounters. #297
Eevee [Thu, 27 Jan 2011 06:28:41 +0000 (22:28 -0800)] 
Removed a ton of nonsensical HG/SS swarm encounters.  #297

13 years agoLots of encounters were using slots that claimed to be for other games. #297 #281
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

13 years agoDelete some B/W female sprites identical to the male ones.
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'.

13 years agoRename the Liberty Pass's icon.
Lynn "Zhorken" Vaughan [Tue, 25 Jan 2011 05:36:38 +0000 (00:36 -0500)] 
Rename the Liberty Pass's icon.

13 years agoAdd names for Victini and the Liberty Pass. #451
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.

13 years agoMerge the fem_sprite columns into has_gender_differences. #363
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."

13 years agoAdd properties for getting a Pokemon from a PokemonForm, and vice-versa.
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.

13 years agoBW names from Nintendo Magazine UK
Brigit Lemanski [Wed, 19 Jan 2011 16:49:28 +0000 (11:49 -0500)] 
BW names from Nintendo Magazine UK

13 years agoFix some references to Sky Drop in move effects. veekun-promotions/2011011701
Lynn "Zhorken" Vaughan [Fri, 14 Jan 2011 07:49:24 +0000 (02:49 -0500)] 
Fix some references to Sky Drop in move effects.

13 years agoAdd the monkey names from Gamestop preorder boxes. #451
Lynn "Zhorken" Vaughan [Fri, 14 Jan 2011 03:02:41 +0000 (22:02 -0500)] 
Add the monkey names from Gamestop preorder boxes. #451

13 years agoAdd new names revealed 2011-01-13. #451
Lynn "Zhorken" Vaughan [Fri, 14 Jan 2011 02:41:51 +0000 (21:41 -0500)] 
Add new names revealed 2011-01-13. #451

13 years agoAdd foreign move/ability names revealed 2010-12-27.
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*.