Das deutsche Python-Forum

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;      
                                 

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")
...

Code: Alles auswählen

#!/usr/bin/env python3
from RPi import GPIO
import mysql.connector
import mysql.connector.errors
from contextlib import closing

but1 = 19
ton = 26

def read()
    ### Code um reader ab zu fragen
    reader = SimpleMFRC522()  
    try:  
        id, text = reader.read() 
        print(id)  
        print(text)  
    finally:  
        GPIO.cleanup() 

def intdb1():
    mydb = mysql.connector.connect(
      host="localhost",
      user="pi",
      password="raspberry",
      database="svwi"
    )
return mydb

def intbl1_database(mydb):
    with closing(mydb.cursor()) as cursor:
        cursor.execute("INSERT INTO tbl1 (ftbl1) VALUES (%s)",["1",])
            mydb.commit()
            return "Eintrag"

ef intbl2_database(mydb):
    with closing(mydb.cursor()) as cursor:
        cursor.execute("INSERT INTO tbl2 (ftbl2)) VALUES (%s)",["1",])
            mydb.commit()
            return "Eintrag"

def main():
    if but1.is_pressed:
        ### führe hier ein Code aus wenn Button gedrückt ist
        mydb = intdb1()
        read()
        ### Habe ich hier die ID noch ?
        Falls Ja dann weiter
        result = intbl2_database(mydb)
    elif but2.is_pressed:
        ### führe hier ein Code aus wenn Button gedrückt ist
        mydb = intdb1()
        read()
        ### Habe ich hier die ID noch ?
        Falls Ja dann weiter
    else:
        ### sonst führe diesen Code aus
        mydb = int1()
        read()
        ### Habe ich hier die ID noch ?
        Falls Ja dann weiter
        result = intbl1_database(mydb)

if __name__ == "__main__":
    main()