WebSVN – SmartDukaan – Diff – /trunk/PyProj/src/shop2020/model/v1/user/impl/UserDataAccessors.py



    return UserCommunication.query.filter_by(user_id = user_communication_user_id).order_by(-UserCommunication.id).all()
 
def get_all_user_communications():
    return UserCommunication.query.order_by(UserCommunication.user_id, -UserCommunication.id).all()
 
def create_master_affiliate(name, added_on):
    master_affiliate = MasterAffiliate()
    master_affiliate.name = name
    master_affiliate.added_on = to_py_date(added_on)
    session.commit()
    return master_affiliate
 
def get_master_affiliate_by_id(id):
    return MasterAffiliate.get_by(id = id)
 
def get_master_affiliate_by_name(name):
    return MasterAffiliate.get_by(name = name)
 
def create_affiliate(name, url, master_affiliate_id, added_on):
    affiliate = Affiliate()
    affiliate.name = name
    if url is not None:
        affiliate.url = url
    affiliate.master_affiliate_id = master_affiliate_id
    affiliate.added_on = to_py_date(added_on)
    session.commit()
    return affiliate
 
def get_affiliate_by_id(id):
    return Affiliate.get_by(id = id)

    return Affiliate.get_by(name = name)
 
def get_affiliates_by_master_affiliate(master_affiliate_id):
    return MasterAffiliate.get_by(id =  master_affiliate_id).affiliates
 
def create_tracker(affiliate_id, added_on):
    tracker = Tracker()
    tracker.affiliate_id = affiliate_id
    tracker.added_on = to_py_date(added_on)
    session.commit()
    return tracker
 
def get_tracker_by_id(id):
    return Tracker.get_by(id = id)
 
def get_trackers_by_affiliate(affiliate_id):
    return Affiliate.get_by(id = affiliate_id).trackers
 
def add_track_log(tracker_id, user_id, event, url, data, added_on):
    track_log = TrackLog()
    track_log.tracker_id = tracker_id
    if user_id:
        track_log.user_id = user_id
    track_log.event = event
    if url:
        track_log.url = url
    if data:
        track_log.data = data
    track_log.added_on = to_py_date(added_on)
    session.commit()
    return track_log.id
 
def get_track_log_by_id(id):
    return TrackLog.get_by(id = id)

Rev 1845	Rev 1859
Line 270...	Line 270...
270	`return UserCommunication.query.filter_by(user_id = user_communication_user_id).order_by(-UserCommunication.id).all()`	270	`return UserCommunication.query.filter_by(user_id = user_communication_user_id).order_by(-UserCommunication.id).all()`
271		271
272	`def get_all_user_communications():`	272	`def get_all_user_communications():`
273	`return UserCommunication.query.order_by(UserCommunication.user_id, -UserCommunication.id).all()`	273	`return UserCommunication.query.order_by(UserCommunication.user_id, -UserCommunication.id).all()`
274		274
275	`def create_master_affiliate(name):`	275	`def create_master_affiliate(name, added_on):`
276	`master_affiliate = MasterAffiliate()`	276	`master_affiliate = MasterAffiliate()`
277	`master_affiliate.name = name`	277	`master_affiliate.name = name`
-		278	`master_affiliate.added_on = to_py_date(added_on)`
278	`session.commit()`	279	`session.commit()`
279	`return master_affiliate`	280	`return master_affiliate`
280		281
281	`def get_master_affiliate_by_id(id):`	282	`def get_master_affiliate_by_id(id):`
282	`return MasterAffiliate.get_by(id = id)`	283	`return MasterAffiliate.get_by(id = id)`
283		284
284	`def get_master_affiliate_by_name(name):`	285	`def get_master_affiliate_by_name(name):`
285	`return MasterAffiliate.get_by(name = name)`	286	`return MasterAffiliate.get_by(name = name)`
286		287
287	`def create_affiliate(name, url, master_affiliate_id):`	288	`def create_affiliate(name, url, master_affiliate_id, added_on):`
288	`affiliate = Affiliate()`	289	`affiliate = Affiliate()`
289	`affiliate.name = name`	290	`affiliate.name = name`
290	`if url is not None:`	291	`if url is not None:`
291	`affiliate.url = url`	292	`affiliate.url = url`
292	`affiliate.master_affiliate_id = master_affiliate_id`	293	`affiliate.master_affiliate_id = master_affiliate_id`
-		294	`affiliate.added_on = to_py_date(added_on)`
293	`session.commit()`	295	`session.commit()`
294	`return affiliate`	296	`return affiliate`
295		297
296	`def get_affiliate_by_id(id):`	298	`def get_affiliate_by_id(id):`
297	`return Affiliate.get_by(id = id)`	299	`return Affiliate.get_by(id = id)`
Line 300...	Line 302...
300	`return Affiliate.get_by(name = name)`	302	`return Affiliate.get_by(name = name)`
301		303
302	`def get_affiliates_by_master_affiliate(master_affiliate_id):`	304	`def get_affiliates_by_master_affiliate(master_affiliate_id):`
303	`return MasterAffiliate.get_by(id = master_affiliate_id).affiliates`	305	`return MasterAffiliate.get_by(id = master_affiliate_id).affiliates`
304		306
305	`def create_tracker(affiliate_id):`	307	`def create_tracker(affiliate_id, added_on):`
306	`tracker = Tracker()`	308	`tracker = Tracker()`
307	`tracker.affiliate_id = affiliate_id`	309	`tracker.affiliate_id = affiliate_id`
-		310	`tracker.added_on = to_py_date(added_on)`
308	`session.commit()`	311	`session.commit()`
309	`return tracker`	312	`return tracker`
310		313
311	`def get_tracker_by_id(id):`	314	`def get_tracker_by_id(id):`
312	`return Tracker.get_by(id = id)`	315	`return Tracker.get_by(id = id)`
313		316
314	`def get_trackers_by_affiliate(affiliate_id):`	317	`def get_trackers_by_affiliate(affiliate_id):`
315	`return Affiliate.get_by(id = affiliate_id).trackers`	318	`return Affiliate.get_by(id = affiliate_id).trackers`
316		319
317	`def add_track_log(tracker_id, user_id, event, url, data):`	320	`def add_track_log(tracker_id, user_id, event, url, data, added_on):`
318	`track_log = TrackLog()`	321	`track_log = TrackLog()`
319	`track_log.tracker_id = tracker_id`	322	`track_log.tracker_id = tracker_id`
320	`if user_id:`	323	`if user_id:`
321	`track_log.user_id = user_id`	324	`track_log.user_id = user_id`
322	`track_log.event = event`	325	`track_log.event = event`
323	`if url:`	326	`if url:`
324	`track_log.url = url`	327	`track_log.url = url`
325	`if data:`	328	`if data:`
326	`track_log.date = data`	329	`track_log.data = data`
-		330	`track_log.added_on = to_py_date(added_on)`
327	`session.commit()`	331	`session.commit()`
328	`return track_log.id`	332	`return track_log.id`
329		333
330	`def get_track_log_by_id(id):`	334	`def get_track_log_by_id(id):`
331	`return TrackLog.get_by(id = id)`	335	`return TrackLog.get_by(id = id)`

Subversion Repositories SmartDukaan

(root)/trunk/PyProj/src/shop2020/model/v1/user/impl/UserDataAccessors.py – Rev 1845 → 1859