ubiqadd.rb

if $*.empty?
  puts "usage: #$0 commands1 [, commands2, ...]"
  exit 1
end

$*.each do |file|
  @cmd = "file:///#{file.tr ?\\, ?/}"
  @apd = `echo %appdata%`.strip.tr ?\\, ?/
  @dbf = Dir.glob("#@apd/Mozilla/Firefox/Profiles/*/ubiquity_ann.sqlite").first
  @stt = 'insert or replace into ubiquity_annotation_memory'
  { autoupdate: true, commands: @cmd,
    confirmed: true, type: :commands }.each do |key, val|
    print `sqlite3 #@dbf "#@stt values('#@cmd','ubiquity/#{key}','#{val}')"`
    exit 1 if $?.exitstatus != 0
  end
  puts "Subscribed: #@cmd"
end