article_ext.coffee

#
# lib/models/article.coffee
# => Resources/models/article.js
#
TiActiveRecord = require 'lib/TiActiveRecord'

class Article extends TiActiveRecord

  @dbName = 'myapp'
  @tableName = 'articles'
  @properties =
    uid: 'integer'
    title: 'text'
    body: 'text'
    image_url: 'text'
    image_name: 'text'
    pv: 'integer'

  #
  # class method
  #
  @findAllByUserId = (userId) ->
    sql = "SELECT * FROM #{@tableName} WHERE USER_ID = ?"
    @read sql, userId

  #
  # instance method
  #
  getImageDir: ->
    imageDir = Ti.Filesystem.getFile(Ti.Filesystem.applicationDataDirectory, "article#{@uid}")
    unless imageDir.exists()
      imageDir.createDirectory()
    imageDir

Article.init()

module.exports = Article