nurtelecom-gras-library 1.3.6

Official Nurtelecom gras library

nurtelecom_gras_library

This is official NurTelecom GRAS library

from nurtelecom_gras_library import PLSQL_data_importer, make_table_query_from_pandas

#create connection
database_connection = PLSQL_data_importer(user = 'user', password = 'pass', host= '192.168.1.1', port = '1521')

#create query
test_query = "select 1 from dual"

#makes pandas df 
test_data = database_connection.get_data(query = test_query)

#make new_create query from pandas df
new_table_name_for_sql = "test_table_name"
query_from_tabel = make_table_query_from_pandas(df = test_data, table_name= new_table_name_for_sql)

#execute query
database_connection.execute(query_from_tabel)