Question

i need help with this python assignment asking for creating a simple database (client application
そ归乔 Assignment rh ENCS-393-2174-WW: Tset5.pdf A2.pdf textbook.pdf Department of ComputV ← → O仚 file:///C 18/comp%20348/A2.pdf 5. Print Report: This will print the contents of the database, sorted by name. Note that the sorted contents should be sent by the server back to the client and then displayed by the client app. The Print Report function is r because it is the primary way for the grader (and you) to determine fthe database server is working correctly. Specifically you can display the database before you perform any updates, then check it again later to make sure everything is worklng. You can NOT get a passing grade on the assignment if the Print Rep。rt option does not work! So the report might look like this: thon DB content3 John 34 ABC 8treet 768-3245 Bob 26 123 Doop Road 345-5678 Donna 35 Here Road 564-6879 Ahmad 43 67 Drury Lane 897-3456 Naney |21 Stuffy Street|345-7896 Billy 199 123 Apple Street 435-456-5768 suel 45 Happy Lane 456-3245 6. Exit does the obvious thing. It should print a "Good bye" message and simply terminate the client application. Note that the server process will still be running since it executes in an infinite loop. If the client is restarted, it should reconnect with the existing server. Ifyou want to stop the server, you can do so either from the development GUI (e.g Eclipse kill' button). or from the command line with a 'kill' signal (on Linux, this would be kill procesSID) So that's the basic idea. Ifyou haven't written Python code before, you will quickly see thatit is a very accessible language with a lot of documentation and supporting materials online. Ifyou like to code, this assignment should actually be fun, certainly less painful than the C assignment DELIVERABLES: Your submission will have multiple source files. At the very least it will have a file called server.py and client.py. Feel free to add additional python files to more easily manage ENG 211 AM O Type here to search ^脈扣49 US 2018-03-14
)

Answer 1

# -*- coding: utf-8 -*-
import sys
import os
from pprint import pprint
import MySQLdb

file=open("data.txt","w")

#create table record(name varchar(100) not null,age varchar(100) not null,address varchar(100) not null,phone varchar (20) not null);
#INSERT INTO record (name,age,address,phone) VALUES ('a','20','test','123456789')

db = MySQLdb.connect("localhost","root","root","locate")
cursor=db.cursor()
cursor.execute("select * from record");
a = cursor.fetchall()

for line in a:
file.write(line[0]+"|"+line[1]+"|"+line[2]+"|"+line[3]+"\n")

Output of data.txt

a|20|test|123456789