How to run the FastAPIQuickCRUD is NOT Clear

[pvssrikanth]

Dear Sir,
I have installed the FastAPIQuickCRUD and also generator.

BUT How to run and which path IS NOT clear in the README File.

Please guide

Also Where should the user setup the variable SQLALCHEMY

Please reply

Regards,

[LuisLuii]

umm, I think just follow the readme is ok. And the FastAPIQuickCRUD and fastapi-crud-project-generator are different project.
you can understand that the fastapi-crud-project-generator is the code gen version of FastAPIQuickCRUD.
free feel to let me know if you have any question, I will reply u ASAP

[LuisLuii]

For example in FastAPIQuickCRUD, you can install pip install SQLAlchemy and pip install fastapi-quickcrud, then run it directly by following code (use in-memory db) and

import uvicorn
from fastapi import FastAPI
from sqlalchemy import Column, Integer, \
    String, Table, ForeignKey, orm
from fastapi_quickcrud import crud_router_builder

Base = orm.declarative_base()


class User(Base):
    __tablename__ = 'test_users'
    id = Column(Integer, primary_key=True, autoincrement=True, unique=True)
    name = Column(String, nullable=False)
    email = Column(String, nullable=False)


friend = Table(
    'test_friend', Base.metadata,
    Column('id', ForeignKey('test_users.id', ondelete='CASCADE', onupdate='CASCADE'), nullable=False),
    Column('friend_name', String, nullable=False)
)

crud_route_1 = crud_router_builder(db_model=User,
                                   prefix="/user",
                                   tags=["User"],
                                   async_mode=True
                                   )
crud_route_2 = crud_router_builder(db_model=friend,
                                   prefix="/friend",
                                   tags=["friend"],
                                   async_mode=True
                                   )

app = FastAPI()
app.include_router(crud_route_1)
app.include_router(crud_route_2)
uvicorn.run(app, host="0.0.0.0", port=8000, debug=False)

Then try with going to localhost:8000/docs

[pvssrikanth]

Hi Sir, Thanks for the prompt response. I have a legacy Postgresql Table which has a few million records in it. I want to autogenerate models with your project FastAPIQuickCRUD will this project help,; if so kindly guide simple way Thanks in advance

…

On Mon, Nov 7, 2022 at 5:31 PM Luis ***@***.***> wrote: For example in FastAPIQuickCRUD, you can run it directly by following code (use in-memory db) and after pip install fastapi-quickcrud ` import uvicorn from fastapi import FastAPI from sqlalchemy import Column, Integer, String, Table, ForeignKey, orm from fastapi_quickcrud import crud_router_builder Base = orm.declarative_base() class User(Base): *tablename* = 'test_users' id = Column(Integer, primary_key=True, autoincrement=True, unique=True) name = Column(String, nullable=False) email = Column(String, nullable=False) friend = Table( 'test_friend', Base.metadata, Column('id', ForeignKey('test_users.id', ondelete='CASCADE', onupdate='CASCADE'), nullable=False), Column('friend_name', String, nullable=False) ) crud_route_1 = crud_router_builder(db_model=User, prefix="/user", tags=["User"], async_mode=True ) crud_route_2 = crud_router_builder(db_model=friend, prefix="/friend", tags=["friend"], async_mode=True ) app = FastAPI() app.include_router(crud_route_1) app.include_router(crud_route_2) uvicorn.run(app, host="0.0.0.0", port=8000, debug=False)` — Reply to this email directly, view it on GitHub <#29 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AEGAGU7SANH6SMZVV7X6AKLWHDVQXANCNFSM6AAAAAARZC3RSE> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[LuisLuii]

I see, seem u can run the above example normally, so u are trying to connect to your PostgreSQL DB

1. I would suggest you use sqlacodegen to generate SQLAlchemy models for your table / or write it by your self.
2. use the following example code and rewrite your Sqlalchemy model, database dns...

import uvicorn
from fastapi import FastAPI
from fastapi_quickcrud import CrudMethods as CrudRouter
from fastapi_quickcrud import crud_router_builder
from sqlalchemy import *
from sqlalchemy.dialects.postgresql import *
from sqlalchemy.orm import *

app = FastAPI()

Base = declarative_base()
metadata = Base.metadata

from sqlalchemy.ext.asyncio import create_async_engine, AsyncSession

engine = create_async_engine('postgresql+asyncpg://postgres:1234@127.0.0.1:5432/postgres', future=True, echo=True,
                             pool_use_lifo=True, pool_pre_ping=True, pool_recycle=7200)
async_session = sessionmaker(bind=engine, class_=AsyncSession)


async def get_transaction_session() -> AsyncSession:
    async with async_session() as session:
        async with session.begin():
            yield session


