rafirh

GRANT USAGE ON SCHEMA "user" TO username;
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA "user" TO username;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA "user" TO username;
GRANT USAGE ON ALL SEQUENCES IN SCHEMA "user" TO username;

rafirh

SELECT
    terminal.name as terminal,
    city.name as kota,
    COALESCE(count(
        CASE
            WHEN r.is_arrival = true AND r.tvehicle_type_id = 4 THEN r.id
            ELSE null
            END), 0::bigint)                       AS ar_vehicle_akap,
    COALESCE(sum(
        CASE

rafirh

SELECT
    terminal.name as terminal,
    city.name as kota,
    COALESCE(count(
        CASE
            WHEN r.is_arrival = true AND r.tvehicle_type_id = 4 THEN r.id
            ELSE null
            END), 0::bigint)                       AS ar_vehicle_akap,
    COALESCE(sum(
        CASE

rafirh

SELECT
    terminal.name as terminal,
    city.name as kota,
    COALESCE(count(
        CASE
            WHEN r.is_arrival = true AND r.tvehicle_type_id = 4 THEN r.id
            ELSE null
            END), 0::bigint)                       AS ar_vehicle_akap,
    COALESCE(sum(
        CASE

rafirh

import java.io.*;
import java.util.*;

public class Solution {
    public static String formatRupiah(int nominal) {
        String strNominal = String.valueOf(nominal);
        String strNominalFormatted = "";
        int counter = 0;
        for (int i = strNominal.length() - 1; i >= 0; i--) {
            strNominalFormatted = strNominal.charAt(i) + strNominalFormatted;

rafirh

import java.util.Scanner;

public class Solution {
    public static void main(String[] args) {
        Scanner scanner = new Scanner(System.in);

        String kelas = scanner.nextLine();
        String nama = scanner.nextLine();

        System.out.println("Nama : " + nama);

rafirh

import java.util.Scanner;

public class Solution {
    public static void main(String[] args) {
        Scanner scanner = new Scanner(System.in);

        int jumlahOrang = scanner.nextInt();
        scanner.nextLine();

        String[][] jadwalTV = new String[3][3];

rafirh

import java.util.Scanner;

public class Solution {
    public static void main(String[] args) {
        Scanner scanner = new Scanner(System.in);

        String kalimat = scanner.nextLine();
        String hasil = removeVowels(kalimat);

        System.out.println(hasil);

rafirh

import java.util.*;

public class Solution {
    public static void main(String[] args) {
        Scanner scanner = new Scanner(System.in);

        int batasMaksimal = scanner.nextInt();
        scanner.nextLine();

        String kalimat = scanner.nextLine();

rafirh

git filter-branch --env-filter '
WRONG_EMAIL="wrong@example.com"
NEW_NAME="New Name Value"
NEW_EMAIL="correct@example.com"

if [ "$GIT_COMMITTER_EMAIL" = "$WRONG_EMAIL" ]
then
    export GIT_COMMITTER_NAME="$NEW_NAME"
    export GIT_COMMITTER_EMAIL="$NEW_EMAIL"
fi