gmarsi's questions

I am developing with Django (2.2) on Ubuntu using an Apache server. How can I show, and always update, the server log record?

By not using python manage.py runserverthe logs, the logs do not appear automatically in the terminal and, every time I want to look at the logs, I have to close and reopen the file to see it updated

From a text created in a <textarea>, I need to be able to access those links that have been introduced.

For example, I enter:

Lorem ipsum dolor, sit amet consectetur adipisicing elit. https://www.stackoverflow.com Beatae eum nobis distinctiveo sapiente maxime ex dolorum, fuga voluptas architecto

https://www.stackoverflow.com

https://www.stackoverflow.com

Asperiores voluptatibus cupiditate sequi incident aperiam. https://www.stackoverflow.com Repellat recusandae quas eos error?

(The Stackoverflow editor already detects them automatically, but let's imagine it's plain text)

How could I, from the plain text, change the text link and turn it into a label <a>to display it in a Django template?

I thought maybe you could search the text for the link with a regex and replace it, but I don't know how to do it. Of course, the regex that I have tried and that works is

regex = r'http[s]?://(?:[a-zA-Z]|[0-9]|[$-_@.&+]|[!*\(\),]|(?:%[0-9a-fA-F][0-9a-fA-F]))+'

Please read the question before marking it as repeated, thanks.

What I need is that if there are duplicate elements in the array, remove them all. The array is something similar to this:

var array = [[1,2],
             [2,3], // repetido
             [3,4],
             [4,5],
             [2,3], // repetido
             [5,6],
             [6,7], // repetido
             [6,7], // repetido
             [7,8]]

so it would be like this:

var array = [[1,2],
            [3,4],
            [4,5],
            [5,6],
            [7,8]]

In the array there can be a minimum of 1000 values, so nesting a for loop in another, and checking value by value is not efficient, the browser closes and the processor is set to 90%

I want to change the font size of the 'ticks' of a chart. At the moment I am using the following instruction to change it only to the graph that I am going to show

plt.tick_params(labelsize = 20)

But just like with

plt.rcParams["figure.figsize"] = [20,10]

I can change the size of all the graphs that I generate, is there something similar to change the font size of the ticks of all the graphs that I generate?

I am working with a table that indicates the Number of the day, the hour of the day and a number of visits

And I want to create a bar graph that indicates the number of visits per hour (like the one in the image)

But how can I also indicate the hours in each bar? Something similar to what I have done with paint, but at all times, of course.

I am working with a CSV file. One of the columns is in string format and I want to convert it to type float . I have created a function that removes commas and currency symbols. But the value, when returned by the function, is automatically replaced directly in the variable that contains all the information of the CSV file and it throws me an alert:

A value is trying to be set on a copy of a slice from a DataFrame

With the code it will be clearer:

import pandas as pd
import numpy as np
import os

mainPath = 'C:/Users/Marcos/Documents/'
filePath = './resultados.csv'
fullPath = os.path.join(mainPath, filePath)

# Leo el archivo e igualo la columna 2017 a la variable 'parse'
data = pd.read_csv(fullPath, sep = '\t')
parse = data['2017'] # Igualando a data.loc[:,'2017'] sigue apareciendo la alerta
data.head()

The first result using head gives the following. I clarify, that in the example I am working with the column 2017 and I want to convert it to float :

Now I show the result of the parse variable

The function I have created is the following. What it does is check if the character is a number or a period, creates a new variable and adds it to an array:

def parseFloat(col):
    length = len(col)
    for i in range(length):
        iElement = col[i]
        newElement = ''
        for j in range(len(col[i])) :
            if iElement[j].isdigit():
                newElement += str(iElement[j])
            elif iElement[j] in ['.']:
                newElement += '.'            
        col[i] = newElement
    return col

parsedResult = parseFloat(parse)

print(parsedResult)

The result of the print is the following (with alert included):

If it weren't for the alert, the result would be as expected. But if I query the original data variable and do a .head() on it , the values ​​of the 2017 column are automatically replaced.

I'm practicing with asynchronous requests. In one of the exercises this code appears. What I don't understand is the .then() method . This method is passed a function per parameter that in turn receives another parameter. What does this second response parameter refer to? or where does it come from? I don't understand the flow of code execution, i.e. I understand the logic of the code and what it does, but I don't really understand how it does it.

Code

let luke

function _handleError(err) {
  console.log(`Request failed: ${err}`)
}


fetch('https://www.swapi.co/api/people/1/')
  .then(function a(response) {
    return response.json()
  })
  .then(function b(json) {
    luke = json
  return fetch(luke.homeworld)
  })
  .then(function c(response) {
    return response.json()
  })
  .then(function d(json) {
    luke.homeworld = json
    console.log(`${luke.name} nacio en ${luke.homeworld.name}`)
  })
  .catch(err => _handleError(err))

