Tuesday, 13 December 2011

Leonardo: update to version 1.9

I just released the1.9 version which enhances and completes the resources management.

If you use the --under option to nest the new resource under another existing one, must be edited the file config / routes.rb because the operation will create the new routes nested, overwriting the originals.

For example if we create the product resource, leonardo will create these routes:
resources :products do
  post :select,           :on => :collection
  post :edit_multiple,    :on => :collection
  put  :update_multiple,  :on => :collection
  put  :create_multiple,  :on => :collection

if then we create the comment resource under product you will get:
resources :products do
  resources :comments do
    post :select,           :on => :collection
    post :edit_multiple,    :on => :collection
    put  :update_multiple,  :on => :collection
    put  :create_multiple,  :on => :collection

resources :products do
  post :select,           :on => :collection
  post :edit_multiple,    :on => :collection
  put  :update_multiple,  :on => :collection
  put  :create_multiple,  :on => :collection

but you have to join it to get something like this:
resources :products do
  post :select,           :on => :collection
  post :edit_multiple,    :on => :collection
  put  :update_multiple,  :on => :collection
  put  :create_multiple,  :on => :collection
  resources :comments do
    post :select,           :on => :collection
    post :edit_multiple,    :on => :collection
    put  :update_multiple,  :on => :collection
    put  :create_multiple,  :on => :collection
Moreover, the list of resources shows a link to the nested resource for the parent who uses the name field. If not present you should replace it with some other field otherwise you can add the method name into the model:
class Product < ActiveRecord::Base

  def name

Monday, 10 October 2011

Leonardo: Update to version 1.8

With the latest version 1.8 I added the chance to sort the columns by this approach:

I also added by default the auto submit to the search form on the index view when the values ​​are changed for fields like select, radio ... those with a net change of the value, avoiding the text box to not encumbering the database. However it is possible to add or remove this feature, by adding or removing the autosubmit class :

<%= f.collection_select :category_id, Category.all, :id, :name, {:prompt => true}, {:class => 'autosubmit'} %>

In custom.js file (called from application.js) I added a bind (or more precisely, a live):

