Python python_mysql_dbconfig.read_db_config函数代码示例

OGeek|极客世界-中国程序员成长平台 › 门户 › 编程› Python›Python编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了Python中python_mysql_dbconfig.read_db_config函数的典型用法代码示例。如果您正苦于以下问题：Python read_db_config函数的具体用法？Python read_db_config怎么用？Python read_db_config使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了read_db_config函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的Python代码示例。

示例1: create_user

def create_user():
	print ('create')
	data = request.json	
	browser = data['browser']
	ip = data['ip']
			
	query = "SELECT COUNT(*) FROM users WHERE browser = %s AND ip = %s"
	try:		
		dbconfig = read_db_config()
		conn = MySQLConnection(**dbconfig)
		cursor = conn.cursor()
		cursor.execute(query, (browser, ip),)
		count = cursor.fetchone()
		count = count[0]
	except Error as e:
		print(e)
	finally:
		cursor.close()
		conn.close()
	if count != 0:
		query = "SELECT id FROM users WHERE browser = %s AND ip = %s"
		try:		
			dbconfig = read_db_config()
			conn = MySQLConnection(**dbconfig)
			cursor = conn.cursor()
			cursor.execute(query, (browser, ip),)
			id = cursor.fetchone()
		except Error as e:
			print(e)
		finally:
			cursor.close()
			conn.close()
		#if user already exist return his id
		return jsonify({'state': 'fail', 'index' : id}) 
	
	#if user is not exist add him to db
	query = "INSERT INTO users (date, browser, ip) VALUES (%s, %s, %s)"    
	date = datetime.now()
	try:
		db_config = read_db_config()
		conn = MySQLConnection(**db_config)
		cursor = conn.cursor()
		cursor.execute(query, (date, browser, ip, ),)
		conn.commit()
	except Error as error:
		print(error)
	finally:
		cursor.close()
		conn.close()				
	return jsonify({'state': 'OK'})

开发者ID:navigator3228，项目名称:netlabs，代码行数:50，代码来源:server.py

示例2: insert_user

def insert_user(name, password, email):
    query = "INSERT INTO users(username, password, email) " \
            "VALUES(%s,%s,%s)"

    args = (name, password, email)
 
    try:
        db_config = read_db_config()
        conn = MySQLConnection(**db_config)
 
        cursor = conn.cursor()
        cursor.execute(query, args)
 
        if cursor.lastrowid:
            print('last insert id', cursor.lastrowid)
        else:
            print('last insert id not found')
 
        conn.commit()
    except Error as error:
        print(error)
 
    finally:
        cursor.close()
        conn.close()

开发者ID:yxnely，项目名称:practice-flask，代码行数:25，代码来源:python_mysql_dbinsert.py

示例3: insert_book

def insert_book(title, isbn):
    query = "INSERT INTO books(title, isbn) " "VALUES(%s, %s)"

    args = (title, isbn)

    try:
        db_config = read_db_config()
        conn = MySQLConnection(**db_config)

        cursor = conn.cursor()
        cursor.execute(query, args)

        if cursor.lastrowid:
            print ("last insert id", cursor.lastrowid)
        else:
            print ("last insert id not found")

        conn.commit()

    except Error as error:
        print error

    finally:
        cursor.close()
        conn.close()

开发者ID:Angadlamba，项目名称:comicBio，代码行数:25，代码来源:python_mysql_insert.py

示例4: update_book

def update_book(book_id, title):
    # read database configuration
    db_config = read_db_config()
 
    # prepare query and data
    query = """ UPDATE books
                SET title = %s
                WHERE id = %s """
 
    data = (title, book_id)
 
    try:
        conn = MySQLConnection(**db_config)
 
        # update book title
        cursor = conn.cursor()
        cursor.execute(query, data)
 
        # accept the changes
        conn.commit()
 
    except Error as error:
        print(error)
 
    finally:
        cursor.close()
        conn.close()

开发者ID:DanielAvelar，项目名称:Python，代码行数:27，代码来源:query_update_one_row.py

示例5: insert_name

def insert_name(name, gender):
    query = "INSERT INTO babynames(babyName, gender) " \
            "VALUES(%s,%s)"

    args = (name, gender)
 
    try:
        db_config = read_db_config()
        conn = MySQLConnection(**db_config)
 
        cursor = conn.cursor()
        cursor.execute(query, args)
 
        if cursor.lastrowid:
            print('last insert id', cursor.lastrowid)
        else:
            print('last insert id not found')
 
        conn.commit()
    except Error as error:
        print(error)
 
    finally:
        cursor.close()
        conn.close()

