public void InserindoListaFabricantes(List<Fabricante> fabricantes) { using (var dbConn = new SQLiteConnection(DB_path)) { dbConn.DropTable<Fabricante>(); dbConn.Dispose(); dbConn.Close(); } foreach (Fabricante f in fabricantes) this.Inserindo(f); }
/** * This method is called when the button to delete all stats is clicked */ private async void dropStats(object sender, EventArgs e) { bool delete = await DisplayAlert("Avertissement", "Attention, supprimer les statistiques est une manoeuvre irréversible !", "Continuer", "Annuler"); if (!delete) { return; } try { SQLite.SQLiteConnection connection = DependencyService.Get <ISQLiteDb>().GetConnection(); connection.DropTable <MyPosition>(); connection.DropTable <Shot>(); connection.DropTable <ScoreHole>(); connection.DropTable <ScorePartie>(); connection.CreateTable <MyPosition>(); connection.CreateTable <Shot>(); connection.CreateTable <ScoreHole>(); connection.CreateTable <ScorePartie>(); } catch (Exception) { } }
private void Seed() { connection.DropTable <Beer>(); connection.DropTable <Pub>(); connection.CreateTable <Beer>(); connection.CreateTable <Pub>(); Beers = connection.Table <Beer>(); Pubs = connection.Table <Pub>(); }
public KspMods(string a_InstallationDirectory, string a_ModPath ) { InstallationDirectory = a_InstallationDirectory; ModDirectory = a_ModPath; db = new SQLiteConnection("kmm.sqlite"); // make sure the table exists if (db.GetTableInfo("KMMInfo").Count == 0) { db.CreateTable<KMMInfo>(); } var tables = new Type[] { typeof(InstalledMods), typeof(ModFiles), typeof(InstalledFiles) }; foreach (var table in tables) { var info = db.GetTableInfo(table.Name); if (info.Count == 0) db.CreateTable(table); } // oh noez it does not match if (db.Table<KMMInfo>().Count() == 0 || db.Table<KMMInfo>().First().Version != GetAssemblyVersion()) { // salvage data var installed_mods = db.Table<InstalledMods>().ToList(); db.DropTable<InstalledMods>(); db.CreateTable<InstalledMods>(); db.InsertAll(installed_mods); var mod_files = db.Table<ModFiles>().ToList(); db.DropTable<ModFiles>(); db.CreateTable<ModFiles>(); db.InsertAll(mod_files); var installed_files = db.Table<InstalledFiles>().ToList(); db.DropTable<InstalledFiles>(); db.CreateTable<InstalledFiles>(); db.InsertAll(installed_files); } // make sure the table is filled if (db.Table<KMMInfo>().Count() == 0) { var nfo = new KMMInfo() { Version = GetAssemblyVersion() }; db.Insert(nfo); } }
static public void createNewsItemTable() { db.DropTable <NewsItem>(); db.CreateTable <NewsItem>(); //db.DropTable //return true; }
public void Drop() { using (var connection = new SQLiteConnection(_dbPath)) { connection.DropTable<Account>(); } }
public void Drop() { using (var db = new SQLiteConnection(DbPath)) { db.DropTable<TracklistItem>(); } }
private void RemoveTableButton_Click(object sender, RoutedEventArgs e) { using (var connection = new SQLiteConnection(new Net.Platform.WinRT.SQLitePlatformWinRT(), path)) { connection.DropTable <User>(); this.Users.Clear(); } }
public void DeleteAllScores() { lock (collisionLock) { database.DropTable <Scoreboard>(); database.CreateTable <Scoreboard>(); } }
public static void Exec() { using (sql.SQLiteConnection connection = new sql.SQLiteConnection("testdb.db")) { connection.CreateTable(typeof (Table)); connection.Insert(typeof (A)); connection.DropTable<Table>(); } }
private void Button_Clicked_1(object sender, EventArgs e) { using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(App.DB_PATH)) { reteta reteta = new reteta(); conn.DropTable <reteta>(); DisplayAlert("Succes", "Lista de cumparaturi este stearsa", "OK"); } }
public static void SaveEvents (List<Event> eventsList) { string path = Path.Combine (Environment.GetFolderPath (Environment.SpecialFolder.Personal), "Event.sqlite"); var db = new SQLiteConnection (path); db.DropTable<Event> (); db.CreateTable<Event> (); db.InsertAll (eventsList); }
public void Setup() { _cache.ApplicationName = AppName; _expectedDatabasePath = Path.Combine( Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.CommonApplicationData), AppName), "SimpleObjectCache"); Directory.CreateDirectory(_expectedDatabasePath); _connection = new SQLiteConnection(Path.Combine(_expectedDatabasePath, "cache.db3")); _connection.DropTable<CacheElement>(); }
private async void drop(object sender, RoutedEventArgs e) { try { var dbpath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "data.db3"); using (var db = new SQLite.SQLiteConnection(dbpath)) { db.DropTable <person>(); db.Dispose(); db.Close(); } var line = new MessageDialog("Table Dropped"); await line.ShowAsync(); } catch { } }
public string createDatabase() { try { string folder = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal); mCon = new SQLiteConnection(System.IO.Path.Combine(folder, "db.db")); mCon.DropTable<User>(); { mCon.CreateTable<User>(); return "Database created"; } } catch (SQLiteException ex) { return ex.Message; } }
//Userテーブルのuserを削除するメソッド //--------------------------delete文的なの-------------------------- public static void deleteUser(int id) { //データベースに接続 using (SQLiteConnection db = new SQLiteConnection(App.dbPath)) { //db.BeginTransaction(); //このサイト https://qiita.com/alzybaad/items/9356b5a651603a548278 try { db.CreateTable <UserModel>(); db.DropTable <UserModel>(); db.Delete(id); } catch (Exception e) { db.Rollback(); System.Diagnostics.Debug.WriteLine(e); } } }
public override void ViewDidLoad () { base.ViewDidLoad (); // Figure out where the SQLite database will be. var documents = Environment.GetFolderPath(Environment.SpecialFolder.Personal); _pathToDatabase = Path.Combine(documents, "db_sqlite-net.db"); using (var conn= new SQLite.SQLiteConnection(_pathToDatabase)) { conn.DropTable<Terms>(); conn.CreateTable<Terms>(); } btnAceptar.TouchUpInside += (sender, e) => { insertTerms(); NavigationController.PopViewController(true); }; btnCancelar.TouchUpInside += (sender, e) => NavigationController.PopViewController (true); }
protected void saveProfileImage(string image) { ProfileImage profileImage = new ProfileImage(); profileImage.Base64 = image; using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(App.FilePath)) { conn.DropTable <ProfileImage>(); conn.CreateTable <ProfileImage>(); int rowsAdded = conn.Insert(profileImage); if (rowsAdded > 0) { Debug.WriteLine("Inserted Itinerary"); } else { Debug.WriteLine("Failed to Insert Itinerary"); } conn.Close(); } }
public void DropTable() => connection.DropTable <Product>();
//Delete all contactlist or delete Contacts table public void DeleteAllContact() { using (var dbConn = new SQLiteConnection(App.DB_PATH)) { //dbConn.RunInTransaction(() => // { dbConn.DropTable<GhiChu>(); dbConn.CreateTable<GhiChu>(); dbConn.Dispose(); dbConn.Close(); //}); } }
static void DropTables() { _db.DropTable <Sprayer>(); _db.DropTable <Operator>(); _db.DropTable <OrchardBlock>(); }
//~~~delete all activities public void DeleteActivities () { using (var dbConn = new SQLiteConnection(this.KreyosDBPath)) { //dbConn.RunInTransaction(() => // { dbConn.DropTable<Kreyos_User_Activities>(); dbConn.CreateTable<Kreyos_User_Activities>(); dbConn.Dispose(); dbConn.Close(); //}); } }
static public void dropNewsItemTable() { db.DropTable <NewsItem>(); }
public void CrearBBDD() { cn.DropTable <Secciones>(); cn.CreateTable <Secciones>(); }
}//DELETE CONTACT THAT I CHOSE //DELETE ALL public void DeleteAllContact() { using (var dbConn = new SQLiteConnection(App.DB_PATH)) { dbConn.DropTable<Contactos>(); dbConn.CreateTable<Contactos>(); dbConn.Dispose(); dbConn.Close(); } }
//테이블 전체 삭제 및 재생성 public bool AllTableDrop() { bool result = false; try { //DB Connection SQLiteConnection conn = new SQLiteConnection(dbPath, true); //테이블 삭제 conn.DropTable<DBForm.MoneyDBForm>(); conn.DropTable<DBForm.ExpenseCategoryForm>(); conn.DropTable<DBForm.IncomeCategoryForm>(); //연결종료 conn.Close(); //새로 테이블을 만든다. CreateDatabaseAsync(); //카테고리 새로 세팅 BasicSetting(); //어플리케이션종료하기위해 결과 값을 리턴한다. result = true; } catch (Exception ex) { ex.Message.ToString(); result = false; } return result; }
public static void Main (string[] args) { Console.WriteLine ("Hello SQLite-net Data!"); /* //Get the path to the folder where the database is stored. // Notes: The Path class performs operations on strings that contain file path info // Path.Combine appends the second path to the first path // Environment.GetSpecialFolderPath gets the path to special pre-defined folders // on Windows, the SpecialFolder enum defines: ProgramFiles, System, AppData, etc. // on Android ... string dbPath = Path.Combine ( Environment.GetFolderPath (Environment.SpecialFolder.Personal), "stocks.db3"); */ /* // Check for an existing db file and only create a new one if it doesn't exist bool exists = File.Exists (dbPath); if (!exists) { // Need to create the database and seed it with some data. SQLiteConnection.CreateFile (dbPath); */ // We're using a file in Assets instead of the one defined above //string dbPath = Directory.GetCurrentDirectory (); string dbPath = @"../../../DataAccess-Android/Assets/stocks.db3"; var db = new SQLiteConnection (dbPath); // Create a Stocks table //if (db.CreateTable (Mono.CSharp.TypeOf(Stock)) != 0) db.DropTable<Stock>(); if (db.CreateTable<Stock>() == 0) { // A table already exixts, delete any data it contains db.DeleteAll<Stock> (); } // Create a new stock and insert it into the database var newStock = new Stock (); newStock.Symbol = "APPL"; newStock.Name = "Apple"; newStock.ClosingPrice = 93.22m; int numRows = db.Insert (newStock); Console.WriteLine ("Number of rows inserted = {0}", numRows); // Insert some more stocks db.Insert(new Stock() {Symbol = "MSFT", Name = "Microsoft", ClosingPrice = 55.25m}); db.Insert (new Stock() {Symbol = "GOOG", Name = "Google", ClosingPrice = 15.25m}); db.Insert (new Stock() {Symbol = "SSNLF", Name = "Samsung", ClosingPrice = 25.25m}); db.Insert (new Stock() {Symbol = "AMZN", Name = "Amazon", ClosingPrice = 35.25m}); db.Insert (new Stock() {Symbol = "MMI", Name = "Motorola Mobility", ClosingPrice = 45.25m}); db.Insert (new Stock() {Symbol = "FB", Name = "Facebook", ClosingPrice = 65.25m}); // Read the stock from the database // Use the Get method with a query expression Stock singleItem = db.Get<Stock> (x => x.Name == "Google"); Console.WriteLine ("Stock Symbol for Google: {0}", singleItem.Symbol); singleItem = db.Get<Stock> (x => x.ClosingPrice >= 30.0m); Console.WriteLine ("First stock priced at or over 30: {0}, price: {1}", singleItem.Symbol, singleItem.ClosingPrice); // Use the Get method with a primary key singleItem = db.Get<Stock> ("FB"); Console.WriteLine ("Stock Name for Symbol FB: {0}", singleItem.Symbol); // Query using SQL var stocksStartingWithA = db.Query<Stock> ("SELECT * FROM Stocks WHERE Symbol LIKE ?", "A%"); foreach(Stock stock in stocksStartingWithA) Console.WriteLine ("Stock starting with A: {0}", stock.Symbol); // Query using Linq var stocksStartingWithM = from s in db.Table<Stock> () where s.Symbol.StartsWith ("M") select s; foreach(Stock stock in stocksStartingWithM) Console.WriteLine ("Stock starting with M: {0}", stock.Symbol); }
public async Task ClearDatabase () { using (var connection = new SQLiteConnection (dbPath, true)) await Task.Run (() => connection.DropTable<BikeTrip> ()).ConfigureAwait (false); }
/// <summary> /// Delete the Alarm entity table. /// </summary> public void DeleteAllAlarmEntities() { lock(DbLock) { using (var db = new SQLiteConnection(DatabaseHelper.GetDBPath())) { db.DropTable<AlarmEntities>(); } } }