Tag Info

Hot answers tagged

1

I would write a python script that would, parse the columns descriptor file, get their widths and names iterate over all the data in the input file, splitting out the data into variables construct a sql query with these variables to the sql server with SQLAlchemy to be sent one by one or as a batch of rows or 1000 at a time This script would take the ...


1

What's below works for your data - be careful of any variation in the field width - that's why delimited files are better - csv, or better still, if you can get it, pipe-delimited (|). It also successfully deals with the header line. I did the following: My code will do for both MD5 and SHA2 passwords - uncomment the relevant bits. CREATE TABLE my_user ( ...



Only top voted, non community-wiki answers of a minimum length are eligible