DatabaseUtils.hpp

#ifndef DATABASEUTILS_HPP
#define DATABASEUTILS_HPP

#include "Export.hpp"
#include "GraphTypes.hpp"

#include <QStringList>
#include <QSqlQuery>

namespace Showcase
{

  namespace DB
  {

    SHOWCASE_API QString uiNodePropsForTagQuery(const QString & uiNodeId, const QString & themeId);
    SHOWCASE_API QString uiNodePropsForEmptyTagQuery(const QString & uiNodeId, const QString & themeId);
    SHOWCASE_API QString themePropertiesForComp(const QString & component, const QString & themeId);
    SHOWCASE_API QString themeDefaults(const QString & themeId);

    SHOWCASE_API NodeId dbNodeId(const QString & server, const QString & table, const QString & id);
    SHOWCASE_API NodeId dbNodeIdWithKey(const QString & server, const QString & table, const QString & id,
                                        const QString & key);
    SHOWCASE_API QString getServer(const NodeId & nodeId);
    SHOWCASE_API QString getTable(const NodeId & nodeId);
    SHOWCASE_API QString getId(const NodeId & nodeId);
    SHOWCASE_API QString getKey(const NodeId & nodeId);
    SHOWCASE_API QString getQueryItem(const NodeId & nodeId, const QString & item);

    SHOWCASE_API NodeId getBaseNodeId(const NodeId & nodeId);

    SHOWCASE_API QString getPropertyTable(const NodeId & nodeId);
    SHOWCASE_API QString getIdTest(const QString & table);

    SHOWCASE_API QStringList getPropertyColumns(const QString & table);

    SHOWCASE_API QString simpleSelectQuery(const QStringList& columns,
                                           const QString& table,
                                           const QStringList& arguments);

    SHOWCASE_API QList<QVariantMap> query(QSqlQuery& query, const QStringList& columns);

    SHOWCASE_API QString selectAll(const QStringList &columns, const QString &table);

    SHOWCASE_API QString rewriteServerUrl(const QString& dbServer);

    SHOWCASE_API NodeId componentThemeNodeId(const QString & componentName,
                                             const QString & server);

    SHOWCASE_API QString getContentNodeType(const NodeId & node);

    SHOWCASE_API QString selectDefaultViewers(const QString & type,
                                              const QString & theme,
                                              QStringList & resultColumns);
    SHOWCASE_API QString parseViewerForMime(const QList<QVariantMap> & queryResult,
                                            const QString & mime);
  }
}

#endif // DATABASEUTILS_HPP