annotate commons/core/sql/TableMatchAdaptator.py @ 6:769e306b7933

Change the repository level.
author yufei-luo
date Fri, 18 Jan 2013 04:54:14 -0500
parents
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
6
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
1 # Copyright INRA (Institut National de la Recherche Agronomique)
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
2 # http://www.inra.fr
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
3 # http://urgi.versailles.inra.fr
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
4 #
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
5 # This software is governed by the CeCILL license under French law and
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
6 # abiding by the rules of distribution of free software. You can use,
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
7 # modify and/ or redistribute the software under the terms of the CeCILL
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
8 # license as circulated by CEA, CNRS and INRIA at the following URL
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
9 # "http://www.cecill.info".
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
10 #
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
11 # As a counterpart to the access to the source code and rights to copy,
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
12 # modify and redistribute granted by the license, users are provided only
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
13 # with a limited warranty and the software's author, the holder of the
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
14 # economic rights, and the successive licensors have only limited
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
15 # liability.
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
16 #
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
17 # In this respect, the user's attention is drawn to the risks associated
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
18 # with loading, using, modifying and/or developing or reproducing the
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
19 # software by the user in light of its specific status of free software,
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
20 # that may mean that it is complicated to manipulate, and that also
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
21 # therefore means that it is reserved for developers and experienced
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
22 # professionals having in-depth computer knowledge. Users are therefore
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
23 # encouraged to load and test the software's suitability as regards their
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
24 # requirements in conditions enabling the security of their systems and/or
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
25 # data to be ensured and, more generally, to use and operate it in the
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
26 # same conditions as regards security.
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
27 #
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
28 # The fact that you are presently reading this means that you have had
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
29 # knowledge of the CeCILL license and that you accept its terms.
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
30
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
31
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
32 from commons.core.sql.TableAdaptator import TableAdaptator
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
33 from commons.core.sql.ITableMatchAdaptator import ITableMatchAdaptator
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
34 from commons.core.coord.Match import Match
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
35
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
36 ## Adaptator for Match table
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
37 #
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
38 class TableMatchAdaptator( TableAdaptator, ITableMatchAdaptator ):
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
39
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
40 ## Give a list of Match instances given a query name
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
41 #
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
42 # @param query string sequence name
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
43 # @return lMatches list of Match instances
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
44 #
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
45 def getMatchListFromQuery( self, query ):
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
46 sqlCmd = "SELECT * FROM %s WHERE query_name='%s';" % ( self._table, query )
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
47 return self._iDb.getObjectListWithSQLCmd( sqlCmd, self._getInstanceToAdapt )
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
48
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
49 ## Give a list of Match instances having the same identifier
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
50 #
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
51 # @param id integer identifier number
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
52 # @return lMatch a list of Match instances
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
53 #
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
54 def getMatchListFromId( self, id ):
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
55 sqlCmd = "SELECT * FROM %s WHERE path='%d';" % ( self._table, id )
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
56 lMatch = self._iDb.getObjectListWithSQLCmd( sqlCmd, self._getInstanceToAdapt )
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
57 return lMatch
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
58
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
59 ## Give a list of Match instances according to the given list of identifier numbers
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
60 #
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
61 # @param lId integer list
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
62 # @return lMatch a list of Match instances
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
63 #
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
64 def getMatchListFromIdList( self, lId ):
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
65 lMatch=[]
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
66 if lId == []:
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
67 return lMatch
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
68 sqlCmd = "select * from %s where path=%d" % (self._table, lId[0])
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
69 for i in lId[1:]:
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
70 sqlCmd += " or path=%d" % (i)
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
71 sqlCmd += ";"
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
72 lMatch = self._iDb.getObjectListWithSQLCmd( sqlCmd, self._getInstanceToAdapt )
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
73 return lMatch
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
74
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
75 ## Give the data contained in the table as a list of Match instances
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
76 #
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
77 # @return lMatchs list of match instances
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
78 #
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
79 def getListOfAllMatches( self ):
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
80 sqlCmd = "SELECT * FROM %s" % ( self._table )
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
81 lMatches = self._iDb.getObjectListWithSQLCmd( sqlCmd, self._getInstanceToAdapt )
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
82 return lMatches
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
83
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
84 def _getInstanceToAdapt(self):
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
85 iMatch = Match()
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
86 return iMatch
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
87
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
88 def _getTypeAndAttr2Insert(self, match):
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
89 type2Insert = ("'%s'","'%d'","'%d'","'%d'","'%f'","'%f'","'%s'","'%d'","'%d'","'%d'","'%f'","'%g'","'%d'","'%f'","'%d'")
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
90 attr2Insert = ( match.range_query.seqname, match.range_query.start, \
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
91 match.range_query.end, match.query_length, match.query_length_perc, \
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
92 match.match_length_perc, match.range_subject.seqname, match.range_subject.start,\
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
93 match.range_subject.end, match.subject_length, match.subject_length_perc, \
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
94 match.e_value, match.score, match.identity, \
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
95 match.id)
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
96 return type2Insert, attr2Insert
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
97
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
98 def _escapeAntislash(self, obj):
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
99 obj.range_query.seqname = obj.range_query.seqname.replace("\\", "\\\\")
769e306b7933 Change the repository level.
yufei-luo
parents:
diff changeset
100 obj.range_subject.seqname = obj.range_subject.seqname.replace("\\", "\\\\")