Skip to content

Instantly share code, notes, and snippets.

View ziterz's full-sized avatar

Ziady Mubaraq ziterz

View GitHub Profile
@ziterz
ziterz / api_doc.md
Last active November 29, 2023 20:00
Movie API Documentation

Movie API Documentation

Endpoints :

List of available endpoints:

  • POST /register
  • POST /login
  • GET /movies
  • DELETE /movies/:id
@ziterz
ziterz / association.md
Last active June 26, 2023 00:32
Sequelize Association

Double One-to-Many

User Grant Profile
User.hasMany(Grant) Grant.belongsTo(User) Profile.hasMany(Grant)
Grant.belongsTo(Profile)

Many-to-Many

@ziterz
ziterz / main.js
Last active August 19, 2021 05:50
Redux with Plain Javascript
const createStore = (reducer) => {
let state
let listeners = []
const getState = () => state
const dispatch = (action) => {
state = reducer(state, action)
listeners.forEach(listener => listener())
}
@ziterz
ziterz / product.js
Created December 22, 2020 04:37
sequelize
// sequelize
Product
.findAndCountAll(paramQuerySQL)
.then(response => {
res.status(200).json(response);
})
.catch(err => next(err));
@ziterz
ziterz / product.js
Created December 22, 2020 04:27
pagination
// pagination
if (page != '' && typeof page !== 'undefined') {
if (page.size != '' && typeof page.size !== 'undefined') {
limit = page.size;
paramQuerySQL.limit = limit;
}
if (page.number != '' && typeof page.number !== 'undefined') {
offset = (page.number * limit) - limit;
paramQuerySQL.offset = offset;
@ziterz
ziterz / product.js
Created December 22, 2020 04:25
sorting
// sorting
if (sort != '' && typeof sort !== 'undefined') {
let query = sort.split(',');
query = query.map(function(item) {
if (item.charAt(0) !== '-') {
return [
[item, 'ASC']
]
} else {
return [
@ziterz
ziterz / product.js
Created December 22, 2020 04:12
filtering - [title]
// filtering - [title]
if (filter != '' && typeof filter !== 'undefined') {
let query = filter.title.split(',').map(function(item) {
return {
[Op.iLike]: '%' + item + '%'
}
});
paramQuerySQL.where = {
title: { [Op.or]: query }
@ziterz
ziterz / product.js
Last active December 22, 2020 04:12
menginisialisasi variabel
// menginisialisasi variabel
let { filter, sort, page } = req.query;
let paramQuerySQL = {};
let limit, offset;
@ziterz
ziterz / API.md
Created October 25, 2020 14:55
REST API documentation from @iros

Movie App

Movie App is an database for movies and TV shows.

RESTful Endpoints

  • GET /movies/:id

Show Movie

Returns json data about a single movie.

@ziterz
ziterz / App.vue
Last active July 21, 2020 17:49
Vuex State Management - Lecture
<template>
<div id="app">
<Navbar/>
<router-view/>
</div>
</template>
<script>
import Navbar from '@/components/Navbar'