I have an objects object. Represents each programming language and its respective color (source: github ):

colors = {
  '1C Enterprise': {
    'color': '#814CCC',
    'url': 'https://github.com/trending?l=1C-Enterprise'
  },
  'ABAP': {
    'color': '#E8274B',
    'url': 'https://github.com/trending?l=ABAP'
  },
  'ActionScript': {
    'color': '#882B0F',
    'url': 'https://github.com/trending?l=ActionScript'
  },
  'Ada': {
    'color': '#02f88c',
    'url': 'https://github.com/trending?l=Ada'
  }
  //...
}

How would a function be made with Javascript which, receiving the name of a language, would return its color. For example devolverColor('Ada')return#02f88c

I have a component that is responsible for displaying the values ​​of an array of objects and each object is assigned a series of colors:

colores: any = [
    {id: 1, c1: '#f0f0f0', c2: '#c8c8c8', c3: '#b4b4b4', c4: 'a0a0a0', c5: '8c8c8c'},
    {id: 2, c1: '#ff0ff', c2: '#ee82ee', c3: '#da70d6', c4: 'ba55d3', c5: '9370db'}
];

Through the *ngFor directive I am trying to show the colors but not as text, but as the color itself, setting it as the background of a div (in the following code the text of each color would appear):

<div *ngFor="let color of colores">
  <div>{{color.c1}}</div>
  <div>{{color.c2}}</div>
  <div>{{color.c3}}</div>
  <div>{{color.c4}}</div>
  <div>{{color.c5}}</div>
  <hr>
</div>

And I'm trying to pass the properties of the object directly as a style and I see that it doesn't work:

<div *ngFor="let color of colores">
  <div style="background: {{color.c1}}">{{color.c1}}</div>
  <div style="background: {{color.c2}}">{{color.c2}}</div>
  <div style="background: {{color.c3}}">{{color.c3}}</div>
  <div style="background: {{color.c4}}">{{color.c4}}</div>
  <div style="background: {{color.c5}}">{{color.c5}}</div>
  <hr>
</div>

How can I do this correctly?

While it is true that there are similarities and differences between cookies and sessions , is there an alternative to these two options?

On the one hand, cookie information can be modified by the user, so storing, for example, a user's ID is not recommended. And on the other hand, the information of a session is deleted once the user exits the browser (if I'm wrong about something, correct me). So how can the user's identity be securely stored so that it cannot be changed or deleted when the browser is exited?

Is there any way to start/stop XAMPP (apache server and mySql) using terminal in Windows 10?

PS: The path where the program is is the one created by default when installing it

I have a <div>inside which there is a <p>with a text. How can I make <div>an underline effect apply text-decoration: underlinewhen hovering over it <p>using CSS?

This is my HTML code:

<div id="addNewColumn"  style="width: 200px; height: 300px; border: 1px dashed green; border-radius: 5px; border-width: 2px; margin: 20px; cursor: pointer">    
    <p id="newColLink"   style="text-align: center;">   Underline on hover </p>
</div>

On branch compras
Changes not staged for commit:
(use "git add <file>..." to update what will be committed)
(use "git checkout -- <file>..." to discard changes in working directory)

    modified:   filtrar_busqueda/informacion_producto.php
    modified:   filtrar_busqueda/show_all.php
    modified:   funciones/funciones_busqueda.php
    modified:   js/script_publicar_anuncio.js
    modified:   login/info.php

no changes added to commit (use "git add" and/or "git commit -a")

C:\xampp\htdocs>
C:\xampp\htdocs>git add -A

C:\xampp\htdocs>git checkout master
Switched to branch 'master'
M       filtrar_busqueda/informacion_producto.php
M       filtrar_busqueda/show_all.php
M       funciones/funciones_busqueda.php
M       js/script_publicar_anuncio.js
M       login/info.php
Your branch is up-to-date with 'origin/master'.

C:\xampp\htdocs>git checkout compras
Switched to branch 'compras'
M       filtrar_busqueda/informacion_producto.php
M       filtrar_busqueda/show_all.php
M       funciones/funciones_busqueda.php
M       js/script_publicar_anuncio.js
M       login/info.php

C:\xampp\htdocs>git add -A

C:\xampp\htdocs>git status
On branch compras
Changes to be committed:
(use "git reset HEAD <file>..." to unstage)

    modified:   filtrar_busqueda/informacion_producto.php
    modified:   filtrar_busqueda/show_all.php
    modified:   funciones/funciones_busqueda.php
    modified:   js/script_publicar_anuncio.js
    modified:   login/info.php


C:\xampp\htdocs>git stash
Saved working directory and index state WIP on compras: 0f734b8 arreglo de 
cantidades en stock al hacer y rechazar un pedido

C:\xampp\htdocs>git checkout master
Switched to branch 'master'
Your branch is up-to-date with 'origin/master'.

