Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Your code is out of a context so is not obvious the right choice. Following some tips:</p> <ul> <li><p>Don't use <code>NameError</code> exception, it is only used when a name, as the exception itself said, is not found in the local or global scope, use <code>ValueError</code> or <code>TypeError</code> if the exception concerns the value or the type of the parameter;</p></li> <li><p>Don't print error messages. Raise meaningful exceptions with a meaningful error message:</p> <pre><code>raise ValueError("password must be longer than 6 characters") </code></pre></li> <li><p>Returning a value from a setter is meaningless while assignment is not an expression, i.e. you cannot check the value of an assignment:</p> <pre><code>if (user.password = 'short'): ... </code></pre></li> <li><p>Just raise an exception in the setter and let the code that set the property handle it.</p></li> </ul> <p>Example:</p> <pre><code>class Test: minlen = 6 @property def password(self): return self._password @password.setter def password(self, value): if not isinstance(value, basestring): raise TypeError("password must be a string") if len(value) &lt; self.minlen: raise ValueError("password must be at least %d character len" % \ self.minlen) self._password = value </code></pre> <p>Look also at <a href="http://forms-project.pollenation.net/cgi-bin/trac.cgi/browser/trunk/formal/types.py#L16" rel="noreferrer">this forms handling library</a>, there the validators , <a href="http://forms-project.pollenation.net/cgi-bin/trac.cgi/browser/trunk/formal/validation.py#L60" rel="noreferrer">here an example</a>, are entities in their own: they can be set dynamically with higher control and less coupled code, but maybe this is much more than you need.</p>
    singulars
    1. This table or related slice is empty.
    1. POProper way in Python to raise errors while setting variables
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USklein
    1. USmg.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POProper way in Python to raise errors while setting variables
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThis was really helpful. Thank you.
      singulars
      1. PO
      1. USensnare
    2. CO@mg, Great post (and great initials!) overall, but I'm concerned about the example at the end. You seem to have made up a `password` decorator, the usage of which is pretty odd; do you mean `@property` and to name the first method `password`? Also, you'll have to use new-style classes if you want to use properties, i.e. change the first line of the example to `class Test(object):` or inherit from some other new-style class. (Even if you weren't using properties yet, you should use new-style classes.)
      singulars
      1. PO
      1. USMike Graham
    3. CO@Mike Graham: damn, tiredness could play bad jokes. you are right for the property naming, the exact form is the one used originally by ensare, i prefer the old good `password = property(...)` but i would be coherent with ensare without really knowing the new 2.6 syntax. The second observation is not true: properties can be used with old style classes
      singulars
      1. PO
      1. USmg.
 

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