.::: Simulation create view with additional ID Unique row_number(),hash /md5 & Primary Key in PostgreSQL EDB :::.

1. Buat Tabel dengan tanggal_lahir
CREATE TABLE karyawan (
    emp_id SERIAL PRIMARY KEY,
    nama VARCHAR(100),
    jabatan VARCHAR(100),
    lokasi VARCHAR(100),
    tanggal_lahir DATE
);

2. Insert Data Sample (dengan tanggal lahir)

.::: Troubleshoot MSSQL SQL Server Procedure or function 'spbuy' expects parameter '@p14', which was not supplied :::.

  

Dari gambar error tersebut terlihat jelas penyebabnya:

Incorrect number of arguments for FUNCTION ... expected 15, got 14

Artinya: FUNCTION atau Stored Procedure spbuy (atau sptaxsample) membutuhkan 15 parameter, tapi saat dipanggil hanya diberikan 14 parameter.

. Tujuan Anda

Anda ingin mensimulasikan kasus tersebut pada database sample SQL Server dengan database contoh bernama hris. 

.::: Simulation create view with additional ID Unique row_number(),hash HASHBYTES/ md5 & Primary Key SQL Server :::.

  

1. Buat Tabel dengan tanggal_lahir
CREATE TABLE karyawan (
    emp_id INT IDENTITY(1,1) PRIMARY KEY,
    nama VARCHAR(100),
    jabatan VARCHAR(100),
    lokasi VARCHAR(100),
    tanggal_lahir DATE
);

2. Insert Data Sample (dengan tanggal lahir)

Saya isi tanggal lahir contoh yang wajar:

INSERT INTO karyawan (nama, jabatan, lokasi, tanggal_lahir) VALUES
('Andi', 'Staff IT', 'Jakarta', '1990-05-12'),
('Sinta', 'HRD', 'Bandung', '1992-11-03'),
('Budi', 'Finance', 'Surabaya', '1988-07-21'),
('Ratna', 'Manager', 'Jakarta', '1985-03-10');

.::: Simulation create view with additional ID Unique row_number(),hash /md5 & Primary Key in MariaDB :::.

 

1. Buat Tabel dengan tanggal_lahir
CREATE TABLE karyawan (
    emp_id INT AUTO_INCREMENT PRIMARY KEY,
    nama VARCHAR(100),
    jabatan VARCHAR(100),
    lokasi VARCHAR(100),
    tanggal_lahir DATE
);
 

.::: Troubleshoot MariaDB Incorrect number of arguments for PROCEDURE teguhth.spbuy; expected 15, got 14 :::.

 

Dari gambar error tersebut terlihat jelas penyebabnya:

Incorrect number of arguments for FUNCTION ... expected 15, got 14

Artinya: FUNCTION atau Stored Procedure spbuy (atau sptaxsample) membutuhkan 15 parameter, tapi saat dipanggil hanya diberikan 14 parameter.

. Tujuan Anda

Anda ingin mensimulasikan kasus tersebut pada database sample MariaDB dengan database contoh bernama hris.

Saya buatkan contoh struktur database, fungsi, dan pemanggilan yang benar & salah, sehingga error yang sama bisa direplikasi.

. SIMULASI DI MARIADB: Database hris

1. Buat Database Sample
CREATE DATABASE IF NOT EXISTS hris;
USE hris;
 

.::: T-SQL Script to Drop All Tables: Foreign-Key Tables First, Then Other Tables, While Excluding One Table (e.g., barang) :::.

 

Berikut beberapa pilihan query SQL Server untuk menampilkan daftar tabel yang memiliki Foreign Key dan diurutkan.

1. Urut berdasarkan nama tabel
SELECT DISTINCT 
    t.name AS TableName
FROM 
    sys.foreign_keys fk
INNER JOIN 
    sys.tables t ON fk.parent_object_id = t.object_id
ORDER BY 
    t.name;
 

.::: Backup & restore table SQL Server Using bcp & SQL CMD like MariaDB (Export SQL Server to csv /txt using t-sql ):::.

 

A. Source (backup data )

1. check table barang 
  

2. Backup data as table using bcp (export mssql to csv txt)

bcp teguhth.dbo.barang out "C:\Backup\barang.txt" -c -t, -S localhost -U usertest -P passwordsql

