Hi,
I have two models (Patients and PatientAddress). I want to create a new
patient using POST method and data should be inserted in Patient and
PatientAddress tables. But the data is inserted only into Patients table
and not in PatientAddress table.
When I POST a new patient with Address then automatically it should create
a new record in PatientAddress table with patnt_refno referencing to the
Patient table. *Could someone please assist to proceed further.*
Below is my code.
*POST Input:*
{
"Address": [
{
"line": "3A insert Second Street",
"city": "insert city",
"country": "India"
}
],
"patnt_id": "P14",
"surname": "Smith",
"forename": "James",
"gender": "M",
"active": 1
}
*models.py*
class Patients(models.Model):
patnt_refno = models.AutoField(primary_key=True)
patnt_id = models.CharField(unique=True, max_length=10, blank=True,
null=True)
surname = models.CharField(max_length=30, blank=True, null=True)
forename = models.CharField(max_length=50, blank=True, null=True)
gender = models.CharField(max_length=1, blank=True, null=True)
dttm_of_birth = models.DateTimeField(blank=True, null=True)
dttm_of_death = models.DateTimeField(blank=True, null=True)
marital_status = models.CharField(max_length=50, blank=True, null=True)
active = models.IntegerField()
def __str__(self):
return self.patnt_id
class Meta:
managed = False
db_table = 'patients'
class PatientAddress(models.Model):
addss_refno = models.AutoField(primary_key=True)
patnt_refno = models.ForeignKey('Patients', db_column='patnt_refno',
related_name='Address')
line = models.CharField(max_length=30, blank=True, null=True)
city = models.CharField(max_length=50, blank=True, null=True)
state = models.CharField(max_length=50, blank=True, null=True)
country = models.CharField(max_length=50, blank=True, null=True)
postcode = models.CharField(max_length=50, blank=True, null=True)
active = models.IntegerField(blank=True, null=True)
class Meta:
managed = False
db_table = 'patientaddress'
*serializers.py*
class PatientAddressSerializer(serializers.ModelSerializer):
class Meta:
model = PatientAddress
fields = ('line','city','country')
class PatientsSerializer(serializers.ModelSerializer):
Address = PatientAddressSerializer(read_only=True,many=True)
class Meta:
model = Patients
fields =
('Address','patnt_refno','patnt_id','surname','forename','gender','active')
*views.py*
class PatientsList(APIView):
def get(self, request):
patients =
Patients.objects.filter(gender='M',active=1).order_by('dttm_of_birth').reverse()
serializer = PatientsSerializer(patients, many=True)
return Response(serializer.data)
def post(self, request):
serializer = PatientsSerializer(data=request.data)
if serializer.is_valid():
serializer.save()
return Response(serializer.data, status=status.HTTP_201_CREATED)
return Response(serializer.errors,
status=status.HTTP_400_BAD_REQUEST)
*urls.py*
urlpatterns = [
url(r'^admin/', admin.site.urls),
url(r'^patients/$', views.PatientsList.as_view()),
]
Thanks in advance,
Thiagu Palaniappan
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/7a69934b-f4c7-4c85-9107-25062187a1a2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
