'boolean', 'date', 'time', 'datetime', 'enum', 'interval', 'pickletype', 'schematype',

'numeric', 'float', 'biginteger', 'smallinteger', 'smallint', 'string', 'bigint','int','integer',

'text', 'unicode', 'unicodetext', 'binary', 'largebinary', 'blob'

# This lists the commands used by the db_tools.py.

print '\nThe general usage pattern of the tool is python box.py [options] [extra parameters]\n'

print 'The following are the available options:\n'

print ' --initiate or -i : Generates a new controller handler. You should specify a controller name and the name should not be a number.'

print '\t\t\t The pattern is python box.py -i [controller name]'

print ' --create or -c : Create the database for the first usage. Only use this if you want to create the database for the first time'

print ' --migrate or -m : Create the migration script for migration process'

print ' --upgrade or -u : Upgrade the database to the latest migration version'

print ' --downgrade or -d : Downgrade the database to the previous migration version.'

print '\t\t\t To downgrade to a specific version use python box.py -d [version number]'

print '--version or -v\t\t : Check current database version.'

print ' --new or -n : Create new data model.'

print '\t\t\t The pattern is box.py -n [model name] [<field name>:<field type>--<field length (if applicable. otherwise, default will be used)>]'

print '\t\t\t For more documentation please see http://docs.sqlalchemy.org/en/rel_0_7/core/types.html#types-generic'

print ' --add or -a : Install a new python package.'

print '\t\t\t The pattern is python box.py -a [package name]'

print ' --help or -h : Display the help file'

print ' --serve or -s : Run The Tornado Web Server'

print ' --gserve or -g : Run The Gunicorn Web Server. You can add your own gunicorn options aside from bind address and port'

print ' --testrun or -t : Run The Development Server'

# This creates the new database.

db.create_all()

# If no repo existed, the creation will prepare for the first migration.

if not os.path.exists(SQLALCHEMY_MIGRATE_REPO):

api.create(SQLALCHEMY_MIGRATE_REPO, 'database repository')

api.version_control(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO)

print '\nDatabase creation completed\n'

else:

# This is used for database migration. Newly created database should go through this as well.

migration = SQLALCHEMY_MIGRATE_REPO + '/versions/%03d_migration.py' % (api.db_version(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO) + 1)

tmp_module = imp.new_module('old_model')

old_model = api.create_model(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO)

exec old_model in tmp_module.__dict__

script = api.make_update_script_for_model(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO, tmp_module.meta, db.metadata)

open(migration, "wt").write(script)

api.upgrade(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO)

print 'New migration saved as ' + migration

# This is used for database migration upgrade.

api.upgrade(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO)

print 'Database upgrade completed!'

# This is used to downgrade the database schema to a certain version or to one version before.

# If you know exactly the version you wish to use then you can directly downgrade to that version.

if not version:

current_version = api.db_version(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO)

downgrade_version = current_version - 1

else:

downgrade_version = version

api.downgrade(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO, downgrade_version)

print 'Database downgrade completed!'

# This is used to add model to the model file.

# Get the current model file and open it for writing.

model_path = os.path.join(BASEDIR, "app/models/" + model_name.lower() + ".py")

init_path = os.path.join(BASEDIR, "app/models/__init__.py")

model_file = open(model_path, 'w')

# Write the class definition.

model_file.write('from app import db\n\n')

model_file.write('class ' + model_name.title() + '(db.Model):\n')

model_file.write(spc+'id = db.Column(db.Integer, primary_key=True)\n')

## Add the model fields.

### First check for the data types and standardize it.

for component in model_components:

in_type = component['field_property'][0].lower()

### The database field type based on http://docs.sqlalchemy.org/en/rel_0_7/core/types.html#types-generic.

if in_type == 'biginteger' or in_type == 'bigint':

data_type = 'BigInteger'

elif in_type=='int' or in_type=='integer':

data_type = 'Integer'

elif in_type == 'boolean':

data_type = 'Boolean'

elif in_type == 'date':

data_type = 'Date'

elif in_type == 'datetime':

data_type = 'DateTime'

elif in_type == 'enum':

data_type = 'Enum'

elif in_type == 'float':

