Advertisement
Guest User

DB til DB

a guest
May 19th, 2018
150
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.42 KB | None | 0 0
  1. import pymysql
  2.  
  3.  
  4. # aaben Rossmann database
  5. def open_db():
  6. database_tyskland = pymysql.connect(user='root',
  7. password='max123',
  8. host='127.0.0.1',
  9. database='Rossmann')
  10.  
  11.  
  12. cursor = database_tyskland.cursor()
  13. # vaelg vilken data vi vil havde
  14. cursor.execute("select * from Filialen")
  15. data = cursor.fetchall()
  16. # test
  17. # for row in data :
  18. # print row [2]
  19.  
  20. # vaelg vores ejen database
  21. conn = pymysql.connect(user='root',
  22. password='max123',
  23. host='127.0.0.1',
  24. database='tyskdb')
  25.  
  26. c = conn.cursor()
  27.  
  28.  
  29. # forlykke til at splitte rossmann's database
  30. for row in data:
  31. name = row[0]
  32. adresse = row[2].split(", ")[0]
  33. zipcode = row[2].split(", ")[1][:5]
  34. zipcode_area =row[2].split(", ")[1][6:]
  35.  
  36.  
  37.  
  38.  
  39. # tilfoej til egen database
  40. c.execute("INSERT INTO Konkurent_database (Name, Zipcode, Zipcode_Area, Adresse) VALUES (%s, %s,%s, %s)",
  41. (name, zipcode, zipcode_area, adresse))
  42.  
  43.  
  44. # lukke begge database forbindelser
  45. database_tyskland.commit()
  46. database_tyskland.close()
  47. conn.commit()
  48. conn.close()
  49.  
  50. # koore deffinationen
  51. open_db()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement