ppms.sql
The sql module provides helper functions for working with the database directly.
Functions
| Function | Parameters | Return Value | Description |
|---|---|---|---|
convert_date_to_planta_time(date, date_format=%d.%m.%Y) | date: String containing a date date_format: A valid date format string | The date converted to amount of days since 01.01.1970 | Converts a readable date into the format used by PLANTA date fields |
convert_planta_time_to_date(planta_time, date_format=%d.%m.%Y) | planta_time: Days since 01.01.1970 date_format: A valid date format string | A readable date as defined by the format | Converts the PLANTA internal date format to a readable string |
get_sql_date_format(planta_time) | planta_time: Days since 01.01.1970 | Returns a string to be used in an sql statement | Converts the days since 01.01.1970 to a proper date string and then adds the dbms related code to make it valid sql |
sanitize_value(value) | value: A value you want to insert into a SQL statement | A sanitized version of the value | Sanitizes a string that will later be formatted into an sql statement. Useful for preventing SQL injections or putting UUID objects into a statement |
Examples
Converting a planta time to a date string
PY
from ppms.sql import convert_planta_time_to_date
from ppms.constants import SYS_VAR_TODAY
today = ppms.uvar_get(SYS_VAR_TODAY)
today_as_date_string = convert_planta_time_to_date(planta_time=today)
ppms.ui_message_box('Today is {}'.format(today_as_date_string))