orsopy.slddb.converters module

Classes for conversion of specific data into sqlite types and back.

class orsopy.slddb.converters.Converter[source]

Bases: ABC

Base class for all other converters, can’t be used stand alone.

sql_type = 'TEXT'

html_list = False

comparator: alias of GenericComparator

html_title = None

validate(data)[source]

abstract convert(data)[source]: Converts data to SQLite format

revert(db_data)[source]

revert_serializable(db_data)[source]

html_input(field, value)[source]

class orsopy.slddb.converters.CType(fromtype, dbtype, db_repstr=None)[source]

Bases: Converter

convert(data)[source]: Converts data to SQLite format

revert(db_data)[source]

class orsopy.slddb.converters.CDate[source]

Bases: Converter

sql_type = 'TEXT'

convert(data)[source]: Converts data to SQLite format

revert(db_data)[source]

revert_serializable(db_data)[source]

html_input(field, value)[source]

class orsopy.slddb.converters.CFormula[source]

Bases: Converter

comparator: alias of FormulaComparator

convert(data)[source]: Converts data to SQLite format

revert(db_data)[source]

html_input(field, value)[source]

class orsopy.slddb.converters.ValidatedString[source]

Bases: CType

regex = None

placeholder = ''

convert(data)[source]: Converts data to SQLite format

html_input(field, value)[source]

class orsopy.slddb.converters.CUrl[source]

Bases: ValidatedString

regex = re.compile('^https?://(?:(?:[A-Z0-9](?:[A-Z0-9-]{0,61}[A-Z0-9])?\\.)+(?:[A-Z]{2,6}\\.?|[A-Z0-9-]{2,}\\.?)|localhost|\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.\\d{1,3})(?::\\d+)?(?:/?|[/?]\\S+)$', re.IGNORECASE)

placeholder = 'http://www.your_website.net'

class orsopy.slddb.converters.CMail[source]

Bases: CType

placeholder = 'your.name@domain.net'

html_input(field, value)[source]

class orsopy.slddb.converters.Cdoi[source]

Bases: ValidatedString

regex = re.compile('^https://doi.org/(?:(?:[A-Z0-9](?:[A-Z0-9-]{0,61}[A-Z0-9])?\\.)+(?:[A-Z]{2,6}\\.?|[A-Z0-9-]{2,}\\.?)|localhost|\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.\\d{1,3})(?::\\d+)?(?:/?|[/?]\\S+)$', re.IGNORECASE)

placeholder = 'https://doi.org/your/ref'

convert(data)[source]: Converts data to SQLite format

class orsopy.slddb.converters.Ccas[source]

Bases: ValidatedString

regex = re.compile('\\b[1-9][0-9]{1,5}-\\d{2}-\\d\\b', re.IGNORECASE)

placeholder = 'xxxxxxx-yy-z'

class orsopy.slddb.converters.CArray(shape=None, ndim=None)[source]

Bases: Converter

sql_type = 'BLOB'

convert(data)[source]: Converts data to SQLite format

revert(db_data)[source]

revert_serializable(db_data)[source]

class orsopy.slddb.converters.CLimited(fromtype, db_type, low_lim=None, up_lim=None, db_repstr=None)[source]

Bases: CType

validate(data)[source]

convert(data)[source]: Converts data to SQLite format

html_input(field, value)[source]

class orsopy.slddb.converters.CComplex[source]

Bases: CArray

convert(data)[source]: Converts data to SQLite format

revert(db_data)[source]

revert_serializable(db_data)[source]

html_input(field, value)[source]

class orsopy.slddb.converters.CSelect(options)[source]

Bases: CType

convert(data)[source]: Converts data to SQLite format

html_input(field, value)[source]

class orsopy.slddb.converters.CMultiSelect(options)[source]

Bases: CType

html_list = True

convert(data)[source]: Converts data to SQLite format

revert(db_data)[source]

html_input(field, value)[source]