Exemplo n.º 1
0
def process_request(client,address):
	database = Database()
	
	while True:
		message = client.recv(1025)
		if message == "close":
			client.send(str(("Thanks for using this database!",0))) # second parameter is 0 - indicates that the client should terminate now like a status
			break;
		elif message == "save":
			file_name = '../Sampleinput/input_file.txt'
			db_file = open(file_name)
			mobiles_list = []
			for eachLine in db_file:
				mobiles_list.append(eval(eachLine))
			db_file.close()
			#client.send(str(("Saving data into the database! Please wait...",1)))
			database.populate_db(mobiles_list)
			client.send(str(("Database is saved!!",1)))
		else:
			database.query(message)
			with open("../Answer/results.txt","rb") as fobj:
				line = fobj.read(1024)
				while line:
					client.send(line)
					line = fobj.read(1024)
			print "sending complete"

	client.close()
Exemplo n.º 2
0
def main():
	print "-" * 110
	print " " * 40 + "Mobile database"
	print "-" * 110
	print """						Query format:
			- SELECT mobiles FROM 'company' WITH 'features'
			- conditions:"
			   - Companies can be any company.To search in all the companies give company name as 'all'
			   - Features must be specified as follows 
			   			'feature' operator 'value'

			   - WITH clause is mandatory
			   - To get multiple the info of mobile with two or more features seperate each feature with an 'and'
			   - Operators supported : '=', '<', '>'"
			- features 
					* operatingsystem ( only operator '=' must be used )
					* price
					* frontcamera
					* rearcamera
					* thickness
					* talktime
					* GPS ( only operator '=' must be used )
					* type ( only operator '=' must be used )

	
	Say a user wants to get the info of samsung mobiles with windows os and price less than 10000Rs and with GPS and with rearcamera\n \t The query will be
	\t\t SELECT mobiles FROM Samsung WITH operatingsystem = windows and price < 10000 and GPS = yes and rearcamera > 0"""

	
	
	start = True
	database = Database()
	while start:
		print "-" * 110
		print """					Menu"""
		print "-" * 110
		print """
				1.Save the new data into database
				2.Query the database
				3.Exit
			  """
		print "-" * 110

		choice = raw_input("Enter the choice!\n")
		if choice == '1':
			file_name = '../Sampleinput/input_file.txt'
			db_file = open(file_name)
			mobiles_list = []
			for eachLine in db_file:
				mobiles_list.append(eval(eachLine))
			db_file.close()
			print "Saving data into the database! Please wait..."
			database.populate_db(mobiles_list)
			print "Database is saved!!"
		elif choice == '2':
			query_string = raw_input("Enter the query\n")
			print "-" * 110
			database.query(query_string)
			print "-" * 110
		elif choice == '3':
			start = False
		else:
			print "Invalid choice"