Databases
StackOverflow2013
Postsdbo
POCreating tables & models on the fly (dynamically) in Ruby on Rails 3
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCreating tables & models on the fly (dynamically) in Ruby on Rails 3
    primarykey
    data
    text
    <p>Bear with me on this one. </p> <p>In an app I'm working on users are able to upload CSV files into the system, with any headers they like and any columns in the data. The CSV is then used to generate a table in the database and the data written to it, it can then be accessed through the system for various uses, searches, sorts updates etc.</p> <p>The old (and now defunct system) was in PHP and handled this fine, although quite messily with lots of raw sql to create the tables and the framework supported magic-models (if the table existed so did the object without a class being defined in a model file)</p> <p>The new version is being written in RoR3, and I am yet to figure out a way to do this. I've managed to sort out the table creation by calling migration tools inside a model (not very Rails-y I know, but needs must...), but I cannot find a way to link to the new table once it's created to write in the data, build relationships or anything else.</p> <p>What I'm hoping for is either, </p> <p>a) someone on here has a better way of doing this than creating tables and models on the fly (a warning here, these files can contain 100'000's of records and different fields so a single table option doesn't work so well) i.e a better database design for this issue.</p> <p>or </p> <p>b) can tell me how to sort out the model issue.</p> <p>I've looked at Dr Nic's Magic Model gem for RoR but it doesn't seem to work in RoR3 unless I'm doing something wrong</p> <p>Sorry for the wall of text, look forward to any suggestions</p> <p>Thanks in advance</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USfullybaked
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCreating tables & models on the fly (dynamically) in Ruby on Rails 3
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POCreating tables & models on the fly (dynamically) in Ruby on Rails 3
      1. USZabba
      1. VTFavorite
    3. VO
      singulars
      1. POCreating tables & models on the fly (dynamically) in Ruby on Rails 3
      1. This table or related slice is empty.
      1. VTUpMod
    1. COJust a wild thought: Maybe try creating a migration file on the fly, then reload that file and db:migrate.
      singulars
      1. POCreating tables & models on the fly (dynamically) in Ruby on Rails 3
      1. USZabba
    2. CO@Zabba, what would that achieve exaclty? Excuse my lack of RoR experience but isn't the migration going to just create the table and not the model? Or did you mean that it would be a "better" way to create the table?
      singulars
      1. POCreating tables & models on the fly (dynamically) in Ruby on Rails 3
      1. USfullybaked
    3. COYes, I meant the part about creating the table. But you could also create the model file and load that, I *suppose*. No experience with this sort of thing as yet.
      singulars
      1. POCreating tables & models on the fly (dynamically) in Ruby on Rails 3
      1. USZabba
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload