API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 6th, 2018
190
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.74 KB | None | 0 0
raw download clone embed print report
  1. app name mvpBottle
  2. https://mvpbottle.azurewebsites.net
  3.  
  4.  
  5.  
  6.  
  7. resource grp mvpResourceGroup
  8. appservice plan mvpPyServicePlan
  9. mvpDb
  10.  
  11. https://docs.microsoft.com/en-us/azure/app-service/app-service-web-tutorial-python-postgresql
  12. POSTGRES
  13. mvpdb
  14. database worknearnetwork
  15. admin user: ragnarob, Vinter18
  16. user: manager, Vinter18
  17.  
  18. az postgres server firewall-rule create --resource-group mvpResourceGroup --server-name mvpdb --start-ip-address 0.0.0.0 --end-ip-address 0.0.0.0 --name AllowAzureIPs
  19.  
  20. psql -h mvpdb.postgres.database.azure.com -U ragnarob@mvpdb postgres
  21.  
  22. venv/scripts/activate.bat
  23.  
  24. set FLASK_APP=app.py; set DBHOST=localhost; set DBUSER=manager; set DBNAME=worknearnetwork; set DBPASS=Vinter18
  25.  
  26. set FLASK_APP=app.py
  27. set DBHOST=flaskdb2.postgres.database.azure.com
  28. set DBUSER=manager
  29. set DBNAME=worknearnetwork
  30. set DBPASS=Vinter18
  31. flask db upgrade
  32.  
  33. set FLASK_APP=app.py
  34. set DBHOST=localhost
  35. set DBUSER=manager
  36. set DBNAME=worknearnetwork
  37. set DBPASS=Vinter18
  38. flask db upgrade
  39.  
  40. set FLASK_APP=app.py
  41. DBHOST=localhost
  42. DBUSER=manager
  43. DBNAME=worknearnetwork
  44. DBPASS=Vinter18
  45. flask run
  46.  
  47. FLASK_APP="app.py" DBHOST="localhost" DBUSER="manager" DBNAME="worknearnetwork" DBPASS="Vinter18"
  48.  
  49.  
  50. postgres local port 5432 eller 52375??
  51.  
  52.  
  53. CREATE DATABASE worknearnetwork;
  54. CREATE USER manager WITH PASSWORD 'Vinter18';
  55. GRANT ALL PRIVILEGES ON DATABASE worknearnetwork TO manager;
  56. ============================================================================================================================================
  57. app name mvpFlaskApp
  58.  
  59. az webapp create --resource-group mvpResourceGroup --plan mvpPyServicePlan --name mvpFlaskApp --runtime "python|3.4" --deployment-local-git
  60. https://ragnarob@mvpflaskapp.scm.azurewebsites.net/mvpFlaskApp.git
  61.  
  62. psql -h <postgresql_name>.postgres.database.azure.com -U <admin_username>@<postgresql_name> postgres
  63.  
  64. packageinfo=$(curl -u ragnarob https://mvpFlaskApp.scm.azurewebsites.net/api/extensionfeed/python362x86)
  65. curl -X PUT -u ragnarob -H "Content-Type: application/json" -d '$packageinfo' https://mvpFlaskApp.scm.azurewebsites.net/api/siteextensions/python362x86
  66.  
  67.  
  68. az webapp config appsettings set --name mvpFlaskApp --resource-group mvpResourceGroup --settings DBHOST="mvpdb.postgres.database.azure.com" DBUSER="manager@mvpdb" DBPASS="Vinter18" DBNAME="worknearnetwork"
  69. git remote add azure https://ragnarob@mvpflaskapp.scm.azurewebsites.net/mvpFlaskApp.git
  70.  
  71.  
  72. az webapp config appsettings set --name <app_name> --resource-group myResourceGroup --settings DBHOST="<postgresql_name>.postgres.database.azure.com" DBUSER="manager@<postgresql_name>" DBPASS="supersecretpass" DBNAME="eventregistration"
  73.  
  74.  
  75. todo remove the line:
  76. <customErrors mode="Off"></customErrors>
  77. from /site/wwwroot/web.config
  78.  
  79. ERROR python visual studio > mvpFlaskApp > Files > httpplatform-stdout-....
  80. GRANT PRIVILEGES på tables!
  81. GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO manager;
  82.  
  83.  
  84.  
  85.  
  86. STORAGE
  87. account resource id /subscriptions/dadcaa5d-dd84-4e8f-b5fd-7c037b5ed683/resourceGroups/cloud-shell-storage-westeurope/providers/Microsoft.Storage/storageAccounts/csbdadcaa5ddd84x4e8fxb5f
  88. blob service resource id /subscriptions/dadcaa5d-dd84-4e8f-b5fd-7c037b5ed683/resourceGroups/cloud-shell-storage-westeurope/providers/Microsoft.Storage/storageAccounts/csbdadcaa5ddd84x4e8fxb5f/blobServices/default
  89.  
  90.  
  91.  
  92. todo enum jobbstatus, null
  93. todo token for mapbox
  94.  
  95. todo test!!!!
  96. todo stylesheet...
  97.  
  98.  
  99. vv
  100. vf
  101.  
  102. todo more minerals npm
  103. todo sikker file upload
  104. todo db null values
  105. todo sikre input til db lol
  106.  
  107.  
  108.  
  109. ========================================= db take 2 ======================
  110. psql -h flaskdb2.postgres.database.azure.com -U manager@flaskdb2 postgres
  111.  
  112. az postgres server create --resource-group mvpResourceGroup --name flaskdb2 --location "North Europe" --admin-user ragnarob --admin-password Vinter18 --sku-name GP_Gen4_2
  113. flaskdb2.postgres.database.azure.com
  114. az postgres server firewall-rule create --resoucre-group mvpResourceGroup --server-name flaskdb2 --start-ip-address 0.0.0.0 --end-ip-address 255.255.255.255 --name AllowAllIPs
  115. psql -h flaskdb2.postgres.database.azure.com -U ragnarob@flaskdb2 postgres
  116. CREATE DATABASE worknearnetwork;
  117. CREATE USER manager WITH PASSWORD 'Vinter18';
  118. GRANT ALL PRIVILEGES ON DATABASE worknearnetwork TO manager;
  119.  
  120. FLASK_APP=app.py DBHOST="flaskdb2.postgres.database.azure.com" DBUSER="manager@flaskdb2" DBNAME="worknearnetwork" DBPASS="Vinter18" flask db upgrade
  121. FLASK_APP=app.py DBHOST="flaskdb2.postgres.database.azure.com" DBUSER="manager@flaskdb2" DBNAME="worknearnetwork" DBPASS="Vinter18" flask run
  122.  
  123. set FLASK_APP=app.py
  124. set DBHOST=flaskdb2.postgres.database.azure.com
  125. set DBUSER=manager@flaskdb2
  126. set DBNAME=worknearnetwork
  127. set DBPASS=Vinter18
  128. flask db upgrade
  129.  
  130. set FLASK_APP=app.py
  131. set DBHOST=localhost
  132. set DBUSER=manager
  133. set DBNAME=worknearnetwork
  134. set DBPASS=Vinter18
  135. flask db upgrade
  136.  
  137.  
  138. az webapp config appsettings set --name mvpFlaskApp --resource-group mvpResourceGroup --settings DBHOST="flaskdb2.postgres.database.azure.com" DBUSER="manager@flaskdb2" DBPASS="Vinter18" DBNAME="worknearnetwork"
  139.  
  140.  
  141.  
  142.  
  143. =====================================================================================================================================================================
  144. =====================================================================================================================================================================
  145. CREATE TABLE public.surveyreplybusiness
  146. (
  147. kabel text COLLATE pg_catalog."default",
  148. sluttdato date NOT NULL,
  149. telefon text COLLATE pg_catalog."default" NOT NULL,
  150. epost text COLLATE pg_catalog."default" NOT NULL,
  151. byggherre text COLLATE pg_catalog."default",
  152. byggherrekontaktperson text COLLATE pg_catalog."default",
  153. byggherretelefon text COLLATE pg_catalog."default",
  154. prosjektleder text COLLATE pg_catalog."default",
  155. prosjektledertelefon text COLLATE pg_catalog."default",
  156. typearbeid text COLLATE pg_catalog."default" NOT NULL,
  157. startdato date NOT NULL,
  158. id integer NOT NULL DEFAULT nextval('surveyreply_id_seq'::regclass),
  159. navn text COLLATE pg_catalog."default" NOT NULL,
  160. kraftlinje text COLLATE pg_catalog."default",
  161. utstyr text COLLATE pg_catalog."default",
  162. kommune text COLLATE pg_catalog."default" NOT NULL,
  163. adresse text COLLATE pg_catalog."default" NOT NULL,
  164. plassnr text COLLATE pg_catalog."default" NOT NULL,
  165. latitude double precision NOT NULL,
  166. longitude double precision NOT NULL,
  167. hoyde double precision NOT NULL,
  168. assistanse boolean NOT NULL,
  169. utkobling boolean NOT NULL,
  170. ekstrabeskrivelse text COLLATE pg_catalog."default",
  171. hasattachedfile boolean NOT NULL,
  172. submitteddate timestamp without time zone NOT NULL,
  173. jobbstatus jobbstatus,
  174. kommentar text COLLATE pg_catalog."default",
  175. kontaktperson text COLLATE pg_catalog."default"
  176. )
  177. WITH (
  178. OIDS = FALSE
  179. )
  180. TABLESPACE pg_default;
  181.  
  182. ALTER TABLE public.surveyreplybusiness
  183. OWNER to postgres;
  184. =====================================================================================================================================================================
  185. =====================================================================================================================================================================
  186. =====================================================================================================================================================================
  187. =====================================================================================================================================================================
  188. CREATE TABLE public.surveyreplyprivate
  189. (
  190. sluttdato date NOT NULL,
  191. telefon text COLLATE pg_catalog."default" NOT NULL,
  192. epost text COLLATE pg_catalog."default" NOT NULL,
  193. typearbeid text COLLATE pg_catalog."default" NOT NULL,
  194. startdato date NOT NULL,
  195. id bigint NOT NULL DEFAULT nextval('surveyreplyprivate_id_seq'::regclass),
  196. navn text COLLATE pg_catalog."default" NOT NULL,
  197. kommune text COLLATE pg_catalog."default" NOT NULL,
  198. adresse text COLLATE pg_catalog."default" NOT NULL,
  199. plassnr text COLLATE pg_catalog."default" NOT NULL,
  200. latitude double precision NOT NULL,
  201. longitude double precision NOT NULL,
  202. hoyde double precision NOT NULL,
  203. assistanse boolean NOT NULL,
  204. utkobling boolean NOT NULL,
  205. ekstrabeskrivelse text COLLATE pg_catalog."default",
  206. hasattachedfile boolean NOT NULL,
  207. submitteddate timestamp without time zone NOT NULL,
  208. jobbstatus jobbstatus,
  209. kommentar text COLLATE pg_catalog."default",
  210. CONSTRAINT surveyreplyprivate_pkey PRIMARY KEY (id)
  211. )
  212. WITH (
  213. OIDS = FALSE
  214. )
  215. TABLESPACE pg_default;
  216.  
  217. ALTER TABLE public.surveyreplyprivate
  218. OWNER to postgres;
  219.  
  220. =====================================================================================================================================================================
  221. =====================================================================================================================================================================
  222. =====================================================================================================================================================================
  223. CREATE TYPE public.jobbstatus AS ENUM
  224. ('ny', 'under arbeid', 'mottatt', 'arkivert');
  225.  
  226. ALTER TYPE public.jobbstatus
  227. OWNER TO postgres;
  228. =====================================================================================================================================================================
  229. =====================================================================================================================================================================
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!