public static void Main (string[] args)
{
dao = new SQLiteDAO ("../../../big-database.sqlite");
var newDAO = new SQLiteDAO ("../../../pizza-1000.sqlite");
var minBlock = 56044;
var maxBlock = 57043;
insertPayments (minBlock, maxBlock, newDAO);
Console.Out.WriteLine ("payments inserted");
var interestingAddresses = new List<Address> ();
for (int i = minBlock; i <= maxBlock; i++) {
var newAddresses = addressesInBlock (i);
foreach (var address in newAddresses) {
if (!interestingAddresses.Any (a => a.ID == address.ID)) {
interestingAddresses.Add (address);
}
}
}
Console.Out.WriteLine ("found " + interestingAddresses.Count + " addresses");
using (var context = newDAO.NewDataContext) {
context.GetTable<Address> ().InsertAllOnSubmit (interestingAddresses);
context.SubmitChanges ();
Console.Out.WriteLine ("inserted " + interestingAddresses.Count + " addresses");
updateFirstOcccurrences (interestingAddresses, minBlock, maxBlock);
context.SubmitChanges ();
Console.Out.WriteLine ("first occurences updated");
foreach (var address in interestingAddresses) {
var profit = address.BalanceAfterBlock (maxBlock);
if (profit > 0) {
address.Profit = profit;
}
}
context.SubmitChanges ();
Console.Out.WriteLine ("balance updated");
}
insertOtherTables (minBlock, maxBlock, newDAO);
Console.Out.WriteLine ("other tables inserted");
}
private static void insertPayments(int minBlock, int maxBlock, SQLiteDAO newDAO) {
Console.Out.WriteLine ("blocks between " + minBlock + " and " + maxBlock);
using (var oldContext = dao.NewDataContext) {
using (var newContext = newDAO.NewDataContext) {
var blocks = oldContext.GetTable<Block> ().Where (b => (b.Height >= minBlock && b.Height <= maxBlock));
var payments = newContext.GetTable<Payment> ();
foreach (var block in blocks) {
Console.WriteLine ("Block " + block.Height);
// insert payments
foreach (var tx in block.Transactions) {
// negative values
foreach (var input in tx.Inputs) {
Payment payment = new Payment {
AddressID = input.AddressID,
TransactionID = input.TransactionID,
BlockHeight = block.Height,
Value = -input.Value
};
payments.InsertOnSubmit (payment);
}
// positive values
foreach (var output in tx.Outputs) {
Payment payment = new Payment {
AddressID = output.AddressID,
TransactionID = output.TransactionID,
BlockHeight = block.Height,
Value = output.Value
};
payments.InsertOnSubmit (payment);
}
}
}
newContext.SubmitChanges ();
Console.WriteLine ("changes submitted");
}
}
}
// Use this for initialization
void Start () {
lines = new List<GameObject>();
// load data
var slash = Path.DirectorySeparatorChar;
var dataPath = Application.dataPath + slash + ".." + slash + ".." + slash + "database.sqlite";
Debug.Log ("Looking for SQLite file at: " + dataPath);
BitcoinDAO dao = new SQLiteDAO(dataPath);
var blocks = dao.Blocks.Take(5000).ToList();
float halfBlocks = blocks.Count / 2f;
foreach (Block b in blocks) {
GameObject line = GameObject.CreatePrimitive(PrimitiveType.Cylinder);
float blockTransactions = (float) b.Transactions.Count;
line.transform.localScale = new Vector3(0.2f, blockTransactions*2, 0.2f);
line.transform.position = new Vector3((b.Height-halfBlocks)*0.2f, -blockTransactions, 0);
line.GetComponent<MeshRenderer>().enabled=false;
Vector3 top = new Vector3((b.Height-halfBlocks)*0.2f, blockTransactions, 0);
Vector3 bottom = new Vector3((b.Height-halfBlocks)*0.2f, -blockTransactions, 0);
LineRenderer lRend = line.AddComponent<LineRenderer>() as LineRenderer;
lRend.material = new Material(Shader.Find("Particles/Additive"));
lRend.SetVertexCount(2);
lRend.SetColors(Color.red, Color.green);
lRend.SetPosition (0, top);
lRend.SetPosition(1, bottom);
lRend.SetWidth(0.2f,0.2f);
line.AddComponent<BlockInfos>();
line.GetComponent<BlockInfos>().Height = b.Height;
line.GetComponent<BlockInfos>().TransactionCount = b.Transactions.Count;
line.GetComponent<BlockInfos>().TimeStamp= b.Timestamp;
lines.Add (line);
}
}
private static void insertOtherTables(int minBlock, int maxBlock, SQLiteDAO newDAO) {
var oldBlocks = dao.Blocks.Where (b => (b.Height >= minBlock && b.Height <= maxBlock));
var blocks = new List<Block> ();
var transactions = new List<Transaction> ();
var outputs = new List<Output> ();
foreach (var block in oldBlocks) {
if (!blocks.Any (b => b.ID == block.ID)) {
blocks.Add (block);
}
foreach (var tx in block.Transactions) {
if (transactions.Exists (t => t.ID == tx.ID)) {
Console.Out.WriteLine ("found double: " + tx.ID);
} else {
transactions.Add (tx);
// Console.Out.WriteLine (tx.ID);
// context.GetTable<Transaction>().InsertOnSubmit (tx);
// context.SubmitChanges ();
}
foreach (var output in tx.Outputs) {
if (!outputs.Any (o => o.ID == output.ID)) {
outputs.Add (output);
}
}
}
}
using (var context = newDAO.NewDataContext) {
context.GetTable<Block> ().InsertAllOnSubmit (blocks);
Console.Out.WriteLine ("inserting " + blocks.Count + " blocks");
context.SubmitChanges ();
}
// //context.GetTable<Transaction>().InsertAllOnSubmit (transactions);
// var txTable = context.GetTable<Transaction> ();
// Console.Out.WriteLine ("inserting " + transactions.Count + " transactions");
// foreach (var tx in transactions) {
// txTable.InsertOnSubmit (tx);
// Console.Out.WriteLine (tx.ID);
// context.SubmitChanges ();
// }
//
// context.SubmitChanges ();
//
// context.GetTable<Output> ().InsertAllOnSubmit (outputs);
// Console.Out.WriteLine ("inserting " + outputs.Count + " outputs");
// context.SubmitChanges ();
Console.Out.WriteLine ("all changes submitted");
}
