kieran-lock / sqliteframe Goto Github PK

View Code? Open in Web Editor NEW

7.0 7.0 0.0 673 KB

A lightweight, zero-dependency ORM for SQLite in Python

Home Page: https://pypi.org/project/SQLiteFrame/

License: MIT License

Python 100.00%

lightweight orm schematics sqlite3 zero-dependency

sqliteframe's Introduction

Welcome to my profile!

Projects

These are the key projects I have created, or am currently creating. You can also see other projects I have worked on by viewing my repositories.

Skills

Below are my key skills as a Software / Web Developer. These are tools and environments that I often work with the build projects and solve problems.

Contact Me

If you have a query relating directly to one of my projects, feel free to open an issue for that project. Otherwise, you can contact me on the below platforms.

Statistics

Below are my GitHub stats. Some may be inaccurate, as contributions to organizations are not counted.

sqliteframe's People

Contributors

Stargazers

Watchers

sqliteframe's Issues

Strings are saved with quotes

When writing data to string field, the string in the SQLite DB contains not only the string value, but also a pair of double quotes.

It looks like the SQL INSERT or UPDATE statement contains '"MyString"' instead of 'MyString' for the values.

Table creation does not preserve order of fields

When creating a table, the fields are generated in alphabetical order. The order from the class in the python code is not preserved.

Example

This class from the project example

@table(database)
class TableName:
    primary_key_field = String(primary_key=True)  # The primary key parameter is False by default
    second_column = Integer  # If only the default options are required, no brackets are necessary either
    third_column = Boolean(nullable=True)  # The nullable parameter is False by default
    fourth_column = String(default="This is a default value.")  # You can also opt-in to giving columns default values like this

leads to this debug output:

CREATE TABLE IF NOT EXISTS TableName (
	fourth_column TEXT NOT NULL DEFAULT "This is a default value.",
	primary_key_field TEXT PRIMARY KEY NOT NULL,
	second_column INTEGER NOT NULL,
	third_column BOOLEAN
);

fourth_column should be the last item in the CREATE TABLE statement, but it's the first, because the fields have been sorted alphabetically.

TypeError: 'module' object is not callable

I'm trying to use your library, but on the first with the following code:

from sqliteframe import table, Integer, String, ForeignKey,Database
database = Database('bep.sqlite',output=True,foreign_keys=True)
@table(db)
class Alert:
    id = Integer(primary_key=True)
    creation_date = String(nullable=False)
    last_update = String(nullable=False)
    search_term = String(nullable=False)

def main():
    insert_stmt = Offer.insert_into({
        'ref':'124',
        'tipo':'tipo'
    })
    insert_stmt.execute()

if __name__ == '__main__':
    main()

if fails on Windows in Python 3.10.4 (Anaconda) with the error:

Traceback (most recent call last):
  File "s:\bep_alerter\models.py", line 6, in <module>
    @table(database)
TypeError: 'module' object is not callable