D. Albarracín's questions

In Acrobat PRO, when you open a PDF you can see the ink manager and its colors, like these:

I have a code in PHP with the TCPDF and Imagemagick libraries to create a PDF with two layers, and in each of them an image. But I need to add another color to this ink manager, is it possible to do that? I can't find much on it.

This is how I create the PDF:

$pdf = new TCPDF('L', 'mm');

$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);

$pdf->AddPage('L', array(60.4, 11.3));

And right after, I add the layers and the images. Is there a function that allows me to do what I need?

I have this regex:

sed "{
s/\(.*,\)\(yes\)\(.*\)/\1true\3/
s/\(.*,\)\(no\)\(.*\)/\1false\3/
/\(.*,\)[^yes-no],.*/d
}" student-mat.csv

But when I run it, it returns the following error:

sed: -e expresión #1, carácter 89: Final de rango inválido

I have modified this part: [^yes-no],for this other: [^yes|no],since it seems that the range was not detected correctly. In this way the error disappears but it does not make the change well.

The idea is that you modify all yesby trueand all noby false.

The structure of .csvthe is as follows:

school  sex age address famsize Pstatus Medu    Fedu    Mjob    Fjob    reason  guardian    traveltime  studytime   failures    schoolsup   famsup  paid    activities  nursery higher  internet    romantic    famrel  freetime    goout   Dalc    Walc    health  absences    G1  G2  G3
GP  F   18  U   GT3 A   4   4   at_home teacher course  mother  2   2   0   yes no  no  no  yes yes no  no  4   3   4   1   1   3   6   5   6   6
GP  F   17  U   GT3 T   1   1   at_home other   course  father  1   2   0   no  yes no  no  no  yes yes no  5   3   3   1   1   3   4   5   5   6
GP  F   15  U   LE3 T   1   1   at_home other   other   mother  1   2   3   yes no  yes no  yes yes yes no  4   3   2   2   3   3   10  7   8   10
GP  F   15  U   GT3 T   4   2   health  services    home    mother  1   3   0   no  yes yes yes yes yes yes yes 3   2   2   1   1   5   2   15  14  15
GP  F   16  U   GT3 T   3   3   other   other   home    father  1   2   0   no  yes yes no  yes yes no  no  4   3   2   1   2   5   4   6   10  10
GP  M   16  U   LE3 T   4   3   services    other   reputation  mother  1   2   0   no  yes yes yes yes yes yes no  5   4   2   1   2   5   10  15  15  15

When executing the command, it only modifies the last 2 values ​​it finds, but no others. How can I solve that?

I'm checking with JS if the route I'm on includes a state or not, to activate a CSS class. These states are looped through, and I check with:

window.location.href.includes(url.contains)

This url.containscan have different states (values), but I have two states which are: provisional-final-allegationand final-allegation.

Which are giving me problems because they are called almost the same, the difference is the provisional-one that goes at the beginning. And includes()he gives me both as valid, so they are activated at the same time.

Is there a way to make the method includes()strict and check exactly what is passed to it as a parameter? or any other method that can help me?

I am finishing an exercise, and I need to know what type each column of a CSV is (Integer, decimal, date...) through bash.

This is the part that displays the data type, but it doesn't work properly. Also it only shows if it is charor number. Is there any other way to simplify it?

 cat dataset_cars.csv | sed -rn '1p;2s/([^,][[:alpha:]]+[^,])+/(char)/g;2s/([^,][[:digit:]]+[^,])+/(num)/gp'

When I run it, it returns the following, it looks like it doesn't do it really well (it adds zeros, and parentheses where it shouldn't):

,price,brand,model,year,title_status,mileage,color,vin,lot,state,country,condition
0,(num),(char),(char),(num),(char),(num)0,(char), (char(num),(num),(char),(char),(num)char)

And the output I expect should be something like this:

Test data:

Columna1, Columna2, Columna3
prueba, 123, 123.89

Departure:

Columna1, Columna2, Columna3
texto, numerico, decimal

I am doing an exercise that says the following:

