scottk/wlan-cloud-ucentralfms
1
0
Fork 0
mirror of https://github.com/Telecominfraproject/wlan-cloud-ucentralfms.git synced 2026-01-09 21:41:40 +00:00
Code Issues Packages Projects Releases 10 Wiki Activity
Files
jaspreet-test
wlan-cloud-ucentralfms/src/storage_firmwares.cpp
stephb9959 e89ae33f58 Move to 2.1
2021-08-21 11:40:04 -07:00

341 lines
13 KiB
C++
Raw Permalink Blame History

//
// Created by stephane bourque on 2021-05-09.
//
#include "StorageService.h"
#include "RESTAPI_FMSObjects.h"
#include "RESTAPI_utils.h"
#include "LatestFirmwareCache.h"
#include "Daemon.h"
#include <limits>
namespace OpenWifi {
bool Convert(const FirmwaresRecord &T, FMSObjects::Firmware & F) {
F.id = T.get<0>();
F.release = T.get<1>();
F.deviceType = T.get<2>();
F.description = T.get<3>();
F.revision = T.get<4>();
F.uri = T.get<5>();
F.image = T.get<6>();
F.imageDate = T.get<7>();
F.size = T.get<8>();
F.downloadCount = T.get<9>();
F.firmwareHash = T.get<10>();
F.owner = T.get<11>();
F.location = T.get<12>();
F.uploader = T.get<13>();
F.digest = T.get<14>();
F.latest = T.get<15>();
F.notes = RESTAPI_utils::to_object_array<SecurityObjects::NoteInfo>(T.get<16>());
F.created = T.get<17>();
return true;
}
bool Convert(const FMSObjects::Firmware & F, FirmwaresRecord & T) {
T.set<0>(F.id);
T.set<1>(F.release);
T.set<2>(F.deviceType);
T.set<3>(F.description);
T.set<4>(F.revision);
T.set<5>(F.uri);
T.set<6>(F.image);
T.set<7>(F.imageDate);
T.set<8>(F.size);
T.set<9>(F.downloadCount);
T.set<10>(F.firmwareHash);
T.set<11>(F.owner);
T.set<12>(F.location);
T.set<13>(F.uploader);
T.set<14>(F.digest);
T.set<15>(F.latest);
T.set<16>(RESTAPI_utils::to_string(F.notes));
T.set<17>(F.created);
return true;
}
bool Storage::AddFirmware(FMSObjects::Firmware & F) {
try {
Poco::Data::Session Sess = Pool_->get();
Poco::Data::Statement Insert(Sess);
// find the older software and change to latest = 0
F.id = Daemon()->CreateUUID();
if(LatestFirmwareCache()->AddToCache(F.deviceType,F.revision,F.id,F.imageDate)) {
F.latest = true ;
Poco::Data::Statement Update(Sess);
std::string st{"UPDATE " + DBNAME_FIRMWARES + " SET latest=0 WHERE deviceType=? AND Latest=1"};
Update << ConvertParams(st),
Poco::Data::Keywords::use(F.deviceType);
Update.execute();
} else {
F.latest = false;
}
auto Notes = RESTAPI_utils::to_string(F.notes);
std::string st{"INSERT INTO " + DBNAME_FIRMWARES + " (" +
DBFIELDS_FIRMWARES_SELECT +
") VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"};
Insert << ConvertParams(st),
Poco::Data::Keywords::use(F.id),
Poco::Data::Keywords::use(F.release),
Poco::Data::Keywords::use(F.deviceType),
Poco::Data::Keywords::use(F.description),
Poco::Data::Keywords::use(F.revision),
Poco::Data::Keywords::use(F.uri),
Poco::Data::Keywords::use(F.image),
Poco::Data::Keywords::use(F.imageDate),
Poco::Data::Keywords::use(F.size),
Poco::Data::Keywords::use(F.downloadCount),
Poco::Data::Keywords::use(F.firmwareHash),
Poco::Data::Keywords::use(F.owner),
Poco::Data::Keywords::use(F.location),
Poco::Data::Keywords::use(F.uploader),
Poco::Data::Keywords::use(F.digest),
Poco::Data::Keywords::use(F.latest),
Poco::Data::Keywords::use(Notes),
Poco::Data::Keywords::use(F.created);
Insert.execute();
return true;
} catch (const Poco::Exception &E) {
Logger_.log(E);
}
return false;
}
bool Storage::UpdateFirmware(std::string & ID, FMSObjects::Firmware & F) {
try {
Poco::Data::Session Sess = Pool_->get();
Poco::Data::Statement Update(Sess);
std::string st{"UPDATE " + DBNAME_FIRMWARES + " set " + DBFIELDS_FIRMWARES_UPDATE +
" WHERE id=?"};
auto Notes = RESTAPI_utils::to_string(F.notes);
Update << ConvertParams(st),
Poco::Data::Keywords::use(F.id),
Poco::Data::Keywords::use(F.release),
Poco::Data::Keywords::use(F.deviceType),
Poco::Data::Keywords::use(F.description),
Poco::Data::Keywords::use(F.revision),
Poco::Data::Keywords::use(F.uri),
Poco::Data::Keywords::use(F.image),
Poco::Data::Keywords::use(F.imageDate),
Poco::Data::Keywords::use(F.size),
Poco::Data::Keywords::use(F.downloadCount),
Poco::Data::Keywords::use(F.firmwareHash),
Poco::Data::Keywords::use(F.owner),
Poco::Data::Keywords::use(F.location),
Poco::Data::Keywords::use(F.uploader),
Poco::Data::Keywords::use(F.digest),
Poco::Data::Keywords::use(F.latest),
Poco::Data::Keywords::use(Notes),
Poco::Data::Keywords::use(F.created),
Poco::Data::Keywords::use(ID);
Update.execute();
return true;
} catch (const Poco::Exception &E) {
Logger_.log(E);
}
return false;
}
bool Storage::DeleteFirmware(std::string & ID) {
try {
Poco::Data::Session Sess = Pool_->get();
Poco::Data::Statement Delete(Sess);
std::string st{"DELETE FROM " + DBNAME_FIRMWARES + " WHERE id=?"};
Delete << ConvertParams(st),
Poco::Data::Keywords::use(ID);
Delete.execute();
return true;
} catch (const Poco::Exception &E) {
Logger_.log(E);
}
return false;
}
bool Storage::GetFirmware(std::string & ID, FMSObjects::Firmware & F) {
try {
Poco::Data::Session Sess = Pool_->get();
Poco::Data::Statement Select(Sess);
std::string st{"SELECT " + DBFIELDS_FIRMWARES_SELECT +
" FROM " + DBNAME_FIRMWARES + " WHERE id=?"};
FirmwaresRecordList Records;
Select << ConvertParams(st),
Poco::Data::Keywords::into(Records),
Poco::Data::Keywords::use(ID);
Select.execute();
if(Records.empty())
return false;
Convert(Records[0],F);
return true;
} catch (const Poco::Exception &E) {
Logger_.log(E);
}
return false;
}
bool Storage::GetFirmwareByName( std::string & Release, std::string &DeviceType, FMSObjects::Firmware & Firmware ) {
try {
FirmwaresRecordList Records;
Poco::Data::Session Sess = Pool_->get();
Poco::Data::Statement Select(Sess);
std::string st{"SELECT " + DBFIELDS_FIRMWARES_SELECT +
" FROM " + DBNAME_FIRMWARES + " where release=? and DeviceType=?"};
Select << ConvertParams(st),
Poco::Data::Keywords::into(Records),
Poco::Data::Keywords::use(Release),
Poco::Data::Keywords::use(DeviceType);
Select.execute();
if(Records.empty())
return false;
Convert(Records[0],Firmware);
return true;
} catch (const Poco::Exception &E) {
Logger_.log(E);
}
return false;
}
bool Storage::GetFirmwareByRevision(std::string & Revision, std::string &DeviceType,FMSObjects::Firmware & Firmware ) {
try {
FirmwaresRecordList Records;
Poco::Data::Session Sess = Pool_->get();
Poco::Data::Statement Select(Sess);
std::string st{"SELECT " + DBFIELDS_FIRMWARES_SELECT +
" FROM " + DBNAME_FIRMWARES + " where Revision=? and DeviceType=?"};
Select << ConvertParams(st),
Poco::Data::Keywords::into(Records),
Poco::Data::Keywords::use(Revision),
Poco::Data::Keywords::use(DeviceType);
Select.execute();
if (Records.empty())
return false;
Convert(Records[0], Firmware);
return true;
} catch (const Poco::Exception &E) {
Logger_.log(E);
}
return false;
}
bool Storage::GetFirmwares(uint64_t From, uint64_t HowMany, std::string & Compatible, FMSObjects::FirmwareVec & Firmwares) {
try {
FirmwaresRecordList Records;
Poco::Data::Session Sess = Pool_->get();
Poco::Data::Statement Select(Sess);
std::string st;
if(Compatible.empty()) {
st = "SELECT " + DBFIELDS_FIRMWARES_SELECT + " FROM " + DBNAME_FIRMWARES + " ORDER BY Id ASC ";
Select << ConvertParams(st) + ComputeRange(From, HowMany),
Poco::Data::Keywords::into(Records);
} else {
st = "SELECT " + DBFIELDS_FIRMWARES_SELECT + " FROM " + DBNAME_FIRMWARES + " where DeviceType=? ORDER BY Id ASC ";
Select << ConvertParams(st) + ComputeRange(From, HowMany),
Poco::Data::Keywords::into(Records),
Poco::Data::Keywords::use(Compatible);
}
Select.execute();
for(const auto &R:Records) {
FMSObjects::Firmware F;
Convert(R,F);
Firmwares.push_back(F);
}
return true;
} catch (const Poco::Exception &E) {
Logger_.log(E);
}
return false;
}
void Storage::PopulateLatestFirmwareCache() {
try {
typedef Poco::Tuple<
std::string,
std::string,
uint64_t,
std::string> FCE;
typedef std::vector<FCE> FCEList;
Poco::Data::Session Sess = Pool_->get();
Poco::Data::Statement Select(Sess);
std::string st{"SELECT Id, DeviceType, ImageDate, Revision FROM " + DBNAME_FIRMWARES};
FCEList Records;
Select << ConvertParams(st),
Poco::Data::Keywords::into(Records);
Select.execute();
for(const auto &R:Records) {
LatestFirmwareCache()->AddToCache(R.get<1>(), R.get<3>(), R.get<0>(), R.get<2>());
}
} catch (const Poco::Exception &E) {
Logger_.log(E);
}
}
bool Storage::ComputeFirmwareAge(std::string & DeviceType, std::string & Revision, FMSObjects::FirmwareAgeDetails &AgeDetails) {
try {
FMSObjects::Firmware CurrentFirmware;
FMSObjects::Firmware LatestFirmware;
bool CurrentFirmwareExists = false;
if(GetFirmwareByRevision(Revision,DeviceType,CurrentFirmware)) {
CurrentFirmwareExists = true;
}
LatestFirmwareCacheEntry LE;
if(LatestFirmwareCache()->FindLatestFirmware(DeviceType,LE)) {
// std::cout << "LE.id" << LE.Id << std::endl;
if(GetFirmware(LE.Id, LatestFirmware)) {
AgeDetails.imageDate = LatestFirmware.imageDate;
AgeDetails.uri = LatestFirmware.uri;
AgeDetails.image = LatestFirmware.image;
AgeDetails.revision = LatestFirmware.revision;
AgeDetails.latestId = LatestFirmware.id;
// std::cout << " Revision='" << Revision << "'" << std::endl;
// std::cout << "LF Revision='" << LatestFirmware.revision << "'" << std::endl;
AgeDetails.latest = (Revision == LatestFirmware.revision);
// std::cout << "Latest=" << AgeDetails.latest << std::endl;
AgeDetails.age = CurrentFirmwareExists ? (LatestFirmware.imageDate - CurrentFirmware.imageDate) : 0;
//std::cout << "Revision: '" << Revision << "' vs '" << LatestFirmware.revision << "'" << std::endl;
//if (AgeDetails.latest)
// std::cout << "Found latest firmware" << std::endl;
return true;
} else {
// std::cout << "Cannot find firmware: " << LE.Id << std::endl;
}
}
} catch (const Poco::Exception &E) {
Logger_.log(E);
}
return false;
}
}
Reference in New Issue View Git Blame Copy Permalink