connect sql by python using txt. file

[dawid294]

Hi python experts i do not know what i do wrong , I would like connect to sql by python using txt.file , Where i do a mistake? or is possible connect to sql by python so as not to be seen password and other things? Thanks Password and other thing should be saved in other folder as my python file. Is it possible thanks

dat=open(location+"udaje.txt",'r')
lines=dat.readlines()
p_username=lines[0]
p_password=lines[1]
p_host=lines[2]
p_service=lines[3]
p_dns=lines[4]
p_port=lines[5]

print(p_username)
print(p_password)
print(p_host)
print(p_service)
print(p_dns)
print(p_port)

#dat.close()

conn=cx_Oracle.connect(user=p_username, password=p_password, dsn=p_dns)
cursor = conn.cursor()
rs = cursor.execute("delete FROM table")
conn.commit()

I get this output

Output:
DatabaseError                             Traceback (most recent call last)
<ipython-input-11-544a4434c1b5> in <module>
     37 #dat.close()
     38 
---> 39 conn=cx_Oracle.connect(user=p_username, password=p_password, dsn=p_dns)
     40 cursor = conn.cursor()
     41 rs = cursor.execute("delete FROM table")

DatabaseError: ORA-12154: TNS: nie je možné rozpoznať zadaný identifikátor pripojenia

[noisefloor]

Hi,

instead of using a text file, use another Python file and define the values for username etc. in there. Then import from there. Everything which is in object - which variables are - is importable. Or use an ini-style file and use the configparser module to read from it. And in case you like to stick to a text file, do not forget to provide the encoding to the open function.
When reading a file, it is better to use the with-statement. This ensures the file is closed properly again.

And please to not build filepathes with +, use pathlib (which is included in Python) instead. That's the clean way.

On your code: syntactically the line is correct I guess - are you sure the values of the parameters you pass are _really_ valid? The error code ORA-12154 indicates that either a parameter is wrong or something is wrong in the tnsnames.ora file.

Regards, noisefloor

[deanhystad]

Let's say your udaje.txt looks like this:

Output:
username
password
host
service
dns
port

I write a program to print out the file.

with open("udaje.txt", "r") as file:
    print(*file.readlines(), sep="\n")

This is the output:

username

password

host

service

dns

port

That may be your problem. Each of the strings in the file has a following newline character, and these will be at the end of your username and password strings. Your username likely doesn't end with "\n".