Here are the examples of the python api sqlalchemy.JSON.evaluates_none taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.
2 Examples
0
Source : test_unitofworkv2.py
with Apache License 2.0
from gethue
with Apache License 2.0
from gethue
def define_tables(cls, metadata):
from sqlalchemy import TypeDecorator
class EvalsNull(TypeDecorator):
impl = String(50)
should_evaluate_none = True
def process_bind_param(self, value, dialect):
if value is None:
value = "nothing"
return value
Table(
"test",
metadata,
Column(
"id", Integer, primary_key=True, test_needs_autoincrement=True
),
Column("evals_null_no_default", EvalsNull()),
Column("evals_null_default", EvalsNull(), default="default_val"),
Column("no_eval_null_no_default", String(50)),
Column("no_eval_null_default", String(50), default="default_val"),
Column(
"builtin_evals_null_no_default", String(50).evaluates_none()
),
Column(
"builtin_evals_null_default",
String(50).evaluates_none(),
default="default_val",
),
)
Table(
"test_w_renames",
metadata,
Column(
"id", Integer, primary_key=True, test_needs_autoincrement=True
),
Column("evals_null_no_default", EvalsNull()),
Column("evals_null_default", EvalsNull(), default="default_val"),
Column("no_eval_null_no_default", String(50)),
Column("no_eval_null_default", String(50), default="default_val"),
Column(
"builtin_evals_null_no_default", String(50).evaluates_none()
),
Column(
"builtin_evals_null_default",
String(50).evaluates_none(),
default="default_val",
),
)
if testing.requires.json_type.enabled:
Table(
"test_has_json",
metadata,
Column(
"id",
Integer,
primary_key=True,
test_needs_autoincrement=True,
),
Column("data", JSON(none_as_null=True).evaluates_none()),
Column("data_null", JSON(none_as_null=True)),
)
@classmethod
0
Source : test_unitofworkv2.py
with MIT License
from sqlalchemy
with MIT License
from sqlalchemy
def define_tables(cls, metadata):
from sqlalchemy import TypeDecorator
class EvalsNull(TypeDecorator):
impl = String(50)
cache_ok = True
cache_ok = True
should_evaluate_none = True
def process_bind_param(self, value, dialect):
if value is None:
value = "nothing"
return value
Table(
"test",
metadata,
Column(
"id", Integer, primary_key=True, test_needs_autoincrement=True
),
Column("evals_null_no_default", EvalsNull()),
Column("evals_null_default", EvalsNull(), default="default_val"),
Column("no_eval_null_no_default", String(50)),
Column("no_eval_null_default", String(50), default="default_val"),
Column(
"builtin_evals_null_no_default", String(50).evaluates_none()
),
Column(
"builtin_evals_null_default",
String(50).evaluates_none(),
default="default_val",
),
)
Table(
"test_w_renames",
metadata,
Column(
"id", Integer, primary_key=True, test_needs_autoincrement=True
),
Column("evals_null_no_default", EvalsNull()),
Column("evals_null_default", EvalsNull(), default="default_val"),
Column("no_eval_null_no_default", String(50)),
Column("no_eval_null_default", String(50), default="default_val"),
Column(
"builtin_evals_null_no_default", String(50).evaluates_none()
),
Column(
"builtin_evals_null_default",
String(50).evaluates_none(),
default="default_val",
),
)
if testing.requires.json_type.enabled:
Table(
"test_has_json",
metadata,
Column(
"id",
Integer,
primary_key=True,
test_needs_autoincrement=True,
),
Column("data", JSON(none_as_null=True).evaluates_none()),
Column("data_null", JSON(none_as_null=True)),
)
@classmethod