first cut of orm, orderlines only [sqlalchemy_classical_mapper]

hjwp · hjwp · commit 2f4f5301cc42 · 2019-11-20T21:08:45.000Z
diff --git a/.travis.yml b/.travis.yml
@@ -2,6 +2,9 @@ dist: xenial
 language: python
 python: 3.8
 
+install:
+- pip3 install sqlalchemy
+
 script:
 - make test
 
diff --git a/orm.py b/orm.py
@@ -0,0 +1,18 @@
+from sqlalchemy import Table, MetaData, Column, Integer, String
+from sqlalchemy.orm import mapper
+
+import model
+
+
+metadata = MetaData()
+
+order_lines = Table(
+    'order_lines', metadata,
+    Column('orderid', String(255), primary_key=True),
+    Column('sku', String(255), primary_key=True),
+    Column('qty', Integer),
+)
+
+
+def start_mappers():
+    mapper(model.OrderLine, order_lines)
