From d7edb4799b63b9bbde25a0d04603476aaf8acd50 Mon Sep 17 00:00:00 2001 From: Matthias Schiffer Date: Sun, 9 Aug 2009 18:52:17 +0200 Subject: Renamed UserBackendMysql to UserDBBackendMysql and UserBackendHome to UserConfigBackendHome --- .../UserDBBackendMysql/UserDBBackendMysql.h | 159 +++++++++++++++++++++ 1 file changed, 159 insertions(+) create mode 100644 src/modules/UserDBBackendMysql/UserDBBackendMysql.h (limited to 'src/modules/UserDBBackendMysql/UserDBBackendMysql.h') diff --git a/src/modules/UserDBBackendMysql/UserDBBackendMysql.h b/src/modules/UserDBBackendMysql/UserDBBackendMysql.h new file mode 100644 index 0000000..959e133 --- /dev/null +++ b/src/modules/UserDBBackendMysql/UserDBBackendMysql.h @@ -0,0 +1,159 @@ +/* + * UserDBBackendMysql.h + * + * Copyright (C) 2008 Matthias Schiffer + * + * This program is free software: you can redistribute it and/or modify it + * under the terms of the GNU Lesser General Public License as published by the + * Free Software Foundation, either version 3 of the License, or + * (at your option) any later version. + * + * This program is distributed in the hope that it will be useful, but + * WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. + * See the GNU Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public License along + * with this program. If not, see . + */ + +#ifndef MAD_MODULES_USERDBBACKENDMYSQL_USERDBBACKENDMYSQL_H_ +#define MAD_MODULES_USERDBBACKENDMYSQL_USERDBBACKENDMYSQL_H_ + +#include +#include + +#include +#include + +#include + +#include +#include + +namespace Mad { +namespace Modules { +namespace UserDBBackendMysql { + +class UserDBBackendMysql : public Common::UserDBBackend, private Core::Configurable, private boost::noncopyable { + private: + typedef std::map > ArgumentMap; + + class Result; + Result query(const std::string &query, const ArgumentMap &args = ArgumentMap()) throw(Core::Exception); + + class Result { + private: + friend Result UserDBBackendMysql::query(const std::string &query, const ArgumentMap &args) throw(Core::Exception); + + boost::shared_ptr result; + + unsigned int mysqlErrno; + const char *error; + + Result(MYSQL *mysql) { + result = boost::shared_ptr(mysql_store_result(mysql), mysql_free_result); + + mysqlErrno = mysql_errno(mysql); + error = mysql_error(mysql); + } + + public: + operator bool() const { + return result; + } + + unsigned int getErrno() const { + return mysqlErrno; + } + + const char* getError() const { + return error; + } + + unsigned int getFieldNumber() const { + return mysql_num_fields(result.get()); + } + + my_ulonglong getRowNumber() const { + return mysql_num_rows(result.get()); + } + + MYSQL_ROW getNextRow() { + return mysql_fetch_row(result.get()); + } + }; + + static const std::string name; + + Common::Application *application; + + std::string host, username, passwd, db, unixSocket; + uint16_t port; + + std::string queryListUsers, queryListGroups; + std::string queryListUserGroups, queryListGroupUsers; + std::string queryUserById, queryUserByName; + std::string queryGroupById, queryGroupByName; + std::string queryUserGroupTable; + std::string queryAddUser, queryUpdateUser, queryDeleteUser; + std::string queryAddGroup, queryUpdateGroup, queryDeleteGroup; + std::string queryAddUserToGroup, queryDeleteUserFromGroup; + + MYSQL *mysql; + + boost::posix_time::ptime lastUpdate; + + boost::mutex mutex; + + protected: + virtual bool handleConfigEntry(const Core::ConfigEntry &entry, bool handled); + virtual void configFinished(); + + virtual boost::shared_ptr > getUserList(boost::posix_time::ptime *timestamp) throw(Core::Exception); + virtual boost::shared_ptr getUserInfo(unsigned long uid, boost::posix_time::ptime *timestamp) throw(Core::Exception); + virtual boost::shared_ptr getUserInfoByName(const std::string &name, boost::posix_time::ptime *timestamp) throw(Core::Exception); + virtual boost::shared_ptr > getUserGroupList(unsigned long uid, boost::posix_time::ptime *timestamp) throw(Core::Exception); + + virtual boost::shared_ptr > getGroupList(boost::posix_time::ptime *timestamp) throw(Core::Exception); + virtual boost::shared_ptr getGroupInfo(unsigned long gid, boost::posix_time::ptime *timestamp) throw(Core::Exception); + virtual boost::shared_ptr getGroupInfoByName(const std::string &name, boost::posix_time::ptime *timestamp) throw(Core::Exception); + virtual boost::shared_ptr > getGroupUserList(unsigned long gid, boost::posix_time::ptime *timestamp) throw(Core::Exception); + + virtual boost::shared_ptr > getFullUserGroupList(boost::posix_time::ptime *timestamp) throw(Core::Exception); + + virtual void addUser(const Common::UserInfo &userInfo) throw(Core::Exception); + virtual void updateUser(unsigned long uid, const Common::UserInfo &userInfo) throw(Core::Exception); + virtual void deleteUser(unsigned long uid) throw(Core::Exception); + + virtual void addGroup(const Common::GroupInfo &groupInfo) throw(Core::Exception); + virtual void updateGroup(unsigned long gid, const Common::GroupInfo &groupInfo) throw(Core::Exception); + virtual void deleteGroup(unsigned long gid) throw(Core::Exception); + + virtual void addUserToGroup(unsigned long uid, unsigned long gid) throw(Core::Exception); + virtual void deleteUserFromGroup(unsigned long uid, unsigned long gid) throw(Core::Exception); + + public: + UserDBBackendMysql(Common::Application *application0) : application(application0), port(0), mysql(0), lastUpdate(boost::posix_time::microsec_clock::universal_time()) { + application->getConfigManager()->registerConfigurable(this); + } + + virtual ~UserDBBackendMysql() { + application->getConfigManager()->unregisterConfigurable(this); + + if(mysql) { + mysql_close(mysql); + mysql = 0; + } + } + + virtual const std::string& getName() { + return name; + } +}; + +} +} +} + +#endif /* MAD_MODULES_USERDBBACKENDMYSQL_USERBACKENDMYSQL_H_ */ -- cgit v1.2.3