Can't insert record to db

[alex]

Its my first try of library and already not working, very disappointed with stacktrace error

using SimpleSQL;

public class Player
{
[PrimaryKey]
public int PlayerID { get; set; }

public string Name { get; set; }

public int Level { get; set; }

public int Coins { get; set; }

public int Gems { get; set; }

public int Goblets { get; set; }
}


public SimpleSQL.SimpleSQLManager dbManager;

   void Start()
   {

       Player playerStats = new Player
       {
           Name = "New Player",
           Level = 3,
           Coins = 50000,
           Gems = 300,
           Goblets = 4321
       };
       dbManager.Insert(playerStats);

       string sql = "SELECT * FROM Player";
       List<Player> players = dbManager.Query<Player>(sql);
       foreach (Player player in players)
       {
           print(player.PlayerID + ". " + player.Name + " (" + player.Level + ")");
       }
   }

And NOT very informative stacktrace:

SQLiteException: Constraint
SimpleSQL.SQLiteConnection.Execute (System.String query, System.Object[] args) (at <9d351781d88446ec91fb4a6de237d175>:0)
SimpleSQL.SQLiteConnection.Insert (System.Object obj, System.String extra, System.Type objType, System.Int64& rowID) (at <9d351781d88446ec91fb4a6de237d175>:0)
SimpleSQL.SQLiteConnection.Insert (System.Object obj, System.Int64& rowID) (at <9d351781d88446ec91fb4a6de237d175>:0)
SimpleSQL.SimpleSQLManager.Insert (System.Object obj, System.Int64& rowID) (at <9d351781d88446ec91fb4a6de237d175>:0)
SimpleSQL.SimpleSQLManager.Insert (System.Object obj) (at <9d351781d88446ec91fb4a6de237d175>:0)
Test.Start () (at Assets/Scripts/Test.cs:22)

Line 22 is dbManager.Insert(playerStats);

if I remove this line dbManager.Insert(playerStats);

everything works fine, its prints 0. New Player (3)

because I already have inserted it once.

Where could be the problem?

P.S. its not working only for Insert with Class Definition

[echo17]

The error you are getting is a Constraint error. This error is coming directly from the sqlite library which SimpleSQL wraps, so unfortunately I cannot control its verbosity. If you do a Google search on sqlite constraint error you will find that you are trying to insert the same primary key twice (the default value of integer, which is zero), which is not allowed in sql systems. There are two ways around this:

1) Supply a PlayerID value when inserting

or

2) Add the AutoIncrement attribute to your PlayerID property of your Player class. Note that you will also need this attribute on the field in your database for it to work.

Just as a side note, the reason that the primary key is not automatically incremented without you specifically requesting it to, is to allow a table where you can have control over what the primary key is. This is good for some tables, so that is why sqlite requires you to specify an auto-increment. Depending on your needs, you can either explicitly set the primary key, or you can have sqlite pull the next value automatically.