Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pymysql
- # aaben Rossmann database
- def open_db():
- database_tyskland = pymysql.connect(user='root',
- password='max123',
- host='127.0.0.1',
- database='Rossmann')
- cursor = database_tyskland.cursor()
- # vaelg vilken data vi vil havde
- cursor.execute("select * from Filialen")
- data = cursor.fetchall()
- # test
- # for row in data :
- # print row [2]
- # vaelg vores ejen database
- conn = pymysql.connect(user='root',
- password='max123',
- host='127.0.0.1',
- database='tyskdb')
- c = conn.cursor()
- # forlykke til at splitte rossmann's database
- for row in data:
- name = row[0]
- adresse = row[2].split(", ")[0]
- zipcode = row[2].split(", ")[1][:5]
- zipcode_area =row[2].split(", ")[1][6:]
- # tilfoej til egen database
- c.execute("INSERT INTO Konkurent_database (Name, Zipcode, Zipcode_Area, Adresse) VALUES (%s, %s,%s, %s)",
- (name, zipcode, zipcode_area, adresse))
- # lukke begge database forbindelser
- database_tyskland.commit()
- database_tyskland.close()
- conn.commit()
- conn.close()
- # koore deffinationen
- open_db()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement