Method slotOpenSQLiteDB

Examples/Infovis/Cxx/StatsView/StatsView.cxx:76–172

Action to be taken upon graph file open

// Action to be taken upon graph file open
void StatsView::slotOpenSQLiteDB()
{
  // Browse for and open the file
  QDir dir;

  // Open the text data file
  QString fileName = QFileDialog::getOpenFileName(this, "Select the SQLite database file",
    QDir::homePath(), "SQLite Files (*.db);;All Files (*.*)");

  if (fileName.isNull())
  {
    std::cerr << "Could not open file" << endl;
    return;
  }

  // Create SQLite reader
  QString fullName = "sqlite://" + fileName;
  vtkSQLiteDatabase* db =
    vtkSQLiteDatabase::SafeDownCast(vtkSQLDatabase::CreateFromURL(fullName.toUtf8().data()));
  bool status = db->Open("");
  if (!status)
  {
    std::cerr << "Couldn't open database.\n";
    return;
  }

  // Query database
  vtkSQLQuery* query = db->GetQueryInstance();
  query->SetQuery("SELECT * from main_tbl");
  this->RowQueryToTable->SetQuery(query);

  // Calculate descriptive statistics
  VTK_CREATE(vtkDescriptiveStatistics, descriptive);
  descriptive->SetInputConnection(0, this->RowQueryToTable->GetOutputPort());
  descriptive->AddColumn("Temp1");
  descriptive->AddColumn("Temp2");
  descriptive->Update();

  // Calculate order statistics -- quartiles
  VTK_CREATE(vtkOrderStatistics, order1);
  order1->SetInputConnection(0, this->RowQueryToTable->GetOutputPort());
  order1->AddColumn("Temp1");
  order1->AddColumn("Temp2");
  order1->SetQuantileDefinition(vtkOrderStatistics::InverseCDFAveragedSteps);
  order1->Update();

  // Calculate order statistics -- deciles
  VTK_CREATE(vtkOrderStatistics, order2);
  order2->SetInputConnection(0, this->RowQueryToTable->GetOutputPort());
  order2->AddColumn("Temp1");
  order2->AddColumn("Temp2");
  order2->SetNumberOfIntervals(10);
  order2->Update();

  // Calculate correlative statistics
  VTK_CREATE(vtkCorrelativeStatistics, correlative);
  correlative->SetInputConnection(0, this->RowQueryToTable->GetOutputPort());
  correlative->AddColumnPair("Temp1", "Temp2");