def printXml():
dao = Dao()
properties = PropertiesReader()
userList = dao.getUsers()
root = ET.Element("xml")
recordUpdated = ET.SubElement(root, "agenda")
for user in userList:
person = ET.SubElement(recordUpdated, "person")
personId = ET.SubElement(person, "id").text = str(user.id)
personName = ET.SubElement(person, "name").text = user.name
personAge = ET.SubElement(person, "age").text = user.age
personPhoneNumber = ET.SubElement(
person, "phone_number").text = user.phoneNumber
birthDate = datetime.strptime(user.birthday, "%Y-%m-%d")
personBirthDate = ET.SubElement(person, "birthday")
personBirthday = ET.SubElement(personBirthDate,
"day").text = str(birthDate.day)
personBirthMonth = ET.SubElement(personBirthDate,
"month").text = str(birthDate.month)
personBirthYear = ET.SubElement(personBirthDate,
"year").text = str(birthDate.year)
tree = ET.ElementTree(root)
filename = properties.dictionary["XML_FILENAME"]
directory = os.path.dirname(filename)
noDir = directory == ""
if not noDir:
if not os.path.exists(directory):
os.makedirs(directory)
tree.write(filename)
print "XML printed as:", filename
def printXml():
dao = Dao()
properties = PropertiesReader()
userList = dao.getUsers()
root = ET.Element("xml")
recordUpdated = ET.SubElement(root, "agenda")
for user in userList:
person = ET.SubElement(recordUpdated, "person")
personId = ET.SubElement(person, "id").text = str(user.id)
personName = ET.SubElement(person, "name").text = user.name
personAge = ET.SubElement(person, "age").text = user.age
personPhoneNumber = ET.SubElement(person,"phone_number").text = user.phoneNumber
birthDate = datetime.strptime(user.birthday, "%Y-%m-%d")
personBirthDate = ET.SubElement(person, "birthday")
personBirthday = ET.SubElement(personBirthDate, "day").text = str(birthDate.day)
personBirthMonth = ET.SubElement(personBirthDate, "month").text = str(birthDate.month)
personBirthYear = ET.SubElement(personBirthDate, "year").text = str(birthDate.year)
tree = ET.ElementTree(root)
filename = properties.dictionary["XML_FILENAME"]
directory = os.path.dirname(filename)
noDir = directory == ""
if not noDir:
if not os.path.exists(directory):
os.makedirs(directory)
tree.write(filename)
print "XML printed as:", filename
def doSomething():
dao = Dao()
userId = raw_input("Enter the employee id to update: ")
user = findUserById(dao,userId)
if (user is None):
print "User was not found"
else:
dao.printUser(userId)
updateUser(dao,user)
def doSomething():
dao = Dao()
userId = raw_input("Enter the employee id to update: ")
user = findUserById(dao, userId)
if (user is None):
print "User was not found"
else:
dao.printUser(userId)
updateUser(dao, user)
def doSomething():
dao = Dao()
try:
f = open("input.csv")
lines = f.readlines()
userList = []
for line in lines:
properties = line.split(",")
newUser = User()
setattr(newUser, "id", properties[0].strip())
setattr(newUser, "name", properties[1].strip())
setattr(newUser, "age", properties[2].strip())
setattr(newUser, "phoneNumber", properties[3].strip())
setattr(newUser, "birthday", properties[4].rstrip("\n"))
userList.append(newUser)
if (userList):
dao.insertUsers(userList)
else:
print "file is empty"
except IOError:
print "File not Found"
def doSomething():
dao = Dao()
try:
f = open("input.csv")
lines = f.readlines()
userList = []
for line in lines:
properties = line.split(",")
newUser = User()
setattr(newUser, "id", properties[0].strip())
setattr(newUser, "name", properties[1].strip())
setattr(newUser, "age", properties[2].strip())
setattr(newUser, "phoneNumber", properties[3].strip())
setattr(newUser, "birthday", properties[4].rstrip("\n"))
userList.append(newUser)
if (userList):
dao.insertUsers(userList)
else:
print "file is empty"
except IOError:
print "File not Found"
