EXECPYTHON()

Purpose

Function to run Python code

Syntax

EXECPYTHON(<expC> [,<expr>...])

See Also

COMPILE, EXEC(), EXECJAVASCRIPT(), EXECPHP(), EXECSCRIPT(), Python Server Pages, REQUIRE()

Description

The EXECPYTHON() function runs Python code. The lines of code are contained in <expC>, which can be a text constant, a filename, a character variable, or a character or memo field. The EXECPYTHON() function can handle blocks of code. Individual lines of code must be separated by a CHR(13) carriage return character. If a filename.py is specified it is loaded and executed. Inside the .py file, to return a value assign a result to returnvalue

To preload python libraries use:

// filename may contain special file prefixes e.g. lib:/mylib.py  thirdpartylibs:/mylibs/mylib.py
loadLibrary("yourlibrary.py")

Once your python libraries are loaded you can call python functions directory.

result = execPython("myPyFunc('arg1','arg2','arg3')")

You can wrap the python function and call it directly from LianjaScript:

// wrapper for python code
proc myFunc(arg1, arg2, arg3)
    result = execPython(format("myPyFunc('{0}','{1}','{2}')"), arg1, arg2, arg3)
return result
 
// call the function directly in your code
result = myFunc('arg1', 'arg2', 'arg3')

You can create a LianjaScript module that contain all of your Python wrapper functions (Using the OpenAI/ChatGPT API for example). See REQUIRE() for details on how to write LianjaScript modules.

Note that if a filename.py is specified and a list of arguments are specified as <expr>... sys.argv in python is an array of arguments. This provides a consistent way to incorporate python functions in your LianjaScript code.

e.g.

#filename.py
import neededmodules
 
# extract arguments specified on execPython()
arg1 = sys.argv[0]
arg2 = sys.argv[1]
 
# execute your code
 
# now return a value
returnvalue = "Ok"

Arguments can also be specified together with the filename e.g.

result = execPython("filename.py?'arg1','arg2','arg3'")

Example

// Character field
create table if not exists scripts (script char(200))
if not used("scripts")
	use scripts
endif
select scripts
append blank
replace script with 'for i in range(9):' + CHR(13)+ '# process commands' + CHR(13)
execpython(script)
 
// Text constant
execpython('for i in range(9):' + CHR(13) + '# process commands' + CHR(13))
 
// Memory variable
m_script = 'for i in range(9):' + CHR(13) + '# process commands' + CHR(13)
execpython(m_script)