class TestUuidPrimarySync(Base):
    __tablename__ = 'test_uuid_primary_sync'
    __table_args__ = (
        PrimaryKeyConstraint('primary_key', name='test_uuid_primary_sync_pkey'),
        UniqueConstraint('primary_key', 'int4_value', 'float4_value',
                         name='test_uuid_primary_sync_primary_key_int4_value_float4_value_key')
    )

    primary_key = Column(UUID(as_uuid=True
                              ))
    bool_value = Column(Boolean, nullable=False, server_default=text('false'))
    float4_value = Column(Float(53), nullable=False)
    float8_value = Column(Float(53), nullable=False, server_default=text('10.10'))
    int2_value = Column(SmallInteger, nullable=False)
    int4_value = Column(Integer, nullable=False)
    char_value = Column(CHAR(10))
    date_value = Column(Date, server_default=text('now()'))
    int8_value = Column(BigInteger, server_default=text('99'))
    interval_value = Column(INTERVAL)
    json_value = Column(JSON)
    jsonb_value = Column(JSONB)
    numeric_value = Column(Numeric)
    text_value = Column(Text)
    time_value = Column(Time)
    timestamp_value = Column(DateTime)
    timestamptz_value = Column(DateTime(True))
    timetz_value = Column(Time(True))
    varchar_value = Column(String)
    array_value = Column(ARRAY(Integer()))
    array_str__value = Column(ARRAY(String()))



router_1 = crud_router_builder(db_session=get_transaction_session,
                               db_model=TestUuidPrimarySync,
                               prefix="/router_1",
                               async_mode=True,
                               crud_methods=CrudRouter.get_declarative_model_full_crud_method(),
                               exclude_columns=[],
                               tags=["test"]
                               )

[app.include_router(i) for i in [router_1]]
uvicorn.run(app, host="0.0.0.0", port=8000, debug=False)

4. then it should works

for the above example table creation sql statement is following

CREATE TABLE public.test_uuid_primary_sync (
	primary_key uuid NOT NULL,
	bool_value bool NOT NULL DEFAULT false,
	char_value bpchar(10) NULL,
	date_value date NULL DEFAULT now(),
	float4_value float8 NOT NULL,
	float8_value float8 NOT NULL DEFAULT 10.10,
	int2_value int2 NOT NULL,
	int4_value int4 NOT NULL,
	int8_value int8 NULL DEFAULT 99,
	interval_value interval NULL,
	json_value json NULL,
	jsonb_value jsonb NULL,
	numeric_value numeric NULL,
	text_value text NULL,
	time_value time NULL,
	timestamp_value timestamp NULL,
	timestamptz_value timestamptz NULL,
	timetz_value timetz NULL,
	varchar_value varchar NULL,
	array_value _int4 NULL,
	array_str__value _varchar NULL,
	CONSTRAINT test_uuid_primary_sync_pkey PRIMARY KEY (primary_key),
	CONSTRAINT test_uuid_primary_sync_primary_key_int4_value_float4_value_key UNIQUE (primary_key, int4_value, float4_value)
);

[LuisLuii]

This project can only provide u some CRUD API with some basic query (try the first example to connect to in-memory in this issue)

On the other head, if you want to add your own business logic into the api, I would like to suggest u try my another open source project, project generator with this example to connect your Postgresql DB.

[pvssrikanth]

Dear Sir, Thanks for the reply . I created models using sqlagen # coding: utf-8 from sqlalchemy import Column, DateTime, Index, Integer, Numeric, String, Table, UniqueConstraint, text from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() metadata = Base.metadata class TESTTABLE(Base): __tablename__ = 'Testtable' __table_args__ = ( UniqueConstraint('TXT_INSURER_CODE', 'TXT_TRANSACTION_ID', 'LOAD_MONTH', 'RECONCILE_FLAG'), ) id = Column(Integer, primary_key=True, server_default=text("nextval('\"HLT_CLAIM_2020_2021_GOVTs_id_seq\"'::regclass)")) .... ... I created these models in db.py file And then copied your refrence code changed the sqlalchemy to postgressql suitable and ran python main.py but getting following error server:/tmp/fastapi-crud-project-generator$ python main.py Traceback (most recent call last): File "main.py", line 3, in <module> from fastapi_quickcrud import CrudMethods as CrudRouter File "/tmp/testenv/lib/python3.8/site-packages/fastapi_quickcrud/__init__.py", line 1, in <module> from .misc.utils import sqlalchemy_to_pydantic File "/tmp/testenv/lib/python3.8/site-packages/fastapi_quickcrud/misc/utils.py", line 14, in <module> from .crud_model import RequestResponseModel, CRUDModel File "/tmp/testenv/lib/python3.8/site-packages/fastapi_quickcrud/misc/crud_model.py", line 13, in <module> class RequestResponseModel(BaseModel): File "pydantic/main.py", line 198, in pydantic.main.ModelMetaclass.__new__ File "pydantic/fields.py", line 506, in pydantic.fields.ModelField.infer File "pydantic/fields.py", line 436, in pydantic.fields.ModelField.__init__ File "pydantic/fields.py", line 557, in pydantic.fields.ModelField.prepare File "pydantic/fields.py", line 831, in pydantic.fields.ModelField.populate_validators File "pydantic/validators.py", line 765, in find_validators RuntimeError: no validator found for <class 'pydantic.main.ModelMetaclass'>, see `arbitrary_types_allowed` in Config Could you kindly guide What else changes i have to make . THIS IS REALLY VERY EXCITING PROJECT IF it works for me. Thanking you srikanth

