Package net.sourceforge.squirrel_sql.plugins.mssql.sql.dbfile

Examples of net.sourceforge.squirrel_sql.plugins.mssql.sql.dbfile.DatabaseFile

459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
                        return;
                   
                    DatabaseFileInfo info = MssqlIntrospector.getDatabaseFileInfo(nodes[0].toString(), _session.getSQLConnection());
                    Object[] files = info.getDataFiles();
                    for (int i = 0; i < files.length; i++) {
                        DatabaseFile file = (DatabaseFile) files[i];
                        final ShrinkDatabaseFileAction shrinkDatabaseFileAction = new ShrinkDatabaseFileAction(app,_resources,plugin,nodes[0].toString(),file);
                        shrinkDatabaseFileAction.setSession(_session);
                        coll.add(shrinkDatabaseFileAction);
                        _resources.addToMenu(shrinkDatabaseFileAction,menu);
                    }
                    menu.addSeparator();
                    files = info.getLogFiles();
                    for (int i = 0; i < files.length; i++) {
                        DatabaseFile file = (DatabaseFile) files[i];
                        final ShrinkDatabaseFileAction shrinkDatabaseFileAction = new ShrinkDatabaseFileAction(app,_resources,plugin,nodes[0].toString(),file);
                        shrinkDatabaseFileAction.setSession(_session);
                        coll.add(shrinkDatabaseFileAction);
                        _resources.addToMenu(shrinkDatabaseFileAction,menu);
                    }
View Full Code Here
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
        String size = rs.getString(5);
        String maxSize = rs.getString(6);
        String growth = rs.getString(7);
        String usage = rs.getString(8);

        DatabaseFile file = new DatabaseFile();
        file.setName(name);
        file.setId(id);
        file.setFilename(filename);
        file.setFilegroup(filegroup);
        file.setSize(size);
        file.setMaxSize(maxSize);
        file.setGrowth(growth);
        file.setUsage(usage);

        if (filegroup == null) dbInfo.addLogFile(file);
        else dbInfo.addDataFile(file);
      }
    }
View Full Code Here
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
    buf.append("]\nON ");

    String lastFilegroup = "";
    for (int i = 0; i < dataFiles.length; i++)
    {
      DatabaseFile file = (DatabaseFile) dataFiles[i];

      String thisFilegroup = file.getFilegroup();
      if (!thisFilegroup.equals(lastFilegroup))
      {
        // if it's PRIMARY, just write it without the FILEGROUP prefix.
        if (thisFilegroup.equals("PRIMARY")) buf.append("PRIMARY");
        else
        {
          buf.append("FILEGROUP ");
          buf.append(thisFilegroup);
        }
        buf.append("\n");
        lastFilegroup = thisFilegroup;
      }

      buf.append("( NAME = ");
      buf.append(file.getName());
      buf.append(",\n\tFILENAME = '");
      buf.append(file.getFilename());
      buf.append("',\n\tSIZE = ");
      buf.append(file.getSize());
      if (!file.getMaxSize().equals("Unlimited"))
      {
        buf.append(",\n\tMAXSIZE = ");
        buf.append(file.getMaxSize());
      }
      buf.append(",\n\tFILEGROWTH = ");
      buf.append(file.getGrowth());
      buf.append(" )");

      if (i < dataFiles.length - 1) buf.append(",");
      buf.append("\n");
    }

    buf.append("LOG ON\n");
    for (int i = 0; i < logFiles.length; i++)
    {
      DatabaseFile file = (DatabaseFile) logFiles[i];

      buf.append("( NAME = ");
      buf.append(file.getName());
      buf.append(",\n\tFILENAME = '");
      buf.append(file.getFilename());
      buf.append("',\n\tSIZE = ");
      buf.append(file.getSize());
      if (!file.getMaxSize().equals("Unlimited"))
      {
        buf.append(",\n\tMAXSIZE = ");
        buf.append(file.getMaxSize());
      }
      buf.append(",\n\tFILEGROWTH = ");
      buf.append(file.getGrowth());
      buf.append(" )");

      if (i < logFiles.length - 1) buf.append(",");

      buf.append("\n");
View Full Code Here
TOP

Related Classes of net.sourceforge.squirrel_sql.plugins.mssql.sql.dbfile.DatabaseFile

  • net.sourceforge.squirrel_sql.plugins.mssql.MssqlPlugin
  • net.sourceforge.squirrel_sql.plugins.mssql.util.MssqlIntrospector
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.