Module lemon.db.drivers.gc

Lemon DB interface to the gadfly cursor.


THIS SOFTWARE IS PROVIDED WITH ABSOLUTELY NO WARRANTY WHATSOVER. YOU USE IT ENTIRELY AT YOUR OWN RISK.
IT ISN'T EVEN SUPPLIED WITH AN IMPLIED FITNESS FOR ANY PURPOSE.

WARNING:

    This Gadfly cursor is experimental. It works for most purposes but becuase Gadlfy is not a full SQL database
    and is not particularly robust you may come across issues in its use. Gadfly also needs to be connected
    in a different mode for performing DROP, ALTER and CREATE commands (see below). If you do not use this mode
    you could run into problems.
    
    You should learn Gadfly's quirks before using this software and then you are much less likely to run into
    problems.
    
    DO NOT USE IN PRODUCTION SYSTEMS.
    
Version:

    File Version 0.1 for LEMON 0.2
    
Description:
    
    Module containing the gadfly cursor.

Warning: Gadfly has no real typing. Al results are just varchars.

    To create a database using gadfly use the usual interface not the lemon.db one.
    
        import gadfly
        import lemon.db.gadfly
        
        connection = gadfly.gadfly()
        connection.startup("mydatabase", "mydirectory")
        
        cursor = lemon.db.gadfly.gadflyCursor(conn=connection)
        
        cursor.execute("create table ph (nm varchar, ph varchar)")
        cursor.execute("insert into ph(nm, ph) values ('arw', '3367')")
        cursor.setShowWarnings(False)
        for x in cursor.SELECT(('nm', 'ph'),"ph"):
            print x
        print cursor.description
        
        cursor.commit()
        
Making a backup

    WARNING:
    
    Gadfly stores the data in the database as text files. If you are transferring files from a server make sure 
    you set the transfer to 'Binary' as you may well corrupt the files transferring them in 'Auto' or 'Text' mode.
    You have been warned!