Vedran Bilopavlović vbilopav

Dictionary for database `example`

	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 \|
	';

	/*
	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,

	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)

	--
	-- 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,

	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

	/*
	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;
	}

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