DybDbi::desc Namespace Reference

Classes
class	Result
Variables
tuple	tabs = Result("show tables")
	output descriptions of all tables
tuple	dsc = Result("describe %s" % t )

---

Detailed Description

Introspect the table descriptions in the DB ...
for schema checking comparisons against 
what the Spec/Code expects :
this is step zero in handling schema migration.


{'Extra': '', 'Default': '0', 'Field': 'SEQNO', 'Key': 'PRI', 'Null': 'NO', 'Type': 'int(11)'}
{'Extra': '', 'Default': '0', 'Field': 'ROW_COUNTER', 'Key': 'PRI', 'Null': 'NO', 'Type': 'int(11)'}
{'Extra': '', 'Default': '', 'Field': 'channelId', 'Key': '', 'Null': 'YES', 'Type': 'int(10) unsigned'}
{'Extra': '', 'Default': '', 'Field': 'status', 'Key': '', 'Null': 'YES', 'Type': 'int(10) unsigned'}
{'Extra': '', 'Default': '', 'Field': 'pedestalHigh', 'Key': '', 'Null': 'YES', 'Type': 'double'}
{'Extra': '', 'Default': '', 'Field': 'sigmaPedestalHigh', 'Key': '', 'Null': 'YES', 'Type': 'double'}
{'Extra': '', 'Default': '', 'Field': 'pedestalLow', 'Key': '', 'Null': 'YES', 'Type': 'double'}
{'Extra': '', 'Default': '', 'Field': 'sigmaPedestalLow', 'Key': '', 'Null': 'YES', 'Type': 'double'}
{'Extra': '', 'Default': '', 'Field': 'thresholdHigh', 'Key': '', 'Null': 'YES', 'Type': 'double'}
{'Extra': '', 'Default': '', 'Field': 'thresholdLow', 'Key': '', 'Null': 'YES', 'Type': 'double'}

---

Variable Documentation

tuple DybDbi::desc::tabs = Result("show tables")

output descriptions of all tables

Definition at line 47 of file desc.py.

tuple DybDbi::desc::dsc = Result("describe %s" % t )

Definition at line 50 of file desc.py.