View Issue Details

IDProjectCategoryView StatusLast Update
0006949mantisbtfeaturepublic2006-04-18 10:17
Reporterlauploix Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status acknowledgedResolutionopen 
Product Version1.0.2 
Summary0006949: Add "id" column in tables that are mainly "n*n relation" tables but also have values (ie : project_user_list)
Description

I would like to be able to map the tables with SQLObject, which is a python object/relational database mapping tool.

I have (talking about the 0.19 version of the database schema that I have)

  • No Pb with "value" tables (user, bug, project, ...)
  • No pb with relations tables (bug_monitor, ...)
  • But.... pb with tables that are relations AND contain value (project_user_list, custom_field_project)

The pb is : SQLObject needs to have and ID column (or equivalent) in any table that has a "value" (and not only external keys).

If it where possible to add an 'ID' column to tables that are mainly relations, but also have values, that would be :

  • Useless for Mantis itself
  • ...but sooooo useful for object-relational mappings

otherwise, we need to use plain SQL.

TagsNo tags attached.

Activities

vboctor

vboctor

2006-04-18 10:17

manager   ~0012610

It makes sense to add an id field to all our tables that don't have ones. Gradually it may make sense to use some of these ids in Mantis code as well.

Issue History

Date Modified Username Field Change
2006-04-17 18:49 lauploix New Issue
2006-04-18 10:17 vboctor Note Added: 0012610
2006-04-18 10:17 vboctor Status new => acknowledged