# -*- coding: utf-8 -*-
# Copyright (c) 2018, Frappe Technologies and contributors
# License: MIT. See LICENSE

import frappe
from frappe import _
from frappe.model.document import Document
from frappe.utils import cint, now_datetime
import hashlib

class TransactionLog(Document):
	def before_insert(self):
		index = get_current_index()
		self.row_index = index
		self.timestamp = now_datetime()
		if index != 1:
			prev_hash = frappe.db.sql(
				"SELECT `chaining_hash` FROM `tabTransaction Log` WHERE `row_index` = '{0}'".format(index - 1))
			if prev_hash:
				self.previous_hash = prev_hash[0][0]
			else:
				self.previous_hash = "Indexing broken"
		else:
			self.previous_hash = self.hash_line()
		self.transaction_hash = self.hash_line()
		self.chaining_hash = self.hash_chain()
		self.checksum_version = "v1.0.1"

	def hash_line(self):
		sha = hashlib.sha256()
		sha.update(
			frappe.safe_encode(str(self.row_index)) + \
			frappe.safe_encode(str(self.timestamp)) + \
			frappe.safe_encode(str(self.data))
		)
		return sha.hexdigest()

	def hash_chain(self):
		sha = hashlib.sha256()
		sha.update(
			frappe.safe_encode(str(self.transaction_hash)) + \
			frappe.safe_encode(str(self.previous_hash))
		)
		return sha.hexdigest()


def get_current_index():
	current = frappe.db.sql("""SELECT `current`
		FROM `tabSeries`
		WHERE `name` = 'TRANSACTLOG'
		FOR UPDATE""")
	if current and current[0][0] is not None:
		current = current[0][0]

		frappe.db.sql("""UPDATE `tabSeries`
			SET `current` = `current` + 1
			where `name` = 'TRANSACTLOG'""")
		current = cint(current) + 1
	else:
		frappe.db.sql("INSERT INTO `tabSeries` (name, current) VALUES ('TRANSACTLOG', 1)")
		current = 1
	return current

# -*- coding: utf-8 -*-
# Copyright (c) 2018, Frappe Technologies and contributors
# License: MIT. See LICENSE

import frappe
from frappe import _
from frappe.model.document import Document
from frappe.utils import cint, now_datetime
import hashlib

class TransactionLog(Document):
	def before_insert(self):
		index = get_current_index()
		self.row_index = index
		self.timestamp = now_datetime()
		if index != 1:
			prev_hash = frappe.get_all("Transaction Log", filters={"row_index":str(index-1)}, pluck="chaining_hash", limit=1)
			if prev_hash:
				self.previous_hash = prev_hash[0]
			else:
				self.previous_hash = "Indexing broken"
		else:
			self.previous_hash = self.hash_line()
		self.transaction_hash = self.hash_line()
		self.chaining_hash = self.hash_chain()
		self.checksum_version = "v1.0.1"

	def hash_line(self):
		sha = hashlib.sha256()
		sha.update(
			frappe.safe_encode(str(self.row_index)) + \
			frappe.safe_encode(str(self.timestamp)) + \
			frappe.safe_encode(str(self.data))
		)
		return sha.hexdigest()

	def hash_chain(self):
		sha = hashlib.sha256()
		sha.update(
			frappe.safe_encode(str(self.transaction_hash)) + \
			frappe.safe_encode(str(self.previous_hash))
		)
		return sha.hexdigest()


def get_current_index():
	current = frappe.db.sql("""SELECT `current`
		FROM `tabSeries`
		WHERE `name` = 'TRANSACTLOG'
		FOR UPDATE""")
	if current and current[0][0] is not None:
		current = current[0][0]

		frappe.db.sql("""UPDATE `tabSeries`
			SET `current` = `current` + 1
			where `name` = 'TRANSACTLOG'""")
		current = cint(current) + 1
	else:
		frappe.db.sql("INSERT INTO `tabSeries` (name, current) VALUES ('TRANSACTLOG', 1)")
		current = 1
	return current

convert doctype transaction_log db.sql calls