data_type = 'Float'

elif in_type == 'interval':

data_type = 'Interval'

elif in_type == 'largebinary':

data_type = 'LargeBinary'

elif in_type == 'numeric':

data_type = 'Numeric'

elif in_type == 'pickletype':

data_type = 'PickleType'

elif in_type == 'schematype':

data_type = 'SchemaType'

elif in_type == 'smallinteger' or in_type == 'smallint':

data_type = 'SmallInteger'

elif in_type == 'string':

data_type = 'String'

elif in_type == 'text':

data_type = 'Text'

elif in_type == 'time':

data_type = 'Time'

elif in_type == 'unicode':

data_type = 'Unicode'

elif in_type == 'unicodetext':

data_type = 'UnicodeText'

elif in_type == 'binary':

data_type = 'Binary'

elif in_type == 'blob':

data_type = 'BLOB'

else:

### If the data type did not match any of the existing data types, display error message and quit the program.

print 'Data type ' + component['field_property'][0] + ' not found. Please refer to SQLAlchemy documentation for valid data types.'

sys.exit()

### If it matches write the model fields into the model files.

if len(component['field_property']) == 2:

model_file.write(spc + component['field_name'].lower() + ' = db.Column(db.' + data_type + '(' + component['field_property'][1] + '))\n')

else:

model_file.write(spc + component['field_name'].lower() + ' = db.Column(db.' + data_type + ')\n')

## Create the class method for data transfer object (dto) for JSON representation.

model_file.write('\n')

model_file.write(spc + '# data transfer object to form JSON\n')

model_file.write(spc + 'def dto(self):\n')

model_file.write(spc + spc + 'return dict(\n')

### Add the json component for all fields.

mod_counter = 1

model_file.write(spc+spc+spc+'id = self.id,\n')

max_mod_index = len(model_components)

for component in model_components:

if mod_counter != max_mod_index:

model_file.write(spc + spc + spc + component['field_name'].lower() + ' = self.' + component['field_name'].lower() + ',\n')

else:

model_file.write(spc + spc + spc + component['field_name'].lower() + ' = self.' + component['field_name'].lower() + ')\n')

mod_counter = mod_counter + 1

model_file.close()

init_file = open(init_path, 'a')

init_file.write("from "+ model_name.lower() + " import " + model_name.title()+"\n")

init_file.close()

print '\n...........\n'

#add the CRUD controllers

generate_controller(model_name, model_components)

generate_index_template(model_name, model_components)

generate_controller_template(model_name, model_components)

generate_edit_template(model_name, model_components)

generate_view_template(model_name, model_components)

# perform the database creation and migration.

# this will be based on the state of the database.

if not os.path.exists(SQLALCHEMY_MIGRATE_REPO):

db_create()

db_migrate()

model_name = model_name.lower()

db_model_name = model_name.title()

mod_counter = 1

max_mod_index = len(model_components)

controller_path = os.path.join(BASEDIR, 'app/controllers/'+model_name+'.py')

controller_file = open(controller_path,'w')

controller_file.write("from flask import Blueprint\n")

controller_file.write("from flask import render_template\n")

controller_file.write("from flask import json\n")

controller_file.write("from flask import session\n")

controller_file.write("from flask import url_for\n")

controller_file.write("from flask import redirect\n")

controller_file.write("from flask import request\n")

controller_file.write("from flask import abort\n")

controller_file.write("from flask import Response\n\n")

controller_file.write("from app import db\n\n")

# import related models

controller_file.write("from app.models import " + db_model_name +"\n\n")

# create blueprint

controller_file.write(model_name+"_view = Blueprint('"+model_name+"_view', __name__)\n\n")

controller_file.write("########### " + model_name + " REST controller ###########\n\n")

controller_file.write("@"+model_name+"_view.route('/" + model_name + "/',methods=['GET','POST'],defaults={'id':None})\n")

controller_file.write("@"+model_name+"_view.route('/" + model_name + "/<id>',methods=['GET','PUT','DELETE'])\n")

controller_file.write("def " + model_name + "_controller(id):\n")

for component in model_components:

controller_file.write(spc + component['field_name'].lower() + " = request.values.get('" + component['field_name'].lower() + "')\n")

