Changeset 13173 for trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm

Timestamp:

May 2, 2007, 3:44:24 PM (19 years ago)

Author:

jhoblitt

Message:

better paramter checking
overhaul instance table
add ->_is_valid_object_key() method
change ->find_instances() to check it's params and only return instances on mounted & available volumes

File:

• trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm (modified) (3 diffs)

trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm

@@ -1 +1 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.33 2007-05-02 20:53:42 jhoblitt Exp $
+# $Id: SQL.pm,v 1.34 2007-05-03 01:44:24 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -144 +144 @@
         WHERE so_id = ?
     },
-    get_object_instances        => qq{
-        SELECT storage_object.so_id,
-            uri, assigned_location
-        FROM storage_object
-        LEFT JOIN instance
-        USING (so_id)
-        WHERE ext_id = ?
+    get_object_instances    => qq{
+        SELECT
+            storage_object.so_id,
+            uri,
+            assigned_vol_id
+        FROM storage_object
+        JOIN instance
+            USING (so_id)
+        JOIN mountedvol
+            USING(vol_id)
+        WHERE ext_id = ?
+            AND available = ?
+    },
+    get_object_instances_by_vol_name => qq{
+        SELECT
+            storage_object.so_id,
+            uri,
+            assigned_vol_id
+        FROM storage_object
+        JOIN instance
+            USING (so_id)
+        JOIN mountedvol
+            USING(vol_id)
+        WHERE ext_id = ?
+            AND name = ?
+            AND available = ?
     },
     get_storage_volume_byname   => qq{
@@ -284 +303 @@
     uri VARCHAR(255) NOT NULL,
     sha1sum CHAR(40) ASCII,
-    assigned_location BOOL,
+    assigned_vol_id INT,
     epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     mtime TIMESTAMP,