Read Value from Config File Python

Question

I have a file .env file contain 5 lines

DB_HOST=http://localhost/
DB_DATABASE=bheng-local
DB_USERNAME=root
DB_PASSWORD=1234567890
UNIX_SOCKET=/tmp/mysql.sock

I want to write python to grab the value of DB_DATABASE I want this bheng-local

I would have use

import linecache
print linecache.getline('.env', 2)

But some people might change the order of the cofigs, that's why linecache is not my option.

I am not sure how to check for only some strings match but all the entire line, and grab the value after the =.

I'm kind of stuck here :

file = open('.env', "r")
read = file.read()
my_line = ""

for line in read.splitlines():
    if line == "DB_DATABASE=":
        my_line = line
        break
print my_line

Can someone please give me a little push here ?

the startwith may be of assistance.

boardrider
– boardrider

2017-03-04 20:46:34 +00:00
Commented Mar 4, 2017 at 20:46 — boardrider
– boardrider, Commented Mar 4, 2017 at 20:46

Knase · Accepted Answer · 2021-05-19 08:01:58Z

12

Modify your .env to

[DB]
DB_HOST=http://localhost/
DB_DATABASE=bheng-local
DB_USERNAME=root
DB_PASSWORD=1234567890
UNIX_SOCKET=/tmp/mysql.sock

Python code

#!/usr/local/bin/python
import configparser
config = configparser.ConfigParser()
config.read('test.env')
print config.get('DB','DB_DATABASE')

Output:

bheng-local

Read https://docs.python.org/3/library/configparser.html

edited May 19, 2021 at 8:01

Knase

1,27414 silver badges23 bronze badges

answered Mar 3, 2017 at 0:23

Sridhar Iyer

3192 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

code-8 Over a year ago

I like the idea of using the parser, but it require me to add more texts on top of my configs file. I don't mind if I am the only one that has it. This config file s is deployed to thousand people already. :( Is there a simple way to grab it base on DB_DATABASE which is the string of file ?

yar · Accepted Answer · 2017-03-02 23:54:55Z

10

Have a look at the config parser: https://docs.python.org/3/library/configparser.html

It's more elegant than a self-made solution

answered Mar 2, 2017 at 23:54

yar

1,9561 gold badge15 silver badges30 bronze badges

2 Comments

code-8 Over a year ago

I like the idea of using the parser, but it require me to add more texts on top of my configs file. I don't mind if I am the only one that has it. This config file s is deployed to thousand people already. :( Is there a simple way to grab it base on DB_DATABASE which is the string of file ?

yar Over a year ago

There are some hacks to go around it, you can find them here: The shortest is probably this one , for Python 3.2+ and this one for earlier versions. The most elegant probably this one.

Sridhar Iyer · Accepted Answer · 2017-03-03 00:56:34Z

4

This should work for you

#!/usr/local/bin/python
file = open('test.env', "r")
read = file.read()

for line in read.splitlines():
    if 'DB_DATABASE=' in line:
        print line.split('=',1)[1]

answered Mar 3, 2017 at 0:56

Sridhar Iyer

3192 silver badges8 bronze badges

Comments

subh8899 · Accepted Answer · 2019-01-11 15:02:26Z

2

#!/usr/local/bin/python

from configobj import ConfigObj
conf = ConfigObj('test.env')
print conf['DB_DATABASE']

edited Jan 11, 2019 at 15:02

answered Jan 11, 2019 at 14:56

subh8899

213 bronze badges

2 Comments

subh8899 Over a year ago

Using ConfigObj, we do not need to add anything like section header at the start of the .env file to read the variable values from it.

Hans Deragon Over a year ago

And without a header, the configuration file can also be read by other languages easily, like Bash for example.

koficodes · Accepted Answer · 2021-03-31 04:05:53Z

2

from os import environ, path
from dotenv import load_dotenv

basedir = path.abspath(path.dirname(__file__))
load_dotenv(path.join(basedir, '.env'))
DB_DATABASE = environ.get('DB_DATABASE')
print(DB_DATABASE)

This could be another option

answered Mar 31, 2021 at 4:05

koficodes

3601 silver badge8 bronze badges

Collectives™ on Stack Overflow

Read Value from Config File Python

5 Answers 5

1 Comment

2 Comments

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

2 Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related