I get File "C:PythonProjectsmyProjectroutershome.py", line 39, in @router.get("/home", response_class=HTMLResponse) ... raise TypeError('{!r} is not a callable object'.format(obj)) TypeError: <generator object get_db at 0x000002B68FBDB100> is not a callable object home.py from fastapi import Depends, APIRouter, Request from fastapi.templating import Jinja2Templates from…
I would like to calculate total Prise per month. i have a database where I save data every minute. TIME KWHI EUR 2023-12-02 23:00:15 8852.892 12.8040 2023-12-02 22:59:13 8852.892 13.4496 2023-12-02 22:58:11 8852.892 13.4496 2023-12-02 22:57:09 8852.892 13.4496 SELECT TIME,…
I'm using PostgreSQL 14, and during the replication setup, I forgot to include single quotes around the value of primary_conninfo. I'm puzzled as to why the server isn't starting, and I'm not finding any logs indicating an error in the…
I want this output id jml total 1 1000 1000 1 100 1100 2 400 400 2 300 700 but when i try my output is id jml total 1 1000 1000 1 100 100 2 400 400 2 300…
I have a typescript and DB question. I generate a uuid as a ticket like so and I can see when I console log it, it displays the uuid as expected. I then want to take that param value and…
Example Tables: Table: TAB1 Col1 Col2 Col3 Col4 A1 A2 AA1 G1 A1 A2 AA1 G2 Table: TAB2 Col1 Col2 Col3 Col4 A1 A2 AA1 H1 A1 A2 AB1 H2 How to write a query to get Expected Result as:…
Exists some way to do some actions after a transaction fails in laravel?, I know it's possible to use a try/catch, but inside of the transaction are other delegate instructions that alredy utilizes try/catch statement. DB::transaction(function () { $this->otherService->Create($data); });…
I am new at Postgresql that's why I can't figure out some privileges here. Database called Denemedb23 is already created. I created the user NoxUser. I executed these commands: REVOKE ALL PRIVILEGES ON DATABASE Denemedb23 FROM public; GRANT CONNECT ON…
I want a request a data from operation i made in controller, when i try my code the output total is null. I try this code $total += $request->jumlah_pinjaman; $data = [ 'tanggal' => $request->tanggal, 'no_bukti' => $request->no_bukti, 'jumlah_pinjaman' =>…
I need to count the number of matching elements between 2 arrays using MongoDB filter aggregation. I tried using $eq and $setIntersection on the condition field of filter but the number of matching elements return just 1 even if all…