blocks|key|1936088|text|Yii2迁移是正确的工具吗？如果您需要一个适当的sql命令和指令序列来创建和填充一组特定的表和数据，您可以使用funtcion来创建一个概要，并使用该函数来删除(或删除)所需的内容。|type|unordered-list-item|depth|inlineStyleRanges|entityRanges|data|1936089|我建议将迁移文件存储在单独的子目录中，我们的演示设置不会干扰普通的“迁移/向上”和“迁移/向下”进程？当然了|1936090|这种迁移是否绑定到文件命名方案，或者是否可以是演示-数据-setup.php？在yii2中(但在其他迁移工具中也是如此)，迁移文件与一个适当的模板(+datetime_migration_name.php+)有关联。|1936091|但就我的经验而言，正确和经常性地创建/填充和删除/更新/删除在某些情况下可能有用--使用控制器，特别是如果这些活动是通过网页或URL启动的，而不需要启动控制台命令，使用带有适当操作的控制器甚至可以上下操作，并且可能是为了适当地响应操作的结果。|unstyled|1936092|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|M|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|N|8|@]|9|@]|A|$]]|$1|I|3|-4|5|H|7|O|8|@]|9|@]|A|$]]]|J|$]]

<ul>
<li>Are Yii2 migrations the right tool for that?
 Could be if you need a proper sequence of sql command and instruction for create and populate a specific set of table and data you can use the funtcion up for creation an popluation and the function down for drop delete (or delete) what you need. </li>
<li>I*s it recommended to store the migration file in a seperate subdirectory that our demo setup does not interfere with ordinary "migrate/up" and "migrate/down" processes? Of course</li>
<li>Is this migration bound to a file naming scheme or can this be e.g. demo-data-setup.php ? In yii2 (but also in the other migration tools ) the migration file are related to a proper template, tipically datetime_migration_name.php </li>
</ul>

But for my experience for a proper and recurrent create/populate and drop/update/delete could be useful in some situation use a controller, especially if these activities are to be launched by web page or a URL without having to launch console commands use a controller with the appropriate action can be even up and down and possibly a view to an appropriate echo the results of operations

blocks|key|2491854|text|Yii2迁移是正确的工具吗？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2491855|不，迁移用于更改数据库结构(添加列、设置索引、..)比用数据填充表更多。在您的示例中，我将编写一个组件，该组件为您需要恢复的每个模型都提供了delete+/+create函数。然后，您可以使用cron任务调用组件。|2491856|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Are Yii2 migrations the right tool for that?

No, migrations are for database structure changes (add a column, set index,..) more than fill tables with data. In your case, I would write a component, that have delete / create function for every model you need to restore. Then, you can call your component with a cron task.

