Example #1
0
    def on_create_dbaction(sender, instance, created, **kwargs):
        from core.tasks import SendEmailTask
        from dbapp.tasks import EmailMsg
        email_msg = EmailMsg(instance)
#        print email_msg.get_msg_html()
#        print email_msg.get_msg_text()
#        print email_msg.get_subject_text()
        if created:
            DbActionRes(dbaction=instance).save()
            admins = _user.objects.filter(is_superuser=True)
            for admin in admins:
                SendEmailTask().delay(subject=email_msg.get_subject_text(),
                                    message=email_msg.get_msg_text(),
                                    message_html=email_msg.get_msg_html(),
                                    recipient=admin.email)

        if not created and int(instance.execute_status) == 0:
            admins = _user.objects.filter(is_superuser=True)
            for admin in admins:
                SendEmailTask().delay(subject=email_msg.get_subject_text(),
                                    message=email_msg.get_msg_text(),
                                    message_html=email_msg.get_msg_html(),
                                    recipient=admin.email)

        if int(instance.execute_status) == 2:
            from .tasks import execute_dml
            sqlstring = instance.sql
            host      = instance.db.dbhost
            user      = instance.db.dbuser
            password  = instance.db.dbpass
            port      = instance.db.dbport
            database  = instance.db.dbname
            execute_dml.delay(
                        user=user,
                        password=password,
                        database=database,
                        host=host,
                        port=port,
                        sqlstring=sqlstring,
                        id=instance.dbactionres.id,
                        autocommit=True,
                )


#            SendEmailTask().apply_async(kwargs=dict(subject=email_msg.get_subject_text(),
#                                  message=email_msg.get_msg_text(),
#                                  message_html=email_msg.get_msg_html(),
#                                  recipient=instance.user.email
#                                  ),
#                                  countdown=10)


        if int(instance.execute_status) == 1:
            SendEmailTask().delay(subject=email_msg.get_subject_text(),
                                  message=email_msg.get_msg_text(),
                                  message_html=email_msg.get_msg_html(),
                                  recipient=instance.user.email)
Example #2
0
 def on_save_dbactionres(sender, instance, created, **kwargs):
     if not created and instance.execute_result:
         from core.tasks import SendEmailTask
         from dbapp.tasks import EmailMsg
         print instance.dbaction.execute_status
         instance_copy = copy.deepcopy(instance)
         instance_copy.execute_status = str(instance.dbaction.execute_status)
         instance_copy.datetime = instance.dbaction.datetime
         instance_copy.sql = instance.dbaction.sql
         instance_copy.user = instance.dbaction.user
         email_msg = EmailMsg(instance_copy)
         SendEmailTask().delay(subject=email_msg.get_subject_text(),
                            message=email_msg.get_msg_text(),
                            message_html=email_msg.get_msg_html(),
                            recipient=instance_copy.user.email,
                            )