ortiga's questions

I create two tables in sql server as follows:

create table personas
(
    id int PRIMARY KEY not null identity,
    nombre_persona varchar(24)
)

create table coches
(
    nombre_persona int FOREIGN KEY REFERENCES personas(id) ON DELETE CASCADE,
    vehiculo varchar(24)
)

insert data:

insert into personas (nombre_persona) values ('juan')
insert into personas (nombre_persona) values ('jose')
insert into personas (nombre_persona) values ('aniceto')
insert into personas (nombre_persona) values ('raul')


insert into coches (vehiculo) values ('mercedes')
insert into coches (vehiculo) values ('seat')
insert into coches (vehiculo) values ('ferrari')
insert into coches (vehiculo) values ('porche')

but when doing the query of the car table I get the values ​​in null, I should put the person to whom each car belongs, not how do I do so that it appears?

select * from coches

nombre_persona    vehiculo
  NULL            mercedes
  NULL            seat
  NULL            ferrari
  NULL            porche

In sublime text the tabs accumulate and they have to be displayed with an arrow:

how to configure sublime so that the tabs are not hidden?

good I have the following function:

def http1(response):

    respone.????
    ...

I call it as follows, passing it a function that also receives a parameter

http1(http2(parametro))

My question is how do I get the parameter name of the http2 function so that I can work with it in the http1 function???

I am trying to access my database from outside but it does not leave me with the root user my server is debian 10 and my database is mysql 8 I have tried to give it permissions but it gives me the following error does anyone know what is happening??:

mysql> GRANT ALL PRIVILEGES ON * . * TO 'root'@'0.0.0.0';
ERROR 1410 (42000): You are not allowed to create a user with GRANT

I have the following array:

array = ['[email protected]','[email protected]','[email protected]']

and then I have a text file with the following:

[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]

How could I remove the elements in the text file from my array, that is, so that the file remains as follows:

[email protected]
[email protected]
[email protected]

I have the following array:

array = [['[email protected]'], ['[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]']]

How can I get the result out of this:

'[email protected]'
'[email protected]'
'[email protected]'
'[email protected]'
'[email protected]'
'[email protected]'

I have a python file with the following content:

file.txt

http://www.alhondigalaunion.es
http://www.alhondigalaunion.es
http://www.unicagroup.es
http://www.jcarrion.es
http://www.jcarrion.es
http://www.aceiteslapedriza.com
http://www.vicasol.com
http://www.medgaz.com
http://www.medgaz.com
http://www.medgaz.com

How could I remove the duplicates in python working directly on the file without deleting it? I'm trying with set but nothing I leave you the code:

 with open(file, 'r') as f2:
        for i in f2:
            array = set(f2)
            print(array)                   
            with open(file2, 'a+') as e:
                for a in array:
                    e.writelines(array[a]) + '\n') 

Hi, how can I change this?

c:>set

USERPROFILE=C:\Users\Administrador

to this:

USERPROFILE=C:\Users\Administrador\Desktop

I am testing with:

setx USERPROFILE "C:\Users\Administrador\Desktop"

but it still doesn't work can someone tell me how to change the value??

In linux it would be as easy as:

var = `command $url`
var = $ (command $url)

But in batch I am trying with a for but it is not taking me the content of the variable% URL%:

set URL=pagina.com:435435
for /f %%i in ('command  %URL%') do set TITULO=%%i

Does anyone know what's going on?

I have the following code:

#!/bin/bash

FSTAB=` grep -v "^#" /etc/fstab | grep . | grep -v "swap" | grep -v "UUID"   | awk '{print $1,$2,$3}'`

for i in $FSTAB
do
    echo "$i"
done

this returns me:

/dev/mapper/centos-root
/
xfs
/dev/sdb2
/hdos
xfs

The problem is that later I want to compare it, so it is returning it to me with line breaks and I want it to return it to me in a single line without breaks, that is to say:

/dev/mapper/centos-root / xfs /dev/sdb2 /hdos xfs

The command cat /etc/redhat-releasereturns:

 CentOS Linux release 5.6.1804 (Core)

How do I select only the 5?

i tried

 cat /etc/redhat-release | awk '{print $4}'

and it returns this:

5.6.1804

but I only want the first number.

I have the following file in centos:

I want the program to check if "computer" exists with a regular expression as it would be with the sed command ???

