============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/client/bitmaps/empty-face-in-bust.png,v Working file: client/bitmaps/empty-face-in-bust.png head: 1.1 branch: locks: strict access list: symbolic names: keyword substitution: b total revisions: 1; selected revisions: 1 description: ---------------------------- revision 1.1 date: 2004/10/11 20:21:37; author: ncq; state: Exp; - default patient picture ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/client/business/gmClinicalRecord.py,v Working file: client/business/gmClinicalRecord.py head: 1.144 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 144; selected revisions: 6 description: ---------------------------- revision 1.144 date: 2004/10/18 11:33:48; author: ncq; state: Exp; lines: +43 -33 - more bulk loading ---------------------------- revision 1.143 date: 2004/10/12 18:39:12; author: ncq; state: Exp; lines: +29 -20 - first cut at using Carlos' bulk fetcher in get_vaccinations(), seems to work fine so far ... please test and report lossage ... ---------------------------- revision 1.142 date: 2004/10/12 11:14:51; author: ncq; state: Exp; lines: +45 -38 - improve get_scheduled_vaccination_regimes/get_vaccinations, mostly by Carlos ---------------------------- revision 1.141 date: 2004/10/11 19:50:15; author: ncq; state: Exp; lines: +19 -13 - improve get_allergies() ---------------------------- revision 1.140 date: 2004/09/28 12:19:15; author: ncq; state: Exp; lines: +144 -49 - any vaccination related data now cached under 'vaccinations' so all of it is flushed when any change to vaccinations occurs - rewrite get_scheduled_vaccination_regimes() (Carlos) - in get_vaccinations() compute seq_no and is_booster status ---------------------------- revision 1.139 date: 2004/09/19 15:07:01; author: ncq; state: Exp; lines: +46 -62 - we don't use a default health issue anymore - remove duplicate existence checks - cleanup, reformat/fix episode queries ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/client/business/gmMedDoc.py,v Working file: client/business/gmMedDoc.py head: 1.24 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 24; selected revisions: 2 description: ---------------------------- revision 1.24 date: 2004/10/11 19:46:52; author: ncq; state: Exp; lines: +210 -297 - properly VOify deriving from cBusinessDBObject - cMedObj -> cMedDocPart - cDocumentFolder.get_documents() - cMedDoc.get_descriptions() where max_lng=None will fetch entire description - comments, cleanup ---------------------------- revision 1.23 date: 2004/09/28 12:20:16; author: ncq; state: Exp; lines: +29 -10 - cleanup/robustify - add get_latest_mugshot() ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/client/business/gmPathLab.py,v Working file: client/business/gmPathLab.py head: 1.41 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 41; selected revisions: 6 description: ---------------------------- revision 1.41 date: 2004/10/18 09:48:20; author: ncq; state: Exp; lines: +14 -11 - must have been asleep at the keyboard ---------------------------- revision 1.40 date: 2004/10/18 09:46:02; author: ncq; state: Exp; lines: +17 -13 - fix create_lab_result() ---------------------------- revision 1.39 date: 2004/10/15 09:05:08; author: ncq; state: Exp; lines: +59 -31 - converted cLabResult to allow use of row __init__() ---------------------------- revision 1.38 date: 2004/10/12 18:32:52; author: ncq; state: Exp; lines: +67 -35 - allow cLabRequest and cTestType to be filled from bulk fetch row data - cLabResult not adapted yet ---------------------------- revision 1.37 date: 2004/09/29 10:25:04; author: ncq; state: Exp; lines: +15 -12 - basic_unit->conversion_unit ---------------------------- revision 1.36 date: 2004/09/18 13:51:56; author: ncq; state: Exp; lines: +13 -4 - support val_target_* ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/client/business/gmVaccination.py,v Working file: client/business/gmVaccination.py head: 1.13 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 13; selected revisions: 3 description: ---------------------------- revision 1.13 date: 2004/10/18 11:35:42; author: ncq; state: Exp; lines: +7 -3 - cleanup ---------------------------- revision 1.12 date: 2004/10/12 11:16:22; author: ncq; state: Exp; lines: +79 -18 - robustify cVaccination.set_seq_no/set_booster_status - Carlos added cVaccinationRegime/put_patient_on_schedule - some test code ---------------------------- revision 1.11 date: 2004/09/28 12:28:12; author: ncq; state: Exp; lines: +71 -10 - cVaccination: add set_booster_status(), set_seq_no() - add cScheduledVaccination (by Carlos) - improve testing ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/client/exporters/gmPatientExporter.py,v Working file: client/exporters/gmPatientExporter.py head: 1.33 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 33; selected revisions: 4 description: ---------------------------- revision 1.33 date: 2004/10/12 10:52:40; author: ncq; state: Exp; lines: +70 -45 - improve vaccinations handling ---------------------------- revision 1.32 date: 2004/10/11 19:53:41; author: ncq; state: Exp; lines: +21 -13 - document classes are now VOs ---------------------------- revision 1.31 date: 2004/09/29 19:13:37; author: ncq; state: Exp; lines: +14 -9 - cosmetical fixes as discussed with our office staff ---------------------------- revision 1.30 date: 2004/09/29 10:12:50; author: ncq; state: Exp; lines: +191 -99 - Carlos added intuitive vaccination table - muchos improvos ! ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/client/pycommon/gmBusinessDBObject.py,v Working file: client/pycommon/gmBusinessDBObject.py head: 1.2 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 2; selected revisions: 2 description: ---------------------------- revision 1.2 date: 2004/10/12 18:37:45; author: ncq; state: Exp; lines: +76 -14 - Carlos added passing in possibly bulk-fetched row data w/o touching the database in __init__() - note that some higher level things will be broken until all affected child classes are fixed - however, note that child classes that don't overload __init__() are NOT affected and support no-DB init transparently - changed docs accordingly - this is the initial bulk-loader work that is hoped to gain quite some performance in some areas (think lab results) ---------------------------- revision 1.1 date: 2004/10/11 19:05:41; author: ncq; state: Exp; - business object-in-db root class, used by cClinItem etc. ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/client/wxpython/gmAllergyWidgets.py,v Working file: client/wxpython/gmAllergyWidgets.py head: 1.3 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 3; selected revisions: 1 description: ---------------------------- revision 1.3 date: 2004/10/11 20:14:16; author: ncq; state: Exp; lines: +177 -205 - use RegetOnPaintMixin - attach to backend - cleanup, remove cruft ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/client/wxpython/gmDemographics.py,v Working file: client/wxpython/gmDemographics.py head: 1.45 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 45; selected revisions: 3 description: ---------------------------- revision 1.45 date: 2004/10/17 23:49:21; author: sjtan; state: Exp; lines: +64 -3 the timer autoscroll idea. ---------------------------- revision 1.44 date: 2004/10/17 22:26:42; author: sjtan; state: Exp; lines: +303 -241 split window new look Richard's demographics ( his eye for gui design is better than most of ours). Rollback if vote no. ---------------------------- revision 1.43 date: 2004/10/16 22:42:12; author: sjtan; state: Exp; lines: +11 -4 script for unitesting; guard for unit tests where unit uses gmPhraseWheel; fixup where version of wxPython doesn't allow a child widget to be multiply inserted (gmDemographics) ; try block for later versions of wxWidgets that might fail the Add (.. w,h, ... ) because expecting Add(.. (w,h) ...) ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/client/wxpython/gmGuiMain.py,v Working file: client/wxpython/gmGuiMain.py head: 1.175 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 175; selected revisions: 2 description: ---------------------------- revision 1.175 date: 2004/10/01 13:17:35; author: ncq; state: Exp; lines: +10 -3 - eventually do what was intended on slave_mode != 1 ---------------------------- revision 1.174 date: 2004/10/01 11:49:59; author: ncq; state: Exp; lines: +8 -4 - improve message on unset database language ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/client/wxpython/gmHorstSpace.py,v Working file: client/wxpython/gmHorstSpace.py head: 1.6 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 6; selected revisions: 3 description: ---------------------------- revision 1.6 date: 2004/10/17 16:06:30; author: ncq; state: Exp; lines: +9 -3 - silly whitespace fix ---------------------------- revision 1.5 date: 2004/10/16 22:42:12; author: sjtan; state: Exp; lines: +6 -3 script for unitesting; guard for unit tests where unit uses gmPhraseWheel; fixup where version of wxPython doesn't allow a child widget to be multiply inserted (gmDemographics) ; try block for later versions of wxWidgets that might fail the Add (.. w,h, ... ) because expecting Add(.. (w,h) ...) ---------------------------- revision 1.4 date: 2004/10/14 12:11:18; author: ncq; state: Exp; lines: +8 -3 - improve comments ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/client/wxpython/gmMedDocWidgets.py,v Working file: client/wxpython/gmMedDocWidgets.py head: 1.9 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 9; selected revisions: 6 description: ---------------------------- revision 1.9 date: 2004/10/17 15:57:36; author: ncq; state: Exp; lines: +16 -11 - after pat.get_documents(): 1) separate len(docs) == 0 from docs is None 2) only the second really is an error 3) however, return True from it, too, as we informed the user about the error already ---------------------------- revision 1.8 date: 2004/10/17 00:05:36; author: sjtan; state: Exp; lines: +11 -1 fixup for paint event re-entry when notification dialog occurs over medDocTree graphics area, and triggers another paint event, and another notification dialog , in a loop. Fixup is set flag to stop _repopulate_tree, and to only unset this flag when patient activating signal gmMedShowDocs to schedule_reget, which is overridden to include resetting of flag, before calling mixin schedule_reget. ---------------------------- revision 1.7 date: 2004/10/14 12:11:50; author: ncq; state: Exp; lines: +6 -3 - __on_activate -> _on_activate ---------------------------- revision 1.6 date: 2004/10/11 19:56:03; author: ncq; state: Exp; lines: +91 -119 - cleanup, robustify, attach doc/part VO directly to node ---------------------------- revision 1.5 date: 2004/10/01 13:34:26; author: ncq; state: Exp; lines: +16 -3 - don't fail to display just because some metadata is missing ---------------------------- revision 1.4 date: 2004/09/19 15:10:44; author: ncq; state: Exp; lines: +50 -63 - lots of cleanup - use status message instead of error box on missing patient so that we don't get an endless loop -> paint_event -> update_gui -> no-patient message -> paint_event -> ... ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/client/wxpython/gmPatPicWidgets.py,v Working file: client/wxpython/gmPatPicWidgets.py head: 1.6 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 6; selected revisions: 2 description: ---------------------------- revision 1.6 date: 2004/10/11 20:18:17; author: ncq; state: Exp; lines: +88 -94 - GnuMed now sports a patient pic in the top panel - not loaded when changing patient (rather reverting to empty face) - use right-click context menu "refresh photo" manually - only Kirk has a picture so far ---------------------------- revision 1.5 date: 2004/09/18 13:54:37; author: ncq; state: Exp; lines: +6 -3 - improve strings ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/client/wxpython/gmPatSearchWidgets.py,v Working file: client/wxpython/gmPatSearchWidgets.py head: 1.8 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 8; selected revisions: 1 description: ---------------------------- revision 1.8 date: 2004/10/19 13:17:02; author: sjtan; state: Exp; lines: +44 -19 try except block for logging and letting the dialog work on not quite upto date postgres installations. ( one's with no set session characteristics to transaction read only). ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/client/wxpython/gmPlugin.py,v Working file: client/wxpython/gmPlugin.py head: 1.37 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 37; selected revisions: 1 description: ---------------------------- revision 1.37 date: 2004/10/14 12:14:51; author: ncq; state: Exp; lines: +21 -15 - rearrange register() internally so we won't end up with half-baked but registered plugins ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/client/wxpython/gmRegetMixin.py,v Working file: client/wxpython/gmRegetMixin.py head: 1.6 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 6; selected revisions: 2 description: ---------------------------- revision 1.6 date: 2004/10/17 15:52:21; author: ncq; state: Exp; lines: +16 -7 - cleanup ---------------------------- revision 1.5 date: 2004/10/17 00:05:36; author: sjtan; state: Exp; lines: +8 -2 fixup for paint event re-entry when notification dialog occurs over medDocTree graphics area, and triggers another paint event, and another notification dialog , in a loop. Fixup is set flag to stop _repopulate_tree, and to only unset this flag when patient activating signal gmMedShowDocs to schedule_reget, which is overridden to include resetting of flag, before calling mixin schedule_reget. ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/client/wxpython/gmTopPanel.py,v Working file: client/wxpython/gmTopPanel.py head: 1.54 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 54; selected revisions: 3 description: ---------------------------- revision 1.54 date: 2004/10/17 16:01:44; author: ncq; state: Exp; lines: +12 -9 - the FIXME said DEuglify, not MORE ---------------------------- revision 1.53 date: 2004/10/16 22:42:12; author: sjtan; state: Exp; lines: +10 -3 script for unitesting; guard for unit tests where unit uses gmPhraseWheel; fixup where version of wxPython doesn't allow a child widget to be multiply inserted (gmDemographics) ; try block for later versions of wxWidgets that might fail the Add (.. w,h, ... ) because expecting Add(.. (w,h) ...) ---------------------------- revision 1.52 date: 2004/10/14 12:13:58; author: ncq; state: Exp; lines: +21 -14 - factor out toolbar creation from toolbar registering ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/client/wxpython/gmVaccWidgets.py,v Working file: client/wxpython/gmVaccWidgets.py head: 1.10 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 10; selected revisions: 3 description: ---------------------------- revision 1.10 date: 2004/10/11 20:11:32; author: ncq; state: Exp; lines: +74 -49 - cleanup - attach vacc VOs directly to list items - add editing (eg. adding) missing vaccination ---------------------------- revision 1.9 date: 2004/10/01 11:50:45; author: ncq; state: Exp; lines: +5 -5 - cleanup ---------------------------- revision 1.8 date: 2004/09/18 13:55:28; author: ncq; state: Exp; lines: +5 -5 - cleanup ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/client/wxpython/gui/gmShowMedDocs.py,v Working file: client/wxpython/gui/gmShowMedDocs.py head: 1.58 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 58; selected revisions: 4 description: ---------------------------- revision 1.58 date: 2004/10/17 15:53:55; author: ncq; state: Exp; lines: +9 -9 - cleanup ---------------------------- revision 1.57 date: 2004/10/17 00:05:36; author: sjtan; state: Exp; lines: +11 -1 fixup for paint event re-entry when notification dialog occurs over medDocTree graphics area, and triggers another paint event, and another notification dialog , in a loop. Fixup is set flag to stop _repopulate_tree, and to only unset this flag when patient activating signal gmMedShowDocs to schedule_reget, which is overridden to include resetting of flag, before calling mixin schedule_reget. ---------------------------- revision 1.56 date: 2004/10/14 12:15:21; author: ncq; state: Exp; lines: +5 -2 - cleanup ---------------------------- revision 1.55 date: 2004/09/19 15:12:26; author: ncq; state: Exp; lines: +17 -11 - cleanup ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/external-patches/README,v Working file: external-patches/README head: 1.1 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 1; selected revisions: 1 description: ---------------------------- revision 1.1 date: 2004/09/30 18:21:07; author: ncq; state: Exp; - a few patches for external tools ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/external-patches/pyPgSQL-IN-list-bug.py,v Working file: external-patches/pyPgSQL-IN-list-bug.py head: 1.1 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 1; selected revisions: 1 description: ---------------------------- revision 1.1 date: 2004/09/30 18:21:07; author: ncq; state: Exp; - a few patches for external tools ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/external-patches/pyPgSQL-interval2mxDateTimeDelta-bugfix.py,v Working file: external-patches/pyPgSQL-interval2mxDateTimeDelta-bugfix.py head: 1.1 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 1; selected revisions: 1 description: ---------------------------- revision 1.1 date: 2004/09/30 18:21:07; author: ncq; state: Exp; - a few patches for external tools ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/server/sql/gmAudit.sql,v Working file: server/sql/gmAudit.sql head: 1.8 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 8; selected revisions: 1 description: ---------------------------- revision 1.8 date: 2004/09/22 14:10:38; author: ncq; state: Exp; lines: +58 -2 - add RULEs to protect audit_trail/audit_fields parent tables from direct insert/update/delete to preserve referential integrity ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/server/sql/gmBlobViews.sql,v Working file: server/sql/gmBlobViews.sql head: 1.7 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 7; selected revisions: 3 description: ---------------------------- revision 1.7 date: 2004/10/11 19:29:13; author: ncq; state: Exp; lines: +52 -27 - v_i18n_doc_type -> v_doc_type - v_doc_med ---------------------------- revision 1.6 date: 2004/10/10 13:13:51; author: ihaywood; state: Exp; lines: +30 -2 example of views to emulate the gmMeasurements tables ---------------------------- revision 1.5 date: 2004/09/20 21:12:42; author: ncq; state: Exp; lines: +22 -16 - constraint on doc_desc - improve v_obj4doc - fix v_latest_mugshot ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/server/sql/gmBlobs.sql,v Working file: server/sql/gmBlobs.sql head: 1.45 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 45; selected revisions: 4 description: ---------------------------- revision 1.45 date: 2004/10/11 18:58:45; author: ncq; state: Exp; lines: +25 -59 - rolled back Ian's changes but retained his comments - needs further thought before implementation ---------------------------- revision 1.44 date: 2004/10/10 13:13:51; author: ihaywood; state: Exp; lines: +23 -5 example of views to emulate the gmMeasurements tables ---------------------------- revision 1.43 date: 2004/10/10 06:34:12; author: ihaywood; state: Exp; lines: +41 -3 Extended blobs to support basic document management: keeping track of whose reviewed what, etc. This duplicates the same functionality for path. results: how can we integrate? CVS ---------------------------------------------------------------------- ---------------------------- revision 1.42 date: 2004/09/20 21:12:42; author: ncq; state: Exp; lines: +9 -4 - constraint on doc_desc - improve v_obj4doc - fix v_latest_mugshot ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/server/sql/gmBlobsData.sql,v Working file: server/sql/gmBlobsData.sql head: 1.9 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 9; selected revisions: 3 description: ---------------------------- revision 1.9 date: 2004/10/11 19:02:31; author: ncq; state: Exp; lines: +29 -55 - go back to before changes that need more discussion ---------------------------- revision 1.8 date: 2004/10/10 13:13:51; author: ihaywood; state: Exp; lines: +16 -4 example of views to emulate the gmMeasurements tables ---------------------------- revision 1.7 date: 2004/10/10 06:34:13; author: ihaywood; state: Exp; lines: +21 -4 Extended blobs to support basic document management: keeping track of whose reviewed what, etc. This duplicates the same functionality for path. results: how can we integrate? CVS ---------------------------------------------------------------------- ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/server/sql/gmClinicalData.sql,v Working file: server/sql/gmClinicalData.sql head: 1.32 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 32; selected revisions: 2 description: ---------------------------- revision 1.32 date: 2004/09/29 10:26:40; author: ncq; state: Exp; lines: +11 -8 - basic_unit -> conversion_unit ---------------------------- revision 1.31 date: 2004/09/25 13:23:32; author: ncq; state: Exp; lines: +64 -12 - add dummy test orgs for in-house/self-measured/generic external ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/server/sql/gmClinicalViews.sql,v Working file: server/sql/gmClinicalViews.sql head: 1.109 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 109; selected revisions: 13 description: ---------------------------- revision 1.109 date: 2004/10/12 09:50:21; author: ncq; state: Exp; lines: +6 -2 - enhance v_vacc_regimes -> add "shots" field holding number of shots for regime ---------------------------- revision 1.108 date: 2004/10/11 19:32:19; author: ncq; state: Exp; lines: +9 -6 - clean up v_pat_allergies ---------------------------- revision 1.107 date: 2004/09/29 19:17:24; author: ncq; state: Exp; lines: +11 -5 - fix typos and grants ---------------------------- revision 1.106 date: 2004/09/29 10:38:22; author: ncq; state: Exp; lines: +254 -26 - measurement views rewritten to match current discussion ---------------------------- revision 1.105 date: 2004/09/28 12:29:29; author: ncq; state: Exp; lines: +8 -3 - add pk_vacc_def to v_vaccs_scheduled4pat ---------------------------- revision 1.104 date: 2004/09/25 13:25:56; author: ncq; state: Exp; lines: +16 -10 - is_significant -> clinically_relevant ---------------------------- revision 1.103 date: 2004/09/22 14:12:19; author: ncq; state: Exp; lines: +33 -2 - add rules to protect clin_root_item from direct insert/update/delete, this prevents child table coherency issues ---------------------------- revision 1.102 date: 2004/09/20 21:14:11; author: ncq; state: Exp; lines: +7 -8 - remove cruft, fix grants - retire lnk_vacc2vacc_def for now as we seem to not need it ---------------------------- revision 1.101 date: 2004/09/18 13:49:32; author: ncq; state: Exp; lines: +25 -20 - fix missing patient pk in v_compl_narrative ---------------------------- revision 1.100 date: 2004/09/18 00:19:24; author: ncq; state: Exp; lines: +122 -3 - add v_compl_narrative - add v_problem_list - include is_significant in v_pat_episodes ---------------------------- revision 1.99 date: 2004/09/17 20:59:58; author: ncq; state: Exp; lines: +6 -108 - remove cruft - in v_pat_episodes UNION pull data from correct places ... ---------------------------- revision 1.98 date: 2004/09/17 20:28:05; author: ncq; state: Exp; lines: +17 -3 - PG 7.4 is helpful: fix UNION ---------------------------- revision 1.97 date: 2004/09/17 20:14:06; author: ncq; state: Exp; lines: +57 -13 - curr_medication -> clin_medication + propagate - partial index on clin_episode.fk_health_issue where fk_health_issue not null - index on clin_medication.discontinued where discontinued not null - rework v_pat_episodes since episode can now have fk_health_issue = null - add val_target_* to v_test_results - fix grants - improve clin_health_issue datatypes + comments - clin_episode: add fk_patient, fk_health_issue nullable - but constrain: if fk_health_issue null then fk_patient NOT none or vice versa - form_instances are soaP - start rework of clin_medication (was curr_medication) ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/server/sql/gmConfigData.sql,v Working file: server/sql/gmConfigData.sql head: 1.4 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 4; selected revisions: 1 description: ---------------------------- revision 1.4 date: 2004/10/01 13:26:15; author: ncq; state: Exp; lines: +21 -2 - add workplace "KnoppixMedica" CD user ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/server/sql/gmMeasurements.sql,v Working file: server/sql/gmMeasurements.sql head: 1.33 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 33; selected revisions: 5 description: ---------------------------- revision 1.33 date: 2004/10/17 16:27:15; author: ncq; state: Exp; lines: +11 -3 - val_num: float -> numeric + fix views - clin_when::date in prescribed_after_started constraint ---------------------------- revision 1.32 date: 2004/10/10 06:34:13; author: ihaywood; state: Exp; lines: +11 -3 Extended blobs to support basic document management: keeping track of whose reviewed what, etc. This duplicates the same functionality for path. results: how can we integrate? CVS ---------------------------------------------------------------------- ---------------------------- revision 1.31 date: 2004/09/29 10:33:54; author: ncq; state: Exp; lines: +55 -29 - cleanup - normalize test_type_local into lnk_table - basic_unit -> conversion_unit ---------------------------- revision 1.30 date: 2004/09/28 12:30:22; author: ncq; state: Exp; lines: +8 -6 - add constraint on test_type_local ---------------------------- revision 1.29 date: 2004/09/17 20:15:00; author: ncq; state: Exp; lines: +20 -4 - add val_target_* to test_result ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/server/sql/gmclinical.sql,v Working file: server/sql/gmclinical.sql head: 1.131 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 131; selected revisions: 10 description: ---------------------------- revision 1.131 date: 2004/10/17 16:27:15; author: ncq; state: Exp; lines: +10 -8 - val_num: float -> numeric + fix views - clin_when::date in prescribed_after_started constraint ---------------------------- revision 1.130 date: 2004/10/14 14:56:43; author: ncq; state: Exp; lines: +79 -54 - work on clin_medication to reflect recent discussion ---------------------------- revision 1.129 date: 2004/09/25 13:25:56; author: ncq; state: Exp; lines: +16 -13 - is_significant -> clinically_relevant ---------------------------- revision 1.128 date: 2004/09/20 23:46:37; author: ncq; state: Exp; lines: +7 -5 - as Syan noted the unique() constraints on clin_episode were plain wrong ---------------------------- revision 1.127 date: 2004/09/20 21:14:11; author: ncq; state: Exp; lines: +27 -24 - remove cruft, fix grants - retire lnk_vacc2vacc_def for now as we seem to not need it ---------------------------- revision 1.126 date: 2004/09/19 17:16:28; author: ncq; state: Exp; lines: +7 -3 - alter table <> add constraint <> needs table name ---------------------------- revision 1.125 date: 2004/09/19 11:25:34; author: ncq; state: Exp; lines: +35 -14 - improved comments - loosened constraints on clin_diag, as found necessary by Jim ---------------------------- revision 1.124 date: 2004/09/18 00:20:57; author: ncq; state: Exp; lines: +55 -23 - add active/significant fields to episode/issue table - improve comments - tighten constraints on clin_episode ---------------------------- revision 1.123 date: 2004/09/17 21:02:04; author: ncq; state: Exp; lines: +18 -5 - further tighten clin_episode ---------------------------- revision 1.122 date: 2004/09/17 20:14:06; author: ncq; state: Exp; lines: +139 -68 - curr_medication -> clin_medication + propagate - partial index on clin_episode.fk_health_issue where fk_health_issue not null - index on clin_medication.discontinued where discontinued not null - rework v_pat_episodes since episode can now have fk_health_issue = null - add val_target_* to v_test_results - fix grants - improve clin_health_issue datatypes + comments - clin_episode: add fk_patient, fk_health_issue nullable - but constrain: if fk_health_issue null then fk_patient NOT none or vice versa - form_instances are soaP - start rework of clin_medication (was curr_medication) ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/server/sql/test-data/test_data-James_Kirk.sql,v Working file: server/sql/test-data/test_data-James_Kirk.sql head: 1.39 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 39; selected revisions: 6 description: ---------------------------- revision 1.39 date: 2004/10/11 19:36:32; author: ncq; state: Exp; lines: +9 -5 - id -> pk ---------------------------- revision 1.38 date: 2004/09/29 10:31:11; author: ncq; state: Exp; lines: +9 -6 - test_type.id -> pk - basic_unit -> conversion_unit ---------------------------- revision 1.37 date: 2004/09/25 13:25:56; author: ncq; state: Exp; lines: +7 -4 - is_significant -> clinically_relevant ---------------------------- revision 1.36 date: 2004/09/20 21:18:26; author: ncq; state: Exp; lines: +41 -19 - add small picture for Kirk ---------------------------- revision 1.35 date: 2004/09/17 20:32:27; author: ncq; state: Exp; lines: +10 -4 - IF there is a health issue it MUST have a label, there is no default ---------------------------- revision 1.34 date: 2004/09/17 20:18:10; author: ncq; state: Exp; lines: +21 -18 - clin_episode_id_seq -> *_pk_seq ============================================================================= RCS file: /cvsroot/gnumed/gnumed/gnumed/server/sql/test-data/test_data-USS_Enterprise.sql,v Working file: server/sql/test-data/test_data-USS_Enterprise.sql head: 1.11 branch: locks: strict access list: symbolic names: keyword substitution: kv total revisions: 11; selected revisions: 2 description: ---------------------------- revision 1.11 date: 2004/09/29 19:16:28; author: ncq; state: Exp; lines: +40 -14 - fix test type defs ---------------------------- revision 1.10 date: 2004/09/29 10:31:11; author: ncq; state: Exp; lines: +13 -10 - test_type.id -> pk - basic_unit -> conversion_unit =============================================================================