SQL MAPPER
Basically what it does is: it executes some SQL thru a database connector you fed it, maps it to some model and gives to u. Also it can create tables
How to install and import it
pip install megahomyaks_sql_mapper <- WARNING: PACKAGE NAME IS DIFFERENT FROM THE PROJECT NAME
import sql_mapper
Some abstract info about a model
from sql_mapper import ModelBase
class MyFirstModel(ModelBase):
_tablename = "obvious"
# You don't need to specify a _tablename if you will not create a table
# for this model using an SQL executor OR insert it using parameter
# marks from this mapper
# (sql_executor.execute("INSERT INTO ?", [MyFirstModel("a", "b")]))
first_field: str = "TEXT"
# Value of each field is its datatype that will be used when SQL table
# will be created (you don't need to fill these (you can preserve only
# the typehint or place a stub as a value) if you will not create a
# table from this model using an SQL executor)
second_field = ""
# Typehints are NOT necessary, they are used only for IDE type checking
# (which is quite dumb in terms of Python, but it is easy to do and
# can potentially help, so why not)
_additional_table_lines = ""
# Specify this if you need to append more lines to a table, such as
# "PRIMARY KEY (some_field)"
Some concrete info about a model + overall usage example
See this file
About StringDump
There is a class called StringDump in string_dump.py, which is a string that consumes other strings, and consists of formattable and unformattable parts. One example can be found here, on line 27 (or not, I'm not a megamind who can remember this reference and fix it when modifying the linked file): sql_mapper_test.py
Don't forget about raw, kids
Now imma head out, gonna use some Tortoise ORM
![halcyon[nouveau]](https://avatars.githubusercontent.com/u/49960726?v=4&s=60)
15 Dec 29, 2022
7 Aug 21, 2022
2.3k Jan 6, 2023
6.9k Jan 7, 2023
4.2k Jan 2, 2023
171 Dec 18, 2022
0 Jul 6, 2022
8 Dec 12, 2022
550 Jan 01, 2023
2.2k Dec 25, 2022
5.8k Dec 31, 2022
35 Dec 23, 2022
1 Feb 26, 2022
1 Dec 25, 2021
1 Jan 05, 2022
66 Dec 02, 2022
253 Dec 31, 2022
7 Jun 04, 2022
158 Jan 07, 2023
3.2k Dec 30, 2022
1 Jan 07, 2022
582 Dec 28, 2022
299 Nov 20, 2022
522 Jan 01, 2023
9 Dec 24, 2022