Try this i am not so sure though but trying isn't bad...kindly give me the
feedback after trying
from django.apps import apps
from django.db import connection, models
from rest_framework.response import Response
from rest_framework.views import APIView
FIELD_TYPE_MAPPING = {
'char': models.CharField,
'integer': models.IntegerField,
'boolean': models.BooleanField,
'email': models.EmailField,
# Add more field types here if needed
}
class CreateTableAPIView(APIView):
def post(self, request):
serializer = CreateTableSerializer(data=request.data)
serializer.is_valid(raise_exception=True)
table_name = serializer.validated_data['table_name']
fields = serializer.validated_data['fields']
# Create a dynamic model class
dynamic_model_attrs = {'__module__': __name__}
for field in fields:
field_name = field['name']
field_type = field['type']
max_length = field.get('max_length', 255)
if field_type in FIELD_TYPE_MAPPING:
field_class =
FIELD_TYPE_MAPPING[field_type](max_length=max_length)
else:
raise ValueError(f"Invalid field type: {field_type}")
dynamic_model_attrs[field_name] = field_class
dynamic_model = type(table_name, (models.Model,),
dynamic_model_attrs)
# Create the database table for the dynamic model
with connection.schema_editor() as schema_editor:
schema_editor.create_model(dynamic_model)
# Register the dynamic model with the app
apps.all_models['dynamic_tables_app'][table_name] = dynamic_model
return Response(f'Table "{table_name}" created successfully!')
On Mon, May 22, 2023 at 8:21 AM Helly Modi <hellymod...@gmail.com> wrote:
> This is my code and it worked in creating tables but here django provides
> 26 fields and many relation how can i include all ? If else become too
> complex .Is there any other way to do this
>
> On Mon, May 22, 2023 at 10:49 AM Helly Modi <hellymod...@gmail.com> wrote:
>
>> class CreateTableAPIView(APIView):
>> def post(self, request):
>> serializer = CreateTableSerializer(data=request.data)
>> serializer.is_valid(raise_exception=True)
>>
>> table_name = serializer.validated_data['table_name']
>> fields = serializer.validated_data['fields']
>>
>> # Create a dynamic model class
>> dynamic_model_attrs = {'__module__': __name__}
>> for field in fields:
>> field_name=field['name']
>> field_type=field['type']
>> max_length=field.get('max_length',255)
>>
>> if field_type=='char':
>> field_class=models.CharField(max_length=max_length)
>> elif field_type== 'integer':
>> field_class=models.IntegerField()
>> elif field_type=='boolean':
>> field_class=models.BooleanField()
>> else:
>> field_class=models.EmailField()
>> dynamic_model_attrs[field_name]=field_class
>>
>>
>> dynamic_model = type(table_name, (models.Model,),
>> dynamic_model_attrs)
>>
>> # Create the database table for the dynamic model
>> with connection.schema_editor() as schema_editor:
>> schema_editor.create_model(dynamic_model)
>>
>> # Register the dynamic model with the app
>> apps.all_models['dynamic_tables_app'][table_name] = dynamic_model
>>
>> return Response(f'Table "{table_name}" created successfully!')
>>
>>
>> On Fri, May 19, 2023 at 6:40 PM Brian Gitau <gitaubrian...@gmail.com>
>> wrote:
>>
>>> which code do you have or you want the code example explaining
>>> everything?
>>>
>>>
>>> On Fri, May 19, 2023 at 3:59 PM Helly Modi <hellymod...@gmail.com>
>>> wrote:
>>>
>>>> How to create dynamic models in django rest framework?
>>>>
>>>> Is there any chance to create dynamic models with APIs
>>>>
>>>>
>>>>
>>>> Any examples please send me thanks in advance..
>>>>
>>>>
>>>>
>>>> 1) Requirement is need create table name and fields in frontend
>>>>
>>>> 2) we are getting the data and store in to the db create db structure
>>>>
>>>> 3) get the table name and fields create table in backend &postgresql
>>>> store to
>>>>
>>>> 4)this code don't update or add into the models
>>>>
>>>> 5)store the data into the tables
>>>>
>>>> --
>>>> 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/72d09483-5129-43e1-bdbb-7b92969d97c4n%40googlegroups.com
>>>> <https://groups.google.com/d/msgid/django-users/72d09483-5129-43e1-bdbb-7b92969d97c4n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>> --
>>> 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/CAMJ3z%3D3Qn0n%2BHVefJg_B6R9RQABA88C4whqbn0g3ygo4k0gkMw%40mail.gmail.com
>>> <https://groups.google.com/d/msgid/django-users/CAMJ3z%3D3Qn0n%2BHVefJg_B6R9RQABA88C4whqbn0g3ygo4k0gkMw%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>> --
> 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/CAO-ToNUai69i86uMD6-Z%2BSZha9DpjHSSbNFBGcwpf19N4eEtnw%40mail.gmail.com
> <https://groups.google.com/d/msgid/django-users/CAO-ToNUai69i86uMD6-Z%2BSZha9DpjHSSbNFBGcwpf19N4eEtnw%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>
--
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/CAMJ3z%3D0LoJKsZfk_4XD0zmCQ2F_Jwc2_Ex9CE24L74Q4P%2BobTQ%40mail.gmail.com.
