no such table

[miking]

Hi,

I am having problems, setting SimpleSQL up for my own data bases. The Demos look neat and seem easy, but setting up everything on your own is bugging me out...

Since i was running into one issue after the other, i decided to do this approach:

1. in Unity: Tools --> SimpleSQL --> Create Empty Database --> Empty.bytes
2. in Unity: Rename DB to TarkovQuests.bytes
3. Opened TarkovQuests.bytes with DB Browser(SQLite)
4. Created a Table "TarkovMap":



5. Added some values to the table:


6. Followed your youtube intro: DBManager with TarkovQuests.bytes as DB File, Logic script is as follows:


public class Logic : MonoBehaviour

{



   public Text output;

   public SimpleSQLManager dbManager;



   // Start is called before the first frame update

   void Start()

   {

       var results = dbManager.Query<SimpleSQL.Demos.TarkovMap>("SELECT * FROM  TarkovMap");

       Debug.Log("No of entries: " + results.Count);

       

       output.text = "";

       foreach (var result in results)

       {

           output.text += "MapName: " + result.MapName + "MapID: " + result.MapId + "\n";

       }

   }

   // Update is called once per frame

   void Update()

   {



   }

}
7. Upon starting the app, i currently get the error: 
SQLiteException: no such table: TarkovMap


The table should be there, when i reopen the DB in the 3rd Party DB Browser, all the data is still there

Do you have an idea what the issue could be here?

Also i was unsure, the ORM file need to be written by myself, is this correct? Or is there some kind of generator? Also what do I have to take into consideration for those files (Case sensitive etc...)
This is the file I created for this simple example (i just checked how it was done in the Weapon Class file):


namespace SimpleSQL.Demos

{

   using SimpleSQL;



   public class TarkovMap

   {

       //The MapId field is set as the primary key in the SQLite database,

               // so we reflect that here with the PrimaryKey attribute

       [PrimaryKey]

       public int MapId { get; set; }



       public string MapName { get; set; }

   }

}
Thanks in advance for your help, i am really pulling my hair, because i think it should be pretty simple to set this stuff up....

Best regards

Mike

[echo17]

Jun 27, 2021 14:16:25 GMT miking said:

The table should be there, when i reopen the DB in the 3rd Party DB Browser, all the data is still there

Please see these FAQs:

link
link

Jun 27, 2021 14:16:25 GMT miking said:

Also i was unsure, the ORM file need to be written by myself, is this correct? Or is there some kind of generator?

Yes, the ORM is written by you. The reason there is no generator is because the ORM might reflect the combination of multiple tables, instead of just a single table. If you are doing any joins in your queries, then you'll likely have fields from all the joined tables. You can create an ORM for a single table, or these joins. You can also create ORM classes that have only a subset of the fields in a table or query. This way you can get just the data you need without having to pull the entire table's worth of fields. You can have multiple ORMs set up for a single query / table as well.

Jun 27, 2021 14:16:25 GMT miking said:

Also what do I have to take into consideration for those files (Case sensitive etc...)

Yes, the ORM is case sensitive. Behind the scenes, SimpleSQL uses reflection to match up query results to ORM definitions. C# is case sensitive.

[miking]

Thanks a lot for your hints, got it running now

Does it make sense to keep "overwrite" on true as long as I am still working on the static part of the database to immediatly get the updates i do and switch it to fals once i am done? Or is there any downside to that?

[echo17]

Yep, that is a good method when developing initially. Just be careful with that setting as it will overwrite any changes made during runtime.

What I like to do in my projects is have two separate databases, one for static data that does not change at runtime and one for dynamic data that changes at runtime. I set overwrite to true on the static database and leave it off for the dynamic one. Makes it easier to update static data that way. You'll need two separate SimpleSQLManager components, one for each database file.