String HtmlTabCtrl::getPageLink(uint32 index)
{
OS_EXCEPT_IF(hasID() == false, "Invalid tabctrl id");
OS_EXCEPT_IF(getRequest() == nullptr, "Invalid request object");
ordered_map<std::wstring, std::wstring> params(getRequest()->getUrlParams());
params.set(getTarget().to_wide(), conversions::to_wstring(index));
return HttpParser::generateLink(getRequest()->getRawUrl(), params);
}
void Statement::prepare(sqlite3 *connection, const String &sql)
{
OS_ASSERT(m_statement == nullptr);
OS_EXCEPT_IF(connection == nullptr, "Invalid connection");
m_connection = connection;
sqlite_int res = safe_sqlite_prepare(connection, sql, &m_statement);
OS_EXCEPT_IF(res != SQLITE_OK, sqlite_last_error(connection, res));
}
bool ObjectsSystem::start(bool recovery)
{
ObjectsIDescriptorClass::descriptors_classes &classes = ObjectsIDescriptorClass::getClasses();
for(ObjectsIDescriptorClass::descriptors_classes::iterator i = classes.begin(); i != classes.end(); ++i)
{
shared_ptr<ObjectsIDescriptor> descriptor = (*i)->create();
OS_EXCEPT_IF(descriptor == nullptr, "Cannot create descriptor class");
OS_EXCEPT_IF(m_descriptors.find(descriptor->getType()) != m_descriptors.end(), "Duplicated descriptor class");
m_descriptors[descriptor->getType()] = descriptor;
}
return true;
}
void ObjectsPollOptionDescriptor::computeStatistics(shared_ptr<IPortalDatabase> db, shared_ptr<ObjectsIObject> object)
{
DescriptorBase::computeStatistics(db, object);
shared_ptr<ObjectsPollOption> poll_option = objects_poll_option_cast(object);
OS_EXCEPT_IF(poll_option == nullptr, "Invalid poll option");
shared_ptr<DataPollOptionStats> stats(OS_NEW DataPollOptionStats());
stats->reference = poll_option->getEntityID().toUTF16();
String sql = String::format(_S("select count(*) from os_snapshot_users, os_polls_votes where \
os_snapshot_users.id = os_polls_votes.author \
and os_snapshot_users.visible=1 \
and os_polls_votes.parent = '%S' \
and os_polls_votes.reference = '%S' \
and os_polls_votes.score is not null").c_str(),
poll_option->getParent().toUTF16().c_str(),
poll_option->getEntityID().toUTF16().c_str());
DataTable table;
if(db->execute(sql, table))
stats->votes = static_cast<uint32>(*table[0][0]);
db->updateRecord(stats);
}
shared_ptr<ObjectsIDescriptor> ObjectsSystem::getDescriptor(PortalObjectType type) const
{
if(type == portalObjectTypeUnknown)
return nullptr;
ObjectsDescriptors::const_iterator i = m_descriptors.find(type);
OS_EXCEPT_IF(i == m_descriptors.end(), "Invalid descriptor");
return i->second;
}
void IDbResult::bind(DataTableRow &row)
{
uint32 count = columns();
for(uint32 i = 0; i < count; i++)
{
DataItem *value = row[i];
OS_EXCEPT_IF(value == nullptr, "Invalid row value !");
value->clear();
get(i, *value);
}
}
bool IExtensionsExtension::updateExtension(shared_ptr<Portal> portal, shared_ptr<IPortalDatabase> db, const Version &version)
{
OS_ASSERT(portal != nullptr);
//shared_ptr<IPortalDatabase> db = portal->getDatabase();
OS_EXCEPT_IF(db == nullptr, "Invalid database");
DbSqlValues values;
values.set(DBTABLES::EXTENSIONS::VERSION, static_cast<String>(version.toString()));
String sql = db->getConnection()->prepare_update(DBTABLES::EXTENSIONS_TABLE, values, DBTABLES::EXTENSIONS::ID, Convert::toSQL(getID().toUTF16()));
return db->getConnection()->executeStatement(sql, values);
}
bool IHttpDirectory::addDirectory(shared_ptr<IHttpDirectory> directory)
{
OS_LOCK(m_cs);
if(directory == nullptr)
return false;
OS_EXCEPT_IF(hasDirectory(directory->getName()), "Duplicated directory");
directory->m_parent = get_this_ptr();
m_directories.push_back(directory->getName(), directory);
return true;
}
bool IExtensionsExtension::isExtensionRegistered(shared_ptr<Portal> portal, shared_ptr<IPortalDatabase> db, Version &version) const
{
OS_ASSERT(portal != nullptr);
OS_EXCEPT_IF(db == nullptr, "Invalid database");
shared_ptr<DbSqlSelect> select(OS_NEW DbSqlSelect(DBTABLES::EXTENSIONS_TABLE));
select->fields.add(DbSqlField(DBTABLES::EXTENSIONS::VERSION));
select->where.add(DBTABLES::EXTENSIONS::ID, Convert::toSQL(getID().toUTF16()));
select->limit.setCount(1);
DataTable result;
if(db->execute(select, result) == false)
return false;
if(result.rows() == 0)
return false;
version.fromString(static_cast<String>(*result[0][0]).to_ascii());
return true;
}
void Connection::connect(const String &filename)
{
close();
// _tsqlite3_open crea un nuovo database se il file non esiste: dovrebbe essere il driver a monte che non crea la connessione se il file non esiste
OS_ASSERT(FileSystem::instance()->fileExists(filename));
int32 res = _tsqlite3_open(filename.c_str(), &m_connection);
OS_EXCEPT_IF(res != SQLITE_OK, sqlite_last_error(m_connection, res));
m_filename = filename;
uint32 cacheSize = OS_NAMESPACE_NAME::Options::instance()->getOption<uint32>(OS_SQLITE_OPTION_CACHE_SIZE);
String synchronous = static_cast<String>(OS_NAMESPACE_NAME::Options::instance()->getOption<String>(OS_SQLITE_OPTION_SYNCHRONOUS)).to_upper();
if((synchronous != _S("FULL")) && (synchronous != _S("NORMAL")) && (synchronous != _S("OFF")))
synchronous = _S("FULL");
uint32 tempStore = OS_NAMESPACE_NAME::Options::instance()->getOption<uint32>(OS_SQLITE_OPTION_TEMP_STORE);
if(tempStore > 2)
tempStore = 0;
doExecute(m_connection, _S("PRAGMA legacy_file_format = OFF;"));
doExecute(m_connection, String::format(_S("PRAGMA cache_size = %d;").c_str(), cacheSize)); // Default di sqlite:2000
doExecute(m_connection, String::format(_S("PRAGMA synchronous = %S;").c_str(), synchronous.c_str())); // FULL/NORMAL/OFF, Default di sqlite: FULL
doExecute(m_connection, String::format(_S("PRAGMA temp_store = %d").c_str(), tempStore)); // 0(Default)/1(File)/2(Memory), Default di sqlite: 0
}
void Connection::_check(sqlite3 *connection)
{
OS_EXCEPT_IF(m_connection == nullptr, "Connection not opened");
}
String Connection::preAnalyze(const String &sql)
{
static boost::recursive_mutex cs;
OS_LOCK(cs);
// Per vedere le sql nel charts:
// RealtimeStatsManager::signal(sql, 1, RealtimeStatsCounter::ctAbsolute, _S("status"));
// Da notare che vengono archiviate nella os_monitor solo le query analizzate dalla "explain".
// Una "insert", non usando indici, non viene catalogata, a meno che non abbia sotto-query.
if(sql.find(_S("explain query plan ")) != String::npos)
return _S("");
if(sql.find(_S("os_monitor")) != String::npos)
return _S("");
static shared_ptr<Connection> connectionAnalyze = nullptr;
if(connectionAnalyze == nullptr)
{
shared_ptr<Driver> driver = boost::dynamic_pointer_cast<Driver>(getDriver());
String path = driver->getDatabasePath(_S("monitor.db"));
if(FileSystem::instance()->exists(path) == false)
{
// Crea il database se non esiste
File file;
String msg = _S("Cannot create file '") + path + _S("'");
OS_EXCEPT_IF(file.open(path, File::ofWrite) == false, msg.to_ascii());
}
connectionAnalyze.reset(OS_NEW Connection(path, getDriver()->createOptions(), getDriver()));
int32 res = _tsqlite3_open(path.c_str(), &connectionAnalyze->m_connection);
OS_EXCEPT_IF(res != SQLITE_OK, sqlite_last_error(connectionAnalyze->m_connection, res));
// Creazione tabella
String sqlCreate = _S("CREATE TABLE IF NOT EXISTS os_monitor (filename text,sql text,thread integer,conn integer,trans integer, qorder integer,qfrom integer,detail text,indexUsed text)");
doExecute(connectionAnalyze->m_connection, sqlCreate);
}
// I valori dei campi li setto a ?, per poter fare delle distinct sui risultati
String keySql = sql;
keySql.trim();
keySql = regex_replace(keySql, RegexManager::instance()->getRegex(_S("'(.*?)'")), _S("<s>")); // Valori dei campi
keySql = regex_replace(keySql, RegexManager::instance()->getRegex(_S("[-+]?[0-9]*\\.?[0-9]+")), _S("<n>")); // Numeri
keySql = keySql.replace_all(_S("\n"),_S(""));
keySql = keySql.replace_all(_S("\r"),_S(""));
keySql = keySql.replace_all(_S("\t"),_S(""));
keySql = keySql.replace_all(_S("'"),_S("")); // Futile, per evitare errori nella insert nella os_monitor
for(;;) // Comprimo gli spazi
{
String x = keySql;
keySql = keySql.replace_all(_S(" "),_S(" "));
if(x == keySql)
break;
}
uint32 conn = uint32(reinterpret_cast<uint64>(this));
boost::any threadID = PlatformManager::instance()->getCurrentThreadID();
// Tenta un cast a uint32
uint32 *thread = boost::any_cast<uint32>(&threadID);
int32 trans = m_transactionId;
DataTable result;
doQuery(m_connection, _S("explain query plan ") + sql,result);
for(uint32 r=0;r<result.rows();r++)
{
int32 order = *result.get(r,_S("order"));
int32 from = *result.get(r,_S("from"));
String detail = *result.get(r,_S("detail"));
String indexUsed;
String::size_type posWithIndex = detail.find(_S("WITH INDEX"));
if(posWithIndex != String::npos)
{
indexUsed = detail.substr(posWithIndex+10);
indexUsed = indexUsed.replace_all(_S("ORDER BY"),String::EMPTY);
indexUsed.trim();
}
String sqlInsert = String::format(_S("insert into os_monitor values ('%S','%S',%u,%u,%u,%d,%d,'%S','%S')").c_str(), m_filename.c_str(), keySql.c_str(), conn, thread != nullptr ? *thread : 0, trans, order, from, detail.c_str(), indexUsed.c_str());
doExecute(connectionAnalyze->m_connection, sqlInsert);
}
String trace = String::format(_S("Sqlite monitor: sql='%S',conn=%u,thread=%u,trans=%u\n").c_str(), sql.c_str(), conn, thread != nullptr ? *thread : 0, trans);
//OS_TRACE(trace);
//RealtimeStatsManager::signal(_S("Sqlite ") + keySql.mid(0,6), 1, RealtimeStatsCounter::ctRelative, _S("items"));
return keySql;
}
void Statement::run()
{
sqlite_int res = safe_sqlite_step(m_statement);
OS_EXCEPT_IF(res != SQLITE_OK && res != SQLITE_ROW && res != SQLITE_DONE, sqlite_last_error(m_connection, res));
}
shared_ptr<SearchResult> SearchResultsDatabase::getResult(shared_ptr<IPortalDatabase> database, uint32 index, bool asGroup)
{
OS_EXCEPT_IF(index >= getResults(), "Invalid result index");
return m_objects[index];
}
