Mercurial > repos > yufei-luo > s_mart

comparison SMART/Java/Python/mySql/MySqlExonTable.py @ 38:2c0c0a89fad7

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Uploaded
author m-zytnicki
date Thu, 02 May 2013 09:56:47 -0400
parents 769e306b7933
children
comparison
equal deleted inserted replaced
37:d22fadc825e3 38:2c0c0a89fad7
1 #
2 # Copyright INRA-URGI 2009-2010
3 #
4 # This software is governed by the CeCILL license under French law and
5 # abiding by the rules of distribution of free software. You can use,
6 # modify and/ or redistribute the software under the terms of the CeCILL
7 # license as circulated by CEA, CNRS and INRIA at the following URL
8 # "http://www.cecill.info".
9 #
10 # As a counterpart to the access to the source code and rights to copy,
11 # modify and redistribute granted by the license, users are provided only
12 # with a limited warranty and the software's author, the holder of the
13 # economic rights, and the successive licensors have only limited
14 # liability.
15 #
16 # In this respect, the user's attention is drawn to the risks associated
17 # with loading, using, modifying and/or developing or reproducing the
18 # software by the user in light of its specific status of free software,
19 # that may mean that it is complicated to manipulate, and that also
20 # therefore means that it is reserved for developers and experienced
21 # professionals having in-depth computer knowledge. Users are therefore
22 # encouraged to load and test the software's suitability as regards their
23 # requirements in conditions enabling the security of their systems and/or
24 # data to be ensured and, more generally, to use and operate it in the
25 # same conditions as regards security.
26 #
27 # The fact that you are presently reading this means that you have had
28 # knowledge of the CeCILL license and that you accept its terms.
29 #
30 import random
31 from SMART.Java.Python.structure.Interval import Interval
32 from SMART.Java.Python.mySql.MySqlTable import MySqlTable
33
34
35 class MySqlExonTable(MySqlTable):
36 """A table of exon in a mySQL database"""
37
38 def __init__(self, connection, name = None, chromosome = None, verbosity = 0):
39 if chromosome == None:
40 chromosome = ""
41 else:
42 chromosome = "_%s" % chromosome
43 if name == None:
44 name = "TmpTable_%d" % (random.randint(0, 100000))
45 name = "%s%s_exons" % (name, chromosome)
46 super(MySqlExonTable, self).__init__(connection, name, verbosity)
47
48
49 def createExonTable(self):
50 variables = Interval.getSqlVariables()
51 variables.append("transcriptId")
52 types = Interval.getSqlTypes()
53 types["transcriptId"] = "int"
54 sizes = Interval.getSqlSizes()
55 sizes["transcriptId"] = 11
56 self.create(variables, types, sizes)
57
58
59 def rename(self, name):
60 super(MySqlExonTable, self).rename("%s_exons" % name)
61
62
63 def addExon(self, exon, transcriptId):
64 values = exon.getSqlValues()
65 values["transcriptId"] = transcriptId
66 id = self.addLine(values)
67 exon.id = id
68
69
70 def retrieveExonsFromTranscriptId(self, transcriptId):
71 if not self.created:
72 return []
73 query = self.mySqlConnection.executeQuery("SELECT * FROM %s WHERE transcriptId = %d" % (self.name, transcriptId))
74 exons = []
75 for exonLine in query.getIterator():
76 exon = Interval()
77 exon.setSqlValues(exonLine)
78 exons.append(exon)
79 return exons
80
81
82 def retrieveExonsFromBulkTranscriptIds(self, transcriptIds):
83 if not transcriptIds:
84 return {}
85 if not self.created:
86 return {}
87 exons = dict([(transcriptId, []) for transcriptId in transcriptIds])
88 query = self.mySqlConnection.executeQuery("SELECT * FROM %s WHERE transcriptId IN (%s)" % (self.name, ", ".join(["%s" % (transcriptId) for transcriptId in transcriptIds])))
89 for exonLine in query.getIterator():
90 exon = Interval()
91 exon.setSqlValues(exonLine)
92 exons[exonLine[-1]].append(exon)
93 return exons
94
95
96 def removeFromTranscriptId(self, transcriptId):
97 self.mySqlConnection.executeQuery("DELETE FROM %s WHERE transcriptId = %d" % (self.name, transcriptId))