def test_board_name_date(self):
""" Create and test a board for correct name and active date """
board = Board(name="Test Board",
post_code=PostCodeDistrict.objects.get(pk=1))
board.save()
self.assertEqual(board.name, 'Test Board')
self.assertEqual(board.date_active, date.today())
class BoardAPIViewTest(TestCase):
"""Test suite for the Board API views."""
def setUp(self):
self.client = APIClient()
self.user = setup_user()
self.user.save()
self.board = Board(title='Test Board', created_by=self.user)
self.board.save()
# self.client.force_authenticate(self.user)
def test_api_can_create_a_new_board(self):
response = self.client.post('/api/v1/boards/', {
"title": "Test Board 2",
"created_by": self.user.id
})
self.assertEqual(response.status_code, status.HTTP_201_CREATED)
self.assertEqual(response.data['id'], self.board.pk + 1)
def test_api_can_update_a_board(self):
response = self.client.put('/api/v1/boards/{0}/'.format(self.board.pk),
{"title": "Test Board Updated"})
self.assertEqual(response.status_code, status.HTTP_200_OK)
self.assertEqual(response.data['title'], 'Test Board Updated')
def test_api_can_delete_a_board(self):
old_count = Board.objects.count()
response = self.client.delete('/api/v1/boards/{0}/'.format(
self.board.pk))
new_count = Board.objects.count()
self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT)
self.assertNotEqual(old_count, new_count)
def new(request):
if request.method == 'GET':
return render(request, 'boards/new.html')
elif request.method == 'POST':
title = request.POST.get('title')
content = request.POST.get('content')
id = request.POST.get('id')
if id:
board = Board.objects.get(id=id)
board.title = title
board.content = content
image = request.FILES.get('image')
board.image = image
board.save()
return redirect('boards:detail', board.id)
image = request.FILES.get('image')
board = Board(
title=title,
content=content,
image=image,
)
board.save()
# print(Board.objects.all())
# return render(request, 'boards/create.html', context)
return redirect('boards:detail', board.id)
def mutate(root, info, **kwargs):
ok = True
board = Board(
name=kwargs.get('name'),
description=kwargs.get('description'),
)
board.save()
return CreateBoard(ok=ok, board=board)
def create(request):
# create
if request.method == 'POST':
title = request.POST.get('title') # 글 제목
content = request.POST.get('content') # 글 내용
board = Board(title=title, content=content)
board.save()
return redirect('boards:detail', board.pk)
# new
else:
return render(request, 'boards/create.html')
def new(request):
# GET
if request.method == 'GET':
return render(request, 'boards/new.html')
# POST
else:
title = request.POST.get('title')
content = request.POST.get('content')
image = request.FILES.get('image')
board = Board(title=title, content=content, image=image)
board.save()
# get인지 post인지 확인
# print(request.method)
return redirect('boards:detail', board.id)
class LabelAPIViewTest(TestCase):
"""Test suite for the Label API views."""
def setUp(self):
self.client = APIClient()
self.user = setup_user()
self.user.save()
self.board = Board(title='Test Board', created_by=self.user)
self.board.save()
self.label = Label(board=self.board,
title='Red Label',
color='#FF0000')
self.label.save()
# self.client.force_authenticate(self.user)
def test_api_can_create_a_new_label(self):
response = self.client.post(
'/api/v1/boards/{board_pk}/labels/'.format(board_pk=self.board.pk),
{
"title": "Green Label",
"color": "#00FF00"
})
self.assertEqual(response.status_code, status.HTTP_201_CREATED)
self.assertEqual(response.data['id'], self.label.pk + 1)
def test_api_can_update_a_label(self):
response = self.client.put(
'/api/v1/boards/{board_pk}/labels/{label_pk}/'.format(
board_pk=self.board.pk, label_pk=self.label.pk), {
"title": "Blue Label",
"color": "#0000FF"
})
self.assertEqual(response.status_code, status.HTTP_200_OK)
self.assertEqual(response.data['title'], 'Blue Label')
self.assertEqual(response.data['color'], '#0000FF')
def test_api_can_delete_a_label(self):
old_count = Label.objects.count()
response = self.client.delete(
'/api/v1/boards/{board_pk}/labels/{label_pk}/'.format(
board_pk=self.board.pk, label_pk=self.label.pk), )
new_count = Label.objects.count()
self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT)
self.assertNotEqual(old_count, new_count)
class ColumnAPIViewTest(TestCase):
"""Test suite for the Column API views."""
def setUp(self):
self.client = APIClient()
self.user = setup_user()
self.user.save()
self.board = Board(title='Test Board', created_by=self.user)
self.board.save()
self.column = Column(board=self.board, title='Backlog', position=1)
self.column.save()
# self.client.force_authenticate(self.user)
def test_api_can_create_a_new_column(self):
response = self.client.post(
'/api/v1/boards/{board_pk}/columns/'.format(
board_pk=self.board.pk), {
"title": "In Progress",
"position": 2
})
self.assertEqual(response.status_code, status.HTTP_201_CREATED)
self.assertEqual(response.data['id'], self.column.pk +
1) # TODO // Column tests should use the position
def test_api_can_update_a_column(self):
response = self.client.put(
'/api/v1/boards/{board_pk}/columns/{position}/'.format(
board_pk=self.board.pk, position=1), {
"title": "Selected for Development",
})
self.assertEqual(response.status_code, status.HTTP_200_OK)
self.assertEqual(response.data['title'], 'Selected for Development')
def test_api_can_delete_a_column(self):
old_count = Column.objects.count()
response = self.client.delete(
'/api/v1/boards/{board_pk}/columns/{position}/'.format(
board_pk=self.board.pk, position=1), )
new_count = Column.objects.count()
self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT)
self.assertNotEqual(old_count, new_count)
django.setup()
# User model
from accounts.models import User
# Tutor model
from tutor_match.models import Department, Subject, Tutor, Schedule, Student
# Board model
from boards.models import Board, Topic, Post
# Job model
from job_find.models import Job
# Creating boards
try:
board1 = Board(name='Announcements',
description='Announce upcoming events at NDNU')
board1.save()
board2 = Board(name='Homework', description='Get help for homework.')
board2.save()
board3 = Board(name='Random', description='Random board')
board3.save()
print("The boards have been created.")
except:
print("Boards exist")
# Creating a user and jobs
try:
user1 = User.objects.create_user("*****@*****.**",
"workerpassword",
first_name="John",
last_name="Worker",
'''
Author: huangjy
Date: 2020-11-22 08:59:39
LastEditors: huangjy
LastEditTime: 2020-11-22 10:02:18
Description: models api 学习和使用
'''
from boards.models import Board
#创建对象
board = Board(name='java', description='java is good language')
#保存对象
board.save()
#访问字段的值
board.id
board.name
board.description
#更新字段
board.description = "This is effective java"
board.description
#每个Django模型都带有一个特殊的属性; 我们称之为模型管理器(Model Manager) 可通过objects 访问
#通过objects 创建新对象
board = Board.objects.create(name="Python",
description="General discussion about Python")
#>>> Board.objects.all()
# <QuerySet [<Board: Board object (1)>, <Board: Board object (2)>, <Board: Board object (3)>]>
#未实现 Board 的__str__ 方法。__str__方法是对象的字符串表示形式
# 定义之后展示
#<QuerySet [<Board: 板块id：1, 板块名称：Django>, <Board: 板块id：2, 板块名称：java>, <Board: 板块id：3, 板块名称：Python>]>
class CommentAPIViewSet(TestCase):
"""Test suite for the Comment API views."""
def setUp(self):
self.client = APIClient()
self.user = setup_user()
self.user.save()
self.board = Board(title='Test Board', created_by=self.user)
self.board.save()
self.label = Label(board=self.board,
title='Red Label',
color='#FF0000')
self.label.save()
self.label2 = Label(board=self.board,
title='Green Label',
color='#00FF00')
self.label2.save()
self.card = Card(board=self.board,
title='Test Card',
description='Test Card description',
created_by=self.user)
self.card.save()
self.comment = Comment(card=self.card,
message='Test message.',
created_by=self.user)
self.comment.save()
# self.client.force_authenticate(self.user)
def test_api_can_create_a_new_comment(self):
response = self.client.post(
'/api/v1/boards/{board_pk}/cards/{card_pk}/comments/'.format(
board_pk=self.board.pk, card_pk=self.card.pk),
{
"message": "Test Message 2.",
"created_by": self.user.pk,
},
format='json' # Explicit format: otherwise list is sent as str()
)
self.assertEqual(response.status_code, status.HTTP_201_CREATED)
self.assertEqual(response.data['id'], self.comment.pk + 1)
def test_api_can_update_a_comment(self):
response = self.client.put(
'/api/v1/boards/{board_pk}/cards/{card_pk}/comments/{comment_pk}/'.
format(board_pk=self.board.pk,
card_pk=self.card.pk,
comment_pk=self.comment.pk), {
"message": "Test Message 2 edited.",
"updated_at": "2017-12-17 06:26:53",
"updated_by": self.user.pk
})
self.assertEqual(response.status_code, status.HTTP_200_OK)
self.assertEqual(response.data['message'], 'Test Message 2 edited.')
self.assertEqual(response.data['updated_at'], "2017-12-17T06:26:53Z")
self.assertEqual(response.data['updated_by'], self.user.pk)
def test_api_can_delete_a_comment(self):
old_count = Comment.objects.count()
response = self.client.delete(
'/api/v1/boards/{board_pk}/cards/{card_pk}/comments/{comment_pk}/'.
format(board_pk=self.board.pk,
card_pk=self.card.pk,
comment_pk=self.comment.pk), )
new_count = Comment.objects.count()
self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT)
self.assertNotEqual(old_count, new_count)
class CardAPIViewSet(TestCase):
"""Test suite for the Card API views."""
def setUp(self):
self.client = APIClient()
self.user = setup_user()
self.user.save()
self.board = Board(title='Test Board', created_by=self.user)
self.board.save()
self.column = Column(board=self.board, title='Backlog', position=1)
self.column.save()
self.label = Label(board=self.board,
title='Red Label',
color='#FF0000')
self.label.save()
self.label2 = Label(board=self.board,
title='Green Label',
color='#00FF00')
self.label2.save()
self.card = Card(board=self.board,
title='Test Card',
description='Test Card description',
created_by=self.user)
self.card.save()
# self.client.force_authenticate(self.user)
def test_api_can_create_a_new_card(self):
response = self.client.post(
'/api/v1/boards/{board_pk}/cards/'.format(board_pk=self.board.pk),
{
"column": None,
"title": "Test Card",
"description": "Test Card description.",
"created_by": self.user.pk,
"labels": [self.label.pk, self.label2.pk]
},
format='json' # Explicit format: otherwise list is sent as str()
)
self.assertEqual(response.status_code, status.HTTP_201_CREATED)
self.assertEqual(response.data['id'], self.card.pk + 1)
def test_api_can_update_a_card(self):
response = self.client.put(
'/api/v1/boards/{board_pk}/cards/{card_pk}/'.format(
board_pk=self.board.pk, card_pk=self.card.pk), {
"title": "Edited Test Card",
"description": "Test Card description updated.",
})
print(response.data)
self.assertEqual(response.status_code, status.HTTP_200_OK)
self.assertEqual(response.data['title'], 'Edited Test Card')
self.assertEqual(response.data['description'],
'Test Card description updated.')
def test_api_can_delete_a_card(self):
old_count = Card.objects.count()
response = self.client.delete(
'/api/v1/boards/{board_pk}/cards/{card_pk}/'.format(
board_pk=self.board.pk, card_pk=self.card.pk), )
new_count = Card.objects.count()
self.assertEqual(response.status_code, status.HTTP_204_NO_CONTENT)
self.assertNotEqual(old_count, new_count)
try:
board.grp = float(grp)
except:
print 'no grp'
try:
board.ots = float(ots)
except:
print 'no ots'
try:
board.cpt = float(cpt)
except:
print 'no cpt'
board.light = light
board.tax = unicode(tax)
board.montage_price = montage_price
board.save()
try:
dirty_img = soup('img')[0]['alt']
d2_img = re.search(";'><img src='(.*)' width='",dirty_img).group(1)
except:
print 'no img'
else:
img_url = BB_SITE_URL + d2_img
img_name = urlparse(img_url).path.split('/')[-1]
img_temp = NamedTemporaryFile()
try:
img_temp.write(urlopen(img_url).read())
except Exception as e:
def create(self, validated_data):
board = Board(owner_id=validated_data['user'],
name=validated_data['name'])
board.save()
