Insert each string values to table SQL using flask

Question

I have string value like:

test.test.com
atest.com
btest.com
ctest.com

I want to insert them into Database table like: DB Example

I tried this:

@flask.route('/domain_settings', methods=['GET', 'POST'])
def domain_settings():
   ss = (s.replace(' ', ''))
   print(ss)
   # test.test.com
   # atest.com
   # btest.com
   # ctest.com
   cur = mysql.connection.cursor()
   cur.execute('INSERT INTO domain (domain_name) VALUES (%s)', [ss])
   mysql.connection.commit()
   cur.close()

But it insert them into one row like: db

How can i achieve that?

if that is a single string value and you are using a single insert statement, then isn't the inserted value correct ? — heretolearn
– heretolearn, Commented Jul 26, 2021 at 14:19
if you want to insert each line as a row, you should split into different elements, then either do a batch insert or loop overt the split list and insert them. — heretolearn
– heretolearn, Commented Jul 26, 2021 at 14:21

Chayan Bansal · Accepted Answer · 2021-07-26 14:38:22Z

1

You can try split method and split the string on "\n" and then insert the values in a for loop.

@flask.route('/domain_settings', methods=['GET', 'POST'])
def domain_settings():
   s_list = s.split('\n') 
   cur = mysql.connection.cursor()
   for domain in s_list:
       cur.execute('INSERT INTO domain (domain_name) VALUES (%s)', [domain])
   mysql.connection.commit()
   cur.close()

answered Jul 26, 2021 at 14:38

Chayan Bansal

2,1051 gold badge16 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert each string values to table SQL using flask

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related