LotR TCG Wiki → Card Sets:  All 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 → Forums:  TLHH CC

Author Topic: SQL Server Version of All Cards  (Read 3997 times)

0 Members and 1 Guest are viewing this topic.

June 20, 2020, 11:57:39 PM
Read 3997 times

TelTura

  • *****
  • Information Offline
  • Ranger
  • Administrator
  • Posts: 842
    • Player's Council Discord
SQL Server Version of All Cards
« on: June 20, 2020, 11:57:39 PM »
Alright, I spent a week taking the spreadsheet of cards from TLHH and the LOTRO dump spreadsheet (so helpfully uploaded by a member of the Facebook group) consolidated and pushed into a database.  SQL Server, specifically.  It was actually very illuminating having two completely separate sources of data; both sets had systematic errors that the other underlined.

If you're a technical type interested in a normalized set of databases containing all 3,527 cards for MS SQL Server, this is for you.  If you prefer some other SQL flavor, I have also prepared a SQL script export, which you will probably need to do some find/replace wrangling on to get it to fit your particular SQL flavor, but should get you 98% of the way there.

*.bak file (also contains table imports for TLHH and LOTRO): https://drive.google.com/open?id=1I6nZncDLRoqUZNzBG8mTkdcLleU6hMEb


SQL script: https://drive.google.com/open?id=171vAtVo9LSOUFvppei3yK4nwhc7LHGgw

Both of these zip files also contain a lotr_tcg_query.sql which shows how to join everything together into something sensible. 

At some point I will try and throw a query together that will put all of this into One Spreadsheet To Rule Them All for those of you who stick to excel, but for now I've got other things to work on.
Come join the Player's Council to help us run events, create new cards, and steer the direction of this great game!

Join our Discord here for more information.