zzz-pokedex.git
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 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 __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 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.

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!