bcp barang out "C:\Backup\barang.txt" -c -t, -S localhost -U usertest -P passwordsql -d teguhth
 

.::: Drop All tables in database using Truncate & drop :::.

correlation with https://teguhth.blogspot.com/2025/10/script-drop-all-database-non-system-in.html

1. Drop table using script
 
 

2. Drop table using script and duration
 

3. script drop_table_indb.sh

[root@teguhth tbldrop]# pwd
/data/drop/tbldrop
[root@teguhth tbldrop]# cat drop_table_indb.sh
#!/bin/bash
# ===========================================================
# Script Name  : drop_all_tbl_confirm.sh
# Tujuan       : Menghapus semua tables dari 1 Database MariaDB dengan konfirmasi
# OS Diuji     : CentOS 9
# Author       : Teguh Triharto
# ===========================================================

# === Konfigurasi koneksi ===
USER="admin"
PASS="admin"
HOST="localhost"
DBX="secretdb"
PORT="3306"

.::: Check Status MariaDB Database Encryption Configuration (ENCRYPTION_KEY_ID) Audit :::.

 

correlation How to Remove ENCRYPTION_KEY_ID  https://teguhth.blogspot.com/2023/05/how-to-remove-encryptionkeyid-from-file.html
correlation Enable Encryption  https://teguhth.blogspot.com/2023/06/enable-encryption-table-database-for.html

1. Check MariaDB Encryption Global Variables
🔐 Encryption Configuration → variable + key management plugin

SHOW VARIABLES WHERE Variable_name IN ('innodb_encrypt_tables','file_key_management_encryption_algorithm' );

2. Check Encryption Key Management Plugin & Library
🔐 Encryption Configuration → variable + key management plugin

SELECT SUBSTRING_INDEX(@@hostname, '.', 1) AS hostname,PLUGIN_NAME,PLUGIN_STATUS,PLUGIN_TYPE,PLUGIN_LIBRARY FROM information_schema.PLUGINS
WHERE PLUGIN_NAME LIKE '%key_management%';

.::: Simulation API PATCH Curl Using Phyton & MariaDB MySQL with HTTP Status Code 500, 400, 200, 404 :::.

 

continue from https://teguhth.blogspot.com/2025/11/simulation-api-post-using-phyton.html

1. script get sample

[root@teguhth api]# cat patch_api_buy.py
from flask import Flask, request, jsonify
import mysql.connector

app = Flask(__name__)

def get_db():
    return mysql.connector.connect(
        host="localhost",
        user="admin",
        password="admin",
        database="hris"
    )

.::: Simulation API PUT Curl Using Phyton & MariaDB MySQL with HTTP Status Code 500, 400, 200, 404 :::.

 

continue from https://teguhth.blogspot.com/2025/11/simulation-api-post-using-phyton.html

1. script get sample

[root@teguhth api]# cat /data/api/put_api_buy.py
from flask import Flask, request, jsonify
import mysql.connector

app = Flask(__name__)

def get_db():
    return mysql.connector.connect(
        host="localhost",
        user="admin",
        password="admin",
        database="hris"
    )

.::: Simulation API GET Curl Using Phyton & MariaDB MySQL with HTTP Status Code 500, 400, 200, 404 :::.

 

continue from https://teguhth.blogspot.com/2025/11/simulation-api-post-using-phyton.html

1. script get sample

[root@teguhth api]# cat /data/api/get_api_buy.py
from flask import Flask, request, jsonify
import mysql.connector

app = Flask(__name__)

def get_db():
    return mysql.connector.connect(
        host="localhost",
        user="admin",
        password="admin",
        database="hris"
    )

@app.route('/get-buy-period', methods=['GET'])
def get_buy_period():
    # Ambil data dari query string
    year = request.args.get("year")
    month = request.args.get("month")
 

.::: Simulation API POST Using Phyton & MariaDB MySQL with HTTP Status Code 500, 422, 200, 405 :::.

 

1. Install phyton

sudo dnf install python3 python3-pip -y
pip3 install flask mysql-connector-python

2. create database sample & insert data  

CREATE DATABASE hris;
USE hris;

CREATE TABLE buy_period (
    id INT AUTO_INCREMENT PRIMARY KEY,
    period_year INT NOT NULL,
    period_month INT NOT NULL,
    start_date DATE NOT NULL,
    end_date DATE NOT NULL
);