Changeset 2902 for trunk/Nebulous-Server/lib/Nebulous/Server.pm

Timestamp:

Jan 4, 2005, 5:19:12 PM (22 years ago)

Author:

jhoblitt

Message:

remove raw SQl from _get_storage_volume

File:

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

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

@@ -1 +1 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: Server.pm,v 1.4 2005-01-05 03:10:08 jhoblitt Exp $
+# $Id: Server.pm,v 1.5 2005-01-05 03:19:12 jhoblitt Exp $
 
 package PS::IPP::IData::Server;
@@ -631 +631 @@
             my $rows;
             if ( $name ) {
-                $query = $db->prepare( qq{ SELECT uri FROM volume WHERE name = ? ORDER BY rand() LIMIT 1 } );
+                $query = $db->prepare( $sql->get_storage_volume_byname );
                 $rows = $query->execute( $name );
             } else {
-                $query = $db->prepare( qq{ SELECT uri FROM volume ORDER BY rand() LIMIT 1 } );
+                $query = $db->prepare( $sql->get_storage_volume );
                 $rows = $query->execute;
             }