Fabian's questions

I need to make a regular expression that will help me format a number in this way.

Example: We have this number222345678

I need an expression that can do this:22 234 5678

That is, after the first 2 numbers add a space, then add one after the next 3 and the last block is 4 numbers.

I currently have something like this:number.toString().replace(/\d{4,4}?(?=...)/g, "$& ")

Which only separates them every 4.

I have searched for an expression that does the same thing but I can't find anything, does anyone know how to do it? Beforehand thank you very much.

I have a little doubt, I have a status like this

const [searchItems, setSearchItems] = useState({
    videos: [],
    texts: [],
    audios: []
});

My idea is to push these arrays inside the object searchItems, if it were pure javascript it would be something likeseachItems.videos.push(object)

but being a state with useState, I must make use of thesetSearchItems

Does anyone know how to do it ?

i have something like

setSearchItems({
    videos: test_search.videos.filter(video =>
        video.name.includes(search)
    )
});

but it doesn't work well at all.

I managed to fix it, but now I have another problem. I have this code

useEffect(() => {
    if (showVideos) {
        setSearchItems({
            ...searchItems,
            videos: test_search.videos.filter(video =>
                video.name.includes(search)
            )
        });
    }
    if (showTexts) {
        setSearchItems({
            ...searchItems,
            texts: test_search.texts.filter(text =>
                text.name.includes(search)
            )
        });
    }
    if (showAudios) {
        setSearchItems({
            ...searchItems,
            audios: test_search.audios.filter(audio =>
                audio.name.includes(search)
            )
        });
    }
    // eslint-disable-next-line react-hooks/exhaustive-deps
}, [search, showVideos, showTexts, showAudios]);

The problem is that it is only assigning the last one, in this case the audios, the others are left empty, how could I solve this?

Beforehand thank you very much.

I have an array for example this

javascript

[
    {
        "nombre": "nombre 1",
        "score": 10
    },
    {
        "nombre": "nombre 2",
        "score": 10
    },
    {
        "nombre": "nombre 3",
        "score": 10
    },
    {
        "nombre": "nombre 4",
        "score": 10
    },
    {
        "nombre": "nombre 19",
        "score": 8
    },
    {
        "nombre": "nombre 43",
        "score": 6
    },
    {
        "nombre": "nombre 87",
        "score": 3
    },
    {
        "nombre": "nombre 99",
        "score": 1
    }
]

Which I am ordering by score, using lodash like this:

_.orderBy(data, ['score'], ['desc'])

As you can see nombre 1, nombre 2, nombre 3and nombre 4have the same score, but when ordering it, nombre 1it is always higher than nombre 2, 3and 4, my idea is to order them by score, but those with the same score are not always in the same place

for instance

[
    {
        "nombre": "nombre 2",
        "score": 10
    },
    {
        "nombre": "nombre 3",
        "score": 10
    },
    {
        "nombre": "nombre 1",
        "score": 10
    },
    {
        "nombre": "nombre 4",
        "score": 10
    }
]

either

[
    {
        "nombre": "nombre 3",
        "score": 10
    },
    {
        "nombre": "nombre 1",
        "score": 10
    },
    {
        "nombre": "nombre 4",
        "score": 10
    },
    {
        "nombre": "nombre 2",
        "score": 10
    }
]

I don't know if I'm explaining myself well, but does anyone know how I can achieve this? My regards and thank you very much.

I have been trying to make a regular expression in javascript to get the text between 2 brackets for example

[descripcion] Esta es una descripcion [/descripcion]

Which should return "This is a description"

I have been testing with this(\Q[descripcion]\E)(\X*)(\Q[/descripcion]\E)

But nothing at all, can someone help me with the expression ?

Another thing, the full text without filtering is like this

[descripcion] La Descripcion [/descripcion][ingredientes] Los ingredientes [/ingredientes][sabor] Sabor [/sabor][aroma] Aroma [/aroma][tiempo]3-5 min[/tiempo][temperatura]80°[/temperatura][cantidad]2,5g/250ml[/cantidad][preparacion] Preparacion [/preparacion][pais]China[/pais][contenido][/contenido][modouso][/modouso]

I just want what's inside[descripcion] esto [/descripcion]

