2021年4月6日 星期二

2021年3月10日 星期三

Travel from Taoyuan to Waipu

Taoyuan -> Waipu

(Bicycle) Expected to leave at 5 PM from DPH to Taoyuan station.(10 minutes)
- 17:00 - 17:10 bicycle to train station in Taoyuan. 

(Train) Expected to leave at 5:30 PM from Taoyuan station to Miaoli. (139-train)
17:30-18:37 139-train from Taoyuan to Miaoli on Friday 

(Train) Expected to leave at 6:54 PM from Miaoli station to Houli. (2237-train)
18:54-19:23 2237-train from Miaoli to Houli on Friday 

台中即時公車動態資訊:業者/豐原客運/214 后里馬場 - 大甲車站(往大甲車站)

- 214 bus information
214 路線公車 即時動態查詢 _ 雲端公車

行動查詢系統

臺中市公車結合去回程的動態到站時刻表

(Bus) Expected to leave at 8:02 PM from 后里車站(后里國小) station to Waipu.
(214 Bus 后里馬場 - 大甲車站(往大甲車站))
Get out at 永豐6鄰 station in Waipu [5023] 永豐6鄰 路線: 214 站序: 35 


--- 2243 will miss time.
17:41-1946 2243-train  [3009] 安眉興安路口 路線: 214 站序: 23

-- 
1801-1934 141-train
1946-1952 3218-train

2021年1月23日 星期六

2019年6月29日 星期六

Easy Batch Insert Events into Google Calendar

Version 2:
Easy Batch Insert Events into Google Calendar 2: By using HTML

Easy Batch Insert Events into Google Calendar

Step 1. Open HTML and Generate Month by clicking button
Step 2. Type the even type
Step 3. Upload calendar events with type not null by clicking button


------

2019年5月14日 星期二

[Python] [pyinstaller] release to the exe file

Step 1: Open "Anaconda Prompt" for the installer command. Of course, you must install the relative application in your PC first.
Step 2:
type the install command:
ex:
pyinstaller -F F:\WEI_LUN\code_project\python\project\ptyhon_project\main_crawler.py

------
That is all.


Note:
The pyinstaller error from the NoteBook:
python用pyinstaller生成exe时报错 TypeError: an integer is required (got type bytes)
https://blog.csdn.net/chen_soldier/article/details/102667201

2019年4月29日 星期一

sqlite: Add TIMESTAMP to my table

--- Create Template Table  ---
DROP TABLE MY_BACKUP;

CREATE TABLE MY_BACKUP(
person_id INTEGER PRIMARY KEY AUTOINCREMENT,
my_link TEXT,
my_state CHAR(15),
my_name TEXT,
record_state INT,
time_stamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Insert into MY_BACKUP(my_link, my_state, my_name, record_state)
    Select my_link, my_state, my_name, record_state
    From my_link_db;

select * from MY_BACKUP;

---  Add TIMESTAMP to My Current Table and  Copy Data from Template Table  ---
DROP TABLE my_link_db;

CREATE TABLE my_link_db(
person_id INTEGER PRIMARY KEY AUTOINCREMENT,
my_link TEXT,
my_state CHAR(15),
my_name TEXT,
record_state INT,
time_stamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Insert into my_link_db(my_link, my_state, my_name, record_state)
    Select my_link, my_state, my_name, record_state
    From MY_BACKUP;

---  DROP Template Table -------------------------------
DROP TABLE MY_BACKUP;

2019年3月9日 星期六

Bug Report: No sound notification for my google home

A correct behavior for the reminder:
1. Setting Reminder by voice command:
My script:
me: Hey Google, set my reminder.
Google: ...(omit)
me: test my reminder.
Google: ...(omit)
me: in 4 minutes
Google: ...(omit)


2.The response for the test reminder:

-------
3. Setting Reminder by using calendar in my browser:


4. The response for the test reminder:
No Sound Notification for my google home???


Does anyone knows what's going on???
-------