View GitHub Repository st2contrib

Schedule Inspection
Subscribe
Completed
Pull Request — master (#610)
by
unknown
02:26
created

GetExcelVariablesAction.run()   A

↳ Parent: GetExcelVariablesAction

Complexity

Conditions 1

Size

Total Lines 9

Duplication

Lines 0
Ratio 0 %

Importance

Changes 4
Bugs 0 Features 0
Metric Value
cc 1
c 4
b 0
f 0
dl 0
loc 9
rs 9.6666
1 
"""
2 
Copyright 2016 Brocade Communications Systems, Inc.
3 
Licensed under the Apache License, Version 2.0 (the "License");
4 
you may not use this file except in compliance with the License.
5 
You may obtain a copy of the License at
6 
    http://www.apache.org/licenses/LICENSE-2.0
7 
Unless required by applicable law or agreed to in writing, software
8 
distributed under the License is distributed on an "AS IS" BASIS,
9 
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
10 
See the License for the specific language governing permissions and
11 
limitations under the License.
12 
"""
13 

            


            
                                                                                                            
                            
            
                                    
            
            

                
                    14
                

                                    
                                                    
                
                
                
from lib import excel_action, excel_reader

            


            
                                                                                                            
                            
            
                                    
            
            

                
                    15
                

                                    
                                                    
                
                
                
import json

            


            
                                                                                                            
                            
            
                                    
            
            

                
                    16
                

                                    
                                                    
                
                
                

            


            
                                                                                                            
                            
            
                                    
            
            

                
                    17
                

                                    
                                                    
                
                
                

            


            
                                                                                                            
                                                                
            
                                    
            
            

                
                    18
                

                                    
                                                    
                
                
                
class GetExcelVariablesAction(excel_action.ExcelAction):

            


            
                                                        
            
                                    
            
            

                
                    19
                

                                    
                                                    
                
                
                
    def run(self, sheet, key, variables, strict):

            


            
                                                        
            
                                    
            
            

                
                    20
                

                                    
                                                    
                
                
                
        data = json.loads(variables)

            


            
                                                        
            
                                    
            
            

                
                    21
                

                                    
                                                    
                
                
                
        excel = excel_reader.ExcelReader(self._excel_file, lock=True)

            


            
                                                        
            
                                    
            
            

                
                    22
                

                                    
                                                    
                
                
                
        excel.set_sheet(sheet, key_column=self._key_column,

            


            
                                                        
            
                                    
            
            

                
                    23
                

                                    
                                                    
                
                
                
                        var_name_row=self._var_name_row,

            


            
                                                        
            
                                    
            
            

                
                    24
                

                                    
                                                    
                
                
                
                        strict=strict)

            


            
                                                        
            
                                    
            
            

                
                    25
                

                                    
                                                    
                
                
                
        excel.set_values_for_variables(key, data)

            


            
                                                        
            
                                    
            
            

                
                    26
                

                                    
                                                    
                
                
                
        excel.save()

            


            
                                                        
            
                                    
            
            

                
                    27
                

                                    
                                                    
                
                
                
        return (True, 'Success')

            


            
                                                        
            
                                    
            
            

                
                    28