Passed
Pull Request — dev (#82)
by Stephan
01:10
created

data.orm.boundaries   A

Complexity

Total Complexity 0

Size/Duplication

Total Lines 387
Duplicated Lines 52.71 %

Importance

Changes 0
Metric Value
wmc 0
eloc 326
dl 204
loc 387
rs 10
c 0
b 0
f 0

How to fix   Duplicated Code   

Duplicated Code

Duplicate code is one of the most pungent code smells. A rule that is often used is to re-structure code once it is duplicated in three or more places.

Common duplication problems, and corresponding solutions are:

1
from geoalchemy2.types import Geometry
2
from sqlalchemy import (
3
    ARRAY,
4
    BigInteger,
5
    Boolean,
6
    Column,
7
    Float,
8
    Integer,
9
    Numeric,
10
    String,
11
    Table,
12
    Text,
13
    text,
14
)
15
from sqlalchemy.ext.declarative import declarative_base
16
17
Base = declarative_base()
18
metadata = Base.metadata
19
20
21
t_bkg_vg250_statistics_view = Table(
22
    "bkg_vg250_statistics_view",
23
    metadata,
24
    Column("id", Text),
25
    Column("area_sum_ha", Integer),
26
    schema="boundaries",
27
)
28
29
30 View Code Duplication
class Vg250Gem(Base):
0 ignored issues
show
Duplication introduced by
This code seems to be duplicated in your project.
Loading history...
31
    __tablename__ = "vg250_gem"
32
    __table_args__ = {
33
        "schema": "boundaries",
34
    }
35
36
    gid = Column(BigInteger, primary_key=True, index=True)
37
    ade = Column(BigInteger)
38
    gf = Column(BigInteger)
39
    bsg = Column(BigInteger)
40
    ars = Column(Text)
41
    ags = Column(Text)
42
    sdv_ars = Column(Text)
43
    gen = Column(Text)
44
    bez = Column(Text)
45
    ibz = Column(BigInteger)
46
    bem = Column(Text)
47
    nbd = Column(Text)
48
    sn_l = Column(Text)
49
    sn_r = Column(Text)
50
    sn_k = Column(Text)
51
    sn_v1 = Column(Text)
52
    sn_v2 = Column(Text)
53
    sn_g = Column(Text)
54
    fk_s3 = Column(Text)
55
    nuts = Column(Text)
56
    ars_0 = Column(Text)
57
    ags_0 = Column(Text)
58
    wsk = Column(Text)
59
    debkg_id = Column(Text)
60
    rs = Column(Text)
61
    sdv_rs = Column(Text)
62
    rs_0 = Column(Text)
63
    geometry = Column(Geometry(srid=4326), index=True)
64
65
66
class Vg250GemClean(Base):
67
    __tablename__ = "vg250_gem_clean"
68
    __table_args__ = {"schema": "boundaries"}
69
70
    id = Column(
71
        Integer,
72
        primary_key=True,
73
        server_default=text(
74
            "nextval('boundaries.vg250_gem_clean_id_seq'::regclass)"
75
        ),
76
    )
77
    old_id = Column(Integer)
78
    gen = Column(Text)
79
    bez = Column(Text)
80
    bem = Column(Text)
81
    nuts = Column(String(5))
82
    rs_0 = Column(String(12))
83
    ags_0 = Column(String(12))
84
    area_ha = Column(Numeric)
85
    count_hole = Column(Integer)
86
    path = Column(ARRAY(Integer()))
87
    is_hole = Column(Boolean)
88
    geometry = Column(Geometry("POLYGON", 3035), index=True)
89
90
91
t_vg250_gem_hole = Table(
92
    "vg250_gem_hole",
93
    metadata,
94
    Column("id", Integer, unique=True),
95
    Column("old_id", Integer),
96
    Column("gen", Text),
97
    Column("bez", Text),
98
    Column("bem", Text),
99
    Column("nuts", String(5)),
100
    Column("rs_0", String(12)),
101
    Column("ags_0", String(12)),
102
    Column("area_ha", Numeric),
103
    Column("count_hole", Integer),
104
    Column("path", ARRAY(Integer())),
105
    Column("is_hole", Boolean),
106
    Column("geometry", Geometry("POLYGON", 3035), index=True),
107
    schema="boundaries",
108
)
109
110
111
t_vg250_gem_valid = Table(
112
    "vg250_gem_valid",
113
    metadata,
114
    Column("id", BigInteger, unique=True),
115
    Column("old_id", Integer),
116
    Column("gen", Text),
117
    Column("bez", Text),
118
    Column("bem", Text),
119
    Column("nuts", String(5)),
120
    Column("rs_0", String(12)),
121
    Column("ags_0", String(12)),
122
    Column("area_ha", Float(53)),
123
    Column("geometry", Geometry("POLYGON", 3035), index=True),
124
    schema="boundaries",
125
)
126
127
128 View Code Duplication
class Vg250Kr(Base):
0 ignored issues
show
Duplication introduced by
This code seems to be duplicated in your project.
Loading history...
129
    __tablename__ = "vg250_krs"
130
    __table_args__ = {
131
        "schema": "boundaries",
132
    }
133
134
    gid = Column(BigInteger, primary_key=True, index=True)
135
    ade = Column(BigInteger)
136
    gf = Column(BigInteger)
137
    bsg = Column(BigInteger)
138
    ars = Column(Text)
139
    ags = Column(Text)
140
    sdv_ars = Column(Text)
141
    gen = Column(Text)
142
    bez = Column(Text)
143
    ibz = Column(BigInteger)
144
    bem = Column(Text)
145
    nbd = Column(Text)
146
    sn_l = Column(Text)
147
    sn_r = Column(Text)
148
    sn_k = Column(Text)
149
    sn_v1 = Column(Text)
150
    sn_v2 = Column(Text)
151
    sn_g = Column(Text)
152
    fk_s3 = Column(Text)
153
    nuts = Column(Text)
154
    ars_0 = Column(Text)
155
    ags_0 = Column(Text)
156
    wsk = Column(Text)
157
    debkg_id = Column(Text)
158
    rs = Column(Text)
159
    sdv_rs = Column(Text)
160
    rs_0 = Column(Text)
161
    geometry = Column(Geometry(srid=4326), index=True)
162
163
164
t_vg250_krs_area = Table(
165
    "vg250_krs_area",
166
    metadata,
167
    Column("id", Integer, unique=True),
168
    Column("gen", Text),
169
    Column("bez", Text),
170
    Column("nuts", String(5)),
171
    Column("rs_0", String(12)),
172
    Column("ags_0", String(12)),
173
    Column("area_ha", Float(53)),
174
    Column("geometry", Geometry, index=True),
175
    schema="boundaries",
176
)
177
178
179 View Code Duplication
class Vg250Lan(Base):
0 ignored issues
show
Duplication introduced by
This code seems to be duplicated in your project.
Loading history...
180
    __tablename__ = "vg250_lan"
181
    __table_args__ = {
182
        "schema": "boundaries",
183
    }
184
185
    gid = Column(BigInteger, primary_key=True, index=True)
186
    ade = Column(BigInteger)
187
    gf = Column(BigInteger)
188
    bsg = Column(BigInteger)
189
    ars = Column(Text)
190
    ags = Column(Text)
191
    sdv_ars = Column(Text)
192
    gen = Column(Text)
193
    bez = Column(Text)
194
    ibz = Column(BigInteger)
195
    bem = Column(Text)
196
    nbd = Column(Text)
197
    sn_l = Column(Text)
198
    sn_r = Column(Text)
199
    sn_k = Column(Text)
200
    sn_v1 = Column(Text)
201
    sn_v2 = Column(Text)
202
    sn_g = Column(Text)
203
    fk_s3 = Column(Text)
204
    nuts = Column(Text)
205
    ars_0 = Column(Text)
206
    ags_0 = Column(Text)
207
    wsk = Column(Text)
208
    debkg_id = Column(Text)
209
    rs = Column(Text)
210
    sdv_rs = Column(Text)
211
    rs_0 = Column(Text)
212
    geometry = Column(Geometry(srid=4326), index=True)
213
214
215
t_vg250_lan_nuts_id = Table(
216
    "vg250_lan_nuts_id",
217
    metadata,
218
    Column("ags_0", Text),
219
    Column("gen", Text),
220
    Column("nuts", Text),
221
    Column("geometry", Geometry),
222
    schema="boundaries",
223
)
224
225
226
t_vg250_lan_union = Table(
227
    "vg250_lan_union",
228
    metadata,
229
    Column("ags_0", String(12), unique=True),
230
    Column("gen", Text),
231
    Column("geometry", Geometry("MULTIPOLYGON", 3035), index=True),
232
    schema="boundaries",
233
)
234
235
236 View Code Duplication
class Vg250Rbz(Base):
0 ignored issues
show
Duplication introduced by
This code seems to be duplicated in your project.
Loading history...
237
    __tablename__ = "vg250_rbz"
238
    __table_args__ = {
239
        "schema": "boundaries",
240
    }
241
242
    gid = Column(BigInteger, primary_key=True, index=True)
243
    ade = Column(BigInteger)
244
    gf = Column(BigInteger)
245
    bsg = Column(BigInteger)
246
    ars = Column(Text)
247
    ags = Column(Text)
248
    sdv_ars = Column(Text)
249
    gen = Column(Text)
250
    bez = Column(Text)
251
    ibz = Column(BigInteger)
252
    bem = Column(Text)
253
    nbd = Column(Text)
254
    sn_l = Column(Text)
255
    sn_r = Column(Text)
256
    sn_k = Column(Text)
257
    sn_v1 = Column(Text)
258
    sn_v2 = Column(Text)
259
    sn_g = Column(Text)
260
    fk_s3 = Column(Text)
261
    nuts = Column(Text)
262
    ars_0 = Column(Text)
263
    ags_0 = Column(Text)
264
    wsk = Column(Text)
265
    debkg_id = Column(Text)
266
    rs = Column(Text)
267
    sdv_rs = Column(Text)
268
    rs_0 = Column(Text)
269
    geometry = Column(Geometry(srid=4326), index=True)
270
271
272 View Code Duplication
class Vg250Sta(Base):
0 ignored issues
show
Duplication introduced by
This code seems to be duplicated in your project.
Loading history...
273
    __tablename__ = "vg250_sta"
274
    __table_args__ = {
275
        "schema": "boundaries",
276
    }
277
278
    gid = Column(BigInteger, primary_key=True, index=True)
279
    ade = Column(BigInteger)
280
    gf = Column(BigInteger)
281
    bsg = Column(BigInteger)
282
    ars = Column(Text)
283
    ags = Column(Text)
284
    sdv_ars = Column(Text)
285
    gen = Column(Text)
286
    bez = Column(Text)
287
    ibz = Column(BigInteger)
288
    bem = Column(Text)
289
    nbd = Column(Text)
290
    sn_l = Column(Text)
291
    sn_r = Column(Text)
292
    sn_k = Column(Text)
293
    sn_v1 = Column(Text)
294
    sn_v2 = Column(Text)
295
    sn_g = Column(Text)
296
    fk_s3 = Column(Text)
297
    nuts = Column(Text)
298
    ars_0 = Column(Text)
299
    ags_0 = Column(Text)
300
    wsk = Column(Text)
301
    debkg_id = Column(Text)
302
    rs = Column(Text)
303
    sdv_rs = Column(Text)
304
    rs_0 = Column(Text)
305
    geometry = Column(Geometry(srid=4326), index=True)
306
307
308
t_vg250_sta_bbox = Table(
309
    "vg250_sta_bbox",
310
    metadata,
311
    Column("gid", Integer, unique=True),
312
    Column("bez", Text),
313
    Column("area_ha", Float(53)),
314
    Column("geometry", Geometry("POLYGON", 3035), index=True),
315
    schema="boundaries",
316
)
317
318
319
t_vg250_sta_invalid_geometry = Table(
320
    "vg250_sta_invalid_geometry",
321
    metadata,
322
    Column("gid", BigInteger, unique=True),
323
    Column("error", Boolean),
324
    Column("error_reason", String),
325
    Column("geometry", Geometry("POINT", 3035), index=True),
326
    schema="boundaries",
327
)
328
329
330
t_vg250_sta_tiny_buffer = Table(
331
    "vg250_sta_tiny_buffer",
332
    metadata,
333
    Column("gid", Integer, unique=True),
334
    Column("bez", Text),
335
    Column("gf", Float(53)),
336
    Column("area_ha", Float(53)),
337
    Column("geometry", Geometry("MULTIPOLYGON", 3035), index=True),
338
    schema="boundaries",
339
)
340
341
342
t_vg250_sta_union = Table(
343
    "vg250_sta_union",
344
    metadata,
345
    Column("gid", Integer, unique=True),
346
    Column("bez", Text),
347
    Column("area_ha", Float(53)),
348
    Column("geometry", Geometry("MULTIPOLYGON", 3035), index=True),
349
    schema="boundaries",
350
)
351
352
353 View Code Duplication
class Vg250Vwg(Base):
0 ignored issues
show
Duplication introduced by
This code seems to be duplicated in your project.
Loading history...
354
    __tablename__ = "vg250_vwg"
355
    __table_args__ = {
356
        "schema": "boundaries",
357
    }
358
359
    gid = Column(BigInteger, primary_key=True, index=True)
360
    ade = Column(BigInteger)
361
    gf = Column(BigInteger)
362
    bsg = Column(BigInteger)
363
    ars = Column(Text)
364
    ags = Column(Text)
365
    sdv_ars = Column(Text)
366
    gen = Column(Text)
367
    bez = Column(Text)
368
    ibz = Column(BigInteger)
369
    bem = Column(Text)
370
    nbd = Column(Text)
371
    sn_l = Column(Text)
372
    sn_r = Column(Text)
373
    sn_k = Column(Text)
374
    sn_v1 = Column(Text)
375
    sn_v2 = Column(Text)
376
    sn_g = Column(Text)
377
    fk_s3 = Column(Text)
378
    nuts = Column(Text)
379
    ars_0 = Column(Text)
380
    ags_0 = Column(Text)
381
    wsk = Column(Text)
382
    debkg_id = Column(Text)
383
    rs = Column(Text)
384
    sdv_rs = Column(Text)
385
    rs_0 = Column(Text)
386
    geometry = Column(Geometry(srid=4326), index=True)
387