Question: We ve designed a database for our fictional climbing gym application, but now we need to test it out by filling it with real, or
Weve designed a database for our fictional climbing gym application, but now we need to test it out by filling it with real, or nearly real, data. While lots of real data would be great, we dont have any on hand. Instead, well use python to generate some fictional data. Data Requirements gyms. You pick the names and the id for the database. For each gym: a walls. Name they with random combinations of North,South, East, and West joined with Vert, Slab, or Overhang. For example, you could have two walls: North Vert and North Slab. b For each wall, flip a coin to decide if it houses one or two lanes. c sets of holds. A set of holds will all have the same color and manufacturer. Colors can be choose at random from a set of your choosing. Pick at random one of the following manufacturers: Escape, SoIll, Atomik, EuroHolds, or Metolious. The holds in a set should be numbered sequentially ie Red Red but dont need to start at Choose the type of each hold at random. d active routes. Select wallslanes at random from your gym. As these are active climbs, you should not select a walllane more than once for this. For set dates, come up with a short list of dates and choose from that list at random with replacement, you can set more than one route on a day Names and setter names can also be as creative as youd like. Holds will be discussed below. e historical routes. Generate these like active routes but given them an end date that is a few weeks after the selected set date. f For each route, you should select, at random, from the gyms set of holds. Then select percent of the holds from that set. Finally, shuffle your selected subset of the holds to determine their placement. Orientations can be a random int from Programming Specifications The only hard specification is that your program should be able to generate SQL files that can be used to insert your data into your database. Lots of files is fine. One frankenfile is OK Whatever works for you. Beyond that, you are highlyencouraged to make good use of all the tools Pyython has to offer. In particular, you might want to explore the following python modules: itertool random datetime
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
