Home » U++ TheIDE » U++ TheIDE: CodeEditor, Assist++, Topic++ » sch file editor
| sch file editor [message #37701] |
Sun, 04 November 2012 13:26  |
omari
Messages: 273
Registered: March 2010
|
Experienced Member |
|
|
Hi all,
this is an attempt to create a sch editor.
I hope it is util.
cordially
omari
regards
omari.
|
|
|
|
|
|
| Re: sch file editor [message #37704 is a reply to message #37701] |
Sun, 04 November 2012 15:21  |
|
|
Hi omari,
It looks interesting, but I don't quite see how it can help anyone. To use it, you need to have some understanding about .sch files and about SQL in general - I'd say that as much as you'd need to write the .sch file yourself. Maybe one thing that might be good about the editor is that it prevents typos and should always generate valid .sch file, but that can be easily checked by trying to compile it.
Is there anything in particular that led you to write this editor? I'm not trying to say it is useless, I'm just curious, because I usually prefer to write everything manually, without specialized editor 
After testing, I have few notes to the program itself:
1) It should allow 0-9 and '_' characters in table and column names, it is valid sql and I use them a lot in my schemas
2) You should add a column for default value, that is very common in my schemas too
3) It fails on parsing errors when loading more complex sch files. Aside from perfecting the parser (I understand it is just first version  ), you should wrap the load functionality in try/catch block, so the application doesn't crash when user imports malformed text from file or clipboard. If you want to test, you can try with the watchdog scheme, it fails probably because it contains some macros not yet supported by your editor.
Best regards,
Honza
|
|
|
|
| Re: sch file editor [message #37711 is a reply to message #37704] |
Sun, 04 November 2012 21:24 |
omari
Messages: 273
Registered: March 2010
|
Experienced Member |
|
|
Hi Honza,
thank you for the test and notes, I'll take them into account.
my goal is to enable rapid creation of sch file with or without knowledge of the .sch file synaxis.
cordially
omari.
regards
omari.
|
|
|
|
|
|
| Re: sch file editor [message #37716 is a reply to message #37711] |
Mon, 05 November 2012 07:08 |
|
|
| omari wrote on Sun, 04 November 2012 21:24 |
my goal is to enable rapid creation of sch file with or without knowledge of the .sch file synaxis.
|
Well, maybe it would be a good idea then to add a read-only CodeEditor to the application showing a preview of .sch file. It would naturally lead the user to learn the .sch file syntax, if he wants
Honza
|
|
|
|
|
|
|
|
|
|
| Re: sch file editor [message #38398 is a reply to message #37742] |
Thu, 13 December 2012 21:31 |
lectus
Messages: 329
Registered: September 2006
Location: Brazil
|
Senior Member |
|
|
Hi!
I like this idea. Writing .SCH manually can be tedious.
But as I said in another thread it might be more interesting to write a plugin/script for MySql WorkBench, it's a UML modeler.
You can design the database visually and then export to .SCH.
Just an idea.
PS: I'm testing your tool and I like it.
[Updated on: Thu, 13 December 2012 21:34] Report message to a moderator |
|
|
|
| Re: sch file editor [message #38402 is a reply to message #38398] |
Fri, 14 December 2012 09:44 |
omari
Messages: 273
Registered: March 2010
|
Experienced Member |
|
|
Hi lectus,
| Quote: |
But as I said in another thread it might be more interesting to write a plugin/script for MySql WorkBench, it's a UML modeler.
You can design the database visually and then export to .SCH.
|
I have started adding DbDesignerFork model import.
I'll post it in a couple of days.
Regars,
omari.
regards
omari.
|
|
|
|
Goto Forum:
Current Time: Fri Nov 01 01:16:39 CET 2024
Total time taken to generate the page: 0.02836 seconds
|
Members
Pages
Help
Register
Login
Home
