Posts

Showing posts from December, 2020

Koneksi ke Linux dari Windows melalui ssh Tanpa Password

Membuat dan instalasi ssh key Jalankan PowerShell (Administrator) Masuk ke folder ssh cd c:\users\{ACCOUNT}\.ssh Buat ssh key ssh-keygen -t rsa Kopikan ssh key ke romote server type $env:USERPROFILE\.ssh\id_rsa.pub | ssh {REMOTE_HOST} "cat >> .ssh/authorized_keys" Tambahkan ssh key ke shell Windows ssh-agent $SHELL Tambahkan ssh key ke Agen Windows ssh-add Setting remote ssh authorized di server (Linux) Masuk ke remote host ssh {REMOTE_HOST} Buat folder ssh mkdir ~/.ssh Ubah permision ke folder ssh chmod 700 ~/.ssh Buat file authorized touch ~/.ssh/authorized_keys Ubah permision ke authorized file chmod 600 ~/.ssh/authorized_keys
Post a Comment
Read more

cURL Contoh Penggunaan GET, POST, PUT, dan DELETE

Berikut ini contoh-contoh penggunaan cURL dalam pengoperasian data antara server dan client. POST Menyimpan data sales ke server. curl -X POST http://localhost:3000/api/sales \ -H "Content-Type: application/json" \ -d '{"name":"saita","street":"ds. plumbon","city":"Indramayu","phone":"0234","cell":"0895","zip":"45212"}' # result {"id":1,"name":"saita","street":"ds. plumbon","city":"Indramayu","phone":"0234","cell":"0895","zip":"45212","created_at":"2020-12-24T07:43:06.966Z","updated_at":"2020-12-24T07:43:06.966Z"} PUT Mengubah data sales di server. curl -H "Content-Type: application/json" \ -X PUT http://l...
Post a Comment
Read more

Install postgresql-12 on CentOS7 WSL

Yang harus pertama kali dilakukan sebelum install Postgresql: mv /usr/bin/systemctl /usr/bin/systemctl.old curl https://raw.githubusercontent.com/gdraheim/docker-systemctl-replacement/master/files/docker/systemctl.py > /usr/bin/systemctl chmod +x /usr/bin/systemctl Anda harus install systemctl3.py jika anda menggunakan python 3 yang terpasang di system. Install PostgreSQL 12 Tahapan instalasi PostgreSQL 12 sudo vi /etc/yum.repos.d/CentOS-Base.repo Setelah terminal menampilkan informasi seperti di bawah ini, ketikkan :wq untuk menyimpan repos. ... [base] name=CentOS-$releasever - Base mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os&infra=$infra #baseurl=http://mirror.centos.org/centos/$releasever/os/$basearch/ gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7 exclude=postgresql* #released updates [updates] name=CentOS-$releasever - Updates mirrorlist=http://mirrorlist.centos.org...
Post a Comment
Read more

Home / Index

import 'dotenv/config'; import compression from 'compression' import express from 'express' import OrderRouter from './routers/order.router' const port: number = 3000 const app: express.Application = express() app.use(compression()) app.use(express.urlencoded({ extended: true })) app.use(express.json()) OrderRouter(app); app.get('/', (req, res) => res.send('Hello World!')) app.listen(port, () => console.log(`Example app listening on port ${port}!`))
Post a Comment
Read more

Interfaces

export interface iOrder { id : number , customer_id : number , sales_id : number , due_date : Date , total : number , cash : number , payments : number , remain_payment : number , created_at : Date , updated_at : Date } export interface iSales { id : number , name : string , street ? : string , city : string , phone ? : string , cell ? : string , zip ? : string , created_at : Date , updated_at : Date } ? means allow NULL value for field.
Post a Comment
Read more

Payment Table

CREATE   SEQUENCE  payments_sequence    AS   INT    START   1   INCREMENT  BY   1    NO  MINVALUE    NO  MAXVALUE   CACHE  1 ; CREATE   TABLE  payments (   id  INT   NOT   NULL   DEFAULT  nextval( 'payments_sequence' ::regclass),   order_id  INT   NOT   NULL ,   method_id  SMALLINT   NOT   NULL ,   amount  NUMERIC ( 11 , 2 )  NOT   NULL , descriptions VARCHAR(128),   created_at  TIMESTAMP   NOT   NULL ,   updated_at  TIMESTAMP   NOT   NULL ); ALTER   TABLE  ONLY payments    ADD   CONSTRAINT  pk_payments  PRIMARY   KEY  (id); CREATE   INDEX  payments_ix_orders  ON  payments    USING  btree (order_id); CREATE  TRIGGER...
Post a Comment
Read more

Sales Table

