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
1 Jan 11, 2022
127 Oct 23, 2022
4 Jul 15, 2022
880 Jan 08, 2023
0 Dec 28, 2021
1.4k Dec 31, 2022
1 Jan 09, 2022
253 Dec 31, 2022
251 Oct 25, 2022
3.4k Jan 02, 2023
35 Nov 01, 2022
4 Jul 30, 2022
1 Feb 07, 2022
45 Jun 01, 2022
64 Oct 14, 2022
2.2k Dec 25, 2022
3 Nov 15, 2021