search

VincentSteil / World_Crisis_DB

Creating a database for world crises similar to what IMDB is for movies that can be navigated in a similar manner. Parsed and accessed through python and initially stored in XML and validated against an XSD. The XML is converted in MySQL later on.
1 stars 0 forks source link

sql queries 11 - 15 #58

Closed VincentSteil closed 11 years ago

VincentSteil commented 11 years ago

refer to https://docs.google.com/spreadsheet/ccc?key=0AnWPQPchhOIAdHp2MVd3aWFqdEh2VHRzX1ZneEpyUXc#gid=0 for the English descriptions and numbering

caisbalderas commented 11 years ago

what database are you using to check the queries. I tried using the database listed on the wcdb3.py but it does not seem to have every crises,person, and org loaded in

VincentSteil commented 11 years ago

We're currently building the db in @mduban s cs my SQL db I'm through queey 15, but haven't tested them yet. When Iwo is done with the db I'll start running them through the db