CuneiTable - ประวัติรุ่นแก้ไข

Tenko: /* General Table Tail */

2024-06-20T08:06:41Z

General Table Tail

←รุ่นแก้ไขก่อนหน้า		รุ่นแก้ไขเมื่อ 15:06, 20 มิถุนายน 2567
บรรทัดที่ 598:		บรรทัดที่ 598:
	\|}		\|}

			==== The Working of General Table Tail ====
	The workings of this macro can be thus summarized:		The workings of this macro can be thus summarized:
	# '''Run the ''general_form_tail'' for the table's in-line form or full-form.		# '''Run the ''general_form_tail'' for the table's in-line form or full-form.

Tenko เมื่อ 02:54, 20 มิถุนายน 2567

2024-06-20T02:54:30Z

←รุ่นแก้ไขก่อนหน้า		รุ่นแก้ไขเมื่อ 09:54, 20 มิถุนายน 2567
บรรทัดที่ 1:		บรรทัดที่ 1:
	CuneiTable is designed specifically to enable in-line data entry. Design-wise, it is more limited than CuneiForm since design flexibility is not highly expected from table-~~rype~~ objects. In essence, CuneiTable is a wrapper for the accompanying CuneiForm, whether that form be the in-line type or the full expansion type.		CuneiTable is designed specifically to enable in-line data entry. Design-wise, it is more limited than CuneiForm since design flexibility is not highly expected from table-type objects. In essence, CuneiTable is a wrapper for the accompanying CuneiForm, whether that form be the in-line type or the full expansion type.

	== Define ==		== Define ==

Tenko: /* Shortcut */

2024-06-19T09:27:11Z

Shortcut

←รุ่นแก้ไขก่อนหน้า		รุ่นแก้ไขเมื่อ 16:27, 19 มิถุนายน 2567
บรรทัดที่ 1,143:		บรรทัดที่ 1,143:
	return ...		return ...

	real_mes = interpret_mes_request(request.args, 3) if mes_dict is None else interpret_mes_request(mes_dict, 3)		real_mes = interpret_mes_request(request.args, 3) if mes_dict is None
			else interpret_mes_request(mes_dict, 3)
	req_prefix = request.args.get("prefix", None)		req_prefix = request.args.get("prefix", None)
	prefix = prefix if req_prefix is None else req_prefix		prefix = prefix if req_prefix is None else req_prefix
บรรทัดที่ 1,150:		บรรทัดที่ 1,151:
	# Append search tables into table.sch_tbs		# Append search tables into table.sch_tbs
	# ...		# ...
	dbtype, tbname~~, model, module, ref_tbname~~ = "table", "<database_file_name>"~~, ProdGrp, iv_moddata[~~"~~code~~"], "<~~table_name~~>"		dbtype, tbname = "table", "<database_file_name>"
	new_default, fetch_all = ~~function_that_return_default_val_dict,~~ function_that_return_all_entries_in_the_database		# If the table name and the database name do not match. Also do:
			# ref_tbname = "<table_name>"
			model, module = CuneiModelClass, "<module_code>"
			new_default = function_that_return_default_val_dict
			fetch_all = function_that_return_all_entries_in_the_database
	return single_tb_page(dbtype, tbname, model, module, table, new_default, fetch_all, request,		return single_tb_page(dbtype, tbname, model, module, table, new_default, fetch_all, request,
	import_form=import_form,		import_form=import_form,
บรรทัดที่ 1,157:		บรรทัดที่ 1,162:
	pin_args=...,		pin_args=...,
	back_route=...,		back_route=...,
	ref_tbname=ref_tbname)		ref_tbname=ref_tbname) # If necessary.
	</syntaxhighlight>		</syntaxhighlight>

Tenko: /* Shortcut */

2024-06-19T09:23:37Z

Shortcut

@@ บรรทัดที่ 1,131: / บรรทัดที่ 1,131: @@
 <syntaxhighlight lang='python' line=1>
-pass
+@blueprint_name.route("path_name", methods=["GET", "POST"])
 </syntaxhighlight>

Tenko: /* Search Table with a Stand-alone Page */

2024-06-19T09:13:57Z

Search Table with a Stand-alone Page

@@ บรรทัดที่ 1,028: / บรรทัดที่ 1,028: @@
 <syntaxhighlight lang='python' line=1>
-pass
+@blueprint_name.route("path_name", methods=["GET", "POST"])
 </syntaxhighlight>

Tenko: /* Simple Search Table */

2024-06-19T09:11:56Z

Simple Search Table

