def create_database_connection(): """Creates a connection to a MySQLDatabase using the parmeters specified in the setting file""" try: db = MySQLDatabase( settings.DATABASE, user=settings.USERNAME, passwd=settings.PASSWORD, host=settings.HOST ) db.connect() except Exception as e: print "Failed to connect to database", e return db
def doSQL(n, u, h, a, g): db = MySQLDatabase("asm_main", host=host, port=3306, user=user, passwd=passwd) db.connect() cur = db.get_cursor() nick = n user = u host = h account = a gecos = g escape = db.get_conn().escape_string sql = "SELECT * FROM actionlog WHERE " search = [] if nick: search.append("nick LIKE '{nick}'".format(nick=escape(nick))) if user: search.append("user LIKE '{user}'".format(user=escape(user))) if host: search.append("host LIKE '{host}'".format(host=escape(host))) if account: search.append("account LIKE '{account}'".format(account=escape(account))) if gecos: search.append("gecos LIKE '{gecos}'".format(gecos=escape(gecos))) sql = sql+" OR ".join(search) l = cur.execute(sql) output = "" for row in cur.fetchall(): output+= "<tr>" output+= "<td>#{}</td>".format(row[0]) # id output+= "<td>{}</td>".format(row[1]) # date output+= "<td>{}<span class=\"userhost\">!{}@{}</span></td>".format(row[5],row[6],row[7]) # nick!ident@host output+= "<td>received {}".format(row[2]) # event # (11, datetime.datetime(2016, 2, 21, 20, 25, 45), 'quiet', None, '##doge', 'doge', '~doge', # 'antispammeta/suchmeta/botters.doge', None, 'doge', 'doge', 'falco-devel', '~falco', # 'botters/doge/bot/falco', "nathan's bot", 'falco') if row[11]: output+= " from {}<span class=\"userhost\">{}{}</span></td>".format( row[11], "!"+row[12] if row[12] else "", "@"+row[13] if row[13] else "") # who it was from elif not row[11]: output+= "</td>" output+= "<td>{}</td>".format(row[4] if row[4] else "") # channel output+= "<td>{}</td>".format(row[3] if row[3] else "") # reason output+= "</tr>" return output
help='Start in daemon mode which notifies to rekall') parser.add_argument('--concept', type=str, help='Concept to store for rekall') parser.add_argument('--rekall', type=bool, default=False, help='Print text and increment rekall') parser.add_argument('--remove', type=bool, default=False, help='Remove a concept') parser.add_argument('--printall', type=bool, default=False, help='Print everything in the database') config = ConfigParser.ConfigParser() config.read(os.path.expanduser('~/.rekall')) args = parser.parse_args() db = MySQLDatabase("rekall", host=config.get("mysql", "host"), user=config.get("mysql", "user"), passwd=config.get("mysql", "password"), charset="utf8", use_unicode=True) db.connect() class BaseModel(Model): class Meta: database = db class Concept(BaseModel): name = CharField() text = TextField(default="# Explanation / Analogy / Like I'm Five" ) last_rekall = DateTimeField(default=datetime.datetime.now) rekalls = IntegerField(default=0) def next_rekall(self): return self.last_rekall + datetime.timedelta(seconds=(INTERVAL_SECONDS ^ self.rekalls)) Concept.create_table(fail_silently=True)
#!/usr/bin/env python # encoding: utf-8 from peewee import (MySQLDatabase, Model, ForeignKeyField, TextField, BigIntegerField, DateTimeField) import settings database = MySQLDatabase(settings.DATABASE, user=settings.USER, password=settings.PASSWORD) database.connect() class BaseModel(Model): class Meta: database = database class Category(BaseModel): name = TextField() class Torrent(BaseModel): category = ForeignKeyField(Category) title = TextField() size = BigIntegerField() magnet = TextField() hash = TextField() nfo = TextField()
from peewee import CharField, Model, MySQLDatabase from app import app MYSQL_DB = 'users' MYSQL_HOST = 'localhost' MYSQL_PORT = 3306 MYSQL_USER = '******' MYSQL_PASS = '******' db = MySQLDatabase(MYSQL_DB, host=MYSQL_HOST, port=MYSQL_PORT, user=MYSQL_USER, passwd=MYSQL_PASS) db.connect() class BaseModel(Model): class Meta: database = db class tbl_users2(BaseModel): user_name = CharField(primary_key=True) user_password = CharField()
def last_test_pymysql(): conn = MySQLDatabase.connect(host='localhost', port=3306, user='******', db='mysql')