IV.2.6.1 Saving objects in an SQLite database
To use SQLite, one first requires the corresponding ruby gem:
require "rubygems"
require "sqlite3"
Then, the database can be created:
fName="brol.fdb"
if (File::exists?(fName))
sqldb = SQLite3::Database.open( fName )
else
sqldb = SQLite3::Database.new( fName )
sqldb.execute <<SQL
PRAGMA auto_vacuum = FULL
SQL
end
In this case only one SQL table is created in the database. The columns correspond to several
data associated with each individual Results, and the BLOB corresponding to the Result
itself:
sqldb.execute <<SQL
CREATE TABLE IF NOT EXISTS dynam_results_1 (
lcName TEXT,
scName TEXT,
resName TEXT,
tensorOrder INTEGER,
intId1 INTEGER,
intId2 INTEGER,
realId1 REAL,
realId2 REAL,
size INTEGER,
result BLOB,
PRIMARY KEY(lcName,scName,resName)
);
SQL
Finally, one loops on xdb attachment Results. For each load case and Result name, one extracts the
Results corresponding to each subcase, and inserts it into the database:
db.attachXdb(xdbFileName)
lcNames=db.getAttachmentLcNames(xdbFileName)
scNames=db.getAttachmentScNames(xdbFileName)
resNames=db.getAttachmentResNames(xdbFileName)
lcNames.each do |lcName|
resNames.each do |resName|
results=db.getAttachmentResults(xdbFileName,lcName,scNames,resName)
if (results) then
results.each do |key,res|
puts key
sqldb.execute( "insert or replace into
dynam_results_1 values (?,?,?,?,?,?,?,?,?,?)",
lcName,key[1],resName,res.TensorOrder,
res.getIntId(0),res.getIntId(1),
res.getRealId(0),res.getRealId(1),res.Size,
SQLite3::Blob.new(res.toBlob()))
end
else
puts "NO FOR" + lcName + resName
end
end
The example is provided in file "RUBY/EX20/rehashDynamicResults.rb"