Skip to content

Instantly share code, notes, and snippets.

View radityopw's full-sized avatar

radityo radityopw

View GitHub Profile
@radityopw
radityopw / Dockerfile
Created November 10, 2023 13:12
Dockerfile PHP-8.2 dengan Ubuntu 20.04
FROM ubuntu:20.04
LABEL author="Radityo P W ([email protected])"
ARG DEBIAN_FRONTEND=noninteractive
# UPDATE PACKAGES
RUN apt-get update
# INSTALL SYSTEM UTILITIES
-- pilih database dan cek apakah ada perbedaan user dengan login
USE [nama database];
EXEC sp_change_users_login 'Report';
-- jika user dan login memiliki nama yang sama, gunakan autofix
EXEC sp_change_users_login 'Auto_Fix', '<nama user>';
-- jika user dan login memiliki nama yang berbeda, lakukan penyematan ulang
@radityopw
radityopw / Dockerfile
Created December 3, 2022 02:50
Dockerfile php8.1 + Ubuntu 20.04
FROM ubuntu:20.04
LABEL author="Radityo P W ([email protected])"
ARG DEBIAN_FRONTEND=noninteractive
# UPDATE PACKAGES
RUN apt-get update
# INSTALL SYSTEM UTILITIES
@radityopw
radityopw / Dockerfile
Last active August 13, 2022 15:14
php7.4 + ubuntu 20.04
FROM ubuntu:20.04
LABEL author="Radityo P W ([email protected])"
ARG DEBIAN_FRONTEND=noninteractive
# UPDATE PACKAGES
RUN apt-get update
# INSTALL SYSTEM UTILITIES
@radityopw
radityopw / readonly_all_db.sql
Last active July 25, 2022 03:57
generate script for adding user in database and datareader member
DECLARE @dbname VARCHAR(50)
DECLARE @statement NVARCHAR(max)
DECLARE db_cursor CURSOR
LOCAL FAST_FORWARD
FOR SELECT name FROM MASTER.dbo.sysdatabases OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @dbname
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT @statement = 'use ['+@dbname+']; '+'CREATE USER [monitoring] FOR LOGIN [monitoring];';
@radityopw
radityopw / Dockerfile
Last active August 14, 2022 02:51
docker php7.4_ubuntu18.04_sqlsrv
FROM ubuntu:18.04
LABEL author="Radityo P W ([email protected])"
ARG DEBIAN_FRONTEND=noninteractive
# UPDATE PACKAGES
RUN apt-get update
# INSTALL SYSTEM UTILITIES
@radityopw
radityopw / php_session_in_gcp.php
Created April 28, 2022 07:37
session handler using google cloud storage
<?php
require_once 'vendor/autoload.php';
use Google\Cloud\Storage\StorageClient;
class MySessionHandler implements SessionHandlerInterface{
private $savePath;
private $storage;
private $bucket;
public function __construct(){
@radityopw
radityopw / clear_temporal_table.sql
Last active November 20, 2023 09:54
menghapus isi history table / temporal table pada sqlserver
declare @table nvarchar(255)
declare @sql nvarchar(max)
-- setting table name
set @table = 'dbo.test'
-- melepas sistem versioning
set @sql = 'ALTER TABLE '+@table+' SET (SYSTEM_VERSIONING = OFF);'
print(@sql)
@radityopw
radityopw / CommandResult.java
Created October 15, 2021 14:30
membuat db sederhana part 2
package com.radityopw.simpledb;
public class CommandResult{
public static final int OK = 1;
public static final int ERROR = 2;
public static final int EXIT = 3;
public int status = CommandResult.OK;
public String message = "";
@radityopw
radityopw / .gitignore
Created October 15, 2021 12:16
membuat DBMS sederhana day 1
# Swap
[._]*.s[a-v][a-z]
!*.svg # comment out if you don't need vector files
[._]*.sw[a-p]
[._]s[a-rt-v][a-z]
[._]ss[a-gi-z]
[._]sw[a-p]
# Session
Session.vim