protected void CreateStore(Boolean UpdateStore)
{
if (StoreExists)
{
if (!UpdateStore)
{
throw new StoreAlreadyExistsException();
}
}
else
{
#if (!WINDOWS_PHONE)
SQLiteConnection.CreateFile(FileName);
#endif
}
var connection = GetConnection(true);
try
{
foreach (var entity in this.Entities)
{
CreateTable(connection, entity);
}
}
finally
{
DoneWithConnection(connection, true);
}
}
public EntityStore(string databaseFullPath, DestructorType destructorType = DestructorType.None)
{
_databaseFullPath = databaseFullPath;
_destructorType = destructorType;
_connectionString = String.Format("Data Source={0}; Version=3; Read Only=False; Pooling=True; Max Pool Size=10", _databaseFullPath);
if (!File.Exists(_databaseFullPath))
{
SQLiteConnection.CreateFile(_databaseFullPath);
Log.Info("Successfully created the EntityStore database file at {0}", databaseFullPath);
}
else
{
Log.Info("Successfully confirmed that the EntityStore database exists at {0}", databaseFullPath);
}
using (var connection = new SQLiteConnection(_connectionString))
{
connection.Open();
using (var cmd = connection.CreateCommand())
{
Log.Debug("About to create or check for the Entities table in the EntityStore database.");
cmd.CommandText = "CREATE TABLE IF NOT EXISTS Entities (entityType TEXT, entityKey TEXT, entityBlob TEXT, entityTag TEXT, lastModified DATETIME, PRIMARY KEY (entityType, entityKey))";
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
Log.Info("Successfully created or checked that the Entities table exists in the EntityStore database.");
}
}
}
/// <summary>
/// Creates the database.
/// </summary>
public void Create()
{
var filePath = new FileInfo(dataSourcePath);
if (!filePath.Exists)
{
SQLiteConnection.CreateFile(dataSourcePath);
}
}
/// <summary>
/// Creates the database.
/// </summary>
public void Create()
{
#if !NETCORE
var filePath = new FileInfo(dataSourcePath);
if (!filePath.Exists)
{
SQLiteConnection.CreateFile(dataSourcePath);
}
#endif
}
private void CreateDbIfNotExists()
{
string path = Path.Combine(this.DBDirectory, this.DBName);
if (!File.Exists(path))
{
Directory.CreateDirectory(this.DBDirectory);
SQLiteConnectionAlias.CreateFile(Path.Combine(this.DBDirectory, this.DBName));
}
}
public static void Setup(bool useLocalFiles)
{
DataDirectory = new DirectoryInfo(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), "Gablarski"));
if (!DataDirectory.Exists)
{
DataDirectory.Create();
}
if (useLocalFiles)
{
KeyFile = new FileInfo("gablarski.key");
DbFile = new FileInfo("gablarski.db");
}
else
{
KeyFile = new FileInfo(Path.Combine(DataDirectory.FullName, "gablarski.key"));
DbFile = new FileInfo(Path.Combine(DataDirectory.FullName, "gablarski.db"));
}
#if !XAMARIN
var builder = new SQLiteConnectionStringBuilder();
builder.DataSource = DbFile.FullName;
db = new SQLiteConnection(builder.ToString());
#else
KeyFile = new FileInfo(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Personal), KeyFile.Name));
DbFile = new FileInfo(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Personal), DbFile.Name));
if (!DbFile.Exists)
{
SQLiteConnection.CreateFile(DbFile.FullName);
}
db = new SQLiteConnection("Data Source=" + DbFile.FullName);
#endif
db.Open();
CreateDbs();
}
public override void CreateStore()
{
if (StoreExists)
{
throw new StoreAlreadyExistsException();
}
#if (!WINDOWS_PHONE)
SQLiteConnection.CreateFile(FileName);
#endif
var connection = GetConnection(true);
try
{
foreach (var entity in this.Entities)
{
CreateTable(connection, entity);
}
}
finally
{
DoneWithConnection(connection, true);
}
}
