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()