OpenNebula

#!/bin/bash

DB_pre="/var/lib/one/one.db"

DB_post="/var/lib/one/one-1.4.db"

rm -f $DB_post

## host_pool

echo "CREATE TABLE host_pool (oid INTEGER PRIMARY KEY,host_name TEXT,state INTEGER,im_mad TEXT,vm_mad TEXT,tm_mad TEXT,last_mon_time INTEGER);" | tee | sqlite3 $DB_post 

sqlite3 $DB_pre 'SELECT * FROM host_pool;' | awk -F'|' '{print "INSERT INTO host_pool VALUES( \"" $1 "\", \"" $2 "\", \"" $3 "\", \"" $4 "\", \"" $5 "\", \"" $6 "\", \"" $7 "\" );"}' | tee |sqlite3 $DB_post 

## vm_pool

echo 'CREATE TABLE vm_pool (oid INTEGER PRIMARY KEY,uid INTEGER,name TEXT,last_poll INTEGER, template_id INTEGER,state INTEGER,lcm_state INTEGER,stime INTEGER,etime INTEGER,deploy_id TEXT,memory INTEGER,cpu INTEGER,net_tx INTEGER,net_rx INTEGER);' | tee | sqlite3 $DB_post 

echo 'select v.*,a.value from vm_pool v , vm_attributes a where a.id=v.oid and a.name='"'NAME';" | sqlite3 $DB_pre | awk -F'|' '{print "INSERT INTO vm_pool VALUES( \"" $1 "\", \"" $2 "\", \"" $14 "\", \"" $3 "\", \"" $4 "\", \"" $5 "\", \"" $6 "\", \"" $7 "\", \"" $8 "\", \"" $9 "\", \"" $10 "\", \"" $11 "\", \"" $12 "\", \"" $13 "\" );"}' | tee |sqlite3 $DB_post

##host_shares

echo 'CREATE TABLE host_shares (hid INTEGER PRIMARY KEY,disk_usage INTEGER, mem_usage INTEGER, cpu_usage INTEGER,max_disk  INTEGER,  max_mem   INTEGER, max_cpu   INTEGER,free_disk INTEGER,  free_mem  INTEGER, free_cpu  INTEGER,used_disk INTEGER,  used_mem  INTEGER, used_cpu  INTEGER,running_vms INTEGER);' | sqlite3 $DB_post

echo 'SELECT * FROM host_shares;' | sqlite3 $DB_pre  | awk -F'|' '{print "INSERT INTO host_shares VALUES( \"" $1 "\", \"" $3 "\", \"" $4 "\", \"" $5 "\", \"" $6 "\", \"" $7 "\", \"" $8 "\", 0, 0, 0, 0 ,0 , 0, \"" $9"\");"  }' | sqlite3 $DB_post 

##user_pool

echo 'CREATE TABLE user_pool (oid INTEGER,user_name TEXT,password TEXT,enabled INTEGER, PRIMARY KEY(oid,user_name), UNIQUE(user_name));' | tee | sqlite3 $DB_post

##all other

for table in history host_attributes leases network_pool vm_attributes vn_template 

do

	echo ".dump $table" | sqlite3 $DB_pre | tee | sqlite3 $DB_post

done