Many thanks

I have 2 tables, 1 of students and another called student_registration

I need to make a select from the students table, get their id and with that id enter the student_matricula table and show the enrollment number

the students table is like this:

id string,
nombres string,
direccion string,
edad int

and the student_registration table is like this

alumno_id,
numero_matricula,
fecha_matricula

I need to show the name of the student and his registration number

for instance

David 2832-1234

I tried to do it with a select from join but it doesn't work this way

SELECT e.nombres, e.id 
FROM alumnos e JOIN alumno_matricula e2 SELECT e2.numero_matricula WHERE e.id = e2.alumno_id

I am trying to create a query to delete some data from a table called branch, but at the time of deleting it, I must also delete the relationships that exist exactly with that data.

i am doing something like this.

UPDATE empleado SET numSucursal = 0 WHERE numSucursal = 2;
DELETE FROM sucursal WHERE numSucursal = 2;

It works but I think it's wrong to do it this way.

the tables are these

CREATE TABLE IF NOT EXISTS sucursal(
    numSucursal int PRIMARY KEY NOT NULL,
    nombre VARCHAR(100) NOT NULL,
    direccion VARCHAR(100) NOT NULL
);

and this

CREATE TABLE IF NOT EXISTS empleado(
    numEmpleado int PRIMARY KEY NOT NULL,
    nombre VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL,
    sueldo bigint NOT NULL,
    fContratacion DATE NOT NULL,
    numSucursal int,
    jefe int NULL,
    CONSTRAINT fkjefe
    FOREIGN KEY (jefe) REFERENCES empleado(numEmpleado),
    CONSTRAINT fksucursal
    FOREIGN KEY (numSucursal) REFERENCES sucursal(numSucursal)
);

The error arises when I try to delete the row, it tells me ERROR 1451: 1451: Cannot delete or update a parent row: a foreign key constraint fails

I haven't been able to find the solution.

I need your help, thank you very much.

I have these tables:

CREATE TABLE IF NOT EXISTS sucursal(
    numSucursal int PRIMARY KEY NOT NULL,
    nombre VARCHAR(100) NOT NULL,
    direccion VARCHAR(100) NOT NULL
);

and this:

CREATE TABLE IF NOT EXISTS empleado(
    numEmpleado int PRIMARY KEY NOT NULL,
    nombre VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL,
    sueldo bigint NOT NULL,
    fContratacion DATE NOT NULL,
    numSucursal int,
    jefe int NULL,
    CONSTRAINT fkjefe
    FOREIGN KEY (jefe) REFERENCES empleado(numEmpleado),
    CONSTRAINT fksucursal
    FOREIGN KEY (numSucursal) REFERENCES sucursal(numSucursal)
);

I have to show the average salary of each branch, but I can't find a way to do it, I know how to get the average, but not how to link the employees to a branch exactly.

When creating an employee, I assign the branch number to the field numSucursalas fk , but the rest does not work for me.

Please help, thank you very much.

I explain, I have a table called employee

CREATE TABLE IF NOT EXISTS empleado(
    numEmpleado int PRIMARY KEY NOT NULL,
    nombre VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL,
    sueldo bigint NOT NULL,
    fContratacion DATE NOT NULL,
    numSucursal int,
    jefe int NULL,
    CONSTRAINT fkjefe
    FOREIGN KEY (jefe) REFERENCES empleado(numEmpleado),
    CONSTRAINT fksucursal
    FOREIGN KEY (numSucursal) REFERENCES sucursal(numSucursal)
);

I have to do a select showing the name, the salary, the date of hiring and the name of the boss.

My problem is that when I show the boss his id appears (numEmpleado)

How can I show the name of the boss?

I have this select

SELECT nombre, sueldo, fContratacion, jefe FROM empleado;

but instead of the id of the boss I should display his name.

I saw that I can create a view, or a select with join, but it doesn't work for me :(

• Hello, I have the following problem, install CKEDITOR on a web with django that I am doing, and when I publish a post, the post appears on the web but with the tags

  visible, in this way (I leave an image)

• How can I make those html tags disappear? Inspecting the source code from the browser you see this (I leave an image)

I need that when viewing from the web those labels are not seen.

Thank you so much.