Flask实现Json数据存库和收藏功能

最新推荐文章于 2024-09-03 08:18:53 发布

Are you ready

最新推荐文章于 2024-09-03 08:18:53 发布

阅读量1.1k

点赞数 2

分类专栏： MTV框架文章标签： Flak收藏功能

本文链接：https://blog.youkuaiyun.com/pythoncsdn111/article/details/94338205

版权

轮播收藏

JSON数据存入数据

import json

import pymysql

#获取json里的轮播图片数据
def read_banners():

    images = []

    with open("getBanner.json") as banners_file:
        banners_json = banners_file.read()
        print(banners_json)
        banners_data = json.loads(banners_json).get("data")

        # print(banners_data)

        for banner in banners_data:
            image = banner.get("image")
            images.append(image)

    return images


def insert_db(images):
#连接数据库
    mysql_client = pymysql.Connect(host="localhost", port=3306, user="root", password="*******", charset="utf8", database="FlaskWork")
#开启事务
    mysql_client.begin()
#创建游标
    cursor = mysql_client.cursor()

    for image in images:

        cursor.execute('INSERT INTO banner(image) VALUES ("%s");' % image)
#提交到轮播图表里
    mysql_client.commit()


if __name__ == '__main__':
    images = read_banners()
    print(images)

    insert_db(images）

import json
import pymysql
#电影数据的插入
def read_movies():

    with open("getMovies.json") as movies_file:
        movies_json = movies_file.read()
        # print(movies_json)
        movies_data = json.loads(movies_json).get("data")

        # print(movies_data)

        return movies_data


def insert_db(movies):
    mysql_client = pymysql.Connect(host="localhost", port=3306, user="root", password="", charset="utf8", database="FlaskWork")

    mysql_client.begin()

    cursor = mysql_client.cursor()

    for movie in movies:

        image = movie.get("image")
        title = movie.get("title")
        duration = movie.get("duration")
        postid = movie.get("postid")

        print(image, title, duration, postid)

        cursor.execute('INSERT INTO movie(image, title, duration, postid) VALUES ("%s", "%s", %d, %d);' % (image, title, int(duration), int(postid)))

    mysql_client.commit()


if __name__ == '__main__':
    movies = read_movies()
    print(movies)

    insert_db(movies)
</