From 85a1961b640e552b3abebae2462a1b425cd87f4f Mon Sep 17 00:00:00 2001 From: "t.me/xtekky" <98614666+xtekky@users.noreply.github.com> Date: Sat, 22 Apr 2023 14:08:19 +0100 Subject: sqlchat --- sqlchat/README.md | 42 +++++++++++++++ sqlchat/__init__.py | 117 +++++++++++++++++++++++++++++++++++++++++ testing/sqlchat_test.py | 7 +++ unfinished/sqlchat/README.md | 3 -- unfinished/sqlchat/__init__.py | 29 ---------- 5 files changed, 166 insertions(+), 32 deletions(-) create mode 100644 sqlchat/README.md create mode 100644 sqlchat/__init__.py create mode 100644 testing/sqlchat_test.py delete mode 100644 unfinished/sqlchat/README.md delete mode 100644 unfinished/sqlchat/__init__.py diff --git a/sqlchat/README.md b/sqlchat/README.md new file mode 100644 index 00000000..89d38fae --- /dev/null +++ b/sqlchat/README.md @@ -0,0 +1,42 @@ +### Example: `sqlchat` (use like openai pypi package) + +```python +# Import sqlchat +import sqlchat + +# sqlchat.Completion.create +# sqlchat.StreamCompletion.create + +[...] + +``` + +#### Example Chatbot +```python +messages = [] + +while True: + user = input('you: ') + + sqlchat_cmpl = sqlchat.Completion.create( + prompt = user, + messages = messages + ) + + print('gpt:', sqlchat_cmpl.completion.choices[0].text) + + messages.extend([ + {'role': 'user', 'content': user }, + {'role': 'assistant', 'content': sqlchat_cmpl.completion.choices[0].text} + ]) +``` + +#### Streaming Response: + +```python +for response in sqlchat.StreamCompletion.create( + prompt = 'write python code to reverse a string', + messages = []): + + print(response.completion.choices[0].text) +``` diff --git a/sqlchat/__init__.py b/sqlchat/__init__.py new file mode 100644 index 00000000..b55c0e46 --- /dev/null +++ b/sqlchat/__init__.py @@ -0,0 +1,117 @@ +from requests import post +from time import time + +headers = { + 'authority' : 'www.sqlchat.ai', + 'accept' : '*/*', + 'accept-language': 'en,fr-FR;q=0.9,fr;q=0.8,es-ES;q=0.7,es;q=0.6,en-US;q=0.5,am;q=0.4,de;q=0.3', + 'content-type' : 'text/plain;charset=UTF-8', + 'origin' : 'https://www.sqlchat.ai', + 'referer' : 'https://www.sqlchat.ai/', + 'sec-fetch-dest' : 'empty', + 'sec-fetch-mode' : 'cors', + 'sec-fetch-site' : 'same-origin', + 'user-agent' : 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36', +} + +class SqlchatResponse: + class Completion: + class Choices: + def __init__(self, choice: dict) -> None: + self.text = choice['text'] + self.content = self.text.encode() + self.index = choice['index'] + self.logprobs = choice['logprobs'] + self.finish_reason = choice['finish_reason'] + + def __repr__(self) -> str: + return f'''<__main__.APIResponse.Completion.Choices(\n text = {self.text.encode()},\n index = {self.index},\n logprobs = {self.logprobs},\n finish_reason = {self.finish_reason})object at 0x1337>''' + + def __init__(self, choices: dict) -> None: + self.choices = [self.Choices(choice) for choice in choices] + + class Usage: + def __init__(self, usage_dict: dict) -> None: + self.prompt_tokens = usage_dict['prompt_chars'] + self.completion_tokens = usage_dict['completion_chars'] + self.total_tokens = usage_dict['total_chars'] + + def __repr__(self): + return f'''<__main__.APIResponse.Usage(\n prompt_tokens = {self.prompt_tokens},\n completion_tokens = {self.completion_tokens},\n total_tokens = {self.total_tokens})object at 0x1337>''' + + def __init__(self, response_dict: dict) -> None: + + self.response_dict = response_dict + self.id = response_dict['id'] + self.object = response_dict['object'] + self.created = response_dict['created'] + self.model = response_dict['model'] + self.completion = self.Completion(response_dict['choices']) + self.usage = self.Usage(response_dict['usage']) + + def json(self) -> dict: + return self.response_dict + +class Completion: + def create( + prompt: str = 'hello world', + messages: list = []) -> SqlchatResponse: + + response = post('https://www.sqlchat.ai/api/chat', headers=headers, stream=True, + json = { + 'messages': messages, + 'openAIApiConfig':{'key':'','endpoint':''}}) + + return SqlchatResponse({ + 'id' : f'cmpl-1337-{int(time())}', + 'object' : 'text_completion', + 'created': int(time()), + 'model' : 'gpt-3.5-turbo', + 'choices': [{ + 'text' : response.text, + 'index' : 0, + 'logprobs' : None, + 'finish_reason' : 'stop' + }], + 'usage': { + 'prompt_chars' : len(prompt), + 'completion_chars' : len(response.text), + 'total_chars' : len(prompt) + len(response.text) + } + }) + +class StreamCompletion: + def create( + prompt : str = 'hello world', + messages: list = []) -> SqlchatResponse: + + messages.append({ + 'role':'user', + 'content':prompt + }) + + response = post('https://www.sqlchat.ai/api/chat', headers=headers, stream=True, + json = { + 'messages': messages, + 'openAIApiConfig':{'key':'','endpoint':''}}) + + for chunk in response.iter_content(chunk_size = 2046): + yield SqlchatResponse({ + 'id' : f'cmpl-1337-{int(time())}', + 'object' : 'text_completion', + 'created': int(time()), + 'model' : 'gpt-3.5-turbo', + + 'choices': [{ + 'text' : chunk.decode(), + 'index' : 0, + 'logprobs' : None, + 'finish_reason' : 'stop' + }], + + 'usage': { + 'prompt_chars' : len(prompt), + 'completion_chars' : len(chunk.decode()), + 'total_chars' : len(prompt) + len(chunk.decode()) + } + }) \ No newline at end of file diff --git a/testing/sqlchat_test.py b/testing/sqlchat_test.py new file mode 100644 index 00000000..28e9d2e3 --- /dev/null +++ b/testing/sqlchat_test.py @@ -0,0 +1,7 @@ +import sqlchat + +for response in sqlchat.StreamCompletion.create( + prompt = 'write python code to reverse a string', + messages = []): + + print(response.completion.choices[0].text, end='') \ No newline at end of file diff --git a/unfinished/sqlchat/README.md b/unfinished/sqlchat/README.md deleted file mode 100644 index ddd5c8f9..00000000 --- a/unfinished/sqlchat/README.md +++ /dev/null @@ -1,3 +0,0 @@ -https://www.sqlchat.ai/ -to do: -- code refractoring \ No newline at end of file diff --git a/unfinished/sqlchat/__init__.py b/unfinished/sqlchat/__init__.py deleted file mode 100644 index a7c2c54b..00000000 --- a/unfinished/sqlchat/__init__.py +++ /dev/null @@ -1,29 +0,0 @@ -import requests - -headers = { - 'authority': 'www.sqlchat.ai', - 'accept': '*/*', - 'accept-language': 'en,fr-FR;q=0.9,fr;q=0.8,es-ES;q=0.7,es;q=0.6,en-US;q=0.5,am;q=0.4,de;q=0.3', - 'content-type': 'text/plain;charset=UTF-8', - 'origin': 'https://www.sqlchat.ai', - 'referer': 'https://www.sqlchat.ai/', - 'sec-fetch-dest': 'empty', - 'sec-fetch-mode': 'cors', - 'sec-fetch-site': 'same-origin', - 'user-agent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36', -} - -data = { - 'messages':[ - {'role':'system','content':''}, - {'role':'user','content':'hello world'}, - ], - 'openAIApiConfig':{ - 'key':'', - 'endpoint':'' - } -} - -response = requests.post('https://www.sqlchat.ai/api/chat', headers=headers, json=data, stream=True) -for message in response.iter_content(chunk_size=1024): - print(message) \ No newline at end of file -- cgit v1.2.3