thequbit

Running "deploy" task

Running "build" task

Running "sass:build" (sass) task
File ./style/frontpage.css created.

Running "autoprefixer:build" (autoprefixer) task
File ./style/frontpage.css created.

thequbit

mysql> mysql> SELECT posts.post_id AS posts_post_id, posts.assignment_id AS posts_assignment_id, posts.client_id AS posts_client_id, posts.post_datetime AS posts_post_datetime, posts.deleted AS posts_deleted, posts.lat AS posts_lat, posts.lng AS posts_lng, mediaobjects.media_object_id AS mediaobjects_media_object_id, mediaobjects.media_id AS mediaobjects_media_id, mediaobjects.file_name AS mediaobjects_file_name, mediaobjects.caption AS mediaobjects_caption, mediaobjeia_text AS mediaobjects_media_text, mediatypes.NAME AS mediatypes_name, mediatypes.description AS mediatypes_description, clients.verified AS clients_verified, clients.client_id AS clients_client_id, languages.language_code AS languages_language_code, languages.NAME AS languages_name FROM posts JOIN postmediaobjects ON posts.post_id = postmediaobjects.post_id JOIN mediaobjects ON mediaobjects.media_object_id = postmediaobjects.media_object_id JOIN mediatypes ON mediatypes.media_type_id = mediaobjects.media_type_id JOIN clients ON clients.client_i

thequbit

class Posts(Base):

    __tablename__ = 'posts'
    post_id = Column(Integer, primary_key=True)
    #user_id = Column(Integer, ForeignKey('users.user_id'))
    client_id = Column(Integer, ForeignKey('clients.client_id'))
    assignment_id = Column(Integer, ForeignKey('assignments.assignment_id'))
    #title = Column(Text)
    post_datetime = Column(DateTime)
    language_id = Column(Integer, ForeignKey('languages.language_id'))

thequbit

    @classmethod
    def get_all_from_assignment_id(cls, session, assignment_id, \
            deleted=False, start=0, count=0):
        with transaction.manager:
            posts_query = session.query(
                Posts.post_id,
                Posts.assignment_id,
                Posts.client_id,
                Posts.post_datetime,
                Posts.deleted,

thequbit

In file included from _mysql.c:44:0:
/usr/include/mysql/my_config.h:438:0: warning: "HAVE_WCSCOLL" redefined [enabled by default]
 #define HAVE_WCSCOLL
 ^
In file included from /usr/include/python2.7/pyconfig.h:3:0,
                 from /usr/include/python2.7/Python.h:8,
                 from _mysql.c:29:
/usr/include/x86_64-linux-gnu/python2.7/pyconfig.h:911:0: note: this is the location of the previous definition
 #define HAVE_WCSCOLL 1
 ^

thequbit

$ sudo apt-get install libmysqlclient-dev python-dev
Reading package lists... Done
Building dependency tree
Reading state information... Done
python-dev is already the newest version.
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

thequbit

Client CUID: 91652a42-88b9-43ab-86c8-1c6d8c1058ee
2015-02-18 13:50:34,536 INFO  [sqlalchemy.engine.base.Engine][Dummy-3] BEGIN (implicit)
2015-02-18 13:50:34,536 INFO  [sqlalchemy.engine.base.Engine][Dummy-3] INSERT INTO clients(cuid) SELECT * FROM ( SELECT "%s" ) AS temp_table WHERE NOT EXISTS (     SELECT cuid FROM clients WHERE cuid = "%s" ) LIMIT 1;
2015-02-18 13:50:34,537 INFO  [sqlalchemy.engine.base.Engine][Dummy-3] (u'91652a42-88b9-43ab-86c8-1c6d8c1058ee', u'91652a42-88b9-43ab-86c8-1c6d8c1058ee')
2015-02-18 13:50:34,538 INFO  [sqlalchemy.engine.base.Engine][Dummy-3] ROLLBACK
Client CUID: 91652a42-88b9-43ab-86c8-1c6d8c1058ee
2015-02-18 13:50:34,542 INFO  [sqlalchemy.engine.base.Engine][Dummy-4] BEGIN (implicit)
2015-02-18 13:50:34,542 INFO  [sqlalchemy.engine.base.Engine][Dummy-4] INSERT INTO clients(cuid) SELECT * FROM ( SELECT "%s" ) AS temp_table WHERE NOT EXISTS (     SELECT cuid FROM clients WHERE cuid = "%s" ) LIMIT 1;
2015-02-18 13:50:34,543 INFO  [sqlalchemy.engine.base.Engine][Dummy-4] (u'9165

thequbit

result = session.execute(
    'INSERT INTO clients(cuid) '
    'SELECT * FROM ( SELECT ":cuid" ) AS temp_table '
    'WHERE NOT EXISTS ( '
    '    SELECT cuid FROM clients WHERE cuid = ":cuid" '
    ') LIMIT 1;',
   cuid=cuid
)

thequbit

=======================================
upload_media.json


POST /upload_media.json HTTP/1.1
Host: anna.duffnet.local:5002
Cache-Control: no-cache

----WebKitFormBoundaryE19zNvXGzXaLvS5C
Content-Disposition: form-data; name="client_id"

thequbit

{
    "media_id": "13fc908d-8085-40d3-9456-59c7007e96b2",
    "success": true,
    "preview_file_name": "2baa9288-988e-4936-ba12-b69f1052428fp.jpg",
    "file_name": "2baa9288-988e-4936-ba12-b69f1052428f.jpg",
    "new_user": true,
    "error_text": ""
}