Video Demonstration of the following

1. How to Install
2. Functionalities and Features
3. How to contribute

Hey thereee! MySchemaFlow needs your help. A form for adding a UNIQUE constraint is currently not implemented. The primary key is automatically configured for uniqueness by default, there are situations where a column, such as an email column, should also be unique. For more details on unique constraints, please visit this awesome website. Happy coding ~

Mabuhay, contributors! 🌟

MySchemaFlow needs your help. Your task is to create a feature where user can export diagrams as text—a SQL Script. As of now, we only have 5 options available for exporting our diagrams. It would be nice if user could also export diagrams as a text, right? 🔥

Happy Coding ~

One feature currently missing in the application is the ability to add indexes to the tables. For more information, please visit this website.

Documentation Request for:

1. API / Functions used throughout the system
2. Installation
3. Project Contribution for Students

Currently only supports MySQL Data Types, there shall be a button to select what type of database is it.

Replication

1. ctrl + shift + c
2. Add Column
3. Populate the fields
4. Column Type
5. Results to ColumnName DataType(undefined

Can we enable the user to go back to the database selection menu, so that they can change the database if they misclicked (instead of fully reloading the application)

Re: Implementation of feature request #17 at PR: #19 the caveats of the implementations are:

• Lack of Proper Icon
• Lack of Proper Table format
• Lack of Dark Mode Support

• Ability to define relationships between entities (one-to-one, one-to-many, many-to-many).
• Users can specify cardinality (e.g., 1, 0..1, , 0..) for relationships.

• Ability to perform CRUD operations on table nodes.
• Ability to clone table nodes.
• Ability to establish connections between table nodes.
• Show active state when a node is dragged, clicked, or when an edge is clicked.
• Dynamically position the handle of the table node.
• Highlight the corresponding column relationship when hovering over the edge component.
• Automatic positioning of nodes.
• Option to position nodes either from top to bottom or from left to right.

The settings button are not easily detectable on its current location. Consider putting it beside the left toolbar icons.

Utilize the SQL.js library to get the CREATE TABLE statement and create a virtual database in memory for the user test SQL Statements

A good complement would be to be able to import from a SQL schema / dump, the same way one can export to SQL.
It could help bootstraping the creation of a schema, or just visualize an existing database.

Works well one the DDL is cleaned up, but with a fresh dump from PhpMyAdmin, I encountered a couple bugs.
I don't know if you'd rather me open a couple new issues on this repo, but I'll summarize them here.
For each test, you can create a .sql file containing the SQL dumps snippets below :

• When a contraint is named after the foreign key, the relation is not created (here "second_first_id_foreign")

# -- test-fail1.sql - Constraint named after foreign key: Relation not created
CREATE TABLE `first` (`id` bigint(20) UNSIGNED NOT NULL, `label` varchar(255) DEFAULT NULL);
CREATE TABLE `second` (`id` bigint(20) UNSIGNED NOT NULL, `first_id` bigint(20) DEFAULT NULL, `label` varchar(255) DEFAULT NULL);
ALTER TABLE `first` ADD PRIMARY KEY (`id`);
ALTER TABLE `second` ADD PRIMARY KEY (`id`), ADD KEY `second_first_id_foreign` (`first_id`);
ALTER TABLE `second` ADD CONSTRAINT `second_first_id_foreign` FOREIGN KEY (`first_id`) REFERENCES `first` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

• When the constraint doesn't have any action, or is missing the update action, an error is thrown.

# -- test-fail2.sql - Missing OnUpdate action : Error -> TypeError: Cannot read properties of undefined (reading 'action')
CREATE TABLE `first` (`id` bigint(20) UNSIGNED NOT NULL, `label` varchar(255) DEFAULT NULL);
CREATE TABLE `second` (`id` bigint(20) UNSIGNED NOT NULL, `first_id` bigint(20) DEFAULT NULL, `label` varchar(255) DEFAULT NULL);
ALTER TABLE `first` ADD PRIMARY KEY (`id`);
ALTER TABLE `second` ADD PRIMARY KEY (`id`), ADD KEY `second_first_id_foreign` (`first_id`);
ALTER TABLE `second` ADD CONSTRAINT `second_ibfk_17f1cf36` FOREIGN KEY (`first_id`) REFERENCES `first` (`id`) ON DELETE CASCADE;

For this one, it comes from src/renderer/src/utilities/ImportHelper.ts:113 :

constraints: {
    onDelete: fk.reference.on[0].action.toUpperCase(),
    onUpdate: fk.reference.on[1].action.toUpperCase(), /* <~~ action is undefined if the "ON UPDATE" clause is missing */
},

Here's a valid version of the above

# -- test-valid.sql - Valid
CREATE TABLE `first` (`id` bigint(20) UNSIGNED NOT NULL, `label` varchar(255) DEFAULT NULL);
CREATE TABLE `second` (`id` bigint(20) UNSIGNED NOT NULL, `first_id` bigint(20) DEFAULT NULL, `label` varchar(255) DEFAULT NULL);
ALTER TABLE `first` ADD PRIMARY KEY (`id`);
ALTER TABLE `second` ADD PRIMARY KEY (`id`), ADD KEY `second_first_id_foreign` (`first_id`);
ALTER TABLE `second` ADD CONSTRAINT `second_ibfk_17f1cf36` FOREIGN KEY (`first_id`) REFERENCES `first` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

Originally posted by @7ute in #7 (comment)

Hello contributors!👋 MySchemaFlow currently does not have an auto-updater in place and it's important to provide our users with a seamless way to receive updates and bug fixes. This issue is created to track the implementation of an auto-updater for our application.

After the query has been executed, the Playground shows a loading screen that is not being completed, therefore not allowing the user to run a query again. This happens when an invalid keyword has been executed

I want add mssql database or .bak to import my database

For foreign key, kindly add another row (that will only be shown if FK is selected as option) that will be specified ON DELETE and ON UPDATE constraints of the FK,

Refer to the MySQL specification below:

[CONSTRAINT [symbol]] FOREIGN KEY
    [index_name] (col_name, ...)
    REFERENCES tbl_name (col_name,...)
    [ON DELETE reference_option]
    [ON UPDATE reference_option]

reference_option:
    RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT

Mabuhay, contributors! 🌟

As of now, there are two ways to:

MySchemaFlow needs your help. Your task is to create a feature where user can generate diagrams from text—a SQL Script. Like the example below:

Enjoy coding ~

When a normal column is transformed into Foreign Key, it does replace the other columns if you repeatedly click on it, hence disabling or validating of the button can be the solution.

Mabuhay, contributors! 🌟

MySchemaFlow needs your assitance. Your task is to create a feature where user can enable a setting to restrict the viewport's movement. You can use this translateExtent property to set a boundary.

Tip:

• Calculate the total width and left position of each node
• Calculate the total height and top position of each node
• This will provide you with an idea of the minimum and maximum values for the translateExtent property.
• You can use Math.min and Math.max.

Happy Coding ~

Maybe when the exit button is clicked we can go to the last index of the history?

Heyaaaa! I am currently for someone who can help me create a logo for MySchemaFlow app. Please contact me on discord and i'll share the details with you.