Index of /2001/12/rubyrdf/squish/service

[ICO]NameLast modifiedSizeDescription
[DIR]Parent Directory  -  
[TXT]askruby.pl27-Apr-2002 12:06 663  
[ ]askruby.rb27-Apr-2002 12:06 730  
[ ]codepiction_client.rb27-Jun-2002 16:29 1.7K 
[ ]defrag_test.rb30-Mar-2002 22:15 4.2K 
[TXT]demo.txt30-Mar-2002 21:50 4.7K 
[ ]events.nt30-Mar-2002 21:50 23K 
[ ]events.sql30-Mar-2002 23:36 50K 
[ ]events.xml30-Mar-2002 21:50 9.8K 
[ ]examples.nt30-Mar-2002 23:36 3.4K 
[ ]examples.rdf30-Mar-2002 23:36 2.0K 
[ ]examples.sql30-Mar-2002 23:36 9.0K 
[ ]joiner.rb31-Mar-2002 22:33 3.7K 
[ ]ltss_demo.rb30-Mar-2002 23:36 1.6K 
[ ]memsquish.rb22-Apr-2002 00:31 831  
[ ]query_tests.rb31-Mar-2002 23:12 20K 
[ ]rdfq-server.rb27-Apr-2002 12:06 2.0K 
[ ]rss_directory.rb07-Jul-2002 00:19 1.4K 
[ ]scutter13-Jul-2002 15:19 12K 
[ ]soap_tests.rb04-Apr-2002 23:11 1.0K 
[ ]superprop_test.rb30-Mar-2002 21:50 745  
[ ]tcplog.rb25-Apr-2002 00:38 284  
[ ]vocabtable.rb15-Jun-2002 19:21 2.0K 
[ ]webfetch_tests.rb01-Apr-2002 05:30 2.1K 


These files test various services wrapped around the basic SQL/Squish
system.

Node folding: defrag
RDF schema property hierarchies: addAllSuperProperties

danbri@w3.org


cd ..

../db/nt2sql.rb service/events.nt >> samples/_query_tests.sql 
../db/nt2sql.rb samples/danbri.wot.nt >> samples/_query_tests.sql 
../db/nt2sql.rb service/examples.rdf >> samples/_query_tests.sql 




some handy excerpts from the Ruby DBI documentation


############

puts "inserting..."
1.upto(13) do |i|
   sql = "insert into simple01 (SongName, SongLength_s) VALUES (?, ?)"
   dbh.do(sql, "Song #{i}", "#{i*10}")
end

puts "selecting..."
sth=dbh.prepare('select * from simple01')
sth.execute

while row=sth.fetch do
 p row
end

puts "deleting..."
dbh.do('delete from simple01 where internal_id > 10')

dbh.disconnect

  The same using Ruby's features
  
require 'dbi'

DBI.connect('DBI:Mysql:test', 'testuser', 'testpwd') do | dbh |

  puts "inserting..."
  sql = "insert into simple01 (SongName, SongLength_s) VALUES (?, ?)"
  dbh.prepare(sql) do | sth |
    1.upto(13) { |i| sth.execute("Song #{i}", "#{i*10}") }
  end

  puts "selecting..."
  dbh.select_all('select * from simple01') do | row |
    p row
  end

  puts "deleting..."
  dbh.do('delete from simple01 where internal_id > 10')

end