Metadata-Version: 2.1
Name: qrookDB
Version: 1.2.0.1
Summary: tiny ORM for SQL-databases
Home-page: https://gitlab.com/qrook/db
Author: Kurush
Author-email: ze17@ya.ru
License: UNKNOWN
Description: 
        # Usage example:
        ```python
            import DB as db
        from data import QRTable
        books, books_authors, authors, events = [QRTable()] * 4
        
        DB = db.DB('postgres', 'db_name', 'user_name', 'password', format_type='dict')
        op = DB.operators
        DB.create_logger(app_name='app', file='app_log.log')
        DB.create_data(__name__, in_module=True)
        
        print(DB.books)
        print(books, books.id)
        data = DB.select(books).where(original_publication_year=2000, language_code='eng').    where(id=op.In(470, 490, 485)).all()
        print(data[:10])
        
        data = books.select('count(*)').group_by(books.original_publication_year).all()
        print(data[:10])
        
        data = DB.select(books, books.id).where('id < 10').order_by(books.id, desc=True).    limit(3).offset(2).all()
        print('limit & offset', data)
        
        data = books.select(authors.id, books.id)    .join(books_authors, op.Eq(books_authors.book_id, books.id))    .join(authors, op.Eq(books_authors.author_id, authors.id)).all()
            # .join(books_authors, 'books_authors.book_id = books.id')print(data[:10])
        
        data = books.select(books.id).where(id=1).where(bool='or', id=2).limit(10).all()
        print('with or:', data)
        
        ok = DB.delete(events, auto_commit=True).where(id=1).exec()
        print(ok)
        
        from datetime import datetime
        t = datetime.now().time()
        d = datetime.now().date()
        ok = DB.update(events, auto_commit=True).set(time=t).where(id=6).exec()
        print(ok)
        
        #ok = DB.insert(events, events.time, auto_commit=True).values([t]).exec()
        #ok = DB.insert(events, events.date, events.time, auto_commit=True).values([d, t]).exec()
        query = events.insert(events.date, events.time, auto_commit=True).values([[d, t], [None, t]]).returning('*')
        data = query.all()
        print(data)
        
        query = events.insert(events.date, events.time, auto_commit=True).values([[d, t], [None, t]]).returning(events.date, events.time)
        data = query.all()
        print(data)
        
        query = events.insert(events.date, events.time, auto_commit=True).values([[d, t], [None, t]]).returning(['date', 'time'])
        data = query.all()
        print(data)
        
        query = events.insert(events.date, events.time, auto_commit=True).values([[d, t], [None, t]]).returning('date', 'time')
        data = query.all()
        print(data)
        
        data = DB.exec('select * from get_book_authors(1) as f(id int, name varchar)').config_fields('id', 'name').all()
        print(data)
        
        q = DB.select(events, events.id, events.id).where(id=1)
        data = q.all()
        print('data:', data, ';	error:', q.get_error())
        ```
        
Platform: UNKNOWN
Classifier: Programming Language :: Python :: 3.6
Classifier: Operating System :: OS Independent
Requires-Python: >=3.6
Description-Content-Type: text/markdown
