seimit
commented
2 years ago Hi Jack, The goal of this project was to convert the stdf file into pandas format in HDF5 file container for easily manipulation with Python data processing tools later on. Currently I do not have time to add stdf to sql feature. But if you have time and knowledge to implement it, I will happy to add this feature in the code. Have a nice day! Seimit
Probing to see if there's any interest to expanding upon this package to have a stdf2sql module. Rather than passing a folder destination, you would pass a connection (maybe using a SQLAlchemy engine to make it as widely compatible with most relational database implementations). I have a use case where this would be useful. In Metis' current state, one would need to extract/save the records as csvs, then read in and push the csvs to a database connection. Would make sense to cut out the middle steps and insert records as one traverses through the file. The stdf_input_file string would need to be the only added column across tables for primary key purposes.