controller_file.write("\n"+ spc +"if id:\n")

controller_file.write(spc + spc + "if request.method == 'GET':\n")

controller_file.write(spc + spc + spc + model_name+" = "+model_name.title()+".query.get(id)\n")

controller_file.write(spc + spc + spc+ "if "+model_name+":\n")

controller_file.write(spc + spc + spc + spc + model_name+" = "+model_name+".dto()\n")

controller_file.write(spc + spc + spc + "if request.values.get('json'):\n")

controller_file.write(spc + spc + spc + spc +"return json.dumps(dict("+model_name+"="+model_name+"))\n")

controller_file.write(spc + spc + spc + "else:\n")

controller_file.write(spc + spc + spc + spc + "return render_template('"+model_name+"_view.html', "+model_name+" = "+model_name+")\n")

controller_file.write(spc + spc + "elif request.method == 'PUT':\n")

controller_file.write(spc + spc + spc + model_name + "_item = " + model_name.title() + ".query.get(id)\n")

for component in model_components:

controller_file.write(spc + spc + spc + model_name + "_item." + component['field_name'].lower() + " = " + component['field_name'].lower() + "\n")

controller_file.write(spc + spc + spc + "db.session.add(" + model_name + "_item)\n")

controller_file.write(spc + spc + spc + "db.session.commit()\n")

controller_file.write(spc + spc + spc + "return 'updated'\n")

controller_file.write(spc + spc + "elif request.method == 'DELETE':\n")

controller_file.write(spc + spc + spc + model_name + "_item = " + model_name.title() + ".query.get(id)\n")

controller_file.write(spc + spc + spc + "db.session.delete(" + model_name + "_item)\n")

controller_file.write(spc + spc + spc + "db.session.commit()\n")

controller_file.write(spc + spc + spc + "return 'deleted'\n")

controller_file.write(spc + spc + "else:\n")

controller_file.write(spc + spc + spc +"return 'Method Not Allowed'\n")

controller_file.write(spc + "else:\n")

controller_file.write(spc + spc + "if request.method == 'GET':\n")

controller_file.write(spc + spc + spc + model_name + "_list = "+model_name.title()+".query.all()\n")

controller_file.write(spc + spc + spc + "if " + model_name + "_list:\n")

controller_file.write(spc + spc + spc + spc + "entries = [" + model_name + ".dto() for " + model_name + " in " + model_name + "_list]\n")

controller_file.write(spc + spc + spc + "else:\n")

controller_file.write(spc + spc + spc + spc + "entries=None\n")

controller_file.write(spc + spc + spc + "if request.values.get('json'):\n")

controller_file.write(spc + spc + spc + spc + "return json.dumps(dict("+model_name+"=entries))\n")

controller_file.write(spc + spc + spc + "else:\n")

controller_file.write(spc + spc + spc + spc + "return render_template('" + model_name + ".html'," + model_name + "_entries = entries, title = \"" + model_name.title() + " List\")\n")

controller_file.write(spc + spc + "elif request.method == 'POST':\n")

controller_file.write(spc + spc + spc + "new_"+model_name+" = "+model_name.title()+"(\n")

for component in model_components:

if mod_counter != max_mod_index:

controller_file.write(spc + spc + spc + spc + spc + spc + spc + component['field_name'].lower() + ' = ' + component['field_name'].lower() + ',\n')

else:

controller_file.write(spc + spc + spc + spc + spc + spc + spc + component['field_name'].lower() + ' = ' + component['field_name'].lower() + '\n')

mod_counter = mod_counter + 1

controller_file.write(spc + spc + spc + spc + spc + spc + spc + ")\n\n")

controller_file.write(spc + spc + spc + "db.session.add(new_" + model_name + ")\n")

controller_file.write(spc + spc + spc + "db.session.commit()\n")

controller_file.write(spc + spc + spc + "if request.values.get('json'):\n")

controller_file.write(spc + spc + spc + spc + "url = '/"+model_name+"/json=true'\n")

controller_file.write(spc + spc + spc + "else:\n")

controller_file.write(spc + spc + spc + spc + "url = '/"+model_name+"/'\n")

