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 ''
