All Questions

Hello, good, I have the following code in Python that prints the number of pages and the data of a PDF, however, this only works if I call the PDF with a directory on my PC. What I want it to do is open the PDF for me using only the Bytes or Base64 string I provide without having to write a new PDF on my pc .

PDFBase64="JVBERi0xLjUNCiW1tbW1..."
Decodificado=base64.b64decode(PDFBase64)
documento=fitz.open(Decodificado)

print("Número de páginas: ",documento.page_count)
print("Datos: ",documento.metadata)```

I am preparing a common schemao databasethat contains tables in common use across multiple projects. All MySQL users must have permission to run ONLY selecton those tables. For that I do:

drop database if exists common_schema;

CREATE DATABASE common_schema CHARACTER SET utf8 COLLATE utf8_general_ci;
grant select on common_schema.* to ""@"";
flush privileges;
use common_schema;

set foreign_key_checks = 0;

-- creación_de_tablas
-- inserts
-- foreign_keys

set foreign_key_checks = 1;

The entire operation is executed with a bash script that is as follows:

cat *.sql  > sql_completo.sql1
mv sql_completo.sql1 sql_completo.sql
mysql -u root -p < sql_completo.sql
rm sql_completo.sql

This script concatenates all the SQL files and loads it into MySQL. The problem is that any user can insert, modify or delete records from common_schema, which it shouldn't be.

I am using MySQL 5.6.51.

Thanks in advance!

What you want to do may be a bit far-fetched. I have a date/time range that triggers a query to the database. This data is the content with which I need to fill this selector, and I need the selector to be filled with the first element selected.

So far what I have achieved is that the selector loads the content of what the database brings but I don't know how to make that content show the first one.

HTML:

     <form [formGroup]="formGateway">
      <mat-form-field class="textBox" appearance="fill">
        <mat-label> Gateway seleccionado </mat-label>
        <mat-select
          formControlName="gatewayId"
        >
          <mat-option
            *ngFor="let gw of basicGatewayDTO"
            [value]="gw.gateway_id"
          >
            {{ gw.gateway_name }}
          </mat-option>
        </mat-select>
      </mat-form-field>
    </form>

TypeScript:

formGateway: any;
basicGatewayDTO: basicGatewayDTO[] = [];

constructor(
    private formBuilder: FormBuilder,
  
) {
  this.formGateway = formBuilder.group({ gatewayId: new FormControl('') });
}
ngOnInit(): void {
  this.FiltrarGateways().then((respuesta) => {
      let respStr = JSON.stringify(respuesta);
      this.basicGatewayDTO = JSON.parse(respStr);

  });
}

I summarized the code so that it is understood how I am handling it (for example, the method that returns the promise that brings the information is not shown), however I am open to other ways of doing it.

What I want to do is set the selector property to have the first index or first option selected, assuming that what the database brings exists. It could be something like this:

setValueSelector(valor: string){
    this.formGateway.gatewayId.setValue(valor);
  }

Or instead of setting the value, set the position, the option, whatever is best and most practical to solve it.

I appreciate any information on this

I've just started in Python and I'm programming a function that performs a sum of various rolls of the dice: import random

print("Comienzo")
total = 0
for i in range(3):
    dado = random.randrange(1, 7)
    print(f"Tirada {i + 1}: {dado}")
    total += dado
print(f"En total ha obtenido {total} punto(s).")
print("Final")

How can I make the number of rolls stop only when the total has reached 100 points?

Dear, I have a problem when bringing two data from a table of MSSQL. The table contains two fields that I want to fetch: CC_PreFijoand CC_Nro. These data in the table, as attached in the following image, are of type INT the first and type BIGINT the second:

What I do is that by DataGridViewselecting an item from it, I make a query to the table asking for those values ​​(and others as well) but the query returns the following error:

System.FormatException: 'La cadena de entrada no tiene el formato correcto.'

And I notice this line:

int prefijo = Convert.ToInt32(sqlDataReader["prefijo"]?.ToString());

What is my mistake? From already thank you very much