Databases
StackOverflow2013
Postsdbo
POQuerying portal_catalog using typed uuids instead of string uuids
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POQuerying portal_catalog using typed uuids instead of string uuids
    primarykey
    data
    text
    <p>I'm writing a Plone calendar module for reserving different resources. This module features a calendar whose events are stored in Postgresql. Each calendar is a Dexterity object stored in the ZODB.</p> <p>To make a link between Plone and Postgresql I naturally turned to the uuid property of the Plone objects. So each uuid in Plone serves as a foreign key in Postgresql, which supports uuid natively.</p> <p>This worked well for me in the past 6 months until I started using Plone 4.1.4. With it, plone.uuid 1.0.2 was introduced which changes the string representation of uuids from uuids <em>with</em> to uuids <em>without</em> dashes.</p> <p>The problem with this change is that I can no longer be certain which representation is going to be used on any given object. Objects created before Plone 4.1.4 contain a differently formatted uuid-string than objects created after.</p> <p>Long story short, to ensure that my code works with any uuid representation I would love to be able to search by using Python's uuid type.</p> <p><strong>So instead of this:</strong></p> <pre><code>catalog.searchResults(UID='325dc47e-08f9-4fa1-bc18-3944a725adb4') </code></pre> <p>Which returns <em>different</em> results than this:</p> <pre><code>catalog.searchResults(UID='325dc47e08f94fa1bc183944a725adb4') </code></pre> <p><strong>I would love to do this:</strong></p> <pre><code>from uuid import UUID catalog.searchResults(UID=UUID('325dc47e-08f9-4fa1-bc18-3944a725adb4')) </code></pre> <p>Which would be <em>equivalent</em> to this:</p> <pre><code>catalog.searchResults(UID=UUID('325dc47e08f94fa1bc183944a725adb4')) </code></pre> <p>Does anyone know how I can achieve that kind of independency from the uuid's representation in Plone?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. UShref_
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POQuerying portal_catalog using typed uuids instead of string uuids
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POQuerying portal_catalog using typed uuids instead of string uuids
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHm. Can't you have a function UUID elsewhere which inspects the string, inserts or removes dashes as needed, and then calls `uuid.UUID`? (Astonishing how much breakage Plone generates with every minor update...)
      singulars
      1. POQuerying portal_catalog using typed uuids instead of string uuids
      1. USUlrich Schwarz
    2. COuuid.UUID actually allows strings with or without dashes. And wherever I can I do make use of that feature by ensuring that the strings I deal with (mostly for JSON) always have a predictable format. The problem is really that I essentially have to query the catalog with both representations to ensure that I get the object back.
      singulars
      1. POQuerying portal_catalog using typed uuids instead of string uuids
      1. UShref_
    3. COWould the solution be that you just assume (U)UID is string id and contain any kind of characters? Why are you stripping dashes away?
      singulars
      1. POQuerying portal_catalog using typed uuids instead of string uuids
      1. USMikko Ohtamaa
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload