Guest User

Untitled

a guest
Mar 18th, 2018
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.51 KB | None | 0 0
  1. class Model1(models.Model):
  2.  
  3. date = models.DateTimeField(db_column='Date', primary_key=True, default='', max_length=40)
  4. data1 = models.CharField(max_length=40, default='NoData', blank=True, null=True, db_column='data1',)
  5. data2 = models.CharField(max_length=40, default='NoData', blank=True, null=True, db_column='data2',)
  6. class Meta:
  7. managed = True
  8. db_table = 'table1'
  9. def __str__(self):
  10. return '%s %s %s' % (str(self.date), self.data1, self.data2,)
  11.  
  12. class Model2(models.Model):
  13.  
  14. date = models.DateTimeField(db_column='Date', primary_key=True, default='', max_length=40)
  15. data1 = models.CharField(max_length=40, default='NoData', blank=True, null=True, db_column='data1',)
  16. data2 = models.CharField(max_length=40, default='NoData', blank=True, null=True, db_column='data2',)
  17. class Meta:
  18. managed = True
  19. db_table = 'table2'
  20. def __str__(self):
  21. return '%s %s %s' % (str(self.date), self.data1, self.data2,)
  22.  
  23. class Model3(models.Model):
  24.  
  25. date = models.DateTimeField(db_column='Date', primary_key=True, default='', max_length=40)
  26. data1 = models.CharField(max_length=40, default='NoData', blank=True, null=True, db_column='data1',)
  27. data2 = models.CharField(max_length=40, default='NoData', blank=True, null=True, db_column='data2',)
  28. class Meta:
  29. managed = True
  30. db_table = 'table3'
  31. def __str__(self):
  32. return '%s %s %s' % (str(self.date), self.data1, self.data2,)
  33.  
  34. from app.models import Model1, Model2, Model3
  35. from django.shortcuts import render
  36.  
  37. def Appview(request):
  38. template_name = 'app/app.html'
  39.  
  40. Model1 = Model1.objects.all()
  41. Model2 = Model2.objects.all()
  42. Model3 = Model3.objects.all()
  43. return render(request, template_name, {'Model1': Model1})
  44.  
  45. <div class="table-responsive container">
  46. <table id = "table" class = "table table-sm table-hover" width="100%">
  47. <thead>
  48. <tr>
  49. <th>Date</th>
  50. <th>Data1</th>
  51. <th>Data2</th>
  52. </tr>
  53. </thead>
  54.  
  55. <tbody>
  56. {% for data in Model1 %}
  57. <tr>
  58. <td>{{ data.date }}</td>
  59. <td>{{ data.data1 }}</td>
  60. <td>{{ data.data2 }}</td>
  61. </tr>
  62. {% endfor %}
  63. </tbody>
  64. </table>
Add Comment
Please, Sign In to add comment