axmad386

CREATE OR REPLACE FUNCTION reset_all_sequences()
RETURNS VOID AS $$
DECLARE
    table_name_var TEXT;
    column_name TEXT;
BEGIN
    -- Loop through all tables in the database
    FOR table_name_var IN (SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_type = 'BASE TABLE') LOOP
 -- Find the name of the sequence associated with the auto-increment column

axmad386

1. List all available wifi, you will see all available wifi with SSID and signal strength

nmcli dev wifi

2. Connect to wifi:

nmcli dev wifi connect "SSID name" password "wifi password"

axmad386

server {
    listen 80;
    server_name ~^(?<subdomain>.+)\.domain\.com domain.com;

    # Location block for path that threated as assets
    location ~* ^/(?<asset>image|css|js|fonts|@vite|node_modules)/(.*) {
        proxy_pass http://127.0.0.1:3000/$asset/$2;
        proxy_set_header Host $host;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_http_version 1.1;

axmad386

public getUrl(location: string): string {
  const {
    endpoint: configEndpoint,
    bucket,
    forcePathStyle,
    region,
  } = this.$config;
  const awsHost = region ? `s3.${region}.amazonaws.com` : "s3.amazonaws.com";
let endpoint = (configEndpoint as string) || `https:${awsHost}`;

axmad386

FROM alpine:edge AS base
# install node
RUN apk add --no-cache nodejs npm tini
# set working directory
WORKDIR /var/www
#install pnpm
RUN npm install -g pnpm
# Set tini as entrypoint
ENTRYPOINT ["/sbin/tini", "--"]
# copy project file

axmad386

• Pastikan rust dan dependencynya sudah terinstall

  curl --proto '=https' --tlsv1.2 -sSf https://sh.rustup.rs | sh
  

• Jika keluar No package dbus-1 found install package tersebut

  sudo apt install libdbus-1-dev pkg-config
  

• Jika keluar error terkait openssl install package berikut

axmad386

buat atau copy kode di bawah di file ~/.config/nvim/init.vim

lua require('plugins')

call plug#begin('~/.vim/plugged')

Plug 'preservim/nerdtree'

Plug 'junegunn/limelight.vim'

axmad386

Basic

Pendahuluan

Part ini wajib dipahami dan dicoba hingga lancar sebelum melangkah ke part yang lain.

Keluar dari VIM

Catatan ini saya taruh di atas untuk pemula yang kadang bingung untuk keluar dari VIM.

• :q untuk keluar dari VIM jika belum melakukan perubahan. Jika sudah melakukan perubahan maka akan terjadi error. Kita harus melakukan save dokument dulu dengan :w.
• :q! jika kita ingin keluar tanpa save. ! artinya ignore. Semacam force quit
• :wq kombinasi dari :w dan :q, artinya save dan exit.

VIM Mode

axmad386

Share Docker Daemon dari Laptop ke Android

Agar android bisa menjalankan docker daemon, diperlukan akses root. Solusi lain selain root adalah dengan cara share docker daemon dari laptop agar bisa diakses di android. Berikut caranya

sudo dockerd -H tcp://0.0.0.0:2375 -H unix:///var/run/docker.sock 

kemudian di android tinggal jalankan docker dengan host ip laptop kitl, misal

docker -H 172.16.10.80 {perintah docker}

axmad386

// src/lib/Support/Http/API.ts

import Axios from 'axios'
import {get} from "svelte/store"
import {Errors$} from "$lib/Support/Store/Error"
import { Auth$ } from '$lib/Support/Store/Auth'
import type {TApiCall} from "$lib/Contract/Http"
import {BASE_API} from "$lib/Env"
import {goto} from "$app/navigation"
import Toast from "$lib/Support/Store/Toast"