summaryrefslogtreecommitdiff
path: root/p2pvr/lib/si.cpp
blob: 032220e125cc4de61b315005ddf31e26e8c92e20 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
#include "si.h"
#include "dvbsiHelpers.h"
#include "sqlContainerCreator.h"
#include <linux/dvb/frontend.h>
#include <rdbmsDataSource.h>
#include <selectcommand.h>
#include <logger.h>

typedef boost::shared_ptr<DB::SelectCommand> SelectPtr;

P2PVR::Deliveries
SI::GetAllDeliveries(short type, const Ice::Current &)
{
	auto db = dataSource<RdbmsDataSource>("postgres");
	Logger()->messagebf(LOG_DEBUG, "%s(type %d)", __PRETTY_FUNCTION__, type);
	P2PVR::Deliveries rtn;
	SelectPtr sel;
	switch (type) {
		case FE_OFDM:
			{
				SqlContainerCreator<P2PVR::Deliveries, DVBSI::TerrestrialDelivery> cc(rtn);
				sel = SelectPtr(db->getReadonly().newSelectCommand("SELECT * FROM delivery_dvbt"));
				cc.populate(sel);
				break;
			}
		case FE_QAM:
			{
				SqlContainerCreator<P2PVR::Deliveries, DVBSI::CableDelivery> cc(rtn);
				sel = SelectPtr(db->getReadonly().newSelectCommand("SELECT * FROM delivery_dvbc"));
				cc.populate(sel);
				break;
			}
		case FE_QPSK:
			{
				SqlContainerCreator<P2PVR::Deliveries, DVBSI::SatelliteDelivery> cc(rtn);
				sel = SelectPtr(db->getReadonly().newSelectCommand("SELECT * FROM delivery_dvbs"));
				cc.populate(sel);
				break;
			}
	}
	Logger()->messagebf(LOG_DEBUG, "%s: Found %d delivery methods", __PRETTY_FUNCTION__, rtn.size());
	return rtn;
}

DVBSI::ServiceList
SI::GetServices(const Ice::Current&)
{
	auto db = dataSource<RdbmsDataSource>("postgres");
	DVBSI::ServiceList rtn;
	SqlContainerCreator<DVBSI::ServiceList, DVBSI::Service> cc(rtn);
	cc.populate(SelectPtr(db->getReadonly().newSelectCommand("SELECT * FROM services ORDER BY serviceId")));
	return rtn;
}