def readContent(self): with open(staticfiles_storage.path('content_api.json'), encoding="utf-8") as f: data = json.load(f) for article in data['results']: if not Article.objects.filter(uuid=article['uuid']).exists(): newArticle = Article() newArticle.authorByLine = article['byline'] newArticle.body = article['body'] newArticle.publishDate = article['publish_at'].split('T')[0] newArticle.headline = article['headline'] newArticle.promo = article['promo'] newArticle.disclosure = article['disclosure'] newArticle.uuid = article['uuid'] newArticle.slug = slugify(article['headline']) for img in article['images']: if img['featured']: newArticle.featuredImage = img['url'] for ins in article['instruments']: newArticle.save() if Instrument.objects.filter( instrumentId=ins['instrument_id']).exists(): newArticle.relatedInstruments.add( Instrument.objects.get( instrumentId=ins['instrument_id'])) else: i = Instrument() i.instrumentId = ins['instrument_id'] i.companyName = ins['company_name'] i.symbol = ins['symbol'] i.exchange = ins['exchange'] i.save() newArticle.relatedInstruments.add(i) for tag in article['tags']: newArticle.save() if Tag.objects.filter(uuid=tag['uuid']).exists(): newArticle.tags.add(Tag.objects.get(uuid=tag['uuid'])) else: t = Tag() t.uuid = tag['uuid'] t.tagName = tag['name'] t.tagSlug = tag['slug'] t.tagTypeName = tag['tag_type']['name'] t.tagTypeSlug = tag['tag_type']['slug'] t.save() newArticle.tags.add(t) newArticle.save() for tag in article['tags']: if self.first == '' and tag['slug'] == '10-promise': self.first = Article.objects.get(uuid=article['uuid'])
def form(request, action, id='-1'): form = ArticleForm try: article = Article.objects.get(id=int(id)) frm = form( initial={ 'author': article.author, 'title': article.title, 'body': article.body, 'preview': article.preview, 'tags_string': article.tags_string, }) except Article.DoesNotExist: article = Article() frm = form() if request.method == 'POST': frm = form(request.POST) if frm.is_valid(): cd = frm.cleaned_data article.author = cd['author'] article.title = cd['title'] article.body = cd['body'] article.preview = cd['preview'] article.tags_string = cd['tags_string'] if action == 'add': article.created = datetime.now() article.modified = datetime.now() article.save() return HttpResponseRedirect('/articles') #return render_to_response('works/result.html', {'post': work }) return direct_to_template(request, 'articles/form.html', { 'form': frm, 'article': article, 'action': action })
def changeBD(request): items_news = [] db = MySQLdb.connect(host="localhost", user="******", passwd="1(8Ik<7YgV", db="giyyan_prasby", charset='utf8') cursor = db.cursor() # запрос к БД sql = """SELECT author, title, preview, body, created FROM `articles_article_old`""" # выполняем запрос cursor.execute(sql) # получаем результат выполнения запроса data = cursor.fetchall() # перебираем записи for rec in data: # извлекаем данные из записей - в том же порядке, как и в SQL-запросе author, title, preview, body, created = rec # добавляем item = Article() item.author = author item.title = title item.title_by = title item.preview = preview item.preview_by = preview item.body = body item.body_by = body item.save() items_news.append(item) # закрываем соединение с БД db.close() return direct_to_template(request, 'tools/change.html', {'items_news': items_news})
def form(request, action, id='-1'): form = ArticleForm try: article = Article.objects.get(id=int(id)) frm = form(initial={ 'author': article.author, 'title': article.title, 'body': article.body, 'preview': article.preview, 'tags_string': article.tags_string, }) except Article.DoesNotExist: article = Article() frm = form() if request.method == 'POST': frm = form(request.POST) if frm.is_valid(): cd = frm.cleaned_data article.author = cd['author'] article.title = cd['title'] article.body = cd['body'] article.preview = cd['preview'] article.tags_string = cd['tags_string'] if action == 'add': article.created = datetime.now() article.modified = datetime.now() article.save() return HttpResponseRedirect('/articles' ) #return render_to_response('works/result.html', {'post': work }) return direct_to_template(request, 'articles/form.html', {'form': frm, 'article': article, 'action': action})
def changeBD(request): items_news = [] db = MySQLdb.connect(host="localhost", user="******", passwd="1(8Ik<7YgV", db="giyyan_prasby", charset="utf8") cursor = db.cursor() # запрос к БД sql = """SELECT author, title, preview, body, created FROM `articles_article_old`""" # выполняем запрос cursor.execute(sql) # получаем результат выполнения запроса data = cursor.fetchall() # перебираем записи for rec in data: # извлекаем данные из записей - в том же порядке, как и в SQL-запросе author, title, preview, body, created = rec # добавляем item = Article() item.author = author item.title = title item.title_by = title item.preview = preview item.preview_by = preview item.body = body item.body_by = body item.save() items_news.append(item) # закрываем соединение с БД db.close() return direct_to_template(request, "tools/change.html", {"items_news": items_news})
def step5(request, action_id, form_class=ActionStep5Form, template_name="actions/step5.html"): action = get_object_or_404(Action, pk=action_id) if not has_perm(request.user,'actions.add_action'): raise Http403 if request.method == "POST": form = form_class(request.POST) if form.is_valid(): add_article = form.cleaned_data['add_article'] if add_article: # add an article from articles.models import Article from categories.models import Category from perms.object_perms import ObjectPermission from django.template.defaultfilters import slugify # article slug is a unique field, if the slug already exists, # what should we do? let append the action id to it to keep it unique slug = slugify(action.email.subject + '-' + str(action.id)) try: art = Article.objects.get(slug=slug) except Article.DoesNotExist: art = Article() art.headline = action.email.subject art.slug = slug art.summary = "" art.body = action.email.body art.sourct = request.user.get_full_name() art.first_name = request.user.first_name art.last_name = request.user.last_name profile = request.user.get_profile() art.phone = profile.phone art.fax = profile.fax art.email = profile.email art.website = get_setting('site', 'global', 'siteurl') art.release_dt = datetime.datetime.now() if action.member_only: art.allow_anonymous_view = 1 art.allow_user_view = 1 art.allow_member_view = 1 art.allow_anonymous_edit = 0 art.allow_user_edit = 0 art.allow_member_edit = 0 art.status = 1 art.status_detail = 'active' art.creator = request.user art.creator_username = request.user.username art.owner = request.user art.owner_username = request.user.username art.save() # user group - assign the permission to view this article if action.group: ObjectPermission.objects.assign_group(action.group, art) # update category category = Category.objects.update(art, 'Newsletter', 'category') action.article = art action.save() #if action.group.members.count() < LIMIT: return HttpResponseRedirect(reverse('action.send', args=[action.id])) #else: # # return to confirmation page # return HttpResponseRedirect(reverse('action.confirm', args=[action.id])) else: form = form_class() return render_to_response(template_name, {'form':form, 'action':action}, context_instance=RequestContext(request))
path = SimpleUploadedFile(path_str, data) img = ArticleImage( image = path, caption = clean_text(photo['caption']), byline = photo['photographer'], article = article ) img.save() status += '-- Imported images for new story %s<br>' % article.headline else: if article.headline != story['headline']: article.headline = story['headline'] if article.summary != story['summary']: article.summary = story['summary'] if article.body != story['body']: article.body = story['body'] status += 'updating story: %s <br>' % article.headline if article.dateline != story['dateline']: article.dateline = story['dateline'] if article.overline != story['overline']: article.overline = story['overline'] if article.id and story.has_key('images'): img_count = 0 for photo_id, photo in story['images'].items(): dupe = False filename = photo['source_url'].rsplit('/', 1)[1] path_str = get_image_path(filename, pub_date) shortname = path_str.split('.')[0] # get file name before the first period. Ex: /img/articles/mypic #print shortname #if shortname in current_images: