def test_crud():
company = Company()
session.add(company)
assert [] == crud.object_list(session, company, MyModel)
obj = crud.create(session, company, MyModel, name='xxx')
assert obj.name == 'xxx'
session.commit()
read_obj = crud.read(session, company, MyModel, obj.id)
assert read_obj == obj
assert 1 == crud.object_count(session, company, MyModel)
assert [read_obj] == crud.object_list(session, company, MyModel)
crud.update(session, company, MyModel, obj.id, name='aaa')
session.commit()
update_obj = crud.read(session, company, MyModel, obj.id)
assert update_obj.name == 'aaa'
crud.delete(session, company, MyModel, obj.id)
delete_obj = crud.read(session, company, MyModel, obj.id)
assert delete_obj is None
assert 0 == crud.object_count(session, company, MyModel)
def atualizarIngresso(arguments):
codigo = arguments['codigo']
nome = arguments['nome']
qtd = int(arguments['quantidade'])
horIni = arguments['horarioInicio']
horTer = arguments['horarioTermino']
data = arguments['data']
end = arguments['endereco']
preco = float(arguments['preco'])
crud.update(
{
"nome": nome,
"quantidade": qtd,
"horarioInicio": horIni,
"horarioTermino": horTer,
"data": data,
"endereco": end,
"preco": preco
}, "ingresso", "codigo = " + str(codigo))
ingresso = crud.select("*", "ingresso", "codigo = " + str(codigo))
return ingresso[0]
def venderIngresso(arguments):
codigo = arguments['codigo']
quantidade = arguments['quantidade']
crud.update({"quantidade": quantidade}, "ingresso",
"codigo = " + str(codigo))
ingresso = crud.select("*", "ingresso", "codigo = " + str(codigo))
return ingresso[0]
def main():
while True:
print(":=="*20)
print("\t\tCONSOLE CRUD WITH SQLITE3")
print(":=="*20)
print("[C]REATE NEW DATABASE")
print("[D]ROP DATABASE")
print("[U]SE DATABASE")
print("[E]xit")
print(":=="*20)
try:
opt = input('Select one option:\n')
if opt.upper() == 'C':
crud.clear()
db.createDB()
elif opt.upper() == 'D':
db.dropDB()
elif opt.upper() == 'U':
while True:
print("[1] Insert new record")
print("[2] Show all records")
print("[3] Update a record")
print("[4] Delete a record")
print("[5] Search a record")
print("[6] Exit")
print(":=="*20)
try:
option = int(input('Select a option:\n'))
if option == 1:
crud.clear()
crud.create()
if option == 2:
crud.clear()
crud.get()
if option == 3:
crud.update()
elif option == 4:
crud.delete()
elif option == 6:
crud.clear()
break
except:
print('Option invalid!')
elif opt.upper() == 'E':
break
except:
print('Option invalid!')
async def update(iD: str,
title: Optional[str] = None,
source: Optional[str] = None,
description: Optional[str] = None,
tags: Optional[str] = None,
language: Optional[str] = None,
author: Optional[str] = None,
likes: Optional[str] = None):
queries = {
'_id': iD,
'title': title,
'source': source,
'description': description,
'tags': tags,
'language': language,
'author': author,
'likes': likes
}
collection = {}
for k in queries.keys():
if queries[k] != None:
if k == 'likes':
collection[k] = int(queries[k])
else:
collection[k] = queries[k]
response = crud.update(collection)
if response:
return {"success": 1}
else:
return {"success": 0}
def entry():
req = {}
if request.method == 'POST':
req = request.json
crud.create(req["message"])
return req
if request.method == 'GET':
req = request.json
retrive = crud.retrive(req["message"])
return retrive
if request.method == 'PUT':
req = request.json
update = crud.update(req["_id"], req["message"])
return update
if request.method == 'DELETE':
req = request.json
crud.delete(req["message"])
return req
return req
def update():
jsonData = json.loads(request.data)
crud.update(jsonData)
response = jsonify(message="Carro atualizado")
return response
choice = input(
"Enter the number of the operation you would like to perform: ")
if choice == "1":
website_to_create = input(
"\nEnter the website for which you want the password to be created: "
)
password_to_create = input("Enter the password: "******"2":
website_to_read = input("\nEnter the name of the website: ")
read(website_to_read)
elif choice == "3":
website_to_update = input(
"\nEnter the website for which you want the password to be updated: "
)
password_to_update = input("Enter the new password: "******"4":
website_to_delete = input(
"\nEnter the website for which you want the password to be deleted: "
)
delete(website_to_delete)
elif choice == "5":
print("Goodbye!")
quit()
else:
print("Wrong username or password.")
quit()
import crud
from pprint import pprint
print '-'*80
print 'BEGIN Testing storage.MySQL.crud...'
crud = crud.Crud('store_test')
crud.query('SELECT * FROM session_data')
crud.insert('session_data', [('key1', 'val1', 'str', 'sess1', 1234567890), ('key1', 'val1', 'str', 'sess1', 1234567890), ('key1', 'val1', 'str', 'sess1', 1234567890)])
crud.insert('session_data2', [('key1', 'val1', 'str', 'sess1', 1234567890), ('key1', 'val1', 'str', 'sess1', 1234567890), ('key1', 'val1', 'str', 'sess1', 1234567890)])
pprint(crud.get('session_data', {'session_id2=': "'sess1'", '`key`=': "'key2'"}))
pprint(crud.get('session_data', {'session_id=': "'sess1'", '`key`=': "'key2'"}))
crud.delete('session_data2')
crud.delete('session_data')
crud.insert('session_data', data=[('key2', 'val1', 'str', 'sess1', 1234567890)])
crud.drop_tables()
crud.create_tables()
crud.insert('session_data', data=[('key2', 'val1', 'str', 'sess1', 1234567890)])
crud.update('session_data2', data={'value': 'val3'}, conditions=[{'session_id=': "'sess1'"}, {'utime=':str(1234567890)}])
crud.update('session_data', data={'value': 'val3'}, conditions=[{'session_id=': "'sess1'"}, {'utime=':str(1234567890)}])
print 'END Testing storage.MySQL.crud...'
print '-'*80
secondMenu = True
inner_decision2 = crud.take_decision()
while inner_decision2 not in range(1, 8) or None:
if inner_decision2 is None:
print("{}There is no option like that!{}".format(
colors["red_txt_black_bgr"], colors["white_txt"]))
inner_decision2 = crud.take_decision()
if inner_decision2 == 1:
crud.create()
elif inner_decision2 == 2:
crud.print_data()
elif inner_decision2 == 3:
crud.update()
elif inner_decision2 == 4:
crud.delete()
elif inner_decision2 == 5:
crud.count_age()
elif inner_decision2 == 6:
crud.count_gender()
elif inner_decision2 == 7:
skipFirst = False
secondMenu = False
else:
print(
"{}There was an error with loading a data file!{}".format(
colors["red_txt_black_bgr"], colors["white_txt"]))
if inner_decision == 2 and not secondMenu:
import crud as c
c.create_table()
c.insert('Glass',5,6.5)
c.update(10,45.6,'Lalla')
print(c.view())
#INSERINDO dados do BD
#sequencia: id, cpf, nome, nascimento, endereco, cidade, estado
values = [
"DEFAULT, '12345678911', 'joão pedro', '2019-03-05', 'R teste BD', 'python', 'ND'",
"DEFAULT, '12345678956', 'karem rodrigues', '2019-03-05', 'R teste BD', 'python', 'ND'"
]
tabela = 'alunos'
crud.insert(values, tabela, cursor, conn)
print(crud.select("*", 'alunos', cursor))
#############################################
#ATUALIZANDO dados do BD
#sequencia: tabela, sets, cursor, conexao, where(se existir)
crud.update("alunos", {
"nome": "Deidata Naruto",
"cidade": "Aldeia da Folha"
}, cursor, conn, "id_aluno = 2")
print(crud.select("*", 'alunos', cursor, "id_aluno = 2"))
############################################
#APAGANDO dados do BD
#sequencia: tabela, where, cursor, conexao
crud.delete("alunos", "cidade = 'Conceição do Ouros'", cursor, conn)
print(crud.select(
"*",
'alunos',
cursor,
))
def update(self, request, pk=None):
try:
uam_func_sync(request, c.strUAMLink, c.strAppName, c.strAppClient,
"File Manager ", "Update",
request.session.session_key,
request.META.get('HTTP_X_FORWARDED_FOR'))
except Exception as e:
logger.info(e)
user_name = request.user.first_name + request.user.last_name
try:
# request = dict(request.data)
param = {
'field': 'directory_id',
'label': 'Directory',
'user_name': user_name
}
# print "\n\n\n@@@@@@data @@",request.data
# payload = request.data
# #payload=serializer.data
# print "original data:%%%%%%%%,",payload
original_data = crud.get(self.table, c.all,
'where id=' + str(pk))[0]
# tags = crud.execute("select tag_id from file_manager_directory_tags where directory_id={}".format(pk))
# shared_ids = crud.execute("select id from file_manager_share where directory_id={}".format(pk))
# original_data.update({c.tags:list(tags and zip(*tags)[0]), 'shared_ids':list(shared_ids and zip(*shared_ids)[0])})
# logger.debug("Files:: get_parent_dirs: Parent Files{}".format(original_data))
# #try:
# payload.update({"id":pk})
# tags = payload.pop(c.tags)
# file_ids=payload.pop("file_ids")
# parent_id=payload.pop("parent_id")
# shared_ids = payload.pop("shared_ids")
# sub_directories=payload.pop("sub_directories")
# workflow_id=payload.pop(c.workflow_id)
# response = crud.update(self.table,payload )
# print "Response",response
param = {
'field': 'directory_id',
'label': 'Directory',
'user_name': user_name
}
original_data = crud.get(self.table, c.all,
'where id=' + str(pk))[0]
dir_obj = Directory.objects.get(id=pk)
serializer = DirectorySerializer(dir_obj, data=request.data)
if serializer.is_valid():
tag_details = self.tag_change(pk, request.data, "directory")
new_tag_ids = {}
old_tag_ids = {}
added_tag = tag_details.get("added_tag")
deleted_tag = tag_details.get("deleted_tag")
new_tag_ids.update(tag_details.get("new_tag_ids"))
old_tag_ids.update(tag_details.get("old_tag_ids"))
directory_update = request.data
for i in directory_update.keys():
if i in [
c.tags, 'parent_id', 'workflow_id', 'shared_dirs',
'file_ids', 'sub_directories'
]:
if i == c.tags:
update_tag = directory_update.pop(i)
else:
directory_update.pop(i)
directory_id = crud.update(self.table, directory_update)
if added_tag:
for tag in added_tag:
directory_tag_data = {
c.directory_id: directory_id,
"tag_id": new_tag_ids.get(tag)
}
crud.add(c.tag_dir_rel, directory_tag_data)
if deleted_tag:
for tag in deleted_tag:
try:
crud.execute(
"delete from file_manager_directory_tags where tag_id={} and directory_id={}"
.format(old_tag_ids.get(tag), pk), True)
except Exception as err:
return Response(err)
logger.debug("Files:: Serializer{}".format(request.data))
log_view = LogView()
original_data1 = {}
map(
lambda x: original_data1.update(
{str(x): original_data.get(x)}), original_data)
# original_data1.update({c.tags:old_tag})
current_data = request.data
current_data.update({'user_id': request.user.id})
ChangeTag = {}
if added_tag:
ChangeTag.update({
"Added": {
c.field: "Tag",
"tag": [Tag for Tag in added_tag],
"action": "Added"
}
})
if deleted_tag:
ChangeTag.update({
"Removed": {
c.field: "Tag",
"tag": [Tag for Tag in deleted_tag],
"action": "Removed"
}
})
log_view.generate_log(
current_data,
param,
original_data1,
self.track_fields,
ChangeTag,
)
return Response(
crud.get(self.table, c.all,
c.where_id_param.format(directory_id)))
else:
logger.debug("Files:: Serializer{}".format(serializer.errors))
return Response(serializer.errors)
except Exception as err:
return Response(err)
def update_quote():
if request.method == 'PUT':
quote = request.get_json()
return crud.update(quote)
