Python db.create_engine函数代码示例

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

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

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

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

示例1: generate_tables

def generate_tables():
    if not db.engine:
        db.create_engine('awesome.db')
    
    sql = lambda x:''.join(x().__sql__.split('\n')[1:])   
    db.update(sql(User))
    db.update(sql(Blog))
    db.update(sql(Comment))

开发者ID:Charles-Lau-，项目名称:awesome_python_app，代码行数:8，代码来源:models.py

示例2: User

#!/usr/bin/env python
# -*- coding:utf-8 -*-

from models import User,Blog,Comment
from transwarp import db

db.create_engine(user='root',password='qwerty',database='awesome-webapp')
u = User(name='Test',email='[email protected]',password='123456',image='about:blank')
u.insert()
print 'new user id:',u.id

u1 = User.find_first('where email=?','[email protected]')
print 'find user\'s name:',u1.name

u1.delete()

u2 = User.find_first('where email=?', '[email protected]')
print 'find user:', u2

开发者ID:wenhuwang，项目名称:awesome-webapp，代码行数:18，代码来源:test_db.py

示例3: connect_db

def connect_db():
    import transwarp.db as dbutil
    dbutil.create_engine('sonic513', 'sonic513', 'co2_monitor', port=3306)

开发者ID:hazelor，项目名称:COO_new，代码行数:3，代码来源:setting_create_tables.py

示例4: WSGIApplication

'''
A WSGI application entry.
'''

import logging; logging.basicConfig(level=logging.INFO)

import os

from transwarp import db
from transwarp.web import WSGIApplication, Jinja2TemplateEngine

from config import configs

# init db:
db.create_engine(**configs.db)

# init wsgi app:
wsgi = WSGIApplication(os.path.dirname(os.path.abspath(__file__)))

template_engine = Jinja2TemplateEngine(os.path.join(os.path.dirname(os.path.abspath(__file__)), 'templates'))

wsgi.template_engine = template_engine

import urls

wsgi.add_interceptor(urls.user_interceptor)
wsgi.add_interceptor(urls.manage_interceptor)
wsgi.add_module(urls)

if __name__ == '__main__':

开发者ID:Spacebody，项目名称:ProfStudSystem，代码行数:30，代码来源:wsgiapp.py

示例5:

#!/usr/bin/env python
# -*- coding: utf-8 -*-

from transwarp import db

db.create_engine(user='root', password='', database='test', host='127.0.0.1', port='3307')

开发者ID:amylovesong，项目名称:python，代码行数:6，代码来源:test_transwarp_db.py

示例6: User

#!/usr/bin/env python
# -*- coding: utf-8 -*-

__author__ = 'Wang Shaohua'

from models import User
from transwarp import db


db.create_engine(user='wshh08', password='2910', database='awesome')


u = User(name='Test', email='[email protected]', password='1234567890', image='about:blank')


u.insert()


print 'new user id:', u.id


u1 = User.find_first('where email=?', '[email protected]')
print 'find user\'s name:', u1.name


# u1.delete()


u2 = User.find_first('where email=?', '[email protected]')
print 'find user:', u2

开发者ID:wshh08，项目名称:awesome-python-webapp，代码行数:30，代码来源:test_db.py

示例7: delete

        pk = self.__primary_key__.name
        args.append(getattr(self, pk))
        db.update('update `%s` set %s where %s=?' % (self.__table__, ','.join(L), pk), *args)
        return self

    def delete(self):
        self.pre_delete and self.pre_delete()
        pk = self.__primary_key__.name
        args = (getattr(self, pk), )
        db.update('delete from `%s` where `%s`=?' % (self.__table__, pk), *args)
        return self

    def insert(self):
        self.pre_insert and self.pre_insert()
        params = {}
        for k, v in self.__mappings__.iteritems():
            if v.insertable:
                if not hasattr(self, k):
                    setattr(self, k, v.default)
                params[v.name] = getattr(self, k)
        db.insert('%s' % self.__table__, **params)
        return self

if __name__=='__main__':
    logging.basicConfig(level=logging.DEBUG)
    db.create_engine('www-data', 'www-data', 'test')
    db.update('drop table if exists user')
    db.update('create table user (id int primary key, name text, email text, passwd text, last_modified real)')
    import doctest
    doctest.testmod()

开发者ID:ethan8621，项目名称:Alvin，代码行数:30，代码来源:orm.py

示例8: User

from models import User, Blog, Comment
import logging

from transwarp import db

logging.basicConfig(level = logging.DEBUG)

db.create_engine(user = 'root', password = 'password', database = 'myblog')

u = User(name='Test', email='[email protected]', password='1234567890', image='about:blank')

u.insert()

print 'new user id:', u.id
print 'create time:', u.created_at

u1 = User.find_first('where email=?', '[email protected]')
print 'find user\'s name:', u1.name

u1.delete()

u2 = User.find_by('where email=?', '[email protected]')

print 'find user:', u2

开发者ID:Rain94，项目名称:myblog，代码行数:24，代码来源:teat_model.py

示例9: User

#coding:utf8

from models import User, Blog, Comment
from transwarp import db

