def test_load_env_only_prefixed_variables_without_strip_prefix(self):
os.chdir(os.path.join(TESTS_DIR, 'cwd'))
self.assertFalse('RUNENVC_STRING' in os.environ)
self.assertFalse('RUNENVC_NUMBER' in os.environ)
self.assertFalse('RUNENVC_FLOAT' in os.environ)
load_env(env_file='env.custom', prefix='RUNENVC_S', strip_prefix=False)
self.assertTrue('RUNENVC_STRING' in os.environ)
self.assertFalse('RUNENVC_NUMBER' in os.environ)
self.assertFalse('RUNENVC_FLOAT' in os.environ)
def test_load_env_only_prefixed_variables_without_strip_prefix(self):
os.chdir(os.path.join(TESTS_DIR, 'cwd'))
self.assertFalse('RUNENVC_STRING' in os.environ)
self.assertFalse('RUNENVC_NUMBER' in os.environ)
self.assertFalse('RUNENVC_FLOAT' in os.environ)
load_env(env_file='env.custom', prefix='RUNENVC_S', strip_prefix=False)
self.assertTrue('RUNENVC_STRING' in os.environ)
self.assertFalse('RUNENVC_NUMBER' in os.environ)
self.assertFalse('RUNENVC_FLOAT' in os.environ)
def test_load_env_from_default_file(self):
os.chdir(os.path.join(TESTS_DIR, 'cwd'))
self.assertFalse('RUNENV_STRING' in os.environ)
self.assertFalse('RUNENV_NUMBER' in os.environ)
self.assertFalse('RUNENV_FLOAT' in os.environ)
load_env()
self.assertTrue('RUNENV_STRING' in os.environ)
self.assertTrue('RUNENV_NUMBER' in os.environ)
self.assertTrue('RUNENV_FLOAT' in os.environ)
self.assertEqual(os.environ.get('RUNENV_STRING'), 'some string')
self.assertEqual(os.environ.get('RUNENV_NUMBER'), '13')
self.assertEqual(os.environ.get('RUNENV_FLOAT'), '12.12')
def test_load_env_skip_if_wrapped_by_runenv(self):
os.chdir(os.path.join(TESTS_DIR, 'cwd'))
self.assertFalse('RUNENVC_STRING' in os.environ)
self.assertFalse('RUNENVC_NUMBER' in os.environ)
self.assertFalse('RUNENVC_FLOAT' in os.environ)
# mark as runned by `envfile` wrapper
os.environ['_RUNENV_WRAPPED'] = '1'
load_env(env_file='env.custom')
self.assertFalse('RUNENVC_STRING' in os.environ)
self.assertFalse('RUNENVC_NUMBER' in os.environ)
self.assertFalse('RUNENVC_FLOAT' in os.environ)
def test_load_env_from_custom_file(self):
os.chdir(os.path.join(TESTS_DIR, 'cwd'))
self.assertFalse('RUNENVC_STRING' in os.environ)
self.assertFalse('RUNENVC_NUMBER' in os.environ)
self.assertFalse('RUNENVC_FLOAT' in os.environ)
load_env(env_file='env.custom')
self.assertTrue('RUNENVC_STRING' in os.environ)
self.assertTrue('RUNENVC_NUMBER' in os.environ)
self.assertTrue('RUNENVC_FLOAT' in os.environ)
self.assertEqual(os.environ.get('RUNENVC_STRING'), 'custom string')
self.assertEqual(os.environ.get('RUNENVC_NUMBER'), '14')
self.assertEqual(os.environ.get('RUNENVC_FLOAT'), '14.14')
def test_load_env_from_default_file(self):
os.chdir(os.path.join(TESTS_DIR, 'cwd'))
self.assertFalse('RUNENV_STRING' in os.environ)
self.assertFalse('RUNENV_NUMBER' in os.environ)
self.assertFalse('RUNENV_FLOAT' in os.environ)
load_env()
self.assertTrue('RUNENV_STRING' in os.environ)
self.assertTrue('RUNENV_NUMBER' in os.environ)
self.assertTrue('RUNENV_FLOAT' in os.environ)
self.assertEqual(os.environ.get('RUNENV_STRING'), 'some string')
self.assertEqual(os.environ.get('RUNENV_NUMBER'), '13')
self.assertEqual(os.environ.get('RUNENV_FLOAT'), '12.12')
def test_load_env_skip_if_wrapped_by_runenv(self):
os.chdir(os.path.join(TESTS_DIR, 'cwd'))
self.assertFalse('RUNENVC_STRING' in os.environ)
self.assertFalse('RUNENVC_NUMBER' in os.environ)
self.assertFalse('RUNENVC_FLOAT' in os.environ)
# mark as runned by `envfile` wrapper
os.environ['_RUNENV_WRAPPED'] = '1'
load_env(env_file='env.custom')
self.assertFalse('RUNENVC_STRING' in os.environ)
self.assertFalse('RUNENVC_NUMBER' in os.environ)
self.assertFalse('RUNENVC_FLOAT' in os.environ)
def test_load_env_from_custom_file(self):
os.chdir(os.path.join(TESTS_DIR, 'cwd'))
self.assertFalse('RUNENVC_STRING' in os.environ)
self.assertFalse('RUNENVC_NUMBER' in os.environ)
self.assertFalse('RUNENVC_FLOAT' in os.environ)
load_env(env_file='env.custom')
self.assertTrue('RUNENVC_STRING' in os.environ)
self.assertTrue('RUNENVC_NUMBER' in os.environ)
self.assertTrue('RUNENVC_FLOAT' in os.environ)
self.assertEqual(os.environ.get('RUNENVC_STRING'), 'custom string')
self.assertEqual(os.environ.get('RUNENVC_NUMBER'), '14')
self.assertEqual(os.environ.get('RUNENVC_FLOAT'), '14.14')
def test_load_env_force_even_wrapped_by_runenv(self):
os.chdir(os.path.join(TESTS_DIR, 'cwd'))
self.assertFalse('RUNENVC_STRING' in os.environ)
self.assertFalse('RUNENVC_NUMBER' in os.environ)
self.assertFalse('RUNENVC_FLOAT' in os.environ)
os.environ['_RUNENV_WRAPPED'] = '1'
load_env(env_file='env.custom', force=True)
self.assertTrue('RUNENVC_STRING' in os.environ)
self.assertTrue('RUNENVC_NUMBER' in os.environ)
self.assertTrue('RUNENVC_FLOAT' in os.environ)
self.assertEqual(os.environ.get('RUNENVC_STRING'), 'custom string')
self.assertEqual(os.environ.get('RUNENVC_NUMBER'), '14')
self.assertEqual(os.environ.get('RUNENVC_FLOAT'), '14.14')
def test_load_env_force_even_wrapped_by_runenv(self):
os.chdir(os.path.join(TESTS_DIR, 'cwd'))
self.assertFalse('RUNENVC_STRING' in os.environ)
self.assertFalse('RUNENVC_NUMBER' in os.environ)
self.assertFalse('RUNENVC_FLOAT' in os.environ)
os.environ['_RUNENV_WRAPPED'] = '1'
load_env(env_file='env.custom', force=True)
self.assertTrue('RUNENVC_STRING' in os.environ)
self.assertTrue('RUNENVC_NUMBER' in os.environ)
self.assertTrue('RUNENVC_FLOAT' in os.environ)
self.assertEqual(os.environ.get('RUNENVC_STRING'), 'custom string')
self.assertEqual(os.environ.get('RUNENVC_NUMBER'), '14')
self.assertEqual(os.environ.get('RUNENVC_FLOAT'), '14.14')
def test_search_grand_parent(self):
ENV_FILE = 'env.search_grandparent'
os.chdir(os.path.join(TESTS_DIR, 'search_grandparent', 'project'))
load_env(env_file=ENV_FILE)
self.assertFalse('GRAND_PARENT' in os.environ)
load_env(env_file=ENV_FILE)
self.assertFalse('GRAND_PARENT' in os.environ)
load_env(env_file=ENV_FILE, search_parent=1)
self.assertFalse('GRAND_PARENT' in os.environ)
load_env(env_file=ENV_FILE, search_parent=2)
self.assertTrue('GRAND_PARENT' in os.environ)
self.assertEqual(os.environ.get('GRAND_PARENT'), '3')
def test_load_env_from_missing_file(self):
load_env(env_file='env.missing')
import os, logging
from runenv import load_env
load_env(env_file='.env')
uri = 'mysql://' +\
os.getenv('DB_USER') + ':' +\
os.getenv('DB_PW') + '@' +\
os.getenv('DB_HOST') + ':' +\
os.getenv('DB_PORT') + '/' +\
os.getenv('DB_NAME')
def test_load_env_from_missing_file(self):
load_env(env_file='env.missing')
@author: DELL
"""
from flask import Flask, request, render_template, make_response
from flask import Markup, flash, session, redirect, url_for
import time
import mysql.connector
from runenv import load_env
import os
import ast
import json
import random
import math
import datetime
load_env()
#config= os.environ.get('config')
user = os.environ.get('user')
host = os.environ.get('host')
passwd = os.environ.get('passwd')
database = os.environ.get('database')
config = {'user': user, 'host': host, 'passwd': passwd, 'database': database}
names = {
"saravanampatti": [0, 33],
"kurudampalayam": [2, 10],
"ashokapuram": [3, 16],
"gks": [4, 29],
"thudiyalur": [5, 4],
"chinnavedampatti": [5, 21],
