sqlite ruby users - May 2005 - count and type_translation

Hello out there,

the following program gives me an error:

--------------------------------------------------
#!/opt/ruby/1.8/bin/ruby

require ''sqlite3''
$db = SQLite3::Database.open("foo.db")
$db.type_translation = true
$db.execute "SELECT COUNT (*) FROM ''sqlite_master'' where 
type=''table'' and name=''sometable''"
$db.close
--------------------------------------------------

/opt/ruby/1.8.2/lib/ruby/site_ruby/1.8/sqlite3/translator.rb:85:in
`type_name'': undefined method `upcase'' for nil:NilClass
(NoMethodError)
        from /opt/ruby/1.8.2/lib/ruby/site_ruby/1.8/sqlite3/translator.rb:77:in
`translate''
        from /opt/ruby/1.8.2/lib/ruby/site_ruby/1.8/sqlite3/resultset.rb:135:in
`next''
        from /opt/ruby/1.8.2/lib/ruby/site_ruby/1.8/sqlite3/resultset.rb:134:in
`map''
        from /opt/ruby/1.8.2/lib/ruby/site_ruby/1.8/sqlite3/resultset.rb:134:in
`next''
        from /opt/ruby/1.8.2/lib/ruby/site_ruby/1.8/sqlite3/resultset.rb:160:in
`each''
        from /opt/ruby/1.8.2/lib/ruby/site_ruby/1.8/sqlite3/database.rb:215:in
`inject''
        from /opt/ruby/1.8.2/lib/ruby/site_ruby/1.8/sqlite3/database.rb:215:in
`execute''
        from /opt/ruby/1.8.2/lib/ruby/site_ruby/1.8/sqlite3/database.rb:210:in
`prepare''
        from /opt/ruby/1.8.2/lib/ruby/site_ruby/1.8/sqlite3/database.rb:210:in
`execute''
        from ./test.rb:6
--------------------------------------------------

I''d expect to return either 1 (Fixnum) or "1" or
[["1"]] or something
else. (Or 0 of course.)


Any workarounds/patches/ideas?

Patrick

This bug has been fixed in the repository for some time... I''m 
embarrassed that I''ve taken so long to package a release. I hope to 
have more time this next week in which to release an updated 
sqlite3-ruby (as well as net-ssh, net-sftp, and a few others).

Again, sorry about that.

- Jamis

On May 8, 2005, at 11:00 AM, Patrick Gundlach wrote:
> Hello out there,
>
> the following program gives me an error:
>
> --------------------------------------------------
> #!/opt/ruby/1.8/bin/ruby
>
> require ''sqlite3''
> $db = SQLite3::Database.open("foo.db")
> $db.type_translation = true
> $db.execute "SELECT COUNT (*) FROM ''sqlite_master''
where  type=''table''
> and name=''sometable''"
> $db.close
> --------------------------------------------------
>
> /opt/ruby/1.8.2/lib/ruby/site_ruby/1.8/sqlite3/translator.rb:85:in 
> `type_name'': undefined method `upcase'' for nil:NilClass 
> (NoMethodError)
>         from 
> /opt/ruby/1.8.2/lib/ruby/site_ruby/1.8/sqlite3/translator.rb:77:in 
> `translate''
>         from 
> /opt/ruby/1.8.2/lib/ruby/site_ruby/1.8/sqlite3/resultset.rb:135:in 
> `next''
>         from 
> /opt/ruby/1.8.2/lib/ruby/site_ruby/1.8/sqlite3/resultset.rb:134:in 
> `map''
>         from 
> /opt/ruby/1.8.2/lib/ruby/site_ruby/1.8/sqlite3/resultset.rb:134:in 
> `next''
>         from 
> /opt/ruby/1.8.2/lib/ruby/site_ruby/1.8/sqlite3/resultset.rb:160:in 
> `each''
>         from 
> /opt/ruby/1.8.2/lib/ruby/site_ruby/1.8/sqlite3/database.rb:215:in 
> `inject''
>         from 
> /opt/ruby/1.8.2/lib/ruby/site_ruby/1.8/sqlite3/database.rb:215:in 
> `execute''
>         from 
> /opt/ruby/1.8.2/lib/ruby/site_ruby/1.8/sqlite3/database.rb:210:in 
> `prepare''
>         from 
> /opt/ruby/1.8.2/lib/ruby/site_ruby/1.8/sqlite3/database.rb:210:in 
> `execute''
>         from ./test.rb:6
> --------------------------------------------------
>
> I''d expect to return either 1 (Fixnum) or "1" or
[["1"]] or something
> else. (Or 0 of course.)
>
>
> Any workarounds/patches/ideas?
>
> Patrick
> _______________________________________________
> sqlite-ruby-users mailing list
> sqlite-ruby-users@rubyforge.org
> http://rubyforge.org/mailman/listinfo/sqlite-ruby-users
>

Hello Jamis,
> This bug has been fixed in the repository for some time... 
I tried the cvs repository sqlite3-ruby on rubyforge and I still get
the same error. I wonder why.
> Again, sorry about that.
Don''t be sorry. Thanks for providing sqlite3-ruby - it is very nice so
far!

Patrick