aboutsummaryrefslogtreecommitdiff
path: root/src/odbc/odbc_queries.erl (unfollow)
Commit message (Collapse)AuthorFilesLines
2013-06-13Switch to rebar build toolEvgeniy Khramtsov1-937/+0
Use dynamic Rebar configuration Make iconv dependency optional Disable transient_supervisors compile option Add hipe compilation support Only compile ibrowse and lhttpc when needed Make it possible to generate an OTP application release Add --enable-debug compile option Add --enable-all compiler option Add --enable-tools configure option Add --with-erlang configure option. Add --enable-erlang-version-check configure option. Add lager support Improve the test suite
2013-03-14Accumulated patch to binarize and indent codeBadlop1-595/+626
2013-01-24Update copyright datesAlexey Shchepin1-1/+1
2012-04-12ODBC support for mod_blockingEvgeniy Khramtsov1-0/+12
2012-04-06Get rid of duplicated codeEvgeniy Khramtsov1-0/+1
2012-02-23Update copyright datesAlexey Shchepin1-1/+1
2012-01-31Replace a single quote with double quotes inEvgeniy Khramtsov1-1/+1
an ODBC escape (thanks to Vladislav Chugunov)
2011-08-16Fix ODBC account counting (thanks to Artem Sh)(EJAB-1491)Badlop1-4/+0
2011-04-14Try to improve support for roster_version in MSSQL (EJAB-1437)Badlop1-4/+12
2011-02-14update copyright up to 2011Christophe Romain1-1/+1
2010-11-01Do not run set_last request inside a transactionEvgeniy Khramtsov1-8/+20
2010-03-05MSSQL support was broken (EJAB-1201)Denis Kurochkin1-2/+70
2010-01-12Update year of ProcessOne copyright from 2009 to 2010 (EJAB-1159)Badlop1-1/+1
SVN Revision: 2891
2009-08-06Support for roster versioning (EJAB-964)Pablo Polvorin1-1/+16
Introduces two options for mod_roster and mod_roster_odbc: - {versioning, true | false} Enable or disable roster versioning on ejabberd. - {store_current_id, true | false} If true, the current roster version is stored on DB (internal or odbc). Otherwise it is calculated on the fly each time. Performance: Setting store_current_id to true should help in reducing the load for both ejabberd and the DB. Details: If store_current_id is false, the roster version is a hash of the entire roster. If store_current_id is true, the roster version is a hash, but of the current time (this has to do with transactional semantics; we need to perform both the roster update and the version update on the same transaction, but we don't have the entire roster when we are changing a single item on DB. Loading it there requires significant changes to be introduced, so I opted for this simpler approach). In either case, there is no difference for the clients, the roster version ID is opaque. IMPORTANT: mod_shared_roster is not compatible with the option 'store_current_id'. Shared roster and roster versioning can be both enabled, but store_current_id MUST be set to false. SVN Revision: 2428
2009-05-06Replace TYPE/1 with is_TYPE/1 (EJAB-922)Badlop1-1/+1
SVN Revision: 2057
2009-01-12* doc/guide.tex: Update copyright date 2008 to 2009 (EJAB-842)Badlop1-1/+1
* doc/guide.html: Likewise * src/*/*.erl: Likewise * src/*/*.erl: Remove unneeded blankspaces in license text SVN Revision: 1804
2008-12-29* src/odbc/odbc_queries.erl: replaced string:join/2 function.Evgeniy Khramtsov1-11/+16
Removed ugly "catch" statement from update_t/4. WARNING: this change requires last version of mysql driver. You can update it from ejabberd-modules repository. SVN Revision: 1762
2008-12-26* src/odbc/ejabberd_odbc.erl: get rid of SERIALIZABLE isolation level on ↵Evgeniy Khramtsov1-58/+176
MySQL connections. * src/odbc/odbc_queries.erl: replaces all delete->insert chains with update->insert. * src/mod_privacy_odbc.erl: moved sql queries to odbc_queries.erl. * src/mod_roster_odbc.erl: changed interface for odbc_queries.erl. SVN Revision: 1755
2008-12-23* src/odbc/odbc_queries.erl: Fix removal of private_storage of anBadlop1-1/+1
account when the account is removed * src/mod_privacy.erl: Remove privacy lists of an account when the account is removed (EJAB-720) * src/mod_privacy_odbc.erl: Likewise SVN Revision: 1742
2008-10-03* src/odbc/odbc_queries.erl: Fix empty query that fail on MySQL.Jérôme Sautret1-2/+2
SVN Revision: 1597
2008-10-03* src/mod_vcard_odbc: added vCard support for MS SQL Server 2005.Jérôme Sautret1-0/+57
* src/odbc/odbc_queries.erl: likewise. * src/odbc/mssql2005.sql: likewise. SVN Revision: 1595
2008-07-31* doc/guide.tex: Update Process-one name to ProcessOne (EJAB-708)Badlop1-1/+1
* doc/guide.html: Likewise * doc/api/overview.edoc: Likewise * src/*/*.erl: Likewise * src/*/*.hrl: Likewise * src/*/*.c: Likewise * src/odbc/*.sql: Likewise SVN Revision: 1499
2008-07-22* src/odbc/odbc_queries.erl: Fixed a typoAlexey Shchepin1-1/+1
SVN Revision: 1467
2008-05-31* src/odbc/odbc_queries.erl (del_user_return_password): ReturnBadlop1-4/+5
password (thanks to Oleg Palij) SVN Revision: 1343
2008-02-12* odbc_queries: fix list_users queries with limit/offset.Jérôme Sautret1-2/+2
SVN Revision: 1188
2008-02-12* odbc_queries: fix list_users query with prefix.Jérôme Sautret1-11/+11
SVN Revision: 1187
2008-01-15* doc/guide.tex: Updated copyright dates to 2008Badlop1-1/+1
* src/*: Likewise SVN Revision: 1153
2007-12-24* Applied copyright patch 3.Mickaël Rémond1-4/+27
SVN Revision: 1113
2007-12-20User count performance improvementsChristophe Romain1-7/+16
SVN Revision: 1086
2007-12-17mssql specific issue bugfixChristophe Romain1-4/+3
SVN Revision: 1074
2007-12-11first patch to mssql quety, still one patch to be doneChristophe Romain1-1/+9
SVN Revision: 1066
2007-12-01* src/odbc_queries.erl: Added a default define value so that weMickaël Rémond1-3/+4
can recompile the file manually with a simple erlc command (with the default generic value). SVN Revision: 1007
2007-12-01* src/odbc/odbc_queries.erl: Reverted the previous patch becauseAlexey Shchepin1-3/+3
it produces "redefining macro 'generic'" compilation error SVN Revision: 1005
2007-11-30* src/odbc_queries.erl: Added a default define value so that we canMickaël Rémond1-0/+4
recompile the file manually with a simple erlc command. SVN Revision: 1003
2007-11-03* src/ejabberd_auth.erl: Better count management and batch users retrieval ↵Mickaël Rémond1-0/+41
for relational database (Thanks to Massimiliano Mirra). * src/ejabberd_auth_odbc.erl: Likewise. * src/odbc/odbc_queries.erl: Likewise. SVN Revision: 968
2007-08-28* src/mod_offline_odbc.erl: Implements quota for offline messagesMickaël Rémond1-2/+14
in relational database (EJAB-314) * src/odbc/odbc_queries.erl: Likewise SVN Revision: 893
2007-06-18* src/odbc/odbc_queries.erl: Added missing users_number/1 for MSSQL (EJAB-239).Mickaël Rémond1-0/+5
SVN Revision: 785
2007-05-12* src/ejabberd_auth.erl: Added get_vh_registered_users_number/1Alexey Shchepin1-0/+15
function * src/ejabberd_auth_odbc.erl: Likewise * src/odbc/odbc_queries.erl: Added users_number/1 function * src/ejabberd.cfg.example: Added an example for pgsql_users_number_estimate option SVN Revision: 766
2006-11-202006-11-20 Mickael Remond <mickael.remond@process-one.net>Mickaël Rémond1-9/+31
* src/ejd2odbc.erl: Copy mod_private data from Mnesia to relational database. * src/odbc/odbc_queries.erl: Refactoring. * src/odbc/mssql.sql: Likewise. * doc/guide.tex: Update to mention mod_private_odbc. * src/odbc/mysql.sql: Started integration of mod_privacy_odbc for MySQL and MSSQL. * src/odbc/mssql.sql: Likewise. SVN Revision: 678
2006-11-05* src/mod_private_odbc.erl: Support for MySQL and MSSQL.Mickaël Rémond1-0/+40
* src/odbc/odbc_queries.erl: Likewise. * src/odbc/mysql.sql: Likewise. * src/odbc/mssql.sql: Likewise. SVN Revision: 674
2006-09-03* src/odbc/odbc_queries.erl: Support for Microsoft SQL Server asMickaël Rémond1-0/+434
a database backend (via ODBC). * src/odbc/ejabberd_odbc.erl: Likewise. * src/odbc/mssql.sql: Likewise. * src/odbc/Makefile.in: Likewise. * src/ejabberd_auth_odbc.erl: Likewise. * src/mod_offline_odbc.erl: Likewise. * src/mod_roster_odbc.erl: Likewise. * src/mod_last_odbc.erl: Likewise. * src/configure.ac: Likewise * doc/guide.tex: Likewise. * doc/introduction.tex: Likewise. * src/odbc/pg.sql: Minor fix. SVN Revision: 598