zzz-pokedex.git
15 years agoAdded command_ prefix to CLI commands to fix import problems.
Eevee [Sat, 25 Jul 2009 09:43:30 +0000 (02:43 -0700)] 
Added command_ prefix to CLI commands to fix import problems.

15 years agoPokédex lookup now uses a whoosh index and spell-checker. #15
Eevee [Sat, 25 Jul 2009 08:28:33 +0000 (01:28 -0700)] 
Pokédex lookup now uses a whoosh index and spell-checker.  #15

15 years agoAdded a README and licensed under MIT.
Eevee [Thu, 23 Jul 2009 07:04:47 +0000 (00:04 -0700)] 
Added a README and licensed under MIT.

15 years agoStubbed in a simple lookup command. #15
Eevee [Thu, 23 Jul 2009 06:44:06 +0000 (23:44 -0700)] 
Stubbed in a simple lookup command.  #15

15 years agoFixed bad/confusing grammar in Aftermath's description.
Eevee [Wed, 22 Jul 2009 06:05:44 +0000 (23:05 -0700)] 
Fixed bad/confusing grammar in Aftermath's description.

15 years agoStubbing out a lookup function. #15
Eevee [Tue, 21 Jul 2009 07:12:25 +0000 (00:12 -0700)] 
Stubbing out a lookup function.  #15

15 years agoVery simple items table and wild held item data. #10
Eevee [Sat, 18 Jul 2009 06:33:36 +0000 (23:33 -0700)] 
Very simple items table and wild held item data.  #10

15 years agoRecolored the cropped Kecleon purple. :3
Eevee [Wed, 15 Jul 2009 05:13:11 +0000 (22:13 -0700)] 
Recolored the cropped Kecleon purple.  :3

15 years agoReplaced cropped sizes with cropped Pokémon for #13.
Eevee [Wed, 15 Jul 2009 05:05:36 +0000 (22:05 -0700)] 
Replaced cropped sizes with cropped Pokémon for #13.

15 years agoMerge branch 'master' of git@veekun.com:pokedex
Eevee [Mon, 6 Jul 2009 00:16:29 +0000 (17:16 -0700)] 
Merge branch 'master' of git@veekun.com:pokedex

15 years agoAdded cropped shape images. #13
Eevee [Mon, 6 Jul 2009 00:15:24 +0000 (17:15 -0700)] 
Added cropped shape images.  #13

These were already supposed to be included, but somehow never got
committed.  Whoops.

15 years agoFixed a slew of foriegn key import problems. #29
Eevee [Sat, 4 Jul 2009 03:12:13 +0000 (23:12 -0400)] 
Fixed a slew of foriegn key import problems.  #29

Curse's type_id was 0, which is bogus; this has been fixed by creating a
real ????? type.
Fourth-gen moves all had zero as a contest effect id, which was also
bogus.
Pokémon 494 and 495 were junk and have been scrapped entirely.
pokemon_form_groups's description column was too short.

pokedex's connect() now takes kwargs passed to sessionmaker().

A more major change: some tables, like pokemon, are self-referential and
contain rows that refer to rows later in the table (for example, Pikachu
evolves from Pichu, which has a higher id).  At the moment such a row is
loaded, the foreign key is thus bogus.  I solved this by turning on
autocommit and wrapping add() in a try block, then attempting to readd
every failed row again after the rest of the table is finished.  Slows
the import down a bit, but makes it work perfectly with foreign key
checks on.

15 years agoAdded Platinum Sinnoh dex numbers. #24
Eevee [Sat, 27 Jun 2009 04:27:35 +0000 (21:27 -0700)] 
Added Platinum Sinnoh dex numbers.  #24

15 years agoAdded remaining Pokémon form data. #5
Eevee [Sun, 21 Jun 2009 05:32:37 +0000 (22:32 -0700)] 
Added remaining Pokémon form data.  #5

Types, abilities, egg groups, and stats for Shaymin, Giratina, and Rotom forms.
Updated height and weight for Shaymin and Giratina forms.
Added Giratina's form descriptions and updated Shaymin's to mention link
battles and freezing.

15 years agoAdded some Pokémon methods to hide form weirdness. #5
Eevee [Tue, 16 Jun 2009 03:48:27 +0000 (20:48 -0700)] 
Added some Pokémon methods to hide form weirdness.  #5

15 years agoAdded Platinum forms. #5
Eevee [Tue, 16 Jun 2009 03:48:02 +0000 (20:48 -0700)] 
Added Platinum forms.  #5

