def handler(event, contest):
logger.info("Start!")
main_loop = IOLoop.instance()
poll = Poll(main_loop)
cal = poll.cal
delete = Delete()
update_and_delete = UpdateAndDelete(main_loop, delete)
table = event['table']
queue_url = event['queueUrl']
message_count = event['messageCount']
poll.messages(sqs_receive_message, queue_url, message_count)
logger.info("Receive API count: {}".format(poll.fetch_count))
logger.info("Fetched messages: {}".format(poll.message_count))
update_and_delete.execute(sqs_delete_message_batch, db_update_item,
queue_url, table, cal.stats)
logger.info("Update API count: {}".format(update_and_delete.update_count))
logger.info("Delete API count: {}".format(delete.delete_count))
logger.info("Delete Message count: {}".format(delete.message_count))
return "Lambda job finished successfully."
def POST(self):
if self.input['oper'] == 'del':
d = Delete(self.input)
return d.delete()
elif self.input['oper'] == 'edit':
u = Update(self.input)
return u.update()
def delete(self):
'''
Функция вызывает класс Delete для удаления элемента таблицы
Получает: -
Возвращает: -
Автор: -
'''
global tree
Delete(tree)
def selBtnEvent(self):
for widget in self.workFrm.winfo_children():
widget.destroy()
if self.selV.get() == 1:
Merge(self)
if self.selV.get() == 2:
Split(self)
if self.selV.get() == 3:
Insert(self)
if self.selV.get() == 4:
Delete(self)
def __init__(self):
super(Window, self).__init__()
self.layout = QBoxLayout(QBoxLayout.TopToBottom)
self.setLayout(self.layout)
self.setWindowTitle("GUI")
self.setFixedSize(500, 500)
Encrypt(self)
Add(self)
Delete(self)
self.Dcheck.toggle()
self.Acheck.toggle()
self.Echeck.toggle()
def delete(jdID, content): date, time, detail = content['dDate'], content['dSTime'], content['dEvent'] year, month, day, hour, minute, __, detail = get_properties(date=date, time=time, detail=detail) nearest = True if 'value' in content['nearest'] else False #print(nearest) selftime = None if 'value' not in content['SeTime'] else content['SeTime']['value'] cmd = None if 'value' not in content['dAll'] else content['dAll']['value'] cmd = cmd if nearest is False else '最近一次' event = Event(jdID=jdID, year=year, month=month, day=day, hour=hour, minute=minute, event_detail=detail, isDelete=True) delete = Delete(db=db, jdID=jdID, event=event, selftime=selftime, cmd=cmd) rst = delete.delete() return rst
def main():
print('Available Options: C=Create, R=Read, U=Update, D=Delete ')
choice = input('Choose your option = ')
if choice == 'C':
createObj=Create()
createObj.func_CreateData()
elif choice == 'R':
readObj = Read()
readObj.func_ReadData()
elif choice == 'U':
updateObj = Update()
updateObj.func_UpdateData()
elif choice == 'D':
deleteObj = Delete()
deleteObj.func_DeleteData()
else:
print('Wrong choice, You are going exist.')
def handler(event, context):
logger.info("Start!")
poll = Poll()
cal = Sum()
update = Update()
delete = Delete()
table = event['table']
queue_url = event['queueUrl']
message_count = event['messageCount']
def on_error(e):
raise e
def on_poll_completed():
logger.info("Receive API count: {}".format(poll.fetch_count))
logger.info("Fetched messages: {}".format(poll.message_count))
update_and_delete()
def update_and_delete_one(key):
updated_message_ids = update.execute(db, table, cal.stats[key])
return delete.execute(sqs_client, queue_url, updated_message_ids)
def update_and_delete():
delete_results = []
async_one = rx.Observable.to_async(update_and_delete_one)
for key in cal.stats:
delete_results.append(async_one(key))
rx.Observable.merge(delete_results).to_blocking().for_each(block)
on_next_message = cal.add
messages = poll.messages(sqs, queue_url, message_count).to_blocking()
messages_observer = rx.Observer(on_next_message, on_error,
on_poll_completed)
messages.subscribe(messages_observer)
messages.for_each(block)
logger.info("Update API count: {}".format(update.update_count))
logger.info("Delete API count: {}".format(delete.delete_count))
logger.info("Delete Message count: {}".format(delete.message_count))
def main():
while 1:
print(
'Available Options: C=Create, R=Read, U=Update, D=Delete, E=Exit ')
choice = input('Choose your option = ')
if choice == 'C':
createObj = Create()
createObj.func_CreateData()
elif choice == 'R':
readObj = Read()
readObj.func_ReadData()
elif choice == 'U':
updateObj = Update()
updateObj.func_UpdateData()
elif choice == 'D':
deleteObj = Delete()
deleteObj.func_DeleteData()
elif choice == 'E':
break
def update_and_delete_one(sqs, db, queue_url, table, stats, executor):
ids = update(db, table, stats)
delete = Delete(executor)
delete.execute(sqs, queue_url, ids)
return delete
from read import Read
from update import Update
from delete import Delete
from raw_crud import connection_to_server
conn = connection_to_server() #Default localhost i połączenie z bazą TheShips
if conn:
while True:
print('c=Create, r=Read, u=Update, d=Delete, anything else=Exit ')
choice = input('What do you want to do? Choose one option: ')
if choice == 'c':
create1 = Create()
create1.insert_row(conn)
elif choice == 'r':
read1 = Read()
read1.display_table(conn)
elif choice == 'u':
update1 = Update()
update1.update_rows(conn)
elif choice == 'd':
delete1 = Delete()
delete1.delete_rows(conn)
else:
print('Bye :)')
break
else:
print('Failed to connect to database')
login_window = LogIn()
if login_window.is_closed:
is_true = False
if login_window.create_homepage:
homepage_window = HomePage(login_window.table_name)
while not homepage_window.is_closed:
if homepage_window.expense:
expense_window = Expense(login_window.table_name)
homepage_window = HomePage(login_window.table_name)
if homepage_window.income:
income_window = Income(login_window.table_name)
homepage_window = HomePage(login_window.table_name)
if homepage_window.transaction:
transaction_window = Transaction(login_window.table_name)
homepage_window = HomePage(login_window.table_name)
if homepage_window.delete:
delete_window = Delete(login_window.table_name)
homepage_window = HomePage(login_window.table_name)
if homepage_window.analysis:
analysis_window = Analysis(login_window.table_name)
homepage_window = HomePage(login_window.table_name)
if homepage_window.suggestion:
suggestion_window = Savings(login_window.table_name)
homepage_window = HomePage(login_window.table_name)
login_window = LogIn()
if login_window.is_closed:
is_true = False
else:
is_true = False
def Del(self):
delete = Delete()
