import asyncio
import asyncpg
from gino import Gino
# from api_server.models.url import Url
db = Gino()
# Initialize Queue
db_queue = asyncio.Queue()
async def listen_for_writes(app):
while True:
# wait for an item from the producer
link = await db_queue.get()
if link is None:
print(1)
# the producer emits None to indicate that it is done
break
# simulate i/o operation using sleep
# await asyncio.sleep(2)
# process the item
print(f"Received new URL: {link.original_url}")
await link.create()
import asyncio
import traceback
from gino import Gino
from sqlalchemy import ForeignKey
dbo = Gino()
class Server(dbo.Model):
__tablename__ = 'server'
guildid = dbo.Column(dbo.Integer(), primary_key=True) # pylint: disable=no-member
class User(dbo.Model):
__tablename__ = 'users'
id = dbo.Column(dbo.Integer(), primary_key=True) # pylint: disable=no-member
guild = dbo.Column(dbo.Integer(), None, ForeignKey('Server.guildid')) # pylint: disable=no-member
funds = dbo.Column(dbo.Integer()) # pylint: disable=no-member
class dbc:
async def add_guild(self, id):
queryRes = Server.query.where(Server.guildid == id)
#print(queryRes) #THIS BREAKS INITIALIZATION SOMEHOW!
if (queryRes == None):
await Server.create(guildid=id)
return True
else:
return False