…

On Mon, Nov 7, 2022 at 8:01 PM Luis ***@***.***> wrote: on the other head, if you want to add some business logic into the api, I would like to suggest u try my another open source project, project generator <https://github.com/LuisLuii/fastapi-crud-project-generator> with this example <https://github.com/LuisLuii/fastapi-crud-project-generator/blob/main/tutorial/generate_project_with_postgres_db_uuid_pk.py> — Reply to this email directly, view it on GitHub <#29 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AEGAGU42MYZIMOVTO7J6T5TWHEHCLANCNFSM6AAAAAARZC3RSE> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[LuisLuii]

Dear Sir,
Thanks for the reply .

I created models using sqlagen

coding: utf-8

from sqlalchemy import Column, DateTime, Index, Integer, Numeric, String,
Table, UniqueConstraint, text
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()
metadata = Base.metadata

class TESTTABLE(Base):
tablename = 'Testtable'
table_args = (
UniqueConstraint('TXT_INSURER_CODE', 'TXT_TRANSACTION_ID',
'LOAD_MONTH', 'RECONCILE_FLAG'),
)

id = Column(Integer, primary_key=True,

server_default=text("nextval('"HLT_CLAIM_2020_2021_GOVTs_id_seq"'::regclass)"))
....
...

I created these models in db.py file

And then copied your refrence code changed the sqlalchemy to
postgressql suitable and ran python main.py

but getting following error

server:/tmp/fastapi-crud-project-generator$ python main.py
Traceback (most recent call last):
File "main.py", line 3, in
from fastapi_quickcrud import CrudMethods as CrudRouter
File
"/tmp/testenv/lib/python3.8/site-packages/fastapi_quickcrud/init.py",
line 1, in
from .misc.utils import sqlalchemy_to_pydantic
File
"/tmp/testenv/lib/python3.8/site-packages/fastapi_quickcrud/misc/utils.py",
line 14, in
from .crud_model import RequestResponseModel, CRUDModel
File
"/tmp/testenv/lib/python3.8/site-packages/fastapi_quickcrud/misc/crud_model.py",
line 13, in
class RequestResponseModel(BaseModel):
File "pydantic/main.py", line 198, in pydantic.main.ModelMetaclass.new
File "pydantic/fields.py", line 506, in pydantic.fields.ModelField.infer
File "pydantic/fields.py", line 436, in
pydantic.fields.ModelField.init
File "pydantic/fields.py", line 557, in pydantic.fields.ModelField.prepare
File "pydantic/fields.py", line 831, in
pydantic.fields.ModelField.populate_validators
File "pydantic/validators.py", line 765, in find_validators
RuntimeError: no validator found for <class
'pydantic.main.ModelMetaclass'>, see arbitrary_types_allowed in Config

Could you kindly guide What else changes i have to make . THIS IS REALLY
VERY EXCITING PROJECT IF it works for me.

Thanking you
srikanth

On Mon, Nov 7, 2022 at 8:01 PM Luis @.***> wrote:

on the other head, if you want to add some business logic into the api, I
would like to suggest u try my another open source project, project
generator https://github.com/LuisLuii/fastapi-crud-project-generator
with this example
https://github.com/LuisLuii/fastapi-crud-project-generator/blob/main/tutorial/generate_project_with_postgres_db_uuid_pk.py

—
Reply to this email directly, view it on GitHub
#29 (comment),
or unsubscribe
https://github.com/notifications/unsubscribe-auth/AEGAGU42MYZIMOVTO7J6T5TWHEHCLANCNFSM6AAAAAARZC3RSE
.
You are receiving this because you authored the thread.Message ID:
@.***>

Seems your table has included a field that type did not have type validator. Could u share the Sqlalchemy schema for double check on my side?

[pvssrikanth]

DearSir engine = create_async_engine('postgresql+asyncpg:// ***@***.***:5432/iibtestdb', future=True, echo=True, pool_use_lifo=True, pool_pre_ping=True, pool_recycle=7200)

…

