zzz-pokedex.git
13 years agoFix default language assignment once and for all.
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.

13 years agoRemove old move effect categories. #389
Eevee [Sun, 10 Apr 2011 05:58:40 +0000 (22:58 -0700)] 
Remove old move effect categories.  #389

13 years agoAdded identifiers for move meta categories.
Eevee [Sun, 10 Apr 2011 05:22:58 +0000 (22:22 -0700)] 
Added identifiers for move meta categories.

13 years agohurp durp default language
Eevee [Wed, 6 Apr 2011 06:34:28 +0000 (23:34 -0700)] 
hurp durp default language

13 years agoMerge remote-tracking branch 'origin/encounters-i18n'
Eevee [Wed, 6 Apr 2011 05:32:51 +0000 (22:32 -0700)] 
Merge remote-tracking branch 'origin/encounters-i18n'

Conflicts:
pokedex/db/__init__.py

13 years agoUnbreak db.connect(), whoops.
Eevee [Wed, 6 Apr 2011 04:46:11 +0000 (21:46 -0700)] 
Unbreak db.connect(), whoops.

13 years agoMerge branch 'encukou'
Eevee [Wed, 6 Apr 2011 04:04:32 +0000 (21:04 -0700)] 
Merge branch 'encukou'

13 years agoRemove the responsibility of setting a default language from multilang.
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.

13 years agoAlways joinedload the local_language for a full language map.
Eevee [Wed, 6 Apr 2011 03:48:10 +0000 (20:48 -0700)] 
Always joinedload the local_language for a full language map.

13 years agoAdd FR/LG encounters. #136
a_magical_me [Mon, 4 Apr 2011 09:42:29 +0000 (02:42 -0700)] 
Add FR/LG encounters.  #136

13 years agoAdd R/S/E 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.

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 agoMake MultilangSession's language class configurable
Petr Viktorin [Mon, 4 Apr 2011 18:51:12 +0000 (21:51 +0300)] 
Make MultilangSession's language class configurable

13 years agoMake session.default_language set/get work
Petr Viktorin [Sun, 3 Apr 2011 19:05:56 +0000 (22:05 +0300)] 
Make session.default_language set/get work

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 agoAdd __repr__ to mapped classes
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

13 years agoMake a bunch of text columns nullable to support missing translations
Petr Viktorin [Sun, 3 Apr 2011 16:34:44 +0000 (19:34 +0300)] 
Make a bunch of text columns nullable to support missing translations

13 years agoEnable nullable MarkdownColumns
Petr Viktorin [Sun, 3 Apr 2011 16:42:46 +0000 (19:42 +0300)] 
Enable nullable MarkdownColumns

13 years agoChange item short effect format to markdown
Petr Viktorin [Sun, 3 Apr 2011 16:34:18 +0000 (19:34 +0300)] 
Change item short effect format to markdown

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.