level1.py 9.15 KB
Newer Older
Wei Shoulin's avatar
Wei Shoulin committed
1
import os
Wei Shoulin's avatar
c3    
Wei Shoulin committed
2
import grpc
Wei Shoulin's avatar
Wei Shoulin committed
3
import datetime
Wei Shoulin's avatar
c3    
Wei Shoulin committed
4
5

from csst_dfs_commons.models import Result
Wei Shoulin's avatar
Wei Shoulin committed
6
from csst_dfs_commons.models.common import from_proto_model_list
Wei Shoulin's avatar
Wei Shoulin committed
7
from csst_dfs_commons.models.facility import Level1Record
Wei Shoulin's avatar
Wei Shoulin committed
8
from csst_dfs_commons.models.constants import UPLOAD_CHUNK_SIZE
Wei Shoulin's avatar
Wei Shoulin committed
9
from csst_dfs_proto.facility.level1 import level1_pb2, level1_pb2_grpc
Wei Shoulin's avatar
c3    
Wei Shoulin committed
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

from ..common.service import ServiceProxy
from ..common.utils import *

class Level1DataApi(object):
    """
    Level1 Data Operation Class
    """    
    def __init__(self):
        self.stub = level1_pb2_grpc.Level1SrvStub(ServiceProxy().channel())

    def find(self, **kwargs):
        ''' retrieve level1 records from database

        parameter kwargs:
Wei Shoulin's avatar
Wei Shoulin committed
25
            level0_id: [str]
Wei Shoulin's avatar
Wei Shoulin committed
26
            module_id: [str]
Wei Shoulin's avatar
c3    
Wei Shoulin committed
27
28
29
30
31
32
33
34
35
36
37
            data_type: [str]
            create_time : (start, end),
            qc1_status : [int],
            prc_status : [int],
            filename: [str]
            limit: limits returns the number of records,default 0:no-limit

        return: csst_dfs_common.models.Result
        '''
        try:
            resp, _ =  self.stub.Find.with_call(level1_pb2.FindLevel1Req(
Wei Shoulin's avatar
Wei Shoulin committed
38
                level0_id = get_parameter(kwargs, "level0_id"),
Wei Shoulin's avatar
Wei Shoulin committed
39
                module_id = get_parameter(kwargs, "module_id"),
Wei Shoulin's avatar
c3    
Wei Shoulin committed
40
41
42
                data_type = get_parameter(kwargs, "data_type"),
                create_time_start = get_parameter(kwargs, "create_time", [None, None])[0],
                create_time_end = get_parameter(kwargs, "create_time", [None, None])[1],
Wei Shoulin's avatar
status    
Wei Shoulin committed
43
44
                qc1_status = get_parameter(kwargs, "qc1_status", 1024),
                prc_status = get_parameter(kwargs, "prc_status", 1024),
Wei Shoulin's avatar
c3    
Wei Shoulin committed
45
46
                filename = get_parameter(kwargs, "filename"),
                limit = get_parameter(kwargs, "limit", 0),
Wei Shoulin's avatar
Wei Shoulin committed
47
                pipeline_id = get_parameter(kwargs, "pipeline_id", ""),
Wei Shoulin's avatar
Wei Shoulin committed
48
                detector_no = get_parameter(kwargs, "detector_no", ""),
Wei Shoulin's avatar
Wei Shoulin committed
49
                filter = get_parameter(kwargs, "filter", ""),
Wei Shoulin's avatar
Wei Shoulin committed
50
51
52
53
54
                other_conditions = {
                    "ra_cen": str(get_parameter(kwargs, "ra_cen", '')),
                    "dec_cen": str(get_parameter(kwargs, "dec_cen", '')),
                    "radius_cen": str(get_parameter(kwargs, "radius_cen", ''))
                }
Wei Shoulin's avatar
c3    
Wei Shoulin committed
55
56
57
            ),metadata = get_auth_headers())

            if resp.success:
Wei Shoulin's avatar
Wei Shoulin committed
58
                return Result.ok_data(data=from_proto_model_list(Level1Record, resp.records)).append("totalCount", resp.totalCount)
Wei Shoulin's avatar
c3    
Wei Shoulin committed
59
60
61
62
            else:
                return Result.error(message = str(resp.error.detail))

        except grpc.RpcError as e:
Wei Shoulin's avatar
Wei Shoulin committed
63
            return Result.error(message="%s:%s" % (e.code().value, e.details()))
Wei Shoulin's avatar
c3    
Wei Shoulin committed
64

