in the gettext branch i started renaming table fields from german to english and doing some cleanups.. the idea of using a data dictionary may be appealing at first, but when you start noticing all the small differences between hospitals and countries, you resolve to using a lot of config tables..
there is little or no recursion i c2x code, afaik. the use of the $$ was a bad design choice for which we are paying. as robert said those will be done afer closing the bugs in 2.6.1 gj. On 2010-09-21 9:06.MD, Ap.Muthu wrote: > $$ - Mostly used as LD_var for translating strings and possibly field names > A data dictionary is what is needed. > I will now try to make some (non)sense out of an entity relationship diagram > for care2x. > The unusual naming conventions for naming fields have got me dizzy. > Since we are all using MySQL5, should we not go in for some views? > $$ is very useful in handling recursively a set of field names and table > names from the information_schema table to act uipon user tables across a > set of similar databases. > Many files have the version number of Care2x hard coded - sould we not use > some config variable for it and do away with the versions table? Is the > versions table used anywhere? > > Regards, > Ap.Muthu > > >> Hi Robert, >> >> you are so right about the $$ a lot of modules uses it, >> prescription, lab requests, depot... >> it's really a dark chapter.. >> >> gj. >> >> On 2010-09-21 8:49.MD, Robert Meggle wrote: >>> Hi Muthu, >>> >>> We are now on the level where all had started of care2x nearly 10 years >>> ago. Since that time that peace of code had not been touched. But you're >>> right, the "_" will be escaped by MySQL and the interesting thing is >>> that somehow it had been worked now since years. >>> >>> Another aspect, especially on that ground.level.zero: The idea to store >>> that kind of global settings in a table like we are discussing it now is >>> really ok, but we can discuss the naming convention of it. But the way >>> how it is used by $$ use of var.... look: >>> http://www.php.net/manual/en/language.variables.variable.php >>> >>> That is a dark chapter of php how to (mis)use variables. Normally you >>> should read it, understand it, and -please- forget it and never use it! >>> >>> Robert >>> >>> >>> Am Dienstag, den 21.09.2010, 23:19 +0530 schrieb Ap.Muthu: >>>> Hi Robert, >>>> >>>> That's a good one. >>>> >>>> I did notice that in many parts of the code the global config variable >>>> was >>>> selectively filtered using "person_%". In MySQL, the "_" should be >>>> escaped >>>> as otherwise it means any characters wildcard. The existing filter will >>>> choose "personell" and "person_" as well! I do not know if the >>>> "person\_%" >>>> will work as an argument in the function but it certainly works in MySQL >>>> directly. At the moment it is not affecting any working by having a few >>>> more >>>> unfiltered variables getting in. >>>> >>>> Regards, >>>> Ap.Muthu >>>> >>>>> Hi, >>>>> >>>>> just one note on 6779, there was one value missing in >>>>> care_config_global. Can be added by: >>>>> >>>>> INSERT INTO care_config_global VALUES ('person_insurance_1_nr_hide', >>>>> '1', NULL, '', '', '', 00000000000000, '', '0000-00-00 00:00:00'); >>>>> >>>>> Robert >>>> >>>> ------------------------------------------------------------------------------ >>>> Start uncovering the many advantages of virtual appliances >>>> and start using them to simplify application deployment and >>>> accelerate your shift to cloud computing. >>>> http://p.sf.net/sfu/novell-sfdev2dev >>>> _______________________________________________ >>>> Care2002-developers mailing list >>>> Care2002-developers@lists.sourceforge.net >>>> https://lists.sourceforge.net/lists/listinfo/care2002-developers >> ------------------------------------------------------------------------------ >> Start uncovering the many advantages of virtual appliances >> and start using them to simplify application deployment and >> accelerate your shift to cloud computing. >> http://p.sf.net/sfu/novell-sfdev2dev >> _______________________________________________ >> Care2002-developers mailing list >> Care2002-developers@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/care2002-developers >> > > > ------------------------------------------------------------------------------ > Start uncovering the many advantages of virtual appliances > and start using them to simplify application deployment and > accelerate your shift to cloud computing. > http://p.sf.net/sfu/novell-sfdev2dev > _______________________________________________ > Care2002-developers mailing list > Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
