I'm using PostgreSQL & asyncpg. class PgDb: # noinspection SpellCheckingInspection def __init__(self, conn: asyncpg.connection.Connection): self.conn = conn async def select(self, sql: str, args: Union[list, Dict[str, Any]] = []) -> List[Dict[str, Any]]: sql, _args = self.__convert_placeholders(sql, args) return [dict(row) for row…
The problem is that putting queries together, I got this "error: cannot insert multiple commands into a prepared statement". What can I do? q1=" set search_path to care; SELECT COALESCE(c.date,a.date,jq.date,jn.date) reportmonth,registration,emailverified,application,submitted,eligible,jqtest,selected,joined from ( SELECT date_trunc('month', createdon)::date as date, count(1) as…
I've two tables like below Table 1 : users id - number authorization - json id user_name authorized_customers 1 user1 ["002001A", "002001B","002001ABC"] 2 user2 ["002001A", "002001Z","002001ABZ"] Table 2: orders id - number, user_id - number - forigen key of users…
Describing the scenario I have this table called event defined in PostgresSQL that, among some not relevant ones, basically has 5 columns: id (integer): primary key of the table date (timestamp): date when the event occurred fk_type (integer): foreign key…
I'm using view composer in Laravel as follows: namespace AppProviders; use IlluminateSupportServiceProvider; use IlluminateSupportFacadesView; use AppModelsGreen; use AppModelsBlue; class SidebarServiceProvider extends ServiceProvider { public function boot(): void { View::composer('layouts.sidebar', function ($view) { $dataGreen = Green::all(); $dataBlue = Blue::all(); $view->with([ 'green'…
For example in a PostgreSQL database, all the other tables can be seen using dt Or with SELECT * FROM pg_catalog.pg_tables; And we know that AGE creates its own label tables, vertex table, edge table. How can I see those…
I will try my best to explain this. Let's say I have a table like this Name Year Present_category Present_count Mother Mary 2023 sweets 3 Linda Mary 2022 sweets 2 Linda Linda 2022 sweets 4 Linda 2021 sweets 1 Linda…
I want to build Laravel + PostgreSQL existing Project. config.php 'pgsql' => [ 'driver' => 'pgsql', 'url' => env('DATABASE_URL', "pgsql://postgres:[email protected]:5432/crawler"), 'host' => env('DB_POSTGRES_HOST', '127.0.0.1'), 'port' => env('DB_POSTGRES_PORT', '5432'), 'database' => env('DB_POSTGRES_DATABASE', 'crawler'), 'username' => env('DB_POSTGRES_USERNAME', 'postgres'), 'password' => env('DB_POSTGRES_PASSWORD', '123'),…
I am getting duplicate and sometimes unordered results with doing a LEFT OUTER JOIN. I think the issue is that there are many artwork_colors that can match the WHERE condition. But I just want the artwork's artwork_color with the highest…
So basically I have a table where are partners and the dates when then they did their orders. partner_id order_date 1 2022-01-02 1 2022-01-20 2 2022-02-20 4 2022-01-15 4 2022-01-17 4 2022-01-30 And I want to have an information of…