class AddrBookApp(Application):
def __init__(self):
super().__init__()
# print(self.config)
self.db = MySQLdb.connect(db=self.config['db'],
host=self.config['host'],
user=self.config['user'],
passwd=self.config['passwd'],
charset="utf8",
use_unicode=True) # defualt가 utf-8아님
self.cursor = self.db.cursor()
self.PERPAGE = 20 # 한 페이지당 출력 건수
self.addressbook_dao = AddressBookDao(self.cursor)
def create_menu(self, menu):
menu.add('목록', self.print_list)
menu.add('상세보기', self.print_detail)
menu.add('검색', self.search)
menu.add('추가', self.add)
menu.add('수정', self.update)
menu.add('삭제', self.delete)
menu.add('종료', self.exit)
def print_list(self):
page = int(input('페이지:'))
pagination = self.addressbook_dao.get_page(page, self.PERPAGE)
print('=' * 75)
print('주소록')
print('=' * 75)
for e in pagination.datas:
print(
f'{e.num:8d} {e.name:20s} {e.phone:16s} {e.email:20s} {e.addr}'
)
print('-' * 75)
# 현재페이지/전체페이지 (총 데이터건수)
print(f"{page}/{pagination.total_page} (총 {pagination.total_count} 건)")
print('-' * 75)
def print_detail(self):
num = int(input('번호:'))
row = self.addressbook_dao.get(num)
# row 출력
if not row:
print(f'{num}은 없습니다.')
return
# row[0] 로쓰면 가독성이 없어서 AddrBookEntry의 인스턴스로 만들어줌
print(f'num: {row.num}')
print(f'이름: {row.name}')
print(f'전화번호: {row.phone}')
print(f'email: {row.email}')
print(f'주소: {row.addr}')
def search(self):
keyword = input('검색어:')
rows = self.addressbook_dao.search(keyword)
# rows 출력
print('=' * 75)
print(f'검색결과({keyword})')
print('=' * 75)
for e in rows:
print(
f'{e.num:8d} {e.name:20s} {e.phone:16s} {e.email:20s} {e.addr}'
)
print('-' * 75)
# 수행평가
def add(self):
# create
print('새 주소록 항목 추가')
name = input('이름:')
phone = input('전화번호:')
email = input('이메일:')
addr = input('주소:')
self.addressbook_dao.add(name, phone, email, addr)
def update(self):
# update
num = int(input('수정할 번호:'))
row = self.addressbook_dao.get(num)
name = input(f'이름({row.name}):')
if name.strip() == '':
name = row.name
phone = input(f'전화번호({row.phone}):')
if phone.strip() == '':
phone = row.phone
email = input(f'이메일({row.email}):')
if email.strip() == '':
email = row.email
addr = input(f'주소({row.addr}):')
if addr.strip() == '':
addr = row.addr
self.addressbook_dao.update(num, name, phone, email, addr)
def delete(self):
# delete
num = int(input('삭제할 번호:'))
row = self.addressbook_dao.get(num)
ans = input(f'{row.name}을 삭제할까요?(Y/N)')
if ans.upper() == 'Y':
self.addressbook_dao.delete(num)
def destroyed(self):
self.cursor.close()
self.db.close()
class AddrBookApp(Application):
def __init__(self):
super().__init__()
# print(self.config)
self.db = MySQLdb.connect(
db = self.config['DB'],
host = self.config['HOST'],
user = self.config['USER'],
passwd = self.config['PASSWD'],
charset = self.config['CHARSET'],
use_unicode = True
)
self.cursor = self.db.cursor()
self.addressbook_dao = AddressBookDao(self.cursor)
self.PERPAGE = 20 # 한 페이지 당 출력 건수
def create_menu(self, menu):
menu.add('목록',self.print_list)
menu.add('상세보기',self.print_detail)
menu.add('검색',self.search)
menu.add('추가',self.add)
menu.add('수정',self.update)
menu.add('삭제',self.delete)
menu.add('종료',self.exit)
def print_list(self):
page = int(input('페이지 : '))
pagination = self.addressbook_dao.get_page(page, self.PERPAGE)
print()
if page > pagination.total_page:
print('잘못된 입력입니다. (페이지 초과)')
return
print('='*100)
print(' '*40,'주소록')
print('='*100,'\n')
for e in pagination.datas:
print(f'{e.num:8d}) {e.name:25s} {e.phone:20s} {e.email:30s} {e.addr}')
# 현재 페이지 / 전체 페이지 (총 데이터 건수)
print(f'\npage : {page} / {pagination.total_page} (총 {pagination.total_count}건)')
def print_detail(self):
num = int(input('번호 : '))
row = self.addressbook_dao.get(num)
print()
if not row:
print(f'{num}은 없습니다.')
return
print(f'num : {row.num}')
print(f'이름 : {row.name}')
print(f'전화번호 : {row.phone}')
print(f'이메일 : {row.email}')
print(f'주소 : {row.addr}')
def search(self): # 부분 일치 검색
keyword = input('검색어 : ')
rows = self.addressbook_dao.search(keyword)
print('='*100)
print(' '*37,'검색 결과 ', len(rows), '건')
print('='*100,'\n')
for e in rows:
print(f'{e.num:8d}) {e.name:25s} {e.phone:20s} {e.email:30s} {e.addr}')
def add(self):
pass
def update(self):
pass
def delete(self):
pass
# def exit(self):
# self.destroyed()
# sys.exit(0)
def destroyed(self): # 부모클래스의 메서드 오버라이드
self.cursor.close()
self.db.close()
class AddrBookApp(Application):
def __init__(self):
super().__init__()
print(self.config)
self.db = MySQLdb.connect(host=self.config['host'],
db=self.config['db'],
user=self.config['user'],
passwd=self.config['passwd'],
charset='utf8',
use_unicode=True)
self.cursor = self.db.cursor()
self.PERPAGE = 20 # 한 페이지당 출력 건수
self.addrbook_dao = AddressBookDao(self.cursor)
def create_menu(self, menu):
menu.add('목록', self.print_list)
menu.add('상세보기', self.print_detail)
menu.add('검색', self.search)
menu.add('추가', self.add)
menu.add('수정', self.update)
menu.add('삭제', self.delete)
menu.add('종료', self.exit)
def print_list(self):
page = int(input('페이지:'))
pagination = self.addrbook_dao.get_page(page, self.PERPAGE)
print('=' * 60)
print('주소록')
print('=' * 60)
for e in pagination.datas:
print(
f'{e.num:8d} {e.name:30s} {e.phone:16s} {e.email:20s} {e.addr}'
)
print('-' * 60)
print(f'{page}/{pagination.total_page} (총 {pagination.total_count} 건)')
print('-' * 60)
def print_detail(self):
num = int(input('번호:'))
row = self.addrbook_dao.get(num)
if not row:
print(f'{num}은 없습니다.')
return
print(f'num: {row.num}')
print(f'이름: {row.name}')
print(f'전화번호: {row.phone}')
print(f'email: {row.email}')
print(f'주소: {row.addr}')
def search(self):
keyword = input('검색어: ')
rows = self.addrbook_dao.search(keyword)
print('=' * 60)
print(f'검색결과({keyword})')
print('=' * 60)
for e in rows:
print(
f'{e.num:8d} {e.name:30s} {e.phone:16s} {e.email:20s} {e.addr}'
)
print('-' * 60)
def add(self):
print('새 주소록 항목 추가')
name = input('이름: ')
phone = input('전화번호: ')
email = input('email: ')
addr = input('주소: ')
self.addrbook_dao.add(name, phone, email, addr)
self.db.commit()
print('추가완료')
def update(self):
num = int(input('대상 선택(번호): '))
row = self.addrbook_dao.get(num)
if not row:
print(f'{num}은 없습니다.')
return
print('주소록 항목 수정')
name = input(f'이름({row.name}):')
if name.strip() == '':
name = row.name
phone = input(f'전화번호({row.phone}):')
if phone.strip() == '':
phone = row.phone
email = input(f'email({row.email}):')
if email.strip() == '':
email = row.email
addr = input(f'주소({row.addr}):')
if addr.strip() == '':
addr = row.addr
self.addrbook_dao.update(num, name, phone, email, addr)
self.db.commit()
print('수정완료')
def delete(self):
name = input('이름: ')
self.addrbook_dao.delete(name)
self.db.commit()
print('삭제완료')
def destroyed(self):
self.cursor.close()
self.db.close()