Changeset 1437 for trunk/scripts

Timestamp:

Oct 29, 2008, 9:24:59 PM (16 years ago)

Author:

price

Message:

more detail on migration: moving db entries

File:

• trunk/scripts/xvm-migrate-machine (modified) (3 diffs)

trunk/scripts/xvm-migrate-machine

@@ -1 @@
-##!/bin/bash
+#!/bin/python
 # Migrates the machine named $1 from the dev cluster.
 # To be run on the prod cluster.
@@ -5 +5 @@
 ## The present version is NOT A REAL SCRIPT.
 ## Things may not even be tested.  Copy and paste.
+not_ready_yet_do_not_run_me
 
+
+from invirt import database
+
+dev_db_uri = 'postgres://sipb-xen@sipb-xen-dev.mit.edu/sipb_xen'
+
+
+def take_data(machine_name):
 ## dump from dev db; save info well
+  database.connect(dev_db_uri)
+  database.session.begin()
+  machine = database.Machine.query().get_by(name=machine_name)
+  disks = database.Disk.query().filter_by(machine=machine).all()
+  nics = database.NIC.query().filter_by(machine=machine).all()
+## remove from dev db; ideally atomic with dump
+  for r in disks + nics + [machine]:
+    database.session.delete(r)
+  database.session.commit()
+  return machine, disks, nics
 
-#echo "\\a \\t \\\\ select * from machines where name = '$MACHINE';" \
-# | psql -h xvm -U sipb-xen sipb_xen -q
-## 581|fsck|256|price|price|2ab6638f-3f65-2b32-3fd3-c16b74a9b7fe|linux|f|1|price|test|f
-## watch out for funny characters in description; better (non-)quoting needed
-## also disks, nics
-
-## remove from dev db; ideally atomic with dump
 
 ## shut down if up
@@ -27 +38 @@
 
 ## add to dev db
+def restore_data(machine, disks, nics):
+  database.connect() # to prod DB
+  database.session.begin()
+  ## now copy machine, disks, nics to new ORM objects (yuck, oh well)
+  ## and database.session.save(those)
+  database.session.commit()
+
 
 ## power on if desired
+
+