Also, you'll have to be VERY careful about auto increment ID fields... What works in MySQL doesn't work on Postgresql...
> From: Leon de Rooij <[email protected]> > Reply-To: "[email protected]" > <[email protected]> > Date: Thu, 18 Jun 2009 11:48:48 +0200 > To: "[email protected]" > <[email protected]> > Subject: [Freeswitch-dev] mod_xml_odbc > > Hi all, > > I'd like to generate user directory xml directly in FS to bypass http > +php (or other scripting language) entirely. So I started writing a > module to do just that. It's still rough - I don't code c very often - > but it works. > > http://jira.freeswitch.org/browse/XML-3 > > Currently all queries are statically defined in the module so users > cannot deviate from the sql schema. Bkw suggested to have a look at > mod_lcr which look really cool, though I'm not really sure yet how to > get the same behavior in this module. > > The sql schema (without indexes for readability) currently looks like > this: > > http://pastebin.freeswitch.org/9427 > > In the module, I'm doing 7 queries: > > Q1: Get domain_id and user_id > Q2: Get domain_params > Q3: Get domain_variables > Q4: Get user_attrs > Q5: Get user_params > Q6: Get user_variables > Q7: Get groups > > Where Q2-Q6 should return a list of name/value pairs. > > To make things more configurable by the user of the module, I could > place all queries in the configuration file, like this: > > http://pastebin.freeswitch.org/9426 > > Do you think that would be acceptable ? > > Then I'd remove all code that automatically generates tables (which > would make the code a lot cleaner and I won't need to find out how to > set auto_increment as it's different for each database). > > Are there any other things I should think about ? > > Do you think this module could be accepted in FS ? :-) > > Thanks for the input ! > > Kind regards, > > Leon > > _______________________________________________ > Freeswitch-dev mailing list > [email protected] > http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev > http://www.freeswitch.org _______________________________________________ Freeswitch-dev mailing list [email protected] http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
