int DocDb::addSource(int packageId, string type, string return_type, string name, int parameter_count, string code) {
CHECK_CONNECTED(m_wrapper->isConnected);
try {
int id = -1;
SimpleResult res;
res = m_wrapper->addSourceQuery->execute(packageId, type, return_type, name, parameter_count, code);
id = res.insert_id();
return id;
} catch (const Exception &ex) {
printException(ex);
return -1;
}
}
int DocDb::addPackage(string name, string filename, string url) {
CHECK_CONNECTED(m_wrapper->isConnected);
try {
int id = -1;
SimpleResult res;
res = m_wrapper->addPackageQuery->execute(name, filename, url);
id = res.insert_id();
return id;
} catch (const Exception &ex) {
printException(ex);
return -1;
}
}
int DocDb::addDependencyId(int packageId, int sourceId, int dependsOn) {
CHECK_CONNECTED(m_wrapper->isConnected);
try {
int id = -1;
SimpleResult res;
res = m_wrapper->addDependsIdQuery->execute(packageId,sourceId,dependsOn);
id = res.insert_id();
return id;
} catch (const Exception &ex) {
printException(ex);
return -1;
}
}
uint32_t createUserAccount(
Connection* connPtr,
const char* username,
const char* passwd,
const char* phone,
const char* email,
uint32_t current) {
if(!connPtr) {
return 0;
}
if(!phone && !email) {
return 0;
}
account acc;
SimpleResult result;
acc.accid = mysqlpp::null;
acc.name = username;
acc.passwd = passwd;
acc.icon = mysqlpp::null;
if(phone) acc.number = phone;
else acc.number = mysqlpp::null;
if(email) acc.email = email;
else acc.email = mysqlpp::null;
acc.authtype = 0;
acc.createtime = current;
acc.acctype = static_cast<sql_tinyint_unsigned>(ACCOUNT_UESR);
try {
mysqlpp::Query query = connPtr->query();
query.insert(acc);
// Show the query about to be executed.
std::cout << "Query: " << query << std::endl;
result = query.execute();
}
catch (const mysqlpp::Exception& er) {
// Catch-all for any other MySQL++ exceptions
return 0;
}
return result.insert_id();
}
bool _ftpEntry::dbAddFile(_ftpEntry *newEntry) {
Query QueryNewFolder = _sqlConnection->query();
QueryNewFolder << "INSERT INTO ServerFiles VALUES(";
// Build the query
dbFileQuery(QueryNewFolder, newEntry);
// hit it!
SimpleResult res = QueryNewFolder.execute();
if(!res.rows())
return false; // No Row added
// Get the AutoID Field
newEntry->setFolderID(res.insert_id());
return true;
}
int DocDb::addDependencyName(int packageId, int sourceId, string dependsOn) {
CHECK_CONNECTED(m_wrapper->isConnected);
try {
int id = -1;
int existingId = -1;
SimpleResult res;
existingId = getGlobalSourceIdFromName(dependsOn);
if (existingId != -1) {
return addDependencyId(packageId, sourceId, existingId);
}
res = m_wrapper->addDependsNameQuery->execute(packageId,sourceId,dependsOn);
id = res.insert_id();
return id;
} catch (const Exception &ex) {
printException(ex);
return -1;
}
}
