File: update.rb

package info (click to toggle)
libdb2-ruby 0.5.4-1
  • links: PTS
  • area: main
  • in suites: sarge
  • size: 2,352 kB
  • ctags: 2,743
  • sloc: ansic: 11,156; ruby: 6,199; cpp: 6,064; makefile: 86; sh: 31
file content (69 lines) | stat: -rwxr-xr-x 2,055 bytes parent folder | download | duplicates (11)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
#!/usr/bin/ruby -I../.. -I../../../src

require 'bdbxml'

def value(document, xpath, context)
   context.returntype = BDB::XML::Context::Values
   result = document.query(xpath, context).to_a
   if result.size != 1
      raise "Expected 1 got #{result.size}"
   end
   result[0]
ensure
   context.returntype = BDB::XML::Context::Documents
end

def new_document(document, context)
   res = value(document,"/*/inventory/inventory/text()", context).to_s
   document.to_s.sub(/#{res}/, "#{res}A")
end

def update(container, xpath, context)
   puts "Updating document for '#{xpath}'"
   print "Return to continue : "
   STDIN.gets
   results = container.query(xpath, context)
   puts "\nFound #{results.size} documents matching the expression '#{xpath}'"
   results.each do |r|
      puts "Updating document #{r.name}"
      puts r
      print "Return to continue : "
      STDIN.gets
      r.content = new_document(r, context)
      container.update(r)
   end
   puts
rescue
   puts "Query #{xpath} failed : #{$!}"
end

def retrieve(container, xpath, context)
   puts "Retrieving document for '#{xpath}'"
   print "Return to continue : "
   STDIN.gets
   results = container.query(xpath, context)
   puts "\nFound #{results.size} documents matching the expression '#{xpath}'"
   results.each do |r|
      puts "Document #{r.name}"
      puts r
      print "Return to continue : "
      STDIN.gets
   end
   puts
rescue
   puts "Query #{xpath} failed : #{$!}"
end

options = {'home' => 'env', 'container' => 'name.xml'}

BDB::Env.new(options['home'], BDB::INIT_TRANSACTION).begin do |txn|
   con = txn.open_xml(options['container'])
   context = BDB::XML::Context.new
   context.set_namespace("fruits", "http://groceryItem.dbxml/fruits")
   context.set_namespace("vegetables", "http://groceryItem.dbxml/vegetables")
   context.set_namespace("desserts", "http://groceryItem.dbxml/desserts");
   update(con, "/fruits:item/product[text() = 'Zapote Blanco']", context)
   retrieve(con, "/fruits:item/product[text() = 'Zapote Blanco']", context)
   txn.commit
end