controller_file.write(spc + spc + spc + "return redirect(url)\n")

controller_file.write(spc + spc + "else:\n")

controller_file.write(spc + spc + spc + "return 'Method Not Allowed'\n\n")

controller_file.close()

main_path = os.path.join(BASEDIR, 'app/main.py')

read_main_file = open(main_path, 'r')

original_lines = read_main_file.readlines()

## import the blueprint file

original_lines[2] = original_lines[2].strip()

original_lines[2] = original_lines[2] + ', ' + model_name + '_view\n'

main_file = open(main_path, 'w')

for lines in original_lines:

main_file.write(lines)

main_file.close()

main_file = open(main_path,'a')

main_file.write("\napp.register_blueprint(" + model_name + "_view)")

main_file.close()

init_path = os.path.join(BASEDIR, 'app/controllers/__init__.py')

init_file = open(init_path, 'a')

init_file.write("\nfrom "+ model_name + " import "+model_name+ "_view")

init_file.close()

model_name = model_name.lower()

template_path = os.path.join(BASEDIR, 'app/templates/' + model_name + '.html')

template_file = open(template_path, 'w')

template_file.write("{% extends \"base.html\" %}\n")

template_file.write("{% block content %}\n")

template_file.write("\t\t<h1>List of " + model_name.title() + " Entries.</h1>\n")

template_file.write("\t\t<table id=\"list-view\">\n")

template_file.write("\t\t\t<thead>\n")

template_file.write("\t\t\t\t<tr>\n")

template_file.write("\t\t\t\t\t<td><b>ID</td>\n")

for component in model_components:

template_file.write("\t\t\t\t\t<td><b>" + component['field_name'].title() + "</b></td>\n")

template_file.write("\t\t\t\t\t<td><b> </td>\n")

template_file.write("\t\t\t\t\t<td><b> </td>\n")

template_file.write("\t\t\t\t</tr>\n")

template_file.write("\t\t\t</thead>\n")

template_file.write("\t\t\t{% if " + model_name + "_entries %}\n")

template_file.write("\t\t\t<tbody>\n")

template_file.write("\t\t\t{% for entry in " + model_name + "_entries %}\n")

template_file.write("\t\t\t\t<tr>\n")

template_file.write("\t\t\t\t\t<td><a href=\"/"+model_name+"/{{ entry.id }}\">{{ entry.id }}</a></td>\n")

for component in model_components:

template_file.write("\t\t\t\t\t<td>{{ entry." + component['field_name'] + " }}</td>\n")

template_file.write('\t\t\t\t\t<td><a href="/' + model_name + '/edit/{{ entry.id }}">Edit</a></td>\n')

template_file.write('\t\t\t\t\t<td><a id="delete-link" data-callback="/' + model_name + '/" data-url="/' + model_name + '/{{ entry.id }}">Delete</a></td>\n')

template_file.write("\t\t\t\t</tr>\n")

template_file.write("\t\t\t{% endfor %}\n")

template_file.write("\t\t\t</tbody>\n")

template_file.write("\t\t</table>\n")

template_file.write("\t\t\t{% else %}\n")

template_file.write("\t\t</table>\n")

template_file.write("\t\tYou have no entries yet\n")

template_file.write("\t\t\t{% endif %}\n")

template_file.write('\t\t\t<br/><br/><b><a id="actions" href="/' + model_name + '/add">Add new entry</a></b>\n')

template_file.write("{% endblock %}\n")

model_name = model_name.lower()

template_path = os.path.join(BASEDIR, 'app/templates/' + model_name + '_view.html')

template_file = open(template_path, 'w')

template_file.write("{% extends \"base.html\" %}\n")

template_file.write("{% block content %}\n")

template_file.write("\t\t<h1>View " + model_name.title() + " single entry.</h1>\n")

template_file.write("\t\t<table>\n")

for component in model_components:

template_file.write("\t\t\t\t<tr>\n")

template_file.write("\t\t\t\t\t<td>" + component['field_name'].title() + ":</td>\n")

template_file.write("\t\t\t\t\t<td>{{ " + model_name + "." + component['field_name'].lower() + " }}</td>\n")

template_file.write("\t\t\t\t</tr>\n")

