Changeset 13302 for trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm
- Timestamp:
- May 7, 2007, 4:27:42 PM (19 years ago)
- File:
-
- 1 edited
-
trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm (modified) (8 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm
r13251 r13302 1 1 # Copyright (c) 2004 Joshua Hoblitt 2 2 # 3 # $Id: SQL.pm,v 1.4 0 2007-05-04 23:36:46jhoblitt Exp $3 # $Id: SQL.pm,v 1.41 2007-05-08 02:27:42 jhoblitt Exp $ 4 4 5 5 package Nebulous::Server::SQL; … … 204 204 vol_id, 205 205 path, 206 xattr, 206 207 total - used as free 207 208 FROM mountedvol … … 218 219 vol_id, 219 220 path, 221 xattr, 220 222 total - used as free 221 223 FROM mountedvol … … 228 230 }, 229 231 new_volume => qq{ 230 INSERT INTO volume (name, path, allocate, available )231 VALUES (?, ?, TRUE, TRUE )232 INSERT INTO volume (name, path, allocate, available, xattr) 233 VALUES (?, ?, TRUE, TRUE, FALSE) 232 234 }, 233 235 get_volume_by_name => qq{ … … 359 361 allocate BOOLEAN DEFAULT FALSE, 360 362 available BOOLEAN DEFAULT FALSE, 363 xattr BOOLEAN DEFAULT FALSE, 361 364 PRIMARY KEY(vol_id), 362 365 KEY(name(16)), … … 396 399 allocate BOOLEAN DEFAULT FALSE, 397 400 available BOOLEAN DEFAULT FALSE, 401 xattr BOOLEAN DEFAULT FALSE, 398 402 KEY(vol_id), 399 403 KEY(allocate), … … 411 415 DECLARE allocatevar BOOLEAN; 412 416 DECLARE availablevar BOOLEAN; 417 DECLARE xattrvar BOOLEAN; 413 418 DECLARE trans_level VARCHAR(255); 414 DECLARE cur1 CURSOR FOR SELECT vol_id, name, path, allocate, available FROM volume;419 DECLARE cur1 CURSOR FOR SELECT vol_id, name, path, allocate, available, xattr FROM volume; 415 420 DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = TRUE; 416 421 … … 430 435 431 436 myloop: LOOP 432 FETCH cur1 INTO vol_idvar, namevar, pathvar, allocatevar, availablevar ;437 FETCH cur1 INTO vol_idvar, namevar, pathvar, allocatevar, availablevar, xattrvar; 433 438 IF `done` THEN LEAVE myloop; END IF; 434 439 INSERT INTO mountedvol 435 SELECT mountpoint, total, used, vol_idvar, namevar, pathvar, allocatevar, availablevar 440 SELECT mountpoint, total, used, vol_idvar, namevar, pathvar, allocatevar, availablevar, xattrvar 436 441 FROM 437 442 (SELECT *, INSTR(pathvar, mountpoint) = 1 as substring
Note:
See TracChangeset
for help on using the changeset viewer.