Make a boxplot of the mean age of the municipalities. What is the municipality with the highest average age?

And these are the columns that are used:

municipi = código postal del municipio y nombre del municipio,
edat = edad media de los habitantes del municipio,
pobl= número de habitantes del municipio,
prov = provincia a la que pertenece el municipio.

In R I do the boxplot like this:

boxplot(temp$edat)

Where tempis the variable where I store the .csv data and edatthe average of the municipalities. This returns me the following:

But they ask me to name the municipality with the highest average age. So try the following:

boxplot(temp$edat ~ temp$municipi)

And it returns it to me in this way, which for me is unreadable, in addition to the fact that it does not show all the municipalities:

Is there any other way to solve the exercise? Or at least know which is the municipality

I have an API from which I need to fetch two JSON, and the important one is this:

Relationships :

  {
    "id": 0,
    "source": {
      "id": 0
    },
    "target": {
      "id": 0
    },
    "type": 0
  }

The other brings some events with their labels, and from them I need the name and the ID.

The JSON of the relationships has a source IDand a target IDand a type. And it is used to create relationships between events.

To give an example: let's say I have two events with ID 1 and ID 2 and I want to create a relationship between them, so in source ID I add ID 1 and in target ID I add ID 2 and add a type (1, 2 or 3) to it . And with this you would have a relationship between event 1 with event 2.

Now, I have a table like this:

Where the header of the columns must be the total number of events, in this case there are 3 events. And in the rows the same. Let's say it's a table of nxn events.

The idea is an array where, for example, test event 2 has a relationship to and only test event 1 . Well, in that row there should be a 1 - -. The hyphen means that there is nothing, and the 1 the type of relationship.

To get a list of relations I have the following method:

  private getRelaciones(idRevision){
    this.relacionService.getRelaciones(idRevision).subscribe(
      (data:any) => {
        this.relaciones = data;
        console.log(this.relaciones);
      }
    );
  }

And I am storing the data here:relaciones: any[] = [];

I call the method in the ngOnInit:this.getRelaciones(this.idRevision);

I have the API call method in a Service class:

  getRelaciones(idRevision: string){
    return this.http.get(`${this.URL}/relation?revisionId=${idRevision}`,this.OPCIONES);
  }

But I can't display the data that way, and I've been working on this for many hours.

This is how I have the table right now:

<table class="table table-bordered">

    <thead>
        <tr>
            <th scope="col"></th>
            <th *ngFor="let evento of eventos" scope="col">{{evento['name']}}</th>
        </tr>
    </thead>

    <tbody *ngFor="let evento of eventos">
        <tr>
            <td><b>{{evento['name']}}</b></td>
            <td *ngFor="let relacion of relaciones">{{relacion['type']}}</td>
        </tr>
    </tbody>

</table>

But it shows me the repeated values ​​in each row. Before I had very messy checks, and I've been deleting and editing code for a whole day. Any way to do it?

EDIT 07/09

Applying Legna's answer:

<table class="table table-bordered">
    <thead>
        <tr>
            <th></th>
            <th *ngFor="let evento of eventos" scope="col">{{evento['name']}}</th>
        </tr>
    </thead>
    <tbody>
        <tr *ngFor="let relacion of relaciones">
            <th scope="row">{{getNameEvent(relacion['source']['id'])}}</th>
            <td *ngFor="let evento of eventos">
                {{evento['id'] === relacion['target']['id'] ? relacion['type'] : "--" }}
            </td>
        </tr>
    </tbody>
</table>

By changing the order of each iteration I've managed to get a good part of it working:

Well the headers are displayed as they should be, and the content of each cell fits perfectly. But I have the problem: As seen in the image, test event 2 has 2 relations, but it is seen in duplicate. You should see a single row with your relationship type. How do I fix this?

Event:

  {
    "id": 0,
    "code": "string",
    "name": "string",
    "description": "string",
    "image": "string",
    "category": 0,
    "revision": {
      "id": 0
    }
  }

