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

 from elixir import session
 import datetime
 from sqlalchemy import desc
 from sqlalchemy import select
 from shop2020.model.v1.user.impl.CartDataAccessors import create_cart
+from sqlalchemy.sql import and_
 def initialize(dbname='user', db_hostname="localhost"):
     log_entry("initialize@DataAccessor", "Initializing data service")
     Dataservice.initialize(dbname, db_hostname)
     session.commit()
 def get_trust_level(userId):
     user = User.query.filter_by(id = userId).first()
     return user.trust_level
+def get_user_emails(start_date, end_date):
+    emails = select([User.table.c.communication_email], and_(User.table.c.active_since >= start_date, User.table.c.active_since <= end_date, User.table.c.is_anonymous==0)).execute()
+    email_addresses = []
+    for email in emails:
+        email_addresses.append(str(email[0]))
+    return email_addresses
 def close_session():
     if session.is_active:
         print "session is active. closing it."
         session.close()

Subversion Repositories SmartDukaan