# Path: models/user.py
# class User(db.Model):
# 
#     created_at          = db.DateTimeProperty(required=True)
#     credentials         = db.TextProperty(default=u'')
#     google_birthday     = db.StringProperty(default=u'')
#     google_email        = db.EmailProperty()
#     google_gender       = db.StringProperty(default=u'')
#     google_id           = db.StringProperty(required=True)
#     google_locale       = db.StringProperty(default=u'')
#     google_name         = db.StringProperty(default=u'')
#     google_picture_url  = db.StringProperty(default=u'')
#     last_login_at       = db.DateTimeProperty(required=True)
#     modified_at         = db.DateTimeProperty(required=True)
#     profile_description = db.TextProperty(default=u'')
#     profile_email       = db.TextProperty(default=u'')
#     profile_name        = db.StringProperty(default=u'')
#     profile_slug        = db.StringProperty(required=True)
#     profile_web_address = db.TextProperty(default=u'')
# 
#     def refresh_token(self):
#         if self.credentials:
#             return json.loads(self.credentials).get('refresh_token')
#         else:
#             None
# 
#     def fetch_data_sources(self):
#         return self.data_sources.order('-modified_at').fetch(limit=None)
# 
#     def to_dict(self):
#         return {
#             'created_at':          self.created_at.strftime('%Y-%m-%d %H:%M:%s'),
#             'credentials':         self.credentials,
#             'data_sources':        [ds.to_dict() for ds in self.fetch_data_sources()],
#             'google_birthday':     self.google_birthday,
#             'google_email':        self.google_email,
#             'google_gender':       self.google_gender,
#             'google_id':           self.google_id,
#             'google_locale':       self.google_locale,
#             'google_name':         self.google_name,
#             'google_picture_url':  self.google_picture_url,
#             'last_login_at':       self.last_login_at.strftime('%Y-%m-%d %H:%M:%s'),
#             'modified_at':         self.modified_at.strftime('%Y-%m-%d %H:%M:%s'),
#             'profile_description': self.profile_description,
#             'profile_email':       self.profile_email,
#             'profile_name':        self.profile_name,
#             'profile_slug':        self.profile_slug,
#             'profile_web_address': self.profile_web_address
#             }
# 
#     @classmethod
#     def get_by_slug(self, profile_slug):
#         """ Find a user with the specified profile slug """
#         return User.gql("WHERE profile_slug = :1", profile_slug).get()
# 
#     @classmethod
#     def get_by_google_id(self, google_id):
#         """ Find a user with the specified google id """
#         return User.gql("WHERE google_id = :1", google_id).get()
# 
# Path: helpers/google_api.py
# class GoogleAPIException(Exception):
# def oauth2_flow(**kwargs):
# def http_from_oauth2(auth_json):
# def user_info(auth_json):
# def drive_service():
# def list_drive_files(auth_json, query="", page_token=None):
# def get_worksheets(auth_json, spreadsheet_key):
# def get_cell_data(auth_json, spreadsheet_key, worksheet_key, limit=None):
# def create_spreadsheet(auth_json, title=""):
# def create_worksheet(auth_json, spreadsheet_key):
# def save_data(auth_json, spreadsheet_key, worksheet_key, data=[[]]):
# def _key(heading):
# def _val(val):    #::::....|...                       ___(_)


from google.appengine.ext import db
from models.user import User
from helpers import google_api
    title              = db.StringProperty(default=u'')
    user               = db.ReferenceProperty(User, collection_name="data_sources")

    def fetch_data_views(self):
        return self.data_views.order('-modified_at').fetch(limit=None)

    def to_dict(self):
        return {
            'created_at':         self.created_at.strftime('%Y-%m-%d %H:%M:%s'),
            'data_views':         [dv.to_dict() for dv in self.fetch_data_views()],
            'description':        self.description,
            'google_spreadsheet': self.google_spreadsheet,
            'google_worksheet':   self.google_worksheet,
            'id':                 self.key().id(),
            'is_featured':        self.is_featured,
            'licence':            self.licence,
            'modified_at':        self.modified_at.strftime('%Y-%m-%d %H:%M:%s'),
            'slug':               self.slug,
            'tags':               self.tags.split(','),
            'tbl_stars':          self.tbl_stars,
            'title':              self.title,
            'used_extensions':    self.used_extensions(),
            'user_id':            self.user.key().id(),
            'user_profile_name':  self.user.profile_name,
            'user_profile_slug':  self.user.profile_slug,
            'public_url':         self.public_url(),
            'spreadsheet_url':    self.spreadsheet_url(),
        }

    def public_url(self):

