Databases
StackOverflow2013
Postsdbo
POWhen to create a class vs setting a boolean flag?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhen to create a class vs setting a boolean flag?
    primarykey
    data
    text
    <p>I have an interesting question to pose; when should one create a model class/object as opposed to setting a boolean flag for data stored in a database?</p> <p>For example, say I have a Person class that has boolean flags for President, Guard, and PartTime. This class/model is treated differently depending on the value of the flags. So the President gets different privileges in the system from the Guard and from the PartTime(r).</p> <p>When would one use Single Table Inheritance to represent this information and when would one just continue to use the boolean flag?</p> <p>My instinct is to convert these to different Objects using STI since this seems more OO to me. Checking booleans seems wrong in some way, but I can also see a place for it.</p> <p><strong>Update for clarification</strong></p> <p>Let me use another example because the one above has too many cases involved with it.</p> <p>I am working on a CMS application that contains Pages, a Page can be Public, Private, Shared, Hidden, or Default (meaning it is what you get when you don't specify a page in the url). Right now, we have a Page model and everything is a boolean flag - Public, Default, Shared. </p> <p>I am not convinced this is the best method of handling this. Especially since we have rules governing what page can be what, i.e., the Default page or a Shared page must be a Public page whereas a Private page is just Private.</p> <p>I agree with the comment below that Roles for the Person example makes a lot of sense. I am not sure that for the Page example it does.</p> <p>And to make things more complicated, there can only be one Default page and one Shared page. STI may allow me to validate this, but I am not sure since there can be many default and shared pages in the table (just not associated with a particular site).</p> <p><strong>Note</strong>: The context for the question is a Ruby on Rails application, but is applicable for any object-oriented language.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USChris Johnston
    1. USChris Johnston
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWhen to create a class vs setting a boolean flag?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POWhen to create a class vs setting a boolean flag?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POWhen to create a class vs setting a boolean flag?
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

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