Hier was ich mir vorstelle
Code: Alles auswählen
db1 = MySQLdb.connect(host = "192.168.1.26",
user = "user",
passwd = "passwd",
db = "zoo")
cur1 = db1.cursor()
z= cur1.execute("SELECT * FROM zoo")
db2 = MySQLdb.connect(host = "192.168.1.28",
user = "user",
passwd = "passwd",
db = "zoo")
cur2 = db2.cursor()
y= cur2.execute("SELECT * FROM zoo")
CREATE TABLE IF NOT EXISTS `logo` (
`id` int(255) unsigned NOT NULL COMMENT 'ID',
`db` varchar(255) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
INSERT INTO `logo` (`db`) VALUES ('1f4ca71c5b3b2be902a5ed34e61ec4d7');
ALTER TABLE `logo` ADD PRIMARY KEY (`id`);
ALTER TABLE `logo` MODIFY `id` int(255) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',AUTO_INCREMENT=2;
Hier wie ich am Script denke
Code: Alles auswählen
...
if z == 1:
db = MySQLdb.connect(host = "192.168.1.26", user = "user", passwd = "passwd", db = "zoo")
elif y == 1:
db = MySQLdb.connect(host = "192.168.1.28", user = "user", passwd = "passwd", db = "zoo")
else:
db = MySQLdb.connect(host = "localhost", user = "user", passwd = "passwd", db = "zoo")
...
...
print ("Hugo will Bier")
...
Bzw kann ich wie oben am Anfang weiter schreiben oder muß ich den abstand halten ?