On Thu, Nov 17, 2022 at 4:17 PM Luis ***@***.***> wrote: Dear Sir, Thanks for the reply . I created models using sqlagen coding: utf-8 from sqlalchemy import Column, DateTime, Index, Integer, Numeric, String, Table, UniqueConstraint, text from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() metadata = Base.metadata class TESTTABLE(Base): *tablename* = 'Testtable' *table_args* = ( UniqueConstraint('TXT_INSURER_CODE', 'TXT_TRANSACTION_ID', 'LOAD_MONTH', 'RECONCILE_FLAG'), ) id = Column(Integer, primary_key=True, server_default=text("nextval('"HLT_CLAIM_2020_2021_GOVTs_id_seq"'::regclass)")) .... ... I created these models in db.py file And then copied your refrence code changed the sqlalchemy to postgressql suitable and ran python main.py but getting following error server:/tmp/fastapi-crud-project-generator$ python main.py Traceback (most recent call last): File "main.py", line 3, in from fastapi_quickcrud import CrudMethods as CrudRouter File "/tmp/testenv/lib/python3.8/site-packages/fastapi_quickcrud/*init*.py", line 1, in from .misc.utils import sqlalchemy_to_pydantic File "/tmp/testenv/lib/python3.8/site-packages/fastapi_quickcrud/misc/utils.py", line 14, in from .crud_model import RequestResponseModel, CRUDModel File "/tmp/testenv/lib/python3.8/site-packages/fastapi_quickcrud/misc/crud_model.py", line 13, in class RequestResponseModel(BaseModel): File "pydantic/main.py", line 198, in pydantic.main.ModelMetaclass.*new* File "pydantic/fields.py", line 506, in pydantic.fields.ModelField.infer File "pydantic/fields.py", line 436, in pydantic.fields.ModelField.*init* File "pydantic/fields.py", line 557, in pydantic.fields.ModelField.prepare File "pydantic/fields.py", line 831, in pydantic.fields.ModelField.populate_validators File "pydantic/validators.py", line 765, in find_validators RuntimeError: no validator found for <class 'pydantic.main.ModelMetaclass'>, see arbitrary_types_allowed in Config Could you kindly guide What else changes i have to make . THIS IS REALLY VERY EXCITING PROJECT IF it works for me. Thanking you srikanth On Mon, Nov 7, 2022 at 8:01 PM Luis *@*.***> wrote: on the other head, if you want to add some business logic into the api, I would like to suggest u try my another open source project, project generator https://github.com/LuisLuii/fastapi-crud-project-generator with this example https://github.com/LuisLuii/fastapi-crud-project-generator/blob/main/tutorial/generate_project_with_postgres_db_uuid_pk.py — Reply to this email directly, view it on GitHub #29 (comment) <#29 (comment)> , or unsubscribe https://github.com/notifications/unsubscribe-auth/AEGAGU42MYZIMOVTO7J6T5TWHEHCLANCNFSM6AAAAAARZC3RSE . You are receiving this because you authored the thread.Message ID: *@*.***> Seems your table has included a field that type did not have type validator. Could u share the Sqlalchemy schema for double on my side? — Reply to this email directly, view it on GitHub <#29 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AEGAGU76OXYIYY5O74BIXKTWIYEM5ANCNFSM6AAAAAARZC3RSE> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[LuisLuii]

sorry, I mean full code of this thing

class TESTTABLE(Base):
    __tablename__ = 'Testtable'
    __table_args__ = (
    )

[pvssrikanth]

