Plone › Archetypes

A few questions regarding SQLStorage

3 messages Options
Embed this post
Permalink
Nico Grubert-2 () A few questions regarding SQLStorage
Reply Threaded More More options
Print post
Permalink
Dear list members

I'd like to develop some content types whose storage is PostgreSQLStorage.
I couldn't find any documentation about the SQLStorage itself so I post
my questions on that list:

1. How does PostgreSQLStorage stores files and images?

2. Can a ReferenceField with "multiValued = True" be stored with
    PostgreSQLStorage?
    I tried this example but when creating a new instance, I get the
    following error:
------------------------------------------------------------------------------
       Exception Type   Copy Error
       Exception Value The object instantmessage.2009-03-12.3650474833
                         does not support this operation

Traceback (innermost last):

     * Module ZPublisher.Publish, line 119, in publish
     * Module ZPublisher.mapply, line 88, in mapply
     * Module ZPublisher.Publish, line 42, in call_object
     * Module Products.CMFPlone.FactoryTool, line 376, in __call__
     * Module ZPublisher.mapply, line 88, in mapply
     * Module ZPublisher.Publish, line 42, in call_object
     * Module Products.CMFFormController.FSControllerPageTemplate, line
90, in __call__
     * Module Products.CMFFormController.BaseControllerPageTemplate,
line 28, in _call
     * Module Products.CMFFormController.ControllerBase, line 231, in
getNext
     * Module Products.CMFFormController.Actions.TraverseTo, line 38, in
__call__
     * Module ZPublisher.mapply, line 88, in mapply
     * Module ZPublisher.Publish, line 42, in call_object
     * Module Products.CMFFormController.FSControllerPythonScript, line
104, in __call__
     * Module Products.CMFFormController.Script, line 145, in __call__
     * Module Products.CMFCore.FSPythonScript, line 140, in __call__
     * Module Shared.DC.Scripts.Bindings, line 313, in __call__
     * Module Shared.DC.Scripts.Bindings, line 350, in _bindAndExec
     * Module Products.CMFCore.FSPythonScript, line 196, in _exec
     * Module None, line 1, in content_edit
       <FSControllerPythonScript at /plone/content_edit used for
/plone/portal_factory/InstantMessage/instantmessage.2009-03-12.3650474833>
       Line 1
     * Module Products.CMFCore.FSPythonScript, line 140, in __call__
     * Module Shared.DC.Scripts.Bindings, line 313, in __call__
     * Module Shared.DC.Scripts.Bindings, line 350, in _bindAndExec
     * Module Products.CMFCore.FSPythonScript, line 196, in _exec
     * Module None, line 13, in content_edit_impl
       <FSPythonScript at /plone/content_edit_impl used for
/plone/portal_factory/InstantMessage/instantmessage.2009-03-12.3650474833>
       Line 13
     * Module Products.Archetypes.BaseObject, line 664, in processForm
     * Module Products.Archetypes.BaseObject, line 773, in
_renameAfterCreation
     * Module Products.Archetypes.BaseObject, line 216, in setId
     * Module Products.CMFPlone.PloneFolder, line 197, in
manage_renameObject
     * Module OFS.CopySupport, line 345, in manage_renameObject
     * Module Products.CMFCore.PortalFolder, line 429, in _verifyObjectPaste
     * Module OFS.CopySupport, line 525, in _verifyObjectPaste
------------------------------------------------------------------------------

3. Is there a bugfix for the TextField - _guess_encoding bug?
    See http://plone.org/support/forums/archetypes#nabble-td1077336

4. If I update my archetypes schema, do I have to update the
    corresponding SQL, too?

Thanks in advance
Nico

------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Archetypes-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/archetypes-users
Raphael Ritz () Re: A few questions regarding SQLStorage
Reply Threaded More More options
Print post
Permalink
Nico Grubert wrote:

> Dear list members
>
> I'd like to develop some content types whose storage is PostgreSQLStorage.
> I couldn't find any documentation about the SQLStorage itself so I post
> my questions on that list:
>
> 1. How does PostgreSQLStorage stores files and images?
>
> 2. Can a ReferenceField with "multiValued = True" be stored with
>     PostgreSQLStorage?
>     I tried this example but when creating a new instance, I get the
>     following error:
> ------------------------------------------------------------------------------
>        Exception Type   Copy Error
>        Exception Value The object instantmessage.2009-03-12.3650474833
>                          does not support this operation

