Esempio n. 1
0
					print school
			elif sys.argv[2] == 'batch':
				for batch in Batch.select():
					print batch
			elif sys.argv[2] == 'user':
				for user in User.select():
					print user
			elif sys.argv[2] == 'student':
				for student in Student.select():
					print student
			elif sys.argv[2] == 'exercise':
				for exercise in Exercise.select():
					print exercise					
	elif sys.argv[1] == 'insert':
		if sys.argv[2] == 'school':
			school = School.insert(name=sys.argv[3]).execute()
			print "New school: " + str(School.select().where(School.id==school).get())
		elif sys.argv[2] == 'batch':
			batch = Batch.insert(school=sys.argv[3], name=sys.argv[4]).execute()
			print "New batch: "	+ str(Batch.select().where(Batch.id==batch).get())
		elif sys.argv[2] == 'student':
			if len(sys.argv) == 6:
				student = Student.insert(batch=sys.argv[3], age=sys.argv[4], last_name='', first_name=sys.argv[5]).execute()
			else:		
				student = Student.insert(batch=sys.argv[3], age=sys.argv[4], last_name=sys.argv[5], first_name=sys.argv[6]).execute()
			print "New student: " + str(Student.select().where(Student.id==student).get())
		elif sys.argv[2] == 'exercise':
			exercise = Exercise.insert(student=sys.argv[3], subject=sys.argv[4],note=sys.argv[5]).execute()
			print "New exercise: " + str(Exercise.select().where(Exercise.id==exercise).get())
	elif sys.argv[1] == 'delete':
		if sys.argv[2] == 'school':