René's URL Explorer Experiment


Title: MySQL/linux case sensitive compatibility by fl0f · Pull Request #1 · fl0f/ODMToolsPython · GitHub

Open Graph Title: MySQL/linux case sensitive compatibility by fl0f · Pull Request #1 · fl0f/ODMToolsPython

X Title: MySQL/linux case sensitive compatibility by fl0f · Pull Request #1 · fl0f/ODMToolsPython

Description: Hi all, I use "LittleBear_ODM_1.1.1_MySQL.sql" example database with linux 64bit based platform. After executing this sql code, database was created and I could explore it (through phphmyadmin). Launching ODMTools, I give database coordinates and application tries to connect, unsuccessfully. Issue was about table names which were all lower case whereas ODMTools expected upper case like "DataValues" instead of "datavalues". So I changed all table names (except for "seriescatalog" which was still expected lower case). Then ODMTools opened successfully and I could explore all the data series. I then tried to make some edits (see also "Lasso widget disabled " issue). After saving edits, ODM could retrieve new variable (with Quality control level set to 1) in table "seriescatalog" but no data were shown on graph. In fact, these data had been written in a new table called "datavalues". This table has been created by ODMTools at the time I saved my edits. I could fix this issue by changing line 525 in file in odmtools/odmservices/series_service.py to : values.to_sql(name="DataValues", if_exists='append', con=self._session_factory.engine, index=False) ## FAP 160127 instead of : values.to_sql(name="datavalues", if_exists='append', con=self._session_factory.engine, index=False) Please find attached the file I modified in Pull request "MySQL/linux case sensitive compatibility" Best regards, Florent

