Changeset 17830

Timestamp:

May 28, 2008, 10:49:34 AM (18 years ago)

Author:

jhoblitt

Message:

remove the use of LAST_INSERT_ID() from the new_object_instance query

Location:

trunk/Nebulous-Server

Files:

• Changes (modified) (1 diff)
• lib/Nebulous/Server.pm (modified) (2 diffs)
• lib/Nebulous/Server/SQL.pm (modified) (2 diffs)

trunk/Nebulous-Server/Changes

@@ -2 +2 @@
 
 0.12
+    - remove the use of LAST_INSERT_ID() from the new_object_instance query
     - add neb-admin util
     - fix Nebulous::Server::setxattr_object() so that creating a new xattr with

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

@@ -1 +1 @@
 # Copyright (c) 2004-2008  Joshua Hoblitt
 #
-# $Id: Server.pm,v 1.74 2008-05-21 19:57:19 jhoblitt Exp $
+# $Id: Server.pm,v 1.75 2008-05-28 20:49:34 jhoblitt Exp $
 
 package Nebulous::Server;
@@ -207 +207 @@
 
         {
+            
             # create instance with no URI
             my $query = $db->prepare_cached( $sql->new_object_instance );
-            $query->execute($vol_id);
+            $query->execute($so_id, $vol_id);
         }
 

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

@@ -1 +1 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.53 2008-05-27 22:09:35 jhoblitt Exp $
+# $Id: SQL.pm,v 1.54 2008-05-28 20:49:34 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -40 +40 @@
     new_object_instance => qq{
         INSERT INTO instance 
-        VALUES (NULL, LAST_INSERT_ID(), ?, 'error', NULL, NULL, NULL, NULL)
+        VALUES (NULL, ?, ?, 'error', NULL, NULL, NULL, NULL)
     },
     new_instance        => qq{