Table of Contents

  1. Introduction
  2. GnrSql Overview
    1. GnrSqlDb
    2. Database model
    3. Accessing the db
    4. Getting data
  3. Quick Start
    1. Use Genro on your SQL db
      1. Connecting to database
      2. Reading database Model
      3. Build the Model objects hierarchy
      4. Explore the model
      5. Selection
      6. Record
      7. Surfing data through relations
  4. Database model
    1. Model Source
      1. Writing a DbModelSrc in Python
        1. Adding package
        2. Adding tables
        3. Adding columns
        4. Adding relations
        5. Adding indexes
      2. Python vs. XML
    2. Model Object
  5. Query
      1. parameter: columns
      2. parameter where
      3. parameter relationDict
  6. Records
    1. record come bag
    2. campi primari
    3. campi in relazione ascendente
    4. campi in relazione discendente
    5. uso formule
    6. browsing automatico da un record nelle relazioni
    7. creazione nuovi record
    8. salvataggio di record
    9. modifica
    10. cancellazione
    11. trigger
    12. gestione record di transazione
  7. Creation and editing
    1. Esempi pratici

Introduction

Genropy provides a very useful library package called gnr.sql that represents our way to handle SQL databases using concepts such as bags, resolvers and structures. Genro Db tools can be used as part of Genro framework, or simlpy as an high level db API.

The most important class, defined in the module gnrsql is GnrSqlDb. This object is used for accessing and writing data to a database.

Now look at the project overview. Overview

Do the QuickStart

OLD STUFF

Attachments