Python Database Examples

Example #1

File: models.py Project: QLGu/wiki.catke

 def update(cls, **update):
     cls._meta.database = Database.get_adapter(Database.WRITE)
     return super(Model, cls).update(**update)

Example #2

File: models.py Project: QLGu/wiki.catke

 def raw(cls, sql, *params):
     cls._meta.database = Database.get_adapter(Database.READ)
     return super(Model, cls).raw(sql, *params)

Example #3

File: models.py Project: QLGu/wiki.catke

 def select(cls, *selection):
     cls._meta.database = Database.get_adapter(Database.READ)
     return super(Model, cls).select(*selection)

Example #4

File: wiki-app.py Project: 2life/wiki.catke

# 加入第三方类库搜索路径
sys.path.append(os.path.join(os.path.dirname(__file__), 'modules'))

# 加载程序配置
from wiki import config
from xcat import cache, Database

# 取缓存实例
cache.client = getattr(
    cache, 
    config.settings['xcat_cache'][config.settings['run_mode']]
)()

# 加载数据库配置
Database.load_config(
    config.settings['database'].get(config.settings['run_mode'], False)
)

import xcat.web
import xcat.plugins

from wiki import uimodules

# 加载UImodel
config.settings['ui_modules'] = uimodules

# run app
from wiki.handlers import *
application = xcat.web.Application([], **config.settings)

# 为插件注册 application

Example #5

File: models.py Project: dloveff/BlogCatke

#coding=utf-8
from peewee import *
from xcat import Database 

Model._meta.database = Database.get_adapter(Database.READ)

class Model(Model):
    """
    基础模型
    """
    class Meta:
        database = Database.get_adapter(Database.READ)

    @classmethod
    def raw(cls, sql, *params):
        cls._meta.database = Database.get_adapter(Database.READ)
        return super(Model,cls).raw(sql, *params)

    @classmethod
    def select(cls, *selection):
        cls._meta.database = Database.get_adapter(Database.READ)
        return super(Model,cls).select(*selection)

    @classmethod
    def update(cls, **update):
        cls._meta.database = Database.get_adapter(Database.WRITE)
        return super(Model,cls).update(**update)

    @classmethod
    def insert(cls, **insert):
        cls._meta.database = Database.get_adapter(Database.WRITE)

Example #6

File: models.py Project: QLGu/wiki.catke

 def create(cls, **query):
     cls._meta.database = Database.get_adapter(Database.WRITE)
     return super(Model, cls).create(**query)

Example #7

File: models.py Project: QLGu/wiki.catke

 def save(self, force_insert=False):
     self._meta.database = Database.get_adapter(Database.WRITE)
     return super(Model, self).save(force_insert)

Example #8

File: models.py Project: dloveff/BlogCatke

 def create(cls, **query):
     cls._meta.database = Database.get_adapter(Database.WRITE)
     return super(Model,cls).create(**query)

Example #9

File: models.py Project: dloveff/BlogCatke

 def drop_table(cls, fail_silently=False):
     cls._meta.database = Database.get_adapter(Database.WRITE)
     return super(Model,cls).drop_table(fail_silently)

Example #10

File: models.py Project: dloveff/BlogCatke

 def insert(cls, **insert):
     cls._meta.database = Database.get_adapter(Database.WRITE)
     return super(Model,cls).insert(**insert)

Example #11

File: models.py Project: dloveff/BlogCatke

 def delete(cls):
     cls._meta.database = Database.get_adapter(Database.WRITE)
     return super(Model,cls).delete()

Example #12

File: models.py Project: dloveff/BlogCatke

 def update(cls, **update):
     cls._meta.database = Database.get_adapter(Database.WRITE)
     return super(Model,cls).update(**update)

Example #13

File: models.py Project: dloveff/BlogCatke

 def select(cls, *selection):
     cls._meta.database = Database.get_adapter(Database.READ)
     return super(Model,cls).select(*selection)

