def store_db(self, item):
engine = db_connect()
session = sessionmaker(bind=engine)
session = session()
news = News()
imgs = []
if item['imgs'] is not None:
for img in item['imgs']:
i = Imgs()
i.img = img
imgs.append(i)
tags = []
if item['tags'] is not None:
for tag in item['tags']:
t = Tags()
t.tag = tag.lower()
news.tags.append(t)
news.link = item['link']
news.title = item['title']
news.subtitle = item['subtitle']
news.session = item['session']
news.sub_session = item['sub_session']
news.author = item['author']
news.publisher = item['publisher']
news.text = item['text']
news.imgs = imgs
news.datetime = convert_datetime(item['date'], item['hour'])
session.add(news)
session.commit()
session.close()
def import_news():
author = UserData.objects.get(id=1)
print author.username
for new_old in Stats.objects.all():
if new_old.catid != 0 and (new_old.catid == 2 or new_old.catid == 3):
print new_old.id, new_old.name, new_old.catid
stci = News()
print author
# stci.id = new_old.id
stci.article = new_old.full.replace('http://centrinform.info/', 'http://ci.ua/')
stci.author = author
stci.foreword = new_old.min.replace('http://centrinform.info/', 'http://ci.ua/')
stci.slug = new_old.url
stci.title = new_old.name
stci.creation_date = new_old.dat_created
stci.description = new_old.opisanie
stci.key_words = new_old.klucheviki
stci.category = NewsCategory.objects.get(id=new_old.catid)
stci.save()
# News.objects.get_or_create(
#
# id=new_old.id,
# article=new_old.full.replace('http://centrinform.info/', 'http://ci.ua/'),
# author=author,
# foreword=new_old.min.replace('http://centrinform.info/', 'http://ci.ua/'),
# slug=new_old.url,
# title=new_old.name,
# creation_date=new_old.dat_created,
# description=new_old.opisanie,
# key_words=new_old.klucheviki,
# category=NewsCategory.objects.get(id=new_old.catid)
# # defaults={'category': NewsCategory.objects.get(id=new_old.catid)} # default применится в случае create
# )
# new.article = new_old
# # new.article = new_old.full.replace('http://centrinform.info/', 'http://ci.ua/')
# new.author = author
# new.category = NewsCategory.objects.get(id=new_old.catid)
# new.foreword = new_old.min.replace('http://centrinform.info/', 'http://ci.ua/')
# new.part_url = new_old.url
# new.title = new_old.name
# new.save()
# try:
#
# except Stats.DoesNotExist:
# print u'Нету'
def new_post(blog_id, username, password, post, publish):
user = authenticate(username, password)
item = News()
item.title = post['title']
item.description = post['description']
if post.get('dateCreated'):
item.dateCreated = datetime.strptime(str(post['dateCreated']),'%Y%m%dT%H:%M:%S')
else:
item.dateCreated = datetime.now().date()
item.author = user
item.publish = publish
item.categories = Categories.objects.get(name=u'Новости сайта')
item.save()
return item.pk
def save(request):
if isLoggedIn(request):
req = request.POST
id = req.get('id')
title = req.get('title')
content = req.get('content')
mag = req.get('mag')
signature = request.COOKIES.get('signature')
if not int(id) == 0:
news = News.objects.filter(id=id).first()
else:
news = News()
if title and content and mag:
news.title = title
news.content = content
news.mag = mag
news.author = signature
news.save()
id = news.id
news = News.objects.filter(id=id)
return HttpResponse(serialize('json', news))
return HttpResponse('0')
