zzz-pokedex.git
13 years agoRename terrain => method. #375
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.

13 years agoAdd script for adding B/W locations
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.

13 years agoAdd B/W locations. #375
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).

13 years agoAdd identifier_from_name() function.
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.

13 years agoRe-add 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.

13 years agoRevert "Added a bunch of autoincrement=False."
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.

13 years agoMake load.py more idiomatic.
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.

13 years agoAdd usage text for --safe.
a_magical_me [Sun, 3 Apr 2011 10:21:54 +0000 (03:21 -0700)] 
Add usage text for --safe.

13 years agoload: Add --recursive option.
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.

13 years agoAlter some identifiers. #207
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'.

13 years agoAdd MarkdownString.__html__().
a_magical_me [Thu, 31 Mar 2011 20:51:19 +0000 (13:51 -0700)] 
Add MarkdownString.__html__().

13 years agoRemove all uses of str.format().
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.

13 years agoSpeed up `import pokedex.db` slightly.
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.

13 years agoChange item short effects to markdown.
Eevee [Sun, 3 Apr 2011 09:16:15 +0000 (02:16 -0700)] 
Change item short effects to markdown.

13 years agoRandom lookup algorithm is now more naive, but less broken.
Eevee [Sun, 3 Apr 2011 08:56:27 +0000 (01:56 -0700)] 
Random lookup algorithm is now more naive, but less broken.

13 years agoAdded a truckload of innerjoins and joinedloads.
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.

13 years agoFix the i18n test; now uses multilang's session subclasses.
Eevee [Sun, 3 Apr 2011 08:26:31 +0000 (01:26 -0700)] 
Fix the i18n test; now uses multilang's session subclasses.

13 years agoSplit up MoveEffectProperty; don't detect dict proxies.
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!)

13 years agoFix `pokedex load` with empty tables.
Eevee [Sun, 3 Apr 2011 08:23:48 +0000 (01:23 -0700)] 
Fix `pokedex load` with empty tables.

13 years agoAdded a bunch of autoincrement=False.
Eevee [Sat, 2 Apr 2011 00:59:42 +0000 (17:59 -0700)] 
Added a bunch of autoincrement=False.

13 years agoMerge branch 'encukou'
Eevee [Sat, 2 Apr 2011 00:10:13 +0000 (17:10 -0700)] 
Merge branch 'encukou'

13 years agoCreated flavor summary tables.
Eevee [Sat, 2 Apr 2011 00:07:28 +0000 (17:07 -0700)] 
Created flavor summary tables.

13 years agoAdd the Czech language
Petr Viktorin [Thu, 31 Mar 2011 13:15:53 +0000 (16:15 +0300)] 
Add the Czech language

13 years agoAdd 'ripped' to column info
Petr Viktorin [Wed, 30 Mar 2011 01:47:18 +0000 (04:47 +0300)] 
Add 'ripped' to column info

13 years agoCreate flavor_summary tables for Pokemon, Move, Item.
Eevee [Fri, 1 Apr 2011 23:47:52 +0000 (16:47 -0700)] 
Create flavor_summary tables for Pokemon, Move, Item.

13 years agoRemove a bad test
Petr Viktorin [Tue, 29 Mar 2011 23:24:52 +0000 (02:24 +0300)] 
Remove a bad test

13 years agoReorder the classes in tables.py alphabetically. Also, test the order.
Petr Viktorin [Tue, 29 Mar 2011 21:15:28 +0000 (00:15 +0300)] 
Reorder the classes in tables.py alphabetically. Also, test the order.

13 years agoUpdate the comment for the Postgres version of pokedex load.
Petr Viktorin [Tue, 29 Mar 2011 20:50:23 +0000 (23:50 +0300)] 
Update the comment for the Postgres version of pokedex load.

13 years agoRemove the test for filter(Pokemon.name > u"Xatu")
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.

13 years agoUpdate test_schema to the new API. Add some missing column metadata.
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.

13 years agoUpdate test_strings.py to the new API (still fails though)
Petr Viktorin [Tue, 29 Mar 2011 16:54:20 +0000 (19:54 +0300)] 
Update test_strings.py to the new API (still fails though)

13 years agoAdd a mapped_classes list, and a translation_classes list to each mapped class
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

13 years agoShapes for gen 5 Pokémon.
Eevee [Fri, 1 Apr 2011 22:59:14 +0000 (15:59 -0700)] 
Shapes for gen 5 Pokémon.

13 years agoDisable autoincrement for MoveMetaAilment.
Eevee [Thu, 31 Mar 2011 16:22:16 +0000 (09:22 -0700)] 
Disable autoincrement for MoveMetaAilment.

13 years agoAdd Stat.is_battle_only.
Eevee [Wed, 30 Mar 2011 04:26:57 +0000 (21:26 -0700)] 
Add Stat.is_battle_only.

13 years agoUpdate the pokedex.db.tables docs.
Eevee [Wed, 30 Mar 2011 03:20:08 +0000 (20:20 -0700)] 
Update the pokedex.db.tables docs.

13 years agoMatch default language by id, not identifier.
Eevee [Wed, 30 Mar 2011 03:15:41 +0000 (20:15 -0700)] 
Match default language by id, not identifier.

13 years agoJoinedload current-language names.
Eevee [Wed, 30 Mar 2011 01:39:37 +0000 (18:39 -0700)] 
Joinedload current-language names.

13 years agoMerge remote-tracking branch 'origin/encukou'
Eevee [Tue, 29 Mar 2011 15:06:34 +0000 (08:06 -0700)] 
Merge remote-tracking branch 'origin/encukou'

13 years agoAdd Czech romanization
Petr Viktorin [Wed, 26 Jan 2011 01:14:42 +0000 (02:14 +0100)] 
Add Czech romanization

13 years agoPrint progress for dropping/creating tables
Petr Viktorin [Tue, 29 Mar 2011 14:36:45 +0000 (17:36 +0300)] 
Print progress for dropping/creating tables

13 years agoFaster `pokedex load` for PostgreSQL #526
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 :)

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.