Example #14

File: models.py Project: dloveff/BlogCatke

 def raw(cls, sql, *params):
     cls._meta.database = Database.get_adapter(Database.READ)
     return super(Model,cls).raw(sql, *params)

Example #15

File: models.py Project: QLGu/wiki.catke

 def insert(cls, **insert):
     cls._meta.database = Database.get_adapter(Database.WRITE)
     return super(Model, cls).insert(**insert)

Example #16

File: models.py Project: dloveff/BlogCatke

 def save(self, force_insert=False):
     self._meta.database = Database.get_adapter(Database.WRITE)
     return super(Model,self).save(force_insert)

Example #17

File: models.py Project: QLGu/wiki.catke

 def delete(cls):
     cls._meta.database = Database.get_adapter(Database.WRITE)
     return super(Model, cls).delete()

Example #18

File: web.py Project: QLGu/wiki.catke

 def on__finish(self):
     # 关闭主从数据库连接
     Database.close()

Example #19

File: models.py Project: QLGu/wiki.catke

 def drop_table(cls, fail_silently=False):
     cls._meta.database = Database.get_adapter(Database.WRITE)
     return super(Model, cls).drop_table(fail_silently)

Example #20

File: models.py Project: QLGu/wiki.catke

#coding=utf-8
from peewee import *
from xcat import Database

Model._meta.database = Database.get_adapter(Database.READ)


class Model(Model):
    """
    基础模型
    """
    class Meta:
        database = Database.get_adapter(Database.READ)

    @classmethod
    def raw(cls, sql, *params):
        cls._meta.database = Database.get_adapter(Database.READ)
        return super(Model, cls).raw(sql, *params)

    @classmethod
    def select(cls, *selection):
        cls._meta.database = Database.get_adapter(Database.READ)
        return super(Model, cls).select(*selection)

    @classmethod
    def update(cls, **update):
        cls._meta.database = Database.get_adapter(Database.WRITE)
        return super(Model, cls).update(**update)

    @classmethod
    def insert(cls, **insert):

Example #21

File: web.py Project: 2life/wiki.catke

 def on__finish(self):
     # 关闭主从数据库连接
     Database.close()

Example #22

File: models.py Project: QLGu/wiki.catke

 class Meta:
     database = Database.get_adapter(Database.READ)

Example #23

import sys

# 设置系统编码为utf8
reload(sys)
sys.setdefaultencoding('utf8')

# 加入第三方类库搜索路径
sys.path.append(os.path.join(os.path.dirname(__file__), 'modules'))

# 加载程序配置
from wiki import config
# 引入Database
from xcat import Database

# 加载数据库配置
Database.load_config(config.settings['database'].get(
    config.settings['run_mode'], False))
Database.connect()

import wiki.models
import wiki.models.wiki

for m in dir(wiki.models):
    model = getattr(wiki.models, m)

    if m != 'Model' and str(type(model)) == "<class 'peewee.BaseModel'>":
        if model.table_exists() == False:
            try:
                model.create_table()
            except Exception, e:
                pass
    elif str(type(model)) == "<type 'module'>":

Example #24

File: task.py Project: phantomk/wiki.catke

reload(sys)
sys.setdefaultencoding("utf8")

# 加入第三方类库搜索路径
sys.path.append(os.path.join(os.path.dirname(__file__), "modules"))

import requests

# 加载程序配置
from wiki import config

# 引入Database
from xcat import Database

# 加载数据库配置
Database.load_config(config.settings["database"].get(config.settings["run_mode"], False))
Database.connect()

from wiki.models import wiki

# 按每个url 3秒超时算, 1分钟要get 20个url
for v in wiki.Task.select().order_by(wiki.Task.level.desc()).limit(20):

    try:
        requests.get(v.url, timeout=2.8)
        print "get %s" % v.url
        # 删除任务
        wiki.Task.delete().where(wiki.Task.id == v.id).execute()
    except Exception, e:
        pass