Subversion Repositories SmartDukaan

'''

Created on 14-Jul-2010

@author: ashish

'''

from email.mime.multipart import MIMEMultipart

from shop2020.thriftpy.utils.ttypes import HelperServiceException, Mail

from email.mime.base import MIMEBase

from email import encoders

import os

import smtplib

from shop2020.utils.Utils import log_entry, to_py_date

from shop2020.helpers.impl.DataService import Message, UserEmail,\

    Report, ReportRoleAuthority, CatalogDashboardUser, UserEmailArchive

from elixir import *

from shop2020.thriftpy.utils.ttypes import Message as Msg

from string import Template

import datetime

from shop2020.helpers.impl import DataService

from email.mime.text import MIMEText

from sqlalchemy.orm import query

from shop2020.helpers.impl.model.DashboardUser import DashboardUser

def initialize(dbname='helper'):

    log_entry("initialize@DataAccessor", "Initializing data service")

    DataService.initialize(dbname)

def save_user_email_for_sending(email_to, email_from, subject, body, source, email_type):

    user_email = UserEmail()

    user_email.emailTo = email_to

    user_email.emailFrom = email_from

    user_email.subject = subject

    user_email.body = body

    user_email.source = source

    user_email.emailType = email_type

    user_email.status = False

    user_email.timestamp = datetime.datetime.now()

    session.commit()

def get_emails_to_be_sent():

    print "get_emails_to_be_sent"

    return UserEmail.query.all()

def mark_email_as_sent(email_id):

    query = 'INSERT INTO ' + str(UserEmailArchive.table) + ' (select * from ' + str(UserEmail.table) + ' where id = ' + str(email_id) + ')'

    session.execute(query, mapper=UserEmailArchive)

    email = UserEmail.get_by(id = email_id)

    if email:

        email.delete()

    session.commit()

def sendMail(mail):

    if not mail:

        raise HelperServiceException(101, "mail not present")

    #msg = MIMEMultipart()

    #mail = Mail()

    if mail.sender:

        mail.data = "This mail is sent by " + mail.sender + "\n" + mail.data

    msg = MIMEText(mail.data)

    msg['To'] = ', '.join( mail.to )

    if mail.sender:

        msg['From'] = mail.sender

    else:    

        msg['From'] = "help@saholic.com"

    msg['Subject'] = mail.subject

    #msg.attach(mail.data)

    #handle attachments in mail

    if mail.attachments:

        for attach in mail.attachments:

            part = MIMEBase('application', 'octet-stream')

            part.set_payload(open(attach, 'rb').read())

            encoders.encode_base64(part)

            part.add_header('Content-Disposition',

                    'attachment; filename="%s"' % os.path.basename(attach))

            msg.attach(part)

    for to in mail.to:

        mail.sender = "help@shop2020.in"

        mail.password = "5h0p2o2o"

        mailServer = smtplib.SMTP("smtp.gmail.com", 587)

        mailServer.ehlo()

        mailServer.starttls()

        mailServer.ehlo()

        mailServer.login(mail.sender, mail.password)

        mailServer.sendmail(mail.password, to, msg.as_string())

        # Should be mailServer.quit(), but that crashes...

        mailServer.close() 

def sendText(text):

    pass

def addMessage(message):

    msg = Message.get_by(message_id=message.id)

    if msg:

        raise HelperServiceException(101, "Message is already present. Please try updation api instead")

    msg = Message();

    msg.message_id = message.id

    msg.message = message.message

    session.commit()

def getMessage(message_id):

    msg = Message.get_by(id=message_id)

    message = Msg()

    message.id = msg.message_id

    message.message = msg.message

    return message

def updateMessage(id, message):

    msg = Message.get_by(message_id=id)

    if msg:

        msg.message = message

        session.commit()

    else:

        raise HelperServiceException(101, "message could not be found with id %d" %(id))

def getSubstitutedMessage(id, params):

    #get the message first

    msg = Message.get_by(message_id=id)

    if not msg:

        raise HelperServiceException(101, "message could not be found with id %d" %(id))

    if params:

        s = Template(msg.message)

        s = s.safe_substitute(params)

        return s

    else:

        return msg.message

def add_user(username, password, warehouseId):

    user = DashboardUser()

    user.username = username

    user.password = password

    user.warehouseId = warehouseId

    user.addedOn = datetime.datetime.now()

    user.status = 0

    try:

        session.commit()

        return True

    except:

        raise HelperServiceException(101, "Some error while adding user")

        return False

def delete_user(username):

    user = DashboardUser.get_by(username=username)

    if user is None:

        return False

    user.delete()

    session.commit()

    return True

def authenticate_dashboard_user(username, password):

    user = DashboardUser.get_by(username=username, password=password)

    if user is None:

        raise HelperServiceException(101, "No dashboard user found")

    user.loggedOn = datetime.datetime.now()

    session.commit()

    return user.to_thrift_object()

def update_password(username, oldPassword, newPassword):

    user = DashboardUser.get_by(username=username)

    if user is None:

        return False

    if user.password == oldPassword:

        user.password = newPassword

        session.commit()

        return True

    return False

def get_reports(role):

    query = session.query(Report).join(ReportRoleAuthority)

    query = query.filter(ReportRoleAuthority.role == role)

    reports = query.all()

    return reports

def close_session():

    if session.is_active:

        print "session is active. closing it."

        session.close()