Re: A problem about database structure and displacement on django admin

On 28/03/2018 3:42 AM, shawnmhy@gmail.com wrote:
> Hi everyone, I am currently working on django and get confused about
> how to design the model.
> Right now, I have a table named 'Reactionmeta' which structure like below:
>
>      1             2              3                     4            
>        5                     6             121                  122
> reaction   name   metabolite1  stoichiometry1  metabolite2
> stoichiometry2 .......... metabolite60  stoichiometry60
> (stoichiometry1 corresponds to metabolite1 and so on so forth)

I think this is a spreadsheet approach to a relationship problem

I'm not totally sure about the reactivity and stoichiometry but I have
used a relational approach to a (probably) different problem.

Mine is a mixture hazard classification system which includes reaction
products from some ingredients. I think maybe your metabolites are like
my ingredients. I don't care about the stoichiometry of my reaction
products and rely on the scientist-user to worry about that. My system
only cares about the end-points.

So for me a mixture is a bunch of ingredients. An ingredient is a
substance with properties and the mixture is a substance with a
many-to-many relationship with itself. The stoichiometry calculations
(if I was doing them) would be in the 'through' record which links a
substance (ingredient) to the mixture substance.

In this way I only have as many records as there are ingredients plus
one for the mixture. No empty records and an unlimited number of
ingredients.

If you are interested you can examine the working system. Let me know
off-list and I can give you a login.

Cheers

Mike

>
> (P.S: I have to claim that each stoichiometry correspond to one
> metabolites in the reaction, like a + b -> 2c + d(the number is the
> stoichiometry)
> However, one metabolite may has different stoichiometry, because they
> may involved in different reactions.
> For example:   a + 2b + c -> d + e + f;     2a + b -> h + j
> (metabolite a has different stoichiometry in two reactions)
>
>
> some of the reactions, contains 2 metabolites, thus this reaction have
> value in 6 columns and no value from column 7-122.
> And some of the reactions contains more than 40 metabolites, so they
> have values in majority of columns.
>
> My question is, I created the class and registered in the admin.py,
> and when I clicked on one reaction in adminsite and all the columns
> are displayed even though some of fields are blank, like below:
>
> <https://lh3.googleusercontent.com/-KPDYkVUUGGU/WrpzXgJ8OPI/AAAAAAAAAFk/nmcZ_c0yYQQ9lMacxP81sl7-VlWd1PzpwCLcBGAs/s1600/1522168647376.jpg>
>
> In that case, how can only display those fields with values and hide
> the fields without values? Or is there is any other way to modify the
> database structure or class structure to display the metabolites and
> stoichiometry only this reaction involves?
>
>
> Thank you!!!!
>
>
> --
> You received this message because you are subscribed to the Google
> Groups "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to django-users+unsubscribe@googlegroups.com
> <mailto:django-users+unsubscribe@googlegroups.com>.
> To post to this group, send email to django-users@googlegroups.com
> <mailto:django-users@googlegroups.com>.
> Visit this group at https://groups.google.com/group/django-users.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/22738963-e373-467e-8291-fdb0086be40e%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/22738963-e373-467e-8291-fdb0086be40e%40googlegroups.com?utm_medium=email&utm_source=footer>.
> For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/c05c9e4b-6550-a9b2-f334-e1d1bc5fb23f%40dewhirst.com.au.
For more options, visit https://groups.google.com/d/optout.