Default values not working with class-based database

[gromiczek]

I've created a database using the class method in SimpleSQL and am also inserting records via the class, however, the integers that should have default values (NumSegments and Alive) are showing up as 0 when I select and read them back out of the database. How can I fix this problem? Thanks for your help and for such a great tool.

Here is the class I'm using to create the db:

public class MotifData

{


    [PrimaryKey, AutoIncrement]

    public int MotifID { get; set; }



    [NotNull]

    public int ParentID1 { get; set; }



    [NotNull]

    public int ParentID2 { get; set; }



    [MaxLength(100), NotNull]

    public string VenueBorn { get; set; }



    [Default(5)]

    public int NumSegments { get; set; }



    [NotNull]

    public DateTime DateTimeBorn { get; set; }



    public DateTime DateTimeDied { get; set; }



    [Default(1)]
    public int Alive { get; set; }



    [MaxLength(100), NotNull]

    public string CurrentVenue { get; set; }
}


Here is the class and method I'm using to create the data for new records:

public class MotifDataCreator : MonoBehaviour

{

    //DateTime utcDate = DateTime.UtcNow;

    string currentVenue = "MyComputer";



    public MotifData CreateNewMotifData()

    {

        MotifData newMotif = new MotifData();

        /*newMotif.MotifID is automatically incremented by the database.*/

        newMotif.ParentID1 = 0;

        newMotif.ParentID2 = 0;
        newMotif.VenueBorn = currentVenue;
        //newMotif.NumSegments defaults to 5

        newMotif.DateTimeBorn = DateTime.UtcNow;

        //newMotif.DateTimeDied is not set yet. It reads 1/1/0001 at 12am when "null"

        //newMotif.Alive defaults to 1
        newMotif.CurrentVenue = currentVenue;


        return newMotif;

    }

}

[echo17]

I'm not sure what might be the issue here. The SQLite.cs class included with the plugin comes from the open source SQLite.NET project. SimpleSQL wraps around this, but the actual implementation is done by the SQLite.NET methods. You might be able to upgrade the SQLite.cs class in your project and recompile the source. I haven't tested newer versions of their code, so I don't know what side effects that might cause. You can find the latest SQLite.cs file here: SQLite.cs

Please see this FAQ on how to recompile the SimpleSQL source: link

In the meantime, you might want to remove the Default attributes and just assign them in your class creator. Not as elegant, but workable.

[gromiczek]

Thanks for taking a look. Yes, I think for now I'll assign the attributes so I don't wade too far out into the weeds - as you say, not elegant, but workable. In the meantime - perhaps this is a fix for a future version update? Thanks again.