Autofield() defined in a model for an existing table with N rows does not use the latest auto increment value for the primary key about peewee HOT 4 CLOSED

This is the generated query:

('INSERT INTO `dim_Projects` (`Name`, `Id`) VALUES (%s, %s)', ['new project test', 1])

from peewee.

That doesn't seem right, it shouldn't be inserting anything for the Id column.

Here is an example based on your code, and it shows that the autofield is NOT inserted:

from peewee import *

db = SqliteDatabase(':memory:')

class DimProject(db.Model):
    Id = AutoField()
    Name = CharField()

db.create_tables([DimProject])

import logging
logger = logging.getLogger('peewee')
logger.setLevel(logging.DEBUG)
logger.addHandler(logging.StreamHandler())

DimProject.create(Name='test')

SQL output correctly shows that Peewee is not providing an Id value and letting the db decide.

('INSERT INTO "dimproject" ("Name") VALUES (?)', ['test'])

from peewee.

The exact same behavior w/MySQL, of course:

from peewee import *

db = MySQLDatabase('peewee_test')

class DimProject(db.Model):
    Id = AutoField()
    Name = CharField()

db.create_tables([DimProject])

import logging
logger = logging.getLogger('peewee')
logger.setLevel(logging.DEBUG)
logger.addHandler(logging.StreamHandler())

DimProject.create(Name='test')
db.drop_tables([DimProject])

Output:

('INSERT INTO `dimproject` (`Name`) VALUES (%s)', ['test'])

from peewee.

Thanks for the quick response. This was a red herring. I obfuscated the model a bit because I don't want to reveal work-related stuff, and in doing so I left out a ForeignKeyField where column_name="Id" instead of "ForeignId". I was mistaken in thinking that the column_name argument was supposed to point this field to the name of the FK field in the other table. Correcting the value solved my problem. I appreciate your time!

from peewee.