vbilopav

Dictionary for database example

• Server: PostgreSQL 216.158.72.53:5432, version 13.7 (Debian 13.7-0+deb11u1)
• Local time stamp: 2022-07-20T12:41:43.0051958+02:00
• Schema: public

Table of Contents

• Table public.addresses
• Table public.alarm_alarm_contacts

vbilopav

do
$$
declare
    _table_name text = 'md_temp';
    _md text = '
| Command | Description |
| --- | --- |
| `git status` | List all *new or modified* files |
| `git diff` | Show file differences that **havent been** staged |
';

vbilopav

/*
Task: get a set of movies where Zendaya played a role, 
and for every such movie calculate the average review score, 
and also retrieve the list of top 5 actors in the order of credits. 

Here’s how such query can be written in EdgeQL: 

select
  Movie {
    title,

vbilopav

select
    title,
    name,
    avg(score)
from movies m
    join movies_actors using(movie_id)
    join actors a using(actor_id)
    join (
        select movie_id
        from actors join movies_actors using(actor_id)

vbilopav

--
-- Detect all duplicate foreign keys from public schema and generates a script that drops all duplicates but first.
--
with fkeys as (

    select
        tc.constraint_name, 
        tc.table_name, 
        kcu.column_name, 
        ccu.table_name as foreign_table_name,

vbilopav

using Newtonsoft.Json.Linq;
using Newtonsoft.Json.Serialization;

namespace MyNamespace;

public static class JsonValidator
{
    public static bool IsJsonValidType(this string json, Type modelType, out string? message)
    {
        try

vbilopav

/*
Creates TypeScript models from CSharp models
- TypeScript model is set by config key TsModelsPath
- CSharp models namespace is set by config key ModelNamespace

1) Add to your Program.cs:
if (ModelBuilder.Build(args))
{
    return;
}

vbilopav

create or replace function companies.search_companies(
    _search varchar, 
    _skip integer, 
    _take integer
) 
returns json
language plpgsql 
as $$
declare
    _count bigint;

vbilopav

PgRoutiner Cheat Sheet

TOC

• Installation
• Connection Managament
• Silent console output and basic configuration
• List database objects
• Create default configuration file
• Objects defintions

vbilopav

Dictionary for database pdd

• Server: PostgreSQL localhost:5436, version 14.0
• Local time stamp: 2022-07-15T12:01:44.0784710+02:00
• Schema: public

Table of Contents

• Table public.business_areas
• Table public.business_roles