AgungPambudi

# Panduan Penggunaan Git

## Mengunduh Repository

Unduh repository ke dalam komputer menggunakan perintah `git clone`. Url
repository dapat dilihat di dalam repository yang diinginkan.

```
git clone <url repository> <folder tujuan>
```

AgungPambudi

/*
file: MySQL Common Table Expression (CTE).sql
language: SQL
author: mail@agungpambudi.com Agung Pambudi
description: SQL Advanced Crypto

Enter your query below.
Please append a semicolon ";" at the end of the query
*/

AgungPambudi

""" 
file: Football Competition Winner's Goals.py
language: python3
author: mail@agungpambudi.com Agung Pambudi
description: REST API: Football Competition Winner's Goals
"""

#!/bin/python3
#
# Complete the 'getWinnerTotalGoals' function below.

AgungPambudi

$ pip3 freeze > requirements.txt  # Python3
$ pip freeze > requirements.txt  # Python2


# if you want to list only packages used inside a virtualenv use:
$ source <myvenvname>/bin/activate         # or in Windows cd <myenvname>\Scripts\   then type activate.bat  Enter
$ pip freeze -l > requirements.txt 


# install packages using pip according to the requirements.txt file from a local directory

AgungPambudi

# pip install firebase-admin pandas xlrd==1.2.0

import firebase_admin
from firebase_admin import credentials
from firebase_admin import firestore

from xlrd import open_workbook

credential_info = credentials.Certificate("path/to/service_account.json")
firebase_admin.initialize_app(credential_info)

AgungPambudi

#author          : Agung Pambudi
#email           : mail@agungpambudi.com
#version         : 0.4
#
#
#==============================================================================
#                                   _         _ _
# ___ ___ _ _ ___ ___ ___ ___ _____| |_ _ _ _| |_|  ___ ___ _____
#| .'| . | | |   | . | . | .'|     | . | | | . | |_|  _| . |     |
#|__,|_  |___|_|_|_  |  _|__,|_|_|_|___|___|___|_|_|___|___|_|_|_|

AgungPambudi

#author          : Agung Pambudi
#email           : mail@agungpambudi.com
#version         : 0.2
#
#
#==============================================================================
#                                   _         _ _
# ___ ___ _ _ ___ ___ ___ ___ _____| |_ _ _ _| |_|  ___ ___ _____
#| .'| . | | |   | . | . | .'|     | . | | | . | |_|  _| . |     |
#|__,|_  |___|_|_|_  |  _|__,|_|_|_|___|___|___|_|_|___|___|_|_|_|

AgungPambudi

#author          : Agung Pambudi
#email           : mail@agungpambudi.com
#version         : 0.2
#
#KyusuMart Planogram Analysis
#==============================================================================
#                                   _         _ _
# ___ ___ _ _ ___ ___ ___ ___ _____| |_ _ _ _| |_|  ___ ___ _____
#| .'| . | | |   | . | . | .'|     | . | | | . | |_|  _| . |     |
#|__,|_  |___|_|_|_  |  _|__,|_|_|_|___|___|___|_|_|___|___|_|_|_|

AgungPambudi

#author          : Agung Pambudi
#email           : mail@agungpambudi.com
#version         : 0.1
#
#KyusuMart Planogram Analysis
#==============================================================================
#                                   _         _ _
# ___ ___ _ _ ___ ___ ___ ___ _____| |_ _ _ _| |_|  ___ ___ _____
#| .'| . | | |   | . | . | .'|     | . | | | . | |_|  _| . |     |
#|__,|_  |___|_|_|_  |  _|__,|_|_|_|___|___|___|_|_|___|___|_|_|_|

AgungPambudi

#author          : Agung Pambudi
#email           : mail@agungpambudi.com
#version         : 0.1
#==============================================================================
#                                   _         _ _
# ___ ___ _ _ ___ ___ ___ ___ _____| |_ _ _ _| |_|  ___ ___ _____
#| .'| . | | |   | . | . | .'|     | . | | | . | |_|  _| . |     |
#|__,|_  |___|_|_|_  |  _|__,|_|_|_|___|___|___|_|_|___|___|_|_|_|
#    |___|       |___|_|