OpenNebula

        @db.fetch("SELECT * from group_pool") do |row|

            gid = row[:oid]

        end

        @db.fetch("SELECT * from cluster_pool") do |row|

            cluster_id = row[:oid]

        end

        @db.fetch("SELECT * from datastore_pool") do |row|

            ds_id = row[:oid]

        # Create a new empty table where we will store the new calculated values

        @db.run "CREATE TABLE host_pool_new (oid INTEGER PRIMARY KEY, " <<

                "last_mon_time INTEGER, uid INTEGER, gid INTEGER, " <<

                "owner_u INTEGER, group_u INTEGER, other_u INTEGER, " <<

                "cid INTEGER, UNIQUE(name));"

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

        # Create a new empty table where we will store the new calculated values

        # Calculate the host's xml and write them to host_pool_new

        @db[:image_pool].each do |row|

        # LEASES

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

        @db[:leases].each do |row|

            doc = Document.new(row[:body])

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

        # Create a new empty table where we will store the new calculated values

        @db[:network_pool].each do |row|

            doc = Document.new(row[:body])

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

        @db.run "ALTER TABLE user_pool RENAME TO old_user_pool;"

        # oneadmin does not have quotas

        @db.fetch("SELECT * FROM old_user_pool WHERE oid=0") do |row|

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

        @db.run "ALTER TABLE group_pool RENAME TO old_group_pool;"

        # oneadmin group does not have quotas

        @db.fetch("SELECT * FROM old_group_pool WHERE oid=0") do |row|