Wei Shoulin's avatar
hstdm    
Wei Shoulin committed
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
    def find_by_brick_ids(self, **kwargs):
        ''' retrieve level1 records by brick_ids like [1,2,3,4]

        :param kwargs: Parameter dictionary, key items support:
            brick_ids: [list]

        return: csst_dfs_common.models.Result
        '''
        try:
            resp, _ =  self.stub.FindByBrickIds.with_call(level1_pb2.FindByBrickIdsReq(
                brick_ids = get_parameter(kwargs, "brick_ids", [])
            ),metadata = get_auth_headers())

            if resp.success:
                return Result.ok_data(data=from_proto_model_list(Level1Record, resp.records))
            else:
                return Result.error(message = str(resp.error.detail))

        except grpc.RpcError as e:
            return Result.error(message="%s:%s" % (e.code().value, e.details()))

Wei Shoulin's avatar
Wei Shoulin committed
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
    def sls_find_by_qc1_status(self, **kwargs):
        ''' retrieve level1 records from database

        parameter kwargs:
            qc1_status: [str]
            limit: limits returns the number of records,default 1

        return: csst_dfs_common.models.Result
        '''
        try:
            resp, _ =  self.stub.FindByQc1Status.with_call(level1_pb2.FindLevel1Req(
                level0_id = None,
                data_type = None,
                create_time_start = None,
                create_time_end = None,
Wei Shoulin's avatar
Wei Shoulin committed
101
                qc1_status = get_parameter(kwargs, "qc1_status", -1),
Wei Shoulin's avatar
Wei Shoulin committed
102
103
104
105
106
107
108
109
110
111
112
113
114
                prc_status = None,
                limit = get_parameter(kwargs, "limit", 1),
                other_conditions = {"orderBy":"create_time asc", "module_id": 'SLS'}
            ),metadata = get_auth_headers())

            if resp.success:
                return Result.ok_data(data=from_proto_model_list(Level1Record, resp.records)).append("totalCount", resp.totalCount)
            else:
                return Result.error(message = str(resp.error.detail))

        except grpc.RpcError as e:
            return Result.error(message="%s:%s" % (e.code().value, e.details()))

Wei Shoulin's avatar
c3    
Wei Shoulin committed
115
116
117
118
119
120
121
122
123
124
    def get(self, **kwargs):
        '''  fetch a record from database

        parameter kwargs:
            id : [int] 

        return csst_dfs_common.models.Result
        '''
        try:
            resp, _ =  self.stub.Get.with_call(level1_pb2.GetLevel1Req(
Wei Shoulin's avatar
Wei Shoulin committed
125
126
127
                id = get_parameter(kwargs, "id"),
                level0_id = get_parameter(kwargs, "level0_id"),
                data_type = get_parameter(kwargs, "data_type") 
Wei Shoulin's avatar
c3    
Wei Shoulin committed
128
129
            ),metadata = get_auth_headers())

Wei Shoulin's avatar
Wei Shoulin committed
130
            if resp.record is None or resp.record.id == 0:
Wei Shoulin's avatar
Wei Shoulin committed
131
                return Result.error(message=f"data not found")  
Wei Shoulin's avatar
c3    
Wei Shoulin committed
132

Wei Shoulin's avatar
Wei Shoulin committed
133
            return Result.ok_data(data = Level1Record().from_proto_model(resp.record))
Wei Shoulin's avatar
Wei Shoulin committed
134

Wei Shoulin's avatar
c3    
Wei Shoulin committed
135
        except grpc.RpcError as e:
Wei Shoulin's avatar
Wei Shoulin committed
136
            return Result.error(message="%s:%s" % (e.code().value, e.details()))   
Wei Shoulin's avatar
c3    
Wei Shoulin committed
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158

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

        parameter kwargs:
            id : [int],
            status : [int]

        return csst_dfs_common.models.Result
        '''
        fits_id = get_parameter(kwargs, "id")
        status = get_parameter(kwargs, "status")
        try:
            resp,_ = self.stub.UpdateProcStatus.with_call(
                level1_pb2.UpdateProcStatusReq(id=fits_id, status=status),
                metadata = get_auth_headers()
            )
            if resp.success:
                return Result.ok_data()
            else:
                return Result.error(message = str(resp.error.detail))
        except grpc.RpcError as e:
Wei Shoulin's avatar
Wei Shoulin committed
159
            return Result.error(message="%s:%s" % (e.code().value, e.details()))
Wei Shoulin's avatar
c3    
Wei Shoulin committed
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179

    def update_qc1_status(self, **kwargs):
        ''' update the status of QC0
        
        parameter kwargs:
            id : [int],
            status : [int]
        '''        
        fits_id = get_parameter(kwargs, "id")
        status = get_parameter(kwargs, "status")
        try:
            resp,_ = self.stub.UpdateQc1Status.with_call(
                level1_pb2.UpdateQc1StatusReq(id=fits_id, status=status),
                metadata = get_auth_headers()
            )
            if resp.success:
                return Result.ok_data()
            else:
                return Result.error(message = str(resp.error.detail))
        except grpc.RpcError as e:
Wei Shoulin's avatar
Wei Shoulin committed
180
            return Result.error(message="%s:%s" % (e.code().value, e.details()))
Wei Shoulin's avatar
c3    
Wei Shoulin committed
181
182
183

    def write(self, **kwargs):
        ''' insert a level1 record into database
