Database Setup

[bkern24]

We need to setup the database. Duh

[bkern24]

My Idea:

1) Create a Script that reads from a CSV excel file 2) Determine Needed sql (sql lite) commands 3) Script executes above commands for each line in the CSV

This would allow us to input the data into excel, and would speed up the process later on when adding additional decks.

[bkern24]

I can work on this, sometime through out this week anyways. @dlattsify Can you make a pull request of the excel file with the trial deck so I can use it for testing my script and what not.

[dlattsify]

I would do a pull request... if I knew how to add files and whatever. I'm useless.

[bkern24]

Lame , adding files is easy. If the files are in the project folder of source tree all you have to do is click commit, and then change the drop down menu to selected changes. Then commit and push and pull request lol

[bkern24]

Working on this still. I created a vbscript and I got everything done but building the SQL statements as I am still trying to figure out the best way to attack Updating vs Creating the tables, and logging into the SQL "Server" as well... I will have enough time tomorrow to do this :)

If your interested you can take a look at my Brandon/SQLScript branch.... The script should run on windows 7 if you pull my branch (Don't push to it though thx). If it doesn't then I may still have some work to do then.

[bkern24]

Okay I got it to work. I had to install the ODBC Driver but it makes sense why. It was either that or installing another scripting language. What we need to figure out now is what we want for the table settings.

For example how many chars per box.

@dlattsify

[dlattsify]

I guess I'm confused. Why do we need to limit/standardize this? Doesn't each "box" just hold a string which we can read?

[bkern24]

I don't know if we can do variable sized columns? Look it up!

[bkern24]

It does matter!

"The effective maximum length of a VARCHAR in MySQL 5.0.3 and later is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used."

[bkern24]

In short, each box is limited to a certain amount of chars. I don't think we would need more then using an int (> 1 byte) and somewhere between 30 chars for all columns and 250 chars for the flavor text

[bkern24]

Okay I have the script almost done. All the code concepts are there I just need to test them, and then we can see if it will work on your computer as well.

[bkern24]

14

Does Everything but Insert into a already created table but that can be for later.

@dlattsify