class SheetEmpty(unittest.TestCase):
sheet = Sheets.Sheet("Lockonia_User_Sheet", 0)
def setUp(self):
self.sheet.resize(1, 0)
def tearDown(self):
self.sheet.resize(1, 0)
def testContains(self):
self.assertFalse(self.sheet.contains(""))
self.assertFalse(self.sheet.contains("a"))
self.assertFalse(self.sheet.contains("Many"))
def testGetRow(self):
self.assertIsNone(self.sheet.get_row(""))
self.assertIsNone(self.sheet.get_row("a"))
self.assertIsNone(self.sheet.get_row("Many"))
def testAddRow(self):
self.sheet.add_row(usersLite[0])
self.assertTrue(self.sheet.contains("Harry"))
self.assertTrue(self.sheet.contains("hxp1"))
self.assertTrue(self.sheet.contains("urawizard"))
self.assertTrue(self.sheet.contains("*****@*****.**"))
self.assertFalse(self.sheet.contains(""))
self.assertFalse(self.sheet.contains("harry"))
def click_pick_up():
# Calls the function FaceRec() file from Sheets.py
root3.destroy()
name = Sheets.FaceRec()
testguirandom.finalScreenPickUp(name)
import User
import Sheets
users = Sheets.UserSheet('Lockonia_User_Sheet', 0)
cameras = Sheets.CameraSheet('Lockonia_Cameras_Sheet', 0)
#User_Sheet Interactions
def create_new_user():
''' Accept multiple inputs, create a User, and add it to the User_Sheet. '''
print('Creating new user.')
name = input("Enter user's first and last names: ")
caseID = input('Enter case id: ')
allowed_cameras = input('Enter maximum number of allowed cameras: ')
cardID = input('Tap card OR enter card number: ')
email = caseID + '@case.edu'
new_user = User.User(name, caseID, cardID, email, allowed_cameras, ' ')
# try:
users.add_user(new_user)
return True
# except:
# print('Creation of new user failed!')
# return False
def remove_user():
''' Remove a user from the user sheet. '''
print('Removing user')
def click_drop_off():
# Calls the function FaceRec() file from Sheets.py
name = Sheets.FaceRec()
testguirandom.finalScreenDropOff(name)
def main():
import Sheets
from IvCalc import IvCalculator as calculator
species, level, iv, cp, hp, tier, best, good = Sheets.main()
dust = []
first = []
second = []
iv_calc = []
for i in level:
i = float(i)
if i <= 2.5:
dust.append(1)
elif i <= 4.5:
dust.append(2)
elif i <= 6.5:
dust.append(3)
elif i <= 8.5:
dust.append(4)
elif i <= 10.5:
dust.append(5)
elif i <= 12.5:
dust.append(6)
elif i <= 14.5:
dust.append(7)
elif i <= 16.5:
dust.append(8)
elif i <= 18.5:
dust.append(9)
elif i <= 20.5:
dust.append(10)
elif i <= 22.5:
dust.append(11)
elif i <= 24.5:
dust.append(12)
elif i <= 26.5:
dust.append(13)
elif i <= 28.5:
dust.append(14)
elif i <= 30.5:
dust.append(15)
elif i <= 32.5:
dust.append(16)
elif i <= 34.5:
dust.append(17)
elif i <= 36.5:
dust.append(18)
elif i <= 38.5:
dust.append(19)
elif i <= 39.5:
dust.append(20)
else:
dust.append(0)
for i in tier:
if i == "Not likely/May not be great/Room for improvement":
first.append(0)
elif i == "Above average/Decent/Pretty decent":
first.append(1)
elif i == "Certainly caught/Strong/Really strong":
first.append(2)
else:
first.append(3)
for i in good:
if i == "Not out of the norm/Don't point to greatness/Kinda basic":
second.append(0)
elif i == "Noticeably trending/Get the job done/Good stats":
second.append(1)
elif i == "Certainly impressed/Excellent stats/Really strong":
second.append(2)
elif i == "Exceed calculations/Blown away/Best I've ever seen":
second.append(3)
i = 0
while i <= len(species):
try:
if best[i] == "HP":
cal = calculator(species[i], [cp[i], hp[i], dust[i], False],
(first, second, False, False, True))
calc = cal.calc()
iv_calc.append(calc)
elif best[i] == "Attack":
cal = calculator(species[i], [cp[i], hp[i], dust[i], False],
(first, second, True, False, False))
calc = cal.calc()
iv_calc.append(calc)
elif best[i] == "Defense":
cal = calculator(species[i], [cp[i], hp[i], dust[i], False],
(first, second, False, True, False))
calc = cal.calc()
iv_calc.append(calc)
elif best[i] == "HP, Attack":
cal = calculator(species[i], [cp[i], hp[i], dust[i], False],
(first, second, True, False, True))
calc = cal.calc()
iv_calc.append(calc)
except:
if best[i] == "HP":
cal = calculator(species[i], [cp[i], hp[i], dust[i], False],
(first, second, False, False, True))
calc = cal.calc()
iv_calc.append(calc)
elif best[i] == "Attack":
cal = calculator(species[i], [cp[i], hp[i], dust[i], False],
(first, second, True, False, False))
calc = cal.calc()
iv_calc.append(calc)
elif best[i] == "Defense":
cal = calculator(species[i], [cp[i], hp[i], dust[i], False],
(first, second, False, True, False))
calc = cal.calc()
iv_calc.append(calc)
elif best[i] == "HP, Attack":
cal = calculator(species[i], [cp[i], hp[i], dust[i], False],
(first, second, True, False, True))
calc = cal.calc()
iv_calc.append(calc)
print(iv_calc[i])
i += 1
PurchasesID = '14WmsBbl2sbo0ctoGiPPR3Pom-h4PisZz'
DocID = "1OVgaYiZkLOOzfYxjhm1pf3O2Rm3SsxYViYg7JIHQjco"
TestID = "17hOXCgzzCd-dE6CXHbf2U-ltyjrbT8MyN05g0zDU-aQ"
url = "http://127.0.0.1:8000/uploads/inventory/"
#url = "http://blasterhackers.com/uploads/components/"
inventoryURL = "http://blasterhackers.com/uploads/inventory/"
SHEET_ID = '1boZJT_4ePXHZBbRs2_LLiUvZl-F6qZm8SDOkOMsPEAg'
BigDocID = "1hczIuBEJMP3E4vvdV91h87LrBtnE-w-xUUXqDqPALnc"
purchases2018ID = '1O7ZQ5BRnesuut6zHC1TwllNJIXXihq0b'
purchases2019ID = '1YvRyPvyZe4nIKireP68Nz5QhWL4dYnbu'
u = Uploader.Uploader(url)
d = Drive.Service()
h = HTMLParser()
s = Sheets.Service()
def main():
# h.parseDoc("samples/Test File.html")
title = d.getDocHTML(BigDocID)
# data = HTML_Editor.parseDoc(title)
docs = d.getChilds(PurchasesID)
# updateContent(WebContentID)
# s = Sheets.Service()
def individualTest():
file_name = d.getDocHTML("1bgD38YbS3znMUDBJpgLFQ1hTg8VnTjNehmZkh0JZiCM")
content = HTML_Editor.parseDoc("doc_html/Dream Orb")
for c in content:
u.sendData(url, c)
def getSheetsCollection(self):
return Sheets()
def click_drop_off():
# Calls the function FaceRec() file from Sheets.py
name = Sheets.FaceRec()
FinalPage.finalScreenDropOff(name)
class SheetPopulated(unittest.TestCase):
sheet = Sheets.Sheet("Lockonia_User_Sheet", 0)
def setUp(self):
for user in usersLite:
self.sheet.add_row(user)
def tearDown(self):
self.sheet.resize(1, 0)
def testContains(self):
self.assertTrue(self.sheet.contains("Harry"))
self.assertTrue(self.sheet.contains("hxp1"))
self.assertTrue(self.sheet.contains("*****@*****.**"))
self.assertTrue(self.sheet.contains("Barry"))
self.assertTrue(self.sheet.contains("no"))
self.assertTrue(self.sheet.contains("*****@*****.**"))
self.assertTrue(self.sheet.contains("Bork"))
self.assertTrue(self.sheet.contains("bor6"))
self.assertTrue(self.sheet.contains("*****@*****.**"))
self.assertFalse(self.sheet.contains(""))
self.assertFalse(self.sheet.contains("notInList"))
self.assertFalse(self.sheet.contains("harry"))
def testGetRow(self):
self.assertEqual(2, self.sheet.get_row_number("Harry"))
self.assertEqual(2, self.sheet.get_row_number("hxp1"))
self.assertEqual(2, self.sheet.get_row_number("*****@*****.**"))
self.assertEqual(3, self.sheet.get_row_number("Barry"))
self.assertEqual(3, self.sheet.get_row_number("no"))
self.assertEqual(3, self.sheet.get_row_number("*****@*****.**"))
self.assertEqual(4, self.sheet.get_row_number("Bork"))
self.assertEqual(4, self.sheet.get_row_number("bor6"))
self.assertEqual(4, self.sheet.get_row_number("*****@*****.**"))
self.assertEqual(usersLite[0], self.sheet.get_row("Harry"))
self.assertEqual(usersLite[0], self.sheet.get_row("hxp1"))
self.assertEqual(usersLite[0],
self.sheet.get_row("*****@*****.**"))
self.assertEqual(usersLite[1], self.sheet.get_row("Barry"))
self.assertEqual(usersLite[1], self.sheet.get_row("no"))
self.assertEqual(usersLite[1],
self.sheet.get_row("*****@*****.**"))
self.assertEqual(usersLite[2], self.sheet.get_row("Bork"))
self.assertEqual(usersLite[2], self.sheet.get_row("bor6"))
self.assertEqual(usersLite[2], self.sheet.get_row("*****@*****.**"))
def testAddRow(self):
self.sheet.add_row(users[3])
self.assertTrue(self.sheet.contains("Mr. Bantuski"))
self.assertTrue(self.sheet.contains("axb34"))
self.assertTrue(self.sheet.contains("none"))
def testRemoveRow(self):
self.assertFalse(self.sheet.remove_row("notInList"))
self.sheet.remove_row("Barry")
self.assertFalse(self.sheet.contains("Barry"))
self.assertFalse(self.sheet.contains("no"))
self.assertFalse(self.sheet.contains("*****@*****.**"))
self.assertTrue(self.sheet.contains("Harry"))
self.assertTrue(self.sheet.contains("Bork"))
self.assertEqual(3, self.sheet.get_row_number("Bork"))
self.sheet.remove_row("Bork")
self.assertFalse(self.sheet.contains("Bork"))
self.assertFalse(self.sheet.contains("bor6"))
self.assertFalse(self.sheet.contains("*****@*****.**"))
self.assertFalse(self.sheet.contains("Barry"))
self.assertTrue(self.sheet.contains("Harry"))
self.assertEqual(2, self.sheet.get_row_number("Harry"))
self.sheet.remove_row("Harry")
self.assertFalse(self.sheet.contains("Harry"))
self.assertFalse(self.sheet.contains("hxp1"))
self.assertFalse(self.sheet.contains("*****@*****.**"))
self.assertFalse(self.sheet.contains("Barry"))
self.assertFalse(self.sheet.contains("Bork"))