// Start is called before the first frame update
void Start()
{
#region Test jsn drop
JSONDropService jsDrop = new JSONDropService {
Token = "6c420424-62ad-4218-8b1f-d6cf2115facd"
};
// Create table person
jsDrop.Create <tblPerson, JsnReceiver>(new tblPerson
{
PersonID = "UUUUUUUUUUUUUUUUUUUUUUUUUUU",
HighScore = 0,
Password = "******"
}, jsnReceiverDel);
/*
* // Store people records
* jsDrop.Store<tblPerson,JsnReceiver> (new List<tblPerson>
* {
* new tblPerson{PersonID = "Jack",HighScore = 100,Password ="******"},
* new tblPerson{PersonID = "Jonny",HighScore = 200,Password ="******"},
* new tblPerson{ PersonID = "Jill",HighScore = 300,Password ="******"}
* }, jsnReceiverDel);
*
* // Retreive all people records
* jsDrop.All<tblPerson, JsnReceiver>(jsnListReceiverDel, jsnReceiverDel);
*
* jsDrop.Select<tblPerson,JsnReceiver>("HighScore > 200",jsnListReceiverDel, jsnReceiverDel);
*
* jsDrop.Delete<tblPerson, JsnReceiver>("PersonID = 'Jonny'", jsnReceiverDel);
*/
jsDrop.Drop <tblPerson, JsnReceiver>(jsnReceiverDel);
#endregion
}
// Start is called before the first frame update
void Start()
{
#region Test jsn drop
JSONDropService jsDrop = new JSONDropService {
Token = "6af89c87-4bff-4941-aa38-d306bf9b5690"
};
//Create table person
jsDrop.Create <Player, JsnReceiver>(new Player
{
Room = "UUUUUUUUUUUUUUUUUUUUUUUUUUU",
Password = "******",
Name = "UUUUUUUUUUUUUUUUUUUUUUUUUUU",
Score = 111111
}, jsnReceiverDel);
// Store people records
jsDrop.Store <Player, JsnReceiver>(new List <Player>
{
new Player {
Room = "Starting Room", Password = "******", Name = "John", Score = 1
},
new Player {
Room = "Starting Room", Password = "******", Name = "Joe", Score = 1
},
new Player {
Room = "Starting Room", Password = "******", Name = "Jim", Score = 1
}
}, jsnReceiverDel);
// Retreive all people records
jsDrop.All <Player, JsnReceiver>(jsnListReceiverDel, jsnReceiverDel);
jsDrop.Select <Player, JsnReceiver>("ID > 20", jsnListReceiverDel, jsnReceiverDel);
jsDrop.Delete <Player, JsnReceiver>("ID = 1", jsnReceiverDel);
jsDrop.Drop <Player, JsnReceiver>(jsnReceiverDel);
#endregion
}
// As soon as the script wakes up, set the script up as a singleton and set it to not destroy on level change.
void OnLevelFinishedLoading(Scene scene, LoadSceneMode mode)
{
DontDestroyOnLoad(this.gameObject);
JSON = new JSONDropService {
Token = "d341e18b-b0b5-4d33-a33d-9239ea617e5a"
};
string query = "Level = '" + Level + "'";
JSON.Select <Chat, JsnReceiver>(query, CheckChatMessageCount, ChatMessageFail);
if (instance == null)
{
instance = this;
}
// Find or create necessary objects
player = Object.FindObjectOfType <Player>();
inventory = Object.FindObjectOfType <InventoryManager>();
cmdLine = Object.FindObjectOfType <CommandLine>();
database = new DatabaseManager("GameData.db");
}
