Re: mysqlclient installation error

2019-06-11 Thread Raja Sekar Sampath
Hi Emmanuel Simeon,

It would be great if you share the download link to Visual Build Tools
and MySQL
C++ Connector


On Tue, 11 Jun 2019 at 21:36, Emmanuel Simeon  wrote:

> Had same issue setting up my current Project,
>
> But my workaround after so much effort was this:
>
> 1. Install Visual Build Tools
>
> 2. Install the Required  MySQL C++ Connector (Better still download MySQL
> Setup with Workbench and install not Xampp or Wamp)
>
> 3. Uninstall Python and use the Web Installer to Install Python 3 again,
>
> Those are essentially the steps i took to get my working.
>
> On Tue, Jun 11, 2019 at 4:42 PM Raja Sekar Sampath 
> wrote:
>
>> Hi Deepak,
>>
>> Thanks for reply.,
>>
>> Is there any alternative for that ?
>>
>> I didn't want to downgrade the django
>>
>> On Tuesday, 11 June 2019 21:02:23 UTC+5:30, Desh Deepak wrote:
>>>
>>> Hi,
>>> MySQL client is not available for Django 2.2 and newer version.
>>> You can uninstall 2.2 and download older Django version 2.0 for the
>>> database connection.
>>>
>>>
>>> Thanks
>>> Desh Deepak
>>> +917011101001
>>>
>>> On Tue, 11 Jun 2019, 19:37 Raja Sekar Sampath, 
>>> wrote:
>>>
>>>> Hi Guys,
>>>>
>>>> While installing mysqlclient using pip, getting this error
>>>>
>>>> VS C++ Build tool was installed in system and updated the setup tools,
>>>> still getting this issue..
>>>> Any solution for this ?
>>>>
>>>> My Environment :
>>>>
>>>> OS : Windows 10
>>>> Python : 3.7
>>>> Django : 2.2
>>>> DB : MariaDB 10.2
>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Django users" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to django...@googlegroups.com.
>>>> To post to this group, send email to django...@googlegroups.com.
>>>> Visit this group at https://groups.google.com/group/django-users.
>>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msgid/django-users/19576386-dd91-4e29-9fce-762a60461368%40googlegroups.com
>>>> <https://groups.google.com/d/msgid/django-users/19576386-dd91-4e29-9fce-762a60461368%40googlegroups.com?utm_medium=email_source=footer>
>>>> .
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>> --
>> You received this message because you are subscribed to the Google Groups
>> "Django users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to django-users+unsubscr...@googlegroups.com.
>> To post to this group, send email to django-users@googlegroups.com.
>> Visit this group at https://groups.google.com/group/django-users.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/django-users/6c3132c0-8427-4a6a-b36c-acb10875b567%40googlegroups.com
>> <https://groups.google.com/d/msgid/django-users/6c3132c0-8427-4a6a-b36c-acb10875b567%40googlegroups.com?utm_medium=email_source=footer>
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
> --
>
> |Simeon Emmanuel |
>
> |Google Student Alumni, Sub Saharan Africa |
>
> |Federal University of Technology, Minna.|
>
> |Cyber Security Science Department|
>
> |emmasime...@gmail.com |
>
> |+234 (0) 8058220157|
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To post to this group, send email to django-users@googlegroups.com.
> Visit this group at https://groups.google.com/group/django-users.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/CAAEK5eXDJy_4BN%3DqobkxT2AoJn3O1LfGST1%3DUxS2LkN62iVgFw%40mail.gmail.com
> <https://groups.google.com/d/msgid/django-users/CAAEK5eXDJy_4BN%3DqobkxT2AoJn3O1LfGST1%3DUxS2LkN62iVgFw%40mail.gmail.com?utm_medium=email_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>


-- 
"Making a million friends is not a miracle, the miracle is to make a friend
who will stand by you when a million are against you. "



Have a Smileness Day
With A Smile
Rs.

e-mail: apkra...@gmail.com
Web: https://apkrajar.wordpress.com

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CAAS5AE7%3D1s74_SxmmWArYf1puf9gPHNi4hnrSdNQuB5ewQ3TtA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


mysqlclient installation error

2019-06-11 Thread Raja Sekar Sampath
Hi Guys,

While installing mysqlclient using pip, getting this error

VS C++ Build tool was installed in system and updated the setup tools, 
still getting this issue..
Any solution for this ?

My Environment :

OS : Windows 10
Python : 3.7
Django : 2.2
DB : MariaDB 10.2

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/19576386-dd91-4e29-9fce-762a60461368%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: mysqlclient installation error

2019-06-11 Thread Raja Sekar Sampath
Hi Deepak,

Thanks for reply.,

Is there any alternative for that ?

I didn't want to downgrade the django 

On Tuesday, 11 June 2019 21:02:23 UTC+5:30, Desh Deepak wrote:
>
> Hi, 
> MySQL client is not available for Django 2.2 and newer version.
> You can uninstall 2.2 and download older Django version 2.0 for the 
> database connection.
>
>
> Thanks 
> Desh Deepak
> +917011101001
>
> On Tue, 11 Jun 2019, 19:37 Raja Sekar Sampath,  > wrote:
>
>> Hi Guys,
>>
>> While installing mysqlclient using pip, getting this error
>>
>> VS C++ Build tool was installed in system and updated the setup tools, 
>> still getting this issue..
>> Any solution for this ?
>>
>> My Environment :
>>
>> OS : Windows 10
>> Python : 3.7
>> Django : 2.2
>> DB : MariaDB 10.2
>>
>> -- 
>> You received this message because you are subscribed to the Google Groups 
>> "Django users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to django...@googlegroups.com .
>> To post to this group, send email to django...@googlegroups.com 
>> .
>> Visit this group at https://groups.google.com/group/django-users.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/django-users/19576386-dd91-4e29-9fce-762a60461368%40googlegroups.com
>>  
>> <https://groups.google.com/d/msgid/django-users/19576386-dd91-4e29-9fce-762a60461368%40googlegroups.com?utm_medium=email_source=footer>
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/6c3132c0-8427-4a6a-b36c-acb10875b567%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Minimum Hardware requirement - reg

