Gsoc 18 Project | Collect build statistics

[Mojca Miklavec]

Dear Vishnu,

On 3 April 2018 at 23:54, Vishnu wrote:
>
> Hello
>
> I have finished the mini project given to me.
> I am now successfully able to scrape data from json into the database.
> And have integrated the database and website to display all the ports and their basic information as it was required
> All the images and files are attached.
> Please go through the link.
> https://drive.google.com/open?id=1LbMnyHjaRCbg7IrAUMM042eD7O2Br-jU

Thank you very much.

As far as I am concerned this serves ok as a demo.
(The database would ideally be filled with Django as well, but that's
ok for now.)
I don't know if other mentors have any further questions.

> On 4 April 2018 at 03:19, Vishnu wrote:
>>
>> Hello
>>
>> I have finished the mini project given to me.
>> I am successfully able to scrape data from json into the database.
>> And have integrated the database and website to display all the ports and their basic information as it was required
>> All the images and files are attached.
>>
>> My last 3 mails got rejected due to large size.
>> Hence uploaded all the images as attachment..

You can see which emails reached the mailing list by looking at
    https://lists.macports.org/pipermail/macports-dev/2018-April/thread.html

I'm not absolutely sure, but I think this email did not reach others
either because the images were still present inline (in quoted
messages) when you hit the "reply to" button and thus the email size
was still prohibitively large.

In the future try not to send anything but trivial/small text
attachments (or super small images like a logotype), any screenshots
should better go to some other place where only those interested in
the topic will go to check them out, while hundreds of other
subscribers to the mailing list would not get their mailboxes filled.

Mojca



>> On 4 April 2018 at 03:06, Vishnu <vishnum1998 at gmail.com> wrote:
>>>
>>> In the last mail it was working but by taking portid from url.
>>>
>>> Now i created my custom view which will take the text after "port/" and search it in port table and return all its properties.
>>>
>>> Please look at the url.This is what our final result would want.
>>>
>>> Thanks
>>>
>>>
>>> On 4 April 2018 at 02:06, Vishnu <vishnum1998 at gmail.com> wrote:
>>>>
>>>> Hello
>>>>
>>>> I have succesfully integrated django & sqlite3 .
>>>> Also am able to display the content on web.
>>>> Following Screenshots will explain :
>>>>
>>>>
>>>>
>>>> Databse :
>>>>
>>>>
>>>>
>>>> Is my progress fine?
>>>>
>>>> I think this would be enough as my proof of skill.
>>>>
>>>> Thanks
>>>>
>>>>
>>>>
>>>> On 4 April 2018 at 01:12, Vishnu <vishnum1998 at gmail.com> wrote:
>>>>>
>>>>> Hello
>>>>>
>>>>>
>>>>> Yes that's what I have been doing.
>>>>> Its almost ready.. Now integrating it with my front-end website.so that table is updated automatically.
>>>>> Will be mailing you very soon. All the screenshots.
>>>>>
>>>>> On Wed, Apr 4, 2018, 1:05 AM Mojca Miklavec <mojca at macports.org> wrote:
>>>>>>
>>>>>> Dear Vishnu,
>>>>>>
>>>>>> On 3 April 2018 at 20:10, Vishnu wrote:
>>>>>> >
>>>>>> > Hello
>>>>>> >
>>>>>> > Yes portindex.json is very useful.
>>>>>> >
>>>>>> > I tried my hands with python and sql.
>>>>>> > And am successfully able to parse the json and store the data into the table .
>>>>>>
>>>>>> Thank you very much. The initial steps look promising.
>>>>>>
>>>>>> Now, try to integrate this into a simple django app with the database
>>>>>> abstraction layer. A simple tutorial is here to demonstrate how to
>>>>>> define simple python classes that automatically interoperate with
>>>>>> database (so no need to write direct sql code at this step):
>>>>>>     https://docs.djangoproject.com/en/2.0/intro/tutorial01/
>>>>>>
>>>>>> Using SQLite is fine (for the production we would probably want to go
>>>>>> for PostgreSQL, but now it doesn't make any difference).
>>>>>>
>>>>>> Mojca