开发者ID:yxnely，项目名称:practice-flask，代码行数:25，代码来源:python_mysql_dbinsert2.py

示例6: login_page

def login_page():
    error = ''
    gc.collect()
    try:
        dbconfig = read_db_config()
        conn = MySQLConnection(**dbconfig)
        cur = conn.cursor()
        if request.method == "POST":
            query = ("""SELECT * FROM users WHERE username = %s""")
            cur.execute(query, (request.form['username'],))
            userpw = cur.fetchone()[2]

            if sha256_crypt.verify(request.form['password'], userpw):
                session['logged_in'] = True
                session['username'] = request.form['username']
                session['user-ip'] = request.remote_addr
                if session['username'] == 'admin':
                    flash(Markup('The Dark Knight&nbsp;&nbsp;<span class="glyphicon glyphicon-knight"></span>'))
                else:
                    flash('Logged In')
                return redirect(url_for('blog'))
            else:
                error = "Invalid Credentials. Please try again."

        gc.collect()

        return render_template('login.html', error = error)

    except Exception as e:
        error = 'Invalid Credentials. Please try again.'
        return render_template('login.html', error = error)

开发者ID:dawoudt，项目名称:dawoudt.com，代码行数:31，代码来源:__init__.py

示例7: insert_imei

def insert_imei(query, args):

    try:
        db_config = read_db_config()
        conn = MySQLConnection(**db_config)

        cursor = conn.cursor()
        cursor.execute(query, args)

        if cursor.lastrowid:
            mensaje = ('Last insert id: %s' % (cursor.lastrowid,) )
            print(mensaje)
        else:
           mensaje = 'Last insert id not found'

        conn.commit()
        
    
    except Error as error:
        print(error)

    finally:
        cursor.close()
        conn.close()
        
    return mensaje

开发者ID:richpolis，项目名称:ServerAndClient，代码行数:26，代码来源:insert_imei.py

示例8: input_data

def input_data():

    for x in range(len(gabungan)):
        gabungan[x]

    query = "INSERT INTO data_test " 
    nilai = "VALUES (\"\"," + "\"" + file + "\"" + ","
    for x in range(len(gabungan)):
        nilai = nilai + str(gabungan[x])
        if x < len(gabungan)-1 :
            nilai = nilai + ", " 
            
    query = query + nilai + ")"
#    print query
        
    try:
        db_config = read_db_config()
        conn = MySQLConnection(**db_config)
 
        cursor = conn.cursor()
        cursor.execute(query)
 
        conn.commit()
    except Error as e:
        print('Error:', e)
 
    finally:
        cursor.close()
        conn.close()

开发者ID:bubgum，项目名称:image-processing，代码行数:29，代码来源:kombinasi.py

示例9: insert_character

def insert_character(char_id, name, realname, gender, origin, image, siteurl, deck):
	query = "INSERT INTO characters(id, name, realname, gender, origin, image, siteurl, deck) " \
			"VALUES(%s, %s, %s, %s, %s, %s, %s, %s)"  

	args = (char_id, name, realname, gender, origin, image, siteurl, deck)

	try:
		db_config = read_db_config()
		conn = MySQLConnection(**db_config)

		cursor = conn.cursor()
		cursor.execute(query, args)
		
		if cursor.lastrowid:
			print('last insert id', cursor.lastrowid)
		else:
			print('last insert id not found')

		conn.commit()

	except Error as error:
		print error

	finally:
		cursor.close()
		conn.close()

开发者ID:Angadlamba，项目名称:comicBio，代码行数:26，代码来源:character_insert.py

示例10: init

    def __init__(self):
        self.current_job_id = 0
        self.current_job_count = 0
        self.job_list = dict()
        self.node_list = dict()
        self.section_list = dict()
        self.acc_type_list = dict() # <acc_name:acc_bw>
        self.node_list = dict() # <node_ip: PowerNode>
        self.job_list = dict()

        self.dbconfig = read_db_config()
        self.conn = MySQLConnection(**self.dbconfig)

开发者ID:xiansl，项目名称:mytests，代码行数:12，代码来源:python_scheduler.py

示例11: init

 def __init__(self, fpga_node_num, total_node_num):
     self.dbconfig = read_db_config()
     self.conn = MySQLConnection(**self.dbconfig)
     self.acc_type_list = dict()
     self.total_node_num = total_node_num
     self.fpga_node_num = fpga_node_num
     self.each_section_num = 4
     self.acc_type_list[0] = ('1','acc0','EC','1200','1')
     self.acc_type_list[1] = ('2','acc1','AES','1700','1')
     self.acc_type_list[2] = ('3','acc2','FFT','1200','1')
     self.acc_type_list[3] = ('4','acc3','DTW','1200','1')
     self.acc_type_list[4] = ('5','acc4','SHA','150','0')
     self.acc_type_num = len(self.acc_type_list)

