sqld4r

→ ‘sqld4r’

What is this?

The sqld4r is model generator for SQLDesigner(http://ondras.zarovi.cz/sql/demo/).
If you have a xml file of the SQLDesigner, you will be able to generate migration files and model files on a minute.
I recommend that you use it with a rocketstarter gem.

Features

• generate migration files and model files from SQLDesigner xml file.
  
• generate migration file for your model’s PKs and FKs.
  
• execute command list before finish.
  (exp., execute ‘rake db:create:all’ for migrate to your database).
  
• save the DBDesigner xml file.
  

Installing

gem install sqld4r

The basics

This gem needs activesupport ver 2.1.0 or higher. (because I checked this version only. I don’t know about another version.)

Demonstration of usage

Usage: sqld4r SQLDesigner_xml_path [options]
Usage: sqld4r --init [options]
Usage: sqld4r --check [options]
and more...
Usage: sqld4r --help

How to use

1. Set environment valiable if you want to change a config file path.

$ export SQLD4R_CONF=~/.sqld4r

- Default is $HOME/.sqld4r

2. Create config file.

$ sqld4r --init

3. Modify default values and command list.

$ vi ~/.sqld4r
$ vi ~/sqld4r_execute_commands

4. Test for setting

$ sqld4r --check

5. Generate migration files and model files from SQLDesigner xml file.

$ cd your-rails-root
$ sqld4r /path/to/SQLDesigner.xml

Forum

http://groups.google.com/group/sqld4r http://groups.google.co.jp/group/sqld4r

How to submit patches

Read the 8 steps for fixing other people’s code and for section 8b: Submit patch to Google Groups, use the Google Group above.

You can fetch the source from either:

• rubyforge: MISSING IN ACTION

TODO – You can not created a RubyForge project, OR have not run rubyforge config yet to refresh your local rubyforge data with this projects’ id information.

When you do this, this message will magically disappear!

Or you can hack website/index.txt and make it all go away!!

Build and test instructions

cd sqld4r
rake test
rake install_gem

License

This code is free to use under the terms of the MIT license.

Contact

Comments are welcome. Send an email to Yusuke Ohmichi via the forum

Yusuke Ohmichi(maimuzo), 24th June 2008
Theme extended from Paul Battley