Auto-generate extjs forms and grids from MySQL/Oracle/SQL Server/PostgreSQL

[LiXin]

From below link you can download extjs forms and grids generated from SQL Server Northwind database using LatticeFramework Studio, also you can generate server side code such as C#, Java or PHP and sql scripts (create database tables and stored procedures) using LatticeFramework Studio.

http://www.latticesoft.com/

And here is the video tutorial show you how to generate extjs forms and grids from different data source (MySQL, Oracle, SQL Server).

http://www.latticesoft.com/product/video.aspx

And screenshot:
http://www.latticesoft.com/product/screenshot/Extjs.JPG


http://www.latticesoft.com

[DragonFist]

I've have to tell you. I work for a Visual Basic house and I've looked at a number of code generation tools recently for work and all are sadly lacking in VB support.

Which make them useless to us. I took a quick look at this, and once again, C#, but no VB support. Unless I missed something.

Anyhow, there's a pretty large VB market out there. I know that my office won't even consider a product that doesn't directly support it.

[dawesi]

you seem to post a lot about IDE's... is latticesoft your company?

[LiXin]

DragonFist:

LatticeFramework Studio is model-driven and template-based tool, that said you only need define the xml model and multiple artifacts in the area of presentation layer, business logic, database schemas, reports and diagrams can be generated using different XSLT templates. If you are Visual Basic house, you can write the XSLT templates to generate VB.NET code, same for generating Perl, Ruby or any language you perfer, so as developer you are total in charge what you want to generate.

dawesi: Yes, latticesoft is my company.

[DragonFist]

Hey, LiXin. I won't argue that. However, the examples and support, out-of-the-box, of any such tool for the language that you use make a big difference in initial use and learning curve.

Codesmith is a template based system as well. And it has this great set of templates called nettiers that model and scaffold an entire backend. But the team writing those templates have been asked to make a VB as it only supports C# and any place I've seen that request, the answer has been a complete (and in some cases rude) refusal to do so. So, despite a salesman calling my office twice a week, trying to convince me that it would be a useful tool for VB based on templating alone, my boss has won't even look at it.

Anyhow, I my point is, if you are going to support .net and have examples for C# but not VB, you are losing business that you may not even be aware of losing. Like I said, just the fact of there being a C# folder and no VB folder is enough for some to close the program and take no further look. It is the way my boss looks at it, and it is pretty much how I look at it now. Too much of a sell. And without examples in the language that I use, I can't easily test where it might fit into my pipeline as I have to fully learn the product and how to write templates just to test its use with VB. It is prohibitive to even evaluating it.

[LiXin]

DragonFist:

Thank you for your suggestions. I will add template for generating business objects in VB.NET.

[DragonFist]

Very Cool. I can tell you that I have been looking for something to fit into the pipeline to save time on some of the grunt work of creating the business layer but have run into the above issues.

If I can find something that will save time and perhaps allow some of the "non-programmers" to contrib to the grunt work of this activity, I can sell my boss on those benefits.

Best,

Shawn

[alexvgs]

Lixin,
It was not immediately clear what the difference is between the purchase version and the download version of latticesoft. Do you know the difference of the top of your head or can you please point me to a URL?

Thanks
Alex

[LiXin]

Alex:

Download version can only display 15 tables/views/procedures of the data source you connect, and some templates are not included such as templates to generate Entity-Relationship diagram, database schema report in Microsoft word and html format etc.

[franckxx]

hi,

i'm interested by latticeframework, but i've a small problem with it...

I've see the video tutoriel...but :

I use Mysql BDD, when i try to connect with latticeframework to bdd, connexion OK, but i don't see my tables... when i check trust checkbox, bug, software crash !

can everyone help me ?

[LiXin]

franckxx:

When connected to MySQL, you need to expand the database to load all tables.

MySQL Connector for .Net does not support trust connection yet, I am going to disable the trust checkbox for MySQL.

[LiXin]

Hi Shawn,

I have added a template (Templates/Domain/BusinessEntity_VBNET.xslt) for generating business objects in VB.NET, below is the latest version of LatticeFramework Studio you can download:

http://www.latticesoft.com/downloads/latticeframeworkstudio.msi

Thanks,

Li

[DragonFist]

Wow, cool. That was fast. I shall definitely check it out.

Thanks,

Shawn

[DragonFist]

Hi LiXin,

I'm checking it out.

I am probably doing something wrong, but when I connect to my database (sql server 2005) and check off tables, I then click extract metadata. I then get an empty .xeml file and attempts to generate after that give an error about the xml root being missing (my guess because it is not in the xeml file.

Best,

Shawn

[LiXin]

Hi Shawn,

You shall not uncheck tables checkbox. Also make sure all tables are load after you expand the database node (a background thread will load the tables), then you can click extract metadata button.

Thanks,
Li

[DragonFist]

You were right, tables was unchecked.

Okay, my immediate impressions. It wasn't clear right out of the box how to connect to the database. Some documentation details would be good here; however, I did figure it out without to much trouble.

I like the fact that it is not trying to do to much for me. The outputed files in the examples are simple store prods and BL classes, not a mess of intertwining technologies that one has to sort out before he can use.

It seems to me the main benefit is that it extracts the metadata from the database into an xml file and xslt's are used to generate the code. The xslt's look clean and easy to read allowing for probable easy editing to support more features.

I've passed the data on to my boss. I think he'll like it.

I suggest putting a community section on your site where users can easily post their xslt's to share and therefore start to build a large amount of templates.

Best,

Shawn

[DragonFist]

Another question, The other two products that you have, are they encompaced by the studio product?

Is there any reason that one would want to get all three as opposed to just the studio?

Thanks,

Shawn

[franckxx]

Hi,

I've retry with mysql database...
It doesn't work for me.

I use "Mov'amp 0.5" and i've 10 databases...

When i expand database, no table.... i've try many methods.... don't work !

I need other mysql users return

[LiXin]

Shawn:

Lattice.DataMapper OR Mapper is free for use (you can get full source code for $99) and I believe you can get Lattice.SPGen for free if you buy 2+ licenses of LatticeFramework Studio. May be we should package three products together as you suggested.

franckxx:

Which version of MySQL you tried to connect? LatticeFramework Studio supports MySQL version 5.0 and after.

[franckxx]

hi Lixin,

I'm very interested by your software, but i don't work for me.

I use "Apache/2.0.54 (Win32) PHP/5.2.3", i've no sp

[LiXin]

franckxx,

So you can connect to your MySQL server using LatticeFramework Studio, right? Did you see information_schema under Databases node? Can you run below sql query at SQL Editor?

select * from information_schema.tables

Click new Query button, copy above query and click Execute SQL button.

[LiXin]

franckxx:

You are possible runing MySQL 4.0 or 4.1, LatticeFramework Studio only supports MySQL 5.0.2 and later.

Thanks,
Li