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)