|
Ma’lumotlar bazasini shakillantirish
|
| bet | 6/10 | | Sana | 14.12.2023 | | Hajmi | 1,57 Mb. | | #118407 |
Bog'liq Individual loyiha 6-amaliy topshiriqPedogilka, kompyuter tarmoq 1, 4-topshiriq2.2. Ma’lumotlar bazasini shakillantirish.
TELEGRAM botimizning ma’lumotlar bazasini shakllantirish uchun bir nechta modellar yozib chiqamiz. Bu bizga foydalanuvchilar ma’lumotlarini saqlashga va turli xil kitoblar, kitobning unitlari, foydalanuvchilar kiritgan lug’atlarni bazaga saqlashga yordam beradi.
from django.db import models
class Service(models.Model):
name_uz=models.CharField(verbose_name='Service Name uz', max_length=1000, null=True)
name_ru = models.CharField(verbose_name='Service Nameru', max_length=1000, null=True)
price_image = models.CharField(verbose_name='Price image file id', max_length=1000, null=True)
order_id = models.IntegerField(verbose_name='Order', default=0)
def __str__(self):
return f"{self.name_uz}"
class Meta:
verbose_name = "Service"
verbose_name_plural = "Services"
class User(models.Model):
name = models.CharField(verbose_name='Name', max_length=100)
fullname = models.CharField(verbose_name='Surname', max_length=100, null=True, blank=True)
phone = models.CharField(verbose_name='Phone Number', max_length=100, null=True, blank=True)
username = models.CharField(verbose_name='Username', max_length=100, null=True, blank=True)
telegram_id = models.BigIntegerField(verbose_name='Telegram ID', unique=True)
lang = models.CharField(verbose_name='Bot lang', choices=[['uz', "O‘zbek"], ['ru', "Russian"]], max_length=20,
null=True, blank=True)
admin = models.BooleanField(verbose_name='Admin', default=False)
first_time = models.DateTimeField(verbose_name='Start time', null=True, blank=True)
use_time = models.DateTimeField(verbose_name='Use time', null=True, blank=True)
def __str__(self):
return f"{self.name} {self.fullname}"
class Meta:
verbose_name = "User"
verbose_name_plural = "Users"
class User2(models.Model):
name = models.CharField(verbose_name='Name', max_length=100)
fullname = models.CharField(verbose_name='FullName', max_length=100, null=True, blank=True)
phone = models.CharField(verbose_name='Phone Number', max_length=100, null=True, blank=True)
username = models.CharField(verbose_name='Username', max_length=100, null=True, blank=True)
telegram_id = models.BigIntegerField(verbose_name='Telegram ID', unique=True)
lang = models.CharField(verbose_name='Bot lang', choices=[['uz', "O‘zbek"], ['ru', "Russian"]], max_length=20,
null=True, blank=True)
admin = models.BooleanField(verbose_name='Admin', default=False)
first_time = models.DateTimeField(verbose_name='Start time', null=True, blank=True)
use_time = models.DateTimeField(verbose_name='Use time', null=True, blank=True)
def __str__(self):
return f"{self.name} {self.fullname}"
class Meta:
verbose_name = "User2"
verbose_name_plural = "Users2"
class Keyboard(models.Model):
lang = models.CharField(verbose_name='Keyboard lang', choices=[['uz', "O‘zbek"], ['ru', 'Russian']], max_length=20)
name = models.CharField(verbose_name='Keyboard name', max_length=1000)
def __str__(self):
return f"{self.name}"
class Meta:
verbose_name = "Keyboard"
verbose_name_plural = "Keyboards"
class Info(models.Model):
title = models.ForeignKey(Keyboard, verbose_name='Title', on_delete=models.CASCADE, related_name='info‘, null=True)
text = models.TextField(verbose_name='Text', default=None)
def __str__(self):
return f"{self.title}"
class Meta:
verbose_name = "Text"
verbose_name_plural = "Texts"
|
| |
