You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@shindig.apache.org by "Ian Boston (JIRA)" <ji...@apache.org> on 2008/04/21 14:19:22 UTC

[jira] Created: (SHINDIG-204) DB Storage Implementation for Social Model

DB Storage Implementation for Social Model
------------------------------------------

                 Key: SHINDIG-204
                 URL: https://issues.apache.org/jira/browse/SHINDIG-204
             Project: Shindig
          Issue Type: Improvement
            Reporter: Ian Boston


Attached is an untested implementation of the various (non rest) services in Social using Cayenne. The model is complete, but I have not done tests on the model or Api.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Re: [jira] Commented: (SHINDIG-204) DB Storage Implementation for Social Model

Posted by Ian Boston <ie...@tfd.co.uk>.
Yes sorry about  the layout... old habits die hard :),

Thought about using the official Maven Cayenne plugin to generate the  
ORM objects, but I think that that only works in v3 which is not  
marked as stable (although almost there M4 I think)

Since the official plugin doesn't generate DDL, and most DBA's dont  
like auto generated schemas (especially Oracle DBA's), they want DDL  
to work with and modify before going into production.... so I wrote  
another one.... which I guess I should send to the Cayenne team as a  
patch or something.

Ian



On 1 May 2008, at 12:14, Vincent Siveton (JIRA) wrote:

>
>     [ https://issues.apache.org/jira/browse/SHINDIG-204? 
> page=com.atlassian.jira.plugin.system.issuetabpanels:comment- 
> tabpanel&focusedCommentId=12593517#action_12593517 ]
>
> Vincent Siveton commented on SHINDIG-204:
> -----------------------------------------
>
> Hehe, Sakai project layout :)
>
> Short thought, why not using Maven Cayenne plugin to generate orm  
> objects?
>
>> DB Storage Implementation for Social Model
>> ------------------------------------------
>>
>>                 Key: SHINDIG-204
>>                 URL: https://issues.apache.org/jira/browse/ 
>> SHINDIG-204
>>             Project: Shindig
>>          Issue Type: Improvement
>>            Reporter: Ian Boston
>>         Attachments: social-db.tgz
>>
>>
>> Attached is an untested implementation of the various (non rest)  
>> services in Social using Cayenne. The model is complete, but I  
>> have not done tests on the model or Api.
>
> -- 
> This message is automatically generated by JIRA.
> -
> You can reply to this email to add a comment to the issue online.
>


[jira] Commented: (SHINDIG-204) DB Storage Implementation for Social Model

Posted by "Vincent Siveton (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/SHINDIG-204?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12593517#action_12593517 ] 

Vincent Siveton commented on SHINDIG-204:
-----------------------------------------

Hehe, Sakai project layout :)

Short thought, why not using Maven Cayenne plugin to generate orm objects?

> DB Storage Implementation for Social Model
> ------------------------------------------
>
>                 Key: SHINDIG-204
>                 URL: https://issues.apache.org/jira/browse/SHINDIG-204
>             Project: Shindig
>          Issue Type: Improvement
>            Reporter: Ian Boston
>         Attachments: social-db.tgz
>
>
> Attached is an untested implementation of the various (non rest) services in Social using Cayenne. The model is complete, but I have not done tests on the model or Api.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (SHINDIG-204) DB Storage Implementation for Social Model

Posted by "Ian Boston (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/SHINDIG-204?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12593510#action_12593510 ] 

Ian Boston commented on SHINDIG-204:
------------------------------------

I am now committing this to a separate SVN repo at  

https://source.sakaiproject.org/contrib//tfd/trunk/social-db/ 

which I have commit access to, and tracking shindig trunk.

All the service impls are done as is the DB impl, and I am slowly writing more tests and population scripts. DDL scripts are generated for the following DB's although I am testing against Derby.

The DB's that are supported.
db2, derby, hsqldb, ingres, mssql, mysql, openbase, oracle, postgres, sybase.



> DB Storage Implementation for Social Model
> ------------------------------------------
>
>                 Key: SHINDIG-204
>                 URL: https://issues.apache.org/jira/browse/SHINDIG-204
>             Project: Shindig
>          Issue Type: Improvement
>            Reporter: Ian Boston
>         Attachments: social-db.tgz
>
>
> Attached is an untested implementation of the various (non rest) services in Social using Cayenne. The model is complete, but I have not done tests on the model or Api.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (SHINDIG-204) DB Storage Implementation for Social Model

Posted by "Kevin Brown (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/SHINDIG-204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kevin Brown updated SHINDIG-204:
--------------------------------

    Component/s: RESTful API (Java)

> DB Storage Implementation for Social Model
> ------------------------------------------
>
>                 Key: SHINDIG-204
>                 URL: https://issues.apache.org/jira/browse/SHINDIG-204
>             Project: Shindig
>          Issue Type: Improvement
>          Components: RESTful API (Java)
>            Reporter: Ian Boston
>         Attachments: social-db.tgz
>
>
> Attached is an untested implementation of the various (non rest) services in Social using Cayenne. The model is complete, but I have not done tests on the model or Api.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (SHINDIG-204) DB Storage Implementation for Social Model

Posted by "Ian Boston (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/SHINDIG-204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ian Boston updated SHINDIG-204:
-------------------------------

    Attachment: social-db.tgz

Source tarball of untested implementation of the DB storage layer. I will keep working on this and updating as I go.

Please DONT assume that this version works.... untill I have added unit tests and fixed the bugs.

> DB Storage Implementation for Social Model
> ------------------------------------------
>
>                 Key: SHINDIG-204
>                 URL: https://issues.apache.org/jira/browse/SHINDIG-204
>             Project: Shindig
>          Issue Type: Improvement
>            Reporter: Ian Boston
>         Attachments: social-db.tgz
>
>
> Attached is an untested implementation of the various (non rest) services in Social using Cayenne. The model is complete, but I have not done tests on the model or Api.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.