CREATE SEQUENCE sales_sequence AS SMALLINT START 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ; CREATE TABLE sales ( id INT NOT NULL DEFAULT nextval ( ' sales_sequence ':: regclass ), name VARCHAR ( 50 ) NOT NULL , street VARCHAR ( 128 ) , city VARCHAR ( 50 ) NOT NULL , phone VARCHAR ( 25 ) NOT NULL , cell VARCHAR ( 25 ) , zip VARCHAR ( 6 ) , created_at TIMESTAMP NOT NULL , updated_at TIMESTAMP NOT NULL ); ALTER TABLE sales ADD CONSTRAINT pk_sales PRIMARY KEY ( id ); CREATE UNIQUE INDEX sales_ix_name ON sales USING btree ( name ); CREATE TRIGGER sales_trig_create BEFORE INSERT ON sales FOR EACH ROW EXECUTE FUNCTION timestamp_on_create (); CREATE TRIGGER sales_trig_update BEFORE UPDATE ON sales FOR EACH ROW EXECUTE FUNCTION timestamp_on_update ();
Post a Comment
Read more

Order Table

CREATE   FUNCTION  orders_on_create()  RETURNS  trigger    LANGUAGE  plpgsql    AS  $$ BEGIN   NEW.remain_payment = NEW.total - (NEW.cash + NEW.payments);   NEW.updated_at =  now ();    RETURN  NEW; END ; $$; CREATE   SEQUENCE  orders_sequence    AS   INT    START   1   INCREMENT  BY   1    NO  MINVALUE    NO  MAXVALUE   CACHE  1 ; CREATE   TABLE  orders (   id  INT   NOT   NULL   DEFAULT  nextval( 'orders_sequence' ::regclass),   customer_id  SMALLINT   NOT   NULL ,   sales_id  SMALLINT   NOT   NULL ,   due_date  TIMESTAMP   NOT   NULL ,   total  NUMERIC ( 11 ,  2 )  NOT   NULL ,   cash  NUMER...
Post a Comment
Read more

Popular posts from this blog

Order Table

CREATE   FUNCTION  orders_on_create()  RETURNS  trigger    LANGUAGE  plpgsql    AS  $$ BEGIN   NEW.remain_payment = NEW.total - (NEW.cash + NEW.payments);   NEW.updated_at =  now ();    RETURN  NEW; END ; $$; CREATE   SEQUENCE  orders_sequence    AS   INT    START   1   INCREMENT  BY   1    NO  MINVALUE    NO  MAXVALUE   CACHE  1 ; CREATE   TABLE  orders (   id  INT   NOT   NULL   DEFAULT  nextval( 'orders_sequence' ::regclass),   customer_id  SMALLINT   NOT   NULL ,   sales_id  SMALLINT   NOT   NULL ,   due_date  TIMESTAMP   NOT   NULL ,   total  NUMERIC ( 11 ,  2 )  NOT   NULL ,   cash  NUMER...
Read more

Surah Yā Sīn

Surah ke–36 Terdiri atas 83 ayat Termasuk Surat Makkiyyah يٰسۤ ۚ yā sīn yaa siin وَالْقُرْاٰنِ الْحَكِيْمِۙ wal-qur`ānil-ḥakīm Demi Al-Qur’an yang penuh hikmah, اِنَّكَ لَمِنَ الْمُرْسَلِيْنَۙ innaka laminal-mursalīn sungguh, engkau (Muhammad) adalah salah seorang dari rasul-rasul, عَلٰى صِرَاطٍ مُّسْتَقِيْمٍۗ ‘alā ṣirāṭim mustaqīm (yang berada) di atas jalan yang lurus, تَنْزِيْلَ الْعَزِيْزِ الرَّحِيْمِۙ tanzīlal-‘azīzir-raḥīm (sebagai wahyu) yang diturunkan oleh (Allah) Yang Mahaperkasa, Maha Penyayang, لِتُنْذِرَ قَوْمًا مَّآ اُنْذِرَ اٰبَاۤؤُهُمْ فَهُمْ غٰفِلُوْنَ litunżira qaumam mā unżira ābā`uhum fa hum gāfilụn agar engkau memberi peringatan kepada suatu kaum yang nenek moyangnya belum pernah diberi peringatan, karena itu mereka lalai. لَقَدْ حَقَّ الْقَوْلُ عَلٰٓى اَكْثَرِهِمْ فَهُمْ لَا يُؤْمِنُوْنَ laqad ḥaqqal-qaulu ‘alā akṡarihim fa hum lā yu`minụn Sungguh, pasti berlaku perkataan (hukuman) terhadap kebanyakan mereka, karena ...
Read more

cURL Contoh Penggunaan GET, POST, PUT, dan DELETE

Berikut ini contoh-contoh penggunaan cURL dalam pengoperasian data antara server dan client. POST Menyimpan data sales ke server. curl -X POST http://localhost:3000/api/sales \ -H "Content-Type: application/json" \ -d '{"name":"saita","street":"ds. plumbon","city":"Indramayu","phone":"0234","cell":"0895","zip":"45212"}' # result {"id":1,"name":"saita","street":"ds. plumbon","city":"Indramayu","phone":"0234","cell":"0895","zip":"45212","created_at":"2020-12-24T07:43:06.966Z","updated_at":"2020-12-24T07:43:06.966Z"} PUT Mengubah data sales di server. curl -H "Content-Type: application/json" \ -X PUT http://l...
Read more