def setUp(self):
# Create a school with a list of students
school = School(name='instituto hebreo',
principal='Juan Perez',
location='Santiago')
school.save()
# ahora creo estudiantes
Student.objects.create(name='ilan', age=28, school=school)
Student.objects.create(name='sigal', age=22, school=school)
def _populate(self):
fake = Faker()
for _ in range(random.randint(10, 30)):
school = School(name=f'{fake.last_name()[:10]}\'s school',
students_max_number=random.randint(10, 200),
established_in=random.randint(1900, 2020),
location=fake.street_address())
school.save()
for __ in range(random.randint(5, school.students_max_number)):
student = Student(first_name=fake.first_name()[:20],
last_name=fake.last_name()[:20],
school=school,
date_of_birth=fake.date_of_birth(),
nationality=fake.country()[:20])
student.save()
def migrateSchoolToDatabase():
schools = user.getAllSchools()
pattern = re.compile(r'\{"[^\}]*"\}')
results = pattern.finditer(schools)
for item in results:
oneSchool = item.group()
namePattern = re.compile(r'(?<="yxsmc":")([^"]+?)(?=")')
name = namePattern.search(oneSchool).group()
print name
engNamePattern = re.compile(r'(?<="yxsywmc":")([^"]+?)(?=")')
try:
engName = engNamePattern.search(oneSchool).group()
except:
engName = ''
numberPattern = re.compile(r'(?<="yxsh":")([^"]+?)(?=")')
number = numberPattern.search(oneSchool).group()
schoolObj = School(name=name, englishName=engName, number=number)
schoolObj.save()
from location.models import Location
from school.models import School
import csv
with open('dataframe_v1.csv') as csvfile:
spamreader = csv.reader(csvfile, delimiter=',')
for row in spamreader:
row[2] = row[2].split(row[3])[0][0:-2]
try:
int(row[1].split(' ')[0])
row[1] = ' '.join(row[1].split(' ')[1:])
except ValueError:
pass
loc = Location(endereco=row[2],
bairro=row[3],
latitude=row[4],
longitude=row[5])
loc.save()
scho = School(nro_entidade=row[0], name=row[1], location=loc)
scho.save()
print(row)
