# Django settings for p4l project.

from django.conf import global_settings

DEBUG = True

TEMPLATE_DEBUG = DEBUG

ADMINS = (

    # ('Your Name', 'your_email@example.com'),

)

MANAGERS = ADMINS

DATABASES = {

    'default': {

        'ENGINE': 'django.db.backends.', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.

        'NAME': '',                      # Or path to database file if using sqlite3.

        # The following settings are not used with sqlite3:

        'USER': '',

        'PASSWORD': '',

        'HOST': '',                      # Empty for localhost through domain sockets or '127.0.0.1' for localhost through TCP.

        'PORT': '',                      # Set to empty string for default.

    }

}

# Hosts/domain names that are valid for this site; required if DEBUG is False

# See https://docs.djangoproject.com/en/1.5/ref/settings/#allowed-hosts

ALLOWED_HOSTS = []

# Local time zone for this installation. Choices can be found here:

# http://en.wikipedia.org/wiki/List_of_tz_zones_by_name

# although not all choices may be available on all operating systems.

# In a Windows environment this must be set to your system time zone.

TIME_ZONE = 'America/Chicago'

# Language code for this installation. All choices can be found here:

# http://www.i18nguy.com/unicode/language-identifiers.html

LANGUAGE_CODE = 'en-us'

ugettext = lambda s: s

LANGUAGES = ( 

    ('fr', ugettext('French')),

    ('en', ugettext('English')),

    ('es', ugettext('Spanish')),

)

SITE_ID = 1

# If you set this to False, Django will make some optimizations so as not

# to load the internationalization machinery.

USE_I18N = True

# If you set this to False, Django will not format dates, numbers and

# calendars according to the current locale.

USE_L10N = True

# If you set this to False, Django will not use timezone-aware datetimes.

USE_TZ = True

# Absolute filesystem path to the directory that will hold user-uploaded files.

# Example: "/var/www/example.com/media/"

MEDIA_ROOT = ''

# URL that handles the media served from MEDIA_ROOT. Make sure to use a

# trailing slash.

# Examples: "http://example.com/media/", "http://media.example.com/"

MEDIA_URL = ''

# Absolute path to the directory static files should be collected to.

# Don't put anything in this directory yourself; store your static files

# in apps' "static/" subdirectories and in STATICFILES_DIRS.

# Example: "/var/www/example.com/static/"

STATIC_ROOT = ''

# URL prefix for static files.

# Example: "http://example.com/static/", "http://static.example.com/"

STATIC_URL = '/static/'

# Additional locations of static files

STATICFILES_DIRS = (

    # Put strings here, like "/home/html/static" or "C:/www/django/static".

    # Always use forward slashes, even on Windows.

    # Don't forget to use absolute paths, not relative paths.

)

# List of finder classes that know how to find static files in

# various locations.

STATICFILES_FINDERS = (

    'django.contrib.staticfiles.finders.FileSystemFinder',

    'django.contrib.staticfiles.finders.AppDirectoriesFinder',

#    'django.contrib.staticfiles.finders.DefaultStorageFinder',

)

# List of callables that know how to import templates from various sources.

TEMPLATE_LOADERS = (

    'django.template.loaders.filesystem.Loader',

    'django.template.loaders.app_directories.Loader',

#     'django.template.loaders.eggs.Loader',

)

MIDDLEWARE_CLASSES = (

    'django.middleware.common.CommonMiddleware',

    'django.contrib.sessions.middleware.SessionMiddleware',

    'django.middleware.locale.LocaleMiddleware',

    'django.middleware.csrf.CsrfViewMiddleware',

    'django.contrib.auth.middleware.AuthenticationMiddleware',

    'django.contrib.messages.middleware.MessageMiddleware',

    # Uncomment the next line for simple clickjacking protection:

    # 'django.middleware.clickjacking.XFrameOptionsMiddleware',

)

ROOT_URLCONF = 'p4l.urls'

AUTH_USER_MODEL = 'p4l.User'

INITIAL_CUSTOM_USER_MIGRATION = "0001_initial"

# Python dotted path to the WSGI application used by Django's runserver.

WSGI_APPLICATION = 'p4l.wsgi.application'

TEMPLATE_DIRS = (

    # Put strings here, like "/home/html/django_templates" or "C:/www/django/templates".

    # Always use forward slashes, even on Windows.

    # Don't forget to use absolute paths, not relative paths.

)

INSTALLED_APPS = (

    'django.contrib.auth',

    'django.contrib.contenttypes',

    'django.contrib.sessions',

    'django.contrib.sites',

    'django.contrib.messages',

    'django.contrib.staticfiles',

    'django.contrib.admin',

    'django_extensions',

    'south',

    'rest_framework',

    'p4l'

)

TEMPLATE_CONTEXT_PROCESSORS = global_settings.TEMPLATE_CONTEXT_PROCESSORS + (

    'django.core.context_processors.i18n',

)

# A sample logging configuration. The only tangible logging

# performed by this configuration is to send an email to

# the site admins on every HTTP 500 error when DEBUG=False.

# See http://docs.djangoproject.com/en/dev/topics/logging for

# more details on how to customize your logging configuration.

LOGGING = {

    'version': 1,

    'disable_existing_loggers': False,

    'filters': {

        'require_debug_false': {

            '()': 'django.utils.log.RequireDebugFalse'

        }

    },

    'handlers': {

        'mail_admins': {

            'level': 'ERROR',

            'filters': ['require_debug_false'],

            'class': 'django.utils.log.AdminEmailHandler'

        }

    },

    'loggers': {

        'django.request': {

            'handlers': ['mail_admins'],

            'level': 'ERROR',

            'propagate': True,

        },

    }

}

NB_RECORDS_BY_PAGE = 20

SPARQL_QUERY_ENDPOINT = "http://localhost:8080/openrdf-sesame/repositories/plan4learning"

SPARQL_SUBJECT_QUERIES = {

"filter" : """

PREFIX skos:<http://www.w3.org/2004/02/skos/core#>

PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX owl:<http://www.w3.org/2002/07/owl#>

PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?uri ?label

WHERE {

    ?uri a skos:Concept.

    ?uri skos:inScheme <http://skos.um.es/unescothes/CS000> .

    ?uri skos:prefLabel ?label.

    FILTER (lang(?label) = %s).

    ?uri skos:prefLabel ?lab.

    FILTER regex (str(?lab), ?reg, 'i').

    FILTER (lang (?lab) = %s).

    BIND (STRLEN(STRBEFORE (str(?lab), ?reg)) AS ?place).

    BIND (STRLEN(STR(?lab)) AS ?len)

}

ORDER BY ?place ?len ?lab

""",

"root" : """

PREFIX skos:<http://www.w3.org/2004/02/skos/core#>

PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX owl:<http://www.w3.org/2002/07/owl#>

PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?uri ?label

WHERE {

    ?uri a skos:Collection ;

    skos:inScheme <http://skos.um.es/unescothes/CS000> ;    

    skos:prefLabel|rdfs:label ?label .

    FILTER (lang(?label) = %s). 

    FILTER NOT EXISTS { [skos:member ?uri] }

}

""",

"childs" : """

PREFIX skos:<http://www.w3.org/2004/02/skos/core#>

PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX owl:<http://www.w3.org/2002/07/owl#>

PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?uri ?label

WHERE {

  ?uri skos:inScheme <http://skos.um.es/unescothes/CS000> .

  { ?uri a ?type

    FILTER (?type = skos:Collection || ?type = skos:Concept) }.

  ?root skos:narrower|skos:member ?uri.

  ?uri skos:prefLabel|rdfs:label ?label.

  FILTER (lang(?label) = %s).

}

""",

"child-count" : """

PREFIX skos:<http://www.w3.org/2004/02/skos/core#>

PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX owl:<http://www.w3.org/2002/07/owl#>

PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>

SELECT (COUNT(?uri) as ?nb)

WHERE {

    ?uri skos:inScheme <http://skos.um.es/unescothes/CS000> .

    ?root skos:narrower|skos:member ?uri.

}

"""

}

SPARQL_THEME_QUERIES = {

'filter' : """

PREFIX skos:<http://www.w3.org/2004/02/skos/core#>

PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX owl:<http://www.w3.org/2002/07/owl#>

PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?uri ?label

WHERE {

    ?uri a skos:Concept.

    ?uri skos:inScheme <http://www.iiep.unesco.org/plan4learning/scheme/Themes> .

    ?uri skos:prefLabel ?label.

    FILTER (lang(?label) = %s).

    ?uri skos:prefLabel ?lab.

    FILTER regex (str(?lab), ?reg, 'i').

    FILTER (lang (?lab) = %s).

    BIND (STRLEN(STRBEFORE (str(?lab), ?reg)) AS ?place).

    BIND (STRLEN(STR(?lab)) AS ?len)

}

ORDER BY ?place ?len ?lab

""",

'root' : """

PREFIX skos:<http://www.w3.org/2004/02/skos/core#>

PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX owl:<http://www.w3.org/2002/07/owl#>

PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?uri ?label

WHERE {

    ?uri a skos:Concept ;

    skos:inScheme <http://www.iiep.unesco.org/plan4learning/scheme/Themes> ;    

    skos:prefLabel ?label .

    FILTER (lang(?label) = %s). 

    FILTER NOT EXISTS { [skos:narrower ?uri] }

}

""",

'childs' : """

PREFIX skos:<http://www.w3.org/2004/02/skos/core#>

PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX owl:<http://www.w3.org/2002/07/owl#>

PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?uri ?label

WHERE {

  ?uri skos:inScheme <http://www.iiep.unesco.org/plan4learning/scheme/Themes> .

  { ?uri a ?type

    FILTER (?type = skos:Collection || ?type = skos:Concept) }.

  ?root skos:narrower|skos:member ?uri.

  ?uri skos:prefLabel|rdfs:label ?label.

  FILTER (lang(?label) = %s).

}

""",

'child-count' : """

PREFIX skos:<http://www.w3.org/2004/02/skos/core#>

PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX owl:<http://www.w3.org/2002/07/owl#>

PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>

SELECT (COUNT(?uri) as ?nb)

WHERE {

    ?uri skos:inScheme <http://www.iiep.unesco.org/plan4learning/scheme/Themes> .

    ?root skos:narrower|skos:member ?uri.

}

"""

}

SPARQL_COUNTRY_QUERIES = {

'filter' : """

PREFIX skos:<http://www.w3.org/2004/02/skos/core#>

PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX owl:<http://www.w3.org/2002/07/owl#>

PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?uri ?label

WHERE {

    ?uri a skos:Concept.

    ?uri skos:inScheme <http://skos.um.es/unescothes/CS000/Countries> .

    ?uri skos:prefLabel ?label.

    FILTER (lang(?label) = %s).

    ?uri skos:prefLabel ?lab.

    FILTER regex (str(?lab), ?reg, 'i').

    FILTER (lang (?lab) = %s).

    BIND (STRLEN(STRBEFORE (str(?lab), ?reg)) AS ?place).

    BIND (STRLEN(STR(?lab)) AS ?len)

}

ORDER BY ?place ?len ?lab

""",

'root' : """

PREFIX skos:<http://www.w3.org/2004/02/skos/core#>

PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX owl:<http://www.w3.org/2002/07/owl#>

PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?uri ?label

WHERE {

    ?uri a skos:Concept ;

    skos:inScheme <http://skos.um.es/unescothes/CS000/Countries> ;    

    skos:prefLabel ?label .

    FILTER (lang(?label) = %s). 

    FILTER NOT EXISTS { [skos:narrower ?uri] }

}

""",

'childs' : """

PREFIX skos:<http://www.w3.org/2004/02/skos/core#>

PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX owl:<http://www.w3.org/2002/07/owl#>

PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?uri ?label

WHERE {

  ?uri skos:inScheme <http://skos.um.es/unescothes/CS000/Countries> .

  { ?uri a ?type

    FILTER (?type = skos:Collection || ?type = skos:Concept) }.

  ?root skos:narrower|skos:member ?uri.

  ?uri skos:prefLabel|rdfs:label ?label.

  FILTER (lang(?label) = %s).

}

""",

'child-count' : """

PREFIX skos:<http://www.w3.org/2004/02/skos/core#>

PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX owl:<http://www.w3.org/2002/07/owl#>

PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>

SELECT (COUNT(?uri) as ?nb)

WHERE {

    ?uri skos:inScheme <http://skos.um.es/unescothes/CS000/Countries> .

    ?root skos:narrower|skos:member ?uri.

}

"""

}

