connection python and SQL

[dawid294]

Hi python experts, Is possible to connect Python and SQL? In jupyter notebook or in Pycharm? Is possible start the code from SQL in Python? If Yes how?Thanks

[buran]

Could you elaborate? It's not clear what you ask. Of course it's possible to interact with a DB from/via python code

[dawid294]

ok i have created the code in PL/SQL developer where i download and edit the data, after that I save this data to excel and after that I start The code with model in python. I would like to improve this process and use only Python, because the SQL code still will the same and I would like to save my time. But I do not know how can i do this which programme i have to use. Thanks

[buran]

Still not sure if you want to rewrite some parts in python or just call PL/SQL from python.
Maybe have a look ate https://python-oracledb.readthedocs.io/e...ution.html

[Pedroski55]

I think it is a good idea to access the database using phpMyAdmin first. Make an SQL query and try it, to make sure that it works. When you know you have a query that works, then you can do it from Python.

I only do simple stuff. For me, pymysql works fine.

import pymysql def mysqlINSERT(name, email, comment): conn = pymysql.connect( host='127.0.0.1', user='baby', password = 'Taizhou', db='babydb', ) cur = conn.cursor() # INSERT query command = 'INSERT INTO agro_products (customer_id, product_name, product_class) VALUES (%s, %s, %s)' cur.execute(command, (name, email, comment)) # without conn.commit() all you get is simulation, nothing is actually written conn.commit() # To close the connection conn.close() return 'OK' name = 'Use me' email = '[email protected]' comment = 'Hope this kills everything!' doit = mysqlINSERT(name, email, comment)

Here is a query to return the column names of a given table:

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'babydb' AND TABLE_NAME = 'agro_products';

Try it in phpMyAdmin first, using your database name and table name, of course. When you know it works, try it in Python.