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

Timestamp:

Oct 14, 2008, 3:56:00 PM (18 years ago)

Author:

jhoblitt

Message:

add neb-voladm util

File:

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

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

@@ -1 +1 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.73 2008-10-14 20:35:07 jhoblitt Exp $
+# $Id: SQL.pm,v 1.74 2008-10-15 01:56:00 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -277 +277 @@
     },
     get_volumes => qq{
-        SELECT v.vol_id, v.name, v.host, v.path, v.allocate, v.available, v.xattr, mountedvol.vol_id > 0 as mounted
-        FROM volume as v
+        SELECT
+            v.vol_id,
+            v.name,
+            v.host,
+            v.path,
+            v.allocate,
+            v.available,
+            v.xattr,
+            mountedvol.vol_id IS NOT NULL as mounted
+        FROM volume AS v
         LEFT JOIN mountedvol
             USING(vol_id)