peewee with BIGINT primary key.

peewee-example.py

#from peewee import *
#import pymysql
import peewee

# 'id' to 'BIGINT AUTO_INCREMENT'
peewee.MySQLDatabase.field_overrides['primary_key'] = 'BIGINT AUTO_INCREMENT'
db = peewee.MySQLDatabase(
    database='peewee_development',
    user='root',
    password='',
    host='localhost',
    port=3306)

class User(peewee.Model):
    email = peewee.CharField(max_length=255)
    password = peewee.CharField(max_length=255)
    class Meta:
        database = db

    # http://stackoverflow.com/questions/21975920/peewee-model-to-json
    def __str__(self):
        r = {}
        for k in self._data.keys():
            try:
                r[k] = str(getattr(self, k))
            except:
                r[k] = json.dumps(getattr(self, k))
        return str(r)

db.drop_table(User)
db.create_tables([User], True)

User.create(email='foobar@example.com', password='very strong password')

for email in ['foobar@example.com', 'foobar@example2.com']:
    try:
        print User.get(User.email==email)
    except User.DoesNotExist, e:
        print "Record not found\n---\n{0}\n---".format(e)