SQLiteHelper

KO | EN

gitlite — search

#python #hacktoberfest #go #golang #machine-learning #linux #macos #windows #awesome-list #pytorch #security #ios #openai #open-source

(★ 9)

Wrapper of the sqlite3 library. Ease of use for programmers doing database work.

SQLiteHelper 최신버젼 다운로드

최종 버전 다운로드 (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# SQLiteHelper
Wrapper of the sqlite3 module for ease of use.  Inspired by the SQLite design of Android using factory methods for some operations

Install the module via pip:
```python
pip install SQLiteHelper
```
To make a Database connection:
```python
from SQLiteHelper import SQLiteHelper as sq

db = sq.Connect("database")
```
This creates a db file named database.db

Next is an example of building a table named content with 3 columns, ID(INT PRIMARY KEY NOT NULL), QUANTITY(TEXT), and NAME(TEXT)
```python
db.table("content").withColumns("ID", "QUANTITY", "NAME").withDataTypes("INT PRIMARY KEY NOT NULL", "TEXT", "TEXT").createTable()
```
Now lets insert a row with an ID of 1, Quantity of "Two", and a NAME of "FOO":
```python
db.table("content").insert(1, "Two", "Foo").into("ID", "QUANTITY", "NAME")
```
Now for selecting all entries from a database with no where clause, you do: 
```python
cursor = db.table("content").select("ID", "QUANTITY", "NAME").execute()
```
If you decide to use a where clause:
```python
cursor = db.table("content").select("ID", "QUANTITY", "NAME").where("ID").equals(1).execute()
```
Both methods return a cursor of all the rows, which can be accessed as such:
```python
for row in cursor:
    for x in range(len(row)):
        print(row[x])
```
Updating entries:
```python
db.table("content").update("QUANTITY").setTo("Four").where("ID").equals(1).execute()
```
Deleting entries:
```python
db.table("content").delete().where("ID").equals(1).execute()
```

Now, lets say you want to detect if a table exists before you query it
```python
db.table("content").tableExists()
```
The above method will return a boolean, True if the table exists, False if it does not

A neat feature is the ability to prepopulate a database with values when the table is created
To do so, create a file, and lets call it initScript.py. In this file, place these lines
```python
class init(object):
    def __init__(self):
        self.columns = ["ID", "QUANTITY", "NAME"]
        self.datatypes = ["INT PRIMARY KEY NOT NULL", "TEXT", "TEXT"]
        self.seed = [["1", "Two", "Foo"],
                     ["2", "Three", "Bar"]]
        
```
The class does not need to be called init, but the init script must have columns(table columns), datatypes(the column's datatypes) and seed(list of rows of prepopulating data to be added to the table)

Then in your main script, you would have something like this:
```python
from SQLiteHelper import SQLiteHelper as sq
import initScript as ins
 
db = sq.Connect("database")
preset = ins.init()
db.table("dbInitTest").init(preset)
```
This will initialize a table called dbInitTest wil 3 columns: ID, QUANTITY, and NAME, along with prepopulated rows of data.  This can be useful for needing preexisting data for actions like machine learning.

More features to come. Please post issues and pull requests as needed

SQLiteHelper

SQLiteHelper 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

SQLiteHelper

SQLiteHelper 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README