Module: sip-router
Branch: janakj/bdb
Commit: 3904bb0de19f991292c69e61ebfe387d2d10809f
URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=3904bb0…
Author: Henning Westerholt <henning.westerholt(a)1und1.de>
Committer: Henning Westerholt <henning.westerholt(a)1und1.de>
Date: Mon Jan 7 14:26:27 2008 +0000
further cleanups in core database API
- move use_table and close function for SQL DBs to core
- move query, raw_query, insert, update, delete functions for SQL DBs to core
- all this functions were almost identical implemented in the three DB,
this functions uses now a function pointer based interface to do the work
- the use_table functions from dbtext and db_berkeley uses also now the core API
- move result management function from db_col to db_res to the other result
management functions, they are not useful alone
- change postgres module to match more the structure of mysql and unixodbc,
remove the 'PARANOID' #define, the other modules don't have this and prefix
all functions with db_postgres, make this more consistent to mysql module
- prefix all functions in unixodbc module with db_unixodbc, make this consistent
to the other modules, cleanup the namespace
- prefix val2str function in mysql with db_mysql too
- move the SQL_BUF_LENGTH to core API, all modules need this
- remove the static SQL char buffer from postgres and unixodbc, uses the one
provided from the core API
- move documentation from db/doc to API files in doxygen format
- improve and extend documentation for the whole API
- make database API const correct, to guard against implementation errors and
allow better compiler optimizations
- change interface free_connection function in SQL DBs to connection structure
to allow the usage of core API do_close
- fix indention for postgres driver and make logging messages consistent
- remove now unneeded system header includes for SQL DBs
- remove transaction related code from postgres driver, this is not used at all
and according to Klaus also brings no performance benefit if used.
- probably some other smaller cleanups
Tested with the testcases, so basic functionality should work.. Please test! :-)
git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3506 689a6050-402a-0410-94f2-e92a70836424
---
modules/db_berkeley/db_berkeley.c | 6 +-----
1 files changed, 1 insertions(+), 5 deletions(-)
diff --git a/modules/db_berkeley/db_berkeley.c b/modules/db_berkeley/db_berkeley.c
index b4ccc7c..8049baf 100644
--- a/modules/db_berkeley/db_berkeley.c
+++ b/modules/db_berkeley/db_berkeley.c
@@ -134,11 +134,7 @@ static void destroy(void)
int bdb_use_table(db_con_t* _h, const char* _t)
{
- if ((!_h) || (!_t))
- return -1;
-
- CON_TABLE(_h) = _t;
- return 0;
+ return db_use_table(_h, _t);
}
/*
Module: sip-router
Branch: janakj/bdb
Commit: bbd5ceca0c61b5346e38e7c8a0efbcb4ea9a0a9d
URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=bbd5cec…
Author: Henning Westerholt <henning.westerholt(a)1und1.de>
Committer: Henning Westerholt <henning.westerholt(a)1und1.de>
Date: Wed Feb 6 15:46:09 2008 +0000
further changes after the db name change
- update INSTALL file
- fix Makefile skip modules variable
- fix module Makefile, lib name
- change db_bind_mod to add the db prefix in the function
- change db url defines in db_berkeley and db_text
- change database modules names in module struct
- fix debian packaging
- fix tests
git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3642 689a6050-402a-0410-94f2-e92a70836424
---
modules/db_berkeley/README | 4 ++--
modules/db_berkeley/db_berkeley.c | 2 +-
modules/db_berkeley/doc/db_berkeley_user.sgml | 4 ++--
3 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/modules/db_berkeley/README b/modules/db_berkeley/README
index 1f7dda5..4cc84b4 100644
--- a/modules/db_berkeley/README
+++ b/modules/db_berkeley/README
@@ -228,8 +228,8 @@ by default none is loaded
Modify the OpenSER configuration file to use db_berkeley
module. The database URL for modules must be the path to the
directory where the Berkeley DB table-files are located,
- prefixed by "db_berkeley://", e.g.,
- "db_berkeley:///usr/local/etc/openser/db_berkeley".
+ prefixed by "berkeley://", e.g.,
+ "berkeley:///usr/local/etc/openser/db_berkeley".
A couple other IMPORTANT things to consider are the 'db_mode'
and the 'use_domain' modparams. The description of these
diff --git a/modules/db_berkeley/db_berkeley.c b/modules/db_berkeley/db_berkeley.c
index 74fea05..7c69751 100644
--- a/modules/db_berkeley/db_berkeley.c
+++ b/modules/db_berkeley/db_berkeley.c
@@ -47,7 +47,7 @@
#define CFG_DIR "/tmp"
#endif
-#define BDB_ID "db_berkeley://"
+#define BDB_ID "berkeley://"
#define BDB_ID_LEN (sizeof(BDB_ID)-1)
#define BDB_PATH_LEN 256
diff --git a/modules/db_berkeley/doc/db_berkeley_user.sgml b/modules/db_berkeley/doc/db_berkeley_user.sgml
index c08222f..b2bd6e3 100644
--- a/modules/db_berkeley/doc/db_berkeley_user.sgml
+++ b/modules/db_berkeley/doc/db_berkeley_user.sgml
@@ -253,8 +253,8 @@ modparam("db_berkeley", "journal_roll_interval", 3600)
<para>
Modify the OpenSER configuration file to use db_berkeley module.
The database URL for modules must be the path to the directory where
- the Berkeley DB table-files are located, prefixed by "db_berkeley://",
- e.g., "db_berkeley:///usr/local/etc/openser/db_berkeley".
+ the Berkeley DB table-files are located, prefixed by "berkeley://",
+ e.g., "berkeley:///usr/local/etc/openser/db_berkeley".
</para>
<para>
Module: sip-router
Branch: janakj/bdb
Commit: 44dab431e3f9b04d33d5d0ea88f90840ad4ef464
URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=44dab43…
Author: Henning Westerholt <henning.westerholt(a)1und1.de>
Committer: Henning Westerholt <henning.westerholt(a)1und1.de>
Date: Fri Feb 8 14:32:23 2008 +0000
- port db_text and db_berkeley to the new core DB API
- remove free_* methods that are not needed anymore
- adjust structure to the other SQL based modules
- basic queries works, but otherwise not that much tested
git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3668 689a6050-402a-0410-94f2-e92a70836424
---
modules/db_berkeley/bdb_res.c | 426 +++++++++----------------------------
modules/db_berkeley/bdb_res.h | 5 -
modules/db_berkeley/bdb_val.c | 2 +
modules/db_berkeley/db_berkeley.c | 10 +-
4 files changed, 107 insertions(+), 336 deletions(-)
Diff: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commitdiff;h=44d…
Module: sip-router
Branch: janakj/bdb
Commit: 885093d82e9631840d684ee026bf94ba207c1aa0
URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=885093d…
Author: Henning Westerholt <henning.westerholt(a)1und1.de>
Committer: Henning Westerholt <henning.westerholt(a)1und1.de>
Date: Tue Mar 4 13:15:47 2008 +0000
- change module docs FAQ link to a common one in the doc dir
- remove module specific FAQ content from the file in doc, this way no FAQ
content will be created
- credits for the patch/ the change scripts goes to Edson Gellert Schubert,
4lists at gmail dot com
- update all READMEs, for most module docs the FAQ and devel information were
now removed
git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3839 689a6050-402a-0410-94f2-e92a70836424
---
modules/db_berkeley/README | 42 -------------------------
modules/db_berkeley/doc/db_berkeley.sgml | 4 +--
modules/db_berkeley/doc/db_berkeley_user.sgml | 3 +-
3 files changed, 2 insertions(+), 47 deletions(-)
diff --git a/modules/db_berkeley/README b/modules/db_berkeley/README
index 4cc84b4..441723c 100644
--- a/modules/db_berkeley/README
+++ b/modules/db_berkeley/README
@@ -41,9 +41,6 @@ Will Quan
1.13. DB Recovery : bdb_recover
1.14. Known Limitations
- 2. Developer's Guide
- 3. Frequently Asked Questions
-
List of Examples
1-1. Set auto_reload parameter
1-2. Set log_enable parameter
@@ -498,42 +495,3 @@ possible
sequence) mechanism. Consequently, this version does not
support surragate keys in dbschema. These are the id columns in
the tables.
- __________________________________________________________
-
-Chapter 2. Developer's Guide
-
- The module does not provide any API to use in other OpenSER
- modules.
- __________________________________________________________
-
-Chapter 3. Frequently Asked Questions
-
- 3.1. Where can I find more about OpenSER?
- 3.2. Where can I post a question about this module?
- 3.3. How can I report a bug?
-
- 3.1. Where can I find more about OpenSER?
-
- Take a look at http://openser.org/.
-
- 3.2. Where can I post a question about this module?
-
- First at all check if your question was already answered on one
- of our mailing lists:
-
- * User Mailing List -
- http://openser.org/cgi-bin/mailman/listinfo/users
- * Developer Mailing List -
- http://openser.org/cgi-bin/mailman/listinfo/devel
-
- E-mails regarding any stable OpenSER release should be sent to
- <users(a)openser.org> and e-mails regarding development versions
- should be sent to <devel(a)openser.org>.
-
- If you want to keep the mail private, send it to
- <team(a)openser.org>.
-
- 3.3. How can I report a bug?
-
- Please follow the guidelines provided at:
- http://sourceforge.net/tracker/?group_id=139143.
diff --git a/modules/db_berkeley/doc/db_berkeley.sgml b/modules/db_berkeley/doc/db_berkeley.sgml
index 306f0b1..361a322 100644
--- a/modules/db_berkeley/doc/db_berkeley.sgml
+++ b/modules/db_berkeley/doc/db_berkeley.sgml
@@ -2,8 +2,7 @@
<!ENTITY user SYSTEM "db_berkeley_user.sgml">
-<!ENTITY devel SYSTEM "db_berkeley_devel.sgml">
-<!ENTITY faq SYSTEM "db_berkeley_faq.sgml">
+<!ENTITY faq SYSTEM "../../../doc/module_faq.sgml">
<!-- Include general documentation entities -->
<!ENTITY % docentities SYSTEM "../../../doc/entities.sgml">
@@ -49,7 +48,6 @@
<toc></toc>
&user;
- &devel;
&faq;
</book>
diff --git a/modules/db_berkeley/doc/db_berkeley_user.sgml b/modules/db_berkeley/doc/db_berkeley_user.sgml
index affdf40..14e6c54 100644
--- a/modules/db_berkeley/doc/db_berkeley_user.sgml
+++ b/modules/db_berkeley/doc/db_berkeley_user.sgml
@@ -1,8 +1,7 @@
<!-- Module User's Guide -->
<chapter>
- <chapterinfo>
- </chapterinfo>
+
<title>User's Guide</title>
<section>
Module: sip-router
Branch: janakj/bdb
Commit: 1ba4e6b90f5c63aaea584e85aacbbdfd2abb4bef
URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1ba4e6b…
Author: Henning Westerholt <henning.westerholt(a)1und1.de>
Committer: Henning Westerholt <henning.westerholt(a)1und1.de>
Date: Wed Feb 27 13:53:33 2008 +0000
- first round of cleanups for documentation
- remove all FAQ and DEVEL files considered empty in content (no content at all
or just the default lines)
- remove of the <RevHistory>/</RevHistory> tag (and of course anything between
them)
- remove the comments at the end of the file that begins with
"<!-- Keep this element at the end of the file"
- credits for the patch/ the change scripts goes to Edson Gellert Schubert,
4lists at gmail dot com
git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3769 689a6050-402a-0410-94f2-e92a70836424
---
modules/db_berkeley/doc/db_berkeley_devel.sgml | 22 --------
modules/db_berkeley/doc/db_berkeley_faq.sgml | 70 ------------------------
modules/db_berkeley/doc/db_berkeley_user.sgml | 11 ----
3 files changed, 0 insertions(+), 103 deletions(-)
diff --git a/modules/db_berkeley/doc/db_berkeley_devel.sgml b/modules/db_berkeley/doc/db_berkeley_devel.sgml
deleted file mode 100644
index 1c666a4..0000000
--- a/modules/db_berkeley/doc/db_berkeley_devel.sgml
+++ /dev/null
@@ -1,22 +0,0 @@
-<!-- Module Developer's Guide -->
-
-<chapter>
- <chapterinfo>
- <revhistory>
- <revision>
- <revnumber>$Revision: 846 $</revnumber>
- <date>$Date: 2006-05-22 09:15:40 -0500 (Mon, 22 May 2006) $</date>
- </revision>
- </revhistory>
- </chapterinfo>
- <title>Developer's Guide</title>
- <para>
- The module does not provide any <acronym>API</acronym> to use in other &ser; modules.
- </para>
-</chapter>
-
-<!-- Keep this element at the end of the file
-Local Variables:
-sgml-parent-document: ("db_berkeley.sgml" "book" "chapter")
-End:
--->
diff --git a/modules/db_berkeley/doc/db_berkeley_faq.sgml b/modules/db_berkeley/doc/db_berkeley_faq.sgml
deleted file mode 100644
index 4fc364e..0000000
--- a/modules/db_berkeley/doc/db_berkeley_faq.sgml
+++ /dev/null
@@ -1,70 +0,0 @@
-<!-- Module FAQ -->
-
-<chapter>
- <chapterinfo>
- <revhistory>
- <revision>
- <revnumber>$Revision: 846 $</revnumber>
- <date>$Date: 2006-05-22 09:15:40 -0500 (Mon, 22 May 2006) $</date>
- </revision>
- </revhistory>
- </chapterinfo>
- <title>Frequently Asked Questions</title>
- <qandaset defaultlabel="number">
- <qandaentry>
- <question>
- <para>Where can I find more about OpenSER?</para>
- </question>
- <answer>
- <para>
- Take a look at &serhomelink;.
- </para>
- </answer>
- </qandaentry>
- <qandaentry>
- <question>
- <para>Where can I post a question about this module?</para>
- </question>
- <answer>
- <para>
- First at all check if your question was already answered on one of
- our mailing lists:
- </para>
- <itemizedlist>
- <listitem>
- <para>User Mailing List - &seruserslink;</para>
- </listitem>
- <listitem>
- <para>Developer Mailing List - &serdevlink;</para>
- </listitem>
- </itemizedlist>
- <para>
- E-mails regarding any stable &ser; release should be sent to
- &serusersmail; and e-mails regarding development versions
- should be sent to &serdevmail;.
- </para>
- <para>
- If you want to keep the mail private, send it to
- &serhelpmail;.
- </para>
- </answer>
- </qandaentry>
- <qandaentry>
- <question>
- <para>How can I report a bug?</para>
- </question>
- <answer>
- <para>
- Please follow the guidelines provided at:
- &serbugslink;.
- </para>
- </answer>
- </qandaentry>
- </qandaset>
-</chapter>
-
-<!-- Keep this element at the end of the file
-Local Variables:
-sgml-parent-document: ("db_berkeley.sgml" "Book" "chapter")
-End:
--->
diff --git a/modules/db_berkeley/doc/db_berkeley_user.sgml b/modules/db_berkeley/doc/db_berkeley_user.sgml
index b2bd6e3..affdf40 100644
--- a/modules/db_berkeley/doc/db_berkeley_user.sgml
+++ b/modules/db_berkeley/doc/db_berkeley_user.sgml
@@ -2,12 +2,6 @@
<chapter>
<chapterinfo>
- <revhistory>
- <revision>
- <revnumber>$Revision: 846 $</revnumber>
- <date>$Date: 2006-05-22 09:15:40 -0500 (Mon, 22 May 2006) $</date>
- </revision>
- </revhistory>
</chapterinfo>
<title>User's Guide</title>
@@ -587,8 +581,3 @@ usage: ./bdb_recover -s schemadir [-h home] [-R lastN]
</chapter>
-<!-- Keep this element at the end of the file
-Local Variables:
-sgml-parent-document: "db_berkeley.sgml" "Book" "chapter")
-End:
--->