←รุ่นแก้ไขก่อนหน้า		รุ่นแก้ไขเมื่อ 16:11, 19 มิถุนายน 2567
บรรทัดที่ 973:		บรรทัดที่ 973:
	=== Simple Search Table ===		=== Simple Search Table ===
	<syntaxhighlight lang='python' line=1>		<syntaxhighlight lang='python' line=1>
	@~~<blueprint>~~.route("<submit_path>", methods=["POST"])		@blueprint_name.route("<submit_path>", methods=["POST"])
	def <function_name>(table=None, prefix="ChqSchTable", *kwargs):		def function_name(table=None, prefix="ChqSchTable", *kwargs):
	if table is None:		if table is None:
	req_prefix = request.args.get("prefix", None)		req_prefix = request.args.get("prefix", None)
	prefix = prefix if req_prefix is None else req_prefix		prefix = prefix if req_prefix is None else req_prefix
	table = ~~ChqSchTable~~(prefix=prefix, searchable=True, editable=False)		table = TableClass(prefix=prefix, searchable=True, editable=False)
	identifier = json.loads(request.form.get("sel_iden" if request.form.get("mode")=="sel" \		identifier = json.loads(request.form.get("sel_iden" if request.form.get("mode")=="sel" \
	else "identifier"))		else "identifier"))
บรรทัดที่ 996:		บรรทัดที่ 996:
	else:		else:
	# Re-format the results as a list of dict.		# Re-format the results as a list of dict.
	response_data = [ {<col0>:<row0_value0>, <col1>:<row0_value1>, ...},		response_data = [ {col0:row0_value0, col1:row0_value1, ...},
	{<col0>:<row1_value0>, <col1>:<row1_value1>, ...},		{col0:row1_value0, col1:row1_value1, ...},
	... ]		... ]
	return jsonify({"data":response_data, "gr_status":"success"})		return jsonify({"data":response_data, "gr_status":"success"})
บรรทัดที่ 1,012:		บรรทัดที่ 1,012:
	# Re-format the results as an array of array.		# Re-format the results as an array of array.
	# The order in each sub-array reflects the table's columns.		# The order in each sub-array reflects the table's columns.
	response_data = [ [<row0_value0>, <row0_value1>, <row0_value2>, ...],		response_data = [ [row0_value0, row0_value1, row0_value2, ...],
	[<row1_value0>, <row1_value1>, <row1_value2>, ...],		[row1_value0, row1_value1, row1_value2, ...],
	... ]		... ]
	return jsonify({"data":response_data})		return jsonify({"data":response_data})

Tenko: /* Search Table with a Stand-alone Page */

2024-06-19T05:52:15Z

Search Table with a Stand-alone Page

