From faeded73f393561d41b73559c726dbdc2f70947d Mon Sep 17 00:00:00 2001 From: a_magical_me Date: Mon, 26 Apr 2010 04:27:55 -0700 Subject: [PATCH] Add experience tables. --- pokedex/data/csv/experience.csv | 601 ++++++++++++++++++++++++++++++++++++++++ pokedex/db/tables.py | 8 + 2 files changed, 609 insertions(+) create mode 100644 pokedex/data/csv/experience.csv diff --git a/pokedex/data/csv/experience.csv b/pokedex/data/csv/experience.csv new file mode 100644 index 0000000..40edfd5 --- /dev/null +++ b/pokedex/data/csv/experience.csv @@ -0,0 +1,601 @@ +growth_rate_id,level,experience +1,1,0 +1,2,10 +1,3,33 +1,4,80 +1,5,156 +1,6,270 +1,7,428 +1,8,640 +1,9,911 +1,10,1250 +1,11,1663 +1,12,2160 +1,13,2746 +1,14,3430 +1,15,4218 +1,16,5120 +1,17,6141 +1,18,7290 +1,19,8573 +1,20,10000 +1,21,11576 +1,22,13310 +1,23,15208 +1,24,17280 +1,25,19531 +1,26,21970 +1,27,24603 +1,28,27440 +1,29,30486 +1,30,33750 +1,31,37238 +1,32,40960 +1,33,44921 +1,34,49130 +1,35,53593 +1,36,58320 +1,37,63316 +1,38,68590 +1,39,74148 +1,40,80000 +1,41,86151 +1,42,92610 +1,43,99383 +1,44,106480 +1,45,113906 +1,46,121670 +1,47,129778 +1,48,138240 +1,49,147061 +1,50,156250 +1,51,165813 +1,52,175760 +1,53,186096 +1,54,196830 +1,55,207968 +1,56,219520 +1,57,231491 +1,58,243890 +1,59,256723 +1,60,270000 +1,61,283726 +1,62,297910 +1,63,312558 +1,64,327680 +1,65,343281 +1,66,359370 +1,67,375953 +1,68,393040 +1,69,410636 +1,70,428750 +1,71,447388 +1,72,466560 +1,73,486271 +1,74,506530 +1,75,527343 +1,76,548720 +1,77,570666 +1,78,593190 +1,79,616298 +1,80,640000 +1,81,664301 +1,82,689210 +1,83,714733 +1,84,740880 +1,85,767656 +1,86,795070 +1,87,823128 +1,88,851840 +1,89,881211 +1,90,911250 +1,91,941963 +1,92,973360 +1,93,1005446 +1,94,1038230 +1,95,1071718 +1,96,1105920 +1,97,1140841 +1,98,1176490 +1,99,1212873 +1,100,1250000 +2,1,0 +2,2,8 +2,3,27 +2,4,64 +2,5,125 +2,6,216 +2,7,343 +2,8,512 +2,9,729 +2,10,1000 +2,11,1331 +2,12,1728 +2,13,2197 +2,14,2744 +2,15,3375 +2,16,4096 +2,17,4913 +2,18,5832 +2,19,6859 +2,20,8000 +2,21,9261 +2,22,10648 +2,23,12167 +2,24,13824 +2,25,15625 +2,26,17576 +2,27,19683 +2,28,21952 +2,29,24389 +2,30,27000 +2,31,29791 +2,32,32768 +2,33,35937 +2,34,39304 +2,35,42875 +2,36,46656 +2,37,50653 +2,38,54872 +2,39,59319 +2,40,64000 +2,41,68921 +2,42,74088 +2,43,79507 +2,44,85184 +2,45,91125 +2,46,97336 +2,47,103823 +2,48,110592 +2,49,117649 +2,50,125000 +2,51,132651 +2,52,140608 +2,53,148877 +2,54,157464 +2,55,166375 +2,56,175616 +2,57,185193 +2,58,195112 +2,59,205379 +2,60,216000 +2,61,226981 +2,62,238328 +2,63,250047 +2,64,262144 +2,65,274625 +2,66,287496 +2,67,300763 +2,68,314432 +2,69,328509 +2,70,343000 +2,71,357911 +2,72,373248 +2,73,389017 +2,74,405224 +2,75,421875 +2,76,438976 +2,77,456533 +2,78,474552 +2,79,493039 +2,80,512000 +2,81,531441 +2,82,551368 +2,83,571787 +2,84,592704 +2,85,614125 +2,86,636056 +2,87,658503 +2,88,681472 +2,89,704969 +2,90,729000 +2,91,753571 +2,92,778688 +2,93,804357 +2,94,830584 +2,95,857375 +2,96,884736 +2,97,912673 +2,98,941192 +2,99,970299 +2,100,1000000 +3,1,0 +3,2,6 +3,3,21 +3,4,51 +3,5,100 +3,6,172 +3,7,274 +3,8,409 +3,9,583 +3,10,800 +3,11,1064 +3,12,1382 +3,13,1757 +3,14,2195 +3,15,2700 +3,16,3276 +3,17,3930 +3,18,4665 +3,19,5487 +3,20,6400 +3,21,7408 +3,22,8518 +3,23,9733 +3,24,11059 +3,25,12500 +3,26,14060 +3,27,15746 +3,28,17561 +3,29,19511 +3,30,21600 +3,31,23832 +3,32,26214 +3,33,28749 +3,34,31443 +3,35,34300 +3,36,37324 +3,37,40522 +3,38,43897 +3,39,47455 +3,40,51200 +3,41,55136 +3,42,59270 +3,43,63605 +3,44,68147 +3,45,72900 +3,46,77868 +3,47,83058 +3,48,88473 +3,49,94119 +3,50,100000 +3,51,106120 +3,52,112486 +3,53,119101 +3,54,125971 +3,55,133100 +3,56,140492 +3,57,148154 +3,58,156089 +3,59,164303 +3,60,172800 +3,61,181584 +3,62,190662 +3,63,200037 +3,64,209715 +3,65,219700 +3,66,229996 +3,67,240610 +3,68,251545 +3,69,262807 +3,70,274400 +3,71,286328 +3,72,298598 +3,73,311213 +3,74,324179 +3,75,337500 +3,76,351180 +3,77,365226 +3,78,379641 +3,79,394431 +3,80,409600 +3,81,425152 +3,82,441094 +3,83,457429 +3,84,474163 +3,85,491300 +3,86,508844 +3,87,526802 +3,88,545177 +3,89,563975 +3,90,583200 +3,91,602856 +3,92,622950 +3,93,643485 +3,94,664467 +3,95,685900 +3,96,707788 +3,97,730138 +3,98,752953 +3,99,776239 +3,100,800000 +4,1,0 +4,2,9 +4,3,57 +4,4,96 +4,5,135 +4,6,179 +4,7,236 +4,8,314 +4,9,419 +4,10,560 +4,11,742 +4,12,973 +4,13,1261 +4,14,1612 +4,15,2035 +4,16,2535 +4,17,3120 +4,18,3798 +4,19,4575 +4,20,5460 +4,21,6458 +4,22,7577 +4,23,8825 +4,24,10208 +4,25,11735 +4,26,13411 +4,27,15244 +4,28,17242 +4,29,19411 +4,30,21760 +4,31,24294 +4,32,27021 +4,33,29949 +4,34,33084 +4,35,36435 +4,36,40007 +4,37,43808 +4,38,47846 +4,39,52127 +4,40,56660 +4,41,61450 +4,42,66505 +4,43,71833 +4,44,77440 +4,45,83335 +4,46,89523 +4,47,96012 +4,48,102810 +4,49,109923 +4,50,117360 +4,51,125126 +4,52,133229 +4,53,141677 +4,54,150476 +4,55,159635 +4,56,169159 +4,57,179056 +4,58,189334 +4,59,199999 +4,60,211060 +4,61,222522 +4,62,234393 +4,63,246681 +4,64,259392 +4,65,272535 +4,66,286115 +4,67,300140 +4,68,314618 +4,69,329555 +4,70,344960 +4,71,360838 +4,72,377197 +4,73,394045 +4,74,411388 +4,75,429235 +4,76,447591 +4,77,466464 +4,78,485862 +4,79,505791 +4,80,526260 +4,81,547274 +4,82,568841 +4,83,590969 +4,84,613664 +4,85,636935 +4,86,660787 +4,87,685228 +4,88,710266 +4,89,735907 +4,90,762160 +4,91,789030 +4,92,816525 +4,93,844653 +4,94,873420 +4,95,902835 +4,96,932903 +4,97,963632 +4,98,995030 +4,99,1027103 +4,100,1059860 +5,1,0 +5,2,15 +5,3,52 +5,4,122 +5,5,237 +5,6,406 +5,7,637 +5,8,942 +5,9,1326 +5,10,1800 +5,11,2369 +5,12,3041 +5,13,3822 +5,14,4719 +5,15,5737 +5,16,6881 +5,17,8155 +5,18,9564 +5,19,11111 +5,20,12800 +5,21,14632 +5,22,16610 +5,23,18737 +5,24,21012 +5,25,23437 +5,26,26012 +5,27,28737 +5,28,31610 +5,29,34632 +5,30,37800 +5,31,41111 +5,32,44564 +5,33,48155 +5,34,51881 +5,35,55737 +5,36,59719 +5,37,63822 +5,38,68041 +5,39,72369 +5,40,76800 +5,41,81326 +5,42,85942 +5,43,90637 +5,44,95406 +5,45,100237 +5,46,105122 +5,47,110052 +5,48,115015 +5,49,120001 +5,50,125000 +5,51,131324 +5,52,137795 +5,53,144410 +5,54,151165 +5,55,158056 +5,56,165079 +5,57,172229 +5,58,179503 +5,59,186894 +5,60,194400 +5,61,202013 +5,62,209728 +5,63,217540 +5,64,225443 +5,65,233431 +5,66,241496 +5,67,249633 +5,68,257834 +5,69,267406 +5,70,276458 +5,71,286328 +5,72,296358 +5,73,305767 +5,74,316074 +5,75,326531 +5,76,336255 +5,77,346965 +5,78,357812 +5,79,367807 +5,80,378880 +5,81,390077 +5,82,400293 +5,83,411686 +5,84,423190 +5,85,433572 +5,86,445239 +5,87,457001 +5,88,467489 +5,89,479378 +5,90,491346 +5,91,501878 +5,92,513934 +5,93,526049 +5,94,536557 +5,95,548720 +5,96,560922 +5,97,571333 +5,98,583539 +5,99,591882 +5,100,600000 +6,1,0 +6,2,4 +6,3,13 +6,4,32 +6,5,65 +6,6,112 +6,7,178 +6,8,276 +6,9,393 +6,10,540 +6,11,745 +6,12,967 +6,13,1230 +6,14,1591 +6,15,1957 +6,16,2457 +6,17,3046 +6,18,3732 +6,19,4526 +6,20,5440 +6,21,6482 +6,22,7666 +6,23,9003 +6,24,10506 +6,25,12187 +6,26,14060 +6,27,16140 +6,28,18439 +6,29,20974 +6,30,23760 +6,31,26811 +6,32,30146 +6,33,33780 +6,34,37731 +6,35,42017 +6,36,46656 +6,37,50653 +6,38,55969 +6,39,60505 +6,40,66560 +6,41,71677 +6,42,78533 +6,43,84277 +6,44,91998 +6,45,98415 +6,46,107069 +6,47,114205 +6,48,123863 +6,49,131766 +6,50,142500 +6,51,151222 +6,52,163105 +6,53,172697 +6,54,185807 +6,55,196322 +6,56,210739 +6,57,222231 +6,58,238036 +6,59,250562 +6,60,267840 +6,61,281456 +6,62,300293 +6,63,315059 +6,64,335544 +6,65,351520 +6,66,373744 +6,67,390991 +6,68,415050 +6,69,433631 +6,70,459620 +6,71,479600 +6,72,507617 +6,73,529063 +6,74,559209 +6,75,582187 +6,76,614566 +6,77,639146 +6,78,673863 +6,79,700115 +6,80,737280 +6,81,765275 +6,82,804997 +6,83,834809 +6,84,877201 +6,85,908905 +6,86,954084 +6,87,987754 +6,88,1035837 +6,89,1071552 +6,90,1122660 +6,91,1160499 +6,92,1214753 +6,93,1254796 +6,94,1312322 +6,95,1354652 +6,96,1415577 +6,97,1460276 +6,98,1524731 +6,99,1571884 +6,100,1640000 diff --git a/pokedex/db/tables.py b/pokedex/db/tables.py index 9e0dc88..f2a31ee 100644 --- a/pokedex/db/tables.py +++ b/pokedex/db/tables.py @@ -172,6 +172,12 @@ class EvolutionMethod(TableBase): name = Column(Unicode(64), nullable=False) description = Column(Unicode(255), nullable=False) +class Experience(TableBase): + __tablename__ = 'experience' + growth_rate_id = Column(Integer, ForeignKey('growth_rates.id'), primary_key=True, nullable=False) + level = Column(Integer, primary_key=True, nullable=False, autoincrement=False) + experience = Column(Integer, nullable=False) + class Generation(TableBase): __tablename__ = 'generations' id = Column(Integer, primary_key=True, nullable=False) @@ -634,6 +640,8 @@ EncounterSlotCondition.condition = relation(EncounterCondition, EvolutionChain.growth_rate = relation(GrowthRate, backref='evolution_chains') +Experience.growth_rate = relation(GrowthRate, backref='experience_table') + Generation.canonical_pokedex = relation(Pokedex, backref='canonical_for_generation') Generation.versions = relation(Version, secondary=VersionGroup.__table__) Generation.main_region = relation(Region) -- 2.7.4