Script started on Wed 12 Sep 2007 10:36:35 PM PDT
$ python demo_sqlalchemy.py
Fred exists.
Barney exists.
The women in the Flintstone neighborhood are: Betty, Pebbles, Wilma.
Full roster of residents:
Name         Sex Pastime             
------------+---+--------------------
Bam-Bam     |M  |clubbing things         
Barney      |M  |being a buddy           
Betty       |F  |[Betty's pastime]       
Dino        |M  |eating                  
Fred        |M  |bowling                 
Pebbles     |F  |eating                  
Wilma       |F  |[Wilma's pastime]       
------------+---+--------------------
Bam-Bam's pastime is clubbing things.
Neighborhood census: 4 men, 3 women
Fred decides to get a sex-change operation.
Neighborhood census: 3 men, 4 women
All the men in the neighborhood decide to do the same.
Neighborhood census: 0 men, 7 women
Then the men have second thoughts and switch back.
Neighborhood census: 4 men, 3 women
End of demo.



$ sqlite3 flintstones.sqlite
SQLite version 3.3.5
Enter ".help" for instructions
sqlite> .schema Flintstones
CREATE TABLE "Flintstones" (
	name VARCHAR(255) NOT NULL, 
	sex VARCHAR(1) NOT NULL, 
	pastime VARCHAR(255) NOT NULL, 
	PRIMARY KEY (name)
);
sqlite> select * from Flintstones order by name;
Bam-Bam|M|clubbing things
Barney|M|being a buddy
Betty|F|[Betty's pastime]
Dino|M|eating
Fred|M|bowling
Pebbles|F|eating
Wilma|F|[Wilma's pastime]
sqlite> $ 



$ python demo_durus.py
Fred exists.
Barney exists.
The women in the Flintstone neighborhood are: Betty, Pebbles, Wilma.
Full roster of residents:
Name         Sex Pastime             
------------+---+--------------------
Bam-Bam     |M  |clubbing things         
Barney      |M  |being a buddy           
Betty       |F  |[Bettty's pastime]      
Dino        |M  |eating                  
Fred        |M  |bowling                 
Pebbles     |F  |crawling                
Wilma       |F  |[Wilma's pastime]       
------------+---+--------------------
Bam-Bam's pastime is clubbing things.
Neighborhood census: 4 men, 3 women
Fred decides to get a sex-change operation.
Neighborhood census: 3 men, 4 women
All the men in the neighborhood decide to do the same.
Neighborhood census: 0 men, 7 women
Then the men have second thoughts and switch back.
Neighborhood census: 4 men, 3 women
End of demo.



$ durus -c --file=flintstones.durus
Durus flintstones.durus
    connection -> the Connection
    root       -> the root instance
>>> import pprint
>>> flintstones = connection.get_root()["flintstones"]
>>> type(flintstones)
<class 'durus.persistent_dict.PersistentDict'>
>>> pprint.pprint(dict(flintstones))
{'Bam-Bam': <Flintstone name='Bam-Bam' sex='M' pastime='clubbing things'>,
 'Barney': <Flintstone name='Barney' sex='M' pastime='being a buddy'>,
 'Betty': <Flintstone name='Betty' sex='F' pastime='[Bettty's pastime]'>,
 'Dino': <Flintstone name='Dino' sex='M' pastime='eating'>,
 'Fred': <Flintstone name='Fred' sex='M' pastime='bowling'>,
 'Pebbles': <Flintstone name='Pebbles' sex='F' pastime='crawling'>,
 'Wilma': <Flintstone name='Wilma' sex='F' pastime='[Wilma's pastime]'>}
>>> 
$ 
Script done on Wed 12 Sep 2007 10:39:32 PM PDT