$('.autosubmit').live('change', function() {
  setTimeout("$('#"+this.id+"').parents('form:first').submit();", 300);
  return false;

I use a timeout to run the submit after eventual updates, usually hidden fields coupled to self completions which currently leonardo does not handle but it will do soon.

With version 1.7 released in late September that I have introduced the option leospace:

rails g leosca decode name:string --leospace=admin

I fixed the code for compatibility with Ruby 1.9.2 which has a slightly different String class.

Now the development users are no longer created by migration, being a database population their place is in the file db / seeds.rb used with rake db: seed. Handy for db:reset or db: schema: load utilities that previously they deleted users.

Create the resource "decode " in no namespace and only the management under the namespace specified in the parameter leospace.

The original scaffold has something similar as well, let's take this example:
rails g scaffold admin/decode name:string

This creates the resource and its management in admin namespace.

We examine the differences:

Both will create paths in admin namespace:

With the scaffold, the resource is called Admin:: Decode and table admin_decodes

With leonardo, the resource is called only Decode and it is not under a namespace. The table is called decodes.

The transaction meets the need to create different interfaces for the same resource. Of course you can also use the original leonardo Methodology:
rails g leosca admin/decode name:string

The latest updates details:

1.8.3 (November 8th, 2011) Marco Mastrodonato
  • Controller/sort_column => Fixed an issue with multiple tables
  • Dev users are now added by rake db:seed, no more by migration
1.8.2 (October 10th, 2011) Marco Mastrodonato
  • List: Added id as first column
  • Replaced String.any? with String.size>0 for ruby 1.9.2 support

1.8.1 (October 10th, 2011) Marco Mastrodonato
  • Updated rspec to pass index view test with two new controller helpers
  •  Date managed with datepicker are now in year-month-day format and now works with sqlite3
  • Added autosubmit class by default. A new function in custom.js let you to autosubmit searches on filter fields change event
1.8.0 (October 7th, 2011) Marco Mastrodonato
  •  Added sortable columns
1.7.2 (October 5th, 2011) Marco Mastrodonato
  • Updated formtastic support to version 2.0
  • Updated template.rb
1.7.1 (October 3th, 2011) Marco Mastrodonato
  • Fixed a layout issue
1.7.0 (September 28th, 2011) Marco Mastrodonato
  • New feature to add a resource management within a namescape. Unlike the original way (rails g leosca admin/resource ...which remains available), the resource is not under the namespace but only its management so you could create one for several kind of users. Try it adding the new option like this example: --leospace=admin
  • Huge code improvements

Tuesday, 20 September 2011

Leonardo: a Rails 3.1 application generator

Update to 1.6 version

I created a new Rails application generator to create 3.1 and automate tasks that are repetitive.

The name of the gem is
leonardo and it consists of two generators:
  1. leolay: to build the layout
  2. leosca: to generate the resource (it replaces original scaffold)

Why create a new generator if there is already the rails scaffold??

The scaffold generator is a handy tool which you can even customize with ease, but is designed for educational purposes and customization is limited to the views. In production I needed something more complete and customizable.

Environment setup and gem installation

Unless we already have one, we create a new ruby environment with rails 3.1:
gem install rails

We can run:
gem install leonardo

...but it is not necessary and I recommend using the process I am about to describe:

create a new application using the template I have prepared, reccomended to facilitate the start-up and to better take advantage of the gem:

rails new NewApp -m http://dl.dropbox.com/u/52600966/template.rb

If the link does not work you can still find the template in the root of the gem

Leonardo relies on the following external gems:
cancan to manage permissions
warden/devise to handle authentication
formtastic for data management
kaminari for paging
rspec/capybara/factory girl/selenium for testing
... and others with whom there is not a close relationship but they are useful to handle other tasks.

The template will propose the adoption of the aforementioned gems, i raccomended to install all answering all "y" or pressing enter when a default is proposed (for example: devise proposes "user" as model name).

It will then run a bundle install to verify the presence of gems and then will perform the various generations, all will last about a minute.

The generation of the layout will ask for confirmation to replace the file en.yml, answer y. I prefer not to force the replacement to allow other executions of the generator leolay if you wanted to update the layout.

At the end you will get an application, "ready to go," allowing them to guide development on the application.

Let's move the application folder and we start the server:cd NewApp
rails s
point your browser at http://localhost:3000 to access the home

If you click on "Sign in" you will be prompted to authenticate (if you included it) for quick access, you can enter:
email: admin@newapp.com
password: abcd1234

Signed in

Creates three users with three different roles (if you have included permission):
  1. admin@newapp.com
  2. manager@newapp.com
  3. user@newapp.com

Of course it's users for purposes related to the development.

We can consult and modify roles access to the file app / models / ability.rb as expected from cancan.

To change the language is enough to send the new one as the value of the lang parameter, eg:http://localhost:3000/?lang=it

Currently it manages language :it and :en. Add support for another language is simple, just add the yml files in the folder where you will find the first two, of course, must have the same tags.

Customize the layout

  • First you replace the logo with your own.
  • You can change the color editing app \ assets \ stylesheets \ stylename.sass (default cloudy). Choosing primary and secondary color, the shades are calculated by sass. 
  • You can customize the paging: Rails g kaminari: views THEME and replace the theme with your favorite theme. Currently available are github and google 
  • You can customize jquery-ui, currently uses a style similar to the lightness 
  • For larger customizations edit the HTML in the templates and layout of individual views. To do this copy the template in the project with Rails g leosca: install

Generate resources

Now we generate some resources leosca using the generator, a sort of custom scaffold:

rails g leosca category name:string active:boolean

rails g leosca product category:references name:string description:text price:decimal released_at:date

To create a nested resource just add the --under=parent for example if we want the product to be nested under category:
rails g leosca product ... --under=category

A resource exists within the parent resource and paths are like this:

When Leonardo detects the presence of a relationship (such as references or belongs_to) is prepared everything necessary for connecting the resources and also whether the resource is nested:
  • nested paths will be created in the controller, in the views and specs
  • will be updated the list of parent resource with links to related resources
  • the creation and / or modification does not require the selection of products related because the parent resource has already been selected before the consultation.

We then create two new tables to the database including:
rake db:migrate

and we also perform the data population that leosca has prepared for us:
rake db:seed

Listing Categories

The image above shows the case where the product was not nested resource under the category.

Some notes:
  • The export data in CSV currently does not work if you activate the paging ajax, I'm looking for a good way to solve.
  • Into the lists are automatically entered all fields in order to apply the filter, then eliminate those that do not interest us. The filters do not work with sqlite 3 and boolean fields due to a bug in the driver that does not generate a correct sql. Works seamlessly with the SQLServer.
  • Related objects show a link with the name. If the table does not have the field name, is used id which should be replaced with the field that more it represents.
  • Only the paging, the show and destroy operation is managed through ajax.
  • About the users automatically created: admin can do everything, manager all the CRUD operations, user cannot to delete.
  • The field labels are auto inserted but the translation must do it by yourself into config/locales/*.yml


Leonardo creates everything you need for testing, even some additions to test the behavior of ajax sections:

rake spec

I use Firefox on Windows (I have not yet been able to do tests with linux) and I got all green, even in the presence of nested resources, though some combinations may not be covered.

Only A Few Recommendations: it will be opening a new session of firefox which you must set it to full screen otherwise selenium will do hard work to click on links. Sometimes instead, there are lag issues, in case of errors of this kind simply repeat the test.

How to customize the generator

Simply install it in your project and customize it to suit your needs:
rails g leosca:install
is located under lib and any changes will take precedence on the gem


For further information or updates on future developments, please consult the project homepage:

Other links:

Thursday, 21 April 2011

Huge files on windows server 2008 R2 64bit

In the previous article I discussed the simple operation read and write of three files with sizes between 330Mb to 2.6 GB on a standard PC with Windows XP. Now we see the changes to a virtual server, a production system that involves an ever increasing number of companies.

The languages ​​examined are:

Ruby 1.8.6 p383 (2009-08-04) [i386-mingw32]
Ruby 1.8.7 p334 (2011-02-18) [i386-mingw32]
Ruby 1.9.2 p180 (2011-02-18) [i386-mingw32]
jruby 1.6.1 (ruby-1.8.7-p330) (2011-04-12) (Java HotSpot(TM) 64-Bit Server VM 1.6.0_23) [Windows Server 2008 R2-amd64-java]
IronRuby (ruby-1.9.2) on .NET 4.0.30319.225
Python 2.7.1 32bit
Python 2.7.1 64bit
Python 3.2.0 32bit
Python 3.2.0 64bit
Php 5.3.6 vc9 unsafe thread
Lua 5.1.4 40
C# 32bit on .NET 2.0.50727.4927
C# 64bit on .NET 2.0.50727.4927
C# 32bit on .NET 4.0.30319.1
C# 64bit on .NET 4.0.30319.1

Only python provides x64 installation packages and I took the opportunity to compare them with the 32-bit versions. Perhaps the differences will be more relevant with math operations instead of IO, but I opened the way for the next comparison.
The Ruby version is the 1.8.6 mingw32 and not the mswin32 as in the previous test. IronRuby instead is the latest 1.1.3 which support ruby 1.9.2 and not 1.8.6 as the version of the previous test with which, however, shares the same framework. net and the same IO section.
This time I also added C # in comparison. I have compiled four different versions for the platform, x86 and x64, and also for the framework, 3.5 and 4. .NET Framework 2.0, 3.0 and 3.5 uses the same CLR version.
Honor to IronRuby, the first of the group that is even above than C #, a compiled language and with which it shares a lot. It 's true that this test does not require very high computing power but it is certainly a curious result.

And here also a summary on the memory usage:

Lua 5.1.4 0,7mb
Php 5.3.6 2,2mb
Python 2.7.1 32bit 2,5mb
Python 3.2.0 32bit 3,7mb
Python 2.7.1 64bit 4mb
Python 3.2.0 64bit 5,5mb
Ruby 1.9.2p180 4-6mb
Ruby 1.8.6p383 4-9mb
Ruby 1.8.7p334 4-9mb
C# 32bit on .NET 2.0.50727.4927 7mb
C# 32bit on .NET 4.0.30319.1 7mb
C# 64bit on .NET 2.0.50727.4927 9mb
C# 64bit on .NET 4.0.30319.1 9mb
IronRuby on .NET 4.0.30319.225 11mb
jruby 1.6.1 (JVM 64-Bit Server 1.6.0_23) jruby 1mb + java 200mb

This is the C# code that I compiled with Visual Studio 2010:

using System;
using System.IO;

namespace Split
    class Program


        /// To split a file into n output files

Filename and records number to split
        static void Main(string[] args)
            string strInput = args[0];
            string strOutput = "out_{0:000}.txt";
            Int32 nrec_to_split = Convert.ToInt32(args[1]);

            DateTime t1 = DateTime.Now;
            Console.WriteLine("C# {1} Started at {0:R}, please wait...", t1, System.Environment.Version);

            StreamReader sr;
            StreamWriter sw = null;
            sr = new StreamReader(strInput);
            Int16 nsplit = 0;
            Int64 nrec = 0;
            while (sr.Peek() >= 0)
                if (nrec % nrec_to_split == 0)
                    if (sw != null) sw.Close();
                    sw = new StreamWriter(String.Format(strOutput, nsplit));

            Console.WriteLine("Ended at {0:R}, please wait...", DateTime.Now);
            Console.WriteLine("Elapsed time {0}", DateTime.Now - t1);


Tuesday, 19 April 2011

Ruby python php lua at work with huge files

Let's see how well does the IO section of some of the most popular scripting languages​​. The exercise consists of reading sequentially several large input file and split it into smaller files.

The languages ​​under consideration are:

Ruby 1.8.6 p287 (2008-08-11) [i386-mswin32]
Ruby 1.8.7 p334 (2011-02-18) [i386-mingw32]
Ruby 1.9.2 p180 (2011-02-18) [i386-mingw32]
jruby 1.5.1 (ruby 1.8.7 patch 249) (Java HotSpot(TM) Client VM 1.6.0_14) [x86-java]
jruby 1.5.1 (ruby 1.8.7 patch 249) (Java HotSpot(TM) Client VM 1.6.0_24) [x86-java]
jruby 1.6.1 (ruby-1.8.7-p330) (Java HotSpot(TM) Client VM 1.6.0_24) [Windows XP-x86-java]
IronRuby on .NET 4.0.30319.225
Python 2.6.2
Python 2.7.1
Python 3.2.0
Php 5.3.6 vc9 unsafe thread
Lua 5.1.4 40

We start by creating the three input files needed for the test:

ruby new.rb input1.txt 185000 1799 => 330Mb
ruby new.rb input2.txt 500000 1799 => 880Mb
ruby new.rb input3.txt 1500000 1799 => 2,6Gb

These measurements were made ​​on a PC Cpu Intel E7300 Core2 Duo 2,66Ghz Ram 3,25Gb with Windows XP Professional 32bit, Hard Disk ST3250310AS Barracuda 7200.10 SATA 3.0Gb/s 250Gb.
Soon it will also perform on a Server Windows 2008 R2 64bit on VMWare Xeon X7460 Dual Core at 2,66Ghz and 2Gb di ram with SCSI disks.
Before and after creating the three input files I defragmented the disk. If the times are erratic means that the disk should be defragmented or there is something that slows down the system such as the antivirus which must be disabled.
For every file I run six benchs and considering the poor performance of the IO system, I dropped the three worst. Of course, before each test I removed the output files.
The graphs are explicit.
Only one comment about ruby 1.9.2 which has obvious problems of IO and these results are not in line with the overall performance of this language that, as I have checked from previous tests, are very good.

These are the scripts that I wrote:
# Written by Marco Mastrodonato on 19/04/2011
# Script to split a file into n output files
# Example:
# ruby split.rb par1 par2
# par1 => name [default => input1.txt]
# par2 => record number that determines the number of output files [default => 1650]

strinput = ARGV[0] || 'input1.txt'
nrec_to_split = ARGV[1] ? ARGV[1].to_i : 1650

unless File.exists? strinput
	puts "File #{strinput} doesn't exists!" 
	exit 1

stroutput = "out_%03d.txt"

t1= Time.now
puts "Ruby #{RUBY_VERSION} #{strinput} started at #{t1}, wait please..."

File.open(strinput, "r") do |f|
	nsplit = 0
	nrec = 0
	fileoutput = nil
	while line = f.gets
		if nrec % nrec_to_split == 0
			nsplit += 1
			fileoutput.close if fileoutput
			fileoutput = File.open(stroutput % nsplit, 'w')
		fileoutput.write line
		nrec += 1
	fileoutput.close if fileoutput

puts "Ended at #{Time.now}"
puts "Elapsed time #{Time.now - t1}"
exit 0
# Written by Marco Mastrodonato on 19/04/2011
# Script to split a file into n output files
# Example:
# python split.py par1 par2
# par1 => name [default => input1.txt]
# par2 => record number that determines the number of output files [default => 1650]

from time import time, gmtime, strftime
import sys

	strinput = sys.argv[1]
	strinput = 'input1.txt'

stroutput = "out_%03d.txt"

	nrec_to_split = int(sys.argv[2])
	nrec_to_split = 1650

t1 = time()
print(strftime("Started at %a, %d %b %Y %H:%M:%S +0000, wait please...", gmtime()))

nrec = 0
nsplit = 0

fileinput = open(strinput, "r")
for line in fileinput:
	if nrec % nrec_to_split == 0:
		except NameError:
			fileoutput = None
		nsplit += 1
		fileoutput = open(stroutput %nsplit , "w")
	nrec += 1    

print(strftime("Ended at %a, %d %b %Y %H:%M:%S +0000", gmtime()))
print("Elapsed time %f" %(time() - t1))
 name [default => input1.txt]
// par2 => record number that determines the number of output files [default => 1650]

$strinput = isset($argv[1]) ? $argv[1] : 'input1.txt';
$nrec_to_split = isset($argv[2]) ? $argv[2] : 1650;
$stroutput = 'out_%03d.txt';

$t1 = microtime_float();
echo "Php ".phpversion()." started at ".date('D, d M Y H:i:s T').", wait please...\n";

$nsplit = 0;
$nrec = 0;

while(!feof($fileinput)) {
	if ($nrec % $nrec_to_split == 0) {
		if (isset($fileoutput)) fclose($fileoutput);
		$fileoutput = fopen(sprintf($stroutput, $nsplit), 'w');
	$buffer = fgets($fileinput);
	fwrite($fileoutput, $buffer);

fclose ($fileinput);

echo "Ended at ".date('D, d M Y H:i:s T')."\n"; 
echo "Elapsed time ".(microtime_float() - $t1)."\n";

function microtime_float() {
	list($usec, $sec) = explode(" ", microtime());
	return ((float)$usec + (float)$sec);

Written by Marco Mastrodonato on 19/04/2011
Script to split a file into n output files
lua split.lua par1 par2
par1 => name [default => input1.txt]
par2 => record number that determines the number of output files [default => 1650]
strinput = arg and arg[1] or "input1.txt"
stroutput = "out_%03d.txt"
nrec_to_split = arg and arg[2] and tonumber(arg[2]) or 1650

local t1 = os.clock()
print(_VERSION .. " started at " .. os.date("%a, %d %b %Y %H:%M:%S +0000"))

nsplit = 0
nrec = 0
for line in io.lines(strinput) do
  if nrec % nrec_to_split == 0 then
    if fileOut ~= nil then io.close(fileOut) end
    nsplit = nsplit + 1
    fileOut = io.open(string.format(stroutput, nsplit) , 'w')
  fileOut:write (line .. '\n')
  nrec = nrec + 1


print("Ended at " .. os.date("%a, %d %b %Y %H:%M:%S +0000"))
print(string.format("Elapsed time: %.2f\n", os.clock() - t1))
To create the files I've used this simple ruby script:
# Example:
# ruby new.rb [NOME] [LINES] [RECORD SIZE]

stroutput = ARGV[0] || 'input1.txt'
num = ARGV[1] ? ARGV[1].to_i : 185000
size = ARGV[2] ? ARGV[2].to_i : 1799

if File.exists? stroutput
	puts "File #{stroutput} already exists!" 
	exit 1

t1= Time.now
puts "Ruby #{RUBY_VERSION} #{stroutput} started at #{t1}, wait please..."

line = "*" * size

File.open(stroutput, "w") do |f|
	num.times do
		f.puts line

puts "Ended at #{Time.now}"
puts "Elapsed time #{Time.now - t1}"
exit 0