Exemplo n.º 1
0
    void Start()
    {
        // LastTable LastTable.GetInstance11 = new LastTable("messages");
        // LastTable.GetInstance()
        LastTable.GetInstace.DeleteTable("last");
        LastTable.FUCl();

        // LastTable LastTable.GetInstance = new LastTable("messages");
        //Add Data
        LastTable.GetInstance().GetDataById(1);
        LastTable.GetInstance().AddData(1, "AR1", "123");
        LastTable.GetInstance.AddData(2, "AR2", "456");
        LastTable.GetInstance.AddData(3, "AR3", "789");
        LastTable.GetInstance.UpdateRow(3, 3, "changed1", "***");
        LastTable.GetInstance.CloseDb();


        //Fetch All Data
        LastTable LastTable.GetInstance2 = new LastTable("messages");

        System.Data.IDataReader reader = LastTable.GetInstance2.GetAllData();

        int fieldCount = reader.FieldCount;

        // List<LastTableEntity> myList = new List<LastTableEntity>();
        while (reader.Read())
        {
            LastTableEntity entity = new LastTableEntity(Convert.ToInt32(reader[0]),
                                                         reader[1].ToString(),
                                                         reader[2].ToString());
            Debug.Log("id: " + entity._id + "|jwt: " + entity._jwt);
            // myList.Add(entity);
        }
    }
Exemplo n.º 2
0
    // Start is called before the first frame update
    void Start()
    {
        LastTable myLastTableDb2 = new LastTable("messages");

        System.Data.IDataReader reader = myLastTableDb2.GetAllData();
        Debug.Log("show me my class bitch");
        int fieldCount = reader.FieldCount;

        // List<LastTableEntity> myList = new List<LastTableEntity>();
        while (reader.Read())
        {
            LastTableEntity entity = new LastTableEntity(Convert.ToInt32(reader[0]),
                                                         reader[1].ToString(),
                                                         reader[2].ToString());
            Debug.Log("id: " + entity._id + "|jwt: " + entity._jwt);
            // myList.Add(entity);
        }
    }