|
Server IP : 172.16.15.8 / Your IP : 3.15.211.71 Web Server : Apache System : Linux zeus.vwu.edu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Wed Nov 6 14:29:02 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.2.24 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/tasimmons/Scripts/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
#!/bin/bash
# This file makes the file createPokedex.sql.
# Running createPokedex.sql will create the pokedex table and populate it with pokemon.
# Only supports KANTO list with no fail
readFile=$1
#create table
echo "create table pokedex (id smallint not null auto_increment, kid smallint, name varchar(20), type1 varchar(10), type2 varchar(10), PRIMARY KEY (id));" > "createPokedex.sql"
#Insert values
echo "INSERT INTO pokedex (kid,name,type1,type2) VALUES" >> "createPokedex.sql"
sed 's/[\t| ]*\([^\t^ ]*\)[\t| ]*\([^\t|^ ]*\)[\t| ]*\([^\t^ ]*\)[\t| ]*\([^\t^ ]*\)[\t| ]*\([^\t^ ]*\)$/("\1","\2","\3","\4"),/g' $readFile >>"createPokedex.sql"
echo ";" >>"createPokedex.sql"
#Fix Mr. Mime 122("Mr.","Mime",
sed -i 's/\(122("Mr.","Mime",\)/("122","Mr. Mime",/' "createPokedex.sql"
#remove any blank entries
sed -i 's/\(("","","",""),\)//g' "createPokedex.sql"
#remove last comma of kanto list
sed -i 's/\(("151","Mew","Psychic","none"),\)/("151","Mew","Psychic","none")/' "createPokedex.sql"