You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@empire-db.apache.org by Benjamin Venditti <be...@arcor.de> on 2010/01/07 02:27:41 UTC
view generation support in codegen
Hi there,
i am glad to announce that I've become a committer to empire-db and i'm
looking forward to work with the empire-db team.
With this announcement i also submitted my first commit in svn. Here is
a overview of my changes:
- new feature: it is now possible to generate views, however they are
not fully functional as the function "createCommand" is not implemented
- bugfix: column names with whitespaces caused the generator to create
uncompilable classes (status: fixed)
- added mysql dependency in pom.xml
- added new configuration options in config.xml
"viewClassSuffix", "tablePackageName", "recordPackageName",
"viewPackageName"
I tested my changes with MySQL and its sample database "sakila"
(http://dev.mysql.com/doc/sakila/en/sakila.html).
Does anyone know if there is a way to retrieve the SQL commands for the
views of a database that it holds?
Best regards,
Benjamin
re: view generation support in codegen
Posted by Rainer Döbele <do...@esteam.de>.
Hi Benni,
great to hear from you.
I don't think it is necessary to retrieve the command for a view.
Implementing the createCommand on a view class in only necessary for creating a database.
And we want to go the other way.
Besides the createCommand requires a DBCommand object and hence you would need a SQL parser that turns a SQL statement into a command object. While this would be possible for simple statements, making it work for all kind of statements could be a too hard nut to crack.
Regards,
Rainer
Benjamin Venditti wrote:
> re: view generation support in codegen
>
> Hi there,
>
> i am glad to announce that I've become a committer to empire-db and i'm
> looking forward to work with the empire-db team.
> With this announcement i also submitted my first commit in svn. Here is
> a overview of my changes:
>
> - new feature: it is now possible to generate views, however they are
> not fully functional as the function "createCommand" is not implemented
> - bugfix: column names with whitespaces caused the generator to create
> uncompilable classes (status: fixed)
> - added mysql dependency in pom.xml
> - added new configuration options in config.xml
> "viewClassSuffix", "tablePackageName", "recordPackageName",
> "viewPackageName"
>
> I tested my changes with MySQL and its sample database "sakila"
> (http://dev.mysql.com/doc/sakila/en/sakila.html).
>
> Does anyone know if there is a way to retrieve the SQL commands for the
> views of a database that it holds?
>
> Best regards,
> Benjamin
Re: view generation support in codegen
Posted by Francis De Brabandere <fr...@gmail.com>.
Ok, I requested to become moderator on all our lists.
Cheers,
Francis
On Fri, Jan 8, 2010 at 11:42 AM, Martijn Dashorst
<ma...@gmail.com> wrote:
> I thought I was on the moderator list, but apparently not (since I
> didn't receive the moderation request). Perhaps Henning or Thomas. In
> any case: you (as PPMC members) should become moderators for your own
> lists (I'm not going to stick around for ever moderating all lists
> :-).
>
> If you're willing to donate (a little bit of) your time moderating
> your lists, please send a message to infra@ requesting to become
> moderator for dev@, commits@, users@ and private@.
>
> http://www.apache.org/dev/committers.html#mail-moderate
>
> Martijn
>
> On Thu, Jan 7, 2010 at 10:54 PM, Francis De Brabandere
> <fr...@gmail.com> wrote:
>> who is moderator for this list?
>>
>> On Thu, Jan 7, 2010 at 12:14 PM, Martijn Dashorst
>> <ma...@gmail.com> wrote:
>>> I guess these messages are awaiting moderation.
>>>
>>> Martijn
>>>
>>> On Thu, Jan 7, 2010 at 11:37 AM, Francis De Brabandere
>>> <fr...@gmail.com> wrote:
>>>> Welcome to the team!
>>>>
>>>> strange, I did not get a svn commit mail for these changes
>>>>
>>>> On Thu, Jan 7, 2010 at 2:27 AM, Benjamin Venditti
>>>> <be...@arcor.de> wrote:
>>>>> Hi there,
>>>>>
>>>>> i am glad to announce that I've become a committer to empire-db and i'm
>>>>> looking forward to work with the empire-db team.
>>>>> With this announcement i also submitted my first commit in svn. Here is a
>>>>> overview of my changes:
>>>>>
>>>>> - new feature: it is now possible to generate views, however they are not
>>>>> fully functional as the function "createCommand" is not implemented
>>>>> - bugfix: column names with whitespaces caused the generator to create
>>>>> uncompilable classes (status: fixed)
>>>>> - added mysql dependency in pom.xml
>>>>> - added new configuration options in config.xml
>>>>> "viewClassSuffix", "tablePackageName", "recordPackageName",
>>>>> "viewPackageName"
>>>>>
>>>>> I tested my changes with MySQL and its sample database "sakila"
>>>>> (http://dev.mysql.com/doc/sakila/en/sakila.html).
>>>>>
>>>>> Does anyone know if there is a way to retrieve the SQL commands for the
>>>>> views of a database that it holds?
>>>>>
>>>>> Best regards,
>>>>> Benjamin
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> http://www.somatik.be
>>>> Microsoft gives you windows, Linux gives you the whole house.
>>>>
>>>
>>>
>>>
>>> --
>>> Become a Wicket expert, learn from the best: http://wicketinaction.com
>>> Apache Wicket 1.4 increases type safety for web applications
>>> Get it now: http://www.apache.org/dyn/closer.cgi/wicket/1.4.4
>>>
>>
>>
>>
>> --
>> http://www.somatik.be
>> Microsoft gives you windows, Linux gives you the whole house.
>>
>
>
>
> --
> Become a Wicket expert, learn from the best: http://wicketinaction.com
> Apache Wicket 1.4 increases type safety for web applications
> Get it now: http://www.apache.org/dyn/closer.cgi/wicket/1.4.4
>
--
http://www.somatik.be
Microsoft gives you windows, Linux gives you the whole house.
Re: view generation support in codegen
Posted by Thomas Fischer <fi...@seitenbau.net>.
> I thought I was on the moderator list, but apparently not (since I
> didn't receive the moderation request). Perhaps Henning or Thomas.
I am also no moderator of the empire-db lists.
Thomas
Re: view generation support in codegen
Posted by Martijn Dashorst <ma...@gmail.com>.
I thought I was on the moderator list, but apparently not (since I
didn't receive the moderation request). Perhaps Henning or Thomas. In
any case: you (as PPMC members) should become moderators for your own
lists (I'm not going to stick around for ever moderating all lists
:-).
If you're willing to donate (a little bit of) your time moderating
your lists, please send a message to infra@ requesting to become
moderator for dev@, commits@, users@ and private@.
http://www.apache.org/dev/committers.html#mail-moderate
Martijn
On Thu, Jan 7, 2010 at 10:54 PM, Francis De Brabandere
<fr...@gmail.com> wrote:
> who is moderator for this list?
>
> On Thu, Jan 7, 2010 at 12:14 PM, Martijn Dashorst
> <ma...@gmail.com> wrote:
>> I guess these messages are awaiting moderation.
>>
>> Martijn
>>
>> On Thu, Jan 7, 2010 at 11:37 AM, Francis De Brabandere
>> <fr...@gmail.com> wrote:
>>> Welcome to the team!
>>>
>>> strange, I did not get a svn commit mail for these changes
>>>
>>> On Thu, Jan 7, 2010 at 2:27 AM, Benjamin Venditti
>>> <be...@arcor.de> wrote:
>>>> Hi there,
>>>>
>>>> i am glad to announce that I've become a committer to empire-db and i'm
>>>> looking forward to work with the empire-db team.
>>>> With this announcement i also submitted my first commit in svn. Here is a
>>>> overview of my changes:
>>>>
>>>> - new feature: it is now possible to generate views, however they are not
>>>> fully functional as the function "createCommand" is not implemented
>>>> - bugfix: column names with whitespaces caused the generator to create
>>>> uncompilable classes (status: fixed)
>>>> - added mysql dependency in pom.xml
>>>> - added new configuration options in config.xml
>>>> "viewClassSuffix", "tablePackageName", "recordPackageName",
>>>> "viewPackageName"
>>>>
>>>> I tested my changes with MySQL and its sample database "sakila"
>>>> (http://dev.mysql.com/doc/sakila/en/sakila.html).
>>>>
>>>> Does anyone know if there is a way to retrieve the SQL commands for the
>>>> views of a database that it holds?
>>>>
>>>> Best regards,
>>>> Benjamin
>>>>
>>>
>>>
>>>
>>> --
>>> http://www.somatik.be
>>> Microsoft gives you windows, Linux gives you the whole house.
>>>
>>
>>
>>
>> --
>> Become a Wicket expert, learn from the best: http://wicketinaction.com
>> Apache Wicket 1.4 increases type safety for web applications
>> Get it now: http://www.apache.org/dyn/closer.cgi/wicket/1.4.4
>>
>
>
>
> --
> http://www.somatik.be
> Microsoft gives you windows, Linux gives you the whole house.
>
--
Become a Wicket expert, learn from the best: http://wicketinaction.com
Apache Wicket 1.4 increases type safety for web applications
Get it now: http://www.apache.org/dyn/closer.cgi/wicket/1.4.4
Re: view generation support in codegen
Posted by Francis De Brabandere <fr...@gmail.com>.
who is moderator for this list?
On Thu, Jan 7, 2010 at 12:14 PM, Martijn Dashorst
<ma...@gmail.com> wrote:
> I guess these messages are awaiting moderation.
>
> Martijn
>
> On Thu, Jan 7, 2010 at 11:37 AM, Francis De Brabandere
> <fr...@gmail.com> wrote:
>> Welcome to the team!
>>
>> strange, I did not get a svn commit mail for these changes
>>
>> On Thu, Jan 7, 2010 at 2:27 AM, Benjamin Venditti
>> <be...@arcor.de> wrote:
>>> Hi there,
>>>
>>> i am glad to announce that I've become a committer to empire-db and i'm
>>> looking forward to work with the empire-db team.
>>> With this announcement i also submitted my first commit in svn. Here is a
>>> overview of my changes:
>>>
>>> - new feature: it is now possible to generate views, however they are not
>>> fully functional as the function "createCommand" is not implemented
>>> - bugfix: column names with whitespaces caused the generator to create
>>> uncompilable classes (status: fixed)
>>> - added mysql dependency in pom.xml
>>> - added new configuration options in config.xml
>>> "viewClassSuffix", "tablePackageName", "recordPackageName",
>>> "viewPackageName"
>>>
>>> I tested my changes with MySQL and its sample database "sakila"
>>> (http://dev.mysql.com/doc/sakila/en/sakila.html).
>>>
>>> Does anyone know if there is a way to retrieve the SQL commands for the
>>> views of a database that it holds?
>>>
>>> Best regards,
>>> Benjamin
>>>
>>
>>
>>
>> --
>> http://www.somatik.be
>> Microsoft gives you windows, Linux gives you the whole house.
>>
>
>
>
> --
> Become a Wicket expert, learn from the best: http://wicketinaction.com
> Apache Wicket 1.4 increases type safety for web applications
> Get it now: http://www.apache.org/dyn/closer.cgi/wicket/1.4.4
>
--
http://www.somatik.be
Microsoft gives you windows, Linux gives you the whole house.
Re: view generation support in codegen
Posted by Martijn Dashorst <ma...@gmail.com>.
I guess these messages are awaiting moderation.
Martijn
On Thu, Jan 7, 2010 at 11:37 AM, Francis De Brabandere
<fr...@gmail.com> wrote:
> Welcome to the team!
>
> strange, I did not get a svn commit mail for these changes
>
> On Thu, Jan 7, 2010 at 2:27 AM, Benjamin Venditti
> <be...@arcor.de> wrote:
>> Hi there,
>>
>> i am glad to announce that I've become a committer to empire-db and i'm
>> looking forward to work with the empire-db team.
>> With this announcement i also submitted my first commit in svn. Here is a
>> overview of my changes:
>>
>> - new feature: it is now possible to generate views, however they are not
>> fully functional as the function "createCommand" is not implemented
>> - bugfix: column names with whitespaces caused the generator to create
>> uncompilable classes (status: fixed)
>> - added mysql dependency in pom.xml
>> - added new configuration options in config.xml
>> "viewClassSuffix", "tablePackageName", "recordPackageName",
>> "viewPackageName"
>>
>> I tested my changes with MySQL and its sample database "sakila"
>> (http://dev.mysql.com/doc/sakila/en/sakila.html).
>>
>> Does anyone know if there is a way to retrieve the SQL commands for the
>> views of a database that it holds?
>>
>> Best regards,
>> Benjamin
>>
>
>
>
> --
> http://www.somatik.be
> Microsoft gives you windows, Linux gives you the whole house.
>
--
Become a Wicket expert, learn from the best: http://wicketinaction.com
Apache Wicket 1.4 increases type safety for web applications
Get it now: http://www.apache.org/dyn/closer.cgi/wicket/1.4.4
Re: view generation support in codegen
Posted by Francis De Brabandere <fr...@gmail.com>.
Welcome to the team!
strange, I did not get a svn commit mail for these changes
On Thu, Jan 7, 2010 at 2:27 AM, Benjamin Venditti
<be...@arcor.de> wrote:
> Hi there,
>
> i am glad to announce that I've become a committer to empire-db and i'm
> looking forward to work with the empire-db team.
> With this announcement i also submitted my first commit in svn. Here is a
> overview of my changes:
>
> - new feature: it is now possible to generate views, however they are not
> fully functional as the function "createCommand" is not implemented
> - bugfix: column names with whitespaces caused the generator to create
> uncompilable classes (status: fixed)
> - added mysql dependency in pom.xml
> - added new configuration options in config.xml
> "viewClassSuffix", "tablePackageName", "recordPackageName",
> "viewPackageName"
>
> I tested my changes with MySQL and its sample database "sakila"
> (http://dev.mysql.com/doc/sakila/en/sakila.html).
>
> Does anyone know if there is a way to retrieve the SQL commands for the
> views of a database that it holds?
>
> Best regards,
> Benjamin
>
--
http://www.somatik.be
Microsoft gives you windows, Linux gives you the whole house.