So I load the list of events from the API, in the ngOnInit:

  private cargarEventos(idRevision: string){
    this.eventoService.getEventos(idRevision).subscribe(
      (data: any) => {
        this.eventos = data;
      }
    );
  }

To obtain a list of events, it is necessary to pass an ID of a review as a parameter, but you do not have to pay attention to this.

As I have mentioned in the answer, a relation is made up of two event IDs ( sourceand target) and a type.

Real data:

EVENT DATA:

[ {
    "id": 1,
    "code": "code-007",
    "name": "Evento ejemplo 1",
    "description": "Descripcion cualquiera...",
    "image": "no-img",
    "category": 7
  },
  {
    "id": 2,
    "code": "code-016",
    "name": "Evento ejemplo 2",
    "description": "Descripcion cualquiera...",
    "image": "no-img",
    "category": 10
  },
    {
    "id": 3,
    "code": "code-021",
    "name": "Evento ejemplo 3",
    "description": "Descripcion cualquiera...",
    "image": "no-img",
    "category": 3
  },
    {
    "id": 4,
    "code": "code-089",
    "name": "Evento ejemplo 4",
    "description": "Descripcion cualquiera...",
    "image": "no-img",
    "category": 12
  },
    {
    "id": 5,
    "code": "code-0227",
    "name": "Evento ejemplo 5",
    "description": "Descripcion cualquiera...",
    "image": "no-img",
    "category": 1
  },
    {
    "id": 6,
    "code": "code-007",
    "name": "Evento ejemplo 6",
    "description": "Descripcion cualquiera...",
    "image": "no-img",
    "category": 10
  },
    {
    "id": 7,
    "code": "code-097",
    "name": "Evento ejemplo 7",
    "description": "Descripcion cualquiera...",
    "image": "no-img",
    "category": 80
  }
]

RELATIONSHIP DATA:

[
  {
    "id": 1,
    "source": {
      "id": 1
    },
    "target": {
      "id": 2
    },
    "type": 2
  },
    {
    "id": 2,
    "source": {
      "id": 2
    },
    "target": {
      "id": 4
    },
    "type": 1
  },
    {
    "id": 3,
    "source": {
      "id": 1
    },
    "target": {
      "id": 5
    },
    "type": 3
  },
    {
    "id": 4,
    "source": {
      "id": 5
    },
    "target": {
      "id": 6
    },
    "type": 0
  }
]

I leave you a list of 7 events and 4 relations as if they came to me from the API, that is the data that I have access to show. I must show the name of each event as headers, both in rows and in columns. So it would be a 7x7 table in this case.

I have a login via Token made with Angular. Once I log in (with the correct data) I navigate to another window like this:

this.router.navigateByUrl('grupo');

And I also keep the access_token and the expire_in in the localStorage . But if instead of logging in I just change the path in the url I can also login.

I need to add this security, that until you log in you cannot navigate to another tab in any case. But how would this be done?

This is the post method I have:

this.http.post(this.url,this.login,opciones)
.subscribe(
  data => {
    if(data){

    this.TOKEN = data["access_token"];
    this.EXPIRES = data["expires_in"];

    localStorage.setItem('TOKEN',this.TOKEN);
    localStorage.setItem('EXPIRE_IN', this.EXPIRES);

    this.router.navigateByUrl('grupo');

  }
},
  error => alert("Fallo de sesion")
)

And these are the options for the POST:

const opciones = {
  headers: new HttpHeaders({
    'Content-Type':'application/x-www-form-urlencoded',
    'Authorization': '--lo que sea--'
  }),
  params: parametros
};

I am trying to login using tokens in Angular. For this I need to send the username and password through the POST method including header and parameter.

These are the header and parameters:

'Content-Type','application/x-www-form-urlencoded'
'scope','...lo que sea...'
'grant_type', 'password'
'Authorization','... lo que sea...'

But I don't know how to include this data in the POST so that it returns the access_token and the other fields.

I have tried the following:

let cabecera = new HttpHeaders();
let parametros = new HttpParams();

cabecera.set('Content-Type','application/x-www-form-urlencoded').set('Authorization','...');
parametros.set('grant_type', 'password');
parametros.set('scope','...');

