February | 2009

Problem
You want to use ActiveScaffold in Rails 2.2, in a model that you have created using the standard Rails scaffolding script.

Solution

Install the ActiveScaffold plugin:

script/plugin install git://github.com/activescaffold/active_scaffold.git -r rails-2.2

1

script/plugin install git://github.com/activescaffold/active_scaffold.git -r rails-2.2
In your layout (model or application for all models) add the following:

<%= javascript_include_tag :defaults %> <%= active_scaffold_includes %>

1
2

<%= javascript_include_tag :defaults %>
<%= active_scaffold_includes %>
In your controller file delete all the standard scaffolding code and add one line, so that your new controller should look like:

class SomethingsController < ApplicationController active_scaffold :something end

1
2
3

class SomethingsController < ApplicationController
active_scaffold :something
end
To configure a RESTful scaffold add the following to your route.rb file:

map.resources :somethings, :active_scaffold => true

1

map.resources :somethings, :active_scaffold => true
Delete the views that were created from the standard rails scaffolding in the views/somethings folder (edit, show, index …)
Restart your server

You should now have an active scaffold for your model.

Facebook

Twitter

Problem
You have two big tables in MySQL (>640K records), that maybe differ in the number of fields, but you want to make sure that the data in the common fields in both tables are the same.

Solution

Use mysql to export the data from the first table in a csv file, selecting only the common fields.
We use the /tmp folder on the server to make sure we have the right permissions to create the file:

mysql>SELECT common_field1, common_field2, ... 
INTO OUTFILE '/tmp/first_table.txt'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM table1;

mysql>SELECT common_field1, common_field2, ...

INTO OUTFILE '/tmp/first_table.txt'

FIELDS TERMINATED BY ','

OPTIONALLY ENCLOSED BY '"'

LINES TERMINATED BY '\n'

FROM table1;

If the tables are in different databases remember to switch db:

use seconddb;

1	use seconddb;

Export the second table in the second file:

mysql>SELECT common_field1, common_field2, ... 
INTO OUTFILE '/tmp/second_table.txt'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM table2;

mysql>SELECT common_field1, common_field2, ...

INTO OUTFILE '/tmp/second_table.txt'

FIELDS TERMINATED BY ','

OPTIONALLY ENCLOSED BY '"'

LINES TERMINATED BY '\n'

FROM table2;

now use the diff. You can use any of the following options:
- diff -q first_table.txt second_table.txt
- diff first_table.txt second_table.txt > diff.txt

M	T	W	T	F	S	S
						1
2	3	4	5	6	7	8
9	10	11	12	13	14	15
16	17	18	19	20	21	22
23	24	25	26	27	28

42

Web notebook about thoughts and discoveries in DevOps, SRE, Software Engineering….

Monthly Archives: February 2009

Using ActiveScaffold in Rails 2.2 after using default scaffolding

Comparing data from two big MySQL tables