This isn't due to the reference field I think.
What fails here is the attempt to copy the entire object.
This is done because you are using (i) portal_factory
and also because you (ii) enabled 'renameAfterCreation'

What happens if you disable both of these?

Raphael

>
> Traceback (innermost last):
>
>      * Module ZPublisher.Publish, line 119, in publish
>      * Module ZPublisher.mapply, line 88, in mapply
>      * Module ZPublisher.Publish, line 42, in call_object
>      * Module Products.CMFPlone.FactoryTool, line 376, in __call__
>      * Module ZPublisher.mapply, line 88, in mapply
>      * Module ZPublisher.Publish, line 42, in call_object
>      * Module Products.CMFFormController.FSControllerPageTemplate, line
> 90, in __call__
>      * Module Products.CMFFormController.BaseControllerPageTemplate,
> line 28, in _call
>      * Module Products.CMFFormController.ControllerBase, line 231, in
> getNext
>      * Module Products.CMFFormController.Actions.TraverseTo, line 38, in
> __call__
>      * Module ZPublisher.mapply, line 88, in mapply
>      * Module ZPublisher.Publish, line 42, in call_object
>      * Module Products.CMFFormController.FSControllerPythonScript, line
> 104, in __call__
>      * Module Products.CMFFormController.Script, line 145, in __call__
>      * Module Products.CMFCore.FSPythonScript, line 140, in __call__
>      * Module Shared.DC.Scripts.Bindings, line 313, in __call__
>      * Module Shared.DC.Scripts.Bindings, line 350, in _bindAndExec
>      * Module Products.CMFCore.FSPythonScript, line 196, in _exec
>      * Module None, line 1, in content_edit
>        <FSControllerPythonScript at /plone/content_edit used for
> /plone/portal_factory/InstantMessage/instantmessage.2009-03-12.3650474833>
>        Line 1
>      * Module Products.CMFCore.FSPythonScript, line 140, in __call__
>      * Module Shared.DC.Scripts.Bindings, line 313, in __call__
>      * Module Shared.DC.Scripts.Bindings, line 350, in _bindAndExec
>      * Module Products.CMFCore.FSPythonScript, line 196, in _exec
>      * Module None, line 13, in content_edit_impl
>        <FSPythonScript at /plone/content_edit_impl used for
> /plone/portal_factory/InstantMessage/instantmessage.2009-03-12.3650474833>
>        Line 13
>      * Module Products.Archetypes.BaseObject, line 664, in processForm
>      * Module Products.Archetypes.BaseObject, line 773, in
> _renameAfterCreation
>      * Module Products.Archetypes.BaseObject, line 216, in setId
>      * Module Products.CMFPlone.PloneFolder, line 197, in
> manage_renameObject
>      * Module OFS.CopySupport, line 345, in manage_renameObject
>      * Module Products.CMFCore.PortalFolder, line 429, in _verifyObjectPaste
>      * Module OFS.CopySupport, line 525, in _verifyObjectPaste
> ------------------------------------------------------------------------------
>
> 3. Is there a bugfix for the TextField - _guess_encoding bug?
>     See http://plone.org/support/forums/archetypes#nabble-td1077336
>
> 4. If I update my archetypes schema, do I have to update the
>     corresponding SQL, too?
>
> Thanks in advance
> Nico
>
> ------------------------------------------------------------------------------
> Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
> powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
> easily build your RIAs with Flex Builder, the Eclipse(TM)based development
> software that enables intelligent coding and step-through debugging.
> Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com


------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Archetypes-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/archetypes-users
Jean Rodrigo Ferri-2 () Re: A few questions regarding SQLStorage
Reply Threaded More More options
Print post
Permalink
In reply to this post by Nico Grubert-2
Nico Grubert escreveu:
> Dear list members
>
> I'd like to develop some content types whose storage is PostgreSQLStorage.
> I couldn't find any documentation about the SQLStorage itself so I post
> my questions on that list:

Do you know the object/relational layer interlegis.sqlalchemystorage? It
may help you to develop Archetypes based content types and map it to RDBMS.

[1] http://colab.interlegis.gov.br/wiki/MapeadorObjetoRelacional

Regards,

--
Jean Ferri

------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Archetypes-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/archetypes-users
Free Embeddable Forum Powered by Nabble Help