Dear Sir, Please keep in confidential with you only KINDLY using sqlautogen redirected to db.py # coding: utf-8 from sqlalchemy import Column, DateTime, Index, Integer, Numeric, String, Table, UniqueConstraint, text from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() metadata = Base.metadata class HLTCLAIM20202021GOVT(Base): __tablename__ = 'HLT_CLAIM_2020_2021_GOVTs' __table_args__ = ( UniqueConstraint('TXT_INSURER_CODE', 'TXT_TRANSACTION_ID', 'LOAD_MONTH', 'RECONCILE_FLAG'), ) id = Column(Integer, primary_key=True, server_default=text("nextval('\"HLT_CLAIM_2020_2021_GOVTs_id_seq\"'::regclass)")) TXT_TPA_CODE = Column(String(10)) TXT_INSURER_CODE = Column(String(10)) TXT_POLICY_NUMBER = Column(String(128)) TXT_MEMBER_REFERENCE_KEY = Column(String(128)) EMPLOYEE_ID = Column(String(128)) DATE_OF_BIRTH = Column(DateTime(True)) NUM_AGE_OF_INSURED = Column(Integer) DATE_POLICY_START = Column(DateTime(True)) DATE_POLICY_END = Column(DateTime(True)) TXT_PRODUCT_TYPE = Column(String(128)) TXT_TYPE_OF_POLICY = Column(String(128)) BOO_FLOATER_APPLICABLE = Column(String(5)) TXT_GENDER = Column(String(10)) NUM_SUM_INSURED = Column(Numeric(30, 2)) TXT_CLAIM_NUMBER = Column(String(128)) TXT_DIAGNOSIS_CODE_LEVEL_I = Column(String(128)) TXT_PROCEDURE_CODE_LEVEL_I = Column(String(1000)) TXT_NAME_OF_THE_HOSPITAL = Column(String(8000)) TXT_REGISTRATION_NUMBER_OF_HOSPITAL = Column(String(128)) TXT_PAN_OF_HOSPITAL = Column(String(128)) TXT_PIN_CODE_OF_HOSPITAL = Column(String(20)) DATE_OF_ADMISSION = Column(DateTime(True)) DATE_OF_DISCHARGE = Column(DateTime(True)) NUM_TOTAL_AMOUNT_CLAIMED = Column(Numeric(30, 2)) NUM_ROOM_CHARGES_CLAIMED = Column(Numeric(30, 2)) NUM_NURSING_CHARGES_CLAIMED = Column(Numeric(30, 2)) NUM_SURGERY_CHARGES_CLAIMED = Column(Numeric(30, 2)) NUM_CONSULTATION_CHARGES_CLAIMED = Column(Numeric(30, 2)) NUM_DIAGONOSTIC_CHARGES_CLAIMED = Column(Numeric(30, 2)) NUM_MEDICINE_CHARGES_CLAIMED = Column(Numeric(30, 2)) NUM_MISCELLANEOUS_CHARGES_CLAIMED = Column(Numeric(30, 2)) NUM_PRE_HOSPITALISATION_EXPENSES_CLAIMED = Column(Numeric(30, 2)) NUM_POST_HOSPITALISATION_EXPENSES_CLAIMED = Column(Numeric(30, 2)) NUM_PROFESSIONAL_CHARGES_CLAIMED = Column(Numeric(30, 2)) NUM_OT_CHARGES_CLAIMED = Column(Numeric(30, 2)) NUM_SURGICAL_IMPLANT_CHARGES_CLAIMED = Column(Numeric(30, 2)) NUM_TOTAL_CLAIM_PAID = Column(Numeric(30, 2)) NUM_INDEMNITY_PAID = Column(Numeric(30, 2)) NUM_HOSPITAL_DAILY_CASH_BENEFIT_PAID = Column(Numeric(30, 2)) NUM_CRITICAL_ILLNESS_BENEFIT_PAID = Column(Numeric(30, 2)) NUM_SURGICAL_CASH_BENEFIT_PAID = Column(Numeric(30, 2)) NUM_CONVALESCENCE_BENEFIT_PAID = Column(Numeric(30, 2)) TXT_REASON_FOR_REJECTION_OF_CLAIM = Column(String(128)) TXT_CLAIM_REMARKS = Column(String(8000)) TXT_DIAGNOSIS_CODE_LEVEL_II = Column(String(128)) TXT_DIAGNOSIS_CODE_LEVEL_III = Column(String(128)) TXT_PROCEDURE_CODE_LEVEL_II = Column(String(128)) TXT_PROCEDURE_CODE_LEVEL_III = Column(String(128)) TXT_MEDICAL_HISTORY_LEVEL_I = Column(String(1000)) TXT_HOSPITAL_CODE = Column(String(128)) TXT_PROCEDURE_DESCRIPTION_LEVEL_I = Column(String(8000)) TXT_PROCEDURE_DESCRIPTION_LEVEL_II = Column(String(1000)) TXT_PROCEDURE_DESCRIPTION_LEVEL_III = Column(String(1000)) TXT_MEDICAL_HISTORY_LEVEL_II = Column(String(1000)) TXT_MEDICAL_HISTORY_LEVEL_III = Column(String(8000)) TXT_REASON_FOR_REDUCTION_OF_CLAIM = Column(String(1000)) TXT_TYPE_OF_CLAIM_PAYMENT = Column(String(128)) TXT_SYSTEM_OF_MEDICINE_USED = Column(String(128)) BOO_HOSPITAL_IS_NETWORK_PROVIDER = Column(String(5)) NUM_AMOUNT_OF_DEDUCTIBLE = Column(Numeric(30, 2)) NUM_PERCENTAGE_OF_COPAYMENT = Column(Numeric(20, 3)) NUM_AMOUNT_OF_COPAYMENT = Column(Numeric(30, 2)) DATE_OF_PAYMENT = Column(DateTime(True)) TXT_PAYMENT_REFERENCE_NUMBER = Column(String(128)) DATE_CLAIM_INTIMATION = Column(DateTime(True)) NUM_BONUS_SUM_INSURED = Column(Numeric(30, 2)) BOO_CLAIM_REOPENED_OR_NOT = Column(String(5)) TXT_CLAIM_STATUS = Column(String(10)) BOO_SURGICAL_OR_NON_SURGICAL_TREATMENT = Column(String(5)) BOO_OUT_PATIENT_OR_IN_PATIENT_TREATMENT = Column(String(5)) TXT_IRDA_PRODUCT_ID = Column(String(128)) TXT_CRITICAL_ILLNESS_DISEASE_CODE = Column(String(128)) NUM_OPENING_CLAIM_PROVISION = Column(Numeric(30, 2)) NUM_CLOSING_CLAIM_PROVISION = Column(Numeric(30, 2)) TXT_TRANSACTION_ID = Column(String(128)) DATE_TRANSACTION_ID = Column(DateTime(True)) TXT_REASON_FOR_HOSPITALISATION = Column(String(128)) TXT_TREATING_DOCTOR_REGISTRATION_NUMBER = Column(String(128)) TXT_TYPE_OF_ADMISSION = Column(String(128)) TXT_ROOM_CATEGORY_OCCUPIED = Column(String(128)) DATE_OF_RECEIPT_OF_COMPLETE_CLAIM_DOCUMENT = Column(DateTime(True)) TXT_PATIENT_ID = Column(String(128)) DATE_OF_COMMENCEMENT_OF_FIRST_INSURANCE_WITHOUT_BREAK = Column(DateTime(True)) LOAD_MONTH = Column(String(15)) FILE_NAME = Column(String(1000)) FINANCIAL_YEAR = Column(String(10)) RECONCILE_FLAG = Column(String(5), server_default=text("'0'::character varying")) createdBy = Column(String(128)) updatedBy = Column(String(128)) createdAt = Column(DateTime(True)) updatedAt = Column(DateTime(True)) dataCategory = Column(String(128), server_default=text("'govt'::character varying")) SIMILARLY OTHER class tables created sample below class HLTCLAIM20202021(Base): __tablename__ = 'HLT_CLAIM_2020_2021s' __table_args__ = ( UniqueConstraint('TXT_INSURER_CODE', 'TXT_TRANSACTION_ID', 'LOAD_MONTH', 'RECONCILE_FLAG'), ) id = Column(Integer, primary_key=True, server_default=text("nextval('\"HLT_CLAIM_2020_2021s_id_seq\"'::regclass)")) TXT_TPA_CODE = Column(String(10)) TXT_INSURER_CODE = Column(String(10)) TXT_POLICY_NUMBER = Column(String(128)) TXT_MEMBER_REFERENCE_KEY = Column(String(128)) EMPLOYEE_ID = Column(String(128)) DATE_OF_BIRTH = Column(DateTime(True)) NUM_AGE_OF_INSURED = Column(Integer) DATE_POLICY_START = Column(DateTime(True)) DATE_POLICY_END = Column(DateTime(True)) All i need is one table How to make it run as API with your excellent project ( READ/ WRITE /SINGLE/MULIPLTE/ SYNC / ASYNC ) One example if it works I WILL BE GREATEFUL to your help Thanking you

