How to create a LOV [ List of Values in a Rails Application ]

Dinooz · February 21, 2007, 3:56pm

I have 3 tables for a Sarbanes Oxley application. Servers , Databases
and Applications.

another set of tables for the Model: Servers_Databases,
Databases_Applications and Servers_Applications.

My question here is how can setup a LOV in order to let the join
tables have a LOV from the Servers, Databases or Applications.

How would the model be applied in has_many ... :trough ....

This is really cool but a little bit confusing.

Thanks in advance for your help....

Dinooz · February 21, 2007, 4:49pm

Thank you Mike for your reply here is layout of the current tables:
3 Main tables: servers , dbs , apps [ For some reason
scaffold_resource did not like the work database/s application/s]

These 3 tables work together with the tables: app_svrs, db_apps and
db_svrs

DROP TABLE IF EXISTS `prs_sarbox_development`.`servers`;
CREATE TABLE `prs_sarbox_development`.`servers` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `cat` varchar(255) default NULL,
  `net_face` int(11) default NULL,
  `ids` int(11) default NULL,
  `mon_man` int(11) default NULL,
  `mon_aut` int(11) default NULL,
  `int_ip` varchar(255) default NULL,
  `ext_ip` varchar(255) default NULL,
  `desc` varchar(255) default NULL,
  `bu_media` varchar(255) default NULL,
  `bu_method` varchar(255) default NULL,
  `bu_data_freq` varchar(255) default NULL,
  `os_vendor` varchar(255) default NULL,
  `os` varchar(255) default NULL,
  `os_version` varchar(255) default NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `prs_sarbox_development`.`dbs`;
CREATE TABLE `prs_sarbox_development`.`dbs` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `cat` varchar(255) default NULL,
  `description` varchar(255) default NULL,
  `mon_man` int(11) default NULL,
  `mon_auto` int(11) default NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `prs_sarbox_development`.`apps`;
CREATE TABLE `prs_sarbox_development`.`apps` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `fsa` int(11) default NULL,
  `fsa_logic` varchar(255) default NULL,
  `description` varchar(255) default NULL,
  `bu_data` varchar(255) default NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `prs_sarbox_development`.`app_svrs`;
CREATE TABLE `prs_sarbox_development`.`app_svrs` (
  `id` int(11) NOT NULL auto_increment,
  `server_id` int(11) default NULL,
  `app_id` int(11) default NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `prs_sarbox_development`.`db_apps`;
CREATE TABLE `prs_sarbox_development`.`db_apps` (
  `id` int(11) NOT NULL auto_increment,
  `db_id` int(11) default NULL,
  `app_id` int(11) default NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `prs_sarbox_development`.`db_svrs`;
CREATE TABLE `prs_sarbox_development`.`db_svrs` (
  `id` int(11) NOT NULL auto_increment,
  `db_id` int(11) default NULL,
  `server_id` int(11) default NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

When I try to open the URL:
http://192.168.2.148:3000/db_apps

I got the list of the content of the DB.

Db App
15 1 Show Edit Destroy
11 14 Show Edit Destroy
22 23 Show Edit Destroy
4 17 Show Edit Destroy
4 21 Show Edit Destroy
2 17 Show Edit Destroy
2 21 Show Edit Destroy
2 5 Show Edit Destroy
2 19 Show Edit Destroy
2 20 Show Edit Destroy

I would like to see instead of the ID of the DB or APP the Name that
belongs to that Database of the Name of the Application from the DBs
and Apps tables repectively. I might be missing something, when I
create the migration run the rake db:migrate then later edit the model
as follow:

app Model:

Dinooz · February 21, 2007, 4:50pm