Redmine

lft, rgt, root_id and parent_id are columns used by the awesome_nested_set vendored with Redmine; in the case of the projects table they are needed to handle project hierarchy.

If your script is written in Ruby language then you should use RoR ActiveRecord API as much as you can rather than writing your own SQL queries; thus a simple p = Project.new( :name => 'my project'); p.save! (or something close) will create a new Project object and persist it in DB.

Maybe you can also use REST API Rest_Projects

Tks Guys
researched solutions and would like some of you on a opnião I found for this problem.
follows:
http://redmineblog.com/articles/redmine-client-access-the-redmine-api-in-ruby/

Using the same parameters and I'm getting errors.

Redmine Client - Access the Redmine API in Ruby

require 'rubygems'
require 'redmine_client'
require 'active_resource'

RedmineClient::Base.configure do
self.site = 'http://MY_redmineqa'
self.user = 'admin'
self.password = 'admin'
end

issue = RedmineClient::Issue.find(1018)
issue.subject = "Changed via the API TESTE"
issue.save

eRROR:

/var/lib/gems/1.8/gems/activesupport-2.3.11/lib/active_support/vendor.rb:32: warning: redefine normalize_translation_keys
/usr/lib/ruby/1.8/pathname.rb:263: warning: `*' interpreted as argument prefix
/var/lib/gems/1.8/gems/redmine_client-0.0.1/lib/redmine_client/base.rb:5: warning: `&' interpreted as argument prefix
/var/lib/gems/1.8/gems/activeresource-2.3.11/lib/active_resource/connection.rb:219: warning: instance variable @proxy not initialized
/var/lib/gems/1.8/gems/activeresource-2.3.11/lib/active_resource/connection.rb:230: warning: instance variable @timeout not initialized
/var/lib/gems/1.8/gems/activeresource-2.3.11/lib/active_resource/connection.rb:190:in `handle_response': Failed with 401 Authorization Required (ActiveResource::UnauthorizedAccess)
from /var/lib/gems/1.8/gems/activeresource-2.3.11/lib/active_resource/connection.rb:173:in `request'
from /var/lib/gems/1.8/gems/activeresource-2.3.11/lib/active_resource/connection.rb:138:in `get'
from /var/lib/gems/1.8/gems/activeresource-2.3.11/lib/active_resource/base.rb:661:in `find_single'
from /var/lib/gems/1.8/gems/activeresource-2.3.11/lib/active_resource/base.rb:589:in `find'
from teste.rb:15

Hy. Tks
I managed to make the creation of projects using the API as was explained to me.
Thank you very much

Hy. Tks
I managed to make the creation of projects using the API as was explained to me.
Thank you very much