15 years agoAdded icons for Platinum formes. #5
Eevee [Tue, 16 Jun 2009 02:04:32 +0000 (19:04 -0700)] 
Added icons for Platinum formes.  #5

Also renamed some older formes to bring them into line with the new
(and actually correct) naming convention.

15 years agoAdded alternate Forme sprites for Platinum. #5
Eevee [Tue, 9 Jun 2009 05:51:36 +0000 (22:51 -0700)] 
Added alternate Forme sprites for Platinum.  #5

This includes the back sprites I was missing, as well as a
reorganization of the sprites away from type names and towards form
names.

15 years agoAdded other languages' Pokémon names.
Eevee [Sun, 7 Jun 2009 08:36:17 +0000 (01:36 -0700)] 
Added other languages' Pokémon names.

15 years agoChanged generation icons to RB/GS/etc.
Eevee [Fri, 29 May 2009 04:18:45 +0000 (21:18 -0700)] 
Changed generation icons to RB/GS/etc.

15 years agoFixed csvimport to load in table dependency order.
Eevee [Fri, 29 May 2009 04:16:18 +0000 (21:16 -0700)] 
Fixed csvimport to load in table dependency order.

15 years agoOops! Added encoding line to tables.py. #6
Eevee [Sun, 17 May 2009 10:01:17 +0000 (03:01 -0700)] 
Oops!  Added encoding line to tables.py.  #6

15 years agoDocumented crazy encounter schema. #7
Eevee [Sun, 17 May 2009 07:18:10 +0000 (00:18 -0700)] 
Documented crazy encounter schema.  #7

15 years agoConsolidated Solaceon Ruins and Old Chateau areas. #7
Eevee [Sun, 17 May 2009 06:34:24 +0000 (23:34 -0700)] 
Consolidated Solaceon Ruins and Old Chateau areas.  #7

All Solaceon Ruins rooms are identical, so there is no reason to have
them duplicated.

All the Old Chateau rooms are similarly identical, EXCEPT for the lone
room that can spawn Gengar.  I also left the Rotom room in, for when I
get around to adding event encounters.

15 years agoAnother rearrangement of CSV rows by primary key.
Eevee [Sun, 17 May 2009 05:31:04 +0000 (22:31 -0700)] 
Another rearrangement of CSV rows by primary key.

15 years agoImproved some location and area names. #7
Eevee [Sun, 17 May 2009 05:16:19 +0000 (22:16 -0700)] 
Improved some location and area names.  #7

Great Marsh is now Great Marsh instead of Safari Zone.

Ruin Maniac Tunnel has been consolidated into one location, and the
areas are actually named informatively.

Turnback Cave has more appropriate area names.

Routes with two parts now mention the cardinal direction in the area
names.  Also, several town names have been fixed.

Lake Verity's area names now mention WHAT they are before/after.

15 years agoAdded some encounter method icons to match #7.
Eevee [Fri, 8 May 2009 00:36:20 +0000 (17:36 -0700)] 
Added some encounter method icons to match #7.

15 years agoImported item icons from old veekun. #10
Eevee [Fri, 8 May 2009 00:35:10 +0000 (17:35 -0700)] 
Imported item icons from old veekun.  #10

Includes little bag icons, big berry icons, and all the underground
sprites.

Unlike veekun, there is no longer a grab-bag 'other' directory of junk I
hadn't sorted yet.

15 years agoFixed table loading under SQLAlchemy 0.5.3.
Eevee [Sun, 3 May 2009 00:44:26 +0000 (17:44 -0700)] 
Fixed table loading under SQLAlchemy 0.5.3.

Apparently the secret property on a singleton hidden in the guts of
SQLAlchemy has been made private recently, so what I wanted to do (get a
list of all ORM classes) is now impossible.  I gave up on trying to find
a real solution and just slapped together something using dir().

15 years agoReordered some rows in mapping tables.
Eevee [Fri, 1 May 2009 13:29:19 +0000 (06:29 -0700)] 
Reordered some rows in mapping tables.

This does NOT actually change the data at all!  These tables were
apparently created with no key defined, so the rows were in arbitrary
order -- but when I created and populated the tables in MySQL on
nyarumaa, the keys were defined correctly, and InnoDB ordered them by
key.  This is about what should happen anyway and the discrepancy adds
clutter when dumping corrections, so I'm just committing the new order.

15 years agoMade csvimport somewhat tolerant of load errors.
Eevee [Fri, 1 May 2009 13:24:09 +0000 (06:24 -0700)] 
Made csvimport somewhat tolerant of load errors.

It used to abruptly abort if a csv file were missing, which wasn't very
nice when I'd just added a new table definition and was trying to reload
everything else.

