[DWS-4] SQL Listing, and Execution WS

[dynamobi-build]

[reporter="ngoodman", created="Thu, 29 Oct 2009 11:16:20 -0700", resolved="Tue, 9 Mar 2010 21:06:29 -0800"]

Create the web services needed by DADMINUI-4.

The flex admin seemed a bit "promiscuous" with usernames/passwords in URLs; let's not do that.

[dynamobi-build]

[author="ngoodman", created="Thu, 29 Oct 2009 11:16:54 -0700"]

need WS before integration Flex API

[dynamobi-build]

[author="ngoodman", created="Thu, 28 Jan 2010 16:51:27 -0800"]

Create a new WS project here
https://studio.dynamobi.com/svn/DWS/dynamows-flexsqladmin/trunk

Copy existing Enunciate build framework, etc (build.xml, enunciate.xml) to build web services to support Flex SQLAdminUI

[dynamobi-build]

[author="ngoodman", created="Thu, 28 Jan 2010 16:59:22 -0800"]

Overall Goal:

Have the Flex SQL Admin flash application work with LucidDB by writing web services to match what the application is expecting. In general, everything that works here (http://www.flexsqladmin.com/demo/) against SQLServer .NET should work against LucidDB and Enunciate.

Notes:

• We have access to open source Flex application, but especially at first we don't want to change much of it.
• Eventually this Flex application will get integrated w/ Admin UI but for now just run it in a web app along side this web services directory (html/swf)
• You'll need an HTTP Sniffer (I use HttpFox in Firefox) or maybe something like this: http://www.predic8.com/open-source/soap-monitor/. You'll need something to watch requests/responses and know what the application web service interface requirements are.
• You may have to do a server side replace on [ and ] for queries/etc until I can change the source to not build those
• You can ignore connections right now, and simply just use a single connection for everything
• Explain Plans should definitely be the last thing - work on everything else first

[dynamobi-build]

[author="ngoodman", created="Thu, 28 Jan 2010 16:59:42 -0800"]

Please begin work on this.

[dynamobi-build]

[author="ngoodman", created="Thu, 28 Jan 2010 17:07:12 -0800"]

to get a sense... we want to implement the web services that this application wants

[dynamobi-build]

[author="ngoodman", created="Thu, 28 Jan 2010 17:17:03 -0800"]

Also, for reference, the .NET based web services code is here:
http://flexsqladmin.svn.sourceforge.net/viewvc/flexsqladmin/Webservices/

It is only for reference - we don't want to use any of it.

[dynamobi-build]

[author="rzhang", created="Thu, 4 Feb 2010 02:28:57 -0800"]

Status:
1.Created enunciate framework to build our webservices to support FlexSQLAdmin.
2.Finished implementing the service getDBMeta(), which list all tables and views info.
3.code was checked-in.
In progress:
1. start to handle execSQL.
Issue:
1. namespace issue.

[dynamobi-build]

[author="ngoodman", created="Thu, 4 Feb 2010 22:45:43 -0800"]

great.... please work to resolve/research the namespace issue and let's try and get one of the web services to work.

[dynamobi-build]

[author="rzhang", created="Fri, 5 Feb 2010 05:24:12 -0800"]

Status
1.execSQL/handleUpdate services were finished
In progress
1.Try to resovle namespace issue
Next
1.Try to integrate flexsqladmin with our services.

[dynamobi-build]

[author="rzhang", created="Mon, 8 Feb 2010 03:25:15 -0800"]

Integrate flexsqladmin with our services.
a. tables/views explorer
b. query specific table

[dynamobi-build]

[author="rzhang", created="Tue, 9 Feb 2010 04:25:07 -0800"]

Today I did some changes on flexsqladmin.
It is a working version of flexsqladmin
please check out 2010-02-09_DWS-4.2nd.swf

[dynamobi-build]

[author="ngoodman", created="Tue, 9 Mar 2010 21:06:02 -0800"]

removing the Plan part.. That will be covered by DWS-7.

[dynamobi-build]

[author="ngoodman", created="Tue, 9 Mar 2010 21:06:29 -0800"]

This issue is completed... The remaining item, (explain plan services) is covered by DWS-7