title: What model should a SQLalchemy database column be to contain an array of data?
body: <p>So I am trying to set up a database, the rows of which will be modified frequently. Every hour, for instance, I want to add a number to a particular part of my database. So if <code>self.checkmarks</code> is entered into the database equal to <code>3</code>, what is the best way to update this part of the database with an added number to make <code>self.checkmarks</code> now equal <code>3, 2</code>? I tried establishing the column as <code>db.Array</code> but got an attribute error:</p>
  
  <blockquote>
    <p>AttributeError: 'SQLAlchemy' object has no attribute 'Array'</p>
  </blockquote>
  
  <p>I have found how to update a database, but I do not know the best way to update by adding to a list rather than replacing. My approach was as follows, but I don't think <code>append</code> will work because the column cannot be an array:</p>
  
  <pre><code>ven = data.query.filter_by(venid=ven['id']).first()
  ven.totalcheckins = ven.totalcheckins.append(ven['stats']['checkinsCount'])
  db.session.commit()
  </code></pre>
  
  <p>Many thanks in advance</p>