def test_get_non_existant(self): PROJECT_NAME = 'test project get' project_dao = ProjectMetaDataDao() project_dao.open(':memory:') read_project_dto = project_dao.get(PROJECT_NAME) self.assertEquals(None, read_project_dto)
def get_project_dates(name): project_dao = ProjectMetaDataDao() project_dao.open('statistics.db3') dto = project_dao.get(name) if dto is None: return '', '' last_fetch = dto.last_fetch.strftime("%d/%m/%Y") last_translation = dto.last_translation_update.strftime("%d/%m/%Y") return last_fetch, last_translation
def get_json(self, date_requested): dao = ProjectMetaDataDao() dao.open('statistics.db3') total_words = 0 projects = dao.get_all() for project in projects: total_words += project.words usage = Usage() calls = usage.get_stats(date_requested) results = {} results['total_words'] = total_words results['projects'] = len(projects) results['searches'] = calls return json.dumps(results, indent=4, separators=(',', ': '))
def test_put_newvalue(self): PROJECT_NAME = 'test project' project_dto = ProjectMetaDataDto(PROJECT_NAME) project_dto.last_fetch = datetime.datetime.now() project_dto.last_translation_update = datetime.datetime.now() project_dao = ProjectMetaDataDao() project_dao.open(':memory:') project_dao.put(project_dto) read_project_dto = project_dao.get(PROJECT_NAME) project_dao.close() self.assertEquals(PROJECT_NAME, read_project_dto.name)
def test_put_updatevalue(self): PROJECT_NAME = 'test project update' WORDS = 100 project_dto = ProjectMetaDataDto(PROJECT_NAME) project_dto.last_fetch = datetime.datetime.now() project_dto.last_translation_update = datetime.datetime.now() project_dao = ProjectMetaDataDao() project_dao.open(':memory:') project_dao.put(project_dto) project_dto.words = WORDS project_dao.put(project_dto) read_project_dto = project_dao.get(PROJECT_NAME) project_dao.close() self.assertEquals(WORDS, read_project_dto.words)
def test_put_updatevalue(self): PROJECT_NAME = 'test project update' WORDS = 100 project_dto = ProjectMetaDataDto(PROJECT_NAME) project_dto.last_fetch = datetime.datetime.now() project_dto.last_translation_update = datetime.datetime.now() project_dao = ProjectMetaDataDao() project_dao.open(':memory:') project_dao.put(project_dto) project_dto.words = WORDS project_dao.put(project_dto) read_project_dto = project_dao.get(PROJECT_NAME) self.assertEquals(WORDS, read_project_dto.words)
def test_delete_last_fetch(self): PROJECT_NAME = 'test project delete' DAYS = 90 project_dto = ProjectMetaDataDto(PROJECT_NAME) project_dto.last_fetch = datetime.datetime.now() project_dto.last_translation_update = datetime.datetime.now() project_dto2 = ProjectMetaDataDto(PROJECT_NAME + "2") project_dto2.last_fetch = datetime.datetime.now() - timedelta(days=DAYS + 5) project_dto2.last_translation_update = datetime.datetime.now() project_dao = ProjectMetaDataDao() project_dao.open(':memory:') project_dao.put(project_dto) project_dao.put(project_dto2) project_dao.delete_last_fetch(DAYS) project_dtos = project_dao.get_all() project_dao.close() self.assertEquals(1, len(project_dtos))
def test_get_all(self): PROJECT_NAME = 'test project get_all' project_dto = ProjectMetaDataDto(PROJECT_NAME) project_dto.last_fetch = datetime.datetime.now() project_dto.last_translation_update = datetime.datetime.now() project_dto2 = ProjectMetaDataDto(PROJECT_NAME + "2") project_dto2.last_fetch = datetime.datetime.now() project_dto2.last_translation_update = datetime.datetime.now() project_dao = ProjectMetaDataDao() project_dao.open(':memory:') project_dao.put(project_dto) project_dao.put(project_dto2) project_dtos = project_dao.get_all() project_dao.close() self.assertEquals(2, len(project_dtos))