diff options
Diffstat (limited to 'website')
| -rw-r--r-- | website/models.py | 31 | ||||
| -rw-r--r-- | website/views.py | 18 |
2 files changed, 47 insertions, 2 deletions
diff --git a/website/models.py b/website/models.py index 7afce12..8237839 100644 --- a/website/models.py +++ b/website/models.py @@ -72,6 +72,20 @@ Models from fossee_new Database created using inspectdb Use it with the "fossee_in" database eg:using("fossee_in") These models are used only for django orm reference. """ +CATEGORY = (("fluid mechanics", "Fluid Mechanics"), + ("control systems", "Control Theory & Control Systems"), + ("chemical engineering", "Chemical Engineering"), + ("thermodynamics", "Thermodynamics"), + ("mechanical engineering", "Mechanical Engineering"), + ("signal processing", "Signal Processing"), + ("digital communications", "Digital Communications"), + ("electrical technology", "Electrical Technology"), + ("maths & science", "Mathematics & Pure Science"), + ("analog electronics", "Analog Electronics"), + ("digital electronics", "Digital Electronics"), + ("computer programming", "Computer Programming"), + ("others", "Others")) + class FOSSEEStats(models.Model): w_id = models.IntegerField(unique=True, primary_key=True) foss_name = models.CharField(max_length=500) @@ -93,3 +107,20 @@ class FOSSEEStats(models.Model): class Meta: db_table = 'workshop' +class TBCPYTHONBook(models.Model): + title = models.CharField(max_length=500) + author = models.CharField(max_length=300) + category = models.CharField(max_length=32, choices=CATEGORY) + publisher_place = models.CharField(max_length=150) + isbn = models.CharField(max_length=50) + edition = models.CharField(max_length=15) + year_of_pub = models.CharField(max_length=4) + no_chapters = models.IntegerField(default=0, blank=True) + contributor = models.IntegerField(default=0, blank=True) + reviewer = models.IntegerField(default=0, blank=True) + approved = models.BooleanField(default=False) + start_time = models.DateField(null=True, default=None) + end_time = models.DateField(null=True, default=None) + class Meta: + db_table = 'tbc_book' + diff --git a/website/views.py b/website/views.py index c0a61e1..769890b 100644 --- a/website/views.py +++ b/website/views.py @@ -1,6 +1,6 @@ from django.http import HttpResponse from django.shortcuts import render, render_to_response, get_object_or_404 -from website.models import FOSSEEStats +from website.models import FOSSEEStats, TBCPYTHONBook from website.models import Nav, Page, Block @@ -44,6 +44,20 @@ def dispatcher(request, permalink=''): 'obj' : rows, } + if permalink == 'textbook-companions-for-academics': + blocks = get_blocks() + python_wokshop_page_content = Page.objects.get(permalink='textbook-companions-for-academics-page') + completed_books = TBCPYTHONBook.objects.using('tbcpython').values('id', 'title', 'author').filter(approved=True).order_by('id') + + context = { + 'page' : python_wokshop_page_content, + 'navs': blocks['navs'], + 'sidebar': blocks['sidebar'], + 'footer': blocks['footer'], + 'permalink': permalink, + 'obj' : completed_books, + } + if permalink == '' or permalink == 'home' : permalink = 'home' page = get_object_or_404(Page, permalink=permalink) @@ -56,7 +70,7 @@ def dispatcher(request, permalink=''): 'permalink': permalink } - if permalink != 'home' and permalink != 'python-workshops': + if permalink != 'home' and permalink != 'python-workshops' and permalink != 'textbook-companions-for-academics': page = get_object_or_404(Page, permalink=permalink) blocks = get_blocks() context = { |