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
4.1k Jan 01, 2023
22.4k Dec 30, 2022
6 Jul 01, 2022
4 Jul 12, 2021
3 Nov 15, 2021
626 Dec 01, 2022
853 Dec 30, 2022
64 Oct 14, 2022
957 Dec 30, 2022
71 Nov 09, 2022
3.8k Jan 01, 2023
10 Dec 07, 2022
10 Dec 22, 2022
1 Nov 30, 2021
4 Jul 30, 2022
2.1k Dec 30, 2022
1.9k Jan 04, 2023