…

On Thu, Nov 17, 2022 at 4:58 PM Luis ***@***.***> wrote: sorry, I mean this thing of full code class TESTTABLE(Base): __tablename__ = 'Testtable' __table_args__ = ( UniqueConstraint('TXT_INSURER_CODE', 'TXT_TRANSACTION_ID', 'LOAD_MONTH', 'RECONCILE_FLAG'), ) id = Column(Integer, primary_key=True, server_default=text("nextval('\"HLT_CLAIM_2020_2021_GOVTs_id_seq\"'::regclass)")) — Reply to this email directly, view it on GitHub <#29 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AEGAGU7MGR3OX6NJSNORHBLWIYJEVANCNFSM6AAAAAARZC3RSE> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[pvssrikanth]

Dear Sir, Please keep code confidential KINDLY using sqlautogen redirected to db.py # coding: utf-8 from sqlalchemy import Column, DateTime, Index, Integer, Numeric, String, Table, UniqueConstraint, text from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() metadata = Base.metadata class HLTCLAIM20202021GOVT(Base): __tablename__ = 'HLT_CLAIM_2020_2021_GOVTs' __table_args__ = ( UniqueConstraint('TXT_INSURER_CODE', 'TXT_TRANSACTION_ID', 'LOAD_MONTH', 'RECONCILE_FLAG'), ) id = Column(Integer, primary_key=True, server_default=text("nextval('\"HLT_CLAIM_2020_2021_GOVTs_id_seq\"'::regclass)")) TXT_TPA_CODE = Column(String(10)) TXT_INSURER_CODE = Column(String(10)) TXT_POLICY_NUMBER = Column(String(128)) TXT_MEMBER_REFERENCE_KEY = Column(String(128)) EMPLOYEE_ID = Column(String(128)) DATE_OF_BIRTH = Column(DateTime(True)) NUM_AGE_OF_INSURED = Column(Integer) DATE_POLICY_START = Column(DateTime(True)) DATE_POLICY_END = Column(DateTime(True)) TXT_PRODUCT_TYPE = Column(String(128)) TXT_TYPE_OF_POLICY = Column(String(128)) BOO_FLOATER_APPLICABLE = Column(String(5)) TXT_GENDER = Column(String(10)) NUM_SUM_INSURED = Column(Numeric(30, 2)) TXT_CLAIM_NUMBER = Column(String(128)) TXT_DIAGNOSIS_CODE_LEVEL_I = Column(String(128)) TXT_PROCEDURE_CODE_LEVEL_I = Column(String(1000)) TXT_NAME_OF_THE_HOSPITAL = Column(String(8000)) TXT_REGISTRATION_NUMBER_OF_HOSPITAL = Column(String(128)) TXT_PAN_OF_HOSPITAL = Column(String(128)) TXT_PIN_CODE_OF_HOSPITAL = Column(String(20)) DATE_OF_ADMISSION = Column(DateTime(True)) DATE_OF_DISCHARGE = Column(DateTime(True)) NUM_TOTAL_AMOUNT_CLAIMED = Column(Numeric(30, 2)) NUM_ROOM_CHARGES_CLAIMED = Column(Numeric(30, 2)) NUM_NURSING_CHARGES_CLAIMED = Column(Numeric(30, 2)) NUM_SURGERY_CHARGES_CLAIMED = Column(Numeric(30, 2)) NUM_CONSULTATION_CHARGES_CLAIMED = Column(Numeric(30, 2)) NUM_DIAGONOSTIC_CHARGES_CLAIMED = Column(Numeric(30, 2)) NUM_MEDICINE_CHARGES_CLAIMED = Column(Numeric(30, 2)) NUM_MISCELLANEOUS_CHARGES_CLAIMED = Column(Numeric(30, 2)) NUM_PRE_HOSPITALISATION_EXPENSES_CLAIMED = Column(Numeric(30, 2)) NUM_POST_HOSPITALISATION_EXPENSES_CLAIMED = Column(Numeric(30, 2)) NUM_PROFESSIONAL_CHARGES_CLAIMED = Column(Numeric(30, 2)) NUM_OT_CHARGES_CLAIMED = Column(Numeric(30, 2)) NUM_SURGICAL_IMPLANT_CHARGES_CLAIMED = Column(Numeric(30, 2)) NUM_TOTAL_CLAIM_PAID = Column(Numeric(30, 2)) NUM_INDEMNITY_PAID = Column(Numeric(30, 2)) NUM_HOSPITAL_DAILY_CASH_BENEFIT_PAID = Column(Numeric(30, 2)) NUM_CRITICAL_ILLNESS_BENEFIT_PAID = Column(Numeric(30, 2)) NUM_SURGICAL_CASH_BENEFIT_PAID = Column(Numeric(30, 2)) NUM_CONVALESCENCE_BENEFIT_PAID = Column(Numeric(30, 2)) TXT_REASON_FOR_REJECTION_OF_CLAIM = Column(String(128)) TXT_CLAIM_REMARKS = Column(String(8000)) TXT_DIAGNOSIS_CODE_LEVEL_II = Column(String(128)) TXT_DIAGNOSIS_CODE_LEVEL_III = Column(String(128)) TXT_PROCEDURE_CODE_LEVEL_II = Column(String(128)) TXT_PROCEDURE_CODE_LEVEL_III = Column(String(128)) TXT_MEDICAL_HISTORY_LEVEL_I = Column(String(1000)) TXT_HOSPITAL_CODE = Column(String(128)) TXT_PROCEDURE_DESCRIPTION_LEVEL_I = Column(String(8000)) TXT_PROCEDURE_DESCRIPTION_LEVEL_II = Column(String(1000)) TXT_PROCEDURE_DESCRIPTION_LEVEL_III = Column(String(1000)) TXT_MEDICAL_HISTORY_LEVEL_II = Column(String(1000)) TXT_MEDICAL_HISTORY_LEVEL_III = Column(String(8000)) TXT_REASON_FOR_REDUCTION_OF_CLAIM = Column(String(1000)) TXT_TYPE_OF_CLAIM_PAYMENT = Column(String(128)) TXT_SYSTEM_OF_MEDICINE_USED = Column(String(128)) BOO_HOSPITAL_IS_NETWORK_PROVIDER = Column(String(5)) NUM_AMOUNT_OF_DEDUCTIBLE = Column(Numeric(30, 2)) NUM_PERCENTAGE_OF_COPAYMENT = Column(Numeric(20, 3)) NUM_AMOUNT_OF_COPAYMENT = Column(Numeric(30, 2)) DATE_OF_PAYMENT = Column(DateTime(True)) TXT_PAYMENT_REFERENCE_NUMBER = Column(String(128)) DATE_CLAIM_INTIMATION = Column(DateTime(True)) NUM_BONUS_SUM_INSURED = Column(Numeric(30, 2)) BOO_CLAIM_REOPENED_OR_NOT = Column(String(5)) TXT_CLAIM_STATUS = Column(String(10)) BOO_SURGICAL_OR_NON_SURGICAL_TREATMENT = Column(String(5)) BOO_OUT_PATIENT_OR_IN_PATIENT_TREATMENT = Column(String(5)) TXT_IRDA_PRODUCT_ID = Column(String(128)) TXT_CRITICAL_ILLNESS_DISEASE_CODE = Column(String(128)) NUM_OPENING_CLAIM_PROVISION = Column(Numeric(30, 2)) NUM_CLOSING_CLAIM_PROVISION = Column(Numeric(30, 2)) TXT_TRANSACTION_ID = Column(String(128)) DATE_TRANSACTION_ID = Column(DateTime(True)) TXT_REASON_FOR_HOSPITALISATION = Column(String(128)) TXT_TREATING_DOCTOR_REGISTRATION_NUMBER = Column(String(128)) TXT_TYPE_OF_ADMISSION = Column(String(128)) TXT_ROOM_CATEGORY_OCCUPIED = Column(String(128)) DATE_OF_RECEIPT_OF_COMPLETE_CLAIM_DOCUMENT = Column(DateTime(True)) TXT_PATIENT_ID = Column(String(128)) DATE_OF_COMMENCEMENT_OF_FIRST_INSURANCE_WITHOUT_BREAK = Column(DateTime(True)) LOAD_MONTH = Column(String(15)) FILE_NAME = Column(String(1000)) FINANCIAL_YEAR = Column(String(10)) RECONCILE_FLAG = Column(String(5), server_default=text("'0'::character varying")) createdBy = Column(String(128)) updatedBy = Column(String(128)) createdAt = Column(DateTime(True)) updatedAt = Column(DateTime(True)) dataCategory = Column(String(128), server_default=text("'govt'::character varying")) SIMILARLY OTHER class tables created sample below class HLTCLAIM20202021(Base): __tablename__ = 'HLT_CLAIM_2020_2021s' __table_args__ = ( UniqueConstraint('TXT_INSURER_CODE', 'TXT_TRANSACTION_ID', 'LOAD_MONTH', 'RECONCILE_FLAG'), ) id = Column(Integer, primary_key=True, server_default=text("nextval('\"HLT_CLAIM_2020_2021s_id_seq\"'::regclass)")) TXT_TPA_CODE = Column(String(10)) TXT_INSURER_CODE = Column(String(10)) TXT_POLICY_NUMBER = Column(String(128)) TXT_MEMBER_REFERENCE_KEY = Column(String(128)) EMPLOYEE_ID = Column(String(128)) DATE_OF_BIRTH = Column(DateTime(True)) NUM_AGE_OF_INSURED = Column(Integer) DATE_POLICY_START = Column(DateTime(True)) DATE_POLICY_END = Column(DateTime(True)) All i need is one table How to make it run as API with your excellent project ( READ/ WRITE /SINGLE/MULIPLTE/ SYNC / ASYNC ) One example if it works I WILL BE GREATEFUL to your help Thanking you

