added list of completed books fetched from external db

1 files changed, 31 insertions, 0 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'
+