def test_createParking(self):
p = Parking()
self.assertEqual(p.places, [])
places = [Place(1, 300, 200, 500, 777), Place(2, 300, 129, 500, 999)]
p2 = Parking(places)
self.assertEqual(p2.places, places)
def test_estEnCours(self):
p2 = Place(1, 300, 200, 500, 788)
c = Client("PEREIRA",
"Alexandre", "4 Boulevard Koenings 31300 Toulouse", True,
Voiture(), 12363663, 144, "12/12/1212", p2, None)
pp = Placement("ID", p2, c, "date..", None)
self.assertEqual(pp.estEnCours, True)
def test_create_place(self):
p = Place(1, 300, 200, 500, 777)
self.assertEquals(p.id, 777)
self.assertEquals(p.niveau, 1)
self.assertEquals(p.hauteur, 300)
self.assertEquals(p.longueur, 200)
self.assertEquals(p.largeur, 500)
def test_recupererVehicule(self):
v1 = Voiture()
c1 = Client("PEREIRA", "Alexandre", "4 Boulevard Koenings 31300 Toulouse", True, v1, 12363663, 144, "12/12/1212", None, "W9V69Q27")
p2 = Place(1, 300, 200, 500, 778)
self.assertEqual(c1.recupererVehicule(), False)
Placement(None, p2, c1, "date..", None)
self.assertEqual(c1.recupererVehicule(), True)
def test_effectuerTache(self):
p2 = Place(1, 300, 200, 500, 788)
c = Client("PEREIRA",
"Alexandre", "4 Boulevard Koenings 31300 Toulouse", True,
Voiture(), 12363663, 144, "12/12/1212", p2, None)
pp = Placement("ID", p2, c, "date..", None)
s = Service(pp, None, 1, "Livraison")
s.effectuerTache()
self.assertNotEqual(s.dateF, None)
def test_get(self):
Placement.tous = []
p2 = Place(1, 300, 200, 500, 788)
c = Client("PEREIRA",
"Alexandre", "4 Boulevard Koenings 31300 Toulouse", True,
Voiture(), 12363663, 144, "12/12/1212", p2, None)
pp = Placement("ID", p2, c, "date..", None)
self.assertEqual(Placement.get("ID"), pp)
self.assertNotEqual(Placement.get("IDD"), pp)
def test_getServices(self):
p2 = Place(1, 300, 200, 500, 788)
c = Client("PEREIRA",
"Alexandre", "4 Boulevard Koenings 31300 Toulouse", True,
Voiture(), 12363663, 144, "12/12/1212", p2, None)
pp = Placement("ID", p2, c, "date..", None)
s1 = Service(pp, "26/10/2015", 1, "Livraison")
s2 = Service(pp, "28/10/2015", 2, "Livraison 2")
self.assertEqual(pp.getServices(), [s1, s2])
def test_nbPlaceOccupes(self):
Placement.tous = []
self.assertEqual(Placement.nbPlaceOccupes(), 0)
p2 = Place(1, 300, 200, 500, 788)
c = Client("PEREIRA",
"Alexandre", "4 Boulevard Koenings 31300 Toulouse", True,
Voiture(), 12363663, 144, "12/12/1212", p2, None)
Placement("ID", p2, c, "date..", None)
self.assertEqual(Placement.nbPlaceOccupes(), 1)
def test_creerService(self):
p2 = Place(1, 300, 200, 500, 788)
c = Client("PEREIRA",
"Alexandre", "4 Boulevard Koenings 31300 Toulouse", True,
Voiture(), 12363663, 144, "12/12/1212", p2, None)
pp = Placement("ID", p2, c, "date..", None)
s = Service(pp, "26/10/2015", 1, "Livraison")
self.assertEqual(s.dateF, "26/10/2015")
self.assertEqual(s.argument, "Livraison")
self.assertEqual(s.placement, pp)
self.assertEqual(s.typeService, 1)
def test_creer(self):
p2 = Place(1, 300, 200, 500, 788)
c = Client("PEREIRA",
"Alexandre", "4 Boulevard Koenings 31300 Toulouse", True,
Voiture(), 12363663, 144, "12/12/1212", p2, None)
pp = Placement("ID", p2, c, "date..", None)
self.assertEqual(pp.client, c)
self.assertEqual(pp.dateD, "date..")
self.assertEqual(pp.dateF, None)
self.assertEqual(pp.id, "ID")
self.assertEqual(pp.place, p2)
self.assertEqual(pp.services, [])
def test_getAvailablePlace(self):
Place.tous = []
p2 = Place(1, 300, 200, 500, 788)
c = Client("PEREIRA",
"Alexandre", "4 Boulevard Koenings 31300 Toulouse", True,
Voiture(), 12363663, 144, "12/12/1212", p2, None)
Placement(None, p2, c, "date..", None)
self.assertEqual(p2.isAvailable(), False)
v = Voiture("IMMAT", 100, 200, 40)
self.assertEqual(Place.getAvailablePlace(v), None)
p2 = Place(1, 300, 200, 500, 788)
self.assertNotEqual(Place.getAvailablePlace(v), None)
self.assertEqual(Place.getAvailablePlace(v), p2)
def test_isAvailable(self):
p = Place(1, 300, 200, 500, 777)
self.assertEqual(p.isAvailable(), True)
# la place a été réservé
c = Client("PEREIRA",
"Alexandre", "4 Boulevard Koenings 31300 Toulouse", True,
Voiture(), 12363663, 144, "12/12/1212", p, None)
self.assertEqual(p.isAvailable(), False)
p2 = Place(1, 300, 200, 500, 778)
Placement(None, p2, c, "date..", None)
self.assertEqual(p2.isAvailable(), False)
def loadAll():
"""
Cette méthode permet de charger la totalité des placements de la base de données dans l'aapplication.
Chaque placement vont alors être instancié.
"""
con = sqlite3.connect("test.db")
with con:
con.row_factory = sqlite3.Row
cur = con.cursor()
cur.execute("SELECT * FROM Placement")
rows = cur.fetchall()
for row in rows:
Placement(row["id"], Place.get(row["place"]), Client.get(row["client"]), row["dateD"], row["dateF"])
con.close()
def loadAll():
"""
Cette fonction permet de charger tous les clients qui sont dans la base de donnée.
Chaque client présent dans la base de données sont alors instancié.
"""
con = sqlite3.connect("test.db")
with con:
con.row_factory = sqlite3.Row
cur = con.cursor()
for row in cur.execute("""SELECT * FROM Client"""):
Client(row["nomClient"], row["prenomClient"], row["adrClient"],
True if (row["estAbonne"] == 1) else False,
Voiture.get(row["idVoiture"]), row["numCB"], row["cryptoVisuel"], row["dateExpiration"],
Place.get(row["placeReserve"]), row["numClient"])
con.close()
def loadAll():
"""
Cette fonction permet de charger tous les clients qui sont dans la base de donnée.
Chaque client présent dans la base de données sont alors instancié.
"""
con = sqlite3.connect("test.db")
with con:
con.row_factory = sqlite3.Row
cur = con.cursor()
for row in cur.execute("""SELECT * FROM Client"""):
Client(row["nomClient"], row["prenomClient"], row["adrClient"],
True if (row["estAbonne"] == 1) else False,
Voiture.get(row["idVoiture"]), row["numCB"],
row["cryptoVisuel"], row["dateExpiration"],
Place.get(row["placeReserve"]), row["numClient"])
con.close()
curseur.execute("""create table Service (placement int, dateFin date, typeService int, argument varchar(100))""")
conn.commit()
conn.close()
initTable()
# print("Création des Voitures...")
# v1 = Voiture()
# v2 = Voiture()
# Voiture.saveAll()
#
# print("Définition des Clients...")
# Client("PEREIRA", "Alexandre", "4 Boulevard Koenings 31300 Toulouse", True, v1, 12363663, 144, "12/12/1212", None)
# Client("PENCHENAT", "Matthieu", "2 Impasse Louis Tharaud 31300 Toulouse", False, v2, 12363669, 147, "12/12/1212", None)
# Client.saveAll()
for client in Client.tous:
print(client)
print("Définition des places de bases...", end="")
placeType = [[300,150,200],[150,200,300],[500,400,300]] # hauteur, largeur, longueur de 3 types de places
for i in range(0,20) :
choosenPlaceType = placeType[randint(0,2)]
Place(randint(1, 2), choosenPlaceType[0], choosenPlaceType[2], choosenPlaceType[1])
Place.saveAll()
for place in Place.tous:
print(place)
print("OK\n")
initTable()
# print("Création des Voitures...")
# v1 = Voiture()
# v2 = Voiture()
# Voiture.saveAll()
#
# print("Définition des Clients...")
# Client("PEREIRA", "Alexandre", "4 Boulevard Koenings 31300 Toulouse", True, v1, 12363663, 144, "12/12/1212", None)
# Client("PENCHENAT", "Matthieu", "2 Impasse Louis Tharaud 31300 Toulouse", False, v2, 12363669, 147, "12/12/1212", None)
# Client.saveAll()
for client in Client.tous:
print(client)
print("Définition des places de bases...", end="")
placeType = [[300, 150, 200], [150, 200, 300],
[500, 400,
300]] # hauteur, largeur, longueur de 3 types de places
for i in range(0, 20):
choosenPlaceType = placeType[randint(0, 2)]
Place(randint(1, 2), choosenPlaceType[0], choosenPlaceType[2],
choosenPlaceType[1])
Place.saveAll()
for place in Place.tous:
print(place)
print("OK\n")
def test_get(self):
p = Place(1, 300, 200, 500, 777)
self.assertEqual(Place.get(7797), None)
self.assertEqual(str(Place.get(777)), str(p))