예제 #1
0
파일: testfile.py 프로젝트: aytsai/teamwait
def test_methods(arg):
    if  arg == "dbfill": 
      import testdbinfo 
      testdbinfo.populate_db()
    elif arg == "acc":
      from LOG import accountAccess
      accountAccess.setAccess('vall', '6')
      accountAccess.setAccess('vall', '10')
      accountAccess.setAccess('vall', '20')
    
    elif arg == "getacc":
      from LOG import accountAccess
      array = accountAccess.getAccess('vall')
      work = array.split(',')
      print work
    
    elif arg == "delacc":
      from LOG import accountAccess
      accountAccess.removeAcess('vall', '20')
    elif arg == "addGlasses":
      from INV import addGlasses
      from LOG import insertRegions
      from MAP import addMapAcc
      insertRegions.insertIntoDb("../teamwait/LOG/regionData.csv")
      addMapAcc.insertIntoDb("../teamwait/MAP/MapAccounts.csv", False)
      addGlasses.addGlasses(Maps.objects.get(account_num = 2),2,45,'g','Francis','Clr',42,21,'CC','NA')
      addGlasses.addGlasses(Maps.objects.get(account_num = 1),1,45,'g','Francis','Clr',42,21,'CC','NA')
      addGlasses.addGlasses(Maps.objects.get(account_num = 1),2,44,'ng','Francis','Clr',42,22,'CC','NA')

    elif arg == "deleteGlasses":
      from INV import deleteGlasses
      deleteGlasses.deleteGlasses(1,1)
    
    elif arg == "addItemToMap":
        from INV import addItemToMap
        from LOG import insertRegions
        from MAP import addMapAcc
        insertRegions.insertIntoDb("../teamwait/LOG/regionData.csv")
        addMapAcc.insertIntoDb("../teamwait/MAP/MapAccounts.csv", False)
        addItemToMap.addItemToMap(-1,"SampleGlassesInv.csv")

    elif arg == "deleteItemFromMap":
        from INV import deleteItemFromMap
        from LOG import insertRegions
        from MAP import addMapAcc
        insertRegions.insertIntoDb("../teamwait/LOG/regionData.csv")
        addMapAcc.insertIntoDb("../teamwait/MAP/MapAccounts.csv", False)
        deleteItemFromMap.deleteItemFromMap(1,"sample.csv")
            
   # elif arg == "addMap"
        #addMap test code here
    
    elif arg == "modifyItemStatus":
        from INV import modifyItemStatus
        modifyItemStatus.modifyItemStatus(1, 1, "reorder")
    
    elif arg == "exportToCSV":
      from INV import exportToCSV
      import os
      exportToCSV.exportToCSV('val')

    elif arg == "InitializeToUnsold":
      from INV import changeStatus
      changeStatus.initializeToUnsold(1)

    elif arg == "changeStatus":
      from INV import changeStatus
      changeStatus.changeStatus(1,1,23,"sold")
	  
    elif arg == "addDateOfSale":
      from INV import addDateOfSale
      addDateOfSale.addDateOfSale(1,1,23,'2003-12-12')
	  
    elif arg == "retailerAddRegNum":
      from INV import retailerRegNum
      retailerRegNum.rAddRegNum(2, 1, 1234)
      retailerRegNum.rAddRegNum(1, 1, 1234)
      print 'There should be an error above about duplicate reg numbers'
	  
    elif arg == "retailerEditRegNum":
      from INV import retailerRegNum
      retailerRegNum.rAddRegNum(1, 1, 9876)
      retailerRegNum.rEditRegNum(1,1,9876,80085)
      retailerRegNum.rEditRegNum(1,1,1111111,80085)
      print 'There should be an error in the console above this about incorrect reg number'
예제 #2
0
파일: views.py 프로젝트: aytsai/teamwait
def exCSV (request):
    fileName = exportToCSV(request.user.username)
    response = HttpResponse(FileWrapper(file(fileName)), mimetype='text/csv')
    response['Content-Disposition'] = 'attachment; filename='+fileName
    return response