18733
Comment:
|
22438
added troubleshooting tips for known cyappstore error
|
Deletions are marked like this. | Additions are marked like this. |
Line 11: | Line 11: |
2.x plugins are managed by UCSD's chianti server. When a developer submits a 2.x plugin, it goes to chianti, ''not'' to the App Store. When a plugin submission is approved, an automatic email is sent by Peng to Samad. If the plugin already has a page on the App Store: 1. Open [[http://cytoscape.org/plugins/plugins.xml]] in an XML editor. Look for the new plugin in this file. 1. In the App Store, sign in as staff. Open the app page and edit it. 1. From ''plugins.xml'', copy the plugin's download URL, release date, and version to the app page. Save the app page. If the plugin does not have an app page in the App Store: 1. Ssh into nrnb.org. Go to the {{{/var/www/CyAppStore}}} directory. 1. Run {{{python manage.py add_plugins "full-name-of-plugin-in-quotes"}}}, where the full name is copied from ''plugins.xml''. This will create the app page for the 2.x plugin. 1. Send an email to the app author with the new app page URL. Ask the author to sign into the App Store to create an account. 1. After the author has signed in, look for the email address in {{{http://apps.cytoscape.org/admin/auth/user}}}. Then add the email address to the list of editors in the app's edit page. Send an email back to the author who now has editing privileges to the app page. |
2.x plugins are managed by UCSD's chianti server. When a developer submits a 2.x plugin, it goes to chianti, ''not'' to the App Store. When a plugin submission is approved, plugins.xml is updated, and an automatic email is sent by Barry. To update the app page to reflect the update to plugins.xml: 1. Go to the App Store and make sure you're signed in a staff account. 1. In the user menu, click "2.x Plugin Management". 1. In the plugin name field, enter the name of the 2.x plugin whose page you want to update. 1. The page will present details about the plugin it obtained from plugins.xml. Check these details. 1. If the details are correct, click on the blue button on the bottom right. |
Line 73: | Line 68: |
* {{{jeff@pinscher.ucsf.edu}}}: Current account server hosting the App Store. | * {{{jeff@pinscher.ucsf.edu}}}: Current account and server hosting the App Store. |
Line 77: | Line 72: |
= App Store Software Dependencies = |
= App Store Dependencies = The App Store requires a machine with 2GB RAM and enough disk space to accommodate a growing app collection. The software itself takes 2.2GB and as of September 2015 the media directory takes 4.3GB to hold 238 apps (368 releases/jar files), and the MySQL database takes 61MB to hold associated author, release and tag data. So, 6.51GB in total. Grow your estimate as the number of apps grows and also add 2GB for temporary scratch space. |
Line 113: | Line 111: |
= Migration = If you want to move the App Store to another machine, here is what to do: 1. Install the needed libraries on the new machine by following the instructions in the *App Store Dependencies* section above. 1. Check out the App Store GitHub repository to the new machine: [[http://github.com/cytoscape/appstore]] 1. In the `conf` directory, make a copy of each `-template.py` file, removing the `-template.py` portion of the file name (e.g. `cp apikeys-template.py apikeys.py`). Open each template file and fill in the fields. Copy the old machine's configuration files if necessary. Do the same for `maven-app-repo-settings-template.xml` in the parent directory, which contains sensitive username and password information. 1. In the `download/geolite` directory, type `make`. This will download the needed !GeoLite data files. (!GeoLite maps IP addresses to geographical locations.) 1. Create the following daily cron jobs on the new machine: * Database backups described above in the subsection ''Backup System''. * Free text search reindexing: the crob job should run `make index` in the App Store directory. 1. Take a snapshot of the database using `mysqldump` then load it to the new machine's database: {{{ # Run this on the old machine mysqldump -u USER_NAME DB_NAME > CyAppStoreDbDump.sql # Transfer CyAppStoreDbDump.sql from the old to new machine # Run this on the new machine mysql -u USER_NAME DB_NAME < CyAppStoreDbDump.sql}}} 1. Create an entry in Apache's `sites-enabled` directory for the App Store. Use the old machine's entry if necessary. 1. Restart Apache and run the test protocol that's described below. == Other resources == In addition to getting the !CyAppStore code up and running along with its dependencies, there are other systems required for a full migration: * Server conf file, e.g., httpd.conf or apache2.conf * Google's authentication protocol for user login. See documentation at https://developers.google.com/identity/protocols/OAuth2 and ask an admin to make changes at https://console.developers.google.com/project. |
|
Line 175: | Line 210: |
Make sure that {{{'default'}}} is pointing to te correct dictionary: | Make sure that {{{'default'}}} is pointing to the correct dictionary: |
Line 193: | Line 228: |
make svnclean }}} |
make nopyc }}} = Known ERROR notifications = 1. {{{MultipleObjectsReturned: get() returned more than one AppDownloadsByGeoLoc -- it returned 2! }}} a. log into mysql: {{{mysql -u root --password=PASSWORD cyappstore}}} b. list any duplicate country entries per app {{{ select app_id, geoloc_id, count(*) as c from download_appdownloadsbygeoloc where app_id is not null group by app_id,geoloc_id having c > 1; }}} c. arbitrarily select the MAX record id from these duplicate cases and delete those records. ''Note: this potentially deletes valid download records and must be repeated if duplicate count is > 2'' {{{ delete from download_appdownloadsbygeoloc where id in (select max from (select MAX(id) as max, app_id, geoloc_id, count(*) as c from download_appdownloadsbygeoloc where app_id is not null group by app_id,geoloc_id having c > 1) as T); }}} 2. {{{MultipleObjectsReturned: get() returned more than one ReleaseDownloadsByDate -- it returned 2! }}} a. log into mysql: {{{mysql -u root --password=PASSWORD cyappstore}}} b. list any duplicate country entries per app {{{ select release_id, download_releasedownloadsbydate.when, count(*) as c from download_releasedownloadsbydate where release_id is not null group by release_id,download_releasedownloadsbydate.when having c > 1; }}} c. arbitrarily select the MAX record id from these duplicate cases and delete those records. ''Note: this potentially deletes valid download records and must be repeated if duplicate count is > 2'' {{{ delete from download_releasedownloadsbydate where id in (select max from (select MAX(id) as max, release_id, download_releasedownloadsbydate.when, count(*) as c from download_releasedownloadsbydate where release_id is not null group by release_id,download_releasedownloadsbydate.when having c > 1) as T); }}} |
Line 203: | Line 283: |
* If you want to remove unused tags, authors, and media files, type this command: | * If you edit any Python files and need it to be refreshed by Apache, you will need to remove all pyc files: |
Line 205: | Line 285: |
python manage.py garbage_dump }}} If any tags or authors were removed, you will have to reindex the text search engine. * When a developer adds a 2.x plugin, it goes into {{{http://cytoscape.org/plugins/plugins.xml}}} but not automatically into the App Store. To add a newly added plugin in {{{plugins.xml}}} to the App Store, do the following: 1. Download {{{plugins.xml}}} and open it. 1. Find the name of the plugin you want to add. It is enclosed in the {{{<name>}}} tag. 1. Run this command: {{{ python manage.py add_plugins_from_plugins_xml name-of-plugin }}} The name of the plugin ''must'' match what's in the {{{<name>}}} tag. If the name has spaces, enclose the name in quotation marks. Do ''not'' run this command on plugins already with app pages, as it will overwrite its details. 1. Reindex the search engine so the app can found through free text search. |
make nopyc }}} |
Line 412: | Line 481: |
=== Extract list of authors for recently updated/submitted apps === Use case: producing a contact list for F1000Research channel authors 1. log into server: `root@apps.cytoscape.org` 1. log into docker (if a docker instance): docker exec -it appstore_mysql_1 /bin/bash 1. log into mysql: mysql -u root --password=PASSWORD cyappstore 1. `select distinct first_name,last_name,email,release_file from apps_app_editors left join apps_release on apps_app_editors.app_id=apps_release.app_id left join auth_user on apps_app_editors.user_id=auth_user.id where apps_release.created>"2015-03-01 01:01:01"; ` |
Site Administration
"Contact Us" emails
When a user fills out the form on the "Contact Us" page, the site sends an email to the site administrator's email address (defined in conf.emails.CONTACT_EMAIL). This email is sent out by the automated email account defined in conf.emails.EMAIL_HOST_USER. Thus, when the administrator receives the email, it will be from the automated email account, not from the user who filled out the "Contact Us" form. The first line in the email contains the user's email address.
When responding to "Contact Us" emails, remember to change the reply address to the user's email address.
2.x plugin submissions
2.x plugins are managed by UCSD's chianti server. When a developer submits a 2.x plugin, it goes to chianti, not to the App Store. When a plugin submission is approved, plugins.xml is updated, and an automatic email is sent by Barry.
To update the app page to reflect the update to plugins.xml:
- Go to the App Store and make sure you're signed in a staff account.
- In the user menu, click "2.x Plugin Management".
- In the plugin name field, enter the name of the 2.x plugin whose page you want to update.
- The page will present details about the plugin it obtained from plugins.xml. Check these details.
- If the details are correct, click on the blue button on the bottom right.
3.0 app submissions
When a jar is submitted to the App Store, the site sends an automated email to the administrator's email address (defined in conf.emails.CONTACT_EMAIL). Even if the app is not approved in the final step by the author, the administrator receives an email. This is done so that the administrator can monitor all submissions.
If an app page already exists for the 3.0 jar submission, the new release becomes immediately available. The administrator will receive an automated email about the submission.
If the app is new, the jar submission requires approval by staff. Sign in as staff, then go to the App Store site. In the user menu on the top right of the page, choose "Pending Apps". At this page, staff can approve an app. Approving an app sends an automatic email to the author and doesn't require any additional work. If the jar is not satisfactory, it can be rejected. No automatic email is sent to the author if the jar is rejected. This is because rejections happen when a jar is malformed and require an individualized email to the author.
App Store Code Structure
Terminology
Django app: Django organizes websites into separate modules called apps. Each app has its own directory at the top level typically containing files like __init__.py, model.py, and views.py.
templates: HTML files with placeholders, which Django processes by filling in Python code.
static files: general website files (images, Java Script, CSS) that are served as is without any processing from Django.
media files: general website files referenced by the database; they are served as is without any processing from Django.
mod_wsgi: Apache module that interfaces with Python.
Explanation of important files
Configuration Files
settings.py: Django settings file for configuring things like the database, location of templates, static files, and so on.
urls.py: the general URL layout of the entire site. Each URL entry in this file delegates URL paths to each Django app.
django.wsgi: the configuration file used when the App Store is deployed to an Apache server using mod_wsgi.
Django Apps
apps: navigation of Cytoscape apps and app pages
users: user login/logout
search: free text searching
backend: JSON representation of 3.0 apps; used by the App Manager in Cytoscape 3.0+
help: about, contact us, getting started pages
submit_app: Cytoscape 3.0 app submission pages and jar verification
download: for downloading releases and tracks download stats for apps
Other Directories
templates: Templates used throughout the App Store.
static: Each subdirectory has static files for a Django app. The common subdirectory has static files that belong to the entire site. When deploying the site to Apache, Apache should directly serve these files instead of through Django.
util: small utility functions used throughout the site's code
dbmigration: scripts that directly update SQL tables after changes had been made to database models; only needed when needing to migrate old versions of SQL database backups
conf: individual configuration files
Backup System
jeff@pinscher.ucsf.edu: Current account and server hosting the App Store.
/home/jeff/backup_cyappstore: Dir containing backup script and latest backup SQL and TGZ.
backupdb.sh: Backup script run by cron job, daily at 12:03am. The script performs a sqldump of the "cyappstore" database, then tar cfz, then scp both files to jeff@pointer.ucsf.edu:/home/jeff/backup_cyappstore/, where the last 2 weeks' worth of SQL and TGZ files are maintained by the prune_cyappstore script.
App Store Dependencies
The App Store requires a machine with 2GB RAM and enough disk space to accommodate a growing app collection. The software itself takes 2.2GB and as of September 2015 the media directory takes 4.3GB to hold 238 apps (368 releases/jar files), and the MySQL database takes 61MB to hold associated author, release and tag data. So, 6.51GB in total. Grow your estimate as the number of apps grows and also add 2GB for temporary scratch space.
The App Store requires the following software packages. If you're on a Mac, this can be installed with Homebrew. If you're on Linux, use your distribution's package manager.
Note that the versions specified here are not mandatory. They only indicate the version with which I've tested the App Store.
- Python 2.6
- xapian 1.2.13 (free-text searching)
- xapian-bindings 1.2.13
This package is not available through Homebrew. The package must be downloaded and installed manually. When running the configure script, make sure to add the --with-python argument: ./configure --with-python
- libjpeg 8d (used by PIL)
- libpng 1.5.14 (also used by PIL)
- GeoIP 1.4.8 (converts IP addresses to geographical locations)
The following Python packages are also required. Each can be installed with pip install. If you don't have pip, type: easy_install pip.
- Django 1.4.5
- MySQL-Python (aka MySQLdb; can be installed with Debian/Ubuntu's package manager; Django uses this to connect to the MySQL database)
- PIL 1.1.7 (can be installed with Debian/Ubuntu's package manager; needed to scale icon and screenshot image files)
PIL must be built the JPEG support. At the end of PIL's installation, you'll see a printout titled PIL 1.1.7 SETUP SUMMARY. This must list JPEG as supported.
- django-social-auth 0.7.23 (aka social_auth; allows users to log in with their Google accounts)
- IPython -- optional (can be installed with Debian/Ubuntu's package manager; very useful for debugging)
Testing App Store Software Dependencies
Run the test_dependencies.py script like so:
python external_scripts/test_dependencies.py
Test the GeoIP library:
python manage.py test_geoip
Note: this script can only be run after the Django project has been configured.
Migration
If you want to move the App Store to another machine, here is what to do:
- Install the needed libraries on the new machine by following the instructions in the *App Store Dependencies* section above.
Check out the App Store GitHub repository to the new machine: http://github.com/cytoscape/appstore
In the conf directory, make a copy of each -template.py file, removing the -template.py portion of the file name (e.g. cp apikeys-template.py apikeys.py). Open each template file and fill in the fields. Copy the old machine's configuration files if necessary. Do the same for maven-app-repo-settings-template.xml in the parent directory, which contains sensitive username and password information.
In the download/geolite directory, type make. This will download the needed GeoLite data files. (GeoLite maps IP addresses to geographical locations.)
- Create the following daily cron jobs on the new machine:
Database backups described above in the subsection Backup System.
Free text search reindexing: the crob job should run make index in the App Store directory.
Take a snapshot of the database using mysqldump then load it to the new machine's database:
# Run this on the old machine mysqldump -u USER_NAME DB_NAME > CyAppStoreDbDump.sql # Transfer CyAppStoreDbDump.sql from the old to new machine # Run this on the new machine mysql -u USER_NAME DB_NAME < CyAppStoreDbDump.sql
Create an entry in Apache's sites-enabled directory for the App Store. Use the old machine's entry if necessary.
- Restart Apache and run the test protocol that's described below.
Other resources
In addition to getting the CyAppStore code up and running along with its dependencies, there are other systems required for a full migration:
- Server conf file, e.g., httpd.conf or apache2.conf
Google's authentication protocol for user login. See documentation at https://developers.google.com/identity/protocols/OAuth2 and ask an admin to make changes at https://console.developers.google.com/project.
How requests are handled
|| | | | | || Request=>|| ==Apache==> | == sites-enabled/appstore ==> | == django.wsgi ==> | == settings.py ==> | == urls.py || || | | | | ||
- An HTTP request is made to the Apache server.
Apache looks in /etc/apache2/sites-enabled to see how to handle the request. The appstore configuration file is set to handle requests made to http://apps.cytoscape.org.
appstore tells Apache to use mod_wsgi. mod_wsgi runs a Python interpreter within Apache. appstore tells mod_wsgi to start Python with /var/www/CyAppStore/django.wsgi.
django.wsgi starts the Django library. It also tells Django the location of settings.py, which Django needs to start the site.
settings.py contains the location of urls.py (defined in the ROOT_URLCONF variable), which is a list of URLs (in the form of regular expressions) and the Python functions that handle them.
urls.py in the top directory of the App Store merely imports additional URLs from each Django app. It dispatches the request to the appropriate function that is designated to handle requests for a given URL. Functions are defined in the views.py file in each Django app.
- The handler function returns with a processed HTML page.
Debugging
/etc/apache2/sites-enabled/appstore
- This file tells Apache and mod_wsgi where to find the site. The most important line is this:
WSGIScriptAlias / /var/www/CyAppStore/django.wsgi
This tells Apache and mod_wsgi where to locate the site code. Make sure the path to django.wsgi is correct.
- This file tells Apache and mod_wsgi where to find the site. The most important line is this:
/var/www/CyAppStore/django.wsgi
This file invokes Django's WSGI handler. It needs to correctly reference settings.py to start the site. Make sure these two lines are correct:
SITE_PARENT_DIR = '/var/www' SITE_DIR = filejoin(SITE_PARENT_DIR, 'CyAppStore')
To check if these variables are being defined correctly, you can launch a separate Python interpreter and enter these lines:from os.path import join as filejoin SITE_PARENT_DIR = '/var/www' SITE_DIR = filejoin(SITE_PARENT_DIR, 'CyAppStore')
Then check if the variables SITE_PARENT_DIR and SITE_DIR are correct.
/var/www/CyAppStore/settings.py
This file is pretty complicated. But if you've checked everything at this point, here's some ways to pinpoint problems in settings.py.
If you're getting an HTTP 500 error, you can get the stack trace by turning on debug mode then reloading the page. Note that debug mode exposes sensitive information about the site to the public. Make sure to keep debug mode off as much as possible. Change to following line to True:
DEBUG = False
You can poke at the code by running a Python shell. Enter this command at the shell prompt in the same directory as settings.py:
python manage.py shell
You can check to see if the site's code is working correctly without having debug mode on. For example, to see if the list of all apps is working, enter this into the Python interpreter:from apps.models import App App.objects.all()
The SQL database settings are specified by the DATABASES variable:
DATABASES = { 'default': deploy_database }
Make sure that 'default' is pointing to the correct dictionary:
deploy_database = { 'ENGINE': 'django.db.backends.mysql', 'NAME': ... 'USER': ..., 'PASSWORD': ... }
If you're getting database errors, enter this command at the shell prompt in the same directory as settings.py:
python manage.py dbshell
If you're able to get a SQL prompt, that means Django can connect to the SQL database.If you make changes to a Python file but you're not seeing the changes taking effect, you may have to delete all the .pyc files. To do so, type this:
make nopyc
Known ERROR notifications
MultipleObjectsReturned: get() returned more than one AppDownloadsByGeoLoc -- it returned 2!
log into mysql: mysql -u root --password=PASSWORD cyappstore b. list any duplicate country entries per app
select app_id, geoloc_id, count(*) as c from download_appdownloadsbygeoloc where app_id is not null group by app_id,geoloc_id having c > 1;
c. arbitrarily select the MAX record id from these duplicate cases and delete those records. Note: this potentially deletes valid download records and must be repeated if duplicate count is > 2
delete from download_appdownloadsbygeoloc where id in (select max from (select MAX(id) as max, app_id, geoloc_id, count(*) as c from download_appdownloadsbygeoloc where app_id is not null group by app_id,geoloc_id having c > 1) as T);
MultipleObjectsReturned: get() returned more than one ReleaseDownloadsByDate -- it returned 2!
log into mysql: mysql -u root --password=PASSWORD cyappstore b. list any duplicate country entries per app
select release_id, download_releasedownloadsbydate.when, count(*) as c from download_releasedownloadsbydate where release_id is not null group by release_id,download_releasedownloadsbydate.when having c > 1;
c. arbitrarily select the MAX record id from these duplicate cases and delete those records. Note: this potentially deletes valid download records and must be repeated if duplicate count is > 2
delete from download_releasedownloadsbydate where id in (select max from (select MAX(id) as max, release_id, download_releasedownloadsbydate.when, count(*) as c from download_releasedownloadsbydate where release_id is not null group by release_id,download_releasedownloadsbydate.when having c > 1) as T);
Tips
- You can reindex the text search engine with this command:
make index
- If you edit any Python files and need it to be refreshed by Apache, you will need to remove all pyc files:
make nopyc
App Store Test Protocol
- Does the front page load?
- Does "All Apps" load?
- Does sorting work as expected?
- Does a category load?
Does a 2.x plugin page load? (e.g. /apps/psicquicuniversalclient)
- Does plugin downloading work?
- Does "Search for posts" work?
- Does ratings work?
Does a 3.x app page load? (e.g. /apps/cluego)
- Do release downloads work?
- When a release is downloaded, is it reflected in the stats page?
- Does app page editing work?
- Icon?
- Any link field?
- Details editing?
- Deleting a 3.0 release?
- Does the release still show in the download stats?
- Does the release no longer show in the app page?
- Does the release no longer show in the backend?
- Does depending on the deleted release fail?
- Does submitting a jar with the same name and version succeed?
- Does search work?
Do app author pages work? (e.g. /apps/with_author/John%20"Scooter"%20Morris)
- Does the "About" page load?
- Does the "Contact Us" page load and work?
Does the /backend/all_apps page work?
- Does it refer accurately to icon and release URLs?
- Do the admin pages load?
App Submission Test Protocol
App submissions will principally test the manifest file. The following snippets are for jars created with the manifest files listed below.
To create an empty jar with just a given manifest, first make sure to have an empty file in the current directory. This is because jar requires at least one input file (besides the manifest) to create a jar. Run this command to create the jar:
jar cmf manifest jar-name.jar empty
Empty manifest test
This should fail: no Cytoscape-App-Name in the manifest.
Simple app test: no version
This should fail: no Cytoscape-App-Version in the manifest.
Manifest:
Cytoscape-App-Name: blah
Simple app test: no API compatibility
This should fail: no Cytoscape-API-Compatibility in the manifest.
Manifest:
Cytoscape-App-Name: blah Cytoscape-App-Version: 1.0
Simple app test: new app
- This should succeed and require adding a new app page.
- After submission, the admin should receive an email about the submission. It should be listed in the Pending Apps page.
- Go back to the "Confirmation" page, then click "No, cancel it". It should no longer be listed in Pending Apps.
- Resubmit the app, and accept it. It should successfully create an app page.
An email from the account in conf/emails.py/EMAIL_ADDR should have been sent to the app author confirming the app.
- The new app page must have the submitter's email address listed as an editor.
Manifest:
Cytoscape-App-Name: blah Cytoscape-App-Version: 1.0 Cytoscape-API-Compatibility: 3.0
Simple app test: new release
This should succeed and not require admin approval. It should still send an email to the admin about the submission.
Manifest:
Cytoscape-App-Name: blah Cytoscape-App-Version: 2.0 Cytoscape-API-Compatibility: 3.0
Simple app test: no authorization
Submit the jar with the same manifest as above but under a different, non-admin account. Submission should be rejected.
OSGi bundle: no name
This should fail: no Bundle-Name.
Manifest:
Bundle-SymbolicName: blah
OSGi bundle: no version
This should fail: no Bundle-Version.
Manifest:
Bundle-SymbolicName: blah Bundle-Name: blah
OSGi bundle: no Cytoscape imports
This should fail: no Cytoscape packages in Import-Package.
Manifest:
Bundle-SymbolicName: blah Bundle-Name: blah Bundle-Version: 3.0 Import-Package: xyz,abc
OSGi bundle: no Cytoscape version in imports
This should fail: no Cytoscape packages in Import-Package.
Manifest:
Bundle-SymbolicName: blah Bundle-Name: blah Bundle-Version: 3.0 Import-Package: org.cytoscape.a, org.cytoscape.b
OSGi bundle: new release
This should succeed.
- The minimum Cytoscape version must be 3.5.
Manifest:
Bundle-SymbolicName: blah Bundle-Name: blah Bundle-Version: 3.0 Import-Package: org.cytoscape.a;version="(3.0,4]", org.cytoscape.b;version="(3.5,4]"
OSGi bundle: export package
This should succeed and ask for a pom and Javadocs.
Manifest:
Bundle-SymbolicName: blah Bundle-Name: blah Bundle-Version: 4.0 Import-Package: org.cytoscape.a;version="(3.0,4]", org.cytoscape.b;version="(3.5,4]" Export-Package: blah
OSGi bundle: deleted dependency
Delete an existing release. Then try to submit an app that depends on it. This should fail.
Manifest:
Bundle-SymbolicName: blah Bundle-Name: blah Bundle-Version: 3.0 Import-Package: org.cytoscape.a;version="(3.0,4]", org.cytoscape.b;version="(3.5,4]" Cytoscape-App-Dependencies: GeneMANIA;3.0.0.beta1
OSGi bundle: multiple dependencies
Submission should succeed. After submission, GeneMANIA and ClueGO must list blah as a dependency.
Manifest:
Bundle-SymbolicName: blah Bundle-Name: blah Bundle-Version: 5.0 Import-Package: org.cytoscape.a;version="(3.0,4]", org.cytoscape.b;version="(3.5,4]" Cytoscape-App-Dependencies: GeneMANIA;3.0.0.beta2, ClueGO;2.0.0
Extract list of authors for recently updated/submitted apps
Use case: producing a contact list for F1000Research channel authors
log into server: root@apps.cytoscape.org
- log into docker (if a docker instance): docker exec -it appstore_mysql_1 /bin/bash
- log into mysql: mysql -u root --password=PASSWORD cyappstore
select distinct first_name,last_name,email,release_file from apps_app_editors left join apps_release on apps_app_editors.app_id=apps_release.app_id left join auth_user on apps_app_editors.user_id=auth_user.id where apps_release.created>"2015-03-01 01:01:01";