本文整理汇总了Python中sqlalchemy.dialects.sqlite.DATETIME属性的典型用法代码示例。如果您正苦于以下问题：Python sqlite.DATETIME属性的具体用法？Python sqlite.DATETIME怎么用？Python sqlite.DATETIME使用的例子？那么恭喜您, 这里精选的属性代码示例或许可以为您提供帮助。您也可以进一步了解该属性所在类sqlalchemy.dialects.sqlite的用法示例。
在下文中一共展示了sqlite.DATETIME属性的5个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: __init__
# 需要导入模块: from sqlalchemy.dialects import sqlite [as 别名]
# 或者: from sqlalchemy.dialects.sqlite import DATETIME [as 别名]
def __init__(self, *args, **kwargs):
truncate_microseconds = kwargs.pop("truncate_microseconds", False)
super(DATETIME, self).__init__(*args, **kwargs)
if truncate_microseconds:
assert "storage_format" not in kwargs, (
"You can specify only "
"one of truncate_microseconds or storage_format."
)
assert "regexp" not in kwargs, (
"You can specify only one of "
"truncate_microseconds or regexp."
)
self._storage_format = (
"%(year)04d-%(month)02d-%(day)02d "
"%(hour)02d:%(minute)02d:%(second)02d"
) 示例2: __init__
# 需要导入模块: from sqlalchemy.dialects import sqlite [as 别名]
# 或者: from sqlalchemy.dialects.sqlite import DATETIME [as 别名]
def __init__(self, *args, **kwargs):
truncate_microseconds = kwargs.pop('truncate_microseconds', False)
super(DATETIME, self).__init__(*args, **kwargs)
if truncate_microseconds:
assert 'storage_format' not in kwargs, "You can specify only "\
"one of truncate_microseconds or storage_format."
assert 'regexp' not in kwargs, "You can specify only one of "\
"truncate_microseconds or regexp."
self._storage_format = (
"%(year)04d-%(month)02d-%(day)02d "
"%(hour)02d:%(minute)02d:%(second)02d"
) 示例3: visit_localtimestamp_func
# 需要导入模块: from sqlalchemy.dialects import sqlite [as 别名]
# 或者: from sqlalchemy.dialects.sqlite import DATETIME [as 别名]
def visit_localtimestamp_func(self, func, **kw):
return 'DATETIME(CURRENT_TIMESTAMP, "localtime")' 示例4: _define_time_stamps_table
# 需要导入模块: from sqlalchemy.dialects import sqlite [as 别名]
# 或者: from sqlalchemy.dialects.sqlite import DATETIME [as 别名]
def _define_time_stamps_table(database):
tstamps = Table(
"timestamps",
database,
Column("iteration", Integer, primary_key=True),
Column("value", DATETIME),
sqlite_autoincrement=True,
extend_existing=True,
)
return tstamps 示例5: test_ad_hoc_types
# 需要导入模块: from sqlalchemy.dialects import sqlite [as 别名]
# 或者: from sqlalchemy.dialects.sqlite import DATETIME [as 别名]
def test_ad_hoc_types(self):
"""test storage of bind processors, result processors
in dialect-wide registry."""
from sqlalchemy.dialects import mysql, postgresql, sqlite
from sqlalchemy import types
eng = engines.testing_engine()
for args in (
(types.Integer,),
(types.String,),
(types.PickleType,),
(types.Enum, "a", "b", "c"),
(sqlite.DATETIME,),
(postgresql.ENUM, "a", "b", "c"),
(types.Interval,),
(postgresql.INTERVAL,),
(mysql.VARCHAR,),
):
@profile_memory()
def go():
type_ = args[0](*args[1:])
bp = type_._cached_bind_processor(eng.dialect)
rp = type_._cached_result_processor(eng.dialect, 0)
bp, rp # strong reference
go()
assert not eng.dialect._type_memos