def update_naming_series(doc): if doc.meta.autoname: if doc.meta.autoname.startswith("naming_series:") \ and getattr(doc, "naming_series", None): revert_series_if_last(doc.naming_series, doc.name) elif doc.meta.autoname.split(":")[0] not in ("Prompt", "field", "hash"): revert_series_if_last(doc.meta.autoname, doc.name)
def update_naming_series(doc): if doc.meta.autoname: if doc.meta.autoname.startswith("naming_series:") \ and getattr(doc, "naming_series", None): revert_series_if_last(doc.naming_series, doc.name) elif doc.meta.autoname.split(":")[0] not in ("Prompt", "field", "hash"): revert_series_if_last(doc.meta.autoname, doc.name)
def revert_fee_numero_comprobante(serie_comprobante, numero_comprobante, serie_nota_credito="", numero_nota_credito=""): if serie_nota_credito != "": revert_series_if_last(serie_nota_credito, numero_nota_credito) else: revert_series_if_last(serie_comprobante, numero_comprobante)
def test_revert_series(self): from datetime import datetime year = datetime.now().year series = 'TEST-{}-'.format(year) key = 'TEST-.YYYY.-' name = 'TEST-{}-00001'.format(year) frappe.db.sql("""INSERT INTO `tabSeries` (name, current) values (%s, 1)""", (series,)) revert_series_if_last(key, name) current_index = frappe.db.sql("""SELECT current from `tabSeries` where name = %s""", series, as_dict=True)[0] self.assertEqual(current_index.get('current'), 0) frappe.db.delete("Series", {"name": series}) series = 'TEST-{}-'.format(year) key = 'TEST-.YYYY.-.#####' name = 'TEST-{}-00002'.format(year) frappe.db.sql("""INSERT INTO `tabSeries` (name, current) values (%s, 2)""", (series,)) revert_series_if_last(key, name) current_index = frappe.db.sql("""SELECT current from `tabSeries` where name = %s""", series, as_dict=True)[0] self.assertEqual(current_index.get('current'), 1) frappe.db.delete("Series", {"name": series}) series = 'TEST-' key = 'TEST-' name = 'TEST-00003' frappe.db.delete("Series", {"name": series}) frappe.db.sql("""INSERT INTO `tabSeries` (name, current) values (%s, 3)""", (series,)) revert_series_if_last(key, name) current_index = frappe.db.sql("""SELECT current from `tabSeries` where name = %s""", series, as_dict=True)[0] self.assertEqual(current_index.get('current'), 2) frappe.db.delete("Series", {"name": series}) series = 'TEST1-' key = 'TEST1-.#####.-2021-22' name = 'TEST1-00003-2021-22' frappe.db.delete("Series", {"name": series}) frappe.db.sql("""INSERT INTO `tabSeries` (name, current) values (%s, 3)""", (series,)) revert_series_if_last(key, name) current_index = frappe.db.sql("""SELECT current from `tabSeries` where name = %s""", series, as_dict=True)[0] self.assertEqual(current_index.get('current'), 2) frappe.db.delete("Series", {"name": series}) series = '' key = '.#####.-2021-22' name = '00003-2021-22' frappe.db.delete("Series", {"name": series}) frappe.db.sql("""INSERT INTO `tabSeries` (name, current) values (%s, 3)""", (series,)) revert_series_if_last(key, name) current_index = frappe.db.sql("""SELECT current from `tabSeries` where name = %s""", series, as_dict=True)[0] self.assertEqual(current_index.get('current'), 2) frappe.db.delete("Series", {"name": series})
def test_naming_series(self): data = ["TEST-", "TEST/17-18/.test_data./.####", "TEST.YYYY.MM.####"] for series in data: name = make_autoname(series) prefix = series if ".#" in series: prefix = series.rsplit('.',1)[0] prefix = parse_naming_series(prefix) old_current = frappe.db.get_value('Series', prefix, "current", order_by="name") revert_series_if_last(series, name) new_current = cint(frappe.db.get_value('Series', prefix, "current", order_by="name")) self.assertEqual(cint(old_current) - 1, new_current)
def test_naming_series(self): data = ["TEST-", "TEST/17-18/.test_data./.####", "TEST.YYYY.MM.####"] for series in data: name = make_autoname(series) prefix = series if ".#" in series: prefix = series.rsplit('.',1)[0] prefix = parse_naming_series(prefix) old_current = frappe.db.get_value('Series', prefix, "current", order_by="name") revert_series_if_last(series, name) new_current = cint(frappe.db.get_value('Series', prefix, "current", order_by="name")) self.assertEqual(cint(old_current) - 1, new_current)
def test_revert_series(self): from datetime import datetime year = datetime.now().year series = 'TEST-{}-'.format(year) key = 'TEST-.YYYY.-' name = 'TEST-{}-00001'.format(year) frappe.db.sql("""INSERT INTO `tabSeries` (name, current) values (%s, 1)""", (series,)) revert_series_if_last(key, name) count = frappe.db.sql("""SELECT current from `tabSeries` where name = %s""", series, as_dict=True)[0] self.assertEqual(count.get('current'), 0) frappe.db.sql("""delete from `tabSeries` where name = %s""", series) series = 'TEST-{}-'.format(year) key = 'TEST-.YYYY.-.#####' name = 'TEST-{}-00002'.format(year) frappe.db.sql("""INSERT INTO `tabSeries` (name, current) values (%s, 2)""", (series,)) revert_series_if_last(key, name) count = frappe.db.sql("""SELECT current from `tabSeries` where name = %s""", series, as_dict=True)[0] self.assertEqual(count.get('current'), 1) frappe.db.sql("""delete from `tabSeries` where name = %s""", series) series = 'TEST-' key = 'TEST-' name = 'TEST-00003' frappe.db.sql("""INSERT INTO `tabSeries` (name, current) values (%s, 3)""", (series,)) revert_series_if_last(key, name) count = frappe.db.sql("""SELECT current from `tabSeries` where name = %s""", series, as_dict=True)[0] self.assertEqual(count.get('current'), 2) frappe.db.sql("""delete from `tabSeries` where name = %s""", series)
def test_revert_series(self): from datetime import datetime year = datetime.now().year series = "TEST-{}-".format(year) key = "TEST-.YYYY.-" name = "TEST-{}-00001".format(year) frappe.db.sql( """INSERT INTO `tabSeries` (name, current) values (%s, 1)""", (series, )) revert_series_if_last(key, name) count = frappe.db.sql( """SELECT current from `tabSeries` where name = %s""", series, as_dict=True)[0] self.assertEqual(count.get("current"), 0) frappe.db.sql("""delete from `tabSeries` where name = %s""", series) series = "TEST-{}-".format(year) key = "TEST-.YYYY.-.#####" name = "TEST-{}-00002".format(year) frappe.db.sql( """INSERT INTO `tabSeries` (name, current) values (%s, 2)""", (series, )) revert_series_if_last(key, name) count = frappe.db.sql( """SELECT current from `tabSeries` where name = %s""", series, as_dict=True)[0] self.assertEqual(count.get("current"), 1) frappe.db.sql("""delete from `tabSeries` where name = %s""", series) series = "TEST-" key = "TEST-" name = "TEST-00003" frappe.db.sql("DELETE FROM `tabSeries` WHERE `name`=%s", series) frappe.db.sql( """INSERT INTO `tabSeries` (name, current) values (%s, 3)""", (series, )) revert_series_if_last(key, name) count = frappe.db.sql( """SELECT current from `tabSeries` where name = %s""", series, as_dict=True)[0] self.assertEqual(count.get("current"), 2) frappe.db.sql("""delete from `tabSeries` where name = %s""", series)
def test_revert_series(self): series = 'TEST-2018-' key = 'TEST-.YYYY.-' name = 'TEST-2018-00001' frappe.db.sql( """INSERT INTO `tabSeries` (name, current) values (%s, 1)""", (series, )) revert_series_if_last(key, name) count = frappe.db.sql( """SELECT current from `tabSeries` where name = %s""", series, as_dict=True)[0] self.assertEqual(count.get('current'), 0) frappe.db.sql("""delete from `tabSeries` where name = %s""", series) series = 'TEST-2018-' key = 'TEST-.YYYY.-.#####' name = 'TEST-2018-00002' frappe.db.sql( """INSERT INTO `tabSeries` (name, current) values (%s, 2)""", (series, )) revert_series_if_last(key, name) count = frappe.db.sql( """SELECT current from `tabSeries` where name = %s""", series, as_dict=True)[0] self.assertEqual(count.get('current'), 1) frappe.db.sql("""delete from `tabSeries` where name = %s""", series) series = 'TEST-' key = 'TEST-' name = 'TEST-00003' frappe.db.sql( """INSERT INTO `tabSeries` (name, current) values (%s, 3)""", (series, )) revert_series_if_last(key, name) count = frappe.db.sql( """SELECT current from `tabSeries` where name = %s""", series, as_dict=True)[0] self.assertEqual(count.get('current'), 2) frappe.db.sql("""delete from `tabSeries` where name = %s""", series)
def revert_naming(d): if getattr(d, 'naming_series', None): revert_series_if_last(d.naming_series, d.name)
def on_trash(self): from frappe.model.naming import revert_series_if_last revert_series_if_last(self.series, self.name)
def after_delete(self): revert_series_if_last(get_batch_naming_series(), self.name)
def after_delete(self): revert_series_if_last(get_batch_naming_series(), self.name)
def on_trash(self): from frappe.model.naming import revert_series_if_last revert_series_if_last(self.series, self.name)
def revert_naming(d): if getattr(d, 'naming_series', None): revert_series_if_last(d.naming_series, d.name)