Gevent sqlalchemy async access MySQL

1. Install mysql-connector

2. DB = create_engine ('mysql + mysqlconnector: // root: liukesun @ localhost/testdb ')

Gevent_sqlalchemy_test.py

 
#! /Usr/bin/pythonimport geventfrom gevent import monkey # patches stdlib (including socket and SSL modules) to cooperate with other greenletsmonkey. patch_all () Import usertabledef get_user_data (): Print "Starting get_user_data" usertable. get_data () print "End get_user_data. "# jobs = [gevent. spawn (print_head, URL) for URL in URLs] jobs = [gevent. spawn (get_user_data), gevent. spawn (get_user_data)] gevent. joinall (jobs)
 

Usertable. py

#! /Usr/bin/ENV pythonimport MySQL. connectormysql. connector. mysqlconnection. get_characterset_info = Lambda CLS: Cls. charsetfrom sqlalchemy import * DB = create_engine ('mysql + mysqlconnector: // root: liukesun @ localhost/testdb', Echo = false) Metadata = metadata (db) users = TABLE ('users', metadata, column ('user _ id', integer, primary_key = true), column ('name', string (40 )), column ('age', integer), column ('Password', string (40),) def get_data (): S = users. select () rs = s.exe cute () for row in RS: Print rowif _ name _ = '_ main _': Print "begin... "get_data () print" end."