def save_to_mysql(self, parm): code = 0 if isinstance(parm, list): parm.append(code) else: parm = list(parm) parm.append(code) res_code = connect(parm) print("存储状态", res_code)
def store_image(filename): img = open(filename, "rb") tablename = "image_table" query = "INSERT INTO " + tablename + "(uuid, content\ , uploadedby, uploadeddat) VALUES (%d, %s, '%s', '%s')" param = (row['uuid'], img, row['uploadedby'], row['uploadedat']) #TODO - connect to mysqldb and push in the image content in blob conn = mysqldb.connect("localhost", "root", "yoyo") cur = return
def fire(self): #starting server or sending data to it? action = self.action.get(0).stringValue() #port that node.js server is running on (String) port = self.port.get(0).stringValue() #Check input type if action == "start": #Start server self.startServer(port) #Wait one second for server to start time.sleep(1) #Check if node.js server is successfully running on port if self.pingServer(port): self.output.broadcast( StringToken("Node.js server running on port " + port)) else: self.output.broadcast( StringToken( "Unable to connect to node.js server on port " + port)) return elif action == "data": #a JSON object (as a String) with resolution and other metadata config = self.config.get(0).stringValue() #Get data from database conn = mysqldb.connect(host=self.db_host, user=self.db_user, passwd=self.db_pass, db=self.db_db) cursor = conn.cursor() cursor.execute("SELECT * FROM data WHERE simId = " + config.simId) data = cursor.fetchone() conn.close() #Send the config and data to the nodejs server with the specified port if self.sendToServer(port, config, data): self.output.broadcast(StringToken("Data sent to server")) else: self.output.broadcast( StringToken("Error sending data to server")) return
import mysqldb con = mysqldb.connect(db="estoque",user="******",passwd="",host="127.0.0.1") #com cursor podemos manipular o banco atraves de SQL (create, insert, select) cur = con.cursor() #inserir dados na tabela #sql = "insert into cidade (nome, uf) values ('Blumenau', 'SC')" #cur.execute(sql) #excluir #cur.execute("delete from cidade where coddig=7") #update (alterar) cur.execute("UPDATE cidade set nome='Rondopolis', uf='MT' where codigo=6") #pesquisa todos os registros de cidade sql = "select * from cidade" cur.execute(sql) #recuperando o resultado da pesquisa recset = cur.fetchall() #listando dados do banco for registros in recset: print("Código: %d, Nome da cidade: %s, UF: %s" %(registros[0], registros[1], registros[2]))
# https://forum.omz-software.com/topic/3334/mysql-in-pythonista/3 # Insert import mysqldb db = mysqldb.connect(host="mysql.my_domain.co.uk", user="******", passwd="my_password", db="my_database", port=3306) c = db.cursor() c.execute("INSERT INTO my_table (my_column1, my_column_2) VALUES (%s, %s)", (my_value_1, my_value_2)) db.commit() db.disconnect() # -------------------- # Select import mysqldb db = mysqldb.connect(host="mysql.my_domain.co.uk", user="******", passwd="my_password", db="my_database",
# coding: utf-8 # https://forum.omz-software.com/topic/1431/mysql-client/11 import mysqldb db = mysqldb.connect(host="http://my_host", user="******", passwd="password", db="my_database", port=3306) cursor = db.cursor()