def save(self): request = self.request model_state = self.model_state model_state.schema = SuggestionSchema() if not model_state.validate(): log.debug('validation error') request.errors = model_state.errors() return {} with request.connmgr.get_connection() as conn: sql = ''' Declare @RC int, @ErrMsg nvarchar(500) EXEC @RC = sp_Suggest ?, ?, @ErrMsg=@ErrMsg OUTPUT SELECT @RC AS [Return], @ErrMsg AS ErrMsg''' result = conn.execute(sql, request.user.Email, model_state.value('Suggestion')).fetchone() if result.Return: model_state.add_error_for('*', result.ErrMsg) return self._get_edit_info() with request.connmgr.get_connection() as conn: addresses = conn.execute('EXEC sp_User_Admin_l').fetchall() if addresses: email_msg = new_suggestion_email_template % { 'Email': request.user.Email, 'Suggestion': model_state.value('Suggestion') } send_email(request, '*****@*****.**', [x.Email for x in addresses], 'New Feature Suggestion', email_msg, reply=request.user.Email) request.session.flash('Thank you for your suggestion') raise HTTPFound(location=request.route_url('search_index'))
def save(self): request = self.request model_state = self.model_state model_state.schema = SuggestionSchema() if not model_state.validate(): log.debug('validation error') request.errors = model_state.errors() return {} with request.connmgr.get_connection() as conn: sql = ''' Declare @RC int, @ErrMsg nvarchar(500) EXEC @RC = sp_Suggest ?, ?, @ErrMsg=@ErrMsg OUTPUT SELECT @RC AS [Return], @ErrMsg AS ErrMsg''' result = conn.execute(sql, request.user.Email, model_state.value('Suggestion')).fetchone() if result.Return: model_state.add_error_for('*', result.ErrMsg) return self._get_edit_info() with request.connmgr.get_connection() as conn: addresses = conn.execute('EXEC sp_User_Admin_l').fetchall() if addresses: email_msg = new_suggestion_email_template % {'Email': request.user.Email, 'Suggestion': model_state.value('Suggestion')} send_email(request, '*****@*****.**', [x.Email for x in addresses], 'New Feature Suggestion', email_msg, reply=request.user.Email) request.session.flash('Thank you for your suggestion') raise HTTPFound(location=request.route_url('search_index'))
def dumperroremail(): if sys.stderr.is_ditry(): email.send_email(None, '*****@*****.**', ['*****@*****.**'], 'Feature DB Notifications Output', sys.stdout.getvalue())
def send_notification(args, namespace): body = render('featuredb:templates/email/notification.mak', namespace) subject = 'Updated Enhancements -- CIOC Feature Request DB' email.send_email(None, '*****@*****.**', namespace['Email'], subject, email.format_message(body, sep="\n"))