Goerman's questions

In the following code it shows a grouping, adding the total of occurrences, assuming that you only have df2, what is the best way to obtain df?

>>> import pandas as pd
>>> d = {
    "var_1":['a','a','a','c','c','c','c'],
    "var_2":['b','b','b','d','d','d','d'],
    "total":[1,1,1,1,1,1,1],
    "days":['4','4','4','2','2','2','2']    
    }
>>> # Create a dataframe since a dictionary 
>>> df = pd.DataFrame(d)
>>> df
  var_1 var_2  total days
0     a     b      1    4
1     a     b      1    4
2     a     b      1    4
3     c     d      1    2
4     c     d      1    2
5     c     d      1    2
6     c     d      1    2
>>> df2 = df.groupby(['var_1','var_2','days']).sum('total').reset_index()
>>> df2
  var_1 var_2 days  total
0     a     b    4      3
1     c     d    2      4

Context:

I successfully deployed moodle with the official docker compose , configured for database mysqland the latest version of moodle on github.

docker file compose:

version: "2"
services:
  webserver:
    environment:
      MOODLE_DOCKER_DBTYPE: mysqli
      MOODLE_DOCKER_DBCOLLATION: utf8mb4_bin
  db:
    image: mysql:5
    command: >
                --character-set-server=utf8mb4
                --collation-server=utf8mb4_bin
                --innodb_file_format=barracuda
                --innodb_file_per_table=On
                --innodb_large_prefix=On
    environment:
      MYSQL_ROOT_PASSWORD: "m@0dl3ing"
      MYSQL_USER: moodle
      MYSQL_PASSWORD: "m@0dl3ing"
      MYSQL_DATABASE: moodle

Container configuration and deployment:

# configuración de variables de entorno usando git-bash.
export MOODLE_DOCKER_WWWROOT=/c/moodle
export MOODLE_DOCKER_DB=mysql
cp config.docker-template.php $MOODLE_DOCKER_WWWROOT/config.php

# Ejecutar contenedores en segundo plano y dejarlos corriendo
bin/moodle-docker-compose up -d

# Abrir para testeo manual:
bin/moodle-docker-compose exec webserver php admin/cli/install_database.php --agree-license --fullname="Docker moodle" --shortname="docker_moodle" --adminpass="test" --adminemail="[email protected]"

Ask:

I am trying to grant privileges to the moodle user (in order to be able to execute some commands that require elevated privileges) with the command:

GRANT ALL PRIVILEGES ON *.* TO 'moodle';

But I get the error:

ERROR 1045 (28000): Access denied for user 'moodle'@'%' (using password: YES)

How can I do it?

Note : I am using docker desktop on windows with WSL 2 enabled.

I have Ubuntu 16.04.3 LTS installed as a guest in a VirtualBox virtual machine running on a Windows 10 OS computer.

With the following command I try to mount a shared folder called "temp".

sudo mount -t vboxsf -o uid=1000,gid=1000 temp /home/$(whoami)/compartida

getting the following error message

wrong fs type, bad option, bad superblock on temp, missing codepage or helper program, or other error

When reviewing the log:

dmesg | tail

vboxsf: Successfully loaded version 5.1.16_Ubunto

sf_read_super_aux err=-22

Edit: Steps followed

1) Install Guest Additions

sudo apt-get install virtualbox-guest-additions-iso
VBoxManage --version
5.0.40_Ubuntor115130

2) Users in Ubuntu must be in the groupvboxsf

sudo groupadd vboxsf
groupadd: el grupo <<vboxsf>> ya existe
sudo usermod -aG vboxsf $(whoami)

3) Define a folder in Windows to be shared with Ubuntu using the VirtualBox interface (Devices/Shared Folders/Shared Folders Preferences/Add New Folder)

3.1) Folder in Windows E:\temp, called tempin the VirtualBox interface

4) Create a mount point in Ubuntu.

mkdir /home/$(whoami)/compartida

-- Se tiene definida la siguiente tabla
CREATE TABLE MY_TABLA
(
   ID        NUMBER (3),
   NUM_TAB   FLOAT (3)
);

INSERT INTO MY_TABLA
     VALUES (24, 24);

