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


------

[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

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;

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???
-------

install pyautogui

Windows can't install pyautogui 0.9.41:
https://github.com/asweigart/pyautogui/issues/292

Solution: Please to install pyautogui 0.9.39 by using the following command line

pip install pyautogui===0.9.39

ref: https://github.com/asweigart/pyautogui/issues/292

Dos Command

1. shutdown your computer
ex:
shutdown your computer after 7200 seconds:

shutdown -s -f -t 7200

stop shutdown:

shutdown -a

find help

shutdown /?

2.  set schedule to shutdown pc
2-1 set shutdown s shutdown_s.bat

shutdown -s

2-2 process schedule shutdown_at_0000.bat on the command line

schtasks /create /tn "shutdown_at_0000" /tr "E:\wei_lun\code\bat\shutdown_s.bat" /sc daily /st 00:00 /ed 3002/12/31

2-3 view your schedule