| Line 1... |
Line 1... |
| 1 |
'''
|
1 |
'''
|
| 2 |
Created on 14-Jul-2010
|
2 |
Created on 14-Jul-2010
|
| 3 |
|
3 |
|
| 4 |
@author: ashish
|
4 |
@author: ashish
|
| 5 |
'''
|
5 |
'''
|
| 6 |
from email.mime.multipart import MIMEMultipart
|
- |
|
| 7 |
from shop2020.thriftpy.utils.ttypes import HelperServiceException, Mail
|
- |
|
| 8 |
from email.mime.base import MIMEBase
|
6 |
from elixir import *
|
| 9 |
from email import encoders
|
7 |
from email import encoders
|
| 10 |
import os
|
8 |
from email.mime.base import MIMEBase
|
| - |
|
9 |
from email.mime.multipart import MIMEMultipart
|
| 11 |
import smtplib
|
10 |
from email.mime.text import MIMEText
|
| 12 |
from shop2020.utils.Utils import log_entry, to_py_date
|
11 |
from shop2020.helpers.impl import DataService
|
| 13 |
from shop2020.helpers.impl.DataService import Message, UserEmail, EntitiesShared, \
|
12 |
from shop2020.helpers.impl.DataService import Message, UserEmail, EntitiesShared, \
|
| 14 |
Report, ReportRoleAuthority, CatalogDashboardUser, UserEmailArchive, QuickLink
|
13 |
Report, ReportRoleAuthority, CatalogDashboardUser, UserEmailArchive, QuickLink
|
| 15 |
|
- |
|
| 16 |
from elixir import *
|
14 |
from shop2020.helpers.impl.model.Agent import Agent
|
| 17 |
|
- |
|
| - |
|
15 |
from shop2020.helpers.impl.model.DashboardUser import DashboardUser
|
| 18 |
from shop2020.thriftpy.utils.ttypes import Message as Msg
|
16 |
from shop2020.thriftpy.utils.ttypes import HelperServiceException, Mail, \
|
| - |
|
17 |
Message as Msg
|
| - |
|
18 |
from shop2020.utils.Utils import log_entry, to_py_date
|
| - |
|
19 |
from sqlalchemy.orm import query
|
| 19 |
from string import Template
|
20 |
from string import Template
|
| 20 |
import datetime
|
21 |
import datetime
|
| 21 |
from shop2020.helpers.impl import DataService
|
- |
|
| 22 |
from email.mime.text import MIMEText
|
22 |
import os
|
| 23 |
from sqlalchemy.orm import query
|
23 |
import smtplib
|
| 24 |
from shop2020.helpers.impl.model.DashboardUser import DashboardUser
|
- |
|
| 25 |
|
24 |
|
| 26 |
def initialize(dbname='helper', db_hostname="localhost"):
|
25 |
def initialize(dbname='helper', db_hostname="localhost"):
|
| 27 |
log_entry("initialize@DataAccessor", "Initializing data service")
|
26 |
log_entry("initialize@DataAccessor", "Initializing data service")
|
| 28 |
DataService.initialize(dbname, db_hostname)
|
27 |
DataService.initialize(dbname, db_hostname)
|
| 29 |
|
28 |
|
| Line 204... |
Line 203... |
| 204 |
quicklink = QuickLink.get_by(id = id)
|
203 |
quicklink = QuickLink.get_by(id = id)
|
| 205 |
quicklink.url = url
|
204 |
quicklink.url = url
|
| 206 |
quicklink.text = text
|
205 |
quicklink.text = text
|
| 207 |
session.commit()
|
206 |
session.commit()
|
| 208 |
|
207 |
|
| - |
|
208 |
def update_password_for_agent(agentEmailId, password):
|
| - |
|
209 |
agent = Agent.get_by(emailId = agentEmailId)
|
| - |
|
210 |
agent.password = password
|
| - |
|
211 |
session.commit()
|
| - |
|
212 |
|
| 209 |
def get_emails_for_notifications_sent(start_datetime, end_datetime):
|
213 |
def get_emails_for_notifications_sent(start_datetime, end_datetime):
|
| 210 |
query = UserEmailArchive.query.filter(UserEmailArchive.emailType == 'ProductNotification')
|
214 |
query = UserEmailArchive.query.filter(UserEmailArchive.emailType == 'ProductNotification')
|
| 211 |
query = query.filter(UserEmailArchive.timestamp >= start_datetime)
|
215 |
query = query.filter(UserEmailArchive.timestamp >= start_datetime)
|
| 212 |
query = query.filter(UserEmailArchive.timestamp <= end_datetime)
|
216 |
query = query.filter(UserEmailArchive.timestamp <= end_datetime)
|
| 213 |
return query.all()
|
217 |
return query.all()
|