SELECT ID, NUM_TAB FROM MY_TABLA;
-- 24   20
```

• Why NUM_TABwas it inserted 20, if it was sent 24?
• In what situations is it advisable to change the precision of a field FLOATby default?

In the cell A1I have the formula =25/26, to see it as text I copy and paste it B1adding a quote at the beginning '=25/26.

With which function can I do this automatically?

With the following script , a new form will be created

// Create a new form, then add a checkbox question, a multiple choice question,
// a page break, then a date question and a grid of questions.
var form = FormApp.create('New Form');
var item = form.addCheckboxItem();
item.setTitle('What condiments would you like on your hot dog?');
item.setChoices([
        item.createChoice('Ketchup'),
        item.createChoice('Mustard'),
        item.createChoice('Relish')
    ]);
form.addMultipleChoiceItem()
    .setTitle('Do you prefer cats or dogs?')
    .setChoiceValues(['Cats','Dogs'])
    .showOtherOption(true);
form.addPageBreakItem()
    .setTitle('Getting to know you');
form.addDateItem()
    .setTitle('When were you born?');
form.addGridItem()
    .setTitle('Rate your interests')
    .setRows(['Cars', 'Computers', 'Celebrities'])
    .setColumns(['Boring', 'So-so', 'Interesting']);
Logger.log('Published URL: ' + form.getPublishedUrl());
Logger.log('Editor URL: ' + form.getEditUrl());

Ask:

How to achieve the reverse effect, that is, from an existing form get the generation script?

I've written a python function to simulate the effect of typing on a GIF , which works except for special characters like tildes and eñes.

Function

def efecto_escritura(x, y, color,texto):
    texto_completo = texto
    ultimo_texto=''
    imagen_inicial = gimp.image_list()[0]    
    #Color del texto 
    gimp.set_foreground(color)

    # Parámetros Fuente
    fontname= 'Sans' #Tipo de letra
    size_type=PIXELS 
    size= 30 #Tamaño
    antialias = True
    border = 0
    #y = 0 
    #x = 0 
    drawable = None
    image = imagen_inicial    
    for i in texto_completo:
        ultimo_texto=ultimo_texto+i
        layer = pdb.gimp_text_fontname(image, drawable, x, y, ultimo_texto, border, antialias, size, size_type, fontname)
        print(ultimo_texto)

Use

Run in GIMP's "Python Console"

efecto_escritura(58,209,(255, 255, 255), 'Stackoverflow en español')

Error message

Calling error for procedure 'gimp-text-fontname': Procedure 'gimp-text-fontname' has been called with value 'Stackoverflow en espaÃ' for argument 'text' (#5, type gchararray). This value is out of range.

Ambient

OS: Windows 10

Python-GIMP:

print(sys.version)
2.7.10 (default, May 23 2015, 09:40:32) [MSC v.1500 32 bit (Intel)]

If there is "some value" in cell F1, it is required to obtain that data as a concatenation of cells B3 and B4, where B3="F" and B4="1".

attempt :

Use the & operator to perform concatenation.

="="&B3&B4

Resulting in "=F1" as a string plus not the data located in said cell.

Scenery:

I have two spreadsheet documents from google drive:

• Book1 , with a sheet called "Day1"
• Book2 , with a sheet called "Consolidated"

I use the IMPORTRANGE function in Book2 to fetch the value from cell A1 of sheet Day1 from Book1 without any problem.

=IMPORTRANGE("1lIpak48SxPpi4aWo20_BuquZ12zCQXekwSCEyBcYotQ";"Dia1!A1")

Rate: 150

I now want to build the IMPORTRANGE function as a concatenation in order to make it parameterizable within the same sheet.

F1="Dia1" //In cell F1 the value to be concatenated is located;

Try:

=CONCATENAR("=IMPORTRANGE(""1lIpak48SxPpi4aWo20_BuquZ12zCQXekwSCEyBcYotQ"";""";F1;"!A1"")")

Although the concatenation is correct, it returns the value =IMPORTRANGE("1lIpak48SxPpi4aWo20_BuquZ12zCQXekwSCEyBcYotQ";"Dia1!A1")as a string.

Ask:

How to indicate that I execute the concatenated string so that it gives me the desired result (150)?

I am trying to migrate a database from SQL Serverto Oracle, for this I am using Oracle SQL Developeras suggested by the following Oracle Tutorial , which has the following sections:

• Connection:
  1. Install Oracle SQL Developer
  2. Create and configure migration repository:

a) Assign permissions:Grant connect, resource, create session, create view to migration_repo identified by migration_repo;

b) Connect to created repository:

Nombre de Conexión: migration_repo 
Usuario: migration_repo 
Contraseña: migration_repo 
SID: MYSID_ORACLE

C) Associate Repository: Tools/Migration/Repository Management/Create Repository, choose " migration_repo"

3. Connect to third party database

• Capture
• Convert
• To transfer
• Trigger
• Move Data

I follow the steps above, but at the end of the transfer section I get the following error:

Mistake:

<message>Error:ORA-06550: línea 1, columna 14:
    PLS-00201: el identificador 'SS2K5ALLPLATFORM.STAGECAPTURE' se debe declarar
    ORA-06550: línea 1, columna 7:
    PL/SQL: Statement ignored
    : FAILED : Migración de Base de Datos : FAILED</message>

Full Log Information:

<?xml version="1.0" encoding="windows-1252" standalone="no"?>
<log>
<record>
  <date>2016-06-01T16:48:18</date>
  <logger>oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle</logger>
  <level>SEVERE</level>
  <class>oracle.dbtools.migration.workbench.core.logging.MigrationLogUtil</class>
  <message>Capture
Enterprise Capture
Capture failed.  Refer to MIGRLOG table in the repository for details</message>
  <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doOnlineEnterpriseCapture(FullMigrateTask.java:758)</param>
  <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doCapture(FullMigrateTask.java:601)</param>
  <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doMaskBasedActions(FullMigrateTask.java:400)</param>
  <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doWork(FullMigrateTask.java:314)</param>
  <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doWork(FullMigrateTask.java:147)</param>
  <param>oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)</param>
  <param>java.util.concurrent.FutureTask.run(FutureTask.java:266)</param>
  <param>oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:621)</param>
  <param>java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)</param>
  <param>java.util.concurrent.FutureTask.run(FutureTask.java:266)</param>
  <param>java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)</param>
  <param>java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)</param>
  <param>java.lang.Thread.run(Thread.java:745)</param>
  <param>oracle.dbtools.migration.workbench.core.logging.LogInfo@572aa33a</param>
  <exception>
    <message>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask$FullMigrateTaskException: Capture
Enterprise Capture
Capture failed.  Refer to MIGRLOG table in the repository for details</message>
    <frame>
      <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
      <line>758</line>
    </frame>
    <frame>
      <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
      <line>601</line>
    </frame>
    <frame>
      <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
      <line>400</line>
    </frame>
    <frame>
      <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
      <line>314</line>
    </frame>
    <frame>
      <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
      <line>147</line>
    </frame>
    <frame>
      <class>oracle.dbtools.raptor.backgroundTask.RaptorTask</class>
      <line>193</line>
    </frame>
    <frame>
      <class>java.util.concurrent.FutureTask</class>
      <line>266</line>
    </frame>
    <frame>
      <class>oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask</class>
      <line>621</line>
    </frame>
    <frame>
      <class>java.util.concurrent.Executors$RunnableAdapter</class>
      <line>511</line>
    </frame>
    <frame>
      <class>java.util.concurrent.FutureTask</class>
      <line>266</line>
    </frame>
    <frame>
      <class>java.util.concurrent.ThreadPoolExecutor</class>
      <line>1142</line>
    </frame>
    <frame>
      <class>java.util.concurrent.ThreadPoolExecutor$Worker</class>
      <line>617</line>
    </frame>
    <frame>
      <class>java.lang.Thread</class>
      <line>745</line>
    </frame>
  </exception>

</record>
<record>
  <date>2016-06-01T16:48:18</date>
  <logger>oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle</logger>
  <level>WARNING</level>
  <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
  <message>Error:ORA-06550: línea 1, columna 14:
PLS-00201: el identificador 'SS2K5ALLPLATFORM.STAGECAPTURE' se debe declarar
ORA-06550: línea 1, columna 7:
PL/SQL: Statement ignored
: FAILED : Migración de Base de Datos : FAILED</message>
  <param>oracle.dbtools.migration.workbench.core.logging.LogInfo@7e8e4394</param>

Tools:

• Microsoft SQLServer 2012
• Oracle 11g V2
• Oracle SQL Developer 4.1.3.20.78
• Java(TM) 1.80_60
• jtds-1.2-dist

Situation:

There is the following table called P_FAMILIA:

|ID |    NAME    | SOLDADOS   |
|---|------------|------------|
| 1 | Stark      |  30000     |
| 2 | Targaryen  |            |
| 3 | Lannister  |  15000     |
| 4 | Greyjoy    |            |

It is required to build a sql query, to pass all the fields of the previous table (the data supplied is an example, it can have many more records) to another table called P_DIAFAMILIAadding the number 1, that is, after executing the query get

|ID |IDP_FAMILIA|    NAME    | SOLDADOS   |
|---|-----------|------------|------------|
| 1 |    1      | Stark      |  30000     |
| 1 |    2      | Targaryen  |            |
| 1 |    3      | Lannister  |  15000     |
| 1 |    4      | Greyjoy    |            |

Scheme

CREATE TABLE P_FAMILIA
(
ID INT,
NAME VARCHAR2(30 BYTE),
SOLDADOS FLOAT(126)
);

ALTER TABLE P_FAMILIA
ADD PRIMARY KEY (ID);

CREATE TABLE P_DIAFAMILIA
(
   ID            INT NOT NULL,
   IDP_FAMILIA   INT NOT NULL,
   NAME          VARCHAR2 (30 BYTE),
   SOLDADOS      FLOAT (126)
);


ALTER TABLE P_DIAFAMILIA
ADD( FOREIGN KEY (ID)
REFERENCES P_FAMILIA (ID));

-- Insert Statements
Insert into P_FAMILIA
   (ID, NAME, SOLDADOS)
 Values
   (1, 'Stark', 30000);
Insert into P_FAMILIA
   (ID, NAME)
 Values
   (2, 'Targaryen');
Insert into P_FAMILIA
   (ID, NAME, SOLDADOS)
 Values
   (3, 'Lannister', 15000);
Insert into P_FAMILIA
   (ID, NAME)
 Values
   (4, 'Greyjoy');
COMMIT;

There is the following table called P_FAMILIA:

|ID |    NAME    | SOLDADOS   |
|---|------------|------------|
| 1 | Stark      |  30000     |
| 2 | Targaryen  |            |
| 3 | Lannister  |  15000     |
| 4 | Greyjoy    |            |

When making the following query

SELECT F.NAME 
FROM P_FAMILIA F

I get

|    NAME    |
|------------|
| Stark      |
| Targaryen  |
| Lannister  |
| Greyjoy    |

I want to display the result of the query as follows:

|            NAME                 |
|---------------------------------|
|Stark,Targaryen,Lannister,Greyjoy|

Update

Try to upload the schema to http://sqlfiddle.com/ but the application has problems when the engine " Oracle 11g R2" is chosen

Scheme:

-- Crear tabla
CREATE TABLE P_FAMILIA
(
ID INT,
NAME VARCHAR2(30 BYTE),
SOLDADOS FLOAT(126)
);

-- Llave primaria
ALTER TABLE P_FAMILIA
ADD PRIMARY KEY (ID);

    -- Insert Statements
Insert into P_FAMILIA
   (ID, NAME, SOLDADOS)
 Values
   (1, 'Stark', 30000);
Insert into P_FAMILIA
   (ID, NAME)
 Values
   (2, 'Targaryen');
Insert into P_FAMILIA
   (ID, NAME, SOLDADOS)
 Values
   (3, 'Lannister', 15000);
Insert into P_FAMILIA
   (ID, NAME)
 Values
   (4, 'Greyjoy');
COMMIT;

I'm trying to display a local variable in a message, but I'm not clear on the concept.

Code:

procedure TForm1.Button1Click(Sender: TObject);
var
 i:integer;
begin
 i:=1;
 ShowMessage(i.AsString);
end;

Mistake:

[Error] Unit1.pas(31): Record, object or class type required

It is required to execute repetitive DCL (Data Control Language) statements on certain tables in the database. How can I generate them automatically?

Sentence to generate:

GRANT DELETE, INSERT, SELECT, UPDATE ON NOMBRETABLA TO ADMINISTRADOR;

It must be applied on all the tables that start with FAM_

Expected result after executing the query:

GRANT DELETE, INSERT, SELECT, UPDATE ON FAM_TABLA_A TO ADMINISTRADOR;
GRANT DELETE, INSERT, SELECT, UPDATE ON FAM_TABLA_B TO ADMINISTRADOR;
GRANT DELETE, INSERT, SELECT, UPDATE ON FAM_PRUEBA TO ADMINISTRADOR;
GRANT DELETE, INSERT, SELECT, UPDATE ON FAM_TABLAC TO ADMINISTRADOR;

Updates:

Use a select to concatenate GRANT DELETE, INSERT, SELECT, UPDATE ON with the name of all the tables that start with FAM_

...

I'm trying to find out if a record exists in database, I run a query selectand I want to get the result, I still can't get it...

Database

By executing the following query directly on the database:

SELECT T.ID
FROM TABLA T
WHERE ID=3

Is obtained:

No rows returned

Now I try to display a message in Delphi saying that the record does not exist.

In the form I have a type component TQuerycalled qValidacionsuccessfully connected to Oracle 11g database.

attempt 1

procedure TfPrueba.ButtonAceptarClick(Sender: TObject);
begin
    qValidacion.Close;
    qValidacion.SQL.Add('SELECT T.ID');
    qValidacion.SQL.Add('FROM TABLA T');
    qValidacion.SQL.Add('WHERE ID=3');
    qValidacion.Open;
    qValidacion.First;
    if qValidacion.IsEmpty then //No se como validar si el Select regresa algo, IsEmpty me muestra los registros existentes
        begin
             ShowMessage('El registro No Existe');
        end;
    qValidacion.SQL.Clear;
end;

attempt 2

procedure TfPrueba.ButtonAceptarClick(Sender: TObject);
begin
    qValidacion.Close;
    qValidacion.SQL.Add('SELECT T.ID');
    qValidacion.SQL.Add('FROM TABLA T');
    qValidacion.SQL.Add('WHERE ID=3');
    qValidacion.Open;
    qValidacion.First;
    if (not qValidacion.Eof) then 
        begin
             ShowMessage('El registro No Existe'); //deberia mostrar el mensaje, pero no lo muestra
        end;
    qValidacion.SQL.Clear;
end;

Situation:

I have a file with data that has the following format:

ID       FLOAT(20),
NAME     VARCHAR2(20 BYTE),
TRIBUTE  VARCHAR2(4 BYTE),
GOLD     VARCHAR2(2 BYTE),

I am going to apply a Regular Expression to find and replace the data with this output (First word of the line, followed by a comma):

ID,
NAME,
TRIBUTE,
GOLD,

Solution in Microsoft Word

The operation in Microsoft Word is this:

Search:<(??*) (*?,)

Replace:\1,

Problem

Now I want to get the same output in Notepad++, but still can't.

Updates Solution in Notepad++:

Reading http://docs.notepad-plus-plus.org/index.php/Regular_Expressions and trying, I have decided the following equivalencies

Busqueda                            |   Word    |   Notepad++   |
------------------------------------+-----------+---------------|
Principio de línea                  |     <     |       ^       |
Cómodin un caracterer cualquiera    |     ?     |      .?       |
Cómodin uno o muchos caracterers    |     *     |      .*       |
Guardar búsqueda                    |    ()     |       ()      |
Busquedad Guardada                  |    /#     |       /#      |

A possible solution would be to perform two searches,

first search

Search:^(.?.?.*) (.*),

Replace:\1,

Second Search

Search:

Replace:

(Search for "space" and replace with "nothing")

Environment:

• Google Chrome Web Browser Version 47.0.25
• Google spreadsheets spreadsheet

Situation

I am trying to make cell I1 change color only when IJ is greater than J1, when choosing the condition the option to relate other cells does not appear

I try to configure using the "Custom formula is" option without success.

Situation

When executing the following queries, the same number of records is obtained, I would like to know what is the difference of using a (+)at the end of the query.

SELECT A.IDTABLAA,B.NOMBRETABLAB
FROM TABLA_A A, TABLA_B B
WHERE A.IDTABLAA=B.IDTABLAB

--Record Count: 2,265

SELECT A.IDTABLAA, B.NOMBRETABLAB
FROM TABLA_A A, TABLA_B B
WHERE A.IDTABLAA=B.IDTABLAB(+)

--Record Count: 2,265

Environment

• Database: Oracle 11g

Equipment Configuration:

Equipment

• I am using Windows 7 Professional.
• I have the Administrator role.
• The USB device has FAT32 file system.

Situation : In the root folder of a USB there is a file called "AUTORUN.INF", which I want to delete, when trying to do it through the Windows explorer, the message appears: "Equipment administrator permissions are required to make changes in this file". I have tried the following alternatives without success.

Proven Alternatives:

1. Remove all file attributes (Read Only File, Archive File, System File, Hidden File) via Windows Command Console.

Attrib –r –a –s –h I:/AUTHORUN.INF

Obtaining the following negative result:

Acceso denegado: I:/AUTORUN.INF

2. Check which process is using the file with the Process Explorer program and then kill the process with the "Handle V4.0" program as suggested by this solution

Shortcut Ctrl + F, to access the “Handle or DLL substring” functionality, then search for “ I:/AUTORUN.INF”, it gives me the answer “0 marching items”

3. Try the Unlocker program .

I ignored the warning "site suspected of serving unwanted software", I downloaded and installed it, when I right click on the file and then choose Unlocker it shows me that the file is not locked by any process, but it does not allow it to be deleted, it asks do it after the next reboot, but it doesn't remove it in the end either.

Untested Alternatives

1. Use a mini Linux, mini Windows or BootCD

Delayed alternative, I don't have those tools.

2. Format the USB.

It implies quite delayed data movement.

3. Remove it using windows safe mode.

Is there a solution that doesn't involve restarting the computer?