let opciones = {
  headers: cabecera,
  params: parametros
}

this.http.post(this.url,opciones).subscribe(data =>{
  console.log(data);
})

But the username and password will not be added in this way for verification. And it returns errors.

I have to perform a series of unit tests, and I'm just starting and I'm not sure how to do them.

I have an interface IPersonawith some methods, and the one I am testing is this:

string nombreCompleto();

And the class Personais like this:

    private string nombre;
    private string apellido;
    private int edad;
    private int kmRecorridos;
    private bool vivo;
    private Persona pareja;

    public Persona()
    {
        this.nombre = "";
        this.apellido = "";
        this.edad = 0;
        this.kmRecorridos = 0;
        this.pareja = null;
        nacer();
    }

    public Persona(string n, string a, int e)
    {
        this.nombre = n;
        this.apellido = a;
        this.edad = e;
        this.pareja = null;
        this.kmRecorridos = 0;
        nacer();
    }

    public string nombreCompleto()
    {
        return "Nombre Completo: " + this.nombre + " " + this.apellido;
    }

I am doing the test in the following way, but I have tried some things and I don't know how to make it successful:

    [TestMethod]
    public void TestMethod1()
    {
        var mockPersona = new Mock<IPersona>();

        mockPersona.Setup(x => x.nombreCompleto()).Returns("Nombre completo " + "" + " " + "");

        IPersona persona = (IPersona) new Persona();           

        Assert.AreEqual(persona.nombreCompleto(), ((IPersona) mockPersona.Object).nombreCompleto());
    }

I'm trying to fully understand the MVVM topic, and some of its methods. I have seen the method RaiseProperty()in two different ways and I don't understand what the difference is.

This would be one:

    public void RaiseProperty([CallerMemberName] string propertyName = "")
    {                       
    }

And the other directly does not have the [CallerMemberName].

I've been reading about it [CallerMemberName]and it says it's to receive the name of the method that calls it.

And one of my doubts: Why know the name of the method that invokes it?

Then another thing that I don't quite understand is what is incorporated, in this case, by the method RaisePropertyin my exercise:

    public void RaiseProperty([CallerMemberName] string propertyName = "")
    {            
        PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(propertyName));            
    }

What is it doing ?, and what is it used for .Invoke()?

I'm doing some LINQ exercises, where I have to do some queries on a .json file . I need it to show Manufacturers and Models that are the color "Fuscia".

Json format:

{"id":1,"Maker":"Mercedes-Benz","Model":"SL-Class","Year":null,"Color":null,"Location":{"Latitude":null,"Longitude":null}}

I have created a class to be able to pass to List<>this .json, looking like this:

class Cars
{
    public string Maker { get; set; }
    public string Model { get; set; }
    public int Year { get; set; }
    public string Color { get; set; }
    public double Location { get; set; }
    public double Latitude { get; set; }
    public double Longitude { get; set; }
}

In the mainI call and create the List<>as follows:

        string archivoJ = File.ReadAllText("Cars.json"); //Cargamos el archivo.

        List<Cars> coches = JsonConvert.DeserializeObject<List<Cars>>(archivoJ); //Creamos una lista con el json.

And in my method where I must execute the Query:

    static void Ejer4(List<Cars> lc)
    {
        var fm = lc.Where(x => x.Color == "Fuscia").Select( y => new { Fabricante = y.Maker, Modelo = y.Model });

        foreach(var i in fm)
        {
            Console.WriteLine($"Fabricante: {i.Fabricante} Modelo: {i.Modelo}");
        }
    }

But when executing, I get the following exception, marking the position of JasonConvert:

Newtonsoft.Json.JsonSerializationException: 'Error converting value {null} to type 'System.Int32'. Path '[0].Year', line 1, position 63.'

In the class CarsI have tried to change the data types to stringall, but it is still the same. How can I prevent it from converting the types null?

!Good!

I'm doing a little test on files in Java.

Try to write words until the user enters "EXIT". Everything that has been written must be saved in a file and created.

