operations.hpp

Go to the documentation of this file.

/* LiteSQL 
 * 
 * The list of contributors at http://litesql.sf.net/ 
 * 
 * See LICENSE for copyright information. */
 
#ifndef __litesql_operations_hpp
#define __litesql_operations_hpp
#include "litesql/datasource.hpp"
namespace litesql {
using namespace std;
template <class T>
litesql::DataSource<T> select(const litesql::Database & db, 
                              const litesql::Expr &e=litesql::Expr()) {
    return litesql::DataSource<T>(db, e);
}

template <class T>
litesql::DataSource<T> intersect(const litesql::DataSource<T>& ds1, 
                                 const litesql::DataSource<T>& ds2) {
    std::string sel = ds1.idQuery().asString() + " INTERSECT " 
        + ds2.idQuery().asString();
    return litesql::DataSource<T>(ds1.getDatabase(), T::Id.in(sel));
}

template <class T>
litesql::DataSource<T> union_(const litesql::DataSource<T>& ds1, 
                              const litesql::DataSource<T>& ds2) {
    std::string sel = ds1.idQuery().asString() + " UNION " 
        + ds2.idQuery().asString();
    return litesql::DataSource<T>(ds1.getDatabase(), T::Id.in(sel));
}

template <class T>
litesql::DataSource<T> except(const litesql::DataSource<T>& ds1, 
                              const litesql::DataSource<T>& ds2) {
    std::string sel = ds1.idQuery().asString() + " EXCEPT " 
        + ds2.idQuery().asString();
    return litesql::DataSource<T>(ds1.getDatabase(), T::Id.in(sel));
}
 
}
#endif