Generator invoking MySQL

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Good afternoon 

I'm a newbie, and I have an inquiry. I want to know if it is possible with metaEdit to create a generator who call mysql and makes some inserts.
I get to the point to generate the SQL sentences out of the model. Can anyone please give me an insight on how I can do it? I will be great 

Thanks and best regards.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
knto Members Profile Send Private Message Find Members Posts Add to Buddy List Member Joined: 17.May.2013 Location: Spain Points: 2	Post Options Post Reply Quote knto Report Post Thanks(0) Quote Reply Topic: Generator invoking MySQL Posted: 17.May.2013 at 17:31
	Good afternoon I'm a newbie, and I have an inquiry. I want to know if it is possible with metaEdit to create a generator who call mysql and makes some inserts. I get to the point to generate the SQL sentences out of the model. Can anyone please give me an insight on how I can do it? I will be great Thanks and best regards.

janne Members Profile Send Private Message Find Members Posts Add to Buddy List MetaCase Joined: 25.Mar.2008 Points: 58	Post Options Post Reply Quote janne Report Post Thanks(1) Quote Reply Posted: 20.May.2013 at 09:59
	Please see the 'Orders and produts' sample in Example project (Entity Relationship Diagram), there exists 'Create SQL' generator for creating the tables and attribute definitions and constraints. In the similar manner you could create your mysql-specific generator or customize the existing one to contain the insertion commands as well. In the end of the generator you may execute the SQL statements in a script file (batch file) : external 'mysql YOUR_DB <your_script.sql>' execute [Edit: removed incorrect double quotes -Steve] Edited by stevek - 20.May.2013 at 11:30