public void TestGetAllTableNames2()
{
var list = new List<string>();
using (IRepository repo = new SQLiteRepository(infoConnectionString))
{
list = repo.GetAllTableNames();
}
Assert.IsTrue(list.Count == 8);
}
public void TestGetAllViewColumns()
{
var list = new List<Column>();
using (IRepository repo = new SQLiteRepository(infoConnectionString))
{
list = repo.GetAllViewColumns();
}
Assert.IsTrue(list.Count == 11);
}
public void TestGetAllColumns2()
{
var list = new List<Column>();
using (IRepository repo = new SQLiteRepository(infoConnectionString))
{
list = repo.GetAllColumns();
}
Assert.IsTrue(list.Count == 68);
Assert.IsTrue(list[0].DataType == "integer");
}
public void TestGetAllTableNames()
{
var list = new List<string>();
using (IRepository repo = new SQLiteRepository(chinookConnectionString))
{
list = repo.GetAllTableNames();
}
Assert.IsTrue(list.Count == 11);
Assert.IsTrue(list[0] == "Album");
}
public void GetMessageC3()
{
SQLiteRepository con = new SQLiteRepository();
con.CreateDatabase();
MessageRepository messageRepository = new MessageRepository(con);
ContactRepository contactRepository = new ContactRepository(con);
Contact contact = new Contact
{
Id = 1,
FirstName = "Pablo",
LastName = "Corral",
Phone = "34676681420"
};
Contact c = new Contact
{
Id = 2,
FirstName = "Cristina",
LastName = "Gambin",
Phone = "34666666666"
};
Chat m = new Chat
{
Mensaje = "hola",
FromTo = "34676681420",
Send = true,
Created = DateTime.Now
};
Chat m1 = new Chat
{
Mensaje = "hola, que tal?",
FromTo = "34676681420",
Send = false,
Created = DateTime.Now.AddSeconds(10)
};
Chat m2 = new Chat
{
Mensaje = "hola, que tal?",
FromTo = "34666666666",
Send = false,
Created = DateTime.Now.AddSeconds(10)
};
using (var connection = con.GetConnection())
{
contactRepository.InsertContact(contact);
contactRepository.InsertContact(c);
messageRepository.InsertMessage(m);
messageRepository.InsertMessage(m1);
messageRepository.InsertMessage(m2);
var result = messageRepository.GetMessagesByPhone("34676681420").Count;
Assert.AreEqual(2, result);
}
}
public void TestCreateSQLiteTable()
{
using (IRepository sourceRepository = new SQLiteRepository(chinookSQLiteConnectionString))
{
var generator = new Generator4(sourceRepository, null, false, false, true);
generator.GenerateTableScript("Album");
var result = generator.GeneratedScript;
var lines = Regex.Split(result, "\r\n|\r|\n");
Assert.IsTrue(lines.Length == 11);
}
}
public void TestSQLiteNetCodeGenWithViews()
{
using (IRepository sourceRepository = new SQLiteRepository(infoConnectionString))
{
var generator = new Generator4(sourceRepository, null, false, false, true);
generator.GenerateSqliteNetModel("Test");
var result = generator.GeneratedScript;
var lines = Regex.Split(result, "\r\n|\r|\n");
Assert.AreEqual(264, lines.Length);
}
}
public void TestSQLiteDataTypes()
{
//cloud_service_product_infos
//;DateFormatString=yyyy-MM-dd HH:mm:ss zzz
using (IRepository sourceRepository = new SQLiteRepository(chinookSQLiteConnectionString))
{
var generator = new Generator4(sourceRepository, "sw.sql", false, false, true);
generator.GenerateTableCreate("Artist");
Assert.IsTrue(generator.GeneratedScript.Contains("INTEGER"));
}
}
public void TestSQLiteDateQuirk()
{
//cloud_service_product_infos
//;DateFormatString=yyyy-MM-dd HH:mm:ss zzz
using (IRepository sourceRepository = new SQLiteRepository(@"Data Source=C:\Users\erik\Downloads\spiceworks_prod.db"))
{
var generator = new Generator4(sourceRepository, "sw.sql");
generator.TruncateSQLiteStrings = true;
generator.ScriptDatabaseToFile(Scope.DataOnly);
}
}
public void TestGetAllIndexes()
{
var list = new List <Index>();
using (IRepository repo = new SQLiteRepository(chinookConnectionString))
{
list = repo.GetAllIndexes();
}
Assert.IsTrue(list.Count == 22);
Assert.IsTrue(list[0].IndexName == "IFK_AlbumArtistId");
}
protected override async void OnAppearing()
{
if (viewModel.Items.Count == 0)
{
viewModel.LoadItemsCommand.Execute(null);
}
ItemsListView.ItemsSource = await SQLiteRepository.Query <Pessoa>("SELECT * FROM " + typeof(Pessoa).Name);
base.OnAppearing();
}
public void TestGetAllTableNames()
{
var list = new List <string>();
using (IRepository repo = new SQLiteRepository(chinookConnectionString))
{
list = repo.GetAllTableNames();
}
Assert.IsTrue(list.Count == 11);
Assert.IsTrue(list[0] == "Album");
}
public void TestSQLiteDataTypes()
{
//cloud_service_product_infos
//;DateFormatString=yyyy-MM-dd HH:mm:ss zzz
using (IRepository sourceRepository = new SQLiteRepository(@"Data Source=C:\Code\SqlCeToolbox\src\API\SqlCeScripting40\Tests\chinook.db"))
{
var generator = new Generator4(sourceRepository, "sw.sql", false, false, true);
generator.GenerateTableCreate("Artist");
Assert.IsTrue(generator.GeneratedScript.Contains("INTEGER"));
}
}
public void TestGetAllPrimaryKeys()
{
var list = new List <PrimaryKey>();
using (IRepository repo = new SQLiteRepository(chinookConnectionString))
{
list = repo.GetAllPrimaryKeys();
}
Assert.IsTrue(list.Count == 12);
Assert.IsTrue(list[0].KeyName == "sqlite_master_PK_Album");
}
public void TestGetAllPrimaryKeys2()
{
var list = new List <PrimaryKey>();
using (IRepository repo = new SQLiteRepository(infoConnectionString))
{
list = repo.GetAllPrimaryKeys();
}
Assert.IsTrue(list.Count == 12);
Assert.IsTrue(list[0].KeyName == "CUSTOMER219ORDERS");
}
public void TestGetAllForeignKeys()
{
var list = new List <ErikEJ.SqlCeScripting.Constraint>();
using (IRepository repo = new SQLiteRepository(chinookConnectionString))
{
list = repo.GetAllForeignKeys();
}
Assert.IsTrue(list.Count == 11);
Assert.IsTrue(list[0].ConstraintName == "FK_Album_0_0");
}
public void TestGetAllColumns()
{
var list = new List <Column>();
using (IRepository repo = new SQLiteRepository(chinookConnectionString))
{
list = repo.GetAllColumns();
}
Assert.AreEqual(67, list.Count);
Assert.AreEqual("bigint", list[0].DataType);
}
public void TestGetAllPrimaryKeys2()
{
var list = new List <PrimaryKey>();
using (IRepository repo = new SQLiteRepository(infoConnectionString))
{
list = repo.GetAllPrimaryKeys();
}
Assert.AreEqual(11, list.Count);
Assert.AreEqual("CUSTOMER219ORDERS", list[0].KeyName);
}
public void TestGetAllTableNamesViewComments()
{
var list = new List <string>();
using (IRepository repo = new SQLiteRepository(viewCommentConnectionString))
{
list = repo.GetAllTableNames();
}
Assert.IsTrue(list.Count == 1);
Assert.IsTrue(list[0] == "MyTable");
}
public async Task <List <bcdb.Transaction> > Convert(List <Transaction> transactions)
{
var sqliteRepository = new SQLiteRepository();
var maxBlock = await sqliteRepository.Blocks.GetLastBlock();
var transactionList = new List <bcdb.Transaction>();
transactions.ForEach(t => transactionList.Add(Convert(t, maxBlock.BlockId)));
return(transactionList);
}
public void TestGetAllForeignKeysMultiColumnKey()
{
var list = new List <ErikEJ.SqlCeScripting.Constraint>();
using (IRepository repo = new SQLiteRepository(fkConnectionString))
{
list = repo.GetAllForeignKeys();
}
Assert.IsTrue(list.Count == 1);
Assert.IsTrue(list[0].ConstraintName == "FK_BEVERAGE_DIRECTORY_0_0");
}
public void TestGetIndexesFromTable()
{
var list = new List <Index>();
using (IRepository repo = new SQLiteRepository(chinookConnectionString))
{
list = repo.GetIndexesFromTable("Album");
}
Assert.IsTrue(list.Count == 2);
Assert.IsTrue(list[1].IndexName == "IPK_Album");
}
public void TestGetAllColumns()
{
var list = new List <Column>();
using (IRepository repo = new SQLiteRepository(chinookConnectionString))
{
list = repo.GetAllColumns();
}
Assert.IsTrue(list.Count == 64);
Assert.IsTrue(list[0].DataType == "integer");
}
public void TestPragma()
{
var sql = "pragma table_info(Album);" + Environment.NewLine + "GO";
DataSet result = null;
using (IRepository repo = new SQLiteRepository(chinookConnectionString))
{
result = repo.ExecuteSql(sql);
}
Assert.IsTrue(result.Tables.Count == 1);
}
public void TestCreateSqliteUneditableTable()
{
using (IRepository sourceRepository = new SQLiteRepository(db21Conn))
{
var generator = new Generator4(sourceRepository, null, false, false, true);
var tables = sourceRepository.GetAllTableNames();
generator.GenerateTableScript("Users");
var result = generator.GeneratedScript;
var lines = Regex.Split(result, "\r\n|\r|\n");
Assert.AreEqual(18, lines.Length, result);
}
}
public StartPage(SQLiteRepository repository)
{
InitializeComponent();
_realm = Realm.GetInstance();
if (_viewModel == null)
{
_viewModel = new StartTestViewModel(repository, _realm);
}
this.BindingContext = _viewModel;
}
/// <summary>
/// Disposes of resources used by this instance.
/// </summary>
/// <param name="disposing">A value indicating whether to dispose of managed resources.</param>
protected override void Dispose(bool disposing)
{
if (!this.disposed)
{
if (this.repository != null)
{
this.repository.Dispose();
this.repository = null;
}
this.disposed = true;
}
}
public void IfDatabaseIsEncryptedButConnectionMissingPasswordShouldThrowException()
{
var sqliteRepository = new SQLiteRepository(new ReynaNullLogger(), new byte[] { 0xFF, 0xEE, 0xDD, 0x10, 0x20, 0x30 });
sqliteRepository.Create();
var assemblyFile = new FileInfo(Assembly.GetExecutingAssembly().ManifestModule.FullyQualifiedName);
var path = Path.Combine(assemblyFile.DirectoryName, "reyna.db");
this.ExecuteScalar("SELECT count(1) FROM sqlite_master WHERE type='table' AND name not like 'sqlite?_%' escape '?'", path);
File.Delete(path);
}
public PessoasPage()
{
InitializeComponent();
//Cria um callback (Watcher, Observable) que será executado após um Sync de success (automático)
listPessoaSubscription = new Subscription <Pessoa>(() => {
Device.BeginInvokeOnMainThread(async() => {
MyListView.ItemsSource = await SQLiteRepository.Query <Pessoa>("SELECT * FROM " + typeof(Pessoa).Name);
});
});
//Chama o callback criado acima (para listar e não precisar esperar que o App faça uma requisição)
listPessoaSubscription.Callback.Invoke();
}
public MainWindow()
{
InitializeComponent();
this._logger = LogManager.GetCurrentClassLogger();
this._sqliteProductITemExecutor = new SqlProductItemExecutor();
this._sqLiteRepository = new SQLiteRepository(_sqliteProductITemExecutor, _logger);
_sqLiteRepository.AddProductItem(new ProductItemModel()
{
Id = Guid.NewGuid()
});
}
private async void GetChainFromDB()
{
var sqliteRepository = new SQLiteRepository();
var chainDB = await sqliteRepository.Blocks.GetEntityListAsync();
if (chainDB != null)
{
_chain.AddRange(blockChainConverter.Convert(chainDB));
}
else
{
await CreateNewBlock(proof : 100, previousHash : "1");
}
}
public void GetMessagesByPhoneAndDate()
{
SQLiteRepository con = new SQLiteRepository();
con.CreateDatabase();
MessageRepository messageRepository = new MessageRepository(con);
ContactRepository contactRepository = new ContactRepository(con);
Contact contact = new Contact
{
Id = 1,
FirstName = "Pablo",
LastName = "Corral",
Phone = "34676681420"
};
Chat m = new Chat
{
Mensaje = "hola",
FromTo = "34676681420",
Send = true,
Created = DateTime.Now.AddDays(-4),
Seen = true
};
Chat m1 = new Chat
{
Mensaje = "que tal estas",
FromTo = "34676681420",
Send = true,
Created = DateTime.Now.AddDays(-3),
Seen = true
};
Chat m2 = new Chat
{
Mensaje = "donde vamos",
FromTo = "34676681420",
Send = true,
Created = DateTime.Now,
Seen = true
};
using (var connection = con.GetConnection())
{
contactRepository.InsertContact(contact);
messageRepository.InsertChat(m);
messageRepository.InsertChat(m1);
messageRepository.InsertChat(m2);
var result = messageRepository.GetMessagesByPhoneAndDate("34676681420", DateTime.Now.AddDays(-1));
Assert.AreEqual(1, result.Count);
}
}
public async Task NotInitializedAsync()
{
IRepository <int, SQLiteDbItem> localRepository = new SQLiteRepository <int, SQLiteDbItem>(null, new SQLiteRepositoryOptions
{
ConnectionString = GetTempDbName()
});
localRepository.IsInitialized.Should().BeTrue();
await localRepository.InsertAsync(new SQLiteDbItem
{
Id = 1,
Data = string.Empty
});
}
public static IAccountRepository GetRepository(string repositoryType)
{
IAccountRepository repo = null;
switch (repositoryType)
{
case "SQLite":
repo = new SQLiteRepository();
break;
default:
throw new ArgumentException("Invalid Repository Type");
}
return(repo);
}
public void TestGetAllIndexes()
{
var list = new List<Index>();
using (IRepository repo = new SQLiteRepository(chinookConnectionString))
{
list = repo.GetAllIndexes();
}
Assert.IsTrue(list.Count == 22);
Assert.IsTrue(list[0].IndexName == "IFK_AlbumArtistId");
}
public void TestGetIndexesFromTable()
{
var list = new List<Index>();
using (IRepository repo = new SQLiteRepository(chinookConnectionString))
{
list = repo.GetIndexesFromTable("Album");
}
Assert.IsTrue(list.Count == 2);
Assert.IsTrue(list[1].IndexName == "IPK_Album");
}
public void TestDatabaseInfo()
{
var values = new List<KeyValuePair<string, string>>();
using (IRepository repo = new SQLiteRepository(chinookConnectionString))
{
values = repo.GetDatabaseInfo();
}
Assert.IsTrue(values.Count == 4);
}
public void TestParse()
{
var sql = "SELECT * FROM Album;" + Environment.NewLine + "GO";
var result = string.Empty;
using (IRepository repo = new SQLiteRepository(chinookConnectionString))
{
result = repo.ParseSql(sql);
}
Assert.IsTrue(result.StartsWith("SCAN "));
sql = "SELECT * FROM Album WHERE AlbumId = 1;" + Environment.NewLine + "GO";
using (IRepository repo = new SQLiteRepository(chinookConnectionString))
{
result = repo.ParseSql(sql);
}
Assert.IsTrue(result.StartsWith("SEARCH TABLE "));
}
public void TestPragma()
{
var sql = "pragma table_info(Album);" + Environment.NewLine + "GO";
DataSet result = null;
using (IRepository repo = new SQLiteRepository(chinookConnectionString))
{
result = repo.ExecuteSql(sql);
}
Assert.IsTrue(result.Tables.Count == 1);
}
public void TestGetDataFromReader()
{
var columns = new List<Column>
{ new Column { ColumnName = "AlbumId"},
new Column { ColumnName = "Title"},
new Column { ColumnName = "ArtistId"},
};
IDataReader reader = null;
using (IRepository repo = new SQLiteRepository(chinookConnectionString))
{
reader = repo.GetDataFromReader("Album", columns);
while (reader.Read())
{
Assert.IsTrue(reader.GetValue(0).GetType() == typeof(long));
Assert.IsTrue(reader.GetValue(2).GetType() == typeof(long));
}
}
}
public void TestGetAllTriggers()
{
var list = new List<Trigger>();
using (IRepository repo = new SQLiteRepository(infoConnectionString))
{
list = repo.GetAllTriggers();
}
Assert.IsTrue(list.Count == 0);
}
public void BootstrapsPullUpAndExcecuteJobWithHttpApplicationEntryPoint()
{
string path = ApplicationUtils.CreateValidExampleApplication();
using (Bootstraps bootstraps = new Bootstraps(path, null, 500))
{
Assert.AreEqual(BootstrapsPullupResultType.Success, bootstraps.PullUp(true).ResultType);
CreateFileJob job = new CreateFileJob()
{
Path = Path.Combine(path, Path.GetRandomFileName())
};
Assert.IsFalse(File.Exists(job.Path));
using (IRepository repository = new SQLiteRepository(string.Format(CultureInfo.InvariantCulture, "data source={0};journal mode=Off;synchronous=Off;version=3", Path.Combine(path, "BlueCollar.sqlite"))))
{
job.Enqueue("Default", null, repository);
}
Thread.Sleep(6000);
Assert.IsTrue(File.Exists("HttpApplicationStart"));
bootstraps.Pushdown(true);
Assert.IsTrue(File.Exists("HttpApplicationEnd"));
}
}
public void TestGetAllForeignKeys()
{
var list = new List<ErikEJ.SqlCeScripting.Constraint>();
using (IRepository repo = new SQLiteRepository(chinookConnectionString))
{
list = repo.GetAllForeignKeys();
}
Assert.IsTrue(list.Count == 11);
Assert.IsTrue(list[0].ConstraintName == "FK_Album_0_0");
}
public void TestCreateSQLiteTable()
{
using (IRepository sourceRepository = new SQLiteRepository(chinookSQLiteConnectionString))
{
var generator = new Generator4(sourceRepository, null, false, false, true);
generator.GenerateTableScript("Album");
var result = generator.GeneratedScript;
var lines = Regex.Split(result, "\r\n|\r|\n");
Assert.IsTrue(lines.Length == 11);
}
}
public void TestSQLiteNetCodeGenWithViews()
{
using (IRepository sourceRepository = new SQLiteRepository(infoConnectionString))
{
var generator = new Generator4(sourceRepository, null, false, false, true);
generator.GenerateSqliteNetModel("Test");
var result = generator.GeneratedScript;
var lines = Regex.Split(result, "\r\n|\r|\n");
Assert.AreEqual(264, lines.Length);
}
}
public void TestGetAllPrimaryKeys2()
{
var list = new List<PrimaryKey>();
using (IRepository repo = new SQLiteRepository(infoConnectionString))
{
list = repo.GetAllPrimaryKeys();
}
Assert.IsTrue(list.Count == 12);
Assert.IsTrue(list[0].KeyName == "CUSTOMER219ORDERS");
}
public void BootstrapsPullUpAndExecuteJob()
{
string path = ApplicationUtils.CreateValidExampleApplication();
using (Bootstraps bootstraps = new Bootstraps(path, null, 500))
{
Assert.AreEqual(BootstrapsPullupResultType.Success, bootstraps.PullUp(true).ResultType);
CreateFileJob job = new CreateFileJob()
{
Path = Path.Combine(path, Path.GetRandomFileName())
};
Assert.IsFalse(File.Exists(job.Path));
// The default configuration specifies a SQLite repository pointing
// to BlueCollar.sqlite in the application's root directory.
using (IRepository repository = new SQLiteRepository(string.Format(CultureInfo.InvariantCulture, "data source={0};journal mode=Off;synchronous=Off;version=3", Path.Combine(path, "BlueCollar.sqlite"))))
{
job.Enqueue("Default", null, repository);
}
// Default worker heartbeat is 5 seconds.
Thread.Sleep(6000);
Assert.IsTrue(File.Exists(job.Path));
}
}
public void TestSQLiteDateQuirk()
{
//cloud_service_product_infos
//;DateFormatString=yyyy-MM-dd HH:mm:ss zzz
using (IRepository sourceRepository = new SQLiteRepository(@"Data Source=C:\Users\erik\Downloads\spiceworks_prod.db"))
{
var generator = new Generator4(sourceRepository, "sw.sql");
generator.TruncateSQLiteStrings = true;
generator.ScriptDatabaseToFile(Scope.DataOnly);
}
}
public void TestSQLiteDataTypes()
{
//cloud_service_product_infos
//;DateFormatString=yyyy-MM-dd HH:mm:ss zzz
using (IRepository sourceRepository = new SQLiteRepository(@"Data Source=C:\Users\erik\Downloads\spiceworks_prod.db"))
{
var generator = new Generator4(sourceRepository, "sw.sql");
generator.GenerateTableCreate("alerts");
}
}
public void TestGetAllPrimaryKeys()
{
var list = new List<PrimaryKey>();
using (IRepository repo = new SQLiteRepository(chinookConnectionString))
{
list = repo.GetAllPrimaryKeys();
}
Assert.IsTrue(list.Count == 12);
Assert.IsTrue(list[0].KeyName == "sqlite_master_PK_Album");
}