template_file.write("\t\t</table>\n")

template_file.write("{% endblock %}")

model_name = model_name.lower()

controller_path = os.path.join(BASEDIR, 'app/controllers/'+model_name+'.py')

template_path = os.path.join(BASEDIR, 'app/templates/' + model_name + '_edit.html')

controller_file = open(controller_path, 'a')

controller_file.write("@"+model_name+"_view.route('/" + model_name + "/edit/<id>')\n")

controller_file.write("def " + model_name + "_edit_controller(id):\n")

controller_file.write(spc + "#this is the controller to edit model entries\n")

controller_file.write(spc + model_name + "_item = " + model_name.title() + ".query.get(id)\n")

controller_file.write(spc + "return render_template('" + model_name + "_edit.html', " + model_name + "_item = " + model_name + "_item, title = \"Edit Entries\")\n\n")

template_file = open(template_path, 'w')

template_file.write("{% extends \"base.html\" %}\n")

template_file.write("{% block content %}\n")

template_file.write("\t\t<h1>Edit " + model_name.title() + " Entries.</h1>\n")

template_file.write("\t\t<form id=\"edit-form\" name=\"" + model_name + "_add\" method=\"put\" action=\"/" + model_name + "/{{ " + model_name + "_item.id }}\">\n")

template_file.write("\t\t<input type=\"hidden\" id=\"url\" value=\"/"+model_name+"/{{ " + model_name + "_item.id }}\">\n")

template_file.write("\t\t<table>\n")

for component in model_components:

template_file.write("\t\t\t\t<tr>\n")

template_file.write("\t\t\t\t\t<td>" + component['field_name'].title() + ":</td>\n")

template_file.write("\t\t\t\t\t<td><input type=\"text\" name=\"" + component['field_name'].lower() + "\" value=\"{{ " + model_name + "_item." + component['field_name'].lower() + " }}\"/></td>\n")

template_file.write("\t\t\t\t</tr>\n")

template_file.write("\t\t\t\t<tr>\n")

template_file.write("\t\t\t\t\t<td><input id=\"submit-put\" type=\"submit\" name=\"submit\" value=\"Edit Entry\"/></td>\n")

template_file.write("\t\t\t\t\t<td> </td>\n")

template_file.write("\t\t\t\t</tr>\n")

template_file.write("\t\t</table>\n")

template_file.write("\t\t</form>\n")

template_file.write("{% endblock %}")

model_name = model_name.lower()

controller_path = os.path.join(BASEDIR, 'app/controllers/'+model_name+'.py')

template_path = os.path.join(BASEDIR, 'app/templates/' + model_name + '_add.html')

controller_file = open(controller_path, 'a')

controller_file.write("@"+model_name+"_view.route('/" + model_name + "/add/')\n")

controller_file.write("def " + model_name + "_add_controller():\n")

controller_file.write(spc + "#this is the controller to add new model entries\n")

controller_file.write(spc + "return render_template('" + model_name + "_add.html', title = \"Add New Entry\")\n\n")

template_file = open(template_path, 'w')

template_file.write("{% extends \"base.html\" %}\n")

template_file.write("{% block content %}\n")

template_file.write("\t\t<h1>Add new " + model_name.title() + " Entries.</h1>\n")

template_file.write("\t\t<form name=\"" + model_name + "_add\" method=\"post\" action=\"/" + model_name + "/\">\n")

template_file.write("\t\t<table>\n")

for component in model_components:

template_file.write("\t\t\t\t<tr>\n")

template_file.write("\t\t\t\t\t<td>" + component['field_name'].title() + ":</td>\n")

template_file.write("\t\t\t\t\t<td><input type=\"text\" name=\"" + component['field_name'].lower() + "\"/></td>\n")

template_file.write("\t\t\t\t</tr>\n")

template_file.write("\t\t\t\t<tr>\n")

template_file.write("\t\t\t\t\t<td><input type=\"submit\" name=\"submit\" value=\"Add Entry\"/></td>\n")

template_file.write("\t\t\t\t\t<td> </td>\n")

template_file.write("\t\t\t\t</tr>\n")

template_file.write("\t\t</table>\n")

template_file.write("\t\t</form>\n")

