Giter Club home page Giter Club logo

python-module-jk-sql's Introduction

jk_sql

Introduction

This python module provides a uniform API to create, modify, read and write data to SQL tables in a database independent way.

What this uniform interface is: A simple way to interact with (in the long run: various) databases in a database independent way. The database schema is maintained separately and stored in a special model file. During runtime this information is available through a clean OOP interface: There are table objects and column objects that provide various information as well as data query and manipulation methods.

What this uniform interface not is: The API provided does NOT cover all microdetails of SQL. The design goal for this module is to provide a clean interface for the most common, typical database operations. So there are some limitations what you will be able to do with this API.

Information about this module can be found here:

Please note that currently only SQLite is supported. In the long run more databases will be supported.

Please also note that this module is still in alpha stage. According to unit tests SQLite support works as intended. Nevertheless the API still must be considered as being unstable: A few changes might be in order until beta stage is reached. If you decide to make use of this module have in mind that a few changes to your program might be required later if this module reaches beta stage and you then perform an upgrade on that module.

How to use this module

Requirements

This module will require the following python modules to operate:

  • (none)

Import

To import this module use the following statement:

import jk_sql

Creating a database

TODO

Creating tables

TODO

Inserting data

TODO

Querying data

TODO

Updating data

TODO

Deleting data

TODO

Modifying tables

TODO

Deleting tables

TODO

Contact Information

This is Open Source code. That not only gives you the possibility of freely using this code it also allows you to contribute. Feel free to contact the author(s) of this software listed below, either for comments, collaboration requests, suggestions for improvement or reporting bugs:

License

This software is provided under the following license:

  • Apache Software License 2.0

python-module-jk-sql's People

Contributors

jkpubsrc avatar

Watchers

James Cloos avatar  avatar

Forkers

sunarch

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.