Now it prints a status per table while loading, and will declare missing
tables to be...  missing.

15 years agoAdded encounter data for Diamond, Pearl, and Platinum.
Eevee [Fri, 1 May 2009 13:20:18 +0000 (06:20 -0700)] 
Added encounter data for Diamond, Pearl, and Platinum.

Finally!  Location order is the same as from the old dex, which was
something like the game but ultimately arbitrary, so it's not any better
now.

This takes a very different approach to storage, rather than copying the
game exactly and trying to fix everything in code.  Comments coming
shortly so other people can actually make use of this.

15 years agoAdded a function for the EXP formula.
Eevee [Fri, 27 Mar 2009 23:49:20 +0000 (19:49 -0400)] 
Added a function for the EXP formula.

15 years agoAdded a couple extra female back sprite flags, new in Platinum.
Eevee [Thu, 26 Mar 2009 00:48:36 +0000 (20:48 -0400)] 
Added a couple extra female back sprite flags, new in Platinum.

Renamed the female-sprite columns as for 'gen4' rather than 'dp'.

15 years agoFixed CSV import's handling of Boolean columns.
Eevee [Thu, 26 Mar 2009 00:43:09 +0000 (20:43 -0400)] 
Fixed CSV import's handling of Boolean columns.

15 years agoAdded Platinum sprites, excluding Formes.
Eevee [Thu, 26 Mar 2009 00:42:08 +0000 (20:42 -0400)] 
Added Platinum sprites, excluding Formes.

15 years agoAdded Python versions of stat formulae.
Eevee [Mon, 23 Mar 2009 02:07:31 +0000 (22:07 -0400)] 
Added Python versions of stat formulae.

15 years agoMerge branch 'master' of eevee@tekkanin.veekun.com:dev/pokedex
Eevee [Mon, 23 Mar 2009 01:14:44 +0000 (21:14 -0400)] 
Merge branch 'master' of eevee@tekkanin.veekun.com:dev/pokedex

15 years agoAdded generic trainer guy/girl sprites, used for size comparison.
Eevee [Mon, 23 Mar 2009 01:09:16 +0000 (18:09 -0700)] 
Added generic trainer guy/girl sprites, used for size comparison.

15 years agoAdded relations for evolution.
Eevee [Fri, 20 Mar 2009 23:28:41 +0000 (19:28 -0400)] 
Added relations for evolution.

Alternate Formes also now have NULL evolution chain ids.

15 years agoOops. Removed leading zeroes on icons.
Eevee [Fri, 20 Mar 2009 04:05:07 +0000 (00:05 -0400)] 
Oops.  Removed leading zeroes on icons.

15 years agoAdded Pokémon icons.
Eevee [Fri, 20 Mar 2009 04:01:43 +0000 (00:01 -0400)] 
Added Pokémon icons.

15 years agoCSV import now respects NULLability of columns.
Eevee [Mon, 9 Mar 2009 01:34:48 +0000 (21:34 -0400)] 
CSV import now respects NULLability of columns.

Empty strings loaded into NULL columns are changed to NULL instead.

15 years agoFixed some MySQL import problems.
Eevee [Sun, 8 Mar 2009 02:54:01 +0000 (18:54 -0800)] 
Fixed some MySQL import problems.

Tables weren't being defined as UTF-8 if that wasn't the server default.

A lot of tables were trying to create erroneous auto_increment columns.

Foreign key checks were pretty much fucking everything up.

15 years agoAdded SQLAlchemy to setup.py and fixed a typo in .gitignore.
Eevee [Sun, 8 Mar 2009 00:26:57 +0000 (16:26 -0800)] 
Added SQLAlchemy to setup.py and fixed a typo in .gitignore.

15 years agoAdded Pokémon cries.
Eevee [Sat, 7 Mar 2009 04:54:32 +0000 (20:54 -0800)] 
Added Pokémon cries.

15 years agoAdded Diamond/Pearl Pokemon sprites.
Eevee [Sat, 7 Mar 2009 04:21:43 +0000 (20:21 -0800)] 
Added Diamond/Pearl Pokemon sprites.

15 years agoFixed some Platinum sprite naming.
Eevee [Sat, 7 Mar 2009 04:15:19 +0000 (20:15 -0800)] 
Fixed some Platinum sprite naming.

201-f.png had become female/201.png.

Deoxys forms were named after games, rather than stats.

15 years agoAdded habitat sprites. Renamed flavor to flavor_text.
Eevee [Sat, 7 Mar 2009 03:14:42 +0000 (19:14 -0800)] 
Added habitat sprites.  Renamed flavor to flavor_text.

