def __conn(self, *args): if len(args) == 0: db = PostgresqlDatabase(database=getConfig('conn_default', 'database'), host=getConfig('conn_default', 'host'), user=getConfig('conn_default', 'user'), password=getConfig('conn_default', 'password')) elif len(args) == 1: conn_key = str(args[0]) if conn_key == "": conn_key = "conn_default" dbtype = getConfig(conn_key, 'dbtype') if dbtype == 'pgsql': db = PostgresqlDatabase( database=getConfig(conn_key, 'database'), host=getConfig(conn_key, 'host'), user=getConfig(conn_key, 'user'), password=getConfig(conn_key, 'password')) elif dbtype == 'mysql': db = MySQLDatabase(database=getConfig(conn_key, 'database'), host=getConfig(conn_key, 'host'), user=getConfig(conn_key, 'user'), password=getConfig(conn_key, 'password')) return db
def get_sync_pool(): return MySQLDatabase( database=config.config.db_name, user=config.config.db_user, password=config.config.db_password, host=config.config.db_host, port=config.config.db_port, )
def init_db() -> MySQLDatabase: db_config = asyncio.run(load_config())['DataBase'] # 定义数据库对象 db = MySQLDatabase( database=db_config['DB'], user=db_config['User'], password=db_config['Password'], host=db_config['Host'], port=db_config['Port'] ) return db
from peewee_async import MySQLDatabase from jinja2 import Environment, PackageLoader # database db = MySQLDatabase('sanic_project_db', user='******', password='', host='127.0.0.1', port=3306) # Jinja2 env = Environment(loader=PackageLoader('simple_project', 'templates'))
from os import environ from peewee import Model, DateTimeField, TextField, SmallIntegerField, OperationalError from peewee_async import MySQLDatabase, Manager from datetime import timedelta, datetime from enum import IntEnum from time import sleep import logging logging.basicConfig(filename='meetbot.log', level=int(environ["LOG_LEVEL"])) _connected = False _database = MySQLDatabase(database=environ["MEETBOT_DATABASE"], user=environ["MEETBOT_DATABASE_USERNAME"], password=environ["MEETBOT_DATABASE_PASSWORD"], host=environ["MEETBOT_DATABASE_HOST"], port=int(environ['MEETBOT_DATABASE_PORT'])) _objects = Manager(_database) class Notification(IntEnum): NONE = 0 HOUR = 1 MINUTE = 2 class Meeting(Model): guild = TextField() description = TextField() date_time = DateTimeField() user_list = TextField() notified = SmallIntegerField(default=Notification.NONE)
import datetime import peewee from peewee_async import MySQLDatabase import peeweedbevolve database = MySQLDatabase(None) class User(peewee.Model): id = peewee.IntegerField(unique=True, null=False) role = peewee.IntegerField(default=0) messages = peewee.IntegerField(default=0) messages_np = peewee.IntegerField(default=0) symbols = peewee.IntegerField(default=0) symbols_np = peewee.IntegerField(default=0) voice = peewee.IntegerField(default=0) first_used = peewee.DateTimeField(default=datetime.datetime.now) mention = peewee.BooleanField(default=True) class Meta: database = database class Chat(peewee.Model): admin = peewee.BooleanField(default=False) kick_left = peewee.BooleanField(default=False) kick_groups = peewee.BooleanField(default=False) kick_link = peewee.BooleanField(default=True) max_warns = peewee.IntegerField(default=3) max_votes = peewee.IntegerField(default=5)
def connection(self): return MySQLDatabase(**self.query)
import os from peewee_async import MySQLDatabase BASE_DIR = os.path.dirname( os.path.dirname(os.path.dirname(os.path.abspath(__file__)))) settings = { "IP": "http://0.0.0.0:8888/", "db": { "host": "127.0.0.1", "user": "******", "password": "******", "name": "authandper", "port": 3306 }, "SECRET_KEY": "8mh1NU9l*1wWsGyqdsB9mv8lx6klKxVVI5uQ&2N9%2!vNVWgkvZ&NkED&cu9iL*d", "SECRET_EXPRIE": 7 * 24 * 3600, "JWT_AUTH_HEADER_PREFIX": "JWT" } database = MySQLDatabase('authandper', host="127.0.0.1", port=3306, user="******", password="******")
import os import logging from peewee_async import MySQLDatabase port = 9004 BASE_DIR = os.path.dirname(__file__) database = MySQLDatabase( 'tornado_db', **{ 'charset': 'utf8', 'use_unicode': True, 'host': 'localhost', 'port': 3306, 'user': '******', 'password': '******' }) logging.basicConfig( level=logging.INFO, format= '%(asctime)s %(filename)s[line:%(lineno)d] %(levelname)s %(message)s', datefmt='%a, %d %b %Y %H:%M:%S', # filename='tornado.log', # filemode='w' ) # logger = logging.getLogger(__name__) # # console = logging.StreamHandler() # console.setLevel(logging.INFO) # console.setLevel(20) # console_formatter = logging.Formatter('%(asctime)s - %(filename)s - [line]:%(lineno)d - %(levelname)s - %(message)s') # console.setFormatter(console_formatter)