I would create a virtual model modelC (with no real table on the DB) as join between model modelA and model modelB. My need is to access to model modelC like a standard model and access to his attributes (modelA…
I have some values in my table like this, Main Table I want to select only those with the latest/highest date, The result will be like the picture in below: Result Table I already try with union but it didn't…
I have a table with these columns: event_time (date) event_data (json) player_account char() I'm trying to get all three fields from my query and groupBy by "player_account" field. The problem is doing this query: DB::connection('aa')-table('bb') ->where('event_time', ">", $date) ->select('event_time', 'event_data',…
Hello i am 2 days stuck trying to install POSTGRE SQL. Today it is on version 16 but already attempted versions 14, 13, 15.... It looks like the bindata folder, which is the db cluster folder, has some kind of…
I've accidentally named a view : "test..view". When I try to delete it now I get the following error : MongoInvalidArgumentError: Collection names cannot be empty I tried running the following command : db.getCollection("test..view").drop() I also tried to rename it…
I have a .sqlite file in a local folder. I would like to update all URLs in this SQLITE file across all tables, indicies, and rows. What is the best way to do this? In a regular sql file I…
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…