wordpress商品信息整理并通过Django管理

行云流水
2022-07-21 / 0 评论 / 257 阅读 / 正在检测是否收录...

前言

通过上一篇文章: wordpress直接通过数据库导出文章标题、分类信息到xls表格 ,将数据导入到excel表格中了。在处理的过程中发现仍然不是很方便,一是数据量有点大,每次打开更新需要的的时间有点久。另外无法统计分析。于是想把它输入到自己的数据库中,方便处理查看查询。

Django添加新模块resource

from django.db import models

#状态
U   = 0
Y   = 1
N   = 2

STATUS_CHOICE = {
    U: '未处理',
    Y: '可用',
    N: '不可用',
}

# Create your models here.
class Resource(models.Model):
    '''
    任务模型类
    '''
    id = models.AutoField(primary_key=True)
    rid = models.CharField(max_length=16, verbose_name='编号', default='0')
    rtitle = models.CharField(max_length=256, verbose_name='标题')
    rcontent = models.TextField(max_length=2048*8, verbose_name='说明')
    rparent1 = models.CharField(max_length=128, verbose_name='一级分类', default='0')
    rparent2 = models.CharField(max_length=128, verbose_name='二级分类', default='1')
    rurl = models.CharField(max_length=256, verbose_name='下载链接', default='0')
    rpwd = models.CharField(max_length=256, verbose_name='解压密码', default='0')
    status_choices = ((k, v) for k,v in STATUS_CHOICE.items())
    rstatus = models.SmallIntegerField(default='0', choices=status_choices, verbose_name='状态')

    # admin显示订单的id
    def __str__(self):
        return self.rtitle

    class Meta:
        db_table = 'code_resource'
        verbose_name = '源码资源'
        verbose_name_plural = '源码资源'

# 修改项目settings.py,添加模块
INSTALLED_APPS = [ 
  ...
  'resource', 
  ...
  ],

# 更新
python3 manage.py makemigrations
python3 manage.py migrate

show create table code_resource;

待处理资源wordpress数据库操作

CREATE TABLE `code_resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rid` varchar(16) COLLATE utf8_bin NOT NULL,
  `rtitle` varchar(256) COLLATE utf8_bin NOT NULL,
  `rcontent` longtext COLLATE utf8_bin NOT NULL,
  `rparent1` varchar(128) COLLATE utf8_bin NOT NULL,
  `rparent2` varchar(128) COLLATE utf8_bin NOT NULL,
  `rurl` varchar(256) COLLATE utf8_bin NOT NULL,
  `rpwd` varchar(256) COLLATE utf8_bin NOT NULL,
  `rstatus` smallint(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=60031 DEFAULT CHARSET=utf8 COLLATE=utf8_bin

insert into code_resource(rid, rtitle, rcontent, rparent1, rparent2, rurl, rpwd, rstatus) 
select
    a.ID,
    a.post_title,
    a.post_content,
    (select name from wp_terms where term_id =  b.parent) as parent1,  
    c.name  as sparent2, 
    ifnull((select meta_value from  wp_postmeta where post_id = a.ID and meta_key = '_riplus_down_info'), 'x') as resource, 
    ifnull((select meta_value from  wp_postmeta where post_id = a.ID and meta_key = '_riplus_other_info'), 'x') as pwd,
    0 as rstatus
from wp_term_taxonomy b 
join  wp_terms c 
on b.term_id = c.term_id 
join  wp_term_relationships d
on b.term_taxonomy_id = d.term_taxonomy_id
join wp_posts a
on a.ID = d.object_id
where b.taxonomy = 'category'
and b.parent != 0;

# 导出
 mysqldump  -uroot -pxxxx -h 127.0.0.1  yonp code_resource > code_resource.sql
 
# 导入
mysql -uroot -pxxxx  taskmonitor < code_resource.sql

数据展示

from django.contrib import admin
from resource.models import Resource
from django.utils.html import format_html


# Register your models here.
class ResourceAdmin(admin.ModelAdmin):
    #后台展示字段
    list_display = ['rid', 'rtitle','rparent1', 'rparent2', 'down_url', 'down_pwd', 'untar_pwd', 'rstatus']
    #过滤字段
    list_filter =  ["rparent1", "rparent2", "rstatus"]
    #搜索字段
    search_fields = ['rtitle']

    def down_url(self, obj):
        """
        下载链接
        """
        tmp_li = obj.rurl.split('"')
        dname = '未知'
        durl = '/'
        dpwd = 'x'
        if len(tmp_li) > 11:
            dname = tmp_li[3]
            durl = tmp_li[7]
            dpwd = tmp_li[11]

        return format_html("<a href='{u}' target='_blank'>{n}</a>", u=durl, n=dname, p=dpwd)

     def down_pwd(self, obj):
        """
        访问密码
        """
        tmp_li = obj.rurl.split('"')
        dpwd = obj.rid
        if len(tmp_li) > 11:
            dpwd = tmp_li[11]

        //点击复制功能
        return format_html(f"""
                            <input type="text" id="{dpwd}" value="{dpwd}" style="position: absolute; top: -10000px">
                            <a href="#" onclick="document.getElementById('{dpwd}').select(); document.execCommand('copy')">{dpwd}</a>
                            """)


    def untar_pwd(self, obj):
        """
        压缩包解压密码
        """
        if obj.rpwd != 'x':
            tmp_li = obj.rpwd.split('"')
            return_str = tmp_li[7]
        else:
            return_str = obj.rpwd
        return return_str

    down_url.short_description = '下载链接'
    down_pwd.short_description = '访问密码'
    untar_pwd.short_description = '解压密码'

admin.site.register(Resource, ResourceAdmin)

FAQ

django 数据库更新抱错后,重新执行

# 确保存在文件
resource/migrations/__init__.py

# 登录数据库,清理resource模块记录
select * from django_migrations;

评论 (0)

取消
只有登录/注册用户才可评论