hpareek

Untitled

Jun 19th, 2017
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.91 KB | None | 0 0
  1.  def OnClick(self, event):                                      
  2.         name = event.GetEventObject().GetLabelText()
  3.         cursor= self.conn.execute("SELECT * FROM ELEMENT where SYMBOL==?", (name,))
  4.         elements = cursor.fetchall()
  5.         print elements
  6.         cursor= self.conn.execute("SELECT ATOMIC_NUMBER FROM ELEMENT where SYMBOL = ?", (name,))
  7.         numbers = cursor.fetchone()[0]
  8.         print numbers
  9.         atomicnumber = numbers
  10.         cursor= self.conn.execute("SELECT MOL_NUMBER FROM LINK where ELEMENT_NUMBER = ?", (atomicnumber,))
  11.         mnumbers = cursor.fetchall()
  12.         print mnumbers        
  13.         mnum_list = []
  14.         for i in mnumbers:
  15.              mnum_list.append(i[0])
  16.         print mnum_list
  17.         combinations = atomicnumber
  18.         inter_list = []
  19.         inter_list.append(mnum_list)
  20.         print inter_list
  21. #print list(set.intersection(*map(set,inter_list))
Add Comment
Please, Sign In to add comment