catalogdb.h

Go to the documentation of this file.

/***************************************************************************
                catalogDB.h  -  K Desktop Planetarium
                             -------------------
    begin                : 2012/03/08
    copyright            : (C) 2012 by Rishab Arora
    email                : ra.rishab@gmail.com
 ***************************************************************************/

/***************************************************************************
 *                                                                         *
 *   This program is free software; you can redistribute it and/or modify  *
 *   it under the terms of the GNU General Public License as published by  *
 *   the Free Software Foundation; either version 2 of the License, or     *
 *   (at your option) any later version.                                   *
 *                                                                         *
 ***************************************************************************/

#ifndef CATALOGDB_H
#define CATALOGDB_H

#include <datahandlers/ksparser.h>
#include <datahandlers/catalogdata.h>
#include <datahandlers/catalogentrydata.h>
#include "kstars/skyobjects/starobject.h"
#include "kstars/skyobjects/deepskyobject.h"
#include "kstars/skycomponents/skycomponent.h"
#include <kstandarddirs.h>
#include <klocale.h>
#include <KDebug>
#include <KMessageBox>
#include <QSqlDatabase>
#include <QDebug>
#include <QSqlQuery>
#include <QSqlRecord>
#include <QSqlTableModel>
#include <QString>
#include <QHash>
#include <QSqlError>
#include <QVariant>
#include <QFile>
#include <QDir>


/* Some notes about the database. (skycomponents.db)
 * 1) The uid for Object Designation is the uid being used by objects in KStars
 *    hence, the uid is a qint64 i.e. a 64 bit signed integer. Coincidentaly,
 *    this is the max limit of an int in Sqlite3.
 *    Hence, the db is compatible with the uid, but doesn't use it as of now.
 */

class CatalogDB {
 public:
   bool Initialize();
   ~CatalogDB();
   QStringList* Catalogs();
   void RefreshCatalogList();
  bool AddCatalogContents(const QString &filename);

  int FindFuzzyEntry(const double ra, const double dec,
                     const double magnitude);

  void AddEntry(const CatalogEntryData &catalog_entry);

  void RemoveCatalog(const QString& catalog_name);

  void GetAllObjects(const QString &catalog_name,
                     QList< SkyObject* > &sky_list,
                     QList < QPair <int, QString> > &object_names,
                     CatalogComponent *catalog_pointer);

  void GetCatalogData(const QString& catalog_name,
                      CatalogData& catalog_data);

 private:
  QSqlDatabase skydb_;

  QSqlError LastError();

  QStringList catalog_list_;

  int FindCatalog(const QString &catalog_name);

  bool ParseCatalogInfoToDB(const QStringList &lines, QStringList &columns,
                            QString &catalog_name, char &delimiter);

  void AddCatalog(const CatalogData& catalog_data);

  QList< QPair< QString, KSParser::DataTypes > >
                              buildParserSequence(const QStringList& Columns);
  void ClearDSOEntries(int catalog_id);
  void FirstRun();
};

#endif  // CATALOGDB_H