Open Graph Description: Hi all, I use "LittleBear_ODM_1.1.1_MySQL.sql" example database with linux 64bit based platform. After executing this sql code, database was created and I could explore it (through phphmy...

X Description: Hi all, I use "LittleBear_ODM_1.1.1_MySQL.sql" example database with linux 64bit based platform. After executing this sql code, database was created and I could explore it (throug...

Opengraph URL: https://github.com/fl0f/ODMToolsPython/pull/1

X: @github

direct link

Domain: github.com

route-pattern/:user_id/:repository/pull/:id/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:c688791f-873c-081a-7296-bcec43b1402e
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-id9BA0:1C9D94:2E4C351:3C302B1:6A5CCDDA
html-safe-nonce5e9715e9de591e8e580ec91dca13ecf6715eb03c2ec0fd1cafeec1008f75c876
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5QkEwOjFDOUQ5NDoyRTRDMzUxOjNDMzAyQjE6NkE1Q0NEREEiLCJ2aXNpdG9yX2lkIjoiMTY2NTMyNjYxMzkzMTAxOTczOCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac6df807e13e8e8db3721f0f8a58ed4da4ae4430eee00ce0bde11ab50b2c2c1336
hovercard-subject-tagpull_request:57347235
github-keyboard-shortcutsrepository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///pull_requests/show/files
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/fl0f/ODMToolsPython/pull/1/files
twitter:imagehttps://avatars.githubusercontent.com/u/13980197?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/13980197?s=400&v=4
og:image:altHi all, I use "LittleBear_ODM_1.1.1_MySQL.sql" example database with linux 64bit based platform. After executing this sql code, database was created and I could explore it (through phphmy...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None5290d7e14309ad1e76106a9c4237bd1041517e83ea182c8ab756752cb0c6940b
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/fl0f/ODMToolsPython git https://github.com/fl0f/ODMToolsPython.git
octolytics-dimension-user_id13980197
octolytics-dimension-user_loginfl0f
octolytics-dimension-repository_id50502648
octolytics-dimension-repository_nwofl0f/ODMToolsPython
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forktrue
octolytics-dimension-repository_parent_id10625704
octolytics-dimension-repository_parent_nwoODM2/ODMToolsPython
octolytics-dimension-repository_network_root_id10625704
octolytics-dimension-repository_network_root_nwoODM2/ODMToolsPython
turbo-body-classeslogged-out env-production page-responsive
disable-turbotrue
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release9c975978430e9ad293956f2bbdaf153b1bd84a99
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/fl0f/ODMToolsPython/pull/1/files#start-of-content
https://github.com/
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ffl0f%2FODMToolsPython%2Fpull%2F1%2Ffiles
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub Copilot appDirect agents from issue to mergehttps://github.com/features/ai/github-app
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
View all resourceshttps://github.com/resources
GitHub SponsorsFund open source developershttps://github.com/open-source/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/open-source/accelerator
GitHub Starshttps://stars.github.com
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ffl0f%2FODMToolsPython%2Fpull%2F1%2Ffiles
Sign up https://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fpull_requests%2Fshow%2Ffiles&source=header-repo&source_repo=fl0f%2FODMToolsPython
Reloadhttps://github.com/fl0f/ODMToolsPython/pull/1/files
Reloadhttps://github.com/fl0f/ODMToolsPython/pull/1/files
Reloadhttps://github.com/fl0f/ODMToolsPython/pull/1/files
fl0f https://github.com/fl0f
ODMToolsPythonhttps://github.com/fl0f/ODMToolsPython
ODM2/ODMToolsPythonhttps://github.com/ODM2/ODMToolsPython
Notifications https://github.com/login?return_to=%2Ffl0f%2FODMToolsPython
Fork 0 https://github.com/login?return_to=%2Ffl0f%2FODMToolsPython
Star 0 https://github.com/login?return_to=%2Ffl0f%2FODMToolsPython
Code https://github.com/fl0f/ODMToolsPython
Pull requests 1 https://github.com/fl0f/ODMToolsPython/pulls
Actions https://github.com/fl0f/ODMToolsPython/actions
Projects https://github.com/fl0f/ODMToolsPython/projects
Wiki https://github.com/fl0f/ODMToolsPython/wiki
Security and quality 0 https://github.com/fl0f/ODMToolsPython/security
Insights https://github.com/fl0f/ODMToolsPython/pulse
Code https://github.com/fl0f/ODMToolsPython
Pull requests https://github.com/fl0f/ODMToolsPython/pulls
Actions https://github.com/fl0f/ODMToolsPython/actions
Projects https://github.com/fl0f/ODMToolsPython/projects
Wiki https://github.com/fl0f/ODMToolsPython/wiki
Security and quality https://github.com/fl0f/ODMToolsPython/security
Insights https://github.com/fl0f/ODMToolsPython/pulse
Sign up for GitHub https://github.com/signup?return_to=%2Ffl0f%2FODMToolsPython%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Ffl0f%2FODMToolsPython%2Fissues%2Fnew%2Fchoose
fl0fhttps://github.com/fl0f
masterhttps://github.com/fl0f/ODMToolsPython/tree/master
MySQL/linux-case-sensitive-compatibilityhttps://github.com/fl0f/ODMToolsPython/tree/MySQL/linux-case-sensitive-compatibility
Conversation 0 https://github.com/fl0f/ODMToolsPython/pull/1
Commits 1 https://github.com/fl0f/ODMToolsPython/pull/1/commits
Checks 0 https://github.com/fl0f/ODMToolsPython/pull/1/checks
Files changed https://github.com/fl0f/ODMToolsPython/pull/1/files
Please reload this pagehttps://github.com/fl0f/ODMToolsPython/pull/1/files
MySQL/linux case sensitive compatibility https://github.com/fl0f/ODMToolsPython/pull/1/files#top
Show all changes 1 commit https://github.com/fl0f/ODMToolsPython/pull/1/files
0c5fd68 MySQL/linux case sensitive compatibility fl0f Jan 27, 2016 https://github.com/fl0f/ODMToolsPython/pull/1/commits/0c5fd68053846ca64ec0170d32c58e719a210468
Clear filters https://github.com/fl0f/ODMToolsPython/pull/1/files
Please reload this pagehttps://github.com/fl0f/ODMToolsPython/pull/1/files
Please reload this pagehttps://github.com/fl0f/ODMToolsPython/pull/1/files
odmtools/odmservices/series_service.pyhttps://github.com/fl0f/ODMToolsPython/pull/1/files#diff-a839ed9534b2adedc8c9b29d382980e895724b3c4d2abde246b4ac552062532b
View file https://github.com/fl0f/ODMToolsPython/blob/0c5fd68053846ca64ec0170d32c58e719a210468/odmtools/odmservices/series_service.py
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/fl0f/ODMToolsPython/pull/1/{{ revealButtonHref }}
https://github.com/fl0f/ODMToolsPython/pull/1/files#diff-a839ed9534b2adedc8c9b29d382980e895724b3c4d2abde246b4ac552062532b
https://github.com/fl0f/ODMToolsPython/pull/1/files#diff-a839ed9534b2adedc8c9b29d382980e895724b3c4d2abde246b4ac552062532b
https://github.com/fl0f/ODMToolsPython/pull/1/files#diff-a839ed9534b2adedc8c9b29d382980e895724b3c4d2abde246b4ac552062532b
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width

URLs of crawlers that visited me.