public void CreateChapterTables()
{
_connection.DropTable <PChapter> ();
_connection.CreateTable <PChapter> ();
_connection.InsertAll(new[] {
new PChapter {
Id = GetRandomString(),
Name = "Sunrise",
Locked = false
},
new PChapter {
Id = GetRandomString(),
Name = "Dawn",
Locked = true
},
new PChapter {
Id = GetRandomString(),
Name = "Dusk",
Locked = true
},
});
CreateLevelDB();
}
public void CreateDB()
{
#if UNITY_EDITOR
_connection.DropTable <Colection>();
_connection.DropTable <Pacote>();
#endif
_connection.CreateTable <Colection>();
_connection.CreateTable <Pacote>();
}
public void CreateDB()
{
_connection.DropTable <Person>();
_connection.CreateTable <Person>();
_connection.InsertAll(new[] {
new Person {
Id = 1,
Name = "탐",
Surname = "Perez",
Age = 56
},
new Person {
Id = 2,
Name = "あいうぇえおか",
Surname = "Arthurson",
Age = 16
},
new Person {
Id = 3,
Name = "John",
Surname = "Doe",
Age = 25
},
new Person {
Id = 4,
Name = "Roberto",
Surname = "Huertas",
Age = 37
},
});
}
public void DropTables()
{
_sqliteConnection.DropTable <Data_Access_Layer.GoodsDispatchedNote>();
_sqliteConnection.DropTable <Data_Access_Layer.GoodsReceivedNote>();
_sqliteConnection.DropTable <Data_Access_Layer.Entry>();
_sqliteConnection.DropTable <Data_Access_Layer.Invoice>();
_sqliteConnection.DropTable <Data_Access_Layer.ProductAttribute>();
_sqliteConnection.DropTable <Data_Access_Layer.ProductDetail>();
_sqliteConnection.DropTable <Data_Access_Layer.Attribute>();
_sqliteConnection.DropTable <Data_Access_Layer.Product>();
_sqliteConnection.DropTable <Data_Access_Layer.Location>();
_sqliteConnection.DropTable <Data_Access_Layer.Counterparty>();
_sqliteConnection.DropTable <Data_Access_Layer.City>();
_sqliteConnection.DropTable <Data_Access_Layer.UserRole>();
_sqliteConnection.DropTable <Data_Access_Layer.RoleClaim>();
_sqliteConnection.DropTable <Data_Access_Layer.Role>();
_sqliteConnection.DropTable <Data_Access_Layer.UserClaim>();
_sqliteConnection.DropTable <Data_Access_Layer.UserLogin>();
_sqliteConnection.DropTable <Data_Access_Layer.UserToken>();
_sqliteConnection.DropTable <Data_Access_Layer.User>();
}