# Path: models/user.py
# class User(db.Model):
# 
#     created_at          = db.DateTimeProperty(required=True)
#     credentials         = db.TextProperty(default=u'')
#     google_birthday     = db.StringProperty(default=u'')
#     google_email        = db.EmailProperty()
#     google_gender       = db.StringProperty(default=u'')
#     google_id           = db.StringProperty(required=True)
#     google_locale       = db.StringProperty(default=u'')
#     google_name         = db.StringProperty(default=u'')
#     google_picture_url  = db.StringProperty(default=u'')
#     last_login_at       = db.DateTimeProperty(required=True)
#     modified_at         = db.DateTimeProperty(required=True)
#     profile_description = db.TextProperty(default=u'')
#     profile_email       = db.TextProperty(default=u'')
#     profile_name        = db.StringProperty(default=u'')
#     profile_slug        = db.StringProperty(required=True)
#     profile_web_address = db.TextProperty(default=u'')
# 
#     def refresh_token(self):
#         if self.credentials:
#             return json.loads(self.credentials).get('refresh_token')
#         else:
#             None
# 
#     def fetch_data_sources(self):
#         return self.data_sources.order('-modified_at').fetch(limit=None)
# 
#     def to_dict(self):
#         return {
#             'created_at':          self.created_at.strftime('%Y-%m-%d %H:%M:%s'),
#             'credentials':         self.credentials,
#             'data_sources':        [ds.to_dict() for ds in self.fetch_data_sources()],
#             'google_birthday':     self.google_birthday,
#             'google_email':        self.google_email,
#             'google_gender':       self.google_gender,
#             'google_id':           self.google_id,
#             'google_locale':       self.google_locale,
#             'google_name':         self.google_name,
#             'google_picture_url':  self.google_picture_url,
#             'last_login_at':       self.last_login_at.strftime('%Y-%m-%d %H:%M:%s'),
#             'modified_at':         self.modified_at.strftime('%Y-%m-%d %H:%M:%s'),
#             'profile_description': self.profile_description,
#             'profile_email':       self.profile_email,
#             'profile_name':        self.profile_name,
#             'profile_slug':        self.profile_slug,
#             'profile_web_address': self.profile_web_address
#             }
# 
#     @classmethod
#     def get_by_slug(self, profile_slug):
#         """ Find a user with the specified profile slug """
#         return User.gql("WHERE profile_slug = :1", profile_slug).get()
# 
#     @classmethod
#     def get_by_google_id(self, google_id):
#         """ Find a user with the specified google id """
#         return User.gql("WHERE google_id = :1", google_id).get()
# 
# Path: helpers/google_api.py
# class GoogleAPIException(Exception):
# def oauth2_flow(**kwargs):
# def http_from_oauth2(auth_json):
# def user_info(auth_json):
# def drive_service():
# def list_drive_files(auth_json, query="", page_token=None):
# def get_worksheets(auth_json, spreadsheet_key):
# def get_cell_data(auth_json, spreadsheet_key, worksheet_key, limit=None):
# def create_spreadsheet(auth_json, title=""):
# def create_worksheet(auth_json, spreadsheet_key):
# def save_data(auth_json, spreadsheet_key, worksheet_key, data=[[]]):
# def _key(heading):
# def _val(val):    #::::....|...                       ___(_)


# Path: models/data_source.py
from google.appengine.ext import db
from models.user import User
from helpers import google_api

    title              = db.StringProperty(default=u'')
    user               = db.ReferenceProperty(User, collection_name="data_sources")

    def fetch_data_views(self):
        return self.data_views.order('-modified_at').fetch(limit=None)

    def to_dict(self):
        return {
            'created_at':         self.created_at.strftime('%Y-%m-%d %H:%M:%s'),
            'data_views':         [dv.to_dict() for dv in self.fetch_data_views()],
            'description':        self.description,
            'google_spreadsheet': self.google_spreadsheet,
            'google_worksheet':   self.google_worksheet,
            'id':                 self.key().id(),
            'is_featured':        self.is_featured,
            'licence':            self.licence,
            'modified_at':        self.modified_at.strftime('%Y-%m-%d %H:%M:%s'),
            'slug':               self.slug,
            'tags':               self.tags.split(','),
            'tbl_stars':          self.tbl_stars,
            'title':              self.title,
            'used_extensions':    self.used_extensions(),
            'user_id':            self.user.key().id(),
            'user_profile_name':  self.user.profile_name,
            'user_profile_slug':  self.user.profile_slug,
            'public_url':         self.public_url(),
            'spreadsheet_url':    self.spreadsheet_url(),
        }

    def public_url(self):

        return "/%s/%s/" % (self.user.profile_slug, self.slug)