2) Blob connector to get a specific blob- Action = Get Blob- Blob Path = The full path to the blob including container and file name. 3) HTTP Connector to take the content from the blob and post to a requestb.in. When the logic app runs, it fails on the blob GetBlob action (and of course the http action is then skipped) The input link json. 2018-10-11 mysql出错提示“BLOB/TEXT column used in key specification without a key length”解决办法 一、问题 pandas对象将DataFrame数据保存到mysql中时,出现错误提示: BLOB/TEXT column used in key specification without a key length.
Close ( )Let’s examine the code in detail:. First, we call the readfile function to read data from a file and return it. Second, we compose an that updates photo column for an author specified by authorid. The args variable is a tuple that contains file data and authorid. We will pass this variable to the execute method together with the query. Third, inside the try except block, we connect to the database, instantiate a cursor, and execute the query with args.
To make the change effective, we call commit method of the MySQLConnection object. Fourth, we close the cursor and database connection in the finally block.Notice that we imported MySQLConnection and Error objects from the MySQL Connector/Python package and readdbconfig function from the pythonmysqldbconfig module that we developed in.Let’s test the updateblob function. Close ( )The readblob function reads BLOB data from the authors table and write it into a file specified by the filename parameter.The code is straightforward:. First, we compose a that retrieves photo of a specific author. Second, we get the database configuration by calling the readdbconfig function.
Third, inside the try except block, we connect to the database, instantiate cursor, and execute the query. Once we got the BLOB data, we use the writefile function to write it into a file specified by the filename. Fourth, in the finally block, we close the cursor and database connection.Now, let’s test the readblob function.