Guest User

Untitled

a guest
Jun 17th, 2012
33
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.49 KB | None | 0 0
  1. ________________________
  2. XML Schema
  3.  
  4. 1 <?xml version="1.0"?>
  5. 2 <database>
  6. 3 <table name="bootstrap" comment="This table is only intended to ever have one record">
  7. 4 <field name="schemaVersion" type="REAL" />
  8. 5 <field name="dbSchema" type="VARCHAR(1048576)" comment="1 MB of text" />
  9. 6 </table>
  10. 7 <table name="Symbol">
  11. 8 <field name="Type" type="SMALLINT" />
  12. 9 <field name="SymbolSpace" type="INTEGER" />
  13. 10 </table>
  14. 11 <table name="PrimitiveSymbolToContent">
  15. 12 <field name="SymbolID" type="INTEGER" ref_target="Symbol(SymbolID)" />
  16. 13 <field name="Content" type="VARCHAR(1024)" />
  17. 14 </table>
  18. 15 <table name="SymbolComposition">
  19. 16 <field name="CompositeSymbolID" type="INTEGER" ref_target="Symbol(SymbolID)" />
  20. 17 <field name="ComponentID" type="INTEGER" ref_target="Symbol(SymbolID)" />
  21. 18 </table>
  22. 19 <table name="Memory">
  23. 20 <field name="Starttime" type="timestamp" />
  24. 21 <field name="Duration" type="timestamp" />
  25. 22 </table>
  26. 23 <table name="MemoryFrame">
  27. 24 <field name="MemoryID" type="INTEGER" ref_target="Memory(MemoryID)" />
  28. 25 <field name="SequenceIndex" type="INTEGER" />
  29. 26 <field name="TimeOffset" type="INTERVAL" />
  30. 27 </table>
  31. 28 <table name="MemorySymbol">
  32. 29 <field name="MemoryFrameID" type="INTEGER" ref_target="MemoryFrame(MemoryFrameID)" />
  33. 30 <field name="SymbolID" type="INTEGER" ref_target="Symbol(SymbolID)" />
  34. 31 <field name="Activation" type="REAL" />
  35. 32 </table>
  36. 33 <table name="Recommendation">
  37. 34 <field name="RecommenderID" type="INTEGER" ref_target="Symbol(SymbolID)" />
  38. 35 <field name="RecommendeeID" type="INTEGER" ref_target="Symbol(SymbolID)" />
  39. 36 <field name="Probability" type="REAL" />
  40. 37 </table>
  41. 38 </database>
  42.  
  43. ___________________
  44.  
  45. 153 dbRdr = DBEntryReader('Symbol')
  46. 154 dbRdr.FilterByType([0,2])
  47. 155 dbRdr.FilterBySymbolID([1,2,3])
  48. 156 dbRdr.Execute()
  49. 157 while dbRdr.Read():
  50. 158 print('SymbolID', dbRdr.SymbolID)
  51. 159 print('Type', dbRdr.Type)
  52. 160 print('SymbolSpace', dbRdr.SymbolSpace)
  53. 161 dbRdr.Close()
Advertisement
Add Comment
Please, Sign In to add comment