开发者ID:zhuangdizhu，项目名称:simulator，代码行数:13，代码来源:set_system.py

示例12: post

    def post(self):
        try:
            
            db_config = read_db_config()
            conn = MySQLConnection(**db_config)
            cursor = conn.cursor()
            cursor.callproc('sp_insertmember')

        except Error as e :
            return {'error': str(e)}
        finally:
            cursor.close()
            conn.close()

开发者ID:adriancherng，项目名称:EMBAmeetup，代码行数:13，代码来源:app.py

示例13: read_db

def read_db():
    try:
        dbconfig = read_db_config()
        conn = MySQLConnection(**dbconfig)
        cursor = conn.cursor()
        cursor.execute("SELECT * FROM temperature;")
        row = cursor.fetchone()
        while row is not None:
            print(row)
            row = cursor.fetchone()
    finally:
        cursor.close()
        conn.close()

开发者ID:fgjhhkfk，项目名称:Python_playground，代码行数:13，代码来源:test_db.py

示例14: search

def search():
    try:
        dbconfig = read_db_config()
        conn = MySQLConnection(**dbconfig)
        cursor = conn.cursor()
        cursor.execute("SELECT * FROM data_train")
        #row_train = cursor.fetchone()
        data_train =  list(cursor)
            
        cursor = conn.cursor()
        cursor.execute("SELECT * FROM data_test")
        data_test = list(cursor)
        
        
        index1 = 0
        for x in range(len(data_train)) :
        
            canbera = 0
            index2 = 2
            
            for y in range(82):                
                temp1 = (data_test[0][index2] - data_train[index1][index2]) 
                temp2 = (data_test[0][index2] + data_train[index1][index2])

                #print "temp1 "+str(temp1)
                #print "temp2 "+str(temp2)
                                
                if temp2 == 0 :
                    hasil_temp = abs(temp1)
                else :
                    hasil_temp = float(abs(temp1)) / float(temp2)
                
                #print "hasil temp = " + str(hasil_temp)
                canbera = float(canbera) + float(hasil_temp)
                
                index2 += 1
            index1+=1
            
            print canbera
        
            
        #for x in range(len(gabungan)):
            #row_train[x]
        
 
    except Error as e:
        print(e)
 
    finally:
        cursor.close()
        conn.close()

开发者ID:bubgum，项目名称:image-processing，代码行数:51，代码来源:kombinasi.py

示例15: init

    def __init__(self, scheduling_algorithm):
        self.scheduling_algorithm = scheduling_algorithm
        self.current_job_count = 0
        self.job_list = dict()
        self.node_list = dict()
        self.section_list = dict()
        self.acc_type_list = dict() # <acc_name:acc_bw>
        self.node_list = dict() # <node_ip: PowerNode>
        self.job_list = dict()
        self.job_waiting_list = dict()#<job_id: weight> could be arrival time, execution time, etc;

	self.epoch_time = time.time()
        self.dbconfig = read_db_config()
        self.conn = MySQLConnection(**self.dbconfig)

开发者ID:xiansl，项目名称:mytests，代码行数:14，代码来源:new_scheduler.py

示例16: insert_many

def insert_many(entry):
    query = "insert into test(name, class, skills) values(%s, %s, %s)"
    try:
        db_config = read_db_config()
        conn = MySQLConnection(**db_config)

        cursor = conn.cursor()
        cursor.executemany(query, entry)
        conn.commit()
    except Error as e:
        print "[SOMETHING BAD HAPPEND!]",e
    finally:
        cursor.close()
        conn.close()

开发者ID:saqibmubarak，项目名称:Python_Workshop，代码行数:14，代码来源:mysql_insert.py

示例17: get_users_one_month

def get_users_one_month():
	count = 0
	try:
		dbconfig = read_db_config()
		conn = MySQLConnection(**dbconfig)
		cursor = conn.cursor()
		cursor.execute("SELECT COUNT(*) FROM users")
		count = cursor.fetchone()
	except Error as e:
		print(e)
	finally:
		cursor.close()
		conn.close()
	count = count[0]
	return jsonify({'count': count})

开发者ID:navigator3228，项目名称:netlabs，代码行数:15，代码来源:server.py

示例18: update_user

def update_user(user_id):
	db_config = read_db_config()
	query = "UPDATE users SET date = %s WHERE id = %s"
	date = datetime.now()
	try:
		conn = MySQLConnection(**db_config)
		cursor = conn.cursor()
		cursor.execute(query, (date, user_id,),)
		conn.commit()
	except Error as error:
		print(error)
	finally:
		cursor.close()
		conn.close()
	return jsonify({'update': 'OK'})

