Module: sip-router Branch: tteras/db_sqlite Commit: 9d36d8537b21b2d1cd51dd639ad8c1b802af2672 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=9d36d853...
Author: Natanael Copa ncopa@alpinelinux.org Committer: Timo Teräs timo.teras@iki.fi Date: Thu May 26 07:18:44 2011 +0000
utils: add sqlite support to kamctl/kamdbctl
- sql scripts copied from postgres versions and converted to sqlite (only major change was: sed s/SERIAL/INTEGER/) - kamdbctl.sqlite based on kamdbctl.postgres with permissions stuff removed (sqlite has unix file permissions only) and some mysql emulation removed too - no real ro-mode
---
utils/kamctl/kamctl | 6 + utils/kamctl/kamctl.sqlite | 51 +++++++++ utils/kamctl/kamctlrc | 6 +- utils/kamctl/kamdbctl | 13 ++ utils/kamctl/kamdbctl.sqlite | 152 ++++++++++++++++++++++++++ utils/kamctl/sqlite/acc-create.sql | 28 +++++ utils/kamctl/sqlite/alias_db-create.sql | 12 ++ utils/kamctl/sqlite/auth_db-create.sql | 15 +++ utils/kamctl/sqlite/avpops-create.sql | 15 +++ utils/kamctl/sqlite/carrierroute-create.sql | 42 +++++++ utils/kamctl/sqlite/cpl-create.sql | 10 ++ utils/kamctl/sqlite/dialog-create.sql | 29 +++++ utils/kamctl/sqlite/dialplan-create.sql | 13 ++ utils/kamctl/sqlite/dispatcher-create.sql | 11 ++ utils/kamctl/sqlite/domain-create.sql | 8 ++ utils/kamctl/sqlite/domainpolicy-create.sql | 13 ++ utils/kamctl/sqlite/drouting-create.sql | 39 +++++++ utils/kamctl/sqlite/group-create.sql | 19 +++ utils/kamctl/sqlite/htable-create.sql | 9 ++ utils/kamctl/sqlite/imc-create.sql | 19 +++ utils/kamctl/sqlite/lcr-create.sql | 43 +++++++ utils/kamctl/sqlite/matrix-create.sql | 9 ++ utils/kamctl/sqlite/msilo-create.sql | 16 +++ utils/kamctl/sqlite/mtree-create.sql | 8 ++ utils/kamctl/sqlite/pdt-create.sql | 9 ++ utils/kamctl/sqlite/permissions-create.sql | 21 ++++ utils/kamctl/sqlite/presence-create.sql | 92 ++++++++++++++++ utils/kamctl/sqlite/purple-create.sql | 9 ++ utils/kamctl/sqlite/registrar-create.sql | 22 ++++ utils/kamctl/sqlite/rls-create.sql | 42 +++++++ utils/kamctl/sqlite/siptrace-create.sql | 20 ++++ utils/kamctl/sqlite/speeddial-create.sql | 14 +++ utils/kamctl/sqlite/standard-create.sql | 5 + utils/kamctl/sqlite/uac-create.sql | 16 +++ utils/kamctl/sqlite/uri_db-create.sql | 10 ++ utils/kamctl/sqlite/userblacklist-create.sql | 21 ++++ utils/kamctl/sqlite/usrloc-create.sql | 22 ++++ 37 files changed, 887 insertions(+), 2 deletions(-)
Diff: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commitdiff;h=9d36...
On Thursday 26 May 2011, Timo Teras wrote:
utils: add sqlite support to kamctl/kamdbctl
- sql scripts copied from postgres versions and converted to sqlite (only major change was: sed s/SERIAL/INTEGER/)
Hi Timo,
great. :-) Is this the only change, or do you need also some other smaller adaptions? Then i could adapt the XSL schema generation infrastructure, that sqlite will also automatically be updated in case the schema is changed.
Cheers,
Henning
On 05/26/2011 11:52 AM, Henning Westerholt wrote:
On Thursday 26 May 2011, Timo Teras wrote:
utils: add sqlite support to kamctl/kamdbctl
- sql scripts copied from postgres versions and converted to sqlite (only major change was: sed s/SERIAL/INTEGER/)
Hi Timo,
great. :-) Is this the only change, or do you need also some other smaller adaptions? Then i could adapt the XSL schema generation infrastructure, that sqlite will also automatically be updated in case the schema is changed.
Bah. I didn't realize the schema was autogenerated from xml. Should have checked. :/
But yes, for the current SQL things this was the only change.
- Timo
-
Henning Westerholt -
Timo Teras