It happens that it only writes the last word in the file and ignores the others. I think it's overwriting every word I type. This is the code:

import java.io.BufferedWriter;
import java.io.FileNotFoundException;
import java.io.FileWriter;
import java.io.IOException;
import java.util.Scanner;

public class Parte1 {

    public static void main(String[] args) throws IOException {

        String palabra;     
        Scanner sc = new Scanner(System.in);

        do {

            System.out.print("Introduce una palabra (SALIR para salir): ");
            palabra = sc.nextLine();

            EscribirFichero(palabra);

        }while(!palabra.equals("SALIR"));

        System.out.println("Fichero creado");
        sc.close();

    }//FIN MAIN.


    public static void EscribirFichero(String palabra) throws IOException {

        FileWriter fichero = null;
        BufferedWriter buffer = null;

        try {

            fichero = new FileWriter("C:/Users/Daniel/Desktop/Parte1.txt");
            buffer = new BufferedWriter(fichero);                                   

            buffer.write(palabra);

        } catch (FileNotFoundException e) {

            System.out.println("Archivo no encontrado. Cambia la ruta");
        }

        if(palabra.equalsIgnoreCase("salir")) {

            buffer.close();
        }   
    }
}

I have a question regarding C# properties with this line:

public int Ataque { get; set; }

Does this also create a variable ataque? Or is it just to shorten the getand set. And it should be placed like this:

int ataque;
public int Ataque { get; set; }

Because I have been told that by style guide, the properties have to be in uppercase, and the variables in lowercase. And that bothers me a bit...

!Good!

I have a simple piece of code that I can't understand very well what is happening...

    static void Main(string[] args)
    {
        string cadena = "lore";

        for(int i=0; i<1000000; i++)
        {
            cadena += "lore";
        }
        Console.WriteLine(cadena);
    }

What it does is easy to figure out. Simply chain the word in the variable a million times and then it should display it on the console.lorecadena

I highlight the should because it doesn't. And this is what I don't understand, why doesn't it show the result, and keep the program running? And how can I make it show it?

I have tried to give it a spin... And the logic that I find is that it exceeds the limit of characters that a can have string, but since no type of exception is thrown, it makes me doubt.

Any idea why this happens, and how to fix it?

!Good!

I am trying to access the Android SDK Manager in Visual Studio, for Xamarin.

When I try to run it, I get a window telling me:

Cannot find adb.exe in the specified SDK path

This is the path where it should be in theory:

C:\Program Files (x86)\Android\android-sdk

I have gone to check that this adb.exe is in the folder, but it is not. If I go to the specified path, there is nothing about it. I've tried looking for a way to install or reinstall this, but can't find anything to help.

How could I fix it?

!Good!

I am studying, and preparing for the OCA Java 8 certification. There is a sample question that I don't quite understand... Which gives me this piece of code:

abstract class Writer {
 public static void write() {
 System.out.println("Writing...");
 }
}
class Author extends Writer {
 public static void write() {
 System.out.println("Writing book");
 }
}
public class Programmer extends Writer {
 public static void write() {
 System.out.println("Writing code");
 }
 public static void main(String[] args) {
 Writer w = new Programmer();
 w.write();
 }
}

And I have to choose the correct answer among these, to know what the result of the program would be:

A) Writing... B) Writing book C) Writing code D) Compilation fails.

According to the results provided by Oracle, the correct one would be A .

But why?

I thought it was C , but apparently not...

EDIT

I answer C , because maineven though a class object is being created in Writerit, a type is being stored Programmer, and therefore it should take the Writing code. Although it is true that the methods do not lead @override, but I did not know to what extent it can influence.

!Good!

I am doing an exercise on Relational Objects in Database. The truth is that I am a bit lost, and I need to insert some data in a table that I have created in the following way:

CREATE TABLE empleados OF Empleado(
idEmpleado PRIMARY KEY);

And the object type is this:

