def _push_diary_data_by_action(user_id, action, data): """ Update server diary database based on client changes. action: 'create' data: { 'uuid': "2F69DEB5-B631-40DD-A65E-AFE9A0882275", 'time': 1477139399, 'title': 'this is a new diary', 'content': 'today is a good day', } action:'delete' data: { 'uuid': "04B977C7-6F7F-4D36-BFDA-FE98C5241DB0" 'time': 1477139399, } """ logger.info('_push_diary_data_by_action: user_id:%s; action:%s; data:%s', user_id, action, data) if action == 'create' or action == 'update': db_diary.upsert_diary(user_id, data.get('uuid'), data) elif action == 'delete': db_diary.delete_diary(user_id, data.get('uuid'), data.get('time')) else: return
def test_pull(): base_test.reinit_table() # create mock user _create_mock_user(1) user_id = 1 # set last_sync_time current_time = int(time.time()) last_sync_time = current_time - 1000 # generate new data[create, update, delete] since last_sync_time uuid1 = _get_uuid() db_diary.create_diary(user_id, uuid1, _get_title(), _get_content(), current_time) uuid2 = _get_uuid() db_diary.create_diary(user_id, uuid2, _get_title(), _get_content(), current_time) db_diary.update_diary(user_id, uuid2, 'updated', 'updated', current_time + 100) uuid3 = _get_uuid() db_diary.create_diary(user_id, uuid3, _get_title(), _get_content(), current_time) db_diary.delete_diary(user_id, uuid3, current_time + 150) # assert uuid1 created, uuid2 created, uuid3 unknown changed_diary_list = db_diary.get_diary_list_since_last_sync( user_id, last_sync_time) assert len(changed_diary_list) == 3
def test_delete(): base_test.reinit_table() _create_mock_user(3) uuid1 = _get_uuid() uuid2 = _get_uuid() uuid3 = _get_uuid() diary_id_1 = db_diary.create_diary(1, uuid1, _get_title(), _get_content()) diary_id_2 = db_diary.create_diary(2, uuid2, _get_title(), _get_content()) diary_id_3 = db_diary.create_diary(3, uuid3, _get_title(), _get_content()) assert db_diary.get_diary_by_id(diary_id_1) is not None assert db_diary.get_diary_by_uuid(uuid1, 1) is not None assert db_diary.get_diary_by_id(diary_id_2) is not None assert db_diary.get_diary_by_uuid(uuid2, 2) is not None assert db_diary.get_diary_by_id(diary_id_3) is not None assert db_diary.get_diary_by_uuid(uuid3, 3) is not None db_diary.delete_diary(1, uuid1) assert db_diary.get_diary_by_id(diary_id_1) is None assert db_diary.get_diary_by_uuid(uuid1, 1) is None db_diary.delete_diary(2, uuid2) assert db_diary.get_diary_by_id(diary_id_1) is None assert db_diary.get_diary_by_uuid(uuid2, 2) is None db_diary.delete_diary(3, uuid3) assert db_diary.get_diary_by_id(diary_id_3) is None assert db_diary.get_diary_by_uuid(uuid3, 3) is None
def test_push(): base_test.reinit_table() # create mock user _create_mock_user(1) # create a diary data = { 'title': 'first diary', 'content': 'first diary', 'time': 11111111, } _uuid = _get_uuid() user_id = 1 assert db_diary.get_diary_by_uuid(_uuid, user_id) is None db_diary.upsert_diary(user_id, _uuid, data) diary = db_diary.get_diary_by_uuid(_uuid, user_id) assert diary is not None assert diary.get('time_created') == 11111111 assert diary.get('time_modified') == 11111111 # change this diary data = { 'title': 'changed diary', 'content': 'changed diary', 'time': 2222222, } db_diary.upsert_diary(user_id, _uuid, data) diary = db_diary.get_diary_by_uuid(_uuid, user_id) assert diary is not None assert diary.get('title') == 'changed diary' assert diary.get('content') == 'changed diary' assert diary.get('time_created') == 11111111 assert diary.get('time_modified') == 2222222 # delete this diary time_delete = 333333333 db_diary.delete_diary(user_id, _uuid, time_delete) diary = db_diary.get_diary_by_uuid(_uuid, user_id) assert diary is None
def _push_diary_data_by_action(user_id, action, data): """ Update server diary database based on client changes. action: 'create' data: { 'uuid': "2F69DEB5-B631-40DD-A65E-AFE9A0882275", 'time': 1477139399, 'title': 'this is a new diary', 'content': 'today is a good day', } action:'delete' data: { 'uuid': "04B977C7-6F7F-4D36-BFDA-FE98C5241DB0" 'time': 1477139399, } """ logger.info('_push_diary_data_by_action: user_id:%s; action:%s; data:%s', user_id, action, data) if action == 'create' or action == 'update': db_diary.upsert_diary(user_id, data.get('uuid'), data) elif action == 'delete': db_diary.delete_diary(user_id, data.get('uuid'), data.get('time')) else: return
def delete_diary(user_id, uuid): db_diary.delete_diary(user_id, uuid)
def delete_diary(user_id, diary_id): db_diary.delete_diary(user_id, diary_id)