web.py mysql_update.py

"""
web.py mysql_update.py
参考：http://webpy.org/cookbook/update.zh-cn
功能：mysql update
测试URL:
http://localhost:8080/hello
http://127.0.0.1:8080/hello
http://127.0.0.1:8080/mysql/update

服务器响应：
Hello, world!
成功。
"""
import web

# 建立数据库连接。
db = web.database(dbn='mysql', db='test', user='root', pw='123456')
# db = web.database(dbn="mysql", host="localhost", port=3306, db="test", user="root", pw="123456")
urls = (
    "/hello", "Hello",
    "/mysql/update", "MysqlUpdate",
)


class Hello:
    def GET(self):
        """
        此方法，必须是大写。
        如果改成get，则报错："HTTP/1.1 GET /" - 405 Method Not Allowed。
        :return:
        """
        return 'hello, world!'


class MysqlUpdate:
    def GET(self):
        table = "customers"
        # UPDATE customers SET salary = 2000 WHERE id = 3
        db.update(table, where="id = 3", salary=2000)
        return 'updated.'


if __name__ == "__main__":
    app = web.application(urls, globals())
    app.run()