Method createTable

src/com/odoo/orm/SQLHelper.java:40–98

(OEDBHelper db)

	}

	public List<String> createTable(OEDBHelper db) {
		Log.d(TAG, "SQLHelper->createTable()");
		List<String> queries = new ArrayList<String>();
		String table = modelToTable(db.getModelName());
		if (!mTables.contains(table)) {
			mTables.add(table);
			StringBuffer sql = new StringBuffer();
			sql.append("CREATE TABLE IF NOT EXISTS ");
			sql.append(table);
			sql.append(" (");
			for (OEColumn col : db.getModelColumns()) {
				if (col.getName().equals("id")
						|| col.getName().equals("oea_name")) {
					continue;
				}
				if (col.getType() instanceof OETypeHelper) {
					sql.append(col.getName());
					sql.append(" ");
					sql.append(((OETypeHelper) col.getType()).getType());
					sql.append(", ");
				}
				if (col.getType() instanceof OEManyToOne) {
					OEManyToOne manyToOne = (OEManyToOne) col.getType();
					List<String> many2one = createTable(manyToOne.getDBHelper());
					for (String query : many2one) {
						queries.add(query);
					}
					sql.append(col.getName());
					sql.append(" ");
					sql.append(((OETypeHelper) OEFields.integer()).getType());
					sql.append(", ");

				}
				if (col.getType() instanceof OEOneToMany) {
					OEOneToMany oneToMany = (OEOneToMany) col.getType();
					List<String> one2many = createTable(oneToMany.getDBHelper());
					for (String query : one2many) {
						queries.add(query);
					}
				}
				if (col.getType() instanceof OEManyToMany) {
					OEManyToMany manyTomany = (OEManyToMany) col.getType();
					List<String> many2many = createTable(manyTomany
							.getDBHelper());
					for (String query : many2many) {
						queries.add(query);
						queries.add(createMany2ManyRel(db.getModelName(),
								manyTomany.getDBHelper().getModelName()));
					}
				}
			}
			sql.append(defaultColumns());
			sql.deleteCharAt(sql.lastIndexOf(","));
			sql.append(");");
			queries.add(sql.toString());
			Log.d("SQLHelper", "Table created : " + table);
		}
		return queries;