1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
|
from django.db import models
from datetime import date
class Nav(models.Model):
"""Main navigation links"""
nav_name = models.CharField(max_length=200)
link = models.CharField(max_length=200)
position = models.IntegerField()
visible = models.BooleanField()
def __str__(self):
return self.nav_name
class SubNav(models.Model):
"""Navigation links for pages"""
nav = models.ForeignKey(Nav, on_delete=models.CASCADE)
subnav_name = models.CharField(max_length=200)
link = models.CharField(max_length=200)
position = models.IntegerField()
visible = models.BooleanField()
def __str__(self):
return self.subnav_name
class Page(models.Model):
"""Page that will be dispatched"""
permalink = models.CharField(max_length=200)
heading = models.CharField(max_length=500)
content = models.TextField()
visible = models.BooleanField()
pub_date = models.DateTimeField('date published', auto_now_add=True)
def __str__(self):
return self.heading
class Block(models.Model):
block_name = models.CharField(max_length=200)
visible = models.BooleanField()
def __str__(self):
return self.block_name
class LinkBox(models.Model):
block = models.ForeignKey(Block, on_delete=models.CASCADE)
linkbox_name = models.CharField(max_length=200)
position = models.IntegerField()
visible = models.BooleanField()
def __str__(self):
return self.linkbox_name
class Link(models.Model):
linkbox = models.ForeignKey(LinkBox, on_delete=models.CASCADE)
link_name = models.CharField(max_length=200)
link = models.CharField(max_length=200)
position = models.IntegerField()
visible = models.BooleanField()
def __str__(self):
return self.link_name
class Banner(models.Model):
title = models.CharField(max_length=500)
banner = models.TextField(max_length=1000)
position = models.IntegerField()
visible = models.BooleanField()
def __str__(self):
return self.banner
class TextBox(models.Model):
block = models.ForeignKey(Block, on_delete=models.CASCADE)
textbox_name = models.CharField(max_length=200)
content = models.TextField()
position = models.IntegerField()
visible = models.BooleanField()
def __str__(self):
return self.textbox_name
"""
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)
type = models.CharField(max_length=50)
w_name = models.CharField(max_length=500)
body = models.TextField()
no_of_participant = models.IntegerField()
event_link = models.TextField()
startdate = models.DateField()
starttime = models.TimeField()
enddate = models.DateField()
endtime = models.TimeField()
venue = models.CharField(max_length=500)
street = models.CharField(max_length=500)
country = models.CharField(max_length=100)
state = models.CharField(max_length=100)
city = models.CharField(max_length=100)
pincode = models.IntegerField(default=0)
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'
|
