def saturation(this):
sat = 0
saturations = Csv.loadall("csv/saturation.csv")
for items in saturations:
if int(items["saturation"]) == 1:
sat += int(this.acideGras[items["acidegras"]])
return sat
def importIngredients(filename):
"""Importer les ingredients depuis un fichier csv. Opération destructrice."""
cursor.execute("DELETE FROM Ingredients")
connection.commit()
cursor.execute("INSERT INTO Ingredients VALUES (NULL, ?, ?, ?)", Csv.loadall("csv/ingredients.csv"))
connection.commit()
def importSaturation(filename):
"""Importer la saturation depuis un fichier csv."""
cursor.execute("DELETE FROM Saturation")
connection.commit()
for d in Csv.loadall(filename):
cursor.execute("INSERT INTO Saturation VALUES (?, ?)", (d["acidegras"], d["saturation"]))
connection.commit()
# Build paths inside the project like this: os.path.join(BASE_DIR, ...)
BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))
# Quick-start development settings - unsuitable for production
# See https://docs.djangoproject.com/en/2.2/howto/deployment/checklist/
# SECURITY WARNING: keep the secret key used in production secret!
#
SECRET_KEY = config('SECRET_KEY')
# SECURITY WARNING: don't run with debug turned on in production!
DEBUG = config('DEBUG', default=False, cast=bool)
ALLOWED_HOSTS = config('ALLOWED_HOSTS', cast=Csv())
# Application definition
INSTALLED_APPS = [
'django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
# Apps propias
'core',
'concursos',
# -*- coding: utf-8 -*-
# @author : Vitaliy Charnou <*****@*****.**>
from subprocess import check_output
import json, os, sys
params = os.getcwd() + '/../../../../../../app/etc/env.php'
config = check_output(
['php', '-r', 'echo json_encode(include "' + params + '");'])
config = json.loads(config)
sys.path.append('../Model/')
sys.path.append('../Model/Writer')
import Log, Export, Csv
from Log import *
from Export import *
from Csv import *
log = Log()
csv = Csv()
log.setBeginTime()
export = Export(config)
data = export.getData()
log.writeln(u'count: %.2f' % len(data))
headers = [i[0] for i in export.getDescription()]
csv.setFile('pupsik2.csv')
csv.setHeaders(headers)
csv.setInFile(data)
log.outEndTime()
def load(this, nom):
loader = Csv.load("csv/acidegras.csv", "nom", nom)
this.update(loader)
def load(this, ref):
loader = Csv.load("csv/ingredients.csv", "ref", ref)
if loader is not None:
this.ref = loader["ref"]
this.famille = loader["famille"]
this.nom = loader["nom"]