2019-06-25 Thread Raja Sekar Sampath
Hi,

What are the facts to be considered while determine the server
configuration for a Django Application?

My Client preferring self hosting, the project having 8 different (apps)
modules and we expect 20 to 30 users concurrently login into the system and
Its having automated cron jobs

Thanks & Regards,
Raja Sekar Sampath

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CAAS5AE6rKGG1Z4LL2SRzQ9X-OE6-HACY41iFrj1qxjRuhU_hxQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


Re: Minimum Hardware requirement - reg

2019-06-28 Thread Raja Sekar Sampath
Thanks to all for the valuable reply

On Wed, 26 Jun 2019 at 08:57, Aldian Fazrihady  wrote:

> Can you convince your client to use clouds instead of self hosting?
> Cloud such as AWS or GCP is easily scriptable, allowing to create
> critical/important automation scripts.
>
> Regards,
>
> Aldian Fazrihady
>
> On Wed, Jun 26, 2019 at 1:19 AM Raja Sekar Sampath 
> wrote:
>
>> Hi,
>>
>> What are the facts to be considered while determine the server
>> configuration for a Django Application?
>>
>> My Client preferring self hosting, the project having 8 different (apps)
>> modules and we expect 20 to 30 users concurrently login into the system and
>> Its having automated cron jobs
>>
>> Thanks & Regards,
>> Raja Sekar Sampath
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Django users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to django-users+unsubscr...@googlegroups.com.
>> To post to this group, send email to django-users@googlegroups.com.
>> Visit this group at https://groups.google.com/group/django-users.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/django-users/CAAS5AE6rKGG1Z4LL2SRzQ9X-OE6-HACY41iFrj1qxjRuhU_hxQ%40mail.gmail.com
>> <https://groups.google.com/d/msgid/django-users/CAAS5AE6rKGG1Z4LL2SRzQ9X-OE6-HACY41iFrj1qxjRuhU_hxQ%40mail.gmail.com?utm_medium=email_source=footer>
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To post to this group, send email to django-users@googlegroups.com.
> Visit this group at https://groups.google.com/group/django-users.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/CAN7EoAZ_XjXHd%2BJ-Gdd1rNOS4HaTQwZLAVar%3DjfT0kZWB4pSyQ%40mail.gmail.com
> <https://groups.google.com/d/msgid/django-users/CAN7EoAZ_XjXHd%2BJ-Gdd1rNOS4HaTQwZLAVar%3DjfT0kZWB4pSyQ%40mail.gmail.com?utm_medium=email_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>


-- 
"Making a million friends is not a miracle, the miracle is to make a friend
who will stand by you when a million are against you. "



Have a Smileness Day
With A Smile
Rs.

e-mail: apkra...@gmail.com
Web: https://apkrajar.wordpress.com

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CAAS5AE7P2k8ApOxzaFawHG4Fyj2_T6rGrAaV%2B479jMKTKm9eEA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


Re: django print all record in the cmd but display the last one on template

2019-10-11 Thread Raja Sekar Sampath
Hi,

Convert the variable IPD into an array or render result variable on template

On Fri, 11 Oct 2019 at 12:04, leb dev  wrote:

> i have a function that retrieve data from sql server database where i am
> using **fetchall()** then  for loop
> the retrieved data are all printed on the **cmd console** but when i tried
> to display these result on the template it **only display the last record**.
>
> views.py
> 
> def search(request):
>
>   query = cursor.execute('Select id, fullname from person')
>   result = query.fetchall()
>   for row in result:
> print("ID==>",id)
> IPD=row[0]
>   return render(request,"test.html",{"IPD":IPD})
>
> test.html
> 
>
>   {{ IPD }}
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/68025e0a-81cf-4e62-bd15-14e2006e0157%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/68025e0a-81cf-4e62-bd15-14e2006e0157%40googlegroups.com?utm_medium=email_source=footer>
> .
>


-- 
Thanks & Regards,

Raja Sekar Sampath
+91 9087434567.

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CAAS5AE6gvtL%2Br5G6Oj2-FW9vUFY3C6PLA31MJ_mGewABNTJ0pg%40mail.gmail.com.


[no subject]

2019-10-08 Thread Raja Sekar Sampath
Hi,

I'm facing challenges to get the result of below problem,I have two models
in my application i.e.,


class UserMenu(models.Model):
name = models.CharField(max_length=50)

def __str__(self):
return self.name


class MenuMapping(models.Model):

user_menu = models.ManyToManyField(UserMenu, verbose_name='Menu')
user_group = models.ForeignKey(Group, related_name='user_group',
verbose_name='Department', on_delete=models.SET_NULL, null=True) # refers -
auth.group which is linked with users


def __str__(self):
return self.user_group.name



Now I want to get the list of UserMenu mapped with the user_group of logged
in user.

I could not able to get expected result with prefetch_related or
select_related,

Can anybody help ??

-- 
Thanks & Regards,

Raja Sekar Sampath
+91 9087434567.

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CAAS5AE5yjCtcdGOgx0sGhUBpWXkrCfCirTanqYaDddXzmRbp9Q%40mail.gmail.com.