CREATE OR REPLACE TYPE Empleado AS OBJECT(
idEmpleado NUMBER,
nombre VARCHAR(20),
apellidos VARCHAR(20),
salario NUMBER,
vencargado REF Encargado,
MAP MEMBER FUNCTION ordenarID return NUMBER,
MEMBER FUNCTION encargadoEmpleado return Encargado);
CREATE OR REPLACE TYPE BODY Empleado
AS
MAP MEMBER FUNCTION ordenarID return NUMBER
IS
BEGIN
RETURN idEmpleado;
END;
END;

Where the attribute of vencargadocomes from this other object type:

CREATE TYPE Encargado AS OBJECT(
idEncargado NUMBER,
nombre VARCHAR(20),
apellidos VARCHAR(20),
cargo VARCHAR(20),
MAP MEMBER FUNCTION ordenarID return NUMBER,
MEMBER FUNCTION empleadosCargo return NUMBER);
CREATE TYPE BODY Encargado
AS
MAP MEMBER FUNCTION ordenarID return NUMBER
IS
BEGIN
RETURN idEncargado;
END;
END;

I have tried to add some data to the employees table and this error has occurred to me, and I don't know how to enter the values:

inconsistent data types: expected REF got NUMBER

I have added them like this:

INSERT INTO empleados VALUES ( Empleado(1,'Juan','Rodriguez',1600,1));

If someone can guide me, it would be very helpful. Thanks.

!Good!

I'm trying (in a very simple code) that when the user writes a letter or word in a variable that expects a numeric type , catch the error with a try catchand repeat to the user to enter some number.

For example, as in this code, to serve as an explanation...

   import java.util.Scanner;

public class Test {
    public static void main(String[] args) {

        Scanner sc = new Scanner(System.in);

        int numero1;
        int numero2;
        int total;

        do {

            try {

                System.out.print("Introduce numero 1: ");
                numero1 = sc.nextInt();

                System.out.print("Introduce numero 2: ");
                numero2 = sc.nextInt();

            } catch (Exception ex) {

                System.out.println("No es un numero. Toma como valor 0. Repite");

                numero1 = 0;
                numero2 = 0;
            }

            total = numero1 + numero2;

            System.out.println("Total: " + total);

        } while (total <= 0);

    }
}

My idea is that when entering a non-numeric data , it collects the error and, in this case, prints a message and gives both variables a value: 0 . For so, the total is equal to 0 , and the loop is activated.

But with this example it becomes an infinite loop, and I'm not understanding why, nor how to do what I want.

I would like to know if the way I want to solve it is possible, or if there is any alternative...

All the best :)

!Good!

I am doing this exercise:

When inserting or modifying a vendor, make sure that the id does not match any customer id. If it matches, it will be inserted, but it will be recorded in a new table as a log.

Where the relational model looks like this:

Clientess (id, nombre)
Vendedores (id, nombre)
Ventas (id_clienteFK, id_vendedorFK, importe, fecha)
tabla_log(id,tipo,descripción)

And trying to perform the exercise, I'm trying with this solution:

CREATE OR REPLACE TRIGGER insertar_vendedor BEFORE INSERT OR UPDATE
ON vendedores
DECLARE 
idCliente number;
BEGIN
select id into idCliente from clientess where clientess.id = :new.id;
if (idCliente%FOUND) then
INSERT INTO tabla_log values (1,'insertar','Se ha insertado un vendedor');
ELSIF (idCliente%NOTFOUND) THEN
DBMS_OUTPUT.PUT_LINE('No hay conincidencia');
END if;
END;

But this error has popped up, and the truth is that I'm starting with Triggers and I'm pretty lost... Let's see if someone knows how to structure this exercise.

Mistake:

I create a variable of type int and I give it a value of, for example, "06" or some other value with a "0" in front, and this should show an error because if it is an integer it cannot have a zero to the left, but everything works fine. On the other hand, if we give it the value: "08" or "09", you get an error indicating that it is out of range.

The error should mark it with the entire sequence from "01" to "09", why only with "08" and "09"?

public static void main( String[] args ) {
  int test = 08;
}

The literal 08 of type int is out of range