CatTrinket

#!/usr/bin/env python3
"""By starting at the top of the triangle below and moving to adjacent numbers
on the row below, the maximum total from top to bottom is 23.

   3
  7 4
 2 4 6
8 5 9 3

That is, 3 + 7 + 4 + 9 = 23.

CatTrinket

---
# Can't change; forms are actually different in some way
wormadam: >-
    Wormadam's cloaks have different types and movepools.  Its cloak is chosen
    when evolving Burmy, and cannot be changed.

basculin: >-
    Basculin's forms have one different ability.  Its form is chosen when it is
    bought, and cannot be changed.

CatTrinket

Aromatic Mist: The Pokémon emanates a mysterious mist with an unplaceable, yet pleasant aroma, enveloping one of its allies. The target is calmed by the scent, and its Special Defense increases slightly.
Baby-Doll Eyes: The Pokémon makes eye contact with its foe, faking a mournful, pitiable expression that disarms the target and gives them second thoughts about attacking such an innocent creature. As such, the target's Attack is slightly lowered.
Belch: After swallowing its food, the user allows it to stew in its stomach, producing all kinds of noxious gases and fluids. The user then produces a huge belch, buffeting its target with a blast so powerful that it knocks the target right off its feet. This move may only be used after the user has consumed a berry.
Boomburst: The Pokémon creates a horrible cacophony with the strength of a small bomb. Pokémon around it are severely damaged by the sudden, blaring noise.
Celebrate: Summons a box.
Confide: The Pokémon mischievously saunters over to its foe and confiden

CatTrinket

asb_test=> select t.name, count(distinct pf.species_id) from types t
asb_test->     join pokemon_form_types pft on t.id=pft.type_id
asb_test->     join pokemon_forms pf on pft.pokemon_form_id=pf.id
asb_test->     group by t.id
asb_test->     order by count desc;
   name   | count 
----------+-------
 Water    |   120
 Normal   |    97
 Flying   |    94

CatTrinket

pokedex=> select l.identifier lang, ps.identifier pokemon, psn.name from pokemon_species_names psn join pokemon_species ps on psn.pokemon_species_id=ps.id join languages l on psn.local_language_id=l.id where length(name) >= 11 and l.identifier not in ('roomaji', 'es', 'it')  order by l.order, ps.order;
 lang |   pokemon   |     name     
------+-------------+--------------
 en   | fletchinder | Fletchinder
 fr   | chesnaught  | Blindépique
 fr   | diggersby   | Excavarenne
 fr   | scatterbug  | Lépidonille
 fr   | skiddo      | Cabriolaine
 fr   | pancham     | Pandespiègle
 fr   | slurpuff    | Cupcanaille

CatTrinket

[zhorken@yagouaroundi:~/Music] » ls -1 *
Alanis Morissette:
1995 - Jagged Little Pill
2002 - Under Rug Swept
2005 - Jagget Little Pill Acoustic

Alan Menken:
2010 - Tangled

Belly:

CatTrinket

 rate | count |  example   
------+-------+------------
    3 |    45 | articuno
    5 |     2 | kyogre
   15 |     1 | volcarona
   25 |    10 | clefable
   30 |    21 | chansey
   35 |     1 | ditto
   45 |   224 | bulbasaur
   50 |     7 | wigglytuff

CatTrinket

asb_test=> select identifier from pokemon_forms pf where not exists (select 1 from pokemon_form_moves pfm join moves m on pfm.move_id=m.id join types t on m.type_id=t.id where pfm.pokemon_form_id=pf.id and m.damage_class_id != 3 and t.identifier in ('dark', 'fire', 'flying', 'ghost', 'rock')) order by "order";
    identifier     
-------------------
 caterpie
 metapod
 weedle
 kakuna
 oddish
 ditto
 sunkern

CatTrinket

 attacking | defending |       result       
-----------+-----------+--------------------
 normal    | normal    | neutral
 normal    | fire      | neutral
 normal    | water     | neutral
 normal    | grass     | neutral
 normal    | electric  | neutral
 normal    | ice       | neutral
 normal    | fighting  | neutral
 normal    | poison    | neutral

CatTrinket

 identifier | base_happiness 
------------+----------------
 pichu      |             70
 pikachu    |             70
 cleffa     |            140
 clefairy   |            140
 igglybuff  |             70
 jigglypuff |             70
 golbat     |             70
 crobat     |             70