…

On Thu, Nov 17, 2022 at 4:58 PM Luis ***@***.***> wrote: sorry, I mean this thing of full code class TESTTABLE(Base): __tablename__ = 'Testtable' __table_args__ = ( UniqueConstraint('TXT_INSURER_CODE', 'TXT_TRANSACTION_ID', 'LOAD_MONTH', 'RECONCILE_FLAG'), ) id = Column(Integer, primary_key=True, server_default=text("nextval('\"HLT_CLAIM_2020_2021_GOVTs_id_seq\"'::regclass)")) — Reply to this email directly, view it on GitHub <#29 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AEGAGU7MGR3OX6NJSNORHBLWIYJEVANCNFSM6AAAAAARZC3RSE> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[LuisLuii]

Hello, I have tested the following code by your Sqlalchemy schema and it works fine

from fastapi import FastAPI
from sqlalchemy import *
from sqlalchemy.ext.asyncio import create_async_engine, AsyncSession
from sqlalchemy.orm import *

from fastapi_quickcrud.crud_router import crud_router_builder

Base = declarative_base()
metadata = Base.metadata

engine = create_async_engine('postgresql+asyncpg://postgres:1234@127.0.0.1:5432/postgres', future=True, echo=True,
                             pool_use_lifo=True, pool_pre_ping=True, pool_recycle=7200)
async_session = sessionmaker(bind=engine, class_=AsyncSession)


async def get_transaction_session() -> AsyncSession:
    async with async_session() as session:
        async with session.begin():
            yield session


class xxx(Base):
    __tablename__ = 'xxxx'
    __table_args__ = (
    )
xxxxx



crud_route_1 = crud_router_builder(db_session=get_transaction_session,
                                 db_model=xxxxx,
                                 prefix="/test_1",
                                 tags=["test_1"],
                                 async_mode=True
                                 )


app = FastAPI()
[app.include_router(i) for i in [crud_route_1]]


import uvicorn

uvicorn.run(app, host="0.0.0.0", port=8080)

[LuisLuii]

but I cannot make a api test since I don't have data of the table, I think It should works

[pvssrikanth]

O.k Sir, I will try this new code Thanks for your kind support to me. Regards,

…

On Thu, Nov 17, 2022 at 5:34 PM Luis ***@***.***> wrote: but I cannot make a api test since I have not data of the table, but I think It should works — Reply to this email directly, view it on GitHub <#29 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AEGAGUZHJLJ3YZREKY34DPLWIYNMPANCNFSM6AAAAAARZC3RSE> . You are receiving this because you authored the thread.Message ID: ***@***.***>