from zstudentDAO import studentDAO

#create
latestid = studentDAO.create(('mark', 45))
# find by id
result = studentDAO.findByID(latestid)
print(result)

#update
studentDAO.update(('Fred', 21, latestid))
result = studentDAO.findByID(latestid)
print(result)

# get all
allStudents = studentDAO.getAll()
for student in allStudents:
    print(student)

# delete
studentDAO.delete(latestid)
Ejemplo n.º 2
0
from zstudentDAO import studentDAO

#create
latestid = studentDAO.create(('mark', 45))

#update
studentDAO.update(('Fred', 21, 13))
print("is this working")
result = studentDAO.findByID(latestid)
print(result)

#get all
allStudents = studentDAO.getAll()
for student in allStudents:
    print(student)

#delete
studentDAO.delete(latestid)
Ejemplo n.º 3
0
from zstudentDAO import studentDAO

# Test create
latestid = studentDAO.create(("Mark", 46))
print(latestid)

# Test find by id
result = studentDAO.findByID(latestid)
print(result)
print("----")

# Test update
studentDAO.update(("Rob", 6, latestid))
result = studentDAO.findByID(latestid)
print(result)
print("----")

# Test get all
allStudents = studentDAO.getAll()
for student in allStudents:
    print(student)

# Test delete
print("Want to delete row with id:", latestid)
studentDAO.delete(latestid)