radityopw

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

# 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

radityopw

CREATE TRIGGER <schema>.<table_name>_read_only_events ON <schema>.<table_name>
    INSTEAD OF INSERT,
               UPDATE,
               DELETE
AS
BEGIN
    RAISERROR( 'table is read only.', 16, 1 )
    ROLLBACK TRANSACTION
END

radityopw

;WITH CTE_Dev
AS (
    SELECT C.column_id
        ,ColumnName = C.NAME
        ,C.max_length
        ,C.user_type_id
        ,C.precision
        ,C.scale
        ,DataTypeName = T.NAME
    FROM sys.columns C

radityopw

# install library
pip install pywin32

# import komponen

import win32com.client

# untuk membuka excel 
xl = win32com.client.Dispatch('Excel.Application')

radityopw

import pyodbc
import time
from shutil import copy
import smtplib
import os
import datetime

def backup_db(cnxn,mode,backup_dir,secondary_backup_dirs,dbname):

    backup_name = dbname+"-"+mode+" database backup"

radityopw

/*

drop table #source ;
drop table #source_diff;
drop table #source_deleted;

*/


declare @last_synchronization_version bigint;

radityopw

CREATE TABLE [dbo].[change_tracking_data](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[nama] [varchar](50) NOT NULL,
 CONSTRAINT [PK_change_tracking_data] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

radityopw

import sqlalchemy
from sqlalchemy.pool import NullPool
from sqlalchemy import text


def connect_sqlserver():

    user = ""
    password = ""
    database = ""

radityopw

CREATE TABLE `pegawai_replicated` (
  `id` int(11) NOT NULL,
  `nama` varchar(50) NOT NULL,
  `jenis_kelamin` char(1) NOT NULL,
  `is_deleted` tinyint(4) NOT NULL
) ENGINE=Aria DEFAULT CHARSET=utf8mb4;

ALTER TABLE `pegawai_replicated`
  ADD PRIMARY KEY (`id`);