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
|
from django.db import models
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, unique=True)
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.title
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'
|
