def create_validation(): meta_data = CRUD().meta_data[0:5] create = [] for data in meta_data: value_input = request.form[data['field_name']] create.append(value_input) reply_create = CRUD().create(create) return render_template("create.html", meta_data=meta_data, create=reply_create)
def edit(): search = CRUD().find({ 'name': request.args.get('name'), 'location': request.args.get('location'), 'search_and': True }) recNo = search[0] record = CRUD().read(recNo) values = [] for value in record: values.append(str(value).strip()) return ''
def validation_remove(): record = CRUD().find({ 'name': request.args.get('name'), 'location': request.args.get('location'), 'search_and': True }) delete = CRUD().delete(record[0]) if delete: return render_template('delete.html', msg_delete=record) else: return render_template('delete.html', msg_delete='Registro apagado com sucesso!')
def basic_structure(name='', location='', search_and=False): records = CRUD().find({ 'name': name, 'location': location, 'search_and': search_and }) registro = [] for record in records: if CRUD().read(record)[-1] != 1: line_record = CRUD().read(record)[0:6] strip_record = [x.strip(' ') for x in line_record] registro.append(strip_record) return registro
def test_remove_user_Passes_correct_value_to_modify_users_file( self, mock_read_users_file, mock_modify_users_file): mock_read_users_file.return_value = self.users_data crud = CRUD() crud.remove_user(1) mock_modify_users_file.assert_called_once_with(self.users_data) pass
def test_get_group_id_Returns_false_for_invalid_group_name( self, mock_read_groups_file ): mock_read_groups_file.return_value=self.groups_data crud=CRUD() name="Test" self.assertEqual(crud.get_group_id(name),False)
def test_get_group_data_Returns_correct_value_if_field_and_id_are_valid( self, mock_read_groups_file): crud = CRUD() mock_read_groups_file.return_value = self.groups_data self.assertEqual(crud.get_group_data('1', 'name'), 'default') """""" pass
def test_get_user_data_Returns_false_for_invalid_field(self, mock_read_users_file): mock_read_users_file.return_value=self.users_data user_id=3 field="Test" crud=CRUD() self.assertEqual(crud.get_user_data(user_id,field),False)
def test_add_new_user_Passes_correct_data_to_modify_users_file( self, mock_modify_users_file, mock_read_users_file): mock_read_users_file.return_value = self.users_data crud = CRUD() crud.add_new_user("*****@*****.**", "2021-02-09") mock_modify_users_file.assert_called_once_with(self.users_data) """Description: il faut utiliser les mocks des fonctions "read_users_file",
def test_remove_group_member_Passes_correct_value_to_modify_groups_file( self, mock_read_groups_file, mock_modify_groups_file): mock_read_groups_file.return_value = self.groups_data crud = CRUD() crud.remove_group_member("2", "*****@*****.**") mock_modify_groups_file.assert_called_once_with(self.groups_data) pass
def test_remove_group_member_Returns_false_for_invalid_group_member( self, mock_read_groups_file): fieldValue = False mock_read_groups_file.return_value = self.groups_data crud = CRUD() self.assertEqual(crud.remove_group_member("1", "3"), fieldValue) pass
def test_update_users_Exception_raised_to_modify_users_file( self, mock_read_users_file, mock_modify_users_file): crud = CRUD() mock_read_users_file.return_value = None self.assertFalse(crud.update_users('1', "name", "NEW")) pass
def test_remove_user_Returns_false_for_invalid_id(self, mock_read_users_file): fieldValue = False mock_read_users_file.return_value = self.users_data crud = CRUD() self.assertEqual(crud.remove_user(3), fieldValue) pass
def test_get_user_id_Returns_id_for_valid_user_name( self, mock_read_users_file): fieldValue = '1' mock_read_users_file.return_value = self.users_data crud = CRUD() self.assertEqual(crud.get_user_id("*****@*****.**"), fieldValue) pass
def test_get_user_id_Returns_false_for_invalid_user_name( self, mock_read_users_file): testMessage = "Invalide" mock_read_users_file.return_value = self.users_data crud = CRUD() self.assertFalse(crud.get_user_id("*****@*****.**"), testMessage) pass
def test_get_user_data_Returns_correct_value_if_field_and_id_are_valid( self, mock_read_users_file): fieldValue = 0 mock_read_users_file.return_value = self.users_data crud = CRUD() self.assertEqual(crud.get_user_data("1", "SpamN"), fieldValue) """Description: il faut utiliser le mock de fonction "read_groups_file",
def test_get_user_data_Returns_false_for_invalid_id( self, mock_read_users_file): mock_read_users_file.return_value = self.users_data crud = CRUD() self.assertFalse(crud.get_user_data("3", "name")) """Description: il faut utiliser le mock de fonction "read_groups_file",
def test_add_new_group_Passes_correct_data_to_modify_groups_file( self, mock_modify_groups_file, mock_read_groups_file): crud = CRUD() mock_read_groups_file.return_value = self.groups_data crud.add_new_group("test", "50", ["test"]) mock_modify_groups_file.assert_called_once_with(self.groups_data) """Description: il faut utiliser les mocks des fonctions "read_groups_file",
def test_remove_user_group_Returns_false_for_invalid_group( #Bool not iterable self, mock_read_users_file): testMessage = "Invalide" mock_read_users_file.return_value = self.users_data crud = CRUD() self.assertFalse(crud.remove_user_group("1", testMessage)) pass
def test_get_user_id_Returns_false_for_invalid_user_name( self, mock_read_users_file ): mock_read_users_file.return_value=self.users_data crud=CRUD() name="*****@*****.**" self.assertEqual(crud.get_user_id(name), False)
def ierParser(): ''' ier파싱로직 :input: None :return: None ''' key = 'BV359oacvun7ZaVBlnAuPnLq3bj7AxJbVK8jdrWotyJwuQNVUP96aQ4XJNBiEdc8kMlPbvi3RVBaeZ5mO'\ 'NmvxNBEPlZQqyjPWKLip73jrFoEOe2uSYT00rKXKg90VRNdvvEUOW7QUDDsi60vsp8RfsYoAxXI8DNZ1LSdZig5bC'\ 'gxnbzOqNHqT67DWZTa8zSQzo1WnWVKICzcMlBi8Jbu5hG4NPGAOF6muP88kckT27hQHf0vYvcyXhVRi6IXQV5DFNs6m'\ 'C7giH27AzxsZUmcnHOM4qaoTMCgCdK3w4IVy5PPpXRsJa86tdZ78gC6mTMWFV5gp35eLQor29ggYre3NGxjEM5Q1Mset'\ '3KUcvDPeducysF99fh5yTI8hWcc8om8iJ88yMDnnPYuVVuVG5RWoxqZvMwGTlR00w4otHLxc4Rj5YmMlGWCXQTudjMmZ'\ '7UC7h3jbFl8ue4ufGdXjkeMOOdkcJKK4iXekPmXfDufeXS2WjOXFzDydHxsESHR5aEL' uid = 'ulju' url = 'https://IERNet.kins.re.kr/IERNet.asmx/jsonData?UID={uid}&AKEY={key}'.format( uid=uid, key=key) req = requests.get(url) if req.status_code == 200: html = req.text jsonStr = html.replace('<?xml version="1.0" encoding="utf-8"?>', '') jsonStr = jsonStr.replace('<string xmlns="http://tempuri.org/">', '') jsonStr = jsonStr.replace('</string>', '') result = json.loads(jsonStr) db = CRUD() for i in range(len(result)): db.insertIerData(name=result[i]['name'], erm=result[i]['erm'], unit=result[i]['unit'], time=result[i]['time']) else: print('잦은요청 시도', req.status_code, req, type(req)) return 'hellow Flask'
def test_add_new_user_3(self): crud = CRUD() crud.add_new_user("*****@*****.**", "2021-02-09") crud.remove_user(0) crud.remove_user_group('1', 'default') user_data = crud.update_users(1, "Trust", 70) self.assertEqual(user_data, self.test_user_3)
def test_get_group_data_Returns_false_for_invalid_field( self, mock_read_groups_file): crud = CRUD() mock_read_groups_file.return_value = self.groups_data self.assertFalse(crud.get_group_data('1', 'INVALID')) """""" pass
def test_remove_user_group_6(self): crud = CRUD() crud.remove_user_group('0', 'default') crud.update_users(0, "Trust", 50) crud.add_new_user("*****@*****.**", "2021-02-09") user_data = crud.remove_user(1) self.assertEqual(user_data, self.test_user_2)
def test_add_new_user_1(self): crud = CRUD() crud.add_new_user("*****@*****.**", "2021-02-10") crud.update_users(0, "name", "*****@*****.**") crud.remove_user_group('2', 'default') user_data = crud.remove_user(1) self.assertEqual(user_data, self.test_user)
def test_remove_user_group_4(self): crud = CRUD() crud.remove_user_group('0', 'default') crud.remove_user(0) user_data = crud.update_users(0, "Trust", 50) # crud.add_new_user("*****@*****.**", "2021-02-09") self.assertFalse(user_data)
def test_remove_user_group_1(self): crud = CRUD() crud.remove_user_group('0', "default") crud.add_new_user("*****@*****.**", "2021-02-09") crud.update_users(1, "name", "*****@*****.**") user_data = crud.remove_user(1) self.assertEqual(user_data, self.test_user_2)
def test_add_new_user_Returns_false_to_invalid_email_to_modify_users_file( self, mock_modify_users_file, mock_modify_groups_file, mock_read_users_file ): crud=CRUD() email="test" date="2003-09-13" self.assertFalse(crud.add_new_user(email,date))
def test_crud_init_add_new_user(self): # _INIT_ crud = CRUD(True) self.assertEqual(crud.read_users_file(), {}) # add_new_user self.assertEqual(crud.add_new_user("*****@*****.**", "2020-11-16"), True) self.assertEqual(crud.read_users_file().get('1'), self.user_2)
def edit_validation(): meta_data = CRUD().meta_data[0:6] edit = {} id_line = request.args.get('id') new_value = request.args.get('val') edit['id'] = json.loads(id_line) edit['value'] = new_value read = CRUD().read(edit['id'][0]) new_record = {} for line, old_record in enumerate(read[:6]): if meta_data[line]['field_name'] == edit['id'][1]: new_record[meta_data[line]['field_name']] = edit['value'] else: new_record[meta_data[line]['field_name']] = old_record CRUD().update(edit['id'][0], new_record) return ''