Advertisement
Guest User

Untitled

a guest
Mar 20th, 2019
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.87 KB | None | 0 0
  1. CREATE TABLE `test_suite` (
  2. `team_name` varchar(30) NOT NULL,
  3. `suite_name` varchar(100) NOT NULL,
  4. `description` varchar(200) DEFAULT NULL,
  5. `schedule` varchar(100) DEFAULT NULL,
  6. `email_list_ok` varchar(200) DEFAULT NULL,
  7. `email_list_fail` varchar(200) DEFAULT NULL,
  8. `template_name` varchar(100) NOT NULL,
  9. PRIMARY KEY (`team_name`,`suite_name`),
  10. KEY `fk_test_suite__email_templates` (`template_name`),
  11. CONSTRAINT `fk_test_suite__email_templates` FOREIGN KEY (`template_name`) REFERENCES `email_templates` (`template_name`),
  12. CONSTRAINT `fk_test_suite__team` FOREIGN KEY (`team_name`) REFERENCES `team` (`team_name`)
  13. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  14.  
  15. class Team(models.Model):
  16. team_name = models.CharField(primary_key=True, max_length=30)
  17. description = models.CharField(max_length=100, blank=True, null=True)
  18.  
  19. class Meta:
  20. managed = False
  21. db_table = 'team'
  22.  
  23. class TestSuite(models.Model):
  24. team_name = models.ForeignKey(Team, on_delete=models.DO_NOTHING, db_column='team_name')
  25. suite_name = models.CharField(max_length=100)
  26. description = models.CharField(max_length=200, blank=True, null=True)
  27. schedule = models.CharField(max_length=100, blank=True, null=True)
  28. email_list_ok = models.CharField(max_length=200, blank=True, null=True)
  29. email_list_fail = models.CharField(max_length=200, blank=True, null=True)
  30. template_name = models.ForeignKey(EmailTemplates, on_delete=models.DO_NOTHING, db_column='template_name')
  31.  
  32. class Meta:
  33. managed = False
  34. db_table = 'test_suite'
  35. unique_together = (('team_name', 'suite_name'),)
  36.  
  37. class TestSuiteViewSet(viewsets.ModelViewSet):
  38. queryset = models.TestSuite.objects.values('team_name','suite_name', 'description','schedule','email_list_ok','email_list_fail','template_name')
  39. serializer_class = serializers.TestSuiteSerializer
  40.  
  41. class TeamViewSet(viewsets.ModelViewSet):
  42. queryset = models.Team.objects.all()
  43. serializer_class = serializers.TeamSerializer
  44.  
  45. class TestSuiteSerializer(serializers.ModelSerializer):
  46. class Meta:
  47. model = models.TestSuite
  48. fields = ['team_name','suite_name', 'description','schedule','email_list_ok','email_list_fail','template_name']
  49.  
  50. File "/usr/local/lib/python3.6/dist-packages/django/core/handlers/exception.py" in inner
  51. 35. response = get_response(request)
  52.  
  53. File "/usr/local/lib/python3.6/dist-packages/django/core/handlers/base.py" in _get_response
  54. 128. response = self.process_exception_by_middleware(e, request)
  55.  
  56. File "/usr/local/lib/python3.6/dist-packages/django/core/handlers/base.py" in _get_response
  57. 126. response = wrapped_callback(request, *callback_args, **callback_kwargs)
  58.  
  59. File "/usr/lib/python3.6/contextlib.py" in inner
  60. 52. return func(*args, **kwds)
  61.  
  62. File "/usr/local/lib/python3.6/dist-packages/django/views/decorators/csrf.py" in wrapped_view
  63. 54. return view_func(*args, **kwargs)
  64.  
  65. File "/usr/local/lib/python3.6/dist-packages/rest_framework/viewsets.py" in view
  66. 116. return self.dispatch(request, *args, **kwargs)
  67.  
  68. File "/usr/local/lib/python3.6/dist-packages/rest_framework/views.py" in dispatch
  69. 495. response = self.handle_exception(exc)
  70.  
  71. File "/usr/local/lib/python3.6/dist-packages/rest_framework/views.py" in handle_exception
  72. 455. self.raise_uncaught_exception(exc)
  73.  
  74. File "/usr/local/lib/python3.6/dist-packages/rest_framework/views.py" in dispatch
  75. 492. response = handler(request, *args, **kwargs)
  76.  
  77. File "/usr/local/lib/python3.6/dist-packages/rest_framework/mixins.py" in list
  78. 48. return Response(serializer.data)
  79.  
  80. File "/usr/local/lib/python3.6/dist-packages/rest_framework/serializers.py" in data
  81. 768. ret = super(ListSerializer, self).data
  82.  
  83. File "/usr/local/lib/python3.6/dist-packages/rest_framework/serializers.py" in data
  84. 262. self._data = self.to_representation(self.instance)
  85.  
  86. File "/usr/local/lib/python3.6/dist-packages/rest_framework/serializers.py" in to_representation
  87. 686. self.child.to_representation(item) for item in iterable
  88.  
  89. File "/usr/local/lib/python3.6/dist-packages/rest_framework/serializers.py" in <listcomp>
  90. 686. self.child.to_representation(item) for item in iterable
  91.  
  92. File "/usr/local/lib/python3.6/dist-packages/rest_framework/serializers.py" in to_representation
  93. 530. ret[field.field_name] = field.to_representation(attribute)
  94.  
  95. File "/usr/local/lib/python3.6/dist-packages/rest_framework/relations.py" in to_representation
  96. 272. return value.pk
  97.  
  98. Exception Type: AttributeError at /dqf_api/test_suites/
  99. Exception Value: 'str' object has no attribute 'pk'
  100.  
  101. router = routers.DefaultRouter()
  102. router.register(r'teams', views.TeamViewSet)
  103. router.register(r'test_suites', views.TestSuiteViewSet)
  104. urlpatterns = [ url(r'^dqf_api/', include(router.urls))]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement