OHua

今天想說重新 review 一次目前所學的 Django 內容 就新開了一個資料夾並且從頭來過 一模一樣的重建一次藉此來複習並熟練

結果在 migrate 的階段噴出錯誤說找不到 zh-TW

OSError: No translation files found for default language zh-TW.

我立刻打開 settings.py 看了看感覺我的設置沒甚麼錯誤阿

OHua

**Ubuntu
sudo gedit /etc/default/apport => enabled = 0
sudo apt-get update
(option)sudo apt update && sudo apt upgrade

**Python
sudo apt-get install python3-pip
sudo apt-get install python3-tk (for matplotlib)
(option) sudo pip3 install virtualenv

OHua

/home/ubuntu/ohua/gitrepo/pypro/member/views.py in checkarrived
            TL.first = ProductPackageClass.objects.filter(package=tl).order_by('date','time').first()
            TL.date = TL.first.start_date
            TL.time = TL.first.start_time
    else :
        raise Http404
    
    product = TL.product
    orderitems = OrderItem.objects.filter(product=product,content_object=TL) ...
    context = {

OHua

**Ubuntu
sudo apt update && sudo apt upgrade
sudo apt install ibus-chewing

**Python
sudo apt-get install python3-pip
pip3 install virtualenv
python3 -m virtualenv --no-site-packages -p python3 kivyinstall
source kivyinstall/bin/activate
(option) python -V # have a nice day!

OHua

構築大綱：ubuntu > nvm > node.js + npm > @vue/cli > vue.js

構築步驟：
1. install nvm from it's github repository
2. install node.js by nvm and get npm at the same time
3. use npm to install vue-cli
4. use vue-cli to construct vue.js MVVM

步驟細節：
sudo apt-get update

OHua

## deploy to GAE
gcloud app deploy app.yaml -v delta
gcloud app deploy dispatch.yaml

## client connet to cloud sql：
wget https://dl.google.com/cloudsql/cloud_sql_proxy.linux.amd64 -O cloud_sql_proxy
chmod +x cloud_sql_proxy
~/cloud_sql_proxy -instances=<project_id>:<region_id>:<database_id>=tcp:3306

## install Google Cloud SDK for gcloud cli-tool

OHua

**Ubuntu
sudo apt update && sudo apt upgrade
sudo apt-get install ibus-chewing

**General tools install
sudo apt-get install git
sudo apt-get install emacs
sudo apt-get install build-essential zlib1g-dev libssl-dev bzip2 libbz2-dev libreadline6-dev libsqlite3-dev
( https://github.com/pyenv/pyenv/wiki/Common-build-problems )
( https://www.cnblogs.com/kevingrace/p/10130801.html )

OHua

##
https://www.contextures.com/xlSampleData01.html#data
https://stackoverflow.com/questions/14529838/apply-multiple-functions-to-multiple-groupby-columns
https://cmdlinetips.com/2018/02/how-to-subset-pandas-dataframe-based-on-values-of-a-column/
https://stackoverflow.com/questions/11869910/pandas-filter-rows-of-dataframe-with-operator-chaining

##
import pandas as pd
import numpy as np

OHua

### Oracle JDK vs Open JDK
different license, performance and stability, but both release new feature and long term support


### install JDK 19 on Ubuntu
1. go to offical website and download .deb package or tarbal file
2. apt install .deb or unzip tarbal into /usr/bin/jvm/


### java version manager