Cakephp 1.3：如何迁移到我的文章表格 - 函数

Question

我有一个使用另一个 php cms 系统的应用程序，我现在将其转移到 CakePHP 1.3。我现在需要将 tblnewsarticles 中的所有旧文章转移到我的新 CakePHP 表 articles 中。这些表具有不同的字段，但我已经能够将我需要的所有字段映射到我的新表。我在 ArticlesController 类 中创建了以下临时 migrate 函数来为我执行此操作，但无法将数据保存到我的表中。一切似乎都很好，包括我已经使用 debug($data) 和 debug($articles) 进行了测试，它显示了数据，但我无法保存任何内容。我看不出这有什么问题，所以感谢任何帮助...

//TEMPORARY FUNCTION THAT WILL BE DELETED/DEACTIVATED AFTER MIGRATION
function migrate(){                
        // FOR TESTING PURPOSES I SET LIMIT=1, BUT I HAVE OVER 4000 ARTICLES TO TRANSFER
    $articles = $this->Article->query(
        "SELECT articleID,subcategoryID,article_title,article_html,article_date,image_extension FROM tblnewsarticles LIMIT 1;"
    );

    foreach($articles as $article){
        $data['Article']['id'] = $article['tblnewsarticles']['articleID'];
        $data['Article']['published'] = 1;
        $data['Article']['title'] = $article['tblnewsarticles']['article_title'];
        $data['Article']['body'] = $article['tblnewsarticles']['article_html'];
        $data['Article']['main_image'] = 'cat_'.$article['tblnewsarticles']['subcategoryID'].'/'.$article['tblnewsarticles']['articleID'].'.'.$article['tblnewsarticles']['image_extension'];
        $data['Article']['category_id'] = $article['tblnewsarticles']['subcategoryID'];
        $data['Article']['user_id'] = 2;
        $data['Article']['created'] = $article['tblnewsarticles']['article_date'];

        if (!empty($data)) {
             $this->Article->create();
             $this->Article->save($data);                       
             $this->Session->setFlash('Migration processed successfully');
        }else{                      
             $this->Session->setFlash('Unsuccessful');
        }
    }   
}

======== 这就是我所做的对我有用的 =============== =

function migrateArticle(){

$articles = $this->Article->query(
                    "SELECT articleID,subcategoryID,article_title,article_html,article_date,image_extension FROM tblnewscategories;"
    );

    foreach($articles as $article){

    $categoryID = $article['tblnewsarticles']['subcategoryID'];
    $articleID = $article['tblnewsarticles']['articleID'];
    $articleTitle = $article['tblnewsarticles']['article_title'];
    $articleSlug = str_replace(" ","-",strtolower($articleTitle));
    $articleBody = $article['tblnewsarticles']['article_html'];
    $articleImage = 'cat_'.$article['tblnewsarticles']['subcategoryID'].'/'.$article['tblnewsarticles']['articleID'].'.'.$article['tblnewsarticles']['image_extension'];
    $articleDate = $article['tblnewsarticles']['article_date'];

   $this->Article->query("INSERT INTO categories (id, published, title, slug, body, main_image, category_id, user_id, created) VALUES('$articleID', '1', '$articleTitle', '$articleSlug', '$articleBody', '$articleImage', '$categoryID', '2', '$articleDate');");   
    }   
}

Answer 1

不要尝试一次加载 4000 条记录，然后单独处理它们。使用复制所有内容的单个数据库查询可能会更容易。类似的东西

INSERT INTO articles
    (id, published, title, body,
     main_image,
     category_id, user_id, created)
    SELECT articleID, 1, article_title, article_html,
          CONCAT('cat_', subcategoryID, '/', articleID, '.', image_extension),
          subcategoryID, 2, article_date
    FROM tblnewsarticles;

（当然未经测试）