level2.py 3.9 KB
Newer Older
Wei Shoulin's avatar
Wei Shoulin committed
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

from ..common.delegate import Delegate
from astropy.table import Table

class Level2DataApi(object):
    """
    Level2 Data Operation Class
    """
    def __init__(self):
        self.pymodule = Delegate().load(sub_module = "facility")
        self.stub = getattr(self.pymodule, "Level2DataApi")()
        
    def find(self, **kwargs):
        ''' retrieve level2 records from database

        :param kwargs: Parameter dictionary, key items support:
            level0_id: [str]
            level1_id: [int]
            module_id: [str]
            brick_id: [int]
            data_type: [str]
Wei Shoulin's avatar
Wei Shoulin committed
22
            object_name: [str]
Wei Shoulin's avatar
Wei Shoulin committed
23
24
25
26
            create_time : (start, end),
            qc2_status : [int],
            prc_status : [int],
            import_status : [int],
Wei Shoulin's avatar
Wei Shoulin committed
27
28
29
            filename: [str],
            build_id : [int],
            pipeline_id: [str],      
Wei Shoulin's avatar
Wei Shoulin committed
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
            limit: limits returns the number of records,default 0:no-limit
        
        :returns: csst_dfs_common.models.Result
        '''
        return self.stub.find(**kwargs)

    def catalog_query(self, **kwargs):
        ''' retrieve level2 catalog

        :param kwargs: Parameter dictionary, key items support:
            sql: [str]
            limit: limits returns the number of records,default 0:no-limit
        
        :returns: csst_dfs_common.models.Result
        '''
        return self.stub.catalog_query(**kwargs)
46
47
48
49
50
51
52
53
54
55
56
57
58
    
    def coord_cond_sql(self, **kwargs):
        ''' generate coordinate search condition sql

        :param kwargs: Parameter dictionary, key items support:
            data_type: [str]
            ra: [float]
            dec: [float]
            radius: [float]
        
        :returns: csst_dfs_common.models.Result
        '''
        return self.stub.coord_cond_sql(**kwargs)    
Wei Shoulin's avatar
Wei Shoulin committed
59

Wei Shoulin's avatar
Wei Shoulin committed
60
61
62
63
64
65
66
67
68
69
70
    def catalog_columns(self, **kwargs):
        ''' retrieve columns data type

        :param kwargs: Parameter dictionary, key items support:
            data_type: [str]
            columns: [list], list of str
        
        :returns: csst_dfs_common.models.Result
        '''
        return self.stub.catalog_columns(**kwargs)  

Wei Shoulin's avatar
Wei Shoulin committed
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
    def find_existed_brick_ids(self, **kwargs):
        '''  retrieve existed brick_ids in the catalog with data_type
        :param kwargs: 
            data_type: [str]
        :returns: csst_dfs_common.models.Result
        '''
        return self.stub.find_existed_brick_ids(**kwargs)    
    
    def get(self, **kwargs):
        '''  fetch a record from database

        :param kwargs: Parameter dictionary, key items support:
            id : [int] 
        
        :returns: csst_dfs_common.models.Result
        '''
        return self.stub.get(**kwargs)


    def update_proc_status(self, **kwargs):
        ''' update the status of reduction

        :param kwargs: Parameter dictionary, key items support:
            id = [int],
            status = [int]
        
        :returns: csst_dfs_common.models.Result
        '''
        return self.stub.update_proc_status(**kwargs)

    def update_qc2_status(self, **kwargs):
        ''' update the status of QC2
        
        :param kwargs: Parameter dictionary, key items support:
            id = [int],
            status = [int]
        
        :returns: csst_dfs_common.models.Result
        '''        
        return self.stub.update_qc2_status(**kwargs)    

    def write(self, **kwargs):
        ''' insert a level2 record into database

        :param kwargs: Parameter dictionary, key items support:
Wei Shoulin's avatar
Wei Shoulin committed
116
117
            level0_id : [str] optional
            level1_id: [int] optional
Wei Shoulin's avatar
Wei Shoulin committed
118
119
120
121
122
123
124
125
126
127
128
129
130
            brick_id: [int]
            module_id : [str]
            object_name: [str]
            data_type : [str]
            filename : [str]
            file_path : [str]            
            prc_status : [int]
            prc_time : [str]
            pipeline_id : [str]
        
        :returns: csst_dfs_common.models.Result
        '''          
        return self.stub.write(**kwargs)