SQLiteTests.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using Helpers.Storage;
using UnityEngine;

namespace Test
{
    using NUnit.Framework;
    [TestFixture]
    public class SQLiteTests : MonoBehaviour {
        private const string DB_NAME = "test.db";

        private const string TBL_NAME = "test_tbl";

        private SQLiteHelper dbh;

        private enum ColNames {
            id = 0,
            name = 1,
            value = 2
        }

        public SQLiteTests()
        {
            dbh = new SQLiteHelper(DB_NAME);
        }

        [SetUp]
        public void Init()
        {
            
        }

        [Test]
        public void createTableTest()
        {
            dbh.dropTable(TBL_NAME);

            var colNames = new[] { ColNames.id.ToString(), ColNames.name.ToString(), ColNames.value.ToString() };
            var colTypes = new[] { SQLiteTypes.INTEGER, SQLiteTypes.TEXT, SQLiteTypes.TEXT };
            var result = dbh.createTable(TBL_NAME, colNames, colTypes);
            Assert.AreEqual(0, result);
        }

        [Test]
        public void insertRecordTest()
        {
            var insertResult = dbh.insert(TBL_NAME, 
                new[] { ColNames.name.ToString(), ColNames.value.ToString(), }, 
                new[] { "test", "test value" });

            Assert.AreEqual(1, insertResult);

            var query = string.Format("SELECT * FROM {0} WHERE {1} = '{2}' LIMIT 1", TBL_NAME, ColNames.name, "test");
            var queryResult = dbh.rawQuery(query);
            Assert.AreEqual("test", queryResult.GetValue(Convert.ToInt32(ColNames.name)));
        }

    }


}