ytyaru/Python.sqlite3.row_factory.cast.insert.datetime.20221024095030

Thin wrapper that returns SQLite3 select result as tuple, sqlite3.Row, namedtuple, dataclass. typecast. Also date type.

ja

sqlite3.row_factory.cast.insert.datetime

Thin wrapper that returns SQLite3 select result as tuple, sqlite3.Row, namedtuple, dataclass. typecast. Also date type.

Requirement

• 2022-10-24
• Raspbierry Pi 4 Model B Rev 1.2
• Raspberry Pi OS buster 10.0 2020-08-20 setup
• bash 5.0.3(1)-release
• Python 3.10.5

$ uname -a
Linux raspberrypi 5.10.103-v7l+ #1529 SMP Tue Mar 8 12:24:00 GMT 2022 armv7l GNU/Linux

Installation

anyenv

git clone https://github.com/anyenv/anyenv ~/.anyenv
echo 'export PATH="$HOME/.anyenv/bin:$PATH"' >> ~/.bash_profile
echo 'eval "$(anyenv init -)"' >> ~/.bash_profile
anyenv install --init -y

pyenv

anyenv install pyenv
exec $SHELL -l

python

sudo apt install -y libsqlite3-dev libbz2-dev libncurses5-dev libgdbm-dev liblzma-dev libssl-dev tcl-dev tk-dev libreadline-dev

pyenv install -l

pyenv install 3.10.5

this works

git clone https://github.com/ytyaru/Python.sqlite3.row_factory.cast.insert.datetime.20221024095030
cd Python.sqlite3.row_factory.cast.insert.datetime.20221024095030/src

Usage

run

./run.py

unit test

./test.py

Author

ytyaru

• 
• 
• 
• 

License

This software is CC0 licensed.