Best Python code snippet using Kiwi_python
product_master_table.py
Source:product_master_table.py  
1from SQL import MySQL_query23def product_master():4    product_master_data = []56    # EGR Cooler ì í7    master_dict = {}89    product_name = 'EGR_Cooler'10    product_code = 'EGRC'  # PK11    product_class = 'N01'12    product_num = 'P01'1314    product_target_l = 'op60_l_260'15    product_target_w = 'op60_w_180'16    product_target_h = 'op60_h_60'1718    master_dict['product_name'] = product_name19    master_dict['product_code'] = product_code  # PK20    master_dict['product_class'] = product_class21    master_dict['product_num'] = product_num22    master_dict['product_target_l'] = product_target_l23    master_dict['product_target_w'] = product_target_w24    master_dict['product_target_h'] = product_target_h2526    product_master_data.append(master_dict)272829    # op10 ë°ì í30    master_dict = {}3132    product_name = 'WIP10'33    product_code = 'op10_WIP'  # PK34    product_class = 'N02'35    product_num = 'WIP1'3637    product_target_l = 'op10_l_200'38    product_target_w = 'op10_w_100'39    product_target_h = 'op10_h_60'4041    master_dict['product_name'] = product_name42    master_dict['product_code'] = product_code  # PK43    master_dict['product_class'] = product_class44    master_dict['product_num'] = product_num4546    master_dict['product_target_l'] = product_target_l47    master_dict['product_target_w'] = product_target_w48    master_dict['product_target_h'] = product_target_h4950    product_master_data.append(master_dict)515253    # op20 ë°ì í54    master_dict = {}5556    product_name = 'WIP20'57    product_code = 'op20_WIP'  # PK58    product_class = 'N02'59    product_num = 'WIP2'6061    product_target_l = 'op20_l_200'62    product_target_w = 'op20_w_140'63    product_target_h = 'op20_h_60'6465    master_dict['product_name'] = product_name66    master_dict['product_code'] = product_code  # PK67    master_dict['product_class'] = product_class68    master_dict['product_num'] = product_num6970    master_dict['product_target_l'] = product_target_l71    master_dict['product_target_w'] = product_target_w72    master_dict['product_target_h'] = product_target_h7374    product_master_data.append(master_dict)757677    # op30 ë°ì í78    master_dict = {}7980    product_name = 'WIP30'81    product_code = 'op30_WIP'  # PK82    product_class = 'N02'83    product_num = 'WIP3'8485    product_target_l = 'op30_l_200'86    product_target_w = 'op30_w_180'87    product_target_h = 'op30_h_60'8889    master_dict['product_name'] = product_name90    master_dict['product_code'] = product_code  # PK91    master_dict['product_class'] = product_class92    master_dict['product_num'] = product_num9394    master_dict['product_target_l'] = product_target_l95    master_dict['product_target_w'] = product_target_w96    master_dict['product_target_h'] = product_target_h9798    product_master_data.append(master_dict)99100101    # op40 ë°ì í102    master_dict = {}103104    product_name = 'WIP40'105    product_code = 'op40_WIP'  # PK106    product_class = 'N02'107    product_num = 'WIP4'108109    product_target_l = 'op40_l_230'110    product_target_w = 'op40_w_180'111    product_target_h = 'op40_h_60'112113    master_dict['product_name'] = product_name114    master_dict['product_code'] = product_code  # PK115    master_dict['product_class'] = product_class116    master_dict['product_num'] = product_num117118    master_dict['product_target_l'] = product_target_l119    master_dict['product_target_w'] = product_target_w120    master_dict['product_target_h'] = product_target_h121122    product_master_data.append(master_dict)123124125    # op50 ë°ì í126    master_dict = {}127128    product_name = 'WIP50'129    product_code = 'op50_WIP'  # PK130    product_class = 'N02'131    product_num = 'WIP5'132133    product_target_l = 'op50_l_260'134    product_target_w = 'op50_w_180'135    product_target_h = 'op50_h_60'136137    master_dict['product_name'] = product_name138    master_dict['product_code'] = product_code  # PK139    master_dict['product_class'] = product_class140    master_dict['product_num'] = product_num141142    master_dict['product_target_l'] = product_target_l143    master_dict['product_target_w'] = product_target_w144    master_dict['product_target_h'] = product_target_h145146    product_master_data.append(master_dict)147148149    # body ë¶í150    master_dict = {}151152    product_name = 'body_part'153    product_code = 'body'  # PK154    product_class = 'N03'155    product_num = 'PART1'156157    product_target_l = 'body_l_200'158    product_target_w = 'body_w_100'159    product_target_h = 'body_h_50'160161    master_dict['product_name'] = product_name162    master_dict['product_code'] = product_code  # PK163    master_dict['product_class'] = product_class164    master_dict['product_num'] = product_num165166    master_dict['product_target_l'] = product_target_l167    master_dict['product_target_w'] = product_target_w168    master_dict['product_target_h'] = product_target_h169170    product_master_data.append(master_dict)171172173    # wavyfin ë¶í174    master_dict = {}175176    product_name = 'wavyfin_part'177    product_code = 'wavyfin'  # PK178    product_class = 'N03'179    product_num = 'PART2'180181    product_target_l = 'wavyfin_l_100'182    product_target_w = 'wavyfin_w_50'183    product_target_h = 'wavyfin_h_60'184185    master_dict['product_name'] = product_name186    master_dict['product_code'] = product_code  # PK187    master_dict['product_class'] = product_class188    master_dict['product_num'] = product_num189190    master_dict['product_target_l'] = product_target_l191    master_dict['product_target_w'] = product_target_w192    master_dict['product_target_h'] = product_target_h193194    product_master_data.append(master_dict)195196197    # pipe1 ë¶í198    master_dict = {}199200    product_name = 'pipe1_part'201    product_code = 'pipe1'  # PK202    product_class = 'N03'203    product_num = 'PART3'204205    product_target_l = 'pipe1_l_30'206    product_target_w = 'pipe1_w_50'207    product_target_h = 'pipe1_h_30'208209    master_dict['product_name'] = product_name210    master_dict['product_code'] = product_code  # PK211    master_dict['product_class'] = product_class212    master_dict['product_num'] = product_num213214    master_dict['product_target_l'] = product_target_l215    master_dict['product_target_w'] = product_target_w216    master_dict['product_target_h'] = product_target_h217218    product_master_data.append(master_dict)219220    # pipe2 ë¶í221    master_dict = {}222223    product_name = 'pipe2_part'224    product_code = 'pipe2'  # PK225    product_class = 'N03'226    product_num = 'PART4'227228    product_target_l = 'pipe2_l_30'229    product_target_w = 'pipe2_w_50'230    product_target_h = 'pipe2_h_30'231232    master_dict['product_name'] = product_name233    master_dict['product_code'] = product_code  # PK234    master_dict['product_class'] = product_class235    master_dict['product_num'] = product_num236237    master_dict['product_target_l'] = product_target_l238    master_dict['product_target_w'] = product_target_w239    master_dict['product_target_h'] = product_target_h240241    product_master_data.append(master_dict)242243244    # flange1 ë¶í245    master_dict = {}246247    product_name = 'flange1_part'248    product_code = 'flange1'  # PK249    product_class = 'N03'250    product_num = 'PART5'251252    product_target_l = 'flange1_l_30'253    product_target_w = 'flange1_w_50'254    product_target_h = 'flange1_h_30'255256    master_dict['product_name'] = product_name257    master_dict['product_code'] = product_code  # PK258    master_dict['product_class'] = product_class259    master_dict['product_num'] = product_num260261    master_dict['product_target_l'] = product_target_l262    master_dict['product_target_w'] = product_target_w263    master_dict['product_target_h'] = product_target_h264265    product_master_data.append(master_dict)266267268    # flange2 ë¶í269    master_dict = {}270271    product_name = 'flange2_part'272    product_code = 'flange2'  # PK273    product_class = 'N03'274    product_num = 'PART6'275276    product_target_l = 'flange2_l_30'277    product_target_w = 'flange2_w_50'278    product_target_h = 'flange2_h_30'279280    master_dict['product_name'] = product_name281    master_dict['product_code'] = product_code  # PK282    master_dict['product_class'] = product_class283    master_dict['product_num'] = product_num284285    master_dict['product_target_l'] = product_target_l286    master_dict['product_target_w'] = product_target_w287    master_dict['product_target_h'] = product_target_h288289    product_master_data.append(master_dict)290291    MySQL_query.insert_product_master(product_master_data)292
...test.gyp
Source:test.gyp  
1# Copyright (c) 2012 Google Inc. All rights reserved.2# Use of this source code is governed by a BSD-style license that can be3# found in the LICENSE file.4{5  'targets': [6    {7      'target_name': 'test_app',8      'product_name': 'Test',9      'type': 'executable',10      'mac_bundle': 1,11      'sources': [12        'main.c',13        'file.ext1',14        'file.ext2',15        'file.ext3',16      ],17      # Env vars in copies.18      'copies': [19        {20          'destination': '<(PRODUCT_DIR)/${PRODUCT_NAME}-copy-brace',21          'files': [ 'main.c', ],  # ${SOURCE_ROOT} doesn't work with xcode22        },23        {24          'destination': '<(PRODUCT_DIR)/$(PRODUCT_NAME)-copy-paren',25          'files': [ '$(SOURCE_ROOT)/main.c', ],26        },27        {28          'destination': '<(PRODUCT_DIR)/$PRODUCT_NAME-copy-bare',29          'files': [ 'main.c', ],  # $SOURCE_ROOT doesn't work with xcode30        },31      ],32      # Env vars in actions. The $FOO's are here to test that env vars that33      # aren't defined are handled in some way that doesn't break the build.34      'actions': [35        {36          'action_name': 'Action copy braces ${PRODUCT_NAME} ${FOO}',37          'description': 'Action copy braces ${PRODUCT_NAME} ${FOO}',38          'inputs': [ '${SOURCE_ROOT}/main.c' ],39          # Referencing ${PRODUCT_NAME} in action outputs doesn't work with40          # the Xcode generator (PRODUCT_NAME expands to "Test Support").41          'outputs': [ '<(PRODUCT_DIR)/action-copy-brace.txt' ],42          'action': [ 'cp', '${SOURCE_ROOT}/main.c',43                      '<(PRODUCT_DIR)/action-copy-brace.txt' ],44        },45        {46          'action_name': 'Action copy parens $(PRODUCT_NAME) $(FOO)',47          'description': 'Action copy parens $(PRODUCT_NAME) $(FOO)',48          'inputs': [ '$(SOURCE_ROOT)/main.c' ],49          # Referencing $(PRODUCT_NAME) in action outputs doesn't work with50          # the Xcode generator (PRODUCT_NAME expands to "Test Support").51          'outputs': [ '<(PRODUCT_DIR)/action-copy-paren.txt' ],52          'action': [ 'cp', '$(SOURCE_ROOT)/main.c',53                      '<(PRODUCT_DIR)/action-copy-paren.txt' ],54        },55        {56          'action_name': 'Action copy bare $PRODUCT_NAME $FOO',57          'description': 'Action copy bare $PRODUCT_NAME $FOO',58          'inputs': [ '$SOURCE_ROOT/main.c' ],59          # Referencing $PRODUCT_NAME in action outputs doesn't work with60          # the Xcode generator (PRODUCT_NAME expands to "Test Support").61          'outputs': [ '<(PRODUCT_DIR)/action-copy-bare.txt' ],62          'action': [ 'cp', '$SOURCE_ROOT/main.c',63                      '<(PRODUCT_DIR)/action-copy-bare.txt' ],64        },65      ],66      # Env vars in xcode_settings.67      'xcode_settings': {68        'INFOPLIST_FILE': 'Info.plist',69        'STRING_KEY': '/Source/Project',70        'BRACE_DEPENDENT_KEY2': '${STRING_KEY}/${PRODUCT_NAME}',71        'BRACE_DEPENDENT_KEY1': 'D:${BRACE_DEPENDENT_KEY2}',72        'BRACE_DEPENDENT_KEY3': '${PRODUCT_TYPE}:${BRACE_DEPENDENT_KEY1}',73        'PAREN_DEPENDENT_KEY2': '$(STRING_KEY)/$(PRODUCT_NAME)',74        'PAREN_DEPENDENT_KEY1': 'D:$(PAREN_DEPENDENT_KEY2)',75        'PAREN_DEPENDENT_KEY3': '$(PRODUCT_TYPE):$(PAREN_DEPENDENT_KEY1)',76        'BARE_DEPENDENT_KEY2': '$STRING_KEY/$PRODUCT_NAME',77        'BARE_DEPENDENT_KEY1': 'D:$BARE_DEPENDENT_KEY2',78        'BARE_DEPENDENT_KEY3': '$PRODUCT_TYPE:$BARE_DEPENDENT_KEY1',79        'MIXED_DEPENDENT_KEY': '${STRING_KEY}:$(PRODUCT_NAME):$MACH_O_TYPE',80      },81      # Env vars in rules. The $FOO's are here to test that env vars that82      # aren't defined are handled in some way that doesn't break the build.83      'rules': [84        {85          'rule_name': 'brace_rule',86          'message': 'Rule braces ${PRODUCT_NAME} ${FOO} <(RULE_INPUT_NAME)',87          'extension': 'ext1',88          'inputs': [ '${SOURCE_ROOT}/main.c' ],89          'outputs': [ '<(PRODUCT_DIR)/rule-copy-brace.txt' ],90          'action': [ 'cp', '${SOURCE_ROOT}/main.c',91                      '<(PRODUCT_DIR)/rule-copy-brace.txt' ],92        },93        {94          'rule_name': 'paren_rule',95          'message': 'Rule parens $(PRODUCT_NAME) $(FOO) <(RULE_INPUT_NAME)',96          'extension': 'ext2',97          'inputs': [ '$(SOURCE_ROOT)/main.c' ],98          'outputs': [ '<(PRODUCT_DIR)/rule-copy-paren.txt' ],99          'action': [ 'cp', '$(SOURCE_ROOT)/main.c',100                      '<(PRODUCT_DIR)/rule-copy-paren.txt' ],101        },102        # TODO: Fails in xcode. Looks like a bug in the xcode generator though103        #       (which uses makefiles for rules, and thinks $PRODUCT_NAME is104        #       $(P)RODUCT_NAME).105        #{106        #  'rule_name': 'bare_rule',107        #  'message': 'Rule copy bare $PRODUCT_NAME $FOO',108        #  'extension': 'ext3',109        #  'inputs': [ '$SOURCE_ROOT/main.c' ],110        #  'outputs': [ '<(PRODUCT_DIR)/rule-copy-bare.txt' ],111        #  'action': [ 'cp', '$SOURCE_ROOT/main.c',112        #              '<(PRODUCT_DIR)/rule-copy-bare.txt' ],113        #},114      ],115    },116  ],...Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.
You could also refer to video tutorials over LambdaTest YouTube channel to get step by step demonstration from industry experts.
Get 100 minutes of automation test minutes FREE!!