blocks|key|2491871|text|是的，您可以使用控制器映射分配命令名，配置迁移路径&表，并在不干扰原始迁移命令的情况下使用它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2491872|在控制台应用程序的配置中，添加一个带有演示的控制器映射|2491873|'controllerMap'+=>+[
++++'demo-setup'+=>+[
++++++++'class'+=>+'yii\console\controllers\MigrateController',
++++++++'migrationPath'+=>+'@common/migrations/demo',
++++++++'migrationTable'+=>+'{{%25demo_setup_migration}}'
++++],|code-block|syntax|javascript|2491874|cd到您的控制台应用程序目录并使用演示-安装命令，就像使用迁移命令一样。|2491875|./yii演示-安装/创建模式./yii演示-安装/创建示例-数据|2491876|./yii演示-安装|2491877|您可能希望设置一个cron作业来重新创建db并应用迁移或重新应用迁移到现有db以覆盖演示数据。|2491878|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

Yes, you could assign command name using controller map, configure migration path &amp; table and use it without interfering with the original migration command. 

In the console app's config, add a controller map with demo

<pre><code>'controllerMap' =&gt; [
 'demo-setup' =&gt; [
 'class' =&gt; 'yii\console\controllers\MigrateController',
 'migrationPath' =&gt; '@common/migrations/demo',
 'migrationTable' =&gt; '{{%demo_setup_migration}}'
 ],
</code></pre>

cd to your console app directory and use demo-setup command as you would use migrate command.

./yii demo-setup/create schema
./yii demo-setup/create sample-data

./yii demo-setup 

You may wish to setup a cron job to re-create db and apply migration or re-apply migration to existing db to override demo data.

blocks|key|2491896|text|是Yii2迁移的正确工具吗？，只要您将演示迁移存储在一个独立的位置，而不是您的主要迁移。老实说，当我启动一个新的Yii2项目时，总是从为演示数据创建迁移开始(我还创建了第一个迁移用户)。我通常使用faker和我自己的一些类来生成演示数据。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2491897|是否建议将迁移文件存储在单独的子目录中，而我们的演示设置不会干扰普通的“迁移/向上”和“迁移/向下”进程？是的，您应该！|2491898|这种迁移是否绑定到文件命名方案，或者可以是例如，从官方的Yii2文档中获取的关于命名迁移的演示-数据-setup.php？：|2491899|注意:由于name参数将用作生成的迁移类名的一部分，因此它只应该包含字母、数字和/或下划线字符。|blockquote|2491900|Ps.：不要过度工程你的项目|2491901|entityMap|0|LINK|mutability|MUTABLE|url|http://www.codesimplicity.com/post/what-is-overengineering/^0|0|E|1S|1J|0|0|1O|0|0|1Q|0|0|1C|0|0|E|6|4|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|11|8|@$9|12|A|13|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|14|8|@$9|15|A|16|B|C]]|D|@]|E|$]]|$1|J|3|K|5|L|7|17|8|@$9|18|A|19|B|C]]|D|@]|E|$]]|$1|M|3|N|5|6|7|1A|8|@$9|1B|A|1C|B|C]]|D|@$9|1D|A|1E|1|1F]]|E|$]]|$1|O|3|-4|5|6|7|1G|8|@]|D|@]|E|$]]]|P|$Q|$5|R|S|T|E|$U|V]]]]

Are Yii2 migrations the right tool for that?
As long as you store your demo migrations in a separate location than your main migration. To be honest, when I start a new Yii2 project I always start with creating migrations for demo data (I also create the first user with migration). I usually use faker, and some of my own classes to generate demo data.

Is it recommended to store the migration file in a seperate subdirectory that our demo setup does not interfere with ordinary "migrate/up" and "migrate/down" processes? Yes, you should! 

Is this migration bound to a file naming scheme or can this be e.g. demo-data-setup.php? From the official Yii2 documentation about naming migrations: 

<blockquote>
 Note: Because the name argument will be used as part of the generated migration class name, it should only contain letters, digits, and/or underscore characters.
</blockquote>

Ps.: don't <a href="http://www.codesimplicity.com/post/what-is-overengineering/" rel="nofollow noreferrer">overengineer</a> your projects

blocks|key|1936159|text|您可以使用固定装置。夹具是测试的重要组成部分。它们的主要目的是在固定/已知状态下设置环境，以便您的测试是可重复的，并以预期的方式运行。Yii提供了一个夹具框架，允许您精确地定义您的夹具，并且在使用协同欺骗和独立运行测试时很容易地使用它们。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1936160|entityMap|0|LINK|mutability|MUTABLE|url|https://www.yiiframework.com/doc/guide/2.0/en/test-fixtures^0|5|4|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

You can use <a href="https://www.yiiframework.com/doc/guide/2.0/en/test-fixtures" rel="nofollow noreferrer">fixtures</a>. 
Fixtures are an important part of testing. Their main purpose is to set up the environment in a fixed/known state so that your tests are repeatable and run in an expected way. Yii provides a fixture framework that allows you to define your fixtures precisely and use them easily both when running your tests with Codeception and independently.

I need to setup demo sites quickly with demo data, including hourly reset of data for a public demo site. Since our data uses timestamps relative to "now" (e.g. archived_timestamp), we cannot just restore an sql dump with fixed timestamps.

My idea is to use Yii2 migrations for that task with PHP code generating timestamps and inserting the demo data. 

How to achieve that?

<ul>
<li>Are Yii2 migrations the right tool for that?</li>
<li>Is it recommended to store the migration file in a seperate subdirectory that our demo setup does not interfere with ordinary "migrate/up" and "migrate/down" processes? </li>
<li>Is this migration bound to a file naming scheme or can this be e.g. demo-data-setup.php ?</li>
</ul>

yIi2 generate demo data with migrations

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我需要设置演示网站与演示数据，包括每小时重置数据的公共演示网站。由于我们的数据使用相对于“现在”(例如archived_timestamp)的时间戳，所以我们不能仅仅用固定的时间戳恢复sql。我的想法是为该任务使用Yii2迁移，使用PHP代码生成时间戳并插入演示数据。如何做到这一点？Yii2迁移是正确的工具吗？是否建议...

问yIi2生成带有迁移的演示数据
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问yIi2生成带有迁移的演示数据EN