Team:Exeter/lab book/glyco/wk5

From 2012.igem.org

(Difference between revisions)
Line 87: Line 87:
       </font>
       </font>
-
     <!------------ENTER LAB BOOK HERE: PLEASE INCLUDE DATES WITHIN THE WEEK------------>  
+
     <p>23/07/12</p>
 +
<p><i>GlycoBase Version 2.0</i></p>
 +
<p>New features include:
 +
</br>1) Randomize Button
 +
</br>2) Drop down menu for the sugar unit choice</p>
 +
<p>To implement the randomize button I need to create a table highlighting all possible combinations.</p>
 +
<p>Assign each of these an integer key, selected via the random number generator function.</p>
 +
<p>Union operator used like an AND function for select statements.</p>
 +
<p>Would it be better to build the chain as we go?</p>
 +
<p>SQL count could be useful for the dropdown menu.</p>
 +
<p>rand_integer = random.randint(1,100) used to select a random integer between 1 and 100.</p>
 +
<p>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.</p>
 +
<p>This is very useful in populating a drop down menu for sugars into the interface.</p>
 +
<p>Use a script to create a text file with the separate sugar names, then subsequently call this text file in the interface mainloop().</p>
 +
<p>Display is unclear in interface, call a meeting to decide layout.</p>
 +
    <p>25/07/12</p>
 +
 
 +
 
      
      
     </font>
     </font>

Revision as of 13:56, 25 September 2012

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

Retrieved from "http://2012.igem.org/Team:Exeter/lab_book/glyco/wk5"