Subversion Repositories SmartDukaan

Rev

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

Rev 5341 Rev 5407
Line 12... Line 12...
12
from shop2020.thriftpy.model.v1.user.ttypes import UserContextException,\
12
from shop2020.thriftpy.model.v1.user.ttypes import UserContextException,\
13
    AuthenticationException, Sex
13
    AuthenticationException, Sex
14
from elixir import session
14
from elixir import session
15
import datetime
15
import datetime
16
from sqlalchemy import desc
16
from sqlalchemy import desc
-
 
17
from sqlalchemy import select
17
from shop2020.model.v1.user.impl.CartDataAccessors import create_cart
18
from shop2020.model.v1.user.impl.CartDataAccessors import create_cart
18
 
19
 
19
 
20
 
20
def initialize(dbname='user', db_hostname="localhost"):
21
def initialize(dbname='user', db_hostname="localhost"):
21
    log_entry("initialize@DataAccessor", "Initializing data service")
22
    log_entry("initialize@DataAccessor", "Initializing data service")
Line 244... Line 245...
244
    return UserCommunication.query.filter_by(user_id = user_communication_user_id).order_by(-UserCommunication.id).all()
245
    return UserCommunication.query.filter_by(user_id = user_communication_user_id).order_by(-UserCommunication.id).all()
245
 
246
 
246
def get_all_user_communications():
247
def get_all_user_communications():
247
    return UserCommunication.query.order_by(-UserCommunication.id).all()
248
    return UserCommunication.query.order_by(-UserCommunication.id).all()
248
 
249
 
-
 
250
def remove_user_communication(commId):
-
 
251
    UserCommunication.query.filter_by(id=commId).delete()
-
 
252
    session.commit()
-
 
253
    
249
def create_master_affiliate(name, added_on):
254
def create_master_affiliate(name, added_on):
250
    master_affiliate = MasterAffiliate()
255
    master_affiliate = MasterAffiliate()
251
    master_affiliate.name = name
256
    master_affiliate.name = name
252
    master_affiliate.added_on = to_py_date(added_on)
257
    master_affiliate.added_on = to_py_date(added_on)
253
    session.commit()
258
    session.commit()
Line 483... Line 488...
483
def increase_trust_level(userId, trustLevelDelta):
488
def increase_trust_level(userId, trustLevelDelta):
484
    user = User.query.filter_by(id = userId).with_lockmode('update').first()
489
    user = User.query.filter_by(id = userId).with_lockmode('update').first()
485
    user.trust_level += trustLevelDelta
490
    user.trust_level += trustLevelDelta
486
    session.commit()
491
    session.commit()
487
 
492
 
-
 
493
def get_trust_level(userId):
-
 
494
    user = User.query.filter_by(id = userId).first()
-
 
495
    return user.trust_level
-
 
496
    
488
def close_session():
497
def close_session():
489
    if session.is_active:
498
    if session.is_active:
490
        print "session is active. closing it."
499
        print "session is active. closing it."
491
        session.close()
500
        session.close()
492
 
501