MHQ7ukp8

1        
2    def sms_take_credit(self, user_id):
3        """Take a credit from a user.
4        
5        Return a bool."""
6
7        user_id = int(user_id)
8        
9        query = 'SELECT creditos FROM creditos WHERE usuario_id = %s'
10        
11        try:
12            self.cursor.execute(query, user_id)
13        except:
14            return False
15            
16        
17        result = self.cursor.fetchone()
18        print result
19        print "creditos",result['creditos']
20        new_credit = result['creditos'] - 1
21        print "new_credit", new_credit
22        print "user_id", user_id
23
24        pdb.set_trace()
25        
26        query = 'UPDATE creditos SET creditos = %s WHERE usuario_id = %s'
27        
28        try:
29            self.cursor.execute(query, (new_credit, user_id))
30        except:
31            return False
32            
33        return True
34
35
36==================================================================
37
38bd
39
40==================================================================
41
42
43CREATE TABLE IF NOT EXISTS `creditos` (
44  `id` int(11) NOT NULL AUTO_INCREMENT,
45  `usuario_id` int(11) NOT NULL,
46  `creditos` int(11) NOT NULL,
47  `creditos_total` int(11) NOT NULL,
48  PRIMARY KEY (`id`)
49) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;