from utils import execute
import peewee as pw
db = 'perkedu'
database = pw.MySQLDatabase(db, **{'user': '******'})
class UnknownField(object):
pass
class BaseModel(pw.Model):
class Meta:
database = database
class Questions(BaseModel):
anonymous = pw.IntegerField(null=True)
answers = pw.IntegerField()
category = pw.IntegerField(null=True)
modified = pw.DateTimeField()
name = pw.CharField(max_length=255)
posted = pw.DateTimeField()
question = pw.CharField(max_length=255)
studentid = pw.CharField(db_column='student_id', max_length=254)
class Meta:
db_table = 'questions'
from bs4 import BeautifulSoup
import peewee
BASE_URL = 'http://210.75.213.188/shh/portal/bjjs2016/'
PAGE = 2940
username = '******'
password = ''
dbname = 'ershoufang'
host = '127.0.0.1'
database = peewee.MySQLDatabase(
dbname,
host=host,
port=3306,
user=username,
passwd=password,
charset='utf8',
use_unicode=True,
)
class BaseModel(peewee.Model):
def __init__(self):
pass
class Meta:
def __init__(self):
super().__init__()
pass
gateway_name=self.gateway_name,
)
self.gateway.on_contract(contract)
#建立链接
# connect = peewee.SqliteDatabase("/home/jiangyx/fruitday/db.sqlite3") #运行该程序后就能在当前目录下创建“test.db”数据库
settings = {
'host': '47.244.240.38',
'password': '******',
'port': 3306,
'user': '******'
}
connect = peewee.MySQLDatabase("fruitday", **settings)
class Money(peewee.Model):
money_user_id = peewee.CharField(
max_length=255) # This field type is a guess.
money_balance = peewee.FloatField()
money_available = peewee.FloatField()
money_frozen = peewee.FloatField()
money_accountid = peewee.CharField(
primary_key=True, max_length=255) # This field type is a guess.
class Meta:
database = connect
import peewee as pw
import os
import sys
from os import path
sys.path.append(path.join(path.dirname(__file__), '..'))
import load_env
db = pw.MySQLDatabase(
os.getenv("DB_NAME"),
user=os.getenv("DB_USER"),
password=os.getenv("DB_PW"),
host=os.getenv("DB_HOST"),
port=int(os.getenv("DB_PORT")),
)
import peewee
from peewee import *
import pandas as pd
db = peewee.MySQLDatabase('securities_master',
user='******',
passwd='password')
class BaseModel(Model):
class Meta:
database = db
class Exchange(BaseModel):
#exchange_id = IntegerField(primary_key = True,unique = True,null=False)
abbrev = CharField(null=False, max_length=32, unique=True)
name = CharField(null=False, max_length=255)
city = CharField(null=True, max_length=255)
country = CharField(null=True, max_length=255)
currency = CharField(null=True, max_length=64)
timezone_offset = TimeField()
created_date = DateTimeField(null=False)
last_updated_date = DateTimeField(null=False)
class Data_Vendor(BaseModel):
#data_vendor_id =IntegerField(primary_key = True,unique = True,null=False)
name = CharField(null=False, max_length=64, unique=True)
website_url = CharField(null=True, max_length=255)
support_email = CharField(null=True, max_length=255)
from datetime import datetime, date
from math import log
import peewee
# open DataBase
db = peewee.MySQLDatabase('my-trac', user='******', passwd='')
class Limits_user(peewee.Model):
name = peewee.TextField()
weight = peewee.FloatField()
maximum = peewee.IntegerField()
class Meta:
database = db
class Weight:
registration = Limits_user.get(Limits_user.name == 'registration').weight
valuations = Limits_user.get(Limits_user.name == 'valuations').weight
uses_app = Limits_user.get(Limits_user.name == 'uses_app').weight
tickets_purchased = Limits_user.get(
Limits_user.name == 'tickets_purchased').weight
groups = Limits_user.get(Limits_user.name == 'groups').weight
class Maximum:
registration = Limits_user.get(Limits_user.name == 'registration').maximum
valuations = Limits_user.get(Limits_user.name == 'valuations').maximum
uses_app = Limits_user.get(Limits_user.name == 'uses_app').maximum
tickets_purchased = Limits_user.get(
import peewee as pw
import os
from dateutil import parser
myDB = (pw.MySQLDatabase(os.environ['CTC_CANDLES_DB'],
host=os.environ['CTC_CANDLES_HOST'],
port=int(os.environ['CTC_CANDLES_PORT']),
user=os.environ['CTC_CANDLES_USER'],
passwd=os.environ['CTC_CANDLES_PASSWORD']))
class MySQLModel(pw.Model):
"""A base model that will use our MySQL database"""
class Meta:
database = myDB
class Candle(MySQLModel):
firstTrade = None
lastTrade = None
close = pw.DecimalField(null=True)
high = pw.DecimalField(null=True)
low = pw.DecimalField(null=True)
open = pw.DecimalField(null=True)
trades = pw.IntegerField(null=True)
volume = pw.DecimalField(null=True, max_digits=20, decimal_places=8)
idfrom = pw.IntegerField(null=True)
idto = pw.IntegerField(null=True)
candle_date_time = pw.CharField(null=True)
# -*- coding: utf-8 -*- ################################### PART0 DESCRIPTION ################################# # Filename: db.py # Description: # # E-mail: [email protected] # Create: 2016-08-28 23:09:25 # Last: __author__ = 'yuens' ################################### PART1 IMPORT ###################################### import peewee databaseName = "DouBan" hostName = "localhost" password = "******" userName = '******' portCode = 3306 #database = peewee.MySQLDatabase('web_db', **{'host': 'localhost', 'password': '******', 'port': 3306, 'user': '******'}) database = peewee.MySQLDatabase(database=databaseName, **{ 'host': hostName, 'password': password, 'port': portCode, 'user': userName })
def setUp(self):
os.system('echo "create database peeweedbevolve_test;" | mysql')
self.db = pw.MySQLDatabase('peeweedbevolve_test')
self.db.connect()
peeweedbevolve.clear()
import os
import peewee
DATABASE = os.environ.get('DATEBASE')
if DATABASE == 'MYSQL':
database = peewee.MySQLDatabase(database="USERDB",
host=os.environ.get('MYSQL_HOST'),
user="******",
password="******",
charset="utf8mb4")
else:
database = peewee.SqliteDatabase(
os.path.join(os.path.dirname(__file__), 'example.db'))
class BaseModel(peewee.Model):
class Meta:
database = database
# Example below
# class User(BaseModel):
# id = peewee.AutoField()
# username = peewee.CharField(unique=True)
# email = peewee.CharField()
# join_date = peewee.DateTimeField(formats="%y/%m/%d %H:%M:%S")
def create_tables():
# with database:
os.path.dirname(
os.path.dirname(os.path.dirname(os.path.abspath(__file__))))))
import toycabinet
import peewee
from toycabinet.core.dborm.models import User
from toycabinet.core.preset import Preset
if not len(Preset.tool.email):
raise KeyError(
'ToyCabinet register need client email address, please fill in [presets.json]'
)
if Preset.tool.db_type == 'postgres':
DB = peewee.PostgresqlDatabase(**Preset.tool.db_info)
elif Preset.tool.db_type == 'mysql':
DB = peewee.MySQLDatabase(**Preset.tool.db_info)
elif Preset.tool.db_type == 'sqlite':
DB = peewee.SqliteDatabase(**Preset.tool.db_info)
else:
raise KeyError(
'ToyCabinet support database types: 1.postgres 2.mysql 3.sqlite ')
database = DB
database.connect()
user = User.get(id=1)
user.name = 'admin'
user.admin = True
user.password = '******'
user.save()
# -*- coding: utf-8 -*-
import peewee, pickle, pdb
from datetime import datetime as dt
from random import choice
from datetime import datetime as dt
from utils import return_slug
from project import bcrypt
_database = peewee.MySQLDatabase('wing_cms',
user='******',
passwd='wing_cms')
class BaseModel(peewee.Model):
class Meta:
database = _database
class ArticleRevision(BaseModel):
pickle_obj = peewee.TextField()
creation_date = peewee.DateField(default=dt.today().date())
def __unicode__(self):
return 'rev. from %s. v%s' % (self.creation_date.strftime('%Y-%m-%d'),
self.id)
class CategoryRevision(BaseModel):
from flask import Flask, render_template, request, send_from_directory
from flask_bootstrap import Bootstrap
from flask_wtf import FlaskForm
from wtforms import SelectField, SubmitField, RadioField, StringField
from wtforms.validators import DataRequired
import peewee as pw
import json
import os
#####################数据库相关##################################################
# 数据库名称定义为全局变量
global MYSQLDB
MYSQLDB = pw.MySQLDatabase('trftarget',
user='******',
password='******',
host='127.0.0.1',
port=3306,
autoconnect=False)
class MYSQLBaseModel(pw.Model):
# 所用数据库为MYSQLDB
class Meta:
database = MYSQLDB # MYSQLDB为所定义的数据库变量
# 定义MySQL data types
class UnTinyIntField(pw.IntegerField):
# Range 0-255
field_type = 'TINYINT UNSIGNED'
#creation d'une DataBase
import peewee as pw
# connection a la base de donnees
myDB = pw.MySQLDatabase("marattm_webproject_quizz",
host="mysql2.paris1.alwaysdata.com",
port=3306,
user="******",
passwd="Azer0123")
myDB.connect()
# Definition de la table 'HighScore'
class Quizz(pw.Model):
class Meta:
database = myDB
# Definition de 3 colonnes
name = pw.CharField() #nom image
img = pw.CharField() #adresse une image
label_name = pw.CharField() #type de l'image
label_nb = pw.BigIntegerField() #ordre
# le champ id est automatiquement cree
if __name__ == "__main__":
# si ce fichier est execute a la main, alors creation de la table
myDB.create_tables([Quizz])
import peewee as pw
import config
myDB = pw.MySQLDatabase(\
config.db['name'], \
host = config.db['host'], \
user = config.db['user'],\
passwd = config.db['passwd'])
class BaseModel(pw.Model):
"""A base model that will use our MySQL database"""
class Meta:
database = myDB
class major(BaseModel):
id = pw.PrimaryKeyField()
major_code = pw.CharField(max_length=255)
major_name = pw.CharField(max_length=255)
class course(BaseModel):
id = pw.PrimaryKeyField()
major = pw.ForeignKeyField(major, related_name='courses')
course_code = pw.CharField(max_length=255)
course_name = pw.CharField(max_length=255)
def createTables():
myDB.connect()
import peewee
import datetime
database = peewee.MySQLDatabase('test',
host='localhost',
port=3306,
user='******',
passwd='')
class User(peewee.Model):
username = peewee.CharField(unique=True, max_length=50, index=True)
password = peewee.CharField(max_length=50, null=True)
email = peewee.CharField(max_length=50)
active = peewee.BooleanField(default=True)
created_date = peewee.DateTimeField(default=datetime.datetime.now)
class Meta:
database = database
db_table = 'users'
def __str__(self):
return self.username
class Store(peewee.Model):
admin = peewee.ForeignKeyField(
User, related_name='store') #primary_key=True Relacion uno a uno
name = peewee.CharField(max_length=50, unique=50, index=True)
address = peewee.TextField()
active = peewee.BooleanField(default=True)
#!/usr/bin/env python
import re
from collections import Counter
from collections import defaultdict
from collections import OrderedDict
from operator import itemgetter
import time
import datetime
import random
#########################################################
import peewee as pw
myDB = pw.MySQLDatabase("mail_db", host="localhost", port=3306, user="******", passwd="mysql")
class MySQLModel(pw.Model):
"""A base model that will use our MySQL database"""
class Meta:
database = myDB
class mailing(MySQLModel):
addr = pw.CharField(max_length=255, unique=True,primary_key=True)
def connect():
try:
myDB.connect()
print("... DB connected")
except Error as e:
print(e)
print("... DB not connected")
import os
import configparser
import peewee
# config.ini から設定値を読み込む
ini_file = configparser.ConfigParser()
ini_file.read_file(open("config.ini"))
# # local保存の場合
# HOST = ini_file.get('db_local', 'HOST')
# DATABASE = ini_file.get('db_local', 'DATABASE')
# USER = ini_file.get('db_local', 'USER')
# PASSWD = ini_file.get('db_local', 'PASSWD')
# docker-compose 保存の場合
HOST = ini_file.get('db_docker', 'HOST')
DATABASE = ini_file.get('db_docker', 'DATABASE')
USER = ini_file.get('db_docker', 'USER')
PASSWD = ini_file.get('db_docker', 'PASSWD')
# データベース接続
db = peewee.MySQLDatabase(host=HOST,
database=DATABASE,
user=USER,
password=PASSWD)
import peewee
import json
# Open configuration file
try:
with open('config.json', encoding='utf8') as config_file:
Config = json.load(config_file)
except:
print('Unable to open config.json!')
print(
'If you haven\'t created a configuration file, please use the example configuration file as a guide.'
)
print('Otherwise, make sure the file permissions are set correctly.')
exit(1)
db = peewee.MySQLDatabase(Config['mail']['db_db'],
host=Config['mail']['db_host'],
port=Config['mail']['db_port'],
user=Config['mail']['db_user'],
passwd=Config['mail']['db_password'],
charset=Config['mail']['db_charset'])
class BaseModel(peewee.Model):
class Meta:
database = db
from contextvars import ContextVar
from api import config
import peewee
db_state_default = {"closed": None, "conn": None, "ctx": None, "transactions": None}
db_state = ContextVar("db_state", default=db_state_default.copy())
class PeeweeConnectionState(peewee._ConnectionState):
def __init__(self, **kwargs):
super().__setattr__("_state", db_state)
super().__init__(**kwargs)
def __setattr__(self, name, value):
self._state.get()[name] = value
def __getattr__(self, name):
return self._state.get()[name]
db = None
if config.DATABASE_TYPE == "mysql":
db = peewee.MySQLDatabase(config.MYSQL_DB, host=config.MYSQL_HOST,
port=config.MYSQL_PORT, user=config.MYSQL_USER, password=config.MYSQL_PASS)
else:
db = peewee.SqliteDatabase(config.SQLITE_NAME, check_same_thread=False)
db._state = PeeweeConnectionState()