pokemon_flavor_text.flavor -> pokemon_flavor_text.flavor_text

15 years agoMoved images/ to media/.
Eevee [Sat, 7 Mar 2009 01:15:24 +0000 (17:15 -0800)] 
Moved images/ to media/.

Since this directory will shortly contain cries, which are mp3s,
'images' didn't really seem fitting.

15 years agoAdded footprint images.
Eevee [Fri, 6 Mar 2009 05:37:25 +0000 (21:37 -0800)] 
Added footprint images.

15 years agoAdded body shape icons. Oops.
Eevee [Thu, 5 Mar 2009 03:36:09 +0000 (19:36 -0800)] 
Added body shape icons.  Oops.

15 years agoAdded Pokemon body shapes.
Eevee [Thu, 5 Mar 2009 03:29:43 +0000 (19:29 -0800)] 
Added Pokemon body shapes.

15 years agoAdded gender rate bars.
Eevee [Wed, 4 Mar 2009 02:19:48 +0000 (18:19 -0800)] 
Added gender rate bars.

Putting them in here because they strike me as generally useful.

15 years agoRound 1 of version icons!
Eevee [Wed, 4 Mar 2009 01:59:18 +0000 (17:59 -0800)] 
Round 1 of version icons!

15 years agoFew more relations, for egg groups and evo chains.
Eevee [Wed, 4 Mar 2009 01:58:27 +0000 (17:58 -0800)] 
Few more relations, for egg groups and evo chains.

15 years agoAdded region names to the generations table.
Eevee [Wed, 4 Mar 2009 01:58:10 +0000 (17:58 -0800)] 
Added region names to the generations table.

15 years agoAdded a generation_id column to the pokemon table.
Eevee [Mon, 2 Mar 2009 09:06:31 +0000 (01:06 -0800)] 
Added a generation_id column to the pokemon table.

15 years agoAdded sprite frames, used on Pokemon page headers.
Eevee [Mon, 2 Mar 2009 09:05:26 +0000 (01:05 -0800)] 
Added sprite frames, used on Pokemon page headers.

15 years agoAdded contest and type ingame sprites.
Eevee [Mon, 2 Mar 2009 03:49:23 +0000 (19:49 -0800)] 
Added contest and type ingame sprites.

15 years agoAdded more table relations, for spline-pokedex Pokemon page.
Eevee [Mon, 2 Mar 2009 03:40:02 +0000 (19:40 -0800)] 
Added more table relations, for spline-pokedex Pokemon page.

15 years agoAdded Sugimori art. Moves images into data/ folder.
Eevee [Sat, 28 Feb 2009 08:00:39 +0000 (00:00 -0800)] 
Added Sugimori art.  Moves images into data/ folder.

15 years agoFixed Pokemon female-sprite flags.
Eevee [Sat, 28 Feb 2009 02:42:12 +0000 (18:42 -0800)] 
Fixed Pokemon female-sprite flags.

Pokemon that have both a female front and back sprite in Gen IV didn't
import the flags at all.  Some goof on my part.

15 years agoAdded a whole bunch of foreign keys.
Eevee [Tue, 24 Feb 2009 07:31:35 +0000 (23:31 -0800)] 
Added a whole bunch of foreign keys.

15 years agoAdded Trozei sprites.
Eevee [Tue, 24 Feb 2009 02:21:15 +0000 (18:21 -0800)] 
Added Trozei sprites.

15 years agoReverted unnecessary changes to setup.py.
Eevee [Mon, 23 Feb 2009 07:46:25 +0000 (23:46 -0800)] 
Reverted unnecessary changes to setup.py.

15 years agoMoved CSV sources into pokedex/.
Eevee [Mon, 23 Feb 2009 07:44:40 +0000 (23:44 -0800)] 
Moved CSV sources into pokedex/.

This appears to be the only way to make data access in eggs actually
work, and is why the Platinum sprites are in pokedex/ too.

15 years agoAdded Platinum front sprites.
Eevee [Mon, 23 Feb 2009 07:43:33 +0000 (23:43 -0800)] 
Added Platinum front sprites.

15 years agoMade a data/csv directory for CSV sources.
Eevee [Sun, 15 Feb 2009 03:19:19 +0000 (19:19 -0800)] 
Made a data/csv directory for CSV sources.

15 years agoInitial commit, with much of the data imported.
Eevee [Thu, 5 Feb 2009 08:05:42 +0000 (00:05 -0800)] 
Initial commit, with much of the data imported.

Includes a wrapper script 'pokedex' that can, so far, read data from a
db and spit out CSVs or deploy CSVs to a db.