how to configure cursor class for Flask-mysql

[hamzanaseem54345]

i tried adding as app.config['MYSQL_CURSOR'] = 'DictCursor' & app.config['MYSQL_DATABASE_CURSOR'] = 'DictCursor' but did not work please help confused.

[ghost]

Hi, part of my code is here. it works. i hope it can be useful:

#config mysql
mysql = MySQL()

app.config['MYSQL_DATABASE_HOST'] = "localhost"
app.config['MYSQL_DATABASE_PORT'] = 3306
app.config['MYSQL_DATABASE_USER'] = 'root'
app.config['MYSQL_DATABASE_PASSWORD'] = 'root'
app.config['MYSQL_DATABASE_DB'] = 'hiflaskdb'
#app.config['MYSQL_DATABASE_CHARSET'] = 'utf-8'
mysql.init_app(app)

@app.route('/register', methods=['GET','POST'])
def register():
	form = RegisterForm(request.form)
	if request.method=='POST' and form.validate():

		name = form.name.data
		email = form.email.data
		username=form.username.data
		password = sha256_crypt.encrypt(str(form.password.data))

		conn=mysql.connect()
		cursor = conn.cursor()
		cursor.execute("INSERT INTO users(name, email, username, password) VALUES(%s,%s,%s,%s)",(name, email, username, password))

		#commit to DB
		conn.commit()

		cursor.close()

		flash('You are registered and can log in!','success')

		return redirect(url_for('index'))


	return render_template('register.html', form=form)	

When i finished all crud operations i will publish my project you can look at on my github page:
https://github.com/kayace

[bbkane]

I need this too- @kayace we're trying to access the cursor types PyMySQL exposes ( specifically this one. Looking at the code, it doesn't appear to be possible. @cyberdelia would you accept a pull request if I added this?

[ghost]

send me taht, if i can help you, i will be happy. 2018-01-22 21:10 GMT+03:00 Benjamin Kane <notifications@github.com>:

…

I need this too- @kayace <https://github.com/kayace> we're trying to access the cursor types PyMySQL exposes ( specifically this one <http://pymysql.readthedocs.io/en/latest/modules/cursors.html#pymysql.cursors.DictCursor>. Looking at the code, it doesn't appear to be possible. @cyberdelia <https://github.com/cyberdelia> would you accept a pull request if I added this? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#28 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ALGBsyYZ6IBfErVO-WQgVXKA-ulKd69Eks5tNM8MgaJpZM4RInO-> .

-- Adnan KAYA adnankayace@gmail.com Blog <https://adnankayace.blogspot.com.tr/> Linkedin <https://www.linkedin.com/in/adnan-kaya-79b975144/> Github <https://github.com/kayace?tab=repositories>

[ghost]

send me that, if i can help you, i will be happy. 2018-01-22 21:15 GMT+03:00 adnan kaya <adnankayace@gmail.com>:

…

send me taht, if i can help you, i will be happy. 2018-01-22 21:10 GMT+03:00 Benjamin Kane ***@***.***>: > I need this too- @kayace <https://github.com/kayace> we're trying to > access the cursor types PyMySQL exposes ( specifically this one > <http://pymysql.readthedocs.io/en/latest/modules/cursors.html#pymysql.cursors.DictCursor>. > Looking at the code, it doesn't appear to be possible. @cyberdelia > <https://github.com/cyberdelia> would you accept a pull request if I > added this? > > — > You are receiving this because you were mentioned. > Reply to this email directly, view it on GitHub > <#28 (comment)>, > or mute the thread > <https://github.com/notifications/unsubscribe-auth/ALGBsyYZ6IBfErVO-WQgVXKA-ulKd69Eks5tNM8MgaJpZM4RInO-> > . > -- Adnan KAYA ***@***.*** Blog <https://adnankayace.blogspot.com.tr/> Linkedin <https://www.linkedin.com/in/adnan-kaya-79b975144/> Github <https://github.com/kayace?tab=repositories>

-- Adnan KAYA adnankayace@gmail.com Blog <https://adnankayace.blogspot.com.tr/> Linkedin <https://www.linkedin.com/in/adnan-kaya-79b975144/> Github <https://github.com/kayace?tab=repositories>

[bbkane]

@kayace what should I send you?

[ghost]

sorry my bad. you said: "would you accept a pull request if I added this?" I got it wrongly. My English :/ Can you tell me how can i help you ? 2018-01-22 21:18 GMT+03:00 Benjamin Kane <notifications@github.com>:

…

@kayace <https://github.com/kayace> what should I send you? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#28 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ALGBs2nLC-owafWgT0u0RC_G5pr2MLU6ks5tNNDrgaJpZM4RInO-> .

-- Adnan KAYA adnankayace@gmail.com Blog <https://adnankayace.blogspot.com.tr/> Linkedin <https://www.linkedin.com/in/adnan-kaya-79b975144/> Github <https://github.com/kayace?tab=repositories>

[bbkane]

@kayace I'm asking the maintainer (@cyberdelia ) if they will accept a pull request to implement this feature (adding a MYSQL_DATABASE_CURSOR_TYPE to the config's values so @h54345 and I can use DictCursor with our connections). I don't want to do the work and @cyberdelia not merge my new feature, so I want his blessing before I start. I wish you could help me, but I really need him. Thanks!

[cyberdelia]

@bbkane Sure.

[bbkane]

@cyberdelia I'll try to work on it this weekend

[bbkane]

Whoops, kinda forgot about that. Sorry