开发者ID:navigator3228，项目名称:netlabs，代码行数:15，代码来源:server.py

示例19: init

 def __init__(self, mean):
     self.dbconfig = read_db_config()
     self.conn = MySQLConnection(**self.dbconfig)
     self.acc_type_list = ['acc0','acc1','acc2','acc3','acc4']
     self.job_size_list = ['1','1','0.3','0.5','2']
     self.job_node_list = list()
     self.fpga_available_node_list = list()
     self.fpga_non_available_node_list = list()
     self.acc_bw_list = dict()
     self.poisson_interval_mean = mean
     self.exponential_interval_mean = mean
     for acc_id in self.acc_type_list:
         self.acc_bw_list[acc_id] = '1.2'
         if acc_id == 'acc4':
             self.acc_bw_list[acc_id] = '0.15'

开发者ID:xiansl，项目名称:mytests，代码行数:15，代码来源:set-job-mysql.py

示例20: query_with_fetchmany

def query_with_fetchmany():
	print "FetchMany...........\n"
	try:
		db_config = read_db_config()
		conn  = MySQLConnection(**db_config)
		cursor = conn.cursor()
		cursor.execute('select * from test')

		for row in iter_rows(cursor, 10):
			print row
	except Error as e:
		print "[SOMETHING BAD HAPPEND ]", e
	finally:
		conn.close()
		cursor.close()

开发者ID:saqibmubarak，项目名称:Python_Workshop，代码行数:15，代码来源:python_mysql_query.py

注：本文中的python_mysql_dbconfig.read_db_config函数示例由纯净天空整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

Python python_qt_binding.loadUi函数代码示例发布时间：2022-05-27

Python python_digest.validate_nonce函数代码示例发布时间：2022-05-27

Python util.grid_equal函数代码示例

1 Python 入门教程

Python入门教程 Python 是一种解释型、面向对象、动态数据类型的高级程序设计语言。 P

阅读：13812|2022-01-22

2 Python wikiutil.getFrontPage函数代码示例

Python wikiutil.getFrontPage函数代码示例

阅读：10205|2022-05-24

3 Python 简介

Python 简介 Python 是一个高层次的结合了解释性、编译性、互动性和面向对象的脚本

阅读：4092|2022-01-22

4 Python tests.group函数代码示例

Python tests.group函数代码示例

阅读：4045|2022-05-27

5 Python util.check_if_user_has_permission

Python util.check_if_user_has_permission函数代码示例

阅读：3845|2022-05-27

6 Python 操练实例98

Python 练习实例98 Python 100例题目：从键盘输入一个字符串，将小写字母全部转换成大

阅读：3515|2022-01-22

7 Python 环境搭建

Python 环境搭建本章节我们将向大家介绍如何在本地搭建 Python 开发环境。 Py

阅读：3032|2022-01-22

8 Python output.darkgreen函数代码示例

Python output.darkgreen函数代码示例

阅读：2655|2022-05-25

9 Python 基础语法

Python 基础语法 Python 语言与 Perl，C 和 Java 等语言有许多相似之处。但是，也

阅读：2651|2022-01-22

10 Python 中文编码

Python 中文编码前面章节中我们已经学会了如何用 Python 输出 Hello, World!，英文没

阅读：2303|2022-01-22

客服电话

电子邮件

Python python_mysql_dbconfig.read_db_config函数代码示例

示例1: create_user

示例2: insert_user

示例3: insert_book

示例4: update_book

示例5: insert_name

示例6: login_page

示例7: insert_imei

示例8: input_data

示例9: insert_character

示例10: __init__

示例11: __init__

示例12: post

示例13: read_db

示例14: search

示例15: __init__

示例16: insert_many

示例17: get_users_one_month

示例18: update_user

示例19: __init__

示例20: query_with_fetchmany

请发表评论

全部评论

上一篇：

下一篇：

Python util.grid_equal函数代码示例

Python util.get_worker_name函数代码示例

Python util.get_webmention_target函数代

Python util.get_uuid函数代码示例

Python util.get_type_by_name函数代码示例

Python util.grid_equal函数代码示例

Python util.get_worker_name函数代码示例

Python util.get_webmention_target函数代

Python util.get_uuid函数代码示例

Python util.get_type_by_name函数代码示例

Python util.get_stdout函数代码示例

关于我们

产品与服务

解决方案

139-2527-9053

示例10: init

示例11: init

示例15: init

示例19: init