def get_news():
now = datetime.now()
strnow = now.strftime('%Y-%m-%d %H:%M:%S')
print(strnow)
# First next run time
'''
period = timedelta(days=day, hours=hour, minutes=min, seconds=second)
next_time = now + period
strnext_time = next_time.strftime('%Y-%m-%d %H:%M:%S')
print(strnext_time)
'''
pasttime = now - timedelta(days=1)
paststr = pasttime.strftime('%Y-%m-%d %H:%M:%S')
print(paststr)
df = pro.news(src='sina', start_date=strnow, end_date=paststr)
print(df)
for index, row in df.iterrows():
news = News()
news.timestamp = index
news.title = row['title']
news.body = row['content']
news.author = 'default'
db.session.add(news)
db.session.commit()
newss = News.query.all()
for n in newss:
print(n.id, n.body)
def _add_news():
json = request.get_json(force=True)
print(json)
news = News(
title=json['title'],
short_text=json['short_text'],
full_text=json['full_text'],
)
from datetime import datetime
news.creation_date = datetime.strptime(json['creation_date'], '%d/%m/%Y')
tag_list = json['tags']
author_id = json['author_id']
author = Author.query \
.filter(Author.author_id == author_id)
news.author = author
tags = Tag.query \
.filter(Tag.tag_id.in_(tag_list)).all()
news.tags = tags
db.session.add(news)
db.session.commit()
return 'ok'
def edit(request):
print request.method
if request.method == "POST":
title = request.POST.get("title", None)
content = request.POST.get("content", None)
news_id = request.POST.get("news_id", None)
delete_tag = request.POST.get("delete_tag", None)
print title
print content
print news_id
print delete_tag
if delete_tag is None:
if title is None or content is None:
return HttpResponse("error")
# 新建news
if news_id is None or news_id == "":
print news_id
try:
news = News()
news.title = title
news.content = content
news.author = "zhaolong"
news.read_count = 0
news.save()
return HttpResponse("success")
except:
return HttpResponse("error")
# 更新news 内容
else:
try:
news = News.objects.get(news_id=int(news_id))
news.title = title
news.content = content
news.author = "zhaolong"
news.save()
return HttpResponse("success")
except:
return HttpResponse("error")
# 删除news
else:
if news_id is None:
return HttpResponse("error")
try:
news = News.objects.get(news_id=int(news_id))
news.delete()
return HttpResponse("success")
except:
return HttpResponse("error")
elif request.method == "GET":
try:
news_id = int(request.GET.get("nid", -1))
news=News.objects.get(pk=news_id)
form = UEditorTestModelForm(instance= news)
except Exception, e:
print str(e)
form = TestUEditorForm( initial={'content': '请在此输入文字'} )
news = None
return render(request, "adminer/editNews.html", {
'form': form,
'news': news,
})
