Gameframe.SQLite 👋

[![Codacy Badge](https://camo.githubusercontent.com/513edd66a69a28f76f8a1bf435955b0192a40196/68747470733a2f2f6170702e636f646163792e636f6d2f70726f6a6563742f62616467652f47726164652f6332613735343539306564643466376239326431323532663833373038623035)](https://www.codacy.com/manual/coryleach/UnitySQLite?utm_source=github.com&utm_medium=referral&utm_content=coryleach/UnitySQLite&utm_campaign=Badge_Grade) ![GitHub release (latest by date including pre-releases)](https://camo.githubusercontent.com/f0516e736f76db82f97f1e9fd12c9647b3031d42/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f762f72656c656173652f636f72796c656163682f556e69747953514c6974653f696e636c7564655f70726572656c6561736573) [![openupm](https://camo.githubusercontent.com/9634ac42fcbdb13b95e910053c5b769c54cccdeb/68747470733a2f2f696d672e736869656c64732e696f2f6e706d2f762f636f6d2e67616d656672616d652e7363656e6573776974636865723f6c6162656c3d6f70656e75706d2672656769737472795f7572693d68747470733a2f2f7061636b6167652e6f70656e75706d2e636f6d)](https://openupm.com/packages/com.gameframe.sceneswitcher/) ![GitHub](https://camo.githubusercontent.com/8a088a6891d4d60acae10978fa71ce8c142af54b/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f6c6963656e73652f636f72796c656163682f556e69747953514c697465) SQLite Package ## Quick Package Install #### Using UnityPackageManager (for Unity 2019.3 or later) Open the package manager window (menu: Window > Package Manager)
Select "Add package from git URL...", fill in the pop-up with the following link:
https://github.com/coryleach/UnitySQLite.git#1.0.2
#### Using UnityPackageManager (for Unity 2019.1 or later) Find the manifest.json file in the Packages folder of your project and edit it to look like this: ```js { "dependencies": { "com.gameframe.sqlite": "https://github.com/coryleach/UnitySQLite.git#1.0.2", ... }, } ``` ## Usage ```c# using Mono.Data.SqliteClient; // Create database string path = Application.persistentDataPath + "/" + "My_Test_Database"; string connection = "URI=file:" + path; // Open connection IDbConnection dbcon = new SqliteConnection(connection); dbcon.Open(); // Create table IDbCommand dbcmd; dbcmd = dbcon.CreateCommand(); string q_createTable = "CREATE TABLE IF NOT EXISTS my_table (id INTEGER PRIMARY KEY, val INTEGER )"; dbcmd.CommandText = q_createTable; dbcmd.ExecuteReader(); // Insert values in table IDbCommand cmnd = dbcon.CreateCommand(); cmnd.CommandText = "INSERT INTO my_table (id, val) VALUES (0, 5)"; cmnd.ExecuteNonQuery(); // Read and print all values in table IDbCommand cmnd_read = dbcon.CreateCommand(); IDataReader reader; string query ="SELECT * FROM my_table"; cmnd_read.CommandText = query; reader = cmnd_read.ExecuteReader(); while (reader.Read()) { Debug.Log("id: " + reader[0].ToString()); Debug.Log("val: " + reader[1].ToString()); } // Close connection dbcon.Close(); ``` ## Author 👤 **Cory Leach** * Twitter: [@coryleach](https://twitter.com/coryleach) * Github: [@coryleach](https://github.com/coryleach) ## Show your support Give a ⭐️ if this project helped you! *** _This README was generated with ❤️ by [Gameframe.Packages](https://github.com/coryleach/unitypackages)_