Python revert_series_if_lastの例

コード例 #1

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)

コード例 #2

ファイル: delete_doc.py プロジェクト: 81552433qqcom/frappe

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)

コード例 #3

ファイル: utils.py プロジェクト: ovenube/nubefact_integration

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)

コード例 #4

ファイル: test_naming.py プロジェクト: DAP-official-com/frappe

	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})

コード例 #5

	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)

コード例 #6

ファイル: test_document.py プロジェクト: ESS-LLP/frappe

	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)

コード例 #7

ファイル: test_naming.py プロジェクト: ESS-LLP/frappe

	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)

コード例 #8

    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)

コード例 #9

ファイル: test_naming.py プロジェクト: adnanmunir83/frappe

    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)

コード例 #10

ファイル: test_runner.py プロジェクト: sivankar/frappe

 def revert_naming(d):
     if getattr(d, 'naming_series', None):
         revert_series_if_last(d.naming_series, d.name)

コード例 #11

	def on_trash(self):
		from frappe.model.naming import revert_series_if_last
		revert_series_if_last(self.series, self.name)

コード例 #12

ファイル: batch.py プロジェクト: vignesharumainayagam/engagex-erpnext-backup-

	def after_delete(self):
		revert_series_if_last(get_batch_naming_series(), self.name)

コード例 #13

	def after_delete(self):
		revert_series_if_last(get_batch_naming_series(), self.name)

コード例 #14

ファイル: salary_slip.py プロジェクト: abhimanyu888/OpenSourceERP

	def on_trash(self):
		from frappe.model.naming import revert_series_if_last
		revert_series_if_last(self.series, self.name)

コード例 #15

ファイル: test_runner.py プロジェクト: ESS-LLP/frappe

	def revert_naming(d):
		if getattr(d, 'naming_series', None):
			revert_series_if_last(d.naming_series, d.name)