#	Drag This	To This	With This Connection Type	And This Will Happen
M1	Anything from the System Model Panel (or Repository Panel)	Anything in the Repository Panel (or System Model Panel)	Reference	Reference Connection will be created but nothing will be generated
M2	SysML Block	MySQL Database	Model Transform	A new table will be generated in the database with columns corresponding to value properties of the SysML block. A model transform connection will be created between the SysML block and the MySQL table.
M3	MySQL Table	SysML Package	Model Transform	A new SysML block will be generated with value properties corresponding to columns of the MySQL table. A model transform connection will be created between the SysML block and the MySQL table.
M4	SysML Block	MySQL Table	Data Map	A new row will be generated in the table with column values corresponding to the default values of the value properties of the SysML block ONLY IF a model transform connection exists between a parent block (supertype) of the given block and the MySQL table (such as by operations M2 - M3). A data map connection will be created between the SysML block and the MySQL table row.
M5	SysML Block Instance	MySQL Table	Data Map	A new row will be generated in the table with column values corresponding to the slot values of the SysML block instance ONLY IF a model transform connection exists between the classifying block of the instance and the MySQL table (such as by operations M2 – M3). A data map connection will be created between the SysML block instance and the MySQL table row.
M6	MySQL Table Row	SysML package	Data Map	User will be asked to select one of the two options: (1) generate a block instance (default option), or (2) generate a specialized (subtype) block. If the first option is selected, a SysML block instance will be generated with slot values corresponding to the columns values of the given row. This block instance will be an instance of the block that has a model transform connection to the table. If such a block does not exist, then a new block will also be generated with a model transform connection to the MySQL table (same as operation M3). If the second option is selected, a SysML block will be generated with value properties (and default values) corresponding to the columns values of the given row. This block will be a child (subtype) of the block that has a model transform connection to the table. If such a block does not exist, then a new block will also be generated with a model transform connection to the MySQL table (same as operation M3). A data map connection will be created between the SysML block instance (or specialized block) and the MySQL table row.

Creating connections between existing model elements

The drag-n-drop operations listed in the table above generate models. Starting with this release, Syndeia can also create model transform connections between existing model elements without generation. You can then perform a compare and sync operation on these connections to sync the models. The following drag-n-drop operations are available between existing model elements:

SysML Block < -- > MySQL Table (Model Transform)
SysML Block < -- > MySQL Table Row (Data Map)
SysML Block Instance < -- > MySQL Table Row (Data Map)

Additional Notes on SysML and MySQL drag-n-drop operations

Column names in the MySQL table must be alpha numeric (white spaces and underscores are allowed) so that they can be used to generate block value properties.
When generating SysML block / instances from MySQL data, or when synchronizing MySQL > SysML, the following data mapping rules are followed.
MySQL data type SysML value type
int / INT Integer
dec / DEC Real
float / FLOAT Real
double / DOUBLE Real
char / CHAR String
varchar / VARCHAR String
When generating MySQL tables and rows from SysML elements, or when synchronizing SysML > MySQL, the following data mapping rules are followed.
SysML value type MySQL data type
String VARCHAR
Real DOUBLE
Integer INT

MySQL data type	SysML value type
int / INT	Integer
dec / DEC	Real
float / FLOAT	Real
double / DOUBLE	Real
char / CHAR	String
varchar / VARCHAR	String

Browser not supported