A1go │ deBlog

[Python] Pause

2023.03.16
Python

input("Press the <ENTER> key to continue...")

基礎用法 import pymysql connection = pymysql.connect( host='localhost', port=3306, user='root', passwd='******', db='db', charset='utf8' ) #--- cursor = connection.cursor() def execute(sql): try: cursor.e ...

[Ubuntu] MySQL

2023.03.16
Linux MySQL Ubuntu 22.04

使用密碼登入 MySQL mysql -u {User Name} -p

[Python] Error/Exception Processing (try statement; try-except)

2023.03.16
Python try statement (try-except)

try / except / else / finally try: ... except A: ... except B as b: ... except (C, D) as e: ... else: ... finally: # 必定被執行 ... Exception BaseException 是由全部的例外所共用的 base class。它的 subclass（子類別）之一，Except ...

常用 SQL

2023.03.16
SQL

Database CREATE DATABASE CREATE DATABASE database_name; USE USE database_name; Data Types Numeric Data Integer Float Money Date and Time Character strings Non-Unicode / Unicode char(n) / nchar(n) 長度 ...

XPath

2023.03.15
Web Design

XPath Syntex Expression Description nodename 選取所有 name 為 nodename 的節點 / 選取自 current node 的下一層 ‘/’ 表示 root 故以 ‘/’ 開頭的路徑為絕對路徑 // 選取 current node 下所有符合條件的節點 . 選取 current node .. 選 ...

[Python] Scrapy

2023.03.15
[Python] Scrapy

安裝 pip install scrapy 註1：pip 中 pyopenssl 版本為 22.1.0, cryptography 版本為 38.0.4 註2：scrappy scrapy 爬蟲創建新專案 $ scrapy startproject {Project Name} 專案結構 {Project Name} scrapy.cfg {Project Name} spiders __ini ...

[Apache 2] 從 domain.name 重定向至 www.domain.name

2023.03.15
Apache2

sudo nano /etc/apache2/sites-available/000-default.conf <VirtualHost *:80> ServerName domain.name Redirect permanent / http://www.domain.name/ </VirtualHost> <VirtualHost *:80> Serve ...

[Ubuntu] 更改 Apache 的 Document Root

2023.02.02
Linux

將 /var/www/ 更名：sudo mv /var/www/ /var/ori_www/ 建立 /home/user/www/：sudo mkdir /home/user/www 修改 /etc/apache2/apache2.conf <Directory /home/user/www/> AllowOverride None Requir ...

[筆記] ⭐️ Apache2 + Uncomplicated Firewall + uWSGI + Flask

2023.02.02
Linux Ubuntu 22.04 Uncomplicated Firewall

安裝 Django Flask 我使用sudo pip install Flask安裝時出現了以下錯誤 (記得使用 sudo ) 所以改用sudo pip install --ignore-installed Flask Installing collected packages: MarkupSafe, itsdangerous, click, blinker, Werkzeug, Jinja2 ...