fortifysql

Name	fortifysql JSON
Version	0.4.0 JSON
	download
home_page	None
Summary	SQLite extension with a focus on security
upload_time	2024-06-11 07:34:38
maintainer	None
docs_url	None
author	Archie Hickmott
requires_python	None
license	None
keywords	sql security
VCS
bugtrack_url
requirements	No requirements were recorded.
Travis-CI	No Travis.
coveralls test coverage	No coveralls.

            # Fortify SQL
A python library for easy SQL injection prevention. Designed arround the SQLite3 python database library. <br>
Current features are:<br>
-	Connect and executes queries on database<br>
-	Allows devs to configure if DROP is allowed on database<br>
-	Allows devs to configure if queries are error caught and printed to console<br>
-	Includes secure features:<br>
    -	Basic injection proof<br>
    -	Can’t use DELETE FROM table WHERE 1=1; as an alternative to drop if DROP is not allowed on database<br>
    -	Can’t run more than one statement on a query that is labelled as single statement<br>
-	One line of code to execute a query<br>
-   Allow statements to be set as blocked by dev so they can’t be executed on the database
## Quickstart
install using pip
```shell
pip install fortifysql
```
fortify is designed arround the database class, start by importing fortifysql and specifying the path of the database to connect to
```python
from fortifysql import Database

database = Database("mydatabase.db")
```
and then to make requests:
```python
data = database.query("SELECT * FROM myTable", save_data = True) # use save_data if you want any data from the request
```
Parameters are defined with a '?' in the request and are passed through in a tuple
```python
data = database.query("SELECT * FROM myTable WHERE id=?", save_data = True, (user_id,))
```

            

Raw data

            {
    "_id": null,
    "home_page": null,
    "name": "fortifysql",
    "maintainer": null,
    "docs_url": null,
    "requires_python": null,
    "maintainer_email": null,
    "keywords": "sql, security",
    "author": "Archie Hickmott",
    "author_email": "25hickmar@gmail.com",
    "download_url": "https://files.pythonhosted.org/packages/5f/f4/ef3d952558a943fe257f002858cc599da10a85f4f32883b81466c1c68cc5/fortifysql-0.4.0.tar.gz",
    "platform": null,
    "description": "# Fortify SQL\r\nA python library for easy SQL injection prevention. Designed arround the SQLite3 python database library. <br>\r\nCurrent features are:<br>\r\n-\tConnect and executes queries on database<br>\r\n-\tAllows devs to configure if DROP is allowed on database<br>\r\n-\tAllows devs to configure if queries are error caught and printed to console<br>\r\n-\tIncludes secure features:<br>\r\n    -\tBasic injection proof<br>\r\n    -\tCan\u00e2\u20ac\u2122t use DELETE FROM table WHERE 1=1; as an alternative to drop if DROP is not allowed on database<br>\r\n    -\tCan\u00e2\u20ac\u2122t run more than one statement on a query that is labelled as single statement<br>\r\n-\tOne line of code to execute a query<br>\r\n-   Allow statements to be set as blocked by dev so they can\u00e2\u20ac\u2122t be executed on the database\r\n## Quickstart\r\ninstall using pip\r\n```shell\r\npip install fortifysql\r\n```\r\nfortify is designed arround the database class, start by importing fortifysql and specifying the path of the database to connect to\r\n```python\r\nfrom fortifysql import Database\r\n\r\ndatabase = Database(\"mydatabase.db\")\r\n```\r\nand then to make requests:\r\n```python\r\ndata = database.query(\"SELECT * FROM myTable\", save_data = True) # use save_data if you want any data from the request\r\n```\r\nParameters are defined with a '?' in the request and are passed through in a tuple\r\n```python\r\ndata = database.query(\"SELECT * FROM myTable WHERE id=?\", save_data = True, (user_id,))\r\n```\r\n",
    "bugtrack_url": null,
    "license": null,
    "summary": "SQLite extension with a focus on security",
    "version": "0.4.0",
    "project_urls": {
        "Bug Reports": "https://github.com/ArchieHickmott/fortify-sql",
        "Documentation": "https://archiehickmott.github.io/fortify-sql/"
    },
    "split_keywords": [
        "sql",
        " security"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "5ff4ef3d952558a943fe257f002858cc599da10a85f4f32883b81466c1c68cc5",
                "md5": "09d00565831718ffe1ffe1aae283484b",
                "sha256": "a190fda0ffd7fb752374071ab253733f1e0b7b499ce7e753e4b5d92632b9d2f1"
            },
            "downloads": -1,
            "filename": "fortifysql-0.4.0.tar.gz",
            "has_sig": false,
            "md5_digest": "09d00565831718ffe1ffe1aae283484b",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 8301,
            "upload_time": "2024-06-11T07:34:38",
            "upload_time_iso_8601": "2024-06-11T07:34:38.105884Z",
            "url": "https://files.pythonhosted.org/packages/5f/f4/ef3d952558a943fe257f002858cc599da10a85f4f32883b81466c1c68cc5/fortifysql-0.4.0.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2024-06-11 07:34:38",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "ArchieHickmott",
    "github_project": "fortify-sql",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": true,
    "lcname": "fortifysql"
}