Subversion Repositories SmartDukaan

Rev

Rev 16350 | Rev 16386 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 16350 Rev 16353
Line 32... Line 32...
32 
        }
 32 
        }
33 
 
 33 
 
34 
db = MySQLdb.connect('localhost',"root","shop2020","dtr" )
 34 
db = MySQLdb.connect('localhost',"root","shop2020","dtr" )
35 
cursor = db.cursor()
 35 
cursor = db.cursor()
36 
 
 36 
 
37 
PUSH_NOTIFICATIONS_SQL = "select p.id, p.user_id, n.*, g.gcm_regid from pushnotifications p join notification_campaigns n on p.notification_campaign_id = n.id left outer join (select * from (select * from gcm_users order by id desc) as X group by user_id, imeinumber) as g on p.user_id = g.user_id where p.type ='pending'"
 37 
PUSH_NOTIFICATIONS_SQL = "select p.id, p.user_id, n.*, g.gcm_regid from pushnotifications p join notification_campaigns n on p.notification_campaign_id = n.id left outer join (select * from (select * from gcm_users order by id desc) as X group by user_id) as g on p.user_id = g.user_id where p.type ='pending'"
38 
ALL_STORES_SQL = "select * from stores"
 38 
ALL_STORES_SQL = "select * from stores"
39 
 
 39 
 
40 
cursor.execute(ALL_STORES_SQL)
 40 
cursor.execute(ALL_STORES_SQL)
41 
result_stores = cursor.fetchall()
 41 
result_stores = cursor.fetchall()
42 
domainStoresMap = {}
 42 
domainStoresMap = {}