template_file.write("{% endblock %}")

controller_name = controller_name.lower()

controller_name = controller_name.replace(' ', '_')

controller_name = controller_name.replace('\'', '_')

controller_name = controller_name.replace('.', '_')

controller_name = controller_name.replace(',', '_')

controller_path = os.path.join(BASEDIR, "app/controllers/" + controller_name + ".py")

view_path = os.path.join(BASEDIR, "app/templates/" + controller_name + ".html")

controller_file = open(controller_path, 'w')

controller_file.write("from flask import Blueprint\n")

controller_file.write("from flask import render_template\n")

controller_file.write("from flask import json\n")

controller_file.write("from flask import session\n")

controller_file.write("from flask import url_for\n")

controller_file.write("from flask import redirect\n")

controller_file.write("from flask import request\n")

controller_file.write("from flask import abort\n")

controller_file.write("from flask import Response\n\n")

controller_file.write("from app import db\n\n")

controller_file.write(controller_name + "_view = Blueprint('" + controller_name + "_view', __name__)\n\n")

controller_file.write("@" + controller_name + "_view.route('/" + controller_name + "/') #Link\n")

controller_file.write("def " + controller_name + "_control():\n")

controller_file.write("\t# add your controller here\n")

controller_file.write("\treturn render_template('" + controller_name + ".html')\n")

controller_file.close()

main_path = os.path.join(BASEDIR, 'app/main.py')

read_main_file = open(main_path, 'r')

original_lines = read_main_file.readlines()

## import the blueprint file

original_lines[2] = original_lines[2].strip()

original_lines[2] = original_lines[2] + ', ' + controller_name + '_view\n'

main_path = os.path.join(BASEDIR, 'app/main.py')

main_file = open(main_path, 'w')

for lines in original_lines:

main_file.write(lines)

main_file.close()

main_file = open(main_path,'a')

main_file.write("\napp.register_blueprint(" + controller_name + "_view)")

main_file.close()

init_path = os.path.join(BASEDIR, 'app/controllers/__init__.py')

init_file = open(init_path, 'a')

init_file.write("\nfrom "+ controller_name + " import " + controller_name + "_view")

init_file.close()

print '\nController generated\n'

view_file = open(view_path, 'a')

view_file.write("{% extends \"base.html\" %}\n")

view_file.write("{% block content %}\n")

view_file.write('\t\t<h1>The ' + controller_name.lower() + ' view.</h1>\n')

view_file.write('\t\t<p>You can change this view in ' + view_path + '</p>\n')

view_file.write("{% endblock %}")

# this is used to get the latest version in the database

current_version = api.db_version(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO)

if not package_name:

print "You need to specify a valid package name"

else:

current_platform = platform.system()

bin_base = ''

if current_platform == 'Windows':

bin_base = 'box\Scripts\pip'

else:

bin_base = 'box/bin/pip'

current_platform = platform.system()

bin_base = ''

if current_platform == 'Windows':

bin_base = 'box\Scripts\python'

else:

bin_base = 'box/bin/python'

current_platform = platform.system()

bin_base = ''

if current_platform == 'Windows':

bin_base = 'box\Scripts\python'

else:

bin_base = 'box/bin/python'

current_platform = platform.system()

if current_platform == 'Windows':

bin_base = 'box\Scripts\gunicorn'

else:

bin_base = 'box/bin/gunicorn'

option_list = [bin_base,'-b','0.0.0.0:'+str(SERVER_PORT),'greeny:app']

try:

restart_gunicorn()

if arguments:

for item in arguments:

option_list.append(item)

call(option_list)

else:

call([bin_base,'-b','0.0.0.0:'+str(SERVER_PORT),'-w','4','-k','tornado','greeny:app','--daemon'])

except:

if arguments:

for item in arguments:

option_list.append(item)

call(option_list)

else:

proc = Popen(['ps','aux'], stdout=PIPE)

output=proc.communicate()[0].split('\n')

processes = output[2:]

ids = []

for item in processes:

if re.search('gunicorn',item):

values=[]

strings = item.split(" ")

for x in strings:

if x != "":

values.append(x)

ids.append(values[1])

ids.sort()