#开启数据库引擎，连接数据库
db.create_engine(user='root', password='123456', database='test')

#实例化一个user类，做好形成表格的准备，进行初始化Model类--》ModelMetalClass采集属性字段,然后通过Model类的函数来进行表格数据操作
u = User(name='Test', email='[email protected]', password='123456', image='about:blank', admin=False)

print User().__sql__()

#形成表格之前，判断此表格是否存在，存在下drop
db.update('drop table if exists user')

#形成表格后进行字段栏的构建,手写创建表的sql脚本
#db.update('create table user (id varchar(50) primary key, email text, password text, admin text, name text, image text, create_at float)')
#表比较多话，用Model对象通过脚本直接生成sql脚本
db.update(User().__sql__())

#字段栏形成后，进行数据的插入
u.insert()

print 'new user id:', u.id

#查询
u1 = User.find_first('where email=?', '[email protected]')
print 'find user\'s name:', u1.name

#删除

开发者ID:SmallPuddingComing，项目名称:mylearn，代码行数:31，代码来源:test_db.py

示例10: isinstance

#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

__author__ = 'Jeffwu'

from models import User, Blog, Comment
from transwarp.orm import StringField,Field

from transwarp import db

db.create_engine(user='root', passwd='', database='awesome')

u = User(name='Test', email='[email protected]', passwd='1234567890', image='about:blank')

print isinstance(u.name,StringField)


#u.insert()

#print 'new user id:', u.id

#u1 = User.find_first('where email=?', '[email protected]')
#print 'find user\'s name:', u1.name

#u1.delete()

开发者ID:X010，项目名称:python-awe，代码行数:30，代码来源:test_db.py

示例11: User

'''
Created on Jun 11, 2016

@author: zlp
'''
from models import User, Blog, Comment
from transwarp import db
import logging

db.create_engine(user='root', password='6129544', database='awesome')
u = User(name='Test', email='[email protected]', password='123456', image='about:blank')
# it can only be inserted once, in the DB, Email column is distinct, if insert multiple time, it will return error message.
try:
    u.insert()
except Exception,e:
    logging.warning('It seems that the same user has been inserted, %s' % e)
print 'new user id:', u.id
 
#Here I add to print the cls name
u1 = User.find_first('where email=?', '[email protected]')
print u1

开发者ID:blackboarddd，项目名称:PyTest，代码行数:21，代码来源:test_db.py

示例12: User

# -*- coding: utf-8 -*-

__author__ = 'ghost'

from models import User, Blog, Comment
from transwarp import db

db.create_engine(user='root', passwd='', db='webapp')

u = User(email='[email protected]', passwd='111111', admin=True, nickname='rsj217', avatar='')
print u
u.insert()
# uu = User.find_by("WHERE admin=1")
# print uu[0].passwd

开发者ID:rsj217，项目名称:python-webapp，代码行数:14，代码来源:test_db.py

示例13: User

#!/usr/bin/env python
# -*- coding: utf-8 -*-

__author__ = 'tiger'


from models import User, Blog, Comment

from transwarp import db

db.create_engine(user='root', password='tiger', database='awesome')

u = User(name='Test', email='[email protected]', password='1234567890', image='about:blank')

u.insert()

print 'new user id:', u.id

u1 = User.find_first('where email=?', '[email protected]')
print 'find user\'s name:', u1.name

# u1.delete()
#
# u2 = User.find_first('where email=?', '[email protected]')
# print 'find user:', u2

开发者ID:jappre，项目名称:mutation，代码行数:25，代码来源:test_db.py

示例14: test

formatter = logging.Formatter('%(asctime)s %(name)-12s %(levelname)-8s %(message)s')
console.setFormatter(formatter)
# 将定义好的console日志handler添加到root logger
logging.getLogger('').addHandler(console)

from models import User, Blog, Comment

from transwarp import db


@db.with_transaction
def test():
    u = User(name='Test', email='[email protected]', password='1234567890', image='about:blank')

    u.insert()

    print 'new user id:', u.id

    u1 = User.find_first('where email=?', '[email protected]')
    print 'find user\'s name:', u1.name

    u1.delete()

    u2 = User.find_first('where email=?', '[email protected]')
    print 'find user:', u2


if __name__ == '__main__':
    db.create_engine(user='mysql', password='mysql', database='awesome')
    test()
    print time.time() , time.strptime()

开发者ID:jy00464346，项目名称:mytest-python-webapp，代码行数:31，代码来源:test_db.py

示例15: User

#!/usr/bin/env python

from models import User,Blog,Comment

from transwarp import db

import logging

if __name__ == '__main__':
    logging.basicConfig(level=logging.INFO)

    db.create_engine(user='edison',password='654321',database='awesome')
    u = User(name='Test',email='[email protected]',passwd='987654321',image='about:blank')
    u.insert()

    print 'new user id:',u.id

    u1 = User.find_first('where email=?','[email protected]')
    print 'find user\'s name:',u1.name

    u1.delete()

    u2 = User.find_first('where email=?','[email protected]')
    print 'find user\'s name:',u2.name

开发者ID:xinedison，项目名称:myweb，代码行数:24，代码来源:test_db.py

