Coverage for toardb/timeseries/models.py: 100%

1# SPDX-FileCopyrightText: 2021 Forschungszentrum Jülich GmbH 

2# SPDX-License-Identifier: MIT 

3 

4from .models_core import Timeseries 

5from .models_role import TimeseriesRole, timeseries_timeseries_roles_table 

6from .models_annotation import TimeseriesAnnotation, timeseries_timeseries_annotations_table 

7from .models_programme import TimeseriesProgramme 

8from .models_changelog import TimeseriesChangelog 

9from .models_contributor import s1_contributors_table 

10from toardb.base import Base 

11 

12from sqlalchemy import Table, Column, Integer, String 

13from sqlalchemy.ext.declarative import declarative_base 

14 

15# controlled vocabulary 

16 

17# Sampling Frequencies 

18SF_enum_table = Table("sf_vocabulary", 

19 Base.metadata, 

20 Column("enum_val", Integer, primary_key=True), 

21 Column("enum_str", String), 

22 Column("enum_display_str", String) 

23 ) 

24 

25# Aggregation Types 

26AT_enum_table = Table("at_vocabulary", 

27 Base.metadata, 

28 Column("enum_val", Integer, primary_key=True), 

29 Column("enum_str", String), 

30 Column("enum_display_str", String) 

31 ) 

32 

33# Data Origin Types 

34OT_enum_table = Table("ot_vocabulary", 

35 Base.metadata, 

36 Column("enum_val", Integer, primary_key=True), 

37 Column("enum_str", String), 

38 Column("enum_display_str", String) 

39 ) 

40 

41# Data Origins 

42DO_enum_table = Table("do_vocabulary", 

43 Base.metadata, 

44 Column("enum_val", Integer, primary_key=True), 

45 Column("enum_str", String), 

46 Column("enum_display_str", String) 

47 ) 

48