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 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_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 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))
