1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
|
# coding: utf8
#==============================================================
# GNUmed database schema change script
#
# License: GPL v2 or later
# Author: karsten.hilbert@gmx.net
#
#==============================================================
import os
from Gnumed.pycommon import gmPG2
#--------------------------------------------------------------
def run(conn=None):
# vaccination history
gmPG2.file2bytea (
query = u"""
update ref.paperwork_templates set
data = %(data)s::bytea,
external_version = '18.4'
where
name_long = 'Vaccination history (GNUmed default)'""",
filename = os.path.join('..', 'sql', 'v17-v18', 'data', 'v18-GNUmed-default_vaccination_history_template.tex'),
conn = conn
)
# invalid GKV-Rezept
gmPG2.file2bytea (
query = u"""
update ref.paperwork_templates set
data = %(data)s::bytea,
external_version = '18.4'
where
name_long = 'ungültiges GKV-Rezept (GNUmed-Vorgabe)'""",
filename = os.path.join('..', 'sql', 'v17-v18', 'data', 'v18-GNUmed-INVALID_default_GKV_Rezept_template.tex'),
conn = conn
)
# LMcC autograph
gmPG2.file2bytea (
query = u"""
update ref.keyword_expansion set
textual_data = NULL,
binary_data = %(data)s::bytea
where
keyword = 'autograph-LMcC'""",
filename = os.path.join('..', 'sql', 'v17-v18', 'data', 'v18-LMcC_autograph.png'),
conn = conn
)
# 1x1 pixels transparent PNG for use in overpic LaTeX environments
gmPG2.file2bytea (
query = u"""
update ref.keyword_expansion set
textual_data = NULL,
binary_data = %(data)s::bytea
where
keyword = '1x1-transparent-PNG'""",
filename = os.path.join('..', 'sql', 'v17-v18', 'data', 'v18-1x1-transparent.png'),
conn = conn
)
# recalls
gmPG2.file2bytea (
query = u"""
update ref.paperwork_templates set
data = %(data)s::bytea,
external_version = '18.0'
where
name_long = 'Upcoming Recalls (GNUmed default)'""",
filename = os.path.join('..', 'sql', 'v17-v18', 'data', 'v18-GNUmed-default_recalls_template.tex'),
conn = conn
)
# referral letter
gmPG2.file2bytea (
query = u"""
update ref.paperwork_templates
set
data = %(data)s::bytea,
external_version = '18.4'
where name_long = 'Referral letter (GNUmed default) [Dr.Rogerio Luz]'
""",
filename = os.path.join('..', 'sql', 'v17-v18', 'data', 'v18-GNUmed-default_referral_letter_template.tex'),
conn = conn
)
# most recent vaccinations record
gmPG2.file2bytea (
query = u"""
UPDATE ref.paperwork_templates SET
data = %(data)s::bytea,
external_version = '18.4'
WHERE
name_long = 'Most recent vaccinations (GNUmed default)'
""",
filename = os.path.join('..', 'sql', 'v17-v18', 'data', 'v18-GNUmed-default_latest_vaccinations_record_template.tex'),
conn = conn
)
# medication list
gmPG2.file2bytea (
query = u"""
UPDATE ref.paperwork_templates SET
data = %(data)s::bytea,
external_version = '18.4'
WHERE
name_long = 'Current medication list (GNUmed default)'
""",
filename = os.path.join('..', 'sql', 'v17-v18', 'data', 'v18-GNUmed-default_medication_list_template.tex'),
conn = conn
)
# consultation report
gmPG2.file2bytea (
query = u"""
update ref.paperwork_templates
set
data = %(data)s::bytea,
external_version = '18.4'
where name_long = 'Consultation report (GNUmed default)'
""",
filename = os.path.join('..', 'sql', 'v17-v18', 'data', 'v18-GNUmed-default_consultation_report_template.tex'),
conn = conn
)
# emr journal
gmPG2.file2bytea (
query = u"""
update ref.paperwork_templates
set
data = %(data)s::bytea,
external_version = '18.4'
where name_long = 'EMR Journal (GNUmed default)'
""",
filename = os.path.join('..', 'sql', 'v17-v18', 'data', 'v18-GNUmed-default_emr_journal_template.tex'),
conn = conn
)
return True
#==============================================================
|
