예제 #1
0
	def flush(self, connection, oldTime=None, oldStaffName=None):
		"""
		Updates or creates the Staff member in the database
		"""
		cursor = connection.cursor()
		
		#maps attributes of the object to db columns
		sqlMap = {"time":"time", "employee_name":"staffName", "site":"location",
		"description":"description", "client_name":"clientName", "purpose":"purpose", 
		"previous_client":"previousClient", "contact_number":"contactNumber",
		"made_by":"madeBy", "date_made":"dateMade", "advocate_called":"advocateCalled",
		"confirmed_by":"confirmedBy", "date_confirmed":"dateConfirmed", "last_period":"lastPeriod"}
		
		params = model.createSqlParams(AppointmentWriteColumns, sqlMap, self)
	
		#if and old time and old staff (primary keys) are given then do an update
		if oldTime and oldStaffName:
			query = model.updateString("appointment", AppointmentWriteColumns, \
			"time = %(oldTime)s and employee_name = %(oldName)s")
		
			#add the where clause values just for the update sql statement
			params["oldTime"] = oldTime
			params["oldName"] = oldStaffName
		
		#else do a create statement
		else:
			query = model.insertString("appointment", AppointmentWriteColumns)

		cursor.execute(query, params)
		connection.commit()
		cursor.close()
예제 #2
0
파일: staff.py 프로젝트: jworr/scheduler
	def flush(self, connection, oldName=None):
		"""
		Updates or creates the appointment in the database
		"""
		cursor = connection.cursor()

		#map the database fields to this objects attributes
		sqlMap = {"name":"name", "role_id":"roleId", "is_active":"isActive",
		"street_address":"street", "city":"city", 
		"zip":"zipCode", "phone":"phone", "state":"state"}
		
		#map the data
		params = model.createSqlParams(EmployeeColumns, sqlMap, self)
		
		#if a old name was given then do an update statement
		if oldName:

			query = model.updateString("employee", EmployeeColumns, "name = %(oldName)s")
			params["oldName"] = oldName
			
		#else do a create statement
		else:
			query = model.insertString("employee", EmployeeColumns)
			
		cursor.execute(query, params)
		
		connection.commit()
		
		cursor.close()
예제 #3
0
파일: booking.py 프로젝트: jworr/scheduler
	def flush(self, connection):
		"""
		Flushes the booking to the database
		"""
		cursor = connection.cursor()

		#map the database fields to this objects attributes
		sqlMap = {"name":"staffName", "start_time":"startTime", "end_time":"endTime",
		"site":"site"}
		
		#remove the last column, the id because it is autogenerated by the database
		columns = BookingColumns[:len(BookingColumns)-1]
		
		#map the data
		params = model.createSqlParams(columns, sqlMap, self)
		
		print "params!", params
		
		#if a old name was given then do an update statement
		if self.bookingId != None:

			query = model.updateString("booking", columns, "booking_id = %(theId)s")
			params["theId"] = self.bookingId
			
		#else do a create statement
		else:
			query = model.insertString("booking", columns)
			
			#get the id assigned to the object
			#select currval('booking_booking_id_seq') from booking;
			
		print "WHAT?",cursor.execute(query, params)
		
		connection.commit()
		
		cursor.close()