←รุ่นแก้ไขก่อนหน้า		รุ่นแก้ไขเมื่อ 12:52, 19 มิถุนายน 2567
บรรทัดที่ 1,024:		บรรทัดที่ 1,024:

	=== Search Table with a Stand-alone Page ===		=== Search Table with a Stand-alone Page ===

			This example is extracted from the route that handles the [[#Shortcut]] form below. So, it can seem excessive in places. Feel free to cut and trim when adapting this pattern to your need.

			<syntaxhighlight lang='python' line=1>
			pass
			</syntaxhighlight>

	==== Shortcut ====		==== Shortcut ====

			<syntaxhighlight lang='python' line=1>
			pass
			</syntaxhighlight>

	== Future Development ==		== Future Development ==

Tenko: /* Simple Search Table */

2024-06-19T05:47:15Z

Simple Search Table

←รุ่นแก้ไขก่อนหน้า		รุ่นแก้ไขเมื่อ 12:47, 19 มิถุนายน 2567
บรรทัดที่ 984:		บรรทัดที่ 984:
	# ...		# ...
	# ...		# ...
	~~fetch = True if request.args.get("fetch") == "yes" else False~~		if request.form.get("mode") == "sel":
	~~if fetch:~~		selected_rows = request.form.get("identifier")
	if request.form.get("mode") == "sel":		try:
	selected_rows = request.form.get("identifier")		selected_rows = json.loads(selected_rows)
	try:		except (TypeError, json.decoder.JSONDecodeError):
	selected_rows = json.loads(selected_rows)		return jsonify({"gr_result":"failure"})
	except (TypeError, json.decoder.JSONDecodeError):		# Retrieve all relevant entries from a database.
	return jsonify({"gr_result":"failure"})		selected_rows = ...
	# Retrieve all relevant entries from a database.		if len(selected_rows) == 0:
	selected_rows = ...		return jsonify({"gr_result":"failure"})
	if len(selected_rows) == 0:		else:
	return jsonify({"gr_result":"failure"})		# Re-format the results as a list of dict.
	else:		response_data = [ {<col0>:<row0_value0>, <col1>:<row0_value1>, ...},
	# Re-format the results as a list of dict.		{<col0>:<row1_value0>, <col1>:<row1_value1>, ...},
	response_data = [ {<col0>:<row0_value0>, <col1>:<row0_value1>, ...},		... ]
	{<col0>:<row1_value0>, <col1>:<row1_value1>, ...},		return jsonify({"data":response_data, "gr_status":"success"})
	... ]
	return jsonify({"data":response_data, "gr_status":"success"})

	if request.form.get("mode") == "qsch" and not(table.multi):		if request.form.get("mode") == "qsch" and not(table.multi):
	# Try fetching exactly ONE matching result from the server.		# Try fetching exactly ONE matching result from the server.
	~~# ...~~
	~~# If the result count is exactly ONE, the quick-search is successful.~~
	~~if ...:~~
	~~# Reformat the result as a dict.~~
	~~return jsonify({"data":qsch_result, "qs_status":"success"})~~
	~~# Now that the quick-search has failed, grab everything and return~~.
	# ...		# ...
	# Re-format the results as an array of array.		# If the result count is exactly ONE, the quick-search is successful.
	# The order in each sub-array reflects the table's columns.		if ...:
	response_data = [ [<row0_value0>, <row0_value1>, <row0_value2>, ...],		# Reformat the result as a dict.
	[<row1_value0>, <row1_value1>, <row1_value2>, ...],		return jsonify({"data":qsch_result, "qs_status":"success"})
	... ]		# Now that the quick-search has failed, grab everything and return.
	return jsonify({"data":response_data})		# ...
			# Re-format the results as an array of array.
			# The order in each sub-array reflects the table's columns.
			response_data = [ [<row0_value0>, <row0_value1>, <row0_value2>, ...],
			[<row1_value0>, <row1_value1>, <row1_value2>, ...],
			... ]
			return jsonify({"data":response_data})

	# NOTE THAT this is an extremely simple variation. In practical cases,		# NOTE THAT this is an extremely simple variation. In practical cases,
	# the function 'fetch_all' can retrieve records from the database while		# the function 'fetch_all' can retrieve records from the database while
	# simultaneously applying the quick-search filter. So, the quick-search		# simultaneously applying the quick-search filter. So, the quick-search
	# section might get switched around a bit.		# section might get switched around a bit.
	</syntaxhighlight>		</syntaxhighlight>

Tenko: /* Simple Search Table */

2024-06-19T05:45:30Z

Simple Search Table

←รุ่นแก้ไขก่อนหน้า		รุ่นแก้ไขเมื่อ 12:45, 19 มิถุนายน 2567
บรรทัดที่ 972:		บรรทัดที่ 972:

	=== Simple Search Table ===		=== Simple Search Table ===
			<syntaxhighlight lang='python' line=1>
			@<blueprint>.route("<submit_path>", methods=["POST"])
			def <function_name>(table=None, prefix="ChqSchTable", *kwargs):
			if table is None:
			req_prefix = request.args.get("prefix", None)
			prefix = prefix if req_prefix is None else req_prefix
			table = ChqSchTable(prefix=prefix, searchable=True, editable=False)
			identifier = json.loads(request.form.get("sel_iden" if request.form.get("mode")=="sel" \
			else "identifier"))
			# Extract variables and parameters from identifier and/or request.
			# ...
			# ...
			fetch = True if request.args.get("fetch") == "yes" else False
			if fetch:
			if request.form.get("mode") == "sel":
			selected_rows = request.form.get("identifier")
			try:
			selected_rows = json.loads(selected_rows)
			except (TypeError, json.decoder.JSONDecodeError):
			return jsonify({"gr_result":"failure"})
			# Retrieve all relevant entries from a database.
			selected_rows = ...
			if len(selected_rows) == 0:
			return jsonify({"gr_result":"failure"})
			else:
			# Re-format the results as a list of dict.
			response_data = [ {<col0>:<row0_value0>, <col1>:<row0_value1>, ...},
			{<col0>:<row1_value0>, <col1>:<row1_value1>, ...},
			... ]
			return jsonify({"data":response_data, "gr_status":"success"})

			if request.form.get("mode") == "qsch" and not(table.multi):
			# Try fetching exactly ONE matching result from the server.
			# ...
			# If the result count is exactly ONE, the quick-search is successful.
			if ...:
			# Reformat the result as a dict.
			return jsonify({"data":qsch_result, "qs_status":"success"})
			# Now that the quick-search has failed, grab everything and return.
			# ...
			# Re-format the results as an array of array.
			# The order in each sub-array reflects the table's columns.
			response_data = [ [<row0_value0>, <row0_value1>, <row0_value2>, ...],
			[<row1_value0>, <row1_value1>, <row1_value2>, ...],
			... ]
			return jsonify({"data":response_data})

			# NOTE THAT this is an extremely simple variation. In practical cases,
			# the function 'fetch_all' can retrieve records from the database while
			# simultaneously applying the quick-search filter. So, the quick-search
			# section might get switched around a bit.
			</syntaxhighlight>

	=== Search Table with a Stand-alone Page ===		=== Search Table with a Stand-alone Page ===

Tenko: /* Useful Server-side Patterns */

2024-06-19T04:52:11Z

Useful Server-side Patterns

←รุ่นแก้ไขก่อนหน้า		รุ่นแก้ไขเมื่อ 11:52, 19 มิถุนายน 2567
บรรทัดที่ 971:		บรรทัดที่ 971:
	== Useful Server-side Patterns ==		== Useful Server-side Patterns ==

	=== ~~Shortcut Route for Single~~-~~table~~ Page ~~& Search Table~~ ===		=== Simple Search Table ===



			=== Search Table with a Stand-alone Page ===

			==== Shortcut ====

	== Future Development ==		== Future Development ==