SPARQL_LANGUAGE_QUERIES = {

'filter' : """

PREFIX skos:<http://www.w3.org/2004/02/skos/core#>

PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX owl:<http://www.w3.org/2002/07/owl#>

PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?uri ?label

WHERE {

    ?uri a skos:Concept.

    ?uri skos:inScheme <http://www.iiep.unesco.org/plan4learning/scheme/Languages> .

    ?uri skos:prefLabel ?label.

    FILTER (lang(?label) = %s).

    ?uri skos:prefLabel ?lab.

    FILTER regex (str(?lab), ?reg, 'i').

    FILTER (lang (?lab) = %s).

    BIND (STRLEN(STRBEFORE (str(?lab), ?reg)) AS ?place).

    BIND (STRLEN(STR(?lab)) AS ?len)

}

ORDER BY ?place ?len ?lab

""",

'root' : """

PREFIX skos:<http://www.w3.org/2004/02/skos/core#>

PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX owl:<http://www.w3.org/2002/07/owl#>

PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?uri ?label

WHERE {

    ?uri a skos:Concept ;

    skos:inScheme <http://www.iiep.unesco.org/plan4learning/scheme/Languages> ;    

    skos:prefLabel ?label .

    FILTER (lang(?label) = %s). 

    FILTER NOT EXISTS { [skos:narrower ?uri] }

}

"""

}

SPARQL_PROJECT_QUERIES = {

'filter' : """

PREFIX skos:<http://www.w3.org/2004/02/skos/core#>

PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX owl:<http://www.w3.org/2002/07/owl#>

PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?uri ?label

WHERE {

    ?uri a skos:Concept.

    ?uri skos:inScheme <http://www.iiep.unesco.org/plan4learning/scheme/Projects> .

    ?uri skos:prefLabel ?label.

    ?uri skos:prefLabel ?lab.

    FILTER regex (str(?lab), ?reg, 'i').

    BIND (STRLEN(STRBEFORE (str(?lab), ?reg)) AS ?place).

    BIND (STRLEN(STR(?lab)) AS ?len)

}

ORDER BY ?place ?len ?lab

""",

'root' : """

PREFIX skos:<http://www.w3.org/2004/02/skos/core#>

PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX owl:<http://www.w3.org/2002/07/owl#>

PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?uri ?label

WHERE {

    ?uri a skos:Concept ;

    skos:inScheme <http://www.iiep.unesco.org/plan4learning/scheme/Projects> ;    

    skos:prefLabel ?label .

}

"""

}

SPARQL_ORGANIZATION_QUERIES = {

'filter' : """

PREFIX skos:<http://www.w3.org/2004/02/skos/core#>

PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX owl:<http://www.w3.org/2002/07/owl#>

PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?uri ?label

WHERE {

    ?uri a skos:Concept.

    ?uri skos:inScheme <http://www.iiep.unesco.org/plan4learning/scheme/Organizations> .

    ?uri skos:prefLabel ?label.

    ?uri skos:prefLabel ?lab.

    FILTER regex (str(?lab), ?reg, 'i').

    BIND (STRLEN(STRBEFORE (str(?lab), ?reg)) AS ?place).

    BIND (STRLEN(STR(?lab)) AS ?len)

}

ORDER BY ?place ?len ?lab

""",

'root' : """

PREFIX skos:<http://www.w3.org/2004/02/skos/core#>

PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX owl:<http://www.w3.org/2002/07/owl#>

PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?uri ?label

WHERE {

    ?uri a skos:Concept ;

    skos:inScheme <http://www.iiep.unesco.org/plan4learning/scheme/Organizations> ;    

    skos:prefLabel ?label .

}

"""

}