使用 ThinkPHP 框架来操作 Typecho 数据库

<?php
namespace app\model;
 
use think\Model;
 
class Metas extends Model
{
    protected $name = "typecho_metas";
}

<?php
namespace app\model;
 
use think\Model;
 
class Relationships extends Model
{
    protected $name = "typecho_relationships";
}

<?php
namespace app\model;
 
use think\Model;
 
class Contents extends Model
{
    protected $name = "typecho_contents";
}

<?php
declare (strict_types = 1);
 
namespace app\command;
 
use think\console\Command;
use think\console\Input;
use think\console\input\Argument;
use think\console\input\Option;
use think\console\Output;
use app\model\Contents;
use app\model\Metas;
use app\model\Relationships;
use Overtrue\Pinyin\Pinyin;
 
 
 
class Shopinsert extends Command
{
 
 
    protected function configure()
    {
        // 指令配置
        $this->setName('shopinsert')
            ->setDescription('导入数据');
    }
 
    protected function execute(Input $input, Output $output)
    {
        $this->insertData($title,$text,$slug);
        $output->writeln("done ...");
    }
 
    private function insertData($title,$text,$slug)
    {
        $insertDataModel = new Contents();
        $insertDataModel->title = $title;
        $insertDataModel->slug = $this->checkPostSlug($slug);
        echo $this->checkPostSlug($slug);
        $insertDataModel->created = time();
        $insertDataModel->modified = time();
        $insertDataModel->text = $text;
        $insertDataModel->order=0;
        $insertDataModel->authorId=1;
        // $insertDataModel->template="";
        $insertDataModel->type="post";
        $insertDataModel->status="publish";
        // $insertDataModel->password="";
        // $insertDataModel->commentsNum="";
        $insertDataModel->allowComment=1;
        $insertDataModel->allowPing=1;
        $insertDataModel->allowFeed=1;
        $insertDataModel->parent=0;
 
        $insertDataModel->save();
 
        // 绑定分类，这里就直接指定了，因为没有其他类别的需求
 
        $metaName = "默认分类";
 
        $insertMetaRelation = new Relationships();
        $insertMetaRelation->cid = $insertDataModel->id;
        $insertMetaRelation->mid = $this->getCategoryIdByName($metaName);
        $insertMetaRelation->save();
 
        // 处理标签，没有就新增
        $tagName = [$title,$metaName];
 
        foreach($tagName as $tagUse)
        {
            $insertTagRelation = new Relationships();
            $insertTagRelation->cid = $insertDataModel->id;
            $insertTagRelation->mid = $this->getTagIdByName($tagUse);
            $insertTagRelation->save();
        }
        
 
    }
 
    //获取标签 ID
    protected function getTagIdByName($name)
    {
        $metainfo = Metas::where(["name"=>$name,"type"=>"tag"])->find();
        if($metainfo)
        {
            $metainfo->count += 1;
            $metainfo->save();
            return $metainfo->mid;
        }else{
            return $this->insertTag($name);
        }
    }
 
    // 检测文章 slug 是否存在，存在则增加表示
    protected function checkPostSlug($slug)
    {
    	$insertDataModel = Contents::where(["slug"=>$slug])->count();
    	if($insertDataModel >0)
    	{
    		return $slug.'-'.time().'-'.mt_rand(10000,99999);
    	}else{
    		return $slug;
    	}
    }
 
    //新增标签
    protected function insertTag($name)
    {
        $metainfo = new Metas();
        $pinyin = new Pinyin();
        $metainfo->name = $name;
        $metainfo->slug = $pinyin->permalink($name);
        $metainfo->count = 1;
        $metainfo->type = "tag";
        $metainfo->description = $name;
        if($metainfo->save())
        {
            return $metainfo->id;
        }else{
            return 0;
        }
    }
 
    //获取分类 ID
    protected function getCategoryIdByName($name)
    {
        $metainfo = Metas::where(["name"=>$name,"type"=>"category"])->find();
        $metainfo->count += 1;
        $metainfo->save();
        return $metainfo->mid;
    }
 
}

<?php
// +----------------------------------------------------------------------
// | 控制台配置
// +----------------------------------------------------------------------
return [
    // 指令定义
    'commands' => [
        'shopinsert' => 'app\command\Shopinsert',
    ],
];