ambertide/datalite

A simple Python library to bind dataclasses with databases.

Ege Emir Özkan - eambertide

Welcome to my GitHub!, I have listed the projects I think are more presentable down below, categorised, some might be still WIP, others I might have collabbed with other people, but all are dear and near to me.

My Projects!

• Web Programming
• Game Development
• Programming Languages
• Web Scrapping & APIs
• Narratives

Web Programming 🔗

I have professionally worked as a full-time web developer for more than a year now, if we include part-time, that makes two years, it is hard to keep motivated to learn new stuff when all you do at work is web programming too, but I have been trying to keep myself motivated with small and interesting projects.

Game Development 🎮

I have interest in Game Development, espacially narrative-driven games, over the years I have experimented with many technologies, wrote an Amnesia custom story with another, have written numerous Choose-Your-Own-Adventure style interactive web games with Inkle, even published some in Google Play once (they aren't there anymore, though.)

My current on-goging project in this area is HailMary, a minimalist, isometric 2D game runtime.

Game Development, but Retro 👾

Senior year of college, I realised I really love Retro Games, this resulted in a series of prototypes and tools to facilitate DOS x86 Choose-Your-Own-Adventure style game development. This led to me actually learning parts of x86 assembly as well as some DOS Interrupts and system calls. I created the following:

I also really like Emulator Work, so I have dabbled on that too:

Programming Languages 🔨

I am a huge Programming Language nerd! Proud subscriber to r/ProgrammingLanguages, design and implementation of programming languages has always interested me, I have written small interpreters here and there and have penned a proposal for a new programming language, I even implemented parts of it. (CFluxion remains incomplete)

Web Scrapping and API Wrapping 🤖

I know my way around BeautifulSoup and HTML web scrapping, and know how to write wrapper APIs for high-level languages around web APIs, including SOAP APIs.

Narrative-Driven Experiences 📖

I always liked writing, hence, sometimes I tend to combine my experiences in writing with my programming experience to create unique narratives, websites, alternate reality games, these are listed here.

PS: This web app was used to generate these repository images

datalite's Issues

Enhancement: proper fetch* type hinting

Current implementation of fetch methods do not type hint objects returned, which makes it more difficult to use.

Suggestion:

Add a TypeVar to fetch.py:

from typing import TypeVar
T = TypeVar('T')

Modify fetch* functions type hinting from:

  def fetch_from(class_: type, obj_id: int) -> Any:

to:

  def fetch_from(class_: type[T], obj_id: int) -> T:

That will give a proper type hint to IDE.

Move away from string interpolation & adopt query parameters

The current implementation uses string interpolation to construct sqlite queries.

See the following for a typical example:

datalite/datalite/datalite_decorator.py

Line 30 in 81010fc

f" VALUES ({', '.join(_convert_sql_format(item[1]) for item in kv_pairs)});")

This causes problems when trying to insert JSON data (or other fancy strings) into a table.

There is another way to pass values into queries: so-called query parameters. Query parameters do not have this same limitation. See cursor-objects (sqlite3).

Handle Optional[] Types

I tried using this with a dataclass which contained a number of types marked Optional[type] and it failed with

datalite/commons.py in _convert_type(type_, type_overload)
     23         return type_overload[type_]
     24     except KeyError:
---> 25         raise TypeError("Requested type not in the default or overloaded type table."

I was able to work around this by defining the fields with default values but it feels like either should work.

Create_entry and other methods raise unknown PyLance reportGeneralTypeIssues

I know it's work, but some type hint improvement may good.

BUG: fetch_equals crashes if there are no rows to return

Lines in fetch_equals:

        cur.execute(f"SELECT * FROM {table_name} WHERE {field} = ?;", (value, ))
        obj_id, *field_values = list(cur.fetchone())

crash execution due to None being returned from cur.fetchone() if there are no rows.

A fix could be:

        row = cur.fetchone()
        if not row:
            return None
        obj_id, *field_values = list(row)