# Generating the up.sql and down.sql files

**URL:** <https://discourse.diesel.rs/t/generating-the-up-sql-and-down-sql-files/132>\
**Category:** Diesel 2.0\
**Created:** [December 16, 2019, 9:16pm UTC](https://discourse.diesel.rs/t/generating-the-up-sql-and-down-sql-files/132 "2019-12-16T21:16:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dns2utf8](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.diesel.rs/dns2utf8/32/44_2.png) [@dns2utf8](https://discourse.diesel.rs/u/dns2utf8)\
**Post date:** [December 16, 2019, 9:16pm UTC](https://discourse.diesel.rs/t/generating-the-up-sql-and-down-sql-files/132/1 "2019-12-16T21:16:26Z")

</div>

Hi all

Currently the cli generates files containing nothing but a comment:

```auto
diesel migration generate create_reports_table --format sql

```

Is there a plan for generating the actual sql?  
Maybe just in simple cases?

Best,  
Stefan

---

<div class="post-metadata">

**Author:** ![weiznich](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.diesel.rs/weiznich/32/64_2.png) [@weiznich](https://discourse.diesel.rs/u/weiznich)\
**Post date:** [December 17, 2019, 5:02pm UTC](https://discourse.diesel.rs/t/generating-the-up-sql-and-down-sql-files/132/2 "2019-12-17T17:02:36Z")

</div>

It’s expected behavior that `diesel migration generate` creates an empty file. Those are just templates for the user to be filled with the actual migration SQL.  
There is conceptually no way to generate those from something. Because there is no other source of information in this case. Where would we get the required information from?