Wei Shoulin's avatar
Wei Shoulin committed
184

Wei Shoulin's avatar
c3    
Wei Shoulin committed
185
        parameter kwargs:
Wei Shoulin's avatar
Wei Shoulin committed
186
            level0_id : [str]
Wei Shoulin's avatar
c3    
Wei Shoulin committed
187
188
189
190
191
192
193
194
            data_type : [str]
            cor_sci_id : [int]
            prc_params : [str]
            filename : [str]
            file_path : [str]            
            prc_status : [int]
            prc_time : [str]
            pipeline_id : [str]
Wei Shoulin's avatar
Wei Shoulin committed
195
            refs: [dict]
Wei Shoulin's avatar
c3    
Wei Shoulin committed
196
197
198
199
200
201

        return csst_dfs_common.models.Result
        '''   

        rec = level1_pb2.Level1Record(
            id = 0,
Wei Shoulin's avatar
Wei Shoulin committed
202
            level0_id = get_parameter(kwargs, "level0_id"),
Wei Shoulin's avatar
Wei Shoulin committed
203
            module_id = get_parameter(kwargs, "module_id", ''),
Wei Shoulin's avatar
c3    
Wei Shoulin committed
204
205
206
            data_type = get_parameter(kwargs, "data_type"),
            cor_sci_id = get_parameter(kwargs, "cor_sci_id"),
            prc_params = get_parameter(kwargs, "prc_params"),
Wei Shoulin's avatar
Wei Shoulin committed
207
208
            filename = get_parameter(kwargs, "filename", ""),
            file_path = get_parameter(kwargs, "file_path", ""),
Wei Shoulin's avatar
Wei Shoulin committed
209
            prc_status = get_parameter(kwargs, "prc_status", -1),
Wei Shoulin's avatar
Wei Shoulin committed
210
            prc_time = get_parameter(kwargs, "prc_time", format_datetime(datetime.now())),
Wei Shoulin's avatar
Wei Shoulin committed
211
212
            pipeline_id = get_parameter(kwargs, "pipeline_id"),
            refs = get_parameter(kwargs, "refs", {})
Wei Shoulin's avatar
c3    
Wei Shoulin committed
213
        )
Wei Shoulin's avatar
Wei Shoulin committed
214
215
216
217
218
219
220
        def stream(rec):
            with open(rec.file_path, 'rb') as f:
                while True:
                    data = f.read(UPLOAD_CHUNK_SIZE)
                    if not data:
                        break
                    yield level1_pb2.WriteLevel1Req(record = rec, data = data)
Wei Shoulin's avatar
c3    
Wei Shoulin committed
221
        try:
Wei Shoulin's avatar
Wei Shoulin committed
222
223
            if not rec.file_path:
                return Result.error(message="file_path is blank")
Wei Shoulin's avatar
Wei Shoulin committed
224
225
            if not os.path.exists(rec.file_path):
                return Result.error(message="the file [%s] not existed" % (rec.file_path, ))
Wei Shoulin's avatar
Wei Shoulin committed
226
227
228
            if not rec.filename:
                rec.filename = os.path.basename(rec.file_path)

Wei Shoulin's avatar
Wei Shoulin committed
229
            resp,_ = self.stub.Write.with_call(stream(rec),metadata = get_auth_headers())
Wei Shoulin's avatar
c3    
Wei Shoulin committed
230
            if resp.success:
Wei Shoulin's avatar
Wei Shoulin committed
231
                return Result.ok_data(data=Level1Record().from_proto_model(resp.record))
Wei Shoulin's avatar
c3    
Wei Shoulin committed
232
233
234
            else:
                return Result.error(message = str(resp.error.detail))
        except grpc.RpcError as e:
Wei Shoulin's avatar
Wei Shoulin committed
235
            return Result.error(message="%s:%s" % (e.code().value, e.details()))