PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;

CREATE TABLE temps(
    name DEFAULT 'RPi.CPU', 
    tdatetime DATETIME DEFAULT (datetime('now', 'localtime')), 
    temperature NUMERIC NOT NULL
);

COMMIT;

#!/usr/bin/env python
# -*- coding: utf-8 -*-
import time
import sqlite3

def get_cpu_temp():
    # 打开文件
    file = open("/sys/class/thermal/thermal_zone0/temp")
    # 读取结果，并转换为浮点数
    temp = float(file.read()) / 1000
    # 关闭文件
    file.close()
    return temp

def insert_cpu_temp(temp):
    # 连接数据库
    conn=sqlite3.connect('cpu.db')
    curs=conn.cursor()  
    
    # 插入数据库
    strtemp = "%.1f" %(temp);
    curs.execute("INSERT INTO temps(temperature) VALUES((?))", (strtemp,))
    conn.commit()
    
    # 关闭数据库
    conn.close()

def main():
    while True:
        temp = get_cpu_temp()
        insert_cpu_temp(temp)
        time.sleep(5*60) 

if __name__ == '__main__':
    main()