def __new__(cls, *args, **kwargs):
if len(args) > 0:
query = session.query(Keyword).filter_by(value = args[0]).first()
if query != None:
return query
else:
return Base.__new__(cls, *args, **kwargs)
def __new__(cls, *args, **kwargs):
if len(args) > 0:
query = session.query(Keyword).filter_by(value=args[0]).first()
if query != None:
return query
else:
return Base.__new__(cls, *args, **kwargs)
)
iso_639_1 = Column(VARCHAR(50))
iso_639_2 = Column(VARCHAR(50))
iso_639_3 = Column(CHAR(4))
class PostalCodeModel(Base):
__tablename__ = 'postal_codes'
__table_args__ = (
PrimaryKeyConstraint("country_code", "postal_code", "admin_code1", "admin_code2", "admin_code3"),
)
country_code = Column(CHAR(2))
postal_code = Column(VARCHAR(20))
admin_code1 = Column(VARCHAR(20))
admin_code2 = Column(VARCHAR(20))
admin_code3 = Column(VARCHAR(20))
class TimezoneModel(Base):
__tablename__ = 'timezones'
timezone_id = Column(Integer, primary_key=True, nullable=False)
class UserTagModel(Base):
__tablename__ = 'usertags'
__table_args__ = (
PrimaryKeyConstraint("geoname_id", "tag"),
)
geoname_id = Column(Integer, ForeignKey("geoname.geoname_id"), nullable=False)
tag = Column(VARCHAR(100))
Base.prepare(engine)
def ofId(self, _id: int, _type: Base):
self._id = _id
self._ins = Base.byId(_id)
return self
# Установленные модули
import re
import telebot
import logging.config
# Модули, созданные в ходе разработки.
import api_connection
from constants import ConstantsToken, ConstantsAnswers, Genres, LoggerConfig
from database import Base
from keyboard import *
from errors import FilmNotFound
from formatters import *
bot = telebot.TeleBot(ConstantsToken.TEST_API_TOKEN)
db = Base()
logging.config.dictConfig(LoggerConfig.dictLogConfig)
logger = logging.getLogger("console_logger")
@bot.message_handler(commands=["start"])
def show_start_message(message):
bot.send_message(message.chat.id,
ConstantsAnswers.GREETING_MSG,
reply_markup=create_main_markup())
@bot.message_handler(
content_types=["text"],
func=lambda message: message.text == Commands.SEARCH_FILM_COMMAND)
def search_movie_command(message):
'manzana_geom_6362_json': func.ST_AsGeoJSON(
func.ST_Transform(self.manzana_geom_6362)),
'manzana_geom_4326_json': func.ST_AsGeoJSON(
func.ST_Transform(self.manzana_geom_4326))
}
return data
## tabla dim_municipio
class DimMunicipio(Base):
__tablename__ = "dim_municipio"
__table_args__ = {'extend_existing': True}
municipio_geom_6362 = Column(
Geometry(geometry_type='MULTIPOLYGON',srid = 6362), nullable = True)
municipio_geom_4326 = Column(
Geometry(geometry_type='MULTIPOLYGON',srid = 4326), nullable = True)
municipio_geom_6362_json = column_property(
func.ST_AsGeoJSON(func.ST_Transform(municipio_geom_6362, 6362)))
municipio_geom_4326_json = column_property(
func.ST_AsGeoJSON(func.ST_Transform(municipio_geom_4326, 4326)))
def to_dict(self):
data = {
'municipio_geom_6362_json': func.ST_AsGeoJSON(
func.ST_Transform(self.municipio_geom_6362)),
'municipio_geom_4326_json': func.ST_AsGeoJSON(
func.ST_Transform(self.municipio_geom_4326))
}
return data
Base.prepare(engine, reflect = True)