Tutti i gists - Opengist

gaiety / update_with_from_join.sql

0 mi piace

0 forks

1 files

Ultima volta attivo 2 days ago

https://neon.com/postgresql/postgresql-tutorial/postgresql-update-join

sql

1	UPDATE table1
2	SET table1.c1 = new_value
3	FROM table2
4	WHERE table1.c2 = table2.c2;

gaiety / Git Alias - Merge latest main

0 mi piace

0 forks

1 files

Ultima volta attivo 1 month ago

Git Alias to Merge Main into Current Branch

alias git

1	[alias]
2	update = "!update() { git fetch && git merge main --no-edit; }; update"

gaiety / run_script_once.sh

0 mi piace

0 forks

1 files

Ultima volta attivo 2 months ago

1	if [ ! -f ~/.script_has_run ]; do sh ~/script_has_run.sh && touch ~/.script_has_run; done

gaiety / Simple nginx static site docker compose

0 mi piace

0 forks

1 files

Ultima volta attivo 3 months ago

No build steps or anything fancy, easy to throw into a static project

docker nginx

1	name: nginx-static-site
2	services:
3	client:
4	image: nginx
5	ports:
6	- 80:80
7	volumes:
8	- ./:/usr/share/nginx/html

gaiety / dotfiles-link.sh

0 mi piace

0 forks

1 files

Ultima volta attivo 3 months ago

Links need to be absolute, which is hard when you don't know where a git repo will be cloned to. This helps with that!

bash link script shell

1	# Link current directory instead of having to always do absolute
2	ln -s "$(pwd)/cool-tool" ~/.config/cool-tool

gaiety / ecto-migration-search-pg_trgm

0 mi piace

0 forks

1 files

Ultima volta attivo 3 months ago

ecto postgres search

1	defmodule MyProject.Repo.Migrations.ItemsSearch do
2	use Ecto.Migration
3
4	def up do
5	execute "CREATE EXTENSION IF NOT EXISTS pg_trgm;"
6
7	execute """
8	CREATE INDEX items_search_index
9	ON items
10	USING gin ((name) gin_trgm_ops);

gaiety / ecto-get-random.ex

0 mi piace

0 forks

1 files

Ultima volta attivo 3 months ago

1	def get_random_items(limit \\ 3) do
2	query =
3	from Item,
4	order_by: fragment("RANDOM()"),
5	limit: ^limit,

gaiety / ecto-search-simple-word-similarity.ex

0 mi piace

0 forks

1 files

Ultima volta attivo 3 months ago

ecto elixir phoenix search

1	defp items_search(search) do
2	dynamic(
3	[item],
4	fragment(
5	"word_similarity(?, CONCAT(?, ' ', ?)) > 0.6",
6	^search,
7	item.name,
8	item.description
9	)
10	)

gaiety / ecto-dynamic-list-within-list-query.sh

0 mi piace

0 forks

1 files

Ultima volta attivo 3 months ago

Adding a check of an elixir list compared to a PostgreSQL array

dynamic ecto elixir query

1	def query(filters, dynamic) do
2	dynamic(
3	[features],
4	^dynamic and fragment("? && ?::varchar[]", ^features, item.features)
5	)
6	end

gaiety / Phoenix (Elixir) + LitElement + TailwindCSS

0 mi piace

0 forks

1 files

Ultima volta attivo 3 months ago

Inline import the compiled TailwindCSS and Phoenix LiveView ViewHook and make it available to components

elixir lit phoenix tailwindcss

1	import {LitElement, unsafeCSS} from 'lit'
2	import type {ViewHook} from 'phoenix_live_view'
3	import styles from '../../../priv/static/assets/app.css?inline'
4
5	declare global {
6	interface HTMLElement {
7	LitLiveHook?: ViewHook
8	}
9	}