shagalalab / sozlik-web Goto Github PK

So far the app had only Qaraqalpaq-English dictionary, however the android counterpart has been updated to include Russian-Qaraqalpaq dictionary.

This task is:

• Download the attached file and unzip it
• Replace the old database file with new one which has Russian-Qaraqalpaq dictionary
• One thing to notice, the table name has been changed from qqen to dictionary, do the appropriate changes in SQL queries in sozlik.py

Attachment: sozlik.db.zip

Database's table structure has been changed, previously it was:

Now it has been changed to:

As you might have noticed, two new columns have been added:

• type
• raw_word

type is a dictionary type, 1 means qq-en, 2 means ru-qq

This task is to change the word to raw_word in translation.html page. This is because in Russian-Qaraqalpaq dictionary some of the words have dividers for example like ГЛОТ//ОК. So what I've done is, original word has been put to raw_word column, while "normalized" word has been put to word column (to normalize, we remove // and change to lower case, so it will be глоток now).

At the end, you should have something similar:

As we have two dictionaries now, we need to be able to distinguish search results, i.e. to which dictionary the word belongs to. So, this task is to add flags to both main screens search suggestions and translation pages.

As you might remember from #2 we have type column which represents dictionary type, 1 means qq-en, 2 means ru-qq. So, try to put flags to search suggestions something similar to this:

And for translation page also you should show to which dictionary it belongs to:

Look at the following screenshot:

If you have noticed, we have the same words found in search results: "сезон". If you look at their url, you will notice that they are the same, like: http://sozlik.com/translate/сезон. And there is no way to find out to which dictionary it belongs to: qaraqalpaq - english or russian - qaraqalpaq. So we need to pass dictionary id to translate url, it can be something like this:

• http://sozlik.com/translate/qqen/сезон for qaraqalpaq - english
• http://sozlik.com/translate/ruqq/сезон for russian - qaraqalpaq

So, the changes required to complete the task:

1. In index.html add dictionary type to translate url
2. Change sozlik.pys get_translate method. Need to add dictionary type to @app.route, then fix SQL query to include dictionary type