C:\xampp\htdocs>git checkout -b conexion
Switched to a new branch 'conexion'

From here I have been working on the connection branch . At the end I have done the following:

C:\xampp\htdocs>git add -A

C:\xampp\htdocs>git commit -m "mensaje del commit"
[conexion de5a847] mensaje del commit
 106 files changed, 873 insertions(+), 2589 deletions(-)
 delete mode 100644 contacto_qbc/datos_conexion.php
 delete mode 100644 errores/datos_conexion.php

...I've omitted the list of changed files to keep things short. Next:

C:\xampp\htdocs>git checkout master
Switched to branch 'master'
Your branch is up-to-date with 'origin/master'.

C:\xampp\htdocs>git merge conexion
Updating 0f734b8..de5a847
Fast-forward
 contacto_qbc/datos_conexion.php                    |   7 -
 datos_conexion.php                                 |   1 -      

...omit the list of changed files again to keep things short. Next:

C:\xampp\htdocs>git branch
  compras
  conexion
  errores
  errores2
  errores_fac
  history
* master
  purchases
  purchases2
  qr
  sales2

C:\xampp\htdocs>git checkout compras
Switched to branch 'compras'

C:\xampp\htdocs>git status
On branch compras
nothing to commit, working tree clean

C:\xampp\htdocs>git checkout master
Switched to branch 'master'
Your branch is ahead of 'origin/master' by 1 commit.
  (use "git push" to publish your local commits)

C:\xampp\htdocs>git branch -d compras
Deleted branch compras (was 0f734b8).

And here is my mistake. As you can see, at the beginning in the purchase branch I add several files and use the ´git stash´ command if I´m not mistaken this command is used to temporarily save the changes in that branch, and I thought that when trying to delete it it would not let me. Does anyone know how to recover that deleted branch?

I need to check the content of a <input>in which only integers greater than 0 (from 1 to X) can be entered. How can I indicate it in the attribute pattern? Or should it be checked with a script?

So far I have managed with this:

 $link = "";
 $longitud = strlen($pais);

 for($i = 0; $i<$longitud;$i++){
     if($pais[$i] == ""){
         $link .= '+';
     }else{
         $link .= $pais[$i];
     }
 }

The result would be, for example, if $pais = "Estados Unidos de America"the variable$link = "Estados+Unidos+de+America"

My doubt is: is there any function to which you can indicate a delimiter and a character or string of characters to replace said type delimiter explode()but indicating a substitution character

I've only recently started using Git and I have a bad habit of starting programming without first creating a new branch. That is, I modify the code directly from the branch master.

Can changes made in one branch be moved to another and thus leave the branch masterclean?

I am working on the development of a website and the time has come to start working with cookies.

Currently, I use sessions for user registration, but I'm wondering:

• What are the differences between sessions and cookies?

• What are their advantages and disadvantages, can you do the same with both?

• Are there differences in terms of security?

As a result of making a web page, a doubt arose. When displaying some type of information on the screen using echophp, how would it be better to display this data, in terms of efficiency?

1. Showing everything with a single echo:

   echo '<table><tbody><tr><th></th></tr></tbody></table>';
   

2. Showing all with multiple echo:

   echo '<table>';
   echo '<tbody>';
   echo '<tr>';
   echo '<th>';
   echo '</th>';
   echo '</tr>';
   echo '</tbody>';
   echo '</table>';
   

I am trying to display some results using PDO. Until now used mysqli_conect()for connection to the database. I suppose that the error is found when displaying the results in the `foreach()´. Could someone tell me how I can correct the error? Thanks in advance"

Code:

<?php


try {
    $conn = new PDO("sqlsrv:server = tcp:name.database.windows.net,1344; 
Database = my_db_name", "my_user_name", "my_password");
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $stmt = $conn->prepare("SELECT Prod_Usu, Prod_Tit, Prod_Fec FROM productos"); 
    $stmt->execute();

    // set the resulting array to associative
    $result = $stmt->setFetchMode(PDO::FETCH_ASSOC); 
    foreach($result as $row) { 
        echo $row['Prod_Usu'] . " - " . $row['Prod_Tit'] . " - " . 
    $row['Prod_Fec'] . "<br>";
    }
}
catch(PDOException $e) {
    echo "Error: " . $e->getMessage();
}
$conn = null;

?>

I am trying to calculate the difference between two dates with format Y-m-d H:i:sfor example 2017-04-10 22:39:09pair that shows me the difference of days, hours and minutes. One of the dates will be the one in the BDD and the other the current one. What I have at the moment is this:

//Hago la consulta etc... y esta es la variable donde almacenaré la fecha
$fec_ = transcurridoPublicacion($fila['Prod_Fec']);

The function that calculates it:

function transcurridoPublicacion($fecha){
    $fecha2 = date("Y-m-d H:i:s");
    $fechaF = date_diff($fecha, $fecha2);
    return $fechaF;          
}