def load_schools(filePath):
file = open(filePath, 'r')
a = []
for i in file:
a.append(i.strip('\n'))
b = []
for i in a:
b.append(i.split(','))
b.pop(0)
for i in b:
# r = School.objects.filter(centre_code=i[0])
# if not r:
sch = School()
sch.centre_code = i[0]
sch.centre_name = i[1]
sch.level = i[2]
sch.program_hours = i[3]
sch.language = i[4]
if i[5] == 'na':
sch.vacancy = False
else:
sch.vacancy = True
try:
sch.registration_fee = float(i[6])
sch.fee = float(i[7])
except Exception as e:
sch.registration_fee = float(0)
sch.fee = float(0)
sch.save()
else:
pass
def test_create_school(self):
school = School(name="The great School of Test",
short_name="test school",
description="<p>Some rich text description?</p>")
school.save()
self.assertEqual('the-great-school-of-test', school.slug)
self.assertEqual(School.objects.get(slug='the-great-school-of-test'),
school)
def test_create_school(self):
school = School(
name = "The great School of Test",
short_name = "test school",
description = "<p>Some rich text description?</p>"
)
school.save()
self.assertEqual('the-great-school-of-test', school.slug)
self.assertEqual(
School.objects.get(slug='the-great-school-of-test'),
school
)
def cb(count,ds):
school = None
try:
school = School.objects.get(gsid=ds["universal-id"])
except:
school = School()
# print "called for num:" + str(count) + "val: " + str(ds)
school.name = ds["name"]
school.gsid = ds["universal-id"]
school.city = ds["city"]
if len(ds["zip"]) > 6:
ds["zip"] = ds["zip"][:6]
school.zip = ds["zip"]
school.state = ds["state"]
school.lat = ds["lat"]
school.lon = ds["lon"]
school.gsurl = ds["url"]
if len(ds["street"]) > 50:
ds["street"] = ds["street"][:49]
school.street = ds["street"]
if len(ds["level"]) > 20:
ds["level"] = ds["level"][:19]
school.level = ds["level"]
if len(ds["phone"]) > 20:
ds["phone"] = ds["phone"][:19]
school.phone = ds["phone"]
if len(ds["subtype"]) > 50:
ds["subtype"] = 'special'
school.type = ds["subtype"]
if len(ds["district-name"]) > 50:
ds["district-name"] = ds["district-name"][:49]
school.district_name = ds["district-name"]
# try:
print school.gsurl
school.save()
def transfer(request):
for each in school_list.school_choices:
name = each[0]
list_ = name.split('г.')
v_name = list_[0]
v_name = v_name.strip()
if len(list_) >1:
city = list_[1]
city = city.strip()
else:
city = "Город N"
country = 'Россия'
school = School(name=v_name, country=country, city = city)
school.save()
return HttpResponse('vasa')
def add(request):
if request.method == "POST":
form = request.POST
# print(form) # for testing
school = School()
school.name = form['name']
school.code = form['code']
school.address = form['address']
school.no_of_students = form['no_of_students']
school.save()
return redirect('schools:school_detail', school.pk)
context = {}
return render(request, 'schools/add.html', context)
def cb(count, ds):
school = None
try:
school = School.objects.get(gsid=ds["universal-id"])
except:
school = School()
# print "called for num:" + str(count) + "val: " + str(ds)
school.name = ds["name"]
school.gsid = ds["universal-id"]
school.city = ds["city"]
if len(ds["zip"]) > 6:
ds["zip"] = ds["zip"][:6]
school.zip = ds["zip"]
school.state = ds["state"]
school.lat = ds["lat"]
school.lon = ds["lon"]
school.gsurl = ds["url"]
if len(ds["street"]) > 50:
ds["street"] = ds["street"][:49]
school.street = ds["street"]
if len(ds["level"]) > 20:
ds["level"] = ds["level"][:19]
school.level = ds["level"]
if len(ds["phone"]) > 20:
ds["phone"] = ds["phone"][:19]
school.phone = ds["phone"]
if len(ds["subtype"]) > 50:
ds["subtype"] = 'special'
school.type = ds["subtype"]
if len(ds["district-name"]) > 50:
ds["district-name"] = ds["district-name"][:49]
school.district_name = ds["district-name"]
# try:
print school.gsurl
school.save()
def handle(self, *args, **options):
filename, self.image_location = args
file = open(filename, 'r')
self.data = csv.DictReader(file)
dev_user = User.objects.get(email='*****@*****.**')
for d in self.data:
# ,Unnamed: 0_x,S No_x,Date,Block,Cluster,School Name_spotways,
# KLP ID,Address,PIN Code,PlayGround?,Fence?,Landmark #1,
# Landmark #2,Route to School,Bus Details,
# LAT_spotways,LONG_spotways,Unnamed: 0_y,S No_y,klp_district,
# klp_block,klp_cluster,dise_code,School Name_ems,category,
# management,LAT_ems,LONG_ems,institution_gender,hierarchy,moi
klpid = d['KLP ID']
address = d['Address']
landmark = d['Landmark #1']
bus = d['Bus Details']
pincode = d['PIN Code']
lat = d['LAT_spotways']
lon = d['LONG_spotways']
coordinates = 'POINT ('+lon+' '+lat+')'
connection, cursor = self.connectKlpCoord()
if klpid.startswith('5'):
continue
print '='*20
try:
school = School.objects.get(id=klpid)
except School.DoesNotExist:
# School doesn't exist
print 'Creating new school with id: %s' % klpid
print d
school = School(
id=klpid,
name=d.get('School Name_ems'),
cat=d.get('category'),
sex=d.get('institution_gender', 'co-ed'),
moi=d.get('moi', 'kannada') or 'kannada',
mgmt=d.get('management', 'ed'),
status=2
)
school.admin3 = self.get_or_create_admin3(d)
if address:
if school.address and (not school.address == address):
school_address = school.address
school_address.address = address
else:
print 'Creating new address for klpid: %s' % klpid
school_address = Address.objects.create(
address=address
)
school.address = school_address
# Update address details.
if landmark:
school_address.landmark = landmark
if bus:
school_address.bus = bus
if pincode:
school_address.pincode = pincode
school_address.save()
school.save()
# Story
story = {
'date': d['Date'],
'user': dev_user,
'email': '*****@*****.**',
'name': 'Team KLP',
'school': school
}
self.createStory(story, klpid, d)
if lat.strip() and lon.strip():
self.updateCoord(cursor, klpid, coordinates)
cursor.close()
connection.commit()
connection.close()
def handle(self, *args, **options):
filename, self.image_location = args
file = open(filename, 'r')
self.data = csv.DictReader(file)
dev_user = User.objects.get(email='*****@*****.**')
for d in self.data:
# ,Unnamed: 0_x,S No_x,Date,Block,Cluster,School Name_spotways,
# KLP ID,Address,PIN Code,PlayGround?,Fence?,Landmark #1,
# Landmark #2,Route to School,Bus Details,
# LAT_spotways,LONG_spotways,Unnamed: 0_y,S No_y,klp_district,
# klp_block,klp_cluster,dise_code,School Name_ems,category,
# management,LAT_ems,LONG_ems,institution_gender,hierarchy,moi
klpid = d['KLP ID']
address = d['Address']
landmark = d['Landmark #1']
bus = d['Bus Details']
pincode = d['PIN Code']
lat = d['LAT_spotways']
lon = d['LONG_spotways']
coordinates = 'POINT (' + lon + ' ' + lat + ')'
connection, cursor = self.connectKlpCoord()
if klpid.startswith('5'):
continue
print '=' * 20
try:
school = School.objects.get(id=klpid)
except School.DoesNotExist:
# School doesn't exist
print 'Creating new school with id: %s' % klpid
print d
school = School(id=klpid,
name=d.get('School Name_ems'),
cat=d.get('category'),
sex=d.get('institution_gender', 'co-ed'),
moi=d.get('moi', 'kannada') or 'kannada',
mgmt=d.get('management', 'ed'),
status=2)
school.admin3 = self.get_or_create_admin3(d)
if address:
if school.address and (not school.address == address):
school_address = school.address
school_address.address = address
else:
print 'Creating new address for klpid: %s' % klpid
school_address = Address.objects.create(address=address)
school.address = school_address
# Update address details.
if landmark:
school_address.landmark = landmark
if bus:
school_address.bus = bus
if pincode:
school_address.pincode = pincode
school_address.save()
school.save()
# Story
story = {
'date': d['Date'],
'user': dev_user,
'email': '*****@*****.**',
'name': 'Team KLP',
'school': school
}
self.createStory(story, klpid, d)
if lat.strip() and lon.strip():
self.updateCoord(cursor, klpid, coordinates)
cursor.close()
connection.commit()
connection.close()
def process_row(self, row, year):
try:
school = School.objects.get(code=int(row[self.INDEXES['School_Code']]))
except Exception as e:
school = School(
code=int(row[self.INDEXES['School_Code']]),
name="School@%s" % int(row[self.INDEXES['School_Code']])
)
school.save()
print "created", str(school)
yearly_data, created = YearlyData.objects.get_or_create(
school=school,
academic_year=year
)
yearly_data.area_type = row[self.INDEXES['Rural_Urban']]
try:
medium = InstractionMedium.objects.get(id=int(row[self.INDEXES['Medium_of_Instruction']]))
yearly_data.mediums.add(medium)
except:
pass
yearly_data.distance_from_brc = row[self.INDEXES['Distance_BRC']]
yearly_data.distance_from_crc = row[self.INDEXES['Distance_CRC']]
school.year_established = row[self.INDEXES['Yeur_Estd']]
school.save()
yearly_data.pre_primary_available = row[self.INDEXES['Pre_Pry_YN']]
yearly_data.pre_primary_student_count = row[self.INDEXES['Pre_Pry_Students']]
yearly_data.pre_primary_teacher_count = row[self.INDEXES['Pre_Pry_Teachers']]
yearly_data.residential = row[self.INDEXES['Residential_Sch_YN']]
try:
res_type = ResidentialType.objects.get(id=int(row[self.INDEXES['Residential_Sch_Type']]))
except:
print 'Unknown ResidentialType found', school.id, row[self.INDEXES['Residential_Sch_Type']]
res_type = ResidentialType(
id=int(row[self.INDEXES['Residential_Sch_Type']]),
name="Unknown"
)
res_type.save()
yearly_data.residential_type = res_type
try:
mgmt = SchoolManaagement.objects.get(id=int(row[self.INDEXES['Sch_Management']]))
except:
print 'Unknown Management found', school.id, row[self.INDEXES['Sch_Management']]
mgmt = SchoolManaagement(
id=int(row[self.INDEXES['Sch_Management']]),
name="Unknown"
)
mgmt.save()
yearly_data.management = mgmt
yearly_data.lowest_class = int(row[self.INDEXES['Lowest_Class']])
yearly_data.highest_class = int(row[self.INDEXES['Highest_Class']])
try:
category = SchoolCategory.objects.get(id=int(row[self.INDEXES['Sch_Category']]))
except:
print 'Unknown Category found', school.id, row[self.INDEXES['Sch_Category']]
category = SchoolCategory(
id=int(row[self.INDEXES['Sch_Category']]),
name="Unknown"
)
category.save()
yearly_data.category = category
yearly_data.type = row[self.INDEXES['School_Type']]
yearly_data.part_of_shift = row[self.INDEXES['Shift_School_YN']]
yearly_data.working_day_count = row[self.INDEXES['No_of_Working_Days']]
yearly_data.academic_inspection_count = row[self.INDEXES['No_of_Acad_Inspection']]
yearly_data.brc_visit_count = row[self.INDEXES['Visits_by_BRC']]
yearly_data.crc_visit_count = row[self.INDEXES['Visits_by_CRC']]
yearly_data.development_grant_received = float(row[self.INDEXES['School_Dev_Grant_Recd']])
yearly_data.development_grant_expenditure = float(row[self.INDEXES['School_Dev_Grant_Expnd']])
yearly_data.tlm_grant_received = float(row[self.INDEXES['TLM_Grant_Recd']])
yearly_data.tlm_grant_expenditure = float(row[self.INDEXES['TLM_Grant_Expnd']])
yearly_data.fund_from_student_received = float(row[self.INDEXES['Funds_from_students_Recd']])
yearly_data.fund_from_student_expenditure = float(row[self.INDEXES['Funds_from_students_Expnd']])
yearly_data.save()
def import_primary_schools():
period = datetime.datetime(day=31, month=12, year=2007)
filename = "%s/documentation/data/2007/primary.csv" % settings.BASE_DIR
n = 1
with open(filename, "rb") as ifile:
reader = csv.reader(ifile)
for row in reader:
if n > 1:
school = School()
school.name = row[0].strip()
school.level = School.PRIMARY
school.ownership = get_ownership(row[2].strip())
school.sponsor = get_sponsor(row[3].strip())
school.student_gender = get_student_gender(row[4].strip())
school.school_type = get_school_type(row[5].strip())
school.student_needs = get_student_needs(row[6].strip())
# location
if row[29]:
county, created = County.objects.get_or_create(name=row[29].strip().upper())
school.county = county
province, created = Province.objects.get_or_create(name=row[28].strip().upper())
school.province = province
if row[33]:
constituency = Constituency.objects.filter(name=row[33].strip().upper()).first()
if not constituency:
constituency, created = Constituency.objects.get_or_create(
name=row[33].strip().upper(), county=county)
school.constituency = constituency
if row[30]:
district = District.objects.filter(name=row[30].strip().upper()).first()
if not district:
district, created = District.objects.get_or_create(
name=row[30].strip().upper(), province=province)
school.district = district
if row[31]:
division, created = Division.objects.get_or_create(
name=row[31].strip().upper(), district=district)
school.division = division
if row[32]:
location, created = Location.objects.get_or_create(
name=row[32].strip().upper(), division=division)
school.location = location
if row[34]:
coord = row[34].split(",")
x = float(coord[0][1:])
y = float(coord[1][1:-2])
school.coordinates = Point(y, x)
school.save()
# facilities
facility1, created = Facility.objects.get_or_create(name="Toilets")
facility2, created = Facility.objects.get_or_create(name="Classrooms")
facility3, created = Facility.objects.get_or_create(name="Enrollment")
facility_record1, created = FacilityRecord.objects.get_or_create(facility=facility1, school=school, period=period, boys=row[11].strip(),
girls=row[12].strip(), total=row[13].strip())
facility_record3, created = FacilityRecord.objects.get_or_create(facility=facility3, school=school, period=period, boys=row[15].strip(),
girls=row[16].strip(), total=row[17].strip())
# staff
if row[18]:
staff1, created = Staff.objects.get_or_create(period=period, school=school, staff_type=Staff.TSC_MALE,
number=row[18].strip(), is_teacher=True)
if row[19]:
staff2, created = Staff.objects.get_or_create(period=period, school=school, staff_type=Staff.TSC_FEMALE,
number=row[19].strip(), is_teacher=True)
if row[20]:
staff3, created = Staff.objects.get_or_create(period=period, school=school, staff_type=Staff.LOCAL_MALE,
number=row[20].strip(), is_teacher=True)
if row[21]:
staff4, created = Staff.objects.get_or_create(period=period, school=school, staff_type=Staff.LOCAL_FEMALE,
number=row[21].strip(), is_teacher=True)
if row[22]:
staff5, created = Staff.objects.get_or_create(period=period, school=school, staff_type=Staff.PTA_MALE,
number=row[22].strip(), is_teacher=True)
if row[23]:
staff6, created = Staff.objects.get_or_create(period=period, school=school, staff_type=Staff.PTA_FEMALE,
number=row[23].strip(), is_teacher=True)
if row[24]:
staff7, created = Staff.objects.get_or_create(period=period, school=school, staff_type=Staff.OTHER_MALE,
number=row[24].strip(), is_teacher=True)
if row[25]:
staff8, created = Staff.objects.get_or_create(period=period, school=school, staff_type=Staff.OTHER_FEMALE,
number=row[25].strip(), is_teacher=True)
if row[26]:
staff9, created = Staff.objects.get_or_create(period=period, school=school, staff_type=Staff.NON_TEACHING_MALE,
number=row[26].strip(), is_teacher=False)
if row[27]:
staff10, created = Staff.objects.get_or_create(period=period, school=school, staff_type=Staff.NON_TEACHING_FEMALE,
number=row[27].strip(), is_teacher=False)
# facts
if row[7]:
fact2, created = Fact.objects.get_or_create(name="Pupil Teacher Ratio", period=period, school=school,
value=row[7].strip())
if row[8]:
fact1, created = Fact.objects.get_or_create(name="Pupil Classroom Ratio", period=period, school=school,
facility=facility2, value=row[8].strip())
if row[9]:
fact4, created = Fact.objects.get_or_create(name="Pupil Toilet Ratio", period=period, school=school,
facility=facility1, value=row[9].strip())
if row[10]:
fact5, created = Fact.objects.get_or_create(name="Total Number of Classrooms", period=period, school=school,
facility=facility2, value=row[10].strip())
if row[14]:
fact5, created = Fact.objects.get_or_create(name="Teachers Toilets", period=period, school=school,
facility=facility1, value=row[14].strip())
n += 1
def import_secondary_schools():
period = datetime.datetime(day=31, month=12, year=2007)
filename = "%s/documentation/data/2007/secondary.csv" % settings.BASE_DIR
n = 1
with open(filename, "rb") as ifile:
reader = csv.reader(ifile)
for row in reader:
if n > 1:
school = School()
school.code = row[0].strip()
school.name = row[1].strip()
school.address = row[2].strip()
school.level = School.SECONDARY
school.ownership = get_ownership(row[3].strip())
school.sponsor = get_sponsor(row[4].strip())
school.student_gender = get_student_gender(row[5].strip())
school.school_type = get_school_type(row[6].strip())
school.student_needs = get_student_needs(row[6].strip())
# location
province, created = Province.objects.get_or_create(name=row[23].strip().upper())
school.province = province
county, created = County.objects.get_or_create(name=row[24].strip().upper())
school.county = county
if row[30]:
constituency = Constituency.objects.filter(name=row[30].strip().upper()).first()
if not constituency:
constituency, created = Constituency.objects.get_or_create(name=row[30].strip().upper(), county=county)
school.constituency = constituency
if row[25]:
district = District.objects.filter(name=row[25].strip().upper()).first()
if not district:
district, created = District.objects.get_or_create(name=row[25].strip().upper(), province=province)
school.district = district
if row[26]:
division, created = Division.objects.get_or_create(name=row[26].strip().upper(), district=district)
school.division = division
if row[27]:
location, created = Location.objects.get_or_create(name=row[27].strip().upper(), division=division)
school.location = location
if row[28]:
sub_location, created = SubLocation.objects.get_or_create(name=row[28].strip().upper(), location=location)
school.sub_location = sub_location
if row[29]:
school_zone, created = SchoolZone.objects.get_or_create(name=row[29].strip().upper(), county=county)
school.school_zone = school_zone
if row[31]:
coord = row[31].split(",")
x = float(coord[0][1:])
y = float(coord[1][1:-2])
school.coordinates = Point(y, x)
school.save()
# staff
if row[12]:
staff1, created = Staff.objects.get_or_create(period=period, school=school, staff_type=Staff.TSC_MALE,
number=row[12].strip(), is_teacher=True)
if row[13]:
staff2, created = Staff.objects.get_or_create(period=period, school=school, staff_type=Staff.TSC_FEMALE,
number=row[13].strip(), is_teacher=True)
if row[14]:
staff3, created = Staff.objects.get_or_create(period=period, school=school, staff_type=Staff.LOCAL_MALE,
number=row[14].strip(), is_teacher=True)
if row[15]:
staff4, created = Staff.objects.get_or_create(period=period, school=school, staff_type=Staff.LOCAL_FEMALE,
number=row[15].strip(), is_teacher=True)
if row[16]:
staff5, created = Staff.objects.get_or_create(period=period, school=school, staff_type=Staff.PTA_MALE,
number=row[16].strip(), is_teacher=True)
if row[17]:
staff6, created = Staff.objects.get_or_create(period=period, school=school, staff_type=Staff.PTA_FEMALE,
number=row[17].strip(), is_teacher=True)
if row[18]:
staff7, created = Staff.objects.get_or_create(period=period, school=school, staff_type=Staff.OTHER_MALE,
number=row[18].strip(), is_teacher=True)
if row[19]:
staff8, created = Staff.objects.get_or_create(period=period, school=school, staff_type=Staff.OTHER_FEMALE,
number=row[19].strip(), is_teacher=True)
if row[20]:
staff9, created = Staff.objects.get_or_create(period=period, school=school, staff_type=Staff.NON_TEACHING_MALE,
number=row[20].strip(), is_teacher=False)
if row[21]:
staff10, created = Staff.objects.get_or_create(period=period, school=school, staff_type=Staff.NON_TEACHING_FEMALE,
number=row[21].strip(), is_teacher=False)
# facts
if row[8]:
fact1, created = Fact.objects.get_or_create(name="Total Enrolment", period=period, school=school,
value=row[8].strip())
if row[9]:
fact2, created = Fact.objects.get_or_create(name="Pupil Teacher Ratio", period=period, school=school,
value=row[9].strip())
if row[10]:
fact3, created = Fact.objects.get_or_create(name="Total Teaching staff", period=period, school=school,
value=row[10].strip())
if row[11]:
fact4, created = Fact.objects.get_or_create(name="Acreage per enrolment", period=period, school=school,
value=row[11].strip())
if row[22]:
fact5, created = Fact.objects.get_or_create(name="Acreage", period=period, school=school,
value=row[22].strip())
n += 1
# Create your views here.
def post_list_view(request):
post_objects = Posts.objects.all()
context = {
'post_objects': post_objects
}
return render(request, "posts/index.html", context) #posts/index.html should be under appname/templates/appname/index.html
#==================
python3 manage.py shell
from schools.models import School
School.objects.all()
school = School(name='Upperhill',code='2003',address='Nyeri',no_of_students=10)
school.save()
School.objects.all()
#models example under manage.py
#important codes
sudo apt install python3-pip
sudo apt-get install mysql-client
pip install mysqlclient
source env/bin/activate
python3 manage.py runserver
python3 manage.py startapp transactions
python(3) -m venv env
pip install django
#if the database is ot available during migrations,add this in init.py
import pymysql