title: Python - How to connect SQLAlchemy to existing database in memory
body: <p>I'm creating my DB from an existing shema and it's stored in <code>:memory:</code>.</p>
  <pre><code>db = Database(filename=':memory:', schema='schema.sql')
  db.recreate()
  </code></pre>
  <p>I now want to &quot;link&quot; this to SQL Alchemy. Followed different methods but could not get it right.</p>
  <p>My current attempt stands as follow:</p>
  <pre><code>engine = create_engine('sqlite:///:memory:')
  
  Base = automap_base()
  Base.prepare(engine, reflect=True)
  User = Base.classes.user
  
  session = Session(engine)
  </code></pre>
  <p>Much like the other stuff I tried this will throw <code>AttributeError: user</code>.</p>
  <p>How can I have this work together?</p>