banco | : file_folder : A project management tool for the command line | Runtime Evironment library

I have a database with the following relationship: relationship

These tables link a customer to an address: Cliente = client Clientenendereco = Many to many table between Endereco (table) and Cliente (table) Endereco = address Endereco_rua = address_street Endereco_cidade = address_city Endereco_estado = address_state

The cardinality is: Cliente NxN Endereco Endereco 1x1 Endereco_rua Endereco_rua 1x1 Endereco_cidade Endereco_cidade 1x1 Endereco_state

And the query I use is:

Goal:

• Get "Banco" and "Lançamento" values from TAB_Aditivos_Pagamentos, search for "Descrição" which contains "Lançamento" and "Banco" from TAB_Aditivos_Pagamentos then UPDATE TAB_Aditivos_Pagamentos, settin "TAB_Aditivos_Pagamentos.Descrição = TAB_Movimentos.Descrição" and also "TAB_Aditivos_Pagamentos.Lançamento = TAB_Movimentos.Lançamento"
• All that ignoring if "Banco" or "Lançamento" is equal 0.

Problems so far:

1. I'm using "while" to do this task, but it's taking a lot of time, and I'm getting a lot of errors, I think it's possible in SQL to make a single query to fix this, that's why I'm here;
2. Sometimes there're more than 1 result with same "Banco" in "Descrição" select, my idea was to use a condition like "(DATEDIFF(d, @Date_Tab1, @Date_Tab2) < 7 AND DATEDIFF(d, @Date_Tab2, @Date_Tab1) > -7)", which could solve this problem, or simply gettin Top 1 result;

What I've already done:

I have a dataset df_1 that looks like this:

And a second dataset, df_2:

I want to, for every output in df_2, compute the return for each month. An expected result for this example is df_3:

In the df_3, I do not need the result to be displayed with a comma separator, however, I need later to be able to plot everything in a graph with time on the X axis and stock values (from df_3) on the Y axis.

Update 1: As requested, here is the constructor of my sample dataframes: df1:

I'm creating a Database from excel files scraped from the web, the problem is that the source lacks a pattern, the name of the columns vary a lot and sometimes it exceeds the 64 characters limitation from MySQL. My solution by now is running the script and replace each word I find to a reduced version. The problem is that there is too much data and the replace library is getting huge.

Here's an example of one table being created after replaces:

I'm doing a management application with 2 pages: users(clientes) and a user datail page that contains a user payment history(cheques).

I'm trying to do a create a form in payment history page(cheques.html) to add a new payment, but I'd the Cheque.cliente would be equals to the current user URL. Ex.: if your URL is cheque/5/, the Cheque.cliente should be 5, and when I add a new payment, the payment should be tracked(ForeignKey) to the user 5(each user has many payments).

Resuming: This application has the functions to CRUD all the user(clientes) and all the payments(cheques), but only the add payment(cheque) function isn't working.

VIEWS.py

I have a database something like this:

I'm having this problem when I try to start my application or run some route. I can't understand why. Can anyone help?

The full error:

Hi for some reason this isn't working

let ifAID = "Banco: Global Bank\nTipo de Cuenta: Corriente"

where \n should be a line break this is what is showing off, any advice ?

I'm using Card, CardContent, Typography and Stack all inside a Box that is inside a Container (There's a lot going on)

My goal is to update a specific document by adding +1 everytime is "buyed", This is how the data enters I can either use this:

const data = JSON.parse(window.localStorage.getItem("listaLibros"))

which comes like this in the console log:

or I can transform all that data into a single array (idk which way would be easier to achieve what I want to do which is why I mention both)

const allItems = [...data1, ...data2, ...data3]

and then it comes like this:

However the reason why I had them "separated" as 4,0,3 is because each array is from a DIFFERENT collection and this time I had none from the second collection which is why it brings 0.

Now the idea is that for every BOOK it adds a +1 as "ordered" in their respective collection each book has his own uid which in this case is added on the document as id one of the examples in the picture is PE-13620 for example.

how can I compare my array information which the collections I think the best approach would be using the one with the separate arrays that way I can divide it by collection