I want that when you try to do an INSERT, but the value of a specific variable is already registered, it shows an error.
For example: | user | e-mail | | -------- | -------------- | | Joseph | [email protected] | | Rex | [email protected] |
If I enter this code it should show an error because the value is already assigned to a user.
INSERT INTO `users` (`usuario`, `email`) VALUES ("Eduardo", "[email protected]");
I hope I explained myself well, I'm new and this would help me a lot.
I have this class component and I need to apply this code in a functional component, I don't know how to convert the state using useState. My question is if I have to generate two states or in one I can only pass the object and the empty array. How would the state...
Since I need to add an empty array to move the elements to that new array and here, from what I see, everything is in a single state, both the data and the empty array. How can I transform that to a functional component
import React, { Component } from 'react'
import { ReactSortable } from "react-sortablejs";
export default class List2 extends Component {
state = {
list: [
{ id: "1", name: "shrek" },
{ id: "2", name: "Nelson" },
{ id: "3", name: "Prueba" }
],
list2: []
};
render() {
return (
<div class="container">
<div className="row align-items-start ">
<div className="col bg-success">
<h6 className="text-center">lista 1</h6>
<ReactSortable
list={this.state.list}
setList={newState => this.setState({ list: newState })}
group="shared-group-name"
>
{this.state.list.map(item => (
<div key={item.id}>
<div className="card m-3 cursor-draggable" >
<div className="card-body">
{item.name}
</div>
</div>
</div>
))}
</ReactSortable>
</div>
<div class="col bg-danger">
<h6 className="text-center">lista 2</h6>
<ReactSortable
list={this.state.list2}
setList={newState => this.setState({ list2: newState })}
group="shared-group-name"
>
{this.state.list2.map(item => (
<div key={item.id}>
<div className="card m-3 cursor-draggable" >
<div className="card-body ">
{item.name}
</div>
</div>
</div>
))}
</ReactSortable>
</div>
<div className="col mt-3">
<h6>Puedas intercambiar datos entre la lista 1 y 2</h6>
</div>
</div>
</div>
)
}
}
I have this problem when capturing the error:
try:
ack_event = PlatformEvent(
notification_event_id=event['detail']['originalEvent']['id'],
source=event['source'],
event_type=event['detail']['originalEvent']['detail']['eventType'],
region=event['region'],
timestamp=event['time'],
organization_id=self.get_notification_event_organization_id(event['detail']['originalEvent']),
success=event['detail']['success'],
result=event['detail']['result'],
event_json=event,
)
ack_event.save()
self.logger.info(f"Saved Acknowledgement Event: {event}")
return self.create_http_response(True, status_code=200)
except Exception as e:
msg_event = f"Error saving acknowledgement event: {event}"
msg_error = f"Error: {e}"
the message that I capture in the Exception as "e" if in the event that I receive there is a wrong property such as "originalEvent" the exception only captures the string "originalEvent" without detail of what the error is. Would there be a way to capture the error in more detail or what would I be doing wrong in this block? Thank you
I have a form to edit an incident, when I touch the "Edit" button, a modal appears to confirm the sending of the form, so far so good. The problem is that now I need to create a checkbox in the confirmation modal to send notifications if they mark it and I need to get both the form information and the checkbox information in my view, but it is not working for me.
#Form that calls the modal
<form method="post" name="editar_inc" novalidate="novalidate">
<div class="card-body">
{% csrf_token %}
{% include 'incidencia/form_editar_incidencia.html' %}
<div class="row justify-content-md-center">
<div class="col col-lg-2">
<button type="button" title="Editar" id="editar_modal" class="btn btn-block btn-primary" data-toggle="modal" data-target="#modal-default">
Editar
</button>
</div>
<div class="col col-lg-2">
<a type="button" href="{% url 'incidencia:listar_incidencias' %}" class="btn btn-block btn-danger">
Cancelar
</a>
</div>
</div>
</div>
#Modal
<div class="modal fade" id="modal-default">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title">Confirmar modificación</h4>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<p>¿Está seguro(a) que desea modificar la incidencia "{{ titulo }}"?</p>
<form action="" method="post" novalidate="novalidate">
{% csrf_token %}
<div class="icheck-primary d-inline">
<input name="notificar" type="checkbox" id="check_notificar_update">
<label for="check_notificar_update">
¿Desea notificar los cambios realizados a los contactos correspondientes?
</label>
</div>
</form>
</div>
<div class="modal-footer justify-content-between">
<button type="button" class="btn btn-default" data-dismiss="modal">Cerrar</button>
<input type="submit" onclick='document.editar_inc.submit();' class="btn btn-primary" value="Aceptar">
</div>
</div>
</div>
In a .txt there are several DNIs, what I want to do is use the grep filter command to get the DNIs that have 9 numbers and 1 letter. I've tried this command but it doesn't work:
INSIDE THE FILE:
123456789A
31232g
42344324f
324f
4554345345345g
234452l
INSTRUCTION I HAVE USED:
cat nif.txt|grep -E "[[:digit:]]{9}[[:alpha:]]{1}"
123456789A
4554345345345g
I get the wrong ID and that's what I don't want it to do. Thanks in advance