def aps2sqldwCodeMigration()

in APS to SQL DW Migration - Schema and Data Migration with PolyBase/3_ChangeSchemas/ChangeSchemas.py [0:0]

• 15 lines of code
• 3 McCabe index (conditional complexity)

def aps2sqldwCodeMigration(srcDir, outDir, fileName, baseDbName, smMatrix):
    fi = open(os.path.join(srcDir, fileName), 'r') 
    fo = open(os.path.join(outDir, fileName), 'w') 
    for row in fi: 
        cmmRows.append(row)          
        for i in range (0,nSchemaRows):       
            apsDbName = smMatrix[i][0]
            apsSchema = smMatrix[i][1]
            SQLDWSchema = smMatrix[i][2]
            tempRow = replaceRow(cmmRows[i], baseDbName, apsDbName, apsSchema, SQLDWSchema) 
            cmmRows.append(tempRow)
        fo.write(cmmRows[nSchemaRows])  
        cmmRows.clear()   
    fi.close()
    fo.close()