示例16: hasattr

#!/usr/bin/env python
# -*- coding: utf-8 -*-

from models import User, Blog, Comment

from transwarp import db
db.create_engine(user='root', password='xjzh256874', database='xblog')

u = User(name='Test', email='[email protected]', password='1234567890', image='about:blank')
print hasattr(u,'__mappings__')
u.insert()
print 'new user id:', u.id

u1 = User.find_first('where email=?', '[email protected]')
print 'find user\'s name:', u1.name

u1.delete()

u2 = User.find_first('where email=?', '[email protected]')
print 'find user:', u2

开发者ID:xiongjzh，项目名称:xblog，代码行数:20，代码来源:test_db.py

示例17: _Engine

#!/usr/bin/env python
# coding=utf-8
#db.py

from transwarp import db 
db.create_engine(user='root',password='111111',database='littlesnail',host='127.0.0.1',port=3306)
users = db.select('select * from user')
n = db.update('insert into user(id,name) values(?,?)',4,'Jack')
with db.connection():
    db.select('...')
    db.update('...')
    db.update('...')
#数据库引擎对象：
class _Engine(object):
    def __init__(self,connect):
        self.connect = connect
    def connect(self):
        return self.connect()
engine = None
#持有数据库连接的上下文对象：
class _DbCtx(threading.local):
    def __init__(self):
        self.connection = None
        self.transactions = 0
    def is_init(self):
        return not self.connection is None
    def init(self):
        self.connection = LasyConnection()
        self.transactions = 0
    def cleanup(self):
        self.connection,cleanup()

开发者ID:littlesnell，项目名称:learngit，代码行数:31，代码来源:db.py

示例18: User

#!/usr/bin/env python
# -*- coding: utf-8 -*-

from models import User, Blog, Comment

from transwarp import db

db.create_engine(user='root', password='Pass1234', database='pywebapp')

u = User(name='Test', email='[email protected]', password='1234567890', image='about:blank')

u.insert()

print 'new user id:', u.id

u1 = User.find_first('where email=?', '[email protected]')
print 'find user\'s name:', u1.name

#u1.delete()

u2 = User.find_first('where email=?', '[email protected]')
print 'find user:', u2

开发者ID:simonguan2014，项目名称:pywebapp，代码行数:22，代码来源:test_db.py

示例19:

#!/usr/bin/python
# -*- coding: utf-8 -*-

from transwarp import db

db.create_engine(user="root", passwd="520119", db="testdb", host="127.0.0.1", port="3306")

users = db.select("select * from user")

开发者ID:liticer，项目名称:awesome_python_webapp，代码行数:8，代码来源:test.py

示例20: add_table

            if data_table:
                return data_table.index
            else:
                return 0
    @classmethod
    def add_table(cls,index):
        r = redis.Redis()
        dt = Data()
        dt.create_table(sub_name = str(index))
        r.set("last_data_table_index",index)
        new_table = Data_Table_Map()
        new_table.end_time = time.time()
        new_table.index = index
        new_table.insert()
    
    

    @classmethod
    def get_tables(cls, start_time, end_time):
        return cls.find_by('where start_time<? and end_time>?', end_time, start_time)

     



if __name__=="__main__":
    db.create_engine('sonic513', 'sonic513', 'tobacco_monitor', host='127.0.0.1',port='3306')
    dtm = Data_Table_Map()
    print dtm.find_first("where 'index'=?",index)

开发者ID:hazelor，项目名称:COO_new，代码行数:29，代码来源:data.py

注：本文中的transwarp.db.create_engine函数示例由纯净天空整理自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 db.select函数代码示例发布时间：2022-05-27

Python transport.Transport类代码示例发布时间：2022-05-27

Python util.grid_equal函数代码示例

1 Python 入门教程

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

阅读：13761|2022-01-22

2 Python wikiutil.getFrontPage函数代码示例

Python wikiutil.getFrontPage函数代码示例

阅读：9251|2022-05-24

3 Python 简介

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

阅读：4061|2022-01-22

4 Python tests.group函数代码示例

Python tests.group函数代码示例

阅读：4039|2022-05-27

5 Python util.check_if_user_has_permission

Python util.check_if_user_has_permission函数代码示例

阅读：3816|2022-05-27

6 Python 操练实例98

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

阅读：3498|2022-01-22

7 Python 环境搭建

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

阅读：3020|2022-01-22

8 Python output.darkgreen函数代码示例

Python output.darkgreen函数代码示例

阅读：2634|2022-05-25

9 Python 基础语法

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

阅读：2622|2022-01-22

10 Python 中文编码

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

阅读：2290|2022-01-22

客服电话

电子邮件

Python db.create_engine函数代码示例

示例1: generate_tables

示例2: User

示例3: connect_db

示例4: WSGIApplication

示例5:

示例6: User

示例7: delete

示例8: User

示例9: User

示例10: isinstance

示例11: User

示例12: User

示例13: User

示例14: test

示例15: User

示例16: hasattr

示例17: _Engine

示例18: User

示例19:

示例20: add_table

请发表评论

全部评论

上一篇：

下一篇：

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