Python : Code to search a value inside a database (.mdb)
Budget: €8 – €30 EUR
Hello,
I need a code to search value inside a database(.mdb). its a database access with a lot of tables and columns.
I need to have an algoritm that search a value . The algorithm have an option : exact or contain
when the option exact is activated:
i need to have inside the value exactly the value that i search
when the option "contains" is activated i need to have the values that contains the word that iseach
the output of this algoirthm its a CSV file:
i need to have the table, the columns and the row where i have the value. and the value and the option used inside the algorithm( exact or contains)
if i have multiple results i want to have all results
so we have 4 columns :
table
columns
row
value
Option search
i cant send you a database but you can create it on microsoft access quicly to test
i use the connector of pyodbc to acces to the base inside python (microsoft access driver)
I need a code to search value inside a database(.mdb). its a database access with a lot of tables and columns.
I need to have an algoritm that search a value . The algorithm have an option : exact or contain
when the option exact is activated:
i need to have inside the value exactly the value that i search
when the option "contains" is activated i need to have the values that contains the word that iseach
the output of this algoirthm its a CSV file:
i need to have the table, the columns and the row where i have the value. and the value and the option used inside the algorithm( exact or contains)
if i have multiple results i want to have all results
so we have 4 columns :
table
columns
row
value
Option search
i cant send you a database but you can create it on microsoft access quicly to test
i use the connector of pyodbc to acces to the base inside python (microsoft access driver)