Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

gh-90016: Reword sqlite3 adapter/converter docs#93095

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to ourterms of service andprivacy statement. We’ll occasionally send you account related emails.

Already on GitHub?Sign in to your account

Merged
Merged
Changes from1 commit
Commits
Show all changes
34 commits
Select commitHold shift + click to select a range
598e26a
gh-90016: Reword sqlite3 adapter/converter docs
erlend-aaslandMay 23, 2022
e5b1b88
Add current adapters/converter as recipes: improve this
erlend-aaslandMay 23, 2022
9399b54
default role
erlend-aaslandMay 23, 2022
40bb59a
Formatting
erlend-aaslandMay 23, 2022
82cf3e2
Address Serhiy's review
erlend-aaslandMay 23, 2022
0b6f381
Address Alex' review
erlend-aaslandMay 25, 2022
c4dde48
Nit
erlend-aaslandMay 25, 2022
72013ef
Address Alex' nitpicks
erlend-aaslandMay 25, 2022
3c70d52
Address in-house review
erlend-aaslandMay 25, 2022
681baad
Recipes, take 1
erlend-aaslandMay 25, 2022
bf4cb1f
Docstring wording
erlend-aaslandMay 25, 2022
2d1a0c1
Update Doc/library/sqlite3.rst
Jun 22, 2022
94308ff
Update Doc/library/sqlite3.rst
Jun 22, 2022
06657f2
Update Doc/library/sqlite3.rst
Jun 22, 2022
b98e363
Update Doc/library/sqlite3.rst
Jun 22, 2022
97812bb
Update Doc/library/sqlite3.rst
Jun 22, 2022
d3dd5a2
Update Doc/library/sqlite3.rst
Jun 22, 2022
f381b65
Update Doc/library/sqlite3.rst
Jun 22, 2022
65eb45c
Update Doc/library/sqlite3.rst
Jun 22, 2022
172c7d9
Update Doc/library/sqlite3.rst
Jun 22, 2022
5ac2af9
Update Doc/library/sqlite3.rst
Jun 22, 2022
433bf5a
Update Doc/library/sqlite3.rst
Jun 22, 2022
f7646de
Update Doc/library/sqlite3.rst
Jun 22, 2022
6fbcff8
Assuming direct control
Jun 22, 2022
b319b54
Address the last part of CAM's review
erlend-aaslandJun 23, 2022
4e3b8fd
Merge branch 'main' into sqlite-doc-converters
erlend-aaslandJun 23, 2022
e821a7e
Clarify parse column names further
erlend-aaslandJun 23, 2022
bc295d8
Revert unneeded change
erlend-aaslandJun 23, 2022
9235f8d
Further clarify register_converter
erlend-aaslandJun 23, 2022
8484164
Use testsetup/doctest
erlend-aaslandJun 23, 2022
b579f67
Revert "Use testsetup/doctest"
erlend-aaslandJun 23, 2022
0e42fa6
Update Doc/library/sqlite3.rst
Jun 24, 2022
8d97fcb
Reflow
erlend-aaslandJun 25, 2022
d300b33
Merge remote-tracking branch 'upstream/main' into sqlite-doc-converters
erlend-aaslandJun 25, 2022
File filter

Filter by extension

Filter by extension

Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
PrevPrevious commit
NextNext commit
Nit
  • Loading branch information
@erlend-aasland
erlend-aasland committedMay 25, 2022
commitc4dde483c89f432df856cadad413aba5fbdbe4ad
7 changes: 4 additions & 3 deletionsDoc/library/sqlite3.rst
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -1336,29 +1336,30 @@ timestamp converter.
Adapter and Converter Recipes
-----------------------------

This section shows recipes forcommon adapters and converters.
This section shows recipes fortimezone-naive adapters and converters.

.. testcode::

import sqlite3

# Timezone-naive datetime adapters and converters.
def adapt_date(val):
return val.isoformat()

def adapt_datetime(val):
return val.isoformat(" ")

def convert_date(val):
import datetime
return datetime.date(*map(int, val.split(b"-")))

def convert_timestamp(val):
import datetime
datepart, timepart = val.split(b" ")
year, month, day = map(int, datepart.split(b"-"))
timepart_full = timepart.split(b".")
hours, minutes, seconds = map(int, timepart_full[0].split(b":"))
if len(timepart_full) == 2:
microseconds = int('{:0<6.6}'.format(timepart_full[1].decode()))
microseconds = int("{:0<6.6}".format(timepart_full[1].decode()))
else:
microseconds = 0

Expand Down

[8]ページ先頭

©2009-2025 Movatter.jp