Read up on possible scopes integration for use in making the filters work. Improved the show_mis prototypes and sorted out some of the kinks in the implementation.
Designed queries to extract only the available stations for a given user's MISs.
Built out the queries needed to populate the listing_character and type selects. Currently values are not shown if there is no data available for them. The next step is to determine how to trigger calls based on the select's value.
Added two tables, one for corporations and one for characters, these will be used to store character/corporation IDs and character/corporation names. They can then be referenced to convert from one to the other.
Added has_many - belongs_to relationships between user, character and corporation
Built supporting factories for the character and corporation models.
Next step is to populate the character and corporation tables with data from the api. This data can be pulled from the APIKeyInfo API.
Added the user_id column to the corporation and character tables to support their assocations. Built machinery to load the character and corporation tables with data from the characters API at time of API enrollment. This may cause performance bottlenecks or slow responses as two APIs now need to be queried in sequential order.
Added factories for Character and Coporation for use in future testing.
Built up machinery to build Corporation and Character objects and save them to the database during API enrollment. This code is sloppy at best and should be extracted into a separate method. It could also probably be optimized or moved to one of the cron triggered modules for load distribution.
Added character and corporation factories to MISBuilder.prepdb, also modified user1 MO factories to reference character 1 and character 2 for testing purposes.
Built up machinery to populate the owner's select with names associated with the user. This needs to be further refined to list only owners with orders.
Removed user has many corporation association and associated corporation with character. This makes it easier to retrieve the corporation details of characters after pulling it out of market orders/MIS. Updated all supporting infrastructure and built a first pass at loading mis_show selects with character/corporation names based on actual market_item_summaries.
Discovered a bug when updating the listing character select to display character names instead of char_ids. The query method used in the owner select would break when multiple values were returned in any of the nested queries. This has been fixed, though it's not pretty and is likely a bottleneck.
Updated all selects in show_mis to user current_user.market_item_summaries instead of MarketItemSummaries.where() statements.
Made demo_odyssey_import.rb to test, dissect and understand code shared by darkbushido in dbdump.rake. The goal is to extract data from and sqlite version of the odyssey data dump provided by CCP and convert it into easily readable seed data for use in a rake db:seed command.
Updated .gitignore to include the odyssey1-1.db in all three locations it is presently stored.