Hi, I have the following code:

 !/bin/bash

  while read line;
  do

  echo "$line";
   if[???????]
   fi

  done < /home/javi.log

javi.log file:

#

javi_2223
javi55_555
imp33
imp44
javi32423
javi5646

I want the script to comment the lines imp33 and imp44 I know what would be done with if but I don't know what to use to comment them...

It would be as follows:

#

javi_2223
javi55_555
#imp33
#imp44
javi32423
javi5646

if the file were like this: how would it be putting the :space it does not take it for me

javi_2223
javi55_555

#imp33
#imp44

javi32423
javi5646

I am making a desktop application and I want to display the value of a variable on the screen inside the quotes this is my code

 static void Main(string[] args)
    {

        int casa = 16;


        Console.WriteLine("variable {{casa}}");
        Console.ReadKey();
    }

It prints casano 16, it can be done by adding and the name of the variable but I want it inside the quotes, could it be done???

In my code I pass a number of lines that I want to take from the csv and then, for each line, iterates the elements that make up the csv but I am not getting it, I put the code

test.csv

gato,casa,http,antonio;
perro,abanico,https,libro;

C# class Program {

    static void Main(string[] args)
    {


        int contador = 0;
        int num_lineas;
        string[] array = null;


        var ruta = Directory.GetCurrentDirectory();

        ruta += "/articulo.csv";



        num_lineas = File.ReadAllLines(ruta).Length;



        array = File.ReadAllText(ruta).Split(';');

        while (contador < num_lineas)
        {


            while (true)
            {

                var a = array[contador].Split(',')[0];
                var b = array[contador].Split(',')[1];
                var c = array[contador].Split(',')[2];
                var d = array[contador].Split(',')[3];
                var e = array[contador].Split(',')[4];
                var f = array[contador].Split(',')[5];
                var g = array[contador].Split(',')[6];
                var h = array[contador].Split(',')[7];
                var i = array[contador].Split(',')[8];

                var imagen = array[contador].Split(',')[9];



                Console.WriteLine(c);



                Thread.Sleep(6000);
                break;

            }

            File.Replace(array[contador]); //aqui tengo que borrar la linea que esta dentro del archivo csv


            contador++;

        }





        Thread.Sleep(6000);


    }
}

}

I have modified it like this now I want to delete the first line of the csv any idea....

My problem is the following, I have a csv with two lines separated at the end by ; and each word separated by , such that:

test.csv

gato,casa,http,antonio;
perro,abanico,https,libro;

Now I want to select the first row and put each name in variables, for example string cat = cat that comes from the csv only from the first row and then the same with the second I have tried with this code but it is only getting the letters:

c#

   static void Main(string[] args)
    {

        int contador;
        string datos;


        var ruta = Directory.GetCurrentDirectory();

        ruta = ruta + "/prueba.csv";


        var lineas = File.ReadAllText(ruta);

        Console.Write(lineas.Split(';'));


            Console.ReadKey();



    }

How to know the name of the directory in which I run a powershell script? My code is as follows:

$usuario = $env:USERPROFILE

[Reflection.Assembly]::LoadFile("$usuario\Desktop\"nombre de la carpeta"\lib.dll")

I want to put a variable in the "folder name" that takes me the name of the current folder where I execute the script as it would be !!! I've looked with the environment variables but I can't find any that work for me.

It seems that the data from the page does not reach me, it opens, but it tells me that the value is null.

I have tried with idand neither, I am in version 5.1 of power shell.

This is the code:

  clear-host

  $ie = new-object -com "InternetExplorer.Application"


    $ie.navigate2("https://www.youtube.com/?hl=es&gl=ES")

    $ie.visible = $true

    $ie.Document.getElementsByTagName("input").value = "asdf"

And this is the error:

I'm trying to pass two parameters by url in angular 5 but it doesn't let me I'm doing it like this

 let administrador = this.usuario.admin

 let username = this.usuario.username

 this._http.get(`http://localhost/api/public/archivo/admin/${administrador},
 ${username}`,{headers:headers}).subscribe(data=>{

 }.....

Any solution ?

I have two tables joined like so

In my project Laravelwhat would be the relation that I would have to put in the model

<?php 

namespace App;

use Illuminate\Database\Eloquent\Model;

class Archivo extends Model
{

protected $fillable = [
        'ruta',
    ];

}