Team:Exeter/lab book/glyco/wk5

From 2012.igem.org

Revision as of 13:56, 25 September 2012 by Jamesml213 (Talk | contribs)

ExiGEM2012 Lab Book Glyco wk5

Glycobase: 23rd - 27th July 2012

23/07/12

GlycoBase Version 2.0

New features include:
1) Randomize Button
2) Drop down menu for the sugar unit choice

To implement the randomize button I need to create a table highlighting all possible combinations.

Assign each of these an integer key, selected via the random number generator function.

Union operator used like an AND function for select statements.

Would it be better to build the chain as we go?

SQL count could be useful for the dropdown menu.

rand_integer = random.randint(1,100) used to select a random integer between 1 and 100.

The SQL select distinct statement: In a table, some of the columns may contain duplicate values. This is not a problem, however sometimes you will want to list only the different (distinct) values in a table. The 'distinct' keyword can be utilized in such situations.

This is very useful in populating a drop down menu for sugars into the interface.

Use a script to create a text file with the separate sugar names, then subsequently call this text file in the interface mainloop().

Display is unclear in interface, call a meeting to decide layout.

25/07/12