| Bug #54862 | Forward engineer "Generate INSERT Statements for Tables" does not work | ||
|---|---|---|---|
| Submitted: | 28 Jun 2010 13:44 | Modified: | 29 Nov 2010 17:24 |
| Reporter: | Borut Bolčina | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Workbench: Modeling | Severity: | S3 (Non-critical) |
| Version: | 5.2.24, 5.2.29 | OS: | Windows |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | forward engineer, insert | ||
[28 Jun 2010 13:44]
Borut Bolčina
[6 Jul 2010 15:41]
Alfredo Kojima
Do you have BLOB fields in the table/INSERTs?
[6 Jul 2010 19:57]
Borut Bolčina
No BLOB. These are the types used in the model: VARCHAR INT TEXT TIMESTAMP TINYINT BOOLEAN
[7 Jul 2010 5:00]
Valeriy Kravchuk
Had you clicked on "Apply changed to data" button after entering data for the table?
[7 Jul 2010 6:00]
Borut Bolčina
Valeriy, this is totally unrelated. I am not trying to Edit Table Data.
[7 Jul 2010 13:53]
Susanne Ebrecht
Many thanks for writing a bug report. You need to click "apply changes to data" when you want insert values to stay and get forwarded. Unfortunately, this isn't documented and so I will set this bug report as documentation bug. Looking into: http://dev.mysql.com/doc/workbench/en/wb-table-editor.html#wb-table-editor-inserts-tab There is not documented that you need to press the button first.
[7 Jul 2010 15:47]
Borut Bolčina
Again, I am not trying to insert the data by hand into some table. Can you please read again the steps to reproduce the problem?
[7 Aug 2010 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[13 Oct 2010 14:20]
Del Hyman-Jones
The bug is still present in Workbench 5.2.29 CE. I have followed the same steps as Borut above and no INSERT statements are generated in the resulting script.
[28 Oct 2010 22:43]
Alfredo Kojima
Can you attach the model you're using?
[29 Oct 2010 9:00]
Del Hyman-Jones
Hi Alfredo, I have attached the file. After selecting Forward Engineer I checked the following options: 1. DROP Objects Before Each CREATE Object 2. Generte INSERT Statements for Tables Clicked Next. Selected the following: 1. Export MySQL Table Objects 2. Export MySQL Routine Objects Clicked next. The script generated in the windows does not contain any INSERT statements. I will attach the output of that also.
[29 Oct 2010 9:09]
Del Hyman-Jones
Syncing the database and then performing a backup is a workaround for this. But I did start off creating the database at the source as opposed to the diagram editor. Thanks for your time it's much appreciated. :-)
[29 Oct 2010 13:58]
Alfredo Kojima
Hi, I don't see any INSERTs data in your model, are you sure this is the correct one?
[29 Oct 2010 14:52]
Del Hyman-Jones
That is definitely 100% the correct file; I synced the model with the source before sending it to you. I am also seeing that my routines do not appear to be in the model either even though they are in the source database.
[29 Oct 2010 14:58]
Alfredo Kojima
In any case, there is no INSERT data in it. Please review it and tell what table has the data.
[29 Oct 2010 15:44]
Del Hyman-Jones
How do I do that? I have sent you the backup of the database which clearly has data in it so I don't know why it won't sync the data in the tables with the model. If I go to Database - Synchronize Model and run through the steps does this not sync the data in from the tables to the model? If it does not, how am I supposed to do it? Where is the options in the Synchronize Model wizard to tell it that I want to import the data?
[29 Oct 2010 16:24]
Alfredo Kojima
Synchronizing or reverse engineering does not import the data into the model. That would be a serious problem for databases with several gigabytes of data. The INSERTs data for tables has to be entered manually in the model and is meant to initialize tables with constant data, like list of countries, list of states etc.
[29 Oct 2010 17:24]
Johannes Taxacher
@Del Hyman-Jones: This "generate insert statement" option creates insert statements on forward-engineer for default-data entered on the tables "Insert" tab. Can you please check/confirm if you have such data in place and it still does not work for you? Thanks in advance
[30 Nov 2010 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
