Subversion Repositories SmartDukaan

Rev

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

Rev 20775 Rev 24394
Line 54... Line 54...
54 
gcmIdGcmRegIdMap = {}
 54 
gcmIdGcmRegIdMap = {}
55 
domainStoresMap = {}
 55 
domainStoresMap = {}
56 
failedGcm = []
 56 
failedGcm = []
57 
 
 57 
 
58 
 
 58 
 
59 
db = MySQLdb.connect(options.mysqlHost,"root","shop2020","dtr" )
 59 
db = MySQLdb.connect(options.mysqlHost,"root","shop2020","127.0.0.1" )
60 
cursor = db.cursor()
 60 
cursor = db.cursor()
61 
 
 61 
 
62 
ALL_STORES_SQL = "select * from stores"
 62 
ALL_STORES_SQL = "select * from stores"
63 
GCM_REG_ID_SQL1 = "select x.user_id, x.gcm_regid, x.id, x.androidid, x.created  from (select gc.* from gcm_users gc join users u on gc.user_id=u.id where gc.user_id in (%s) and gc.androidid is not null and u.activated=1 order by gc.id desc) as x group by x.user_id, x.gcm_regid, x.androidid"
 63 
GCM_REG_ID_SQL1 = "select x.user_id, x.gcm_regid, x.id, x.androidid, x.created  from (select gc.* from gcm_users gc join users u on gc.user_id=u.id where gc.user_id in (%s) and gc.androidid is not null and u.activated=1 order by gc.id desc) as x group by x.user_id, x.gcm_regid, x.androidid"
64 
GCM_REG_ID_SQL2 = "select x.user_id, x.gcm_regid, x.id, x.androidid, x.created, x.imeinumber  from (select gc.* from gcm_users gc join users u on u.id=gc.user_id where gc.user_id in (%s) and gc.androidid is null and gc.imeinumber and u.activated=1 is not null order by id desc) as x group by x.user_id, x.imeinumber"
 64 
GCM_REG_ID_SQL2 = "select x.user_id, x.gcm_regid, x.id, x.androidid, x.created, x.imeinumber  from (select gc.* from gcm_users gc join users u on u.id=gc.user_id where gc.user_id in (%s) and gc.androidid is null and gc.imeinumber and u.activated=1 is not null order by id desc) as x group by x.user_id, x.imeinumber"