Very simple items table and wild held item data. #10

diff --git a/pokedex/data/csv/items.csv b/pokedex/data/csv/items.csv
new file mode 100644 (file)
index 0000000..edb3fa5
--- /dev/null
+++ b/pokedex/data/csv/items.csv
@@ -0,0 +1,442 @@
+id,name
+1,Master Ball
+2,Ultra Ball
+3,Great Ball
+4,Poke Ball
+5,Safari Ball
+6,Net Ball
+7,Dive Ball
+8,Nest Ball
+9,Repeat Ball
+10,Timer Ball
+11,Luxury Ball
+12,Premier Ball
+13,Dusk Ball
+14,Heal Ball
+15,Quick Ball
+16,Cherish Ball
+17,Potion
+18,Antidote
+19,Burn Heal
+20,Ice Heal
+21,Awakening
+22,Parlyz Heal
+23,Full Restore
+24,Max Potion
+25,Hyper Potion
+26,Super Potion
+27,Full Heal
+28,Revive
+29,Max Revive
+30,Fresh Water
+31,Soda Pop
+32,Lemonade
+33,Moomoo Milk
+34,EnergyPowder
+35,Energy Root
+36,Heal Powder
+37,Revival Herb
+38,Ether
+39,Max Ether
+40,Elixir
+41,Max Elixir
+42,Lava Cookie
+43,Berry Juice
+44,Sacred Ash
+45,HP Up
+46,Protein
+47,Iron
+48,Carbos
+49,Calcium
+50,Rare Candy
+51,PP Up
+52,Zinc
+53,PP Max
+54,Old Gateau
+55,Guard Spec.
+56,Dire Hit
+57,X Attack
+58,X Defend
+59,X Speed
+60,X Accuracy
+61,X Special
+62,X Sp. Def
+63,Poke Doll
+64,Fluffy Tail
+65,Blue Flute
+66,Yellow Flute
+67,Red Flute
+68,Black Flute
+69,White Flute
+70,Shoal Salt
+71,Shoal Shell
+72,Red Shard
+73,Blue Shard
+74,Yellow Shard
+75,Green Shard
+76,Super Repel
+77,Max Repel
+78,Escape Rope
+79,Repel
+80,Sun Stone
+81,Moon Stone
+82,Fire Stone
+83,Thunderstone
+84,Water Stone
+85,Leaf Stone
+86,TinyMushroom
+87,Big Mushroom
+88,Pearl
+89,Big Pearl
+90,Stardust
+91,Star Piece
+92,Nugget
+93,Heart Scale
+94,Honey
+95,Growth Mulch
+96,Damp Mulch
+97,Stable Mulch
+98,Gooey Mulch
+99,Root Fossil
+100,Claw Fossil
+101,Helix Fossil
+102,Dome Fossil
+103,Old Amber
+104,Armor Fossil
+105,Skull Fossil
+106,Rare Bone
+107,Shiny Stone
+108,Dusk Stone
+109,Dawn Stone
+110,Oval Stone
+111,Odd Keystone
+112,Adamant Orb
+113,Lustrous Orb
+114,Grass Mail
+115,Flame Mail
+116,Bubble Mail
+117,Bloom Mail
+118,Tunnel Mail
+119,Steel Mail
+120,Heart Mail
+121,Snow Mail
+122,Space Mail
+123,Air Mail
+124,Mosaic Mail
+125,Brick Mail
+126,Cheri Berry
+127,Chesto Berry
+128,Pecha Berry
+129,Rawst Berry
+130,Aspear Berry
+131,Leppa Berry
+132,Oran Berry
+133,Persim Berry
+134,Lum Berry
+135,Sitrus Berry
+136,Figy Berry
+137,Wiki Berry
+138,Mago Berry
+139,Aguav Berry
+140,Iapapa Berry
+141,Razz Berry
+142,Bluk Berry
+143,Nanab Berry
+144,Wepear Berry
+145,Pinap Berry
+146,Pomeg Berry
+147,Kelpsy Berry
+148,Qualot Berry
+149,Hondew Berry
+150,Grepa Berry
+151,Tamato Berry
+152,Cornn Berry
+153,Magost Berry
+154,Rabuta Berry
+155,Nomel Berry
+156,Spelon Berry
+157,Pamtre Berry
+158,Watmel Berry
+159,Durin Berry
+160,Belue Berry
+161,Occa Berry
+162,Passho Berry
+163,Wacan Berry
+164,Rindo Berry
+165,Yache Berry
+166,Chople Berry
+167,Kebia Berry
+168,Shuca Berry
+169,Coba Berry
+170,Payapa Berry
+171,Tanga Berry
+172,Charti Berry
+173,Kasib Berry
+174,Haban Berry
+175,Colbur Berry
+176,Babiri Berry
+177,Chilan Berry
+178,Liechi Berry
+179,Ganlon Berry
+180,Salac Berry
+181,Petaya Berry
+182,Apicot Berry
+183,Lansat Berry
+184,Starf Berry
+185,Enigma Berry
+186,Micle Berry
+187,Custap Berry
+188,Jaboca Berry
+189,Rowap Berry
+190,BrightPowder
+191,White Herb
+192,Macho Brace
+193,Exp. Share
+194,Quick Claw
+195,Soothe Bell
+196,Mental Herb
+197,Choice Band
+198,King's Rock
+199,SilverPowder
+200,Amulet Coin
+201,Cleanse Tag
+202,Soul Dew
+203,DeepSeaTooth
+204,DeepSeaScale
+205,Smoke Ball
+206,Everstone
+207,Focus Band
+208,Lucky Egg
+209,Scope Lens
+210,Metal Coat
+211,Leftovers
+212,Dragon Scale
+213,Light Ball
+214,Soft Sand
+215,Hard Stone
+216,Miracle Seed
+217,BlackGlasses
+218,Black Belt
+219,Magnet
+220,Mystic Water
+221,Sharp Beak
+222,Poison Barb
+223,NeverMeltIce
+224,Spell Tag
+225,TwistedSpoon
+226,Charcoal
+227,Dragon Fang
+228,Silk Scarf
+229,Up-Grade
+230,Shell Bell
+231,Sea Incense
+232,Lax Incense
+233,Lucky Punch
+234,Metal Powder
+235,Thick Club
+236,Stick
+237,Red Scarf
+238,Blue Scarf
+239,Pink Scarf
+240,Green Scarf
+241,Yellow Scarf
+242,Wide Lens
+243,Muscle Band
+244,Wise Glasses
+245,Expert Belt
+246,Light Clay
+247,Life Orb
+248,Power Herb
+249,Toxic Orb
+250,Flame Orb
+251,Quick Powder
+252,Focus Sash
+253,Zoom Lens
+254,Metronome
+255,Iron Ball
+256,Lagging Tail
+257,Destiny Knot
+258,Black Sludge
+259,Icy Rock
+260,Smooth Rock
+261,Heat Rock
+262,Damp Rock
+263,Grip Claw
+264,Choice Scarf
+265,Sticky Barb
+266,Power Bracer
+267,Power Belt
+268,Power Lens
+269,Power Band
+270,Power Anklet
+271,Power Weight
+272,Shed Shell
+273,Big Root
+274,Choice Specs
+275,Flame Plate
+276,Splash Plate
+277,Zap Plate
+278,Meadow Plate
+279,Icicle Plate
+280,Fist Plate
+281,Toxic Plate
+282,Earth Plate
+283,Sky Plate
+284,Mind Plate
+285,Insect Plate
+286,Stone Plate
+287,Spooky Plate
+288,Draco Plate
+289,Dread Plate
+290,Iron Plate
+291,Odd Incense
+292,Rock Incense
+293,Full Incense
+294,Wave Incense
+295,Rose Incense
+296,Luck Incense
+297,Pure Incense
+298,Protector
+299,Electirizer
+300,Magmarizer
+301,Dubious Disc
+302,Reaper Cloth
+303,Razor Claw
+304,Razor Fang
+305,TM01
+306,TM02
+307,TM03
+308,TM04
+309,TM05
+310,TM06
+311,TM07
+312,TM08
+313,TM09
+314,TM10
+315,TM11
+316,TM12
+317,TM13
+318,TM14
+319,TM15
+320,TM16
+321,TM17
+322,TM18
+323,TM19
+324,TM20
+325,TM21
+326,TM22
+327,TM23
+328,TM24
+329,TM25
+330,TM26
+331,TM27
+332,TM28
+333,TM29
+334,TM30
+335,TM31
+336,TM32
+337,TM33
+338,TM34
+339,TM35
+340,TM36
+341,TM37
+342,TM38
+343,TM39
+344,TM40
+345,TM41
+346,TM42
+347,TM43
+348,TM44
+349,TM45
+350,TM46
+351,TM47
+352,TM48
+353,TM49
+354,TM50
+355,TM51
+356,TM52
+357,TM53
+358,TM54
+359,TM55
+360,TM56
+361,TM57
+362,TM58
+363,TM59
+364,TM60
+365,TM61
+366,TM62
+367,TM63
+368,TM64
+369,TM65
+370,TM66
+371,TM67
+372,TM68
+373,TM69
+374,TM70
+375,TM71
+376,TM72
+377,TM73
+378,TM74
+379,TM75
+380,TM76
+381,TM77
+382,TM78
+383,TM79
+384,TM80
+385,TM81
+386,TM82
+387,TM83
+388,TM84
+389,TM85
+390,TM86
+391,TM87
+392,TM88
+393,TM89
+394,TM90
+395,TM91
+396,TM92
+397,HM01
+398,HM02
+399,HM03
+400,HM04
+401,HM05
+402,HM06
+403,HM07
+404,HM08
+405,Explorer Kit
+406,Loot Sack
+407,Rule Book
+408,Poke Radar
+409,Point Card
+410,Journal
+411,Seal Case
+412,Fashion Case
+413,Seal Bag
+414,Pal Pad
+415,Works Key
+416,Old Charm
+417,Galactic Key
+418,Red Chain
+419,Town Map
+420,Vs. Seeker
+421,Coin Case
+422,Old Rod
+423,Good Rod
+424,Super Rod
+425,Sprayduck
+426,Poffin Case
+427,Bicycle
+428,Suite Key
+429,Oak's Letter
+430,Lunar Wing
+431,Member Card
+432,Azure Flute
+433,S.S. Ticket
+434,Contest Pass
+435,Magma Stone
+436,Parcel
+437,Coupon 1
+438,Coupon 2
+439,Coupon 3
+440,Storage Key
+441,SecretPotion

diff --git a/pokedex/data/csv/pokemon_items.csv b/pokedex/data/csv/pokemon_items.csv
new file mode 100644 (file)
index 0000000..386fd82
--- /dev/null
+++ b/pokedex/data/csv/pokemon_items.csv
@@ -0,0 +1,676 @@
+pokemon_id,version_id,item_id,rarity
+12,12,199,5
+15,12,222,5
+19,12,177,5
+20,12,177,5
+22,12,221,5
+25,12,132,50
+25,12,213,5
+26,12,132,5
+27,12,194,5
+28,12,194,5
+35,12,81,5
+35,12,131,50
+36,12,81,5
+36,12,131,50
+37,12,129,100
+38,12,129,100
+46,12,86,50
+46,12,87,5
+47,12,86,50
+47,12,87,5
+49,12,272,5
+50,12,214,5
+51,12,214,5
+52,12,194,5
+53,12,194,5
+56,12,170,5
+57,12,170,5
+58,12,129,100
+59,12,129,100
+61,12,198,5
+62,12,198,5
+63,12,225,5
+64,12,225,5
+65,12,225,5
+72,12,222,5
+73,12,222,5
+74,12,206,5
+75,12,206,5
+76,12,206,5
+77,12,168,5
+78,12,168,5
+79,12,256,5
+80,12,198,5
+81,12,210,5
+82,12,210,5
+83,12,236,5
+84,12,221,5
+85,12,221,5
+88,12,92,5
+89,12,92,5
+90,12,88,50
+90,12,89,5
+91,12,88,50
+91,12,89,5
+104,12,235,5
+105,12,235,5
+108,12,256,5
+109,12,205,5
+110,12,205,5
+113,12,110,50
+113,12,208,5
+116,12,212,5
+117,12,212,5
+120,12,90,50
+120,12,91,5
+121,12,90,50
+121,12,91,5
+122,12,131,5
+124,12,130,100
+125,12,299,50
+126,12,300,5
+132,12,234,5
+132,12,251,50
+143,12,211,100
+147,12,212,5
+148,12,212,5
+149,12,212,5
+151,12,134,100
+161,12,132,5
+162,12,132,50
+162,12,135,5
+170,12,204,5
+171,12,204,5
+172,12,132,5
+173,12,81,5
+173,12,131,50
+186,12,198,5
+191,12,169,5
+193,12,242,5
+199,12,198,5
+203,12,133,5
+208,12,210,5
+211,12,222,5
+213,12,132,100
+215,12,194,5
+215,12,263,50
+222,12,215,5
+230,12,212,5
+231,12,162,5
+232,12,162,5
+238,12,130,100
+239,12,299,50
+240,12,300,5
+241,12,33,100
+242,12,110,50
+242,12,208,5
+250,12,44,100
+251,12,134,100
+261,12,128,5
+262,12,128,5
+263,12,132,5
+264,12,132,50
+264,12,135,5
+267,12,272,5
+269,12,272,5
+276,12,172,5
+277,12,172,5
+284,12,199,5
+285,12,167,5
+286,12,167,5
+293,12,127,5
+294,12,127,5
+295,12,127,5
+297,12,198,5
+299,12,215,5
+300,12,131,5
+301,12,131,5
+303,12,161,5
+304,12,215,5
+305,12,215,5
+306,12,215,5
+315,12,222,5
+316,12,89,5
+317,12,89,5
+318,12,203,5
+319,12,203,5
+322,12,129,100
+323,12,129,100
+325,12,171,5
+326,12,171,5
+327,12,127,5
+328,12,214,5
+331,12,265,5
+332,12,265,5
+335,12,194,5
+337,12,81,5
+338,12,80,5
+345,12,273,5
+346,12,273,5
+351,12,220,100
+352,12,133,5
+353,12,224,5
+354,12,224,5
+355,12,173,5
+356,12,173,5
+358,12,175,5
+361,12,176,5
+362,12,176,5
+366,12,89,5
+367,12,203,5
+368,12,204,5
+369,12,204,5
+370,12,93,50
+371,12,227,5
+372,12,227,5
+373,12,227,5
+374,12,210,5
+375,12,210,5
+376,12,210,5
+385,12,91,100
+396,12,165,5
+397,12,165,5
+398,12,165,5
+400,12,132,50
+400,12,135,5
+401,12,254,5
+402,12,254,5
+406,12,222,5
+407,12,222,5
+413,12,199,5
+414,12,199,5
+415,12,94,100
+416,12,222,5
+418,12,163,5
+419,12,163,5
+420,12,216,5
+421,12,216,5
+427,12,166,5
+428,12,166,5
+431,12,126,5
+432,12,126,5
+433,12,175,5
+434,12,128,5
+435,12,128,5
+436,12,210,5
+437,12,210,5
+439,12,131,5
+440,12,110,50
+440,12,233,5
+441,12,254,5
+443,12,174,5
+444,12,174,5
+445,12,174,5
+446,12,211,100
+451,12,222,5
+452,12,222,5
+453,12,258,5
+454,12,258,5
+456,12,164,5
+457,12,164,5
+459,12,223,5
+460,12,223,5
+461,12,194,5
+461,12,263,50
+462,12,210,5
+463,12,256,5
+466,12,299,50
+467,12,300,5
+469,12,242,5
+476,12,215,5
+477,12,173,5
+478,12,176,5
+492,12,134,100
+499,12,199,5
+500,12,199,5
+12,13,199,5
+15,13,222,5
+19,13,177,5
+20,13,177,5
+22,13,221,5
+25,13,132,50
+25,13,213,5
+26,13,132,5
+27,13,194,5
+28,13,194,5
+35,13,81,5
+35,13,131,50
+36,13,81,5
+36,13,131,50
+37,13,129,100
+38,13,129,100
+46,13,86,50
+46,13,87,5
+47,13,86,50
+47,13,87,5
+49,13,272,5
+50,13,214,5
+51,13,214,5
+52,13,194,5
+53,13,194,5
+56,13,170,5
+57,13,170,5
+58,13,129,100
+59,13,129,100
+61,13,198,5
+62,13,198,5
+63,13,225,5
+64,13,225,5
+65,13,225,5
+72,13,222,5
+73,13,222,5
+74,13,206,5
+75,13,206,5
+76,13,206,5
+77,13,168,5
+78,13,168,5
+79,13,256,5
+80,13,198,5
+81,13,210,5
+82,13,210,5
+83,13,236,5
+84,13,221,5
+85,13,221,5
+88,13,92,5
+89,13,92,5
+90,13,88,50
+90,13,89,5
+91,13,88,50
+91,13,89,5
+104,13,235,5
+105,13,235,5
+108,13,256,5
+109,13,205,5
+110,13,205,5
+113,13,110,50
+113,13,208,5
+116,13,212,5
+117,13,212,5
+120,13,90,50
+120,13,91,5
+121,13,90,50
+121,13,91,5
+122,13,131,5
+124,13,130,100
+125,13,299,5
+126,13,300,50
+132,13,234,5
+132,13,251,50
+143,13,211,100
+147,13,212,5
+148,13,212,5
+149,13,212,5
+151,13,134,100
+161,13,132,5
+162,13,132,50
+162,13,135,5
+170,13,204,5
+171,13,204,5
+172,13,132,5
+173,13,81,5
+173,13,131,50
+186,13,198,5
+191,13,169,5
+193,13,242,5
+199,13,198,5
+203,13,133,5
+208,13,210,5
+211,13,222,5
+213,13,132,100
+215,13,194,5
+215,13,263,50
+222,13,215,5
+230,13,212,5
+231,13,162,5
+232,13,162,5
+238,13,130,100
+239,13,299,5
+240,13,300,50
+241,13,33,100
+242,13,110,50
+242,13,208,5
+250,13,44,100
+251,13,134,100
+261,13,128,5
+262,13,128,5
+263,13,132,5
+264,13,132,50
+264,13,135,5
+267,13,272,5
+269,13,272,5
+276,13,172,5
+277,13,172,5
+284,13,199,5
+285,13,167,5
+286,13,167,5
+293,13,127,5
+294,13,127,5
+295,13,127,5
+297,13,198,5
+299,13,215,5
+300,13,131,5
+301,13,131,5
+303,13,161,5
+304,13,215,5
+305,13,215,5
+306,13,215,5
+315,13,222,5
+316,13,89,5
+317,13,89,5
+318,13,203,5
+319,13,203,5
+322,13,129,100
+323,13,129,100
+325,13,171,5
+326,13,171,5
+327,13,127,5
+328,13,214,5
+331,13,265,5
+332,13,265,5
+335,13,194,5
+337,13,81,5
+338,13,80,5
+345,13,273,5
+346,13,273,5
+351,13,220,100
+352,13,133,5
+353,13,224,5
+354,13,224,5
+355,13,173,5
+356,13,173,5
+358,13,175,5
+361,13,176,5
+362,13,176,5
+366,13,89,5
+367,13,203,5
+368,13,204,5
+369,13,204,5
+370,13,93,50
+371,13,227,5
+372,13,227,5
+373,13,227,5
+374,13,210,5
+375,13,210,5
+376,13,210,5
+385,13,91,100
+396,13,165,5
+397,13,165,5
+398,13,165,5
+400,13,132,50
+400,13,135,5
+401,13,254,5
+402,13,254,5
+406,13,222,5
+407,13,222,5
+413,13,199,5
+414,13,199,5
+415,13,94,100
+416,13,222,5
+418,13,163,5
+419,13,163,5
+420,13,216,5
+421,13,216,5
+427,13,166,5
+428,13,166,5
+431,13,126,5
+432,13,126,5
+433,13,175,5
+434,13,128,5
+435,13,128,5
+436,13,210,5
+437,13,210,5
+439,13,131,5
+440,13,110,50
+440,13,233,5
+441,13,254,5
+443,13,174,5
+444,13,174,5
+445,13,174,5
+446,13,211,100
+451,13,222,5
+452,13,222,5
+453,13,258,5
+454,13,258,5
+456,13,164,5
+457,13,164,5
+459,13,223,5
+460,13,223,5
+461,13,194,5
+461,13,263,50
+462,13,210,5
+463,13,256,5
+466,13,299,5
+467,13,300,50
+469,13,242,5
+476,13,215,5
+477,13,173,5
+478,13,176,5
+492,13,134,100
+499,13,199,5
+500,13,199,5
+12,14,199,5
+15,14,222,5
+19,14,177,5
+20,14,177,5
+22,14,221,5
+25,14,132,50
+25,14,213,5
+26,14,132,5
+27,14,194,5
+28,14,194,5
+35,14,81,5
+35,14,131,50
+36,14,81,5
+36,14,131,50
+37,14,129,100
+38,14,129,100
+46,14,86,50
+46,14,87,5
+47,14,86,50
+47,14,87,5
+49,14,272,5
+50,14,214,5
+51,14,214,5
+52,14,194,5
+53,14,194,5
+56,14,170,5
+57,14,170,5
+58,14,129,100
+59,14,129,100
+61,14,198,5
+62,14,198,5
+63,14,225,5
+64,14,225,5
+65,14,225,5
+72,14,222,5
+73,14,222,5
+74,14,206,5
+75,14,206,5
+76,14,206,5
+77,14,168,5
+78,14,168,5
+79,14,256,5
+80,14,198,5
+81,14,210,5
+82,14,210,5
+83,14,236,5
+84,14,221,5
+85,14,221,5
+88,14,92,5
+89,14,92,5
+90,14,88,50
+90,14,89,5
+91,14,88,50
+91,14,89,5
+104,14,235,5
+105,14,235,5
+108,14,256,5
+109,14,205,5
+110,14,205,5
+113,14,110,50
+113,14,208,5
+116,14,212,5
+117,14,212,5
+120,14,90,50
+120,14,91,5
+121,14,90,50
+121,14,91,5
+122,14,131,5
+124,14,130,100
+125,14,299,50
+126,14,300,50
+132,14,234,5
+132,14,251,50
+143,14,211,100
+147,14,212,5
+148,14,212,5
+149,14,212,5
+151,14,134,100
+161,14,132,5
+162,14,132,50
+162,14,135,5
+170,14,204,5
+171,14,204,5
+172,14,132,5
+173,14,81,5
+173,14,131,50
+186,14,198,5
+191,14,169,5
+193,14,242,5
+199,14,198,5
+203,14,133,5
+208,14,210,5
+211,14,222,5
+213,14,132,100
+215,14,194,5
+215,14,263,50
+222,14,215,5
+230,14,212,5
+231,14,162,5
+232,14,162,5
+238,14,130,100
+239,14,299,50
+240,14,300,50
+241,14,33,100
+242,14,110,50
+242,14,208,5
+250,14,44,100
+251,14,134,100
+261,14,128,5
+262,14,128,5
+263,14,132,5
+264,14,132,50
+264,14,135,5
+267,14,272,5
+269,14,272,5
+276,14,172,5
+277,14,172,5
+284,14,199,5
+285,14,167,5
+286,14,167,5
+293,14,127,5
+294,14,127,5
+295,14,127,5
+297,14,198,5
+299,14,215,5
+300,14,131,5
+301,14,131,5
+303,14,161,5
+304,14,215,5
+305,14,215,5
+306,14,215,5
+315,14,222,5
+316,14,89,5
+317,14,89,5
+318,14,203,5
+319,14,203,5
+322,14,129,100
+323,14,129,100
+325,14,171,5
+326,14,171,5
+327,14,127,5
+328,14,214,5
+331,14,265,5
+332,14,265,5
+335,14,194,5
+337,14,81,5
+338,14,80,5
+345,14,273,5
+346,14,273,5
+351,14,220,100
+352,14,133,5
+353,14,224,5
+354,14,224,5
+355,14,173,5
+356,14,173,5
+358,14,175,5
+361,14,176,5
+362,14,176,5
+366,14,89,5
+367,14,203,5
+368,14,204,5
+369,14,204,5
+370,14,93,50
+371,14,227,5
+372,14,227,5
+373,14,227,5
+374,14,210,5
+375,14,210,5
+376,14,210,5
+385,14,91,100
+396,14,165,5
+397,14,165,5
+398,14,165,5
+400,14,132,50
+400,14,135,5
+401,14,254,5
+402,14,254,5
+406,14,222,5
+407,14,222,5
+413,14,199,5
+414,14,199,5
+415,14,94,100
+416,14,222,5
+418,14,163,5
+419,14,163,5
+420,14,216,5
+421,14,216,5
+427,14,166,5
+428,14,166,5
+431,14,126,5
+432,14,126,5
+433,14,175,5
+434,14,128,5
+435,14,128,5
+436,14,210,5
+437,14,210,5
+439,14,131,5
+440,14,110,50
+440,14,233,5
+441,14,254,5
+443,14,174,5
+444,14,174,5
+445,14,174,5
+446,14,211,100
+451,14,222,5
+452,14,222,5
+453,14,258,5
+454,14,258,5
+456,14,164,5
+457,14,164,5
+459,14,223,5
+460,14,223,5
+461,14,194,5
+461,14,263,50
+462,14,210,5
+463,14,256,5
+466,14,299,50
+467,14,300,50
+469,14,242,5
+476,14,215,5
+477,14,173,5
+478,14,176,5
+492,14,134,100
+499,14,199,5
+500,14,199,5

diff --git a/pokedex/db/tables.py b/pokedex/db/tables.py
index 3638e53..4d542e9 100644 (file)
--- a/pokedex/db/tables.py
+++ b/pokedex/db/tables.py
@@ -132,6 +132,11 @@ class GrowthRate(TableBase):
     name = Column(Unicode(16), nullable=False)
     formula = Column(Unicode(255), nullable=False)
 
     name = Column(Unicode(16), nullable=False)
     formula = Column(Unicode(255), nullable=False)
 

+class Item(TableBase):
+    __tablename__ = 'items'
+    id = Column(Integer, primary_key=True, nullable=False)
+    name = Column(Unicode(16), nullable=False)
+

 class Language(TableBase):
     __tablename__ = 'languages'
     id = Column(Integer, primary_key=True, nullable=False)
 class Language(TableBase):
     __tablename__ = 'languages'
     id = Column(Integer, primary_key=True, nullable=False)


@@ -278,6 +283,13 @@ class PokemonFormSprite(TableBase):
     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
     name = Column(Unicode(16), nullable=True)
 
     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
     name = Column(Unicode(16), nullable=True)
 

+class PokemonItem(TableBase):
+    __tablename__ = 'pokemon_items'
+    pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
+    version_id = Column(Integer, ForeignKey('versions.id'), primary_key=True, nullable=False, autoincrement=False)
+    item_id = Column(Integer, ForeignKey('items.id'), primary_key=True, nullable=False, autoincrement=False)
+    rarity = Column(Integer, nullable=False)
+

 class PokemonName(TableBase):
     __tablename__ = 'pokemon_names'
     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 class PokemonName(TableBase):
     __tablename__ = 'pokemon_names'
     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)


@@ -365,6 +377,7 @@ Pokemon.evolution_children = relation(Pokemon, primaryjoin=Pokemon.id==Pokemon.e
                                                                remote_side=[Pokemon.id]))
 Pokemon.flavor_text = relation(PokemonFlavorText, backref='pokemon')
 Pokemon.foreign_names = relation(PokemonName, backref='pokemon')
                                                                remote_side=[Pokemon.id]))
 Pokemon.flavor_text = relation(PokemonFlavorText, backref='pokemon')
 Pokemon.foreign_names = relation(PokemonName, backref='pokemon')

+Pokemon.items = relation(PokemonItem)

 Pokemon.generation = relation(Generation, backref='pokemon')
 Pokemon.shape = relation(PokemonShape, backref='pokemon')
 Pokemon.stats = relation(PokemonStat, backref='pokemon')
 Pokemon.generation = relation(Generation, backref='pokemon')
 Pokemon.shape = relation(PokemonShape, backref='pokemon')
 Pokemon.stats = relation(PokemonStat, backref='pokemon')


@@ -374,6 +387,9 @@ PokemonDexNumber.generation = relation(Generation)
 
 PokemonFlavorText.version = relation(Version)
 
 
 PokemonFlavorText.version = relation(Version)
 

+PokemonItem.item = relation(Item, backref='pokemon')
+PokemonItem.version = relation(Version)
+

 PokemonFormGroup.pokemon = relation(Pokemon, backref=backref('form_group',
                                                              uselist=False))
 PokemonFormSprite.pokemon = relation(Pokemon, backref='form_sprites')
 PokemonFormGroup.pokemon = relation(Pokemon, backref=backref('form_group',
                                                              uselist=